From b376d197b51f2e67c314e23b8ac484dc2ae8f4a5 Mon Sep 17 00:00:00 2001
From: Adam Mathes <adam@trenchant.org>
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

