diff options
author | Adam Mathes <adam@trenchant.org> | 2018-04-22 16:31:19 -0700 |
---|---|---|
committer | Adam Mathes <adam@trenchant.org> | 2018-04-22 16:31:19 -0700 |
commit | b376d197b51f2e67c314e23b8ac484dc2ae8f4a5 (patch) | |
tree | 9699832c43969531d6a3576b31f3e6d002e5ede4 /init.sql | |
parent | cd1509967d7dafbf2d1a051206e368bd3aa5e179 (diff) | |
download | neko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.tar.gz neko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.tar.bz2 neko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.zip |
wip single category on feed
Diffstat (limited to 'init.sql')
-rw-r--r-- | init.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -6,6 +6,7 @@ CREATE TABLE feed ( url VARCHAR(255) NOT NULL, web_url VARCHAR(255) NOT NULL DEFAULT "", title VARCHAR(255) NOT NULL DEFAULT "", + category VARCHAR(255) NOT NULL DEFAULT "", last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY (url), PRIMARY KEY (id) @@ -27,4 +28,3 @@ CREATE TABLE item ( INDEX (publish_date), PRIMARY KEY (id) ); - |