Differential D152 Diff 464 branches/5.3.x/core/install/upgrades.sql

Changeset View

Standalone View

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

	Show First 20 Lines • Show All 2926 Lines • ▼ Show 20 Line(s)
	UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';			UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';

	# ===== v 5.3.0-B1 =====			# ===== v 5.3.0-B1 =====
	ALTER TABLE ScheduledTasks ADD Settings TEXT NULL;			ALTER TABLE ScheduledTasks ADD Settings TEXT NULL;
	ALTER TABLE Themes ADD ImageResizeRules TEXT NULL;			ALTER TABLE Themes ADD ImageResizeRules TEXT NULL;

	DELETE FROM UserPersistentSessionData WHERE VariableName = 'emailevents[Emails]columns_.';			DELETE FROM UserPersistentSessionData WHERE VariableName = 'emailevents[Emails]columns_.';

	INSERT INTO <%TABLE_PREFIX%>SystemCache (VarName, Data)			INSERT INTO SystemCache (VarName, Data)
	SELECT 'tmp_translation' AS VarName, l<%PRIMARY_LANGUAGE%>_Translation AS Data			SELECT 'tmp_translation' AS VarName, l<%PRIMARY_LANGUAGE%>_Translation AS Data
	FROM <%TABLE_PREFIX%>LanguageLabels			FROM <%TABLE_PREFIX%>LanguageLabels
	WHERE PhraseKey = 'LC_IMPORTLANG_PHRASEWARNING';			WHERE PhraseKey = 'LC_IMPORTLANG_PHRASEWARNING';

	UPDATE <%TABLE_PREFIX%>LanguageLabels			UPDATE LanguageLabels
	SET			SET
	Phrase = 'la_fld_ImportOverwrite',			Phrase = 'la_fld_ImportOverwrite',
	PhraseKey = 'LA_FLD_IMPORTOVERWRITE',			PhraseKey = 'LA_FLD_IMPORTOVERWRITE',
	l<%PRIMARY_LANGUAGE%>_HintTranslation = (SELECT Data FROM <%TABLE_PREFIX%>SystemCache WHERE VarName = 'tmp_translation' LIMIT 1)			l<%PRIMARY_LANGUAGE%>_HintTranslation = (SELECT Data FROM <%TABLE_PREFIX%>SystemCache WHERE VarName = 'tmp_translation' LIMIT 1)
	WHERE PhraseKey = 'LA_PROMPT_OVERWRITEPHRASES';			WHERE PhraseKey = 'LA_PROMPT_OVERWRITEPHRASES';

	DELETE FROM LanguageLabels WHERE PhraseKey = 'LC_IMPORTLANG_PHRASEWARNING';			DELETE FROM LanguageLabels WHERE PhraseKey = 'LC_IMPORTLANG_PHRASEWARNING';

	▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines