diff options
| -rw-r--r-- | init.sql | 11 |
1 files changed, 7 insertions, 4 deletions
@@ -1,8 +1,11 @@ +SET NAMES 'utf8'; +SET CHARACTER SET utf8; + CREATE TABLE feed ( id INT NOT NULL AUTO_INCREMENT, - url VARCHAR(100) NOT NULL, - web_url VARCHAR(100) NOT NULL DEFAULT "", - title VARCHAR(100) NOT NULL DEFAULT "", + url VARCHAR(255) NOT NULL, + web_url VARCHAR(255) NOT NULL DEFAULT "", + title VARCHAR(255) NOT NULL DEFAULT "", last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY (url), PRIMARY KEY (id) @@ -12,7 +15,7 @@ CREATE TABLE item ( id INT NOT NULL AUTO_INCREMENT, feed_id INT NOT NULL, title TEXT, - url VARCHAR(100) NOT NULL, + url VARCHAR(255) NOT NULL, description TEXT, publish_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, read_state BOOLEAN DEFAULT FALSE NOT NULL, |