diff options
Diffstat (limited to 'sql/sqlite3.sql')
-rw-r--r-- | sql/sqlite3.sql | 8 |
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 ) +); |