From 0db7b7ef7a35070bf802a6c3313701d6faa5b3dc Mon Sep 17 00:00:00 2001
From: tim b <timb@camcompu.home>
Date: Thu, 8 Apr 2010 18:22:25 -0700
Subject: favs

---
 db/0-create.psql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'db')

diff --git a/db/0-create.psql b/db/0-create.psql
index cad20e9..2771676 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -12,6 +12,7 @@ CREATE TABLE users (
     bio text NOT NULL DEFAULT '',
     profile_bg text
 );
+CREATE INDEX users_nick_idx ON users (lower(nick));
 
 CREATE TABLE rooms (
     room_id SERIAL PRIMARY KEY,
@@ -64,6 +65,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));
 
 INSERT INTO rooms (key, name, description, admin_only) 
-- 
cgit v1.2.3-70-g09d2