Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -r13840 -r14092 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 13840) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14092) @@ -1937,3 +1937,60 @@ ALTER TABLE FormSubmissions ADD MessageId VARCHAR(255) NULL DEFAULT NULL AFTER Notes, ADD INDEX (MessageId); + +# ===== v 5.1.1-B1 ===== +ALTER TABLE PortalUser ADD DisplayToPublic TEXT NULL; + +UPDATE Phrase +SET l<%PRIMARY_LANGUAGE%>_Translation = 'Comments' +WHERE PhraseKey = 'LA_FLD_COMMENTS'; + +ALTER TABLE Category + CHANGE `Type` `Type` INT(11) NOT NULL DEFAULT '1', + CHANGE `IsSystem` `Protected` TINYINT( 4 ) NOT NULL DEFAULT '0', + ADD INDEX ( `Protected` ); + +UPDATE Category SET `Type` = IF(`Protected` = 1, 2, 1); +UPDATE Category SET `Protected` = 1 WHERE ThemeId > 0; + +ALTER TABLE Category CHANGE CachedDescendantCatsQty CachedDescendantCatsQty INT(11) NOT NULL DEFAULT '0'; +ALTER TABLE Events CHANGE `Module` `Module` VARCHAR(40) NOT NULL DEFAULT 'Core'; + +ALTER TABLE Language + CHANGE DateFormat DateFormat VARCHAR(50) NOT NULL DEFAULT 'm/d/Y', + CHANGE TimeFormat TimeFormat VARCHAR(50) NOT NULL DEFAULT 'g:i:s A', + CHANGE DecimalPoint DecimalPoint VARCHAR(10) NOT NULL DEFAULT '.', + CHANGE Charset Charset VARCHAR(20) NOT NULL DEFAULT 'utf-8'; + +ALTER TABLE ItemReview CHANGE Rating Rating TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'; +UPDATE PortalUser SET tz = NULL; + +ALTER TABLE Category + CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL, + CHANGE ModifiedById ModifiedById INT(11) NULL DEFAULT NULL; +UPDATE Category SET CreatedById = NULL WHERE CreatedById = 0; +UPDATE Category SET ModifiedById = NULL WHERE ModifiedById = 0; + +ALTER TABLE ItemFiles CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL; + +ALTER TABLE Drafts CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL; +UPDATE Drafts SET CreatedById = NULL WHERE CreatedById = 0; + +ALTER TABLE ItemReview CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL; + +# ===== v 5.1.1-B2 ===== +UPDATE Phrase SET `Module` = 'Core' WHERE PhraseKey = 'LU_SECTION_FILES'; + +# ===== v 5.1.1-RC1 ===== +ALTER TABLE PortalUser + CHANGE Phone Phone VARCHAR(255) NOT NULL DEFAULT '', + CHANGE City City VARCHAR(255) NOT NULL DEFAULT '', + CHANGE Street Street VARCHAR(255) NOT NULL DEFAULT '', + CHANGE Zip Zip VARCHAR(20) NOT NULL DEFAULT '', + CHANGE ip ip VARCHAR(20) NOT NULL DEFAULT ''; + +UPDATE Phrase + SET l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron to run Agents' + WHERE PhraseKey = 'LA_USECRONFORREGULAREVENT' AND l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron for Running Regular Events'; + +# ===== v 5.1.1 ===== \ No newline at end of file