From b376d197b51f2e67c314e23b8ac484dc2ae8f4a5 Mon Sep 17 00:00:00 2001 From: Adam Mathes Date: Sun, 22 Apr 2018 16:31:19 -0700 Subject: wip single category on feed --- init.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'init.sql') 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) ); - -- cgit v1.2.3