aboutsummaryrefslogtreecommitdiffstats
path: root/init.sql
diff options
context:
space:
mode:
authorAdam Mathes <adam@trenchant.org>2018-04-22 16:31:19 -0700
committerAdam Mathes <adam@trenchant.org>2018-04-22 16:31:19 -0700
commitb376d197b51f2e67c314e23b8ac484dc2ae8f4a5 (patch)
tree9699832c43969531d6a3576b31f3e6d002e5ede4 /init.sql
parentcd1509967d7dafbf2d1a051206e368bd3aa5e179 (diff)
downloadneko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.tar.gz
neko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.tar.bz2
neko-b376d197b51f2e67c314e23b8ac484dc2ae8f4a5.zip
wip single category on feed
Diffstat (limited to 'init.sql')
-rw-r--r--init.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/init.sql b/init.sql
index 51938ee..05fc263 100644
--- a/init.sql
+++ b/init.sql
@@ -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)
);
-