Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -N -r5110 -r5185 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 5110) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 5185) @@ -15,15 +15,25 @@ CREATE TABLE Category ( CategoryId int(11) NOT NULL auto_increment, - Type int(11) NOT NULL default '0', + `Type` int(11) NOT NULL default '0', ParentId int(11) NOT NULL default '0', Name varchar(255) NOT NULL default '', - Filename varchar(255) NOT NULL, + l1_Name varchar(255) NOT NULL default '', + l2_Name varchar(255) NOT NULL default '', + l3_Name varchar(255) NOT NULL default '', + l4_Name varchar(255) NOT NULL default '', + l5_Name varchar(255) NOT NULL default '', + Filename varchar(255) NOT NULL default '', AutomaticFilename tinyint(3) unsigned NOT NULL default '1', Description text NOT NULL, + l1_Description text NOT NULL, + l2_Description text NOT NULL, + l3_Description text NOT NULL, + l4_Description text NOT NULL, + l5_Description text NOT NULL, CreatedOn int(11) NOT NULL default '0', EditorsPick tinyint(4) NOT NULL default '0', - Status tinyint(4) NOT NULL default '0', + `Status` tinyint(4) NOT NULL default '0', Pop tinyint(4) default NULL, Priority int(11) NOT NULL default '0', MetaKeywords varchar(255) default NULL, @@ -44,13 +54,23 @@ CachedCategoryTemplate varchar(255) NOT NULL default '', CachedItemTemplate varchar(255) NOT NULL default '', PRIMARY KEY (CategoryId), - KEY ParentId (ParentId), UNIQUE KEY ResourceId (ResourceId), + KEY ParentId (ParentId), KEY Modified (Modified), KEY Priority (Priority), KEY sorting (Name,Priority), - KEY Filename (Filename(5)) -) + KEY Filename (Filename(5)), + KEY l1_Name (l1_Name(5)), + KEY l2_Name (l2_Name(5)), + KEY l3_Name (l3_Name(5)), + KEY l4_Name (l4_Name(5)), + KEY l5_Name (l5_Name(5)), + KEY l1_Description (l1_Description(5)), + KEY l2_Description (l2_Description(5)), + KEY l3_Description (l3_Description(5)), + KEY l4_Description (l4_Description(5)), + KEY l5_Description (l5_Description(5)) +) # --------------------------------------------------------