1 files changed, 7 insertions, 4 deletions
diff --git a/db/0-create.psql-altered b/db/0-create.psql-altered
index cb1469b..68c9f1e 100755
--- a/db/0-create.psql-altered
+++ b/db/0-create.psql-altered
@@ -1,4 +1,8 @@
-CREATE DATABASE dumpfm;
+-- dump.fm schema (altered copy)
+--
+-- Run with:
+--   createdb dumpfm
+--   psql -d dumpfm -f db/0-create.psql-altered
 
 CREATE TABLE users (
     user_id SERIAL PRIMARY KEY,
@@ -17,9 +21,8 @@ CREATE TABLE users (
     profile_bg text
 );
 
-ALTER TABLE users ADD CONSTRAINT users_nick_constraint UNIQUE (LOWER(nick));
-
-CREATE INDEX users_nick_lowercase_idx ON users (lower(nick));
+-- Case-insensitive uniqueness for nicks.
+CREATE UNIQUE INDEX users_nick_lowercase_uidx ON users (lower(nick));
 
 CREATE TABLE rooms (
     room_id SERIAL PRIMARY KEY,