Index: branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql =================================================================== diff -u -r7815 -r7816 --- branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql (.../upgrades.sql) (revision 7815) +++ branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql (.../upgrades.sql) (revision 7816) @@ -9,3 +9,32 @@ # ===== v 4.0.2 ===== ALTER TABLE EmailMessage ADD ReplacementTags TEXT AFTER Template; +ALTER TABLE Phrase CHANGE Translation Translation TEXT NOT NULL; +ALTER TABLE Category + CHANGE Description Description TEXT, + CHANGE l1_Description l1_Description TEXT, + CHANGE l2_Description l2_Description TEXT, + CHANGE l3_Description l3_Description TEXT, + CHANGE l4_Description l4_Description TEXT, + CHANGE l5_Description l5_Description TEXT, + CHANGE CachedNavbar CachedNavbar text, + CHANGE l1_CachedNavbar l1_CachedNavbar text, + CHANGE l2_CachedNavbar l1_CachedNavbar text, + CHANGE l3_CachedNavbar l1_CachedNavbar text, + CHANGE l4_CachedNavbar l1_CachedNavbar text, + CHANGE l5_CachedNavbar l1_CachedNavbar text; + +ALTER TABLE ConfigurationAdmin CHANGE ValueList ValueList TEXT; + +ALTER TABLE EmailQueue + CHANGE `Subject` `Subject` TEXT, + CHANGE toaddr toaddr TEXT, + CHANGE fromaddr fromaddr TEXT; + +ALTER TABLE Category DROP Pop; + +ALTER TABLE PortalUser + CHANGE CreatedOn CreatedOn INT NOT NULL DEFAULT '0', + CHANGE dob dob INT(11) NULL DEFAULT NULL, + CHANGE PassResetTime PassResetTime INT(11) UNSIGNED NULL DEFAULT NULL, + CHANGE PwRequestTime PwRequestTime INT(11) UNSIGNED NULL DEFAULT NULL; \ No newline at end of file