From 0720091ca73b9714aab2b38c3682c15a0cbd4533 Mon Sep 17 00:00:00 2001 From: Jesse Morgan Date: Thu, 2 Jun 2011 17:20:54 -0700 Subject: Added pages --- design/database.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'design') 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, -- cgit v1.2.3