From c4e555c160fbca08457fd178f6031d5bba4a4c16 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Thu, 10 Feb 2011 07:07:40 -0500 Subject: [PATCH] - Fix subtype select labels for fields added with 'Add field' --- SQL/sqlite.initial.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index e7faeed..875b3cb 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -28,7 +28,7 @@ changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', - email varchar(128) NOT NULL default '', + email varchar(255) NOT NULL default '', firstname varchar(128) NOT NULL default '', surname varchar(128) NOT NULL default '', vcard text NOT NULL default '' @@ -97,7 +97,7 @@ preferences text NOT NULL default '' ); -CREATE INDEX ix_users_username ON users(username); +CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host); CREATE INDEX ix_users_alias ON users(alias); -- -------------------------------------------------------- -- Gitblit v1.9.1