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 =