From a07e48f45e3b922a63aaae58b5bd816b8e324ee1 Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Sun, 3 May 2015 21:14:36 +0200 Subject: started to add pages --- sql/sqlite3.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'sql/sqlite3.sql') diff --git a/sql/sqlite3.sql b/sql/sqlite3.sql index 97ffcea..ff22476 100644 --- a/sql/sqlite3.sql +++ b/sql/sqlite3.sql @@ -31,3 +31,11 @@ create table login( user_id integer references user(id), last_login timestamp ); + +create table page( + id integer primary key autoincrement not null, + slug varchar(32) not null, + title varchar(32) not null, + content text, + unique( slug ) +); -- cgit v1.2.3-54-g00ecf