Fixed a couple bugs

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