Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- feed 1: <input type="text" value="http://rss.news.yahoo.com/rss/topstories"> **the default feed for everyone, but they can change it**
- feed 2: <input type="text" value="http://content.usatoday.com">
- feed 3: <input type="text" value="http://newsrss.bbc.co.uk/rss/newsonl.../world/rss.xml">
- feed 4: <input type="text" value="">
- feed 5: <input type="text" value="">
- feed 6: <input type="text" value="">
- feed 7: <input type="text" value="">
- feed 8: <input type="text" value="">
- feed 9: <input type="text" value="">
- <input type="submit" value="update">
- CREATE TABLE users (
- user_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
- first_name VARCHAR(20) NOT NULL,
- last_name VARCHAR(40) NOT NULL,
- state CHAR(2) NOT NULL,
- email VARCHAR(60) NOT NULL,
- pass CHAR(32) NOT NULL,
- registration_date DATETIME NOT NULL,
- PRIMARY KEY(user_id),
- UNIQUE (email),
- INDEX login (email, pass),
- INDEX state (state)
- );
- CREATE TABLE feeds (
- user_id SMALLINT UNSIGNED NOT NULL,
- feed_url VARCHAR(255) NOT NULL DEFAULT 'http://rss.news.yahoo.com/rss/topstories',
- feed_id SMALLINT UNSIGNED NOT NULL DEFAULT 1,
- PRIMARY KEY(user_id, feed_url)
- );
Add Comment
Please, Sign In to add comment