diff options
| author | listandshare on ubuntu01 <jmorgan@foursquarestaff.com> | 2011-06-03 09:36:02 -0700 |
|---|---|---|
| committer | Jesse Morgan <jesse@jesterpm.net ; true> | 2011-06-03 09:36:02 -0700 |
| commit | 546f20c9f81b2a3e515141726c50d2621c2411df (patch) | |
| tree | fa9da307b5b1ecdcfd092f53bd8690b420bacfe9 /design/database.sql | |
| parent | c4931852362c7a54498742ced909a81c42fc1209 (diff) | |
| parent | bd11955780a958fdee35d03c94b88e65eea3cdd3 (diff) | |
Merge branch 'master' of 10.20.30.9:git/community
Diffstat (limited to 'design/database.sql')
| -rw-r--r-- | design/database.sql | 7 |
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'); |