diff options
| author | Andreas Baumann <mail@andreasbaumann.cc> | 2015-05-03 21:14:36 +0200 |
|---|---|---|
| committer | Andreas Baumann <mail@andreasbaumann.cc> | 2015-05-03 21:14:36 +0200 |
| commit | a07e48f45e3b922a63aaae58b5bd816b8e324ee1 (patch) | |
| tree | c2258783ecacc7005226acedc198ca332763e992 /sql/sqlite3.sql | |
| parent | 549dffeef49ae25c89d4d1cc6c71c715edfb753f (diff) | |
| download | aCms-a07e48f45e3b922a63aaae58b5bd816b8e324ee1.tar.gz aCms-a07e48f45e3b922a63aaae58b5bd816b8e324ee1.tar.bz2 | |
started to add pages
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 ) +); |