summaryrefslogtreecommitdiff
path: root/sql/sqlite3.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/sqlite3.sql')
-rw-r--r--sql/sqlite3.sql8
1 files changed, 8 insertions, 0 deletions
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 )
+);