summaryrefslogtreecommitdiff
path: root/design
diff options
context:
space:
mode:
Diffstat (limited to 'design')
-rw-r--r--design/database.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/design/database.sql b/design/database.sql
index 412245d..8a19001 100644
--- a/design/database.sql
+++ b/design/database.sql
@@ -79,8 +79,9 @@ CREATE TABLE user (
UNIQUE KEY(email)
);
-CREATE TABLE pages (
+CREATE TABLE page (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+ title VARCHAR(60) NOT NULL,
url VARCHAR(60) NOT NULL,
content TEXT NOT NULL,