From 1225be7b79ed98873a51729635e4b18f622da3da Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Wed, 7 Nov 2012 17:37:06 +0100
Subject: Add comments feature: show list, add

---
 schema.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 2119322..43e4822 100644
--- a/schema.sql
+++ b/schema.sql
@@ -14,3 +14,14 @@ create table news (
     user_id integer,
     FOREIGN KEY(user_id) REFERENCES users(id)
 );
+
+drop table if exists comments;
+create table comments (
+    id integer primary key autoincrement,
+    date string default (strftime('%Y-%m-%dT%H:%M:%S','now')),
+    content string not null,
+    user_id integer,
+    news_id integer,
+    FOREIGN KEY(user_id) REFERENCES users(id),
+    FOREIGN KEY(news_id) REFERENCES news(id)
+);
-- 
cgit v1.2.3-70-g09d2

