[Sommaire] [Imprimer]

   1  CREATE 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  
  14  INSERT 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;
  15  DROP TABLE {PREFIX}category;
  16  
  17  CREATE 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  
  30  CREATE INDEX categorya_idx ON {PREFIX}category (authorid);
  31  CREATE INDEX categoryp_idx ON {PREFIX}category (parentid);
  32  CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right);
  33  CREATE INDEX categoryso_idx ON {PREFIX}category (sort_order);
  34  
  35  
  36  INSERT 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;
  37  DROP TABLE {PREFIX}tempcategory;
  38  
  39  UPDATE {PREFIX}category SET hide_sub =