summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authortimb <timb@mb.local>2010-04-09 19:15:38 -0700
committertimb <timb@mb.local>2010-04-09 19:15:38 -0700
commit362e6c8760711626da079611aa457aa00ce4b5b7 (patch)
tree651adc3125c863ca264f45a6b2a9b8184876b321 /db
parent0db7b7ef7a35070bf802a6c3313701d6faa5b3dc (diff)
cleaned the code a tiny bit before merging
Diffstat (limited to 'db')
-rw-r--r--db/0-create.psql4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/0-create.psql b/db/0-create.psql
index 2771676..3ab384c 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -12,7 +12,7 @@ CREATE TABLE users (
bio text NOT NULL DEFAULT '',
profile_bg text
);
-CREATE INDEX users_nick_idx ON users (lower(nick));
+CREATE INDEX users_nick_lowercase_idx ON users (lower(nick));
CREATE TABLE rooms (
room_id SERIAL PRIMARY KEY,
@@ -66,7 +66,7 @@ CREATE TABLE tags (
CREATE INDEX tags_user_id_idx ON tags (user_id);
CREATE INDEX tags_message_id_idx ON tags (message_id);
CREATE INDEX tags_created_on_id_idx ON tags (created_on DESC);
-CREATE INDEX tags_tag_idx ON tags (lower(tag));
+CREATE INDEX tags_tag_lowercase_idx ON tags (lower(tag));
INSERT INTO rooms (key, name, description, admin_only)
VALUES ('dumpfm', 'Room A', 'Hangout', false);