Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r15051 -r15105 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15051) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15105) @@ -2603,3 +2603,42 @@ INSERT INTO SystemSettings VALUES(DEFAULT, 'CKFinderLicenseKey', '', 'In-Portal', 'in-portal:configure_advanced', 'la_section_Settings3rdPartyAPI', 'la_config_CKFinderLicenseKey', 'text', NULL, NULL, 80.04, 0, 0, NULL); INSERT INTO SystemSettings VALUES(DEFAULT, 'EnablePageContentRevisionControl', '0', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsAdmin', 'la_config_EnablePageContentRevisionControl', 'checkbox', '', '', 40.19, 0, 0, NULL); + +# ===== v 5.2.0-B2 ===== +ALTER TABLE Users + CHANGE Username Username varchar(255) NOT NULL DEFAULT '', + CHANGE IPAddress IPAddress varchar(15) NOT NULL DEFAULT '', + CHANGE PwResetConfirm PwResetConfirm varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE UserSessions + CHANGE TimeZone TimeZone varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE CountryStates + CHANGE l1_Name l1_Name varchar(255) NOT NULL DEFAULT '', + CHANGE l2_Name l2_Name varchar(255) NOT NULL DEFAULT '', + CHANGE l3_Name l3_Name varchar(255) NOT NULL DEFAULT '', + CHANGE l4_Name l4_Name varchar(255) NOT NULL DEFAULT '', + CHANGE l5_Name l5_Name varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE Categories + CHANGE DirectLinkAuthKey DirectLinkAuthKey varchar(20) NOT NULL DEFAULT ''; + +ALTER TABLE ScheduledTasks + CHANGE SiteDomainLimitation SiteDomainLimitation varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE ItemFilters + CHANGE ItemPrefix ItemPrefix varchar(255) NOT NULL DEFAULT '', + CHANGE FilterField FilterField varchar(255) NOT NULL DEFAULT '', + CHANGE FilterType FilterType varchar(100) NOT NULL DEFAULT ''; + +ALTER TABLE SpamReports + CHANGE ItemPrefix ItemPrefix varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE CachedUrls + CHANGE ParsedVars ParsedVars text; + +ALTER TABLE CurlLog + CHANGE Message Message varchar(255) NOT NULL DEFAULT '', + CHANGE PageUrl PageUrl varchar(255) NOT NULL DEFAULT '', + CHANGE RequestUrl RequestUrl varchar(255) NOT NULL DEFAULT '', + CHANGE CurlError CurlError varchar(255) NOT NULL DEFAULT '';