Index: branches/5.0.x/core/install/install_schema.sql =================================================================== diff -u -r12591 -r12638 --- branches/5.0.x/core/install/install_schema.sql (.../install_schema.sql) (revision 12591) +++ branches/5.0.x/core/install/install_schema.sql (.../install_schema.sql) (revision 12638) @@ -207,18 +207,16 @@ ); CREATE TABLE PortalGroup ( - GroupId int(11) NOT NULL auto_increment, - Name varchar(255) NOT NULL default '', - Description varchar(255) default NULL, - CreatedOn int(10) unsigned default NULL, - System tinyint(4) NOT NULL default '0', - Personal tinyint(4) NOT NULL default '0', - Enabled tinyint(4) NOT NULL default '1', - ResourceId int(11) NOT NULL default '0', - FrontRegistration tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (GroupId), - UNIQUE KEY Name (Name), - UNIQUE KEY ResourceId (ResourceId), + GroupId int(11) NOT NULL AUTO_INCREMENT, + `Name` varchar(255) NOT NULL DEFAULT '', + Description varchar(255) DEFAULT NULL, + CreatedOn int(10) unsigned DEFAULT NULL, + System tinyint(4) NOT NULL DEFAULT '0', + Personal tinyint(4) NOT NULL DEFAULT '0', + Enabled tinyint(4) NOT NULL DEFAULT '1', + FrontRegistration tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (GroupId), + UNIQUE KEY `Name` (`Name`), KEY Personal (Personal), KEY Enabled (Enabled), KEY CreatedOn (CreatedOn)