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