diff options
Diffstat (limited to 'design/database.sql')
| -rw-r--r-- | design/database.sql | 3 |
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, |