Index: trunk/core/install/install_schema.sql =================================================================== diff -u -N -r8029 -r8057 --- trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8029) +++ trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8057) @@ -344,8 +344,8 @@ l5_CachedNavbar text, CreatedById int(11) NOT NULL default '0', ResourceId int(11) default NULL, - ParentPath text NOT NULL, - NamedParentPath text NOT NULL, + ParentPath TEXT NULL DEFAULT NULL, + NamedParentPath TEXT NULL DEFAULT NULL, MetaDescription varchar(255) default NULL, HotItem int(11) NOT NULL default '2', NewItem int(11) NOT NULL default '2', Index: trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql =================================================================== diff -u -N -r8054 -r8057 --- trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8054) +++ trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8057) @@ -1,7 +1,7 @@ ALTER TABLE EmailMessage ADD ReplacementTags TEXT AFTER Template; ALTER TABLE Phrase CHANGE Translation Translation TEXT NOT NULL, CHANGE Module Module VARCHAR(30) NOT NULL DEFAULT 'In-Portal'; -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 l2_CachedNavbar text, CHANGE l3_CachedNavbar l3_CachedNavbar text, CHANGE l4_CachedNavbar l4_CachedNavbar text, CHANGE l5_CachedNavbar l5_CachedNavbar text; +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 l2_CachedNavbar text, CHANGE l3_CachedNavbar l3_CachedNavbar text, CHANGE l4_CachedNavbar l4_CachedNavbar text, CHANGE l5_CachedNavbar l5_CachedNavbar text, CHANGE ParentPath ParentPath TEXT NULL DEFAULT NULL, CHANGE NamedParentPath NamedParentPath TEXT NULL DEFAULT NULL; ALTER TABLE ConfigurationAdmin CHANGE ValueList ValueList TEXT; ALTER TABLE EmailQueue CHANGE `Subject` `Subject` TEXT, CHANGE toaddr toaddr TEXT, CHANGE fromaddr fromaddr TEXT; Index: trunk/core/install/upgrades.sql =================================================================== diff -u -N -r8048 -r8057 --- trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8048) +++ trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8057) @@ -25,7 +25,9 @@ CHANGE l2_CachedNavbar l2_CachedNavbar text, CHANGE l3_CachedNavbar l3_CachedNavbar text, CHANGE l4_CachedNavbar l4_CachedNavbar text, - CHANGE l5_CachedNavbar l5_CachedNavbar text; + CHANGE l5_CachedNavbar l5_CachedNavbar text, + CHANGE ParentPath ParentPath TEXT NULL DEFAULT NULL, + CHANGE NamedParentPath NamedParentPath TEXT NULL DEFAULT NULL; ALTER TABLE ConfigurationAdmin CHANGE ValueList ValueList TEXT;