Changeset View
Changeset View
Standalone View
Standalone View
core/install/upgrades.sql
Show First 20 Lines • Show All 2929 Lines • ▼ Show 20 Line(s) | |||||
SET l1_Subject = REPLACE(l1_Subject, "Field name='Username'", 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, "Field name='Username'", 'UserTitle') | SET l1_Subject = REPLACE(l1_Subject, "Field name='Username'", 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, "Field name='Username'", 'UserTitle') | ||||
WHERE TemplateName LIKE 'USER%'; | WHERE TemplateName LIKE 'USER%'; | ||||
UPDATE EmailTemplates | UPDATE EmailTemplates | ||||
SET l1_Subject = REPLACE(l1_Subject, 'Field name="Username"', 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, 'Field name="Username"', 'UserTitle') | SET l1_Subject = REPLACE(l1_Subject, 'Field name="Username"', 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, 'Field name="Username"', 'UserTitle') | ||||
WHERE TemplateName LIKE 'USER%'; | WHERE TemplateName LIKE 'USER%'; | ||||
UPDATE SystemSettings SET VariableValue = 1 WHERE VariableName = 'CSVExportEncoding'; | UPDATE SystemSettings SET VariableValue = 1 WHERE VariableName = 'CSVExportEncoding'; | ||||
ALTER TABLE Semaphores ADD MainIDs INT NULL DEFAULT NULL AFTER MainPrefix; | ALTER TABLE Semaphores ADD MainIDs INT NULL DEFAULT NULL AFTER MainPrefix; | ||||
UPDATE LanguageLabels | |||||
SET l1_Translation = 'Incorrect date format, please use ({format}) ex. ({sample})' | |||||
WHERE PhraseKey = 'LA_ERR_BAD_DATE_FORMAT'; |