From 251349acaf0f8fed47aad1610b5b627a7e684f27 Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
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

