From 362e6c8760711626da079611aa457aa00ce4b5b7 Mon Sep 17 00:00:00 2001 From: timb Date: Fri, 9 Apr 2010 19:15:38 -0700 Subject: cleaned the code a tiny bit before merging --- db/0-create.psql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') 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); -- cgit v1.2.3-70-g09d2