From df25a48abd69292af55f3356a48a737da829cd20 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Wed, 7 Nov 2012 01:27:36 +0100
Subject: Add basic news feature: list, show, add

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

(limited to 'schema.sql')

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

