Differential D3 Diff 95 core/install/upgrades.sql

Changeset View

Standalone View

core/install/upgrades.sql

	# ===== v 4.0.1 =====			# ===== v 4.0.1 =====
	ALTER TABLE EmailLog ADD EventParams TEXT NOT NULL;			ALTER TABLE EmailLog ADD EventParams TEXT NOT NULL;

	INSERT INTO ConfigurationAdmin VALUES ('MailFunctionHeaderSeparator', 'la_Text_smtp_server', 'la_config_MailFunctionHeaderSeparator', 'radio', NULL, '1=la_Linux,2=la_Windows', 30.08, 0, 0);			INSERT INTO ConfigurationAdmin VALUES ('MailFunctionHeaderSeparator', 'la_Text_smtp_server', 'la_config_MailFunctionHeaderSeparator', 'radio', NULL, '1=la_Linux,2=la_Windows', 30.08, 0, 0);
	INSERT INTO ConfigurationValues VALUES (0, 'MailFunctionHeaderSeparator', 1, 'In-Portal', 'in-portal:configure_general');			INSERT INTO ConfigurationValues VALUES (0, 'MailFunctionHeaderSeparator', 1, 'In-Portal', 'in-portal:configure_general');

	ALTER TABLE PersistantSessionData DROP PRIMARY KEY ;			ALTER TABLE PersistantSessionData DROP PRIMARY KEY ;
	ALTER TABLE PersistantSessionData ADD INDEX ( `PortalUserId` ) ;			ALTER TABLE PersistantSessionData ADD INDEX ( `PortalUserId` ) ;

	# ===== v 4.1.0 =====			# ===== v 4.1.0 =====
	ALTER TABLE EmailMessage ADD ReplacementTags TEXT AFTER Template;			ALTER TABLE EmailMessage ADD ReplacementTags TEXT AFTER Template;
	ALTER TABLE Phrase			ALTER TABLE Phrase
	CHANGE Translation Translation TEXT NOT NULL,			CHANGE Translation Translation TEXT NOT NULL,
				alexUnsubmitted Not Done Reply Please don't list column names in INSERT statements, unless it's absolutely necessary. alex: Please don't list column names in INSERT statements, unless it's absolutely necessary.
	CHANGE Module Module VARCHAR(30) NOT NULL DEFAULT 'In-Portal';			CHANGE Module Module VARCHAR(30) NOT NULL DEFAULT 'In-Portal';
	ALTER TABLE Category			ALTER TABLE Category
	CHANGE Description Description TEXT,			CHANGE Description Description TEXT,
	CHANGE l1_Description l1_Description TEXT,			CHANGE l1_Description l1_Description TEXT,
	CHANGE l2_Description l2_Description TEXT,			CHANGE l2_Description l2_Description TEXT,
	CHANGE l3_Description l3_Description TEXT,			CHANGE l3_Description l3_Description TEXT,
	CHANGE l4_Description l4_Description TEXT,			CHANGE l4_Description l4_Description TEXT,
	CHANGE l5_Description l5_Description TEXT,			CHANGE l5_Description l5_Description TEXT,
	▲ Show 20 Lines • Show All 2978 Lines • ▼ Show 20 Line(s)
	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.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.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:module_deployment_log.delete', 11, 1, 1, 0);			INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:module_deployment_log.delete', 11, 1, 1, 0);

	UPDATE EmailTemplates			UPDATE EmailTemplates
	SET			SET
	l<%PRIMARY_LANGUAGE%>_Subject = REPLACE(l<%PRIMARY_LANGUAGE%>_Subject, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>'),			l<%PRIMARY_LANGUAGE%>_Subject = REPLACE(l<%PRIMARY_LANGUAGE%>_Subject, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>'),
	l<%PRIMARY_LANGUAGE%>_PlainTextBody = REPLACE(l<%PRIMARY_LANGUAGE%>_PlainTextBody, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>'),			l<%PRIMARY_LANGUAGE%>_PlainTextBody = REPLACE(l<%PRIMARY_LANGUAGE%>_PlainTextBody, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>'),
	l<%PRIMARY_LANGUAGE%>_HtmlBody = REPLACE(l<%PRIMARY_LANGUAGE%>_HtmlBody, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>')			l<%PRIMARY_LANGUAGE%>_HtmlBody = REPLACE(l<%PRIMARY_LANGUAGE%>_HtmlBody, '<inp2:u_Field name="Email"/>', '<inp2:Field name="Email"/>')
	WHERE TemplateName IN ('USER.SUBSCRIBE', 'USER.UNSUBSCRIBE');			WHERE TemplateName IN ('USER.SUBSCRIBE', 'USER.UNSUBSCRIBE');

				alexUnsubmitted Not Done Reply Several more issues with this: If a variable is renamed in `upgrades.sql` then it have no effect on clean In-Portal installation. To make clean installation work it needs to be renamed in `INSERT INTO` sql in the `install_data.sql` file as well. You have renamed variable only, but not it's usages. I've counted 2 usages at least in the Core module. alex: Several more issues with this: # If a variable is renamed in `upgrades.sql` then it have no…
	ALTER TABLE CategoryItems ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);			ALTER TABLE CategoryItems ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);
	ALTER TABLE UserGroupRelations DROP PRIMARY KEY;			ALTER TABLE UserGroupRelations DROP PRIMARY KEY;
	ALTER TABLE UserGroupRelations ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id), ADD UNIQUE KEY UserGroup (PortalUserId, GroupId);			ALTER TABLE UserGroupRelations ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id), ADD UNIQUE KEY UserGroup (PortalUserId, GroupId);
				alexUnsubmitted Not Done Reply The `DisplayOrder` column value (the `10.04` in above SQL) should be unique across same configuration group. Right now it exactly matches value of `NoPermissionTemplate` system setting. You need to: shift down all configuration variables in same sub-section use `10.05` as `DisplayOrder` column value for that new system setting update `install_data.sql` to reflect new value in `DisplayOrder` column I usually use SQL similar to this to shift up/down system settings in particular sub-group: UPDATE SystemSettings SET DisplayOrder = ROUND(DisplayOrder + 0.01, 2) WHERE Section = 'x' and Heading = 'y' AND DisplayOrder > z alex: The `DisplayOrder` column value (the `10.04` in above SQL) should be unique across same…
				alexUnsubmitted Not Done Reply Just noticed that used label doesn't match system setting name and should be `la_config_ FatalErrorTemplate`. You can see on screenshot above that two system settings have identical translation. alex: Just noticed that used label doesn't match system setting name and should be `la_config_…
	DELETE FROM UserPersistentSessionData WHERE VariableName IN ('u-ug[Default]columns_.', 'g-ug[Default]columns_.');			DELETE FROM UserPersistentSessionData WHERE VariableName IN ('u-ug[Default]columns_.', 'g-ug[Default]columns_.');
	ALTER TABLE SpamControl ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);			ALTER TABLE SpamControl ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);

	INSERT INTO SystemSettings VALUES(DEFAULT, 'SSLDomain', '', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsSSL', 'la_config_SSLDomain', 'text', '', '', 30.01, 0, 1, NULL);			INSERT INTO SystemSettings VALUES(DEFAULT, 'SSLDomain', '', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsSSL', 'la_config_SSLDomain', 'text', '', '', 30.01, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'AdminSSLDomain', '', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsSSL', 'la_config_AdminSSLDomain', 'text', '', '', 30.02, 0, 0, NULL);			INSERT INTO SystemSettings VALUES(DEFAULT, 'AdminSSLDomain', '', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsSSL', 'la_config_AdminSSLDomain', 'text', '', '', 30.02, 0, 0, NULL);
	DELETE FROM LanguageLabels WHERE PhraseKey IN ('LA_CONFIG_SSL_URL', 'LA_CONFIG_ADMINSSL_URL', 'LA_FLD_SSLURL');			DELETE FROM LanguageLabels WHERE PhraseKey IN ('LA_CONFIG_SSL_URL', 'LA_CONFIG_ADMINSSL_URL', 'LA_FLD_SSLURL');

	ALTER TABLE SiteDomains			ALTER TABLE SiteDomains
	CHANGE SSLUrl SSLDomainName VARCHAR(255) NOT NULL DEFAULT '',			CHANGE SSLUrl SSLDomainName VARCHAR(255) NOT NULL DEFAULT '',
	CHANGE SSLUrlUsesRegExp SSLDomainNameUsesRegExp TINYINT(4) NOT NULL DEFAULT '0';			CHANGE SSLUrlUsesRegExp SSLDomainNameUsesRegExp TINYINT(4) NOT NULL DEFAULT '0';
	DELETE FROM UserPersistentSessionData WHERE VariableName = 'site-domain[Default]columns_.';			DELETE FROM UserPersistentSessionData WHERE VariableName = 'site-domain[Default]columns_.';
	No newline at end of file
				UPDATE SystemSettings
				SET VariableName = 'NotFoundErrorTemplate'
				WHERE VariableName = 'ErrorTemplate';

				UPDATE SystemSettings
				SET DisplayOrder = ROUND(DisplayOrder + 0.01, 2)
				WHERE Section = 'in-portal:configure_advanced' and Heading = 'la_section_SettingsWebsite' AND DisplayOrder > 10.04;

				INSERT INTO SystemSettings VALUES (DEFAULT, 'FatalErrorTemplate', 'error_fatal', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsWebsite', 'la_config_FatalErrorTemplate', 'text', '', '', 10.05, 0, 0, null);