diff options
Diffstat (limited to 'design')
-rw-r--r-- | design/database.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/design/database.sql b/design/database.sql index 06b607c..475dac2 100644 --- a/design/database.sql +++ b/design/database.sql @@ -26,6 +26,7 @@ CREATE TABLE category ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, shortname VARCHAR(30) NOT NULL, name VARCHAR(30) NOT NULL, + description VARCHAR(255) NOT NULL, PRIMARY KEY(id) ); @@ -93,11 +94,11 @@ CREATE TABLE page ( -- The following creates some sample data INSERT INTO category (name, shortname) VALUES + ('Give', 'give'), + ('Needs', 'needs'), ('Jobs', 'jobs'), ('Housing', 'housing'), - ('Events', 'events'), - ('For Sale','forsale'), - ('Needs', 'needs'); + ('Events', 'events'); INSERT INTO source (name) VALUES ('Foursquare Church'); |