Add basic news feature: list, show, add

1 files changed, 10 insertions, 0 deletions

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)
+);