diff options
| author | Jesse Morgan <jesse@jesterpm.net> | 2011-06-02 17:20:54 -0700 |
|---|---|---|
| committer | Jesse Morgan <jesse@jesterpm.net ; true> | 2011-06-02 17:20:54 -0700 |
| commit | 0720091ca73b9714aab2b38c3682c15a0cbd4533 (patch) | |
| tree | 0d77e48eb52d3f39123659550976c5999effddff /design | |
| parent | 1800a1e9022a9f4316e0d57a650faed9da0e8df4 (diff) | |
Added pages
Diffstat (limited to 'design')
| -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, |