From 251349acaf0f8fed47aad1610b5b627a7e684f27 Mon Sep 17 00:00:00 2001 From: Jesse Morgan Date: Tue, 17 May 2011 17:20:06 -0700 Subject: Added category buttons and categories page --- design/database.sql | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) (limited to 'design/database.sql') diff --git a/design/database.sql b/design/database.sql index 22daf7f..08bcc54 100644 --- a/design/database.sql +++ b/design/database.sql @@ -24,6 +24,7 @@ USE p4scommunity; CREATE TABLE category ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, + shortname VARCHAR(30) NOT NULL, name VARCHAR(30) NOT NULL, PRIMARY KEY(id) @@ -79,12 +80,12 @@ CREATE TABLE pages ( ); -- The following creates some sample data -INSERT INTO category (name) VALUES - ('Jobs'), - ('Housing'), - ('Events'), - ('For Sale'), - ('Needs'); +INSERT INTO category (name, shortname) VALUES + ('Jobs', 'jobs'), + ('Housing', 'housing'), + ('Events', 'events'), + ('For Sale','forsale'), + ('Needs', 'needs'); INSERT INTO source (name) VALUES ('Foursquare Church'); -- cgit v1.2.3