diff options
| author | timb <timb@mb.local> | 2010-04-09 19:15:38 -0700 |
|---|---|---|
| committer | timb <timb@mb.local> | 2010-04-09 19:15:38 -0700 |
| commit | 362e6c8760711626da079611aa457aa00ce4b5b7 (patch) | |
| tree | 651adc3125c863ca264f45a6b2a9b8184876b321 /db | |
| parent | 0db7b7ef7a35070bf802a6c3313701d6faa5b3dc (diff) | |
cleaned the code a tiny bit before merging
Diffstat (limited to 'db')
| -rw-r--r-- | db/0-create.psql | 4 |
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); |
