Changeset View
Changeset View
Standalone 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, | ||||
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'); | ||||
Not Done ReplySeveral more issues with this:
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); | ||||
Not Done ReplyThe 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:
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… | |||||
Not Done ReplyJust 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_.'; | ||||
UPDATE Modules | UPDATE Modules | ||||
SET ClassNamespace = 'InPortal\\Core' | SET ClassNamespace = 'InPortal\\Core' | ||||
WHERE `Name` IN ('Core', 'In-Portal'); | WHERE `Name` IN ('Core', 'In-Portal'); | ||||
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); |
Please don't list column names in INSERT statements, unless it's absolutely necessary.