Differential D297 Diff 732 core/install/upgrades.sql

Changeset View

Standalone View

core/install/upgrades.sql

	Show First 20 Lines • Show All 3046 Lines • ▼ Show 20 Line(s)
	ALTER TABLE SiteDomains			ALTER TABLE SiteDomains
	ADD `Status` TINYINT NOT NULL DEFAULT '1' AFTER Priority,			ADD `Status` TINYINT NOT NULL DEFAULT '1' AFTER Priority,
	ADD INDEX (`Status`);			ADD INDEX (`Status`);

	INSERT INTO SystemSettings VALUES(DEFAULT, 'SessionLogRotationInterval', '2629800', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SessionLogRotationInterval', 'select', '', '86400=la_opt_OneDay\|\|604800=la_opt_OneWeek\|\|1209600=la_opt_TwoWeeks\|\|2629800=la_opt_OneMonth\|\|7889400=la_opt_ThreeMonths\|\|31557600=la_opt_OneYear\|\|63115200=la_opt_TwoYears\|\|94672800=la_opt_ThreeYears\|\|157788000=la_opt_FiveYears\|\|-1=la_opt_EmailLogKeepForever', 65.05, 0, 1, NULL);			INSERT INTO SystemSettings VALUES(DEFAULT, 'SessionLogRotationInterval', '2629800', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SessionLogRotationInterval', 'select', '', '86400=la_opt_OneDay\|\|604800=la_opt_OneWeek\|\|1209600=la_opt_TwoWeeks\|\|2629800=la_opt_OneMonth\|\|7889400=la_opt_ThreeMonths\|\|31557600=la_opt_OneYear\|\|63115200=la_opt_TwoYears\|\|94672800=la_opt_ThreeYears\|\|157788000=la_opt_FiveYears\|\|-1=la_opt_EmailLogKeepForever', 65.05, 0, 1, NULL);

	UPDATE PromoBlocks SET ScheduleToDate = ScheduleToDate + 86399 WHERE DATE_FORMAT(FROM_UNIXTIME(ScheduleTodate), "%H%i") = "0000";			UPDATE PromoBlocks SET ScheduleToDate = ScheduleToDate + 86399 WHERE DATE_FORMAT(FROM_UNIXTIME(ScheduleTodate), "%H%i") = "0000";
	DELETE FROM LanguageLabels WHERE PhraseKey = "LA_FLD_SCHEDULEDATE";			DELETE FROM LanguageLabels WHERE PhraseKey = "LA_FLD_SCHEDULEDATE";

				ALTER TABLE PageRevisions
				ADD l1_ContentBlockContent text AFTER RevisionNumber,
				ADD l2_ContentBlockContent text AFTER l1_ContentBlockContent,
				ADD l3_ContentBlockContent text AFTER l2_ContentBlockContent,
				ADD l4_ContentBlockContent text AFTER l3_ContentBlockContent,
				ADD l5_ContentBlockContent text AFTER l4_ContentBlockContent;
				UPDATE SearchConfig SET DisplayOrder = DisplayOrder + 1 WHERE DisplayOrder BETWEEN 5 AND 7 AND ModuleName = 'In-Portal';
				alexUnsubmitted Not Done Reply this must also be done in `/core/install/install_data.sql` enable for both Simple and Advanced Searches by default set weight of 1 by default via changing `DisplayOrder` field move this search setting after `Description` field no record present in `SearchConfig` table after Clean Install all existing search fields are enabled by default for advanced search and it makes sense to enable this one for simple search as well most likely fields with 0 weight will reduce page rank in search results position of the field doesn't represent what's in it (I guess all text fields are on top) alex: # this must also be done in `/core/install/install_data.sql` # enable for both Simple and…
				alexUnsubmitted Not Done Reply replace `DisplayOrder >= 5` with `DisplayOrder BETWEEN 5 AND 7` there database after clean install and after upgrade should look the same alex: replace `DisplayOrder >= 5` with `DisplayOrder BETWEEN 5 AND 7` --- there database after…
				INSERT INTO SearchConfig VALUES ('Categories', 'ContentBlockContent', 1, 1, 'lu_fielddesc_category_ContentBlockContent', 'lc_field_ContentBlockContent', 'In-Portal', 'la_text_category', 5, DEFAULT, 1, 'text', 'MULTI:PageRevisions.ContentBlockContent', '{ForeignTable}.PageId={LocalTable}.CategoryId AND {ForeignTable}.RevisionNumber = {LocalTable}.LiveRevisionNumber', NULL, NULL, NULL, NULL, NULL);