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'); | 
