Committer: akanashin
LJSUP-12225: Two identical accountU trunk/bin/upgrading/update-db-general.pl
Modified: trunk/bin/upgrading/update-db-general.pl =================================================================== --- trunk/bin/upgrading/update-db-general.pl 2012-05-16 11:04:03 UTC (rev 21973) +++ trunk/bin/upgrading/update-db-general.pl 2012-05-16 13:51:29 UTC (rev 21974) @@ -552,6 +552,7 @@ `type` char(5) default NULL, `name` char(80) default NULL, PRIMARY KEY (`domainid`), + UNIQUE KEY `domain` (`domain`), KEY `userid` (`userid`), KEY `rcptid` (`userid`) ) @@ -4455,6 +4456,11 @@ do_alter("domains", "ALTER TABLE domains ADD COLUMN type char(5)"); do_alter("domains", "ALTER TABLE domains ADD COLUMN name char(80)"); } + + unless (index_name("domains", "UNIQUE:domain")) { + do_alter("domains", "ALTER TABLE domains ADD UNIQUE (domain)"); + } + }); register_alter(sub {