From a07e48f45e3b922a63aaae58b5bd816b8e324ee1 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
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

