summaryrefslogtreecommitdiff
path: root/design
diff options
context:
space:
mode:
Diffstat (limited to 'design')
-rw-r--r--design/database.sql7
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');