Index: branches/5.0.x/core/install/upgrades.sql =================================================================== diff -u -N -r12641 -r12703 --- branches/5.0.x/core/install/upgrades.sql (.../upgrades.sql) (revision 12641) +++ branches/5.0.x/core/install/upgrades.sql (.../upgrades.sql) (revision 12703) @@ -1528,4 +1528,71 @@ CHANGE CachedTemplate CachedTemplate varchar(255) NOT NULL DEFAULT '', CHANGE ThemeId ThemeId int(10) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE UserSession CHANGE BrowserSignature BrowserSignature varchar(32) NOT NULL DEFAULT ''; \ No newline at end of file +ALTER TABLE UserSession CHANGE BrowserSignature BrowserSignature varchar(32) NOT NULL DEFAULT ''; + +ALTER TABLE ChangeLogs + CHANGE Changes Changes text NULL, + CHANGE OccuredOn OccuredOn INT(11) NULL DEFAULT NULL; + +ALTER TABLE EmailLog CHANGE EventParams EventParams text NULL; +ALTER TABLE FormFields CHANGE DefaultValue DefaultValue text NULL; +ALTER TABLE ImportCache CHANGE VarValue VarValue text NULL; +ALTER TABLE ImportScripts CHANGE Description Description text NULL; +ALTER TABLE PersistantSessionData CHANGE VariableValue VariableValue text NULL; + +ALTER TABLE Phrase + CHANGE `Translation` `Translation` text NULL, + CHANGE PhraseKey PhraseKey VARCHAR(255) NOT NULL DEFAULT '', + CHANGE LastChanged LastChanged INT(10) UNSIGNED NULL DEFAULT NULL; + +ALTER TABLE PhraseCache CHANGE PhraseList PhraseList text NULL; + +ALTER TABLE Stylesheets + CHANGE AdvancedCSS AdvancedCSS text NULL, + CHANGE LastCompiled LastCompiled INT(10) UNSIGNED NULL DEFAULT NULL; + +ALTER TABLE StylesheetSelectors + CHANGE SelectorData SelectorData text NULL, + CHANGE Description Description text NULL, + CHANGE AdvancedCSS AdvancedCSS text NULL; + +ALTER TABLE Category + CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '1', + CHANGE CreatedOn CreatedOn INT(11) NULL DEFAULT NULL, + CHANGE Modified Modified INT(11) NULL DEFAULT NULL; + +ALTER TABLE Language CHANGE UserDocsUrl UserDocsUrl VARCHAR(255) NOT NULL DEFAULT ''; + +ALTER TABLE MailingLists + CHANGE Subject Subject VARCHAR(255) NOT NULL DEFAULT '', + CHANGE EmailsQueued EmailsQueued INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE EmailsSent EmailsSent INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE EmailsTotal EmailsTotal INT(10) UNSIGNED NOT NULL DEFAULT '0'; + +ALTER TABLE EmailQueue + CHANGE MailingId MailingId INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE Queued Queued INT(10) UNSIGNED NULL DEFAULT NULL, + CHANGE LastSendRetry LastSendRetry INT(10) UNSIGNED NULL DEFAULT NULL; + +ALTER TABLE ImportScripts CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '1'; + +ALTER TABLE Semaphores + CHANGE SessionKey SessionKey INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `Timestamp` `Timestamp` INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE MainPrefix MainPrefix VARCHAR(255) NOT NULL DEFAULT ''; + +ALTER TABLE Skins + CHANGE LogoBottom LogoBottom VARCHAR(255) NOT NULL DEFAULT '', + CHANGE LogoLogin LogoLogin VARCHAR(255) NOT NULL DEFAULT ''; + +ALTER TABLE ItemReview CHANGE ReviewText ReviewText LONGTEXT NULL; +ALTER TABLE SessionData CHANGE VariableValue VariableValue LONGTEXT NULL; + +ALTER TABLE PortalUser + CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '1', + CHANGE Modified Modified INT(11) NULL DEFAULT NULL; + +ALTER TABLE ItemFiles CHANGE CreatedOn CreatedOn INT(11) UNSIGNED NULL DEFAULT NULL; +ALTER TABLE FormSubmissions CHANGE SubmissionTime SubmissionTime INT(11) NULL DEFAULT NULL; +ALTER TABLE SessionLogs CHANGE SessionStart SessionStart INT(11) NULL DEFAULT NULL; +ALTER TABLE Visits CHANGE VisitDate VisitDate INT(10) UNSIGNED NULL DEFAULT NULL; \ No newline at end of file