summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorsostler <sbostler@gmail.com>2010-01-06 01:46:06 -0500
committersostler <sbostler@gmail.com>2010-01-06 01:46:06 -0500
commitf73640c51513fa9164edcd25493ef0fdb75b7d18 (patch)
treea25666b0ad4a4ce7afb43a10d44a0cf4a725e647 /db
parentb43135d49c062fec59426969169259bd982b4585 (diff)
Updated db file
Diffstat (limited to 'db')
-rwxr-xr-xdb/0-create.psql5
1 files changed, 4 insertions, 1 deletions
diff --git a/db/0-create.psql b/db/0-create.psql
index af5ace6..ac0dac6 100755
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -32,4 +32,7 @@ CREATE INDEX user_id_idx ON messages (user_id);
CREATE INDEX room_id_idx ON messages (room_id);
CREATE INDEX created_on_idx ON messages (created_on);
-INSERT INTO rooms (room_id, name) VALUES (1, 'dumpfm'); \ No newline at end of file
+INSERT INTO rooms (key, name, description, admin_only)
+ VALUES ('RoomA', 'Room A', 'Hangout', false);
+INSERT INTO rooms (key, name, description, admin_only)
+ VALUES ('VIP', 'The VIP Room', 'Command Post', true); \ No newline at end of file