Differential D440 Diff 1170 branches/5.2.x/core/install/upgrades.sql

Changeset View

Standalone View

branches/5.2.x/core/install/upgrades.sql

	Show First 20 Lines • Show All 2958 Lines • ▼ Show 20 Line(s)

	ALTER TABLE Users ADD KEY Email (Email);			ALTER TABLE Users ADD KEY Email (Email);

	INSERT INTO SystemSettings VALUES(DEFAULT, 'SystemLogCodeFragmentPathFilterRegExp', '#(modules/custom\|system/cache/modules/custom)/.*#', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SystemLogCodeFragmentPathFilterRegExp', 'text', NULL, NULL, 65.05, 0, 1, NULL);			INSERT INTO SystemSettings VALUES(DEFAULT, 'SystemLogCodeFragmentPathFilterRegExp', '#(modules/custom\|system/cache/modules/custom)/.*#', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SystemLogCodeFragmentPathFilterRegExp', 'text', NULL, NULL, 65.05, 0, 1, NULL);
	ALTER TABLE SystemLog			ALTER TABLE SystemLog
	ADD COLUMN `LogCodeFragment` longtext NULL AFTER `LogSourceFileLine`,			ADD COLUMN `LogCodeFragment` longtext NULL AFTER `LogSourceFileLine`,
	ADD COLUMN `LogCodeFragmentsRotated` tinyint(4) NOT NULL DEFAULT '0' AFTER `LogCodeFragment`;			ADD COLUMN `LogCodeFragmentsRotated` tinyint(4) NOT NULL DEFAULT '0' AFTER `LogCodeFragment`;
	ALTER TABLE SystemLog ADD INDEX `TIMESTAMP_CODE_FRAGMENTS_ROTATED` (`LogTimestamp`,`LogCodeFragmentsRotated`) USING BTREE;			ALTER TABLE SystemLog ADD INDEX `TIMESTAMP_CODE_FRAGMENTS_ROTATED` (`LogTimestamp`,`LogCodeFragmentsRotated`) USING BTREE;

				ALTER TABLE Semaphores
				ADD COLUMN `UserId` int(11) NULL,
				ADD COLUMN `IpAddress` varchar(15) NOT NULL DEFAULT '',
				ADD COLUMN `Hostname` varchar(255) NOT NULL DEFAULT '',
				ADD COLUMN `RequestURI` varchar(255) NOT NULL DEFAULT '',
				ADD COLUMN `Backtrace` longtext NULL;
				INSERT INTO SystemSettings VALUES(DEFAULT, 'SemaphoreLifetimeInSeconds', '300', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsSystem', 'la_config_SemaphoreLifetimeInSeconds', 'text', '', 'style=\"width: 50px;\"', 60.1, 0, 1, 'hint:la_config_SemaphoreLifetimeInSeconds');