INSERT INTO Events (Event, Enabled, FromUserId, Module, Description, Type) VALUES ('COMMON.FOOTER', 1, 0, 'In-Portal', 'la_event_common.footer', 1);
ALTER TABLE CustomField ADD IsSystem TINYINT UNSIGNED NOT NULL;

ALTER TABLE CategoryCustomData ADD INDEX (ResourceId);
ALTER TABLE PortalUserCustomData ADD INDEX (ResourceId);

ALTER TABLE Permissions CHANGE Permission Permission VARCHAR(255) NOT NULL;
INSERT INTO ConfigurationValues VALUES ('NoPermissionTemplate', 'no_permission', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationAdmin VALUES ('NoPermissionTemplate', 'la_Text_Website', 'la_config_nopermission_template', 'text', '', '', 17, 0);

ALTER TABLE ConfigurationValues DROP PRIMARY KEY;
ALTER TABLE ConfigurationValues ADD VariableId INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;
ALTER TABLE ConfigurationValues ADD UNIQUE (VariableName);

ALTER TABLE PhraseCache ADD ConfigVariables text;

UPDATE Modules SET Version = '1.2.0' WHERE Name = 'In-Portal';