From 36d95e85868100b5b65b136f322b686566eaaffd Mon Sep 17 00:00:00 2001 From: Jesse Morgan Date: Thu, 2 Jun 2011 20:06:26 -0700 Subject: Fixed a couple bugs --- design/database.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'design') 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'); -- cgit v1.2.3