Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -r10316 -r10323 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10316) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10323) @@ -92,7 +92,7 @@ CREATE TABLE EmailSubscribers ( EmailMessageId int(11) NOT NULL default '0', - PortalUserId int(11) NOT NULL default '0' + PortalUserId int(11) NOT NULL default '0', KEY EmailMessageId (EmailMessageId), KEY PortalUserId (PortalUserId) ); @@ -132,7 +132,7 @@ ThousandSep VARCHAR(10) NOT NULL DEFAULT '', `Charset` varchar(20) NOT NULL default '', UnitSystem tinyint(4) NOT NULL default '1', - PRIMARY KEY (LanguageId) + PRIMARY KEY (LanguageId), KEY Enabled (Enabled), KEY PrimaryLang (PrimaryLang), KEY AdminInterfaceLang (AdminInterfaceLang), @@ -159,11 +159,9 @@ PortalUserId int(11) NOT NULL default '0', VariableName varchar(255) NOT NULL default '', VariableValue text NOT NULL, - PRIMARY KEY (VariableId), + PRIMARY KEY (VariableId), KEY UserId (PortalUserId), - KEY VariableName (VariableName), - KEY VariableName (Loaded), - KEY VariableName (LoadOrder) + KEY VariableName (VariableName) ); CREATE TABLE Phrase ( Index: branches/RC/admin/install/inportal_schema.sql =================================================================== diff -u -r10316 -r10323 --- branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 10316) +++ branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 10323) @@ -94,7 +94,7 @@ Status tinyint(4) NOT NULL default '2', TextFormat int(11) NOT NULL default '0', Module varchar(255) NOT NULL default '', - PRIMARY KEY (ReviewId) + PRIMARY KEY (ReviewId), KEY CreatedOn (CreatedOn), KEY ItemId (ItemId), KEY ItemType (ItemType), Index: branches/RC/admin/install/inportal_remove.sql =================================================================== diff -u -r9581 -r10323 --- branches/RC/admin/install/inportal_remove.sql (.../inportal_remove.sql) (revision 9581) +++ branches/RC/admin/install/inportal_remove.sql (.../inportal_remove.sql) (revision 10323) @@ -223,4 +223,8 @@ DROP TABLE Counters # -------------------------------------------------------- DROP TABLE Skins -# +# -------------------------------------------------------- +DROP TABLE ChangeLogs +# -------------------------------------------------------- +DROP TABLE SessionLogs +# \ No newline at end of file