1CREATE TABLE {PREFIX}tempcategory ( 2 categoryid {AUTOINCREMENT} {PRIMARY}, 3 category_name varchar(255) default NULL, 4 category_icon varchar(255) default NULL, 5 category_description text, 6 authorid int(11) default NULL, 7 category_left int(11) default '0', 8 category_right int(11) default '0', 9 parentid int(11) DEFAULT '0' NOT NULL, 10 sort_order int(11), 11 hide_sub int(1) 12) {UTF_8}; 13 14INSERT INTO {PREFIX}tempcategory (categoryid, category_name, category_icon, category_description, authorid, category_left, category_right, parentid) SELECT categoryid, category_name, category_icon, category_description, authorid, category_left, category_right, parentid FROM {PREFIX}category; 15DROP TABLE {PREFIX}category; 16 17CREATE TABLE {PREFIX}category ( 18 categoryid {AUTOINCREMENT} {PRIMARY}, 19 category_name varchar(255) default NULL, 20 category_icon varchar(255) default NULL, 21 category_description text, 22 authorid int(11) default NULL, 23 category_left int(11) default '0', 24 category_right int(11) default '0', 25 parentid int(11) DEFAULT '0' NOT NULL, 26 sort_order int(11), 27 hide_sub int(1) 28) {UTF_8}; 29 30CREATE INDEX categorya_idx ON {PREFIX}category (authorid); 31CREATE INDEX categoryp_idx ON {PREFIX}category (parentid); 32CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right); 33CREATE INDEX categoryso_idx ON {PREFIX}category (sort_order); 34 35 36INSERT INTO {PREFIX}category (categoryid, category_name, category_icon, category_description, authorid, category_left, category_right, parentid) SELECT categoryid, category_name, category_icon, category_description, authorid, category_left, category_right, parentid FROM {PREFIX}tempcategory; 37DROP TABLE {PREFIX}tempcategory; 38 39UPDATE {PREFIX}category SET hide_sub =