Index: branches/5.3.x/core/install/upgrades.sql =================================================================== diff -u -N -r15945 -r15956 --- branches/5.3.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15945) +++ branches/5.3.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15956) @@ -2961,3 +2961,24 @@ ADD ErrorMessage VARCHAR(255) NOT NULL DEFAULT '' AFTER Status; ALTER TABLE ScheduledTasks ADD Module varchar(30) NOT NULL DEFAULT 'Core'; + +CREATE TABLE ModuleDeploymentLog ( + Id int(11) NOT NULL AUTO_INCREMENT, + Module varchar(30) NOT NULL DEFAULT 'In-Portal', + RevisionNumber int(11) NOT NULL DEFAULT '0', + RevisionTitle varchar(255) NOT NULL DEFAULT '', + CreatedOn int(10) unsigned DEFAULT NULL, + IPAddress varchar(15) NOT NULL DEFAULT '', + Output text, + ErrorMessage varchar(255) NOT NULL DEFAULT '', + Mode tinyint(1) NOT NULL DEFAULT '1', + Status tinyint(1) NOT NULL DEFAULT '1', + PRIMARY KEY (Id), + KEY CreatedOn (CreatedOn), + KEY Mode (Mode), + KEY Status (Status) +); + +INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:module_deployment_log.view', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:module_deployment_log.edit', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:module_deployment_log.delete', 11, 1, 1, 0);