[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}category
   2    ADD parentid INT(11) DEFAULT '0' NOT NULL,
   3    ADD category_left INT(11) DEFAULT '0' NOT NULL,
   4    ADD category_right INT(11) DEFAULT '0' NOT NULL;
   5  
   6  create table {PREFIX}entrycat (
   7    entryid int(11) not null,
   8    categoryid int(11) not null
   9  );
  10  
  11  INSERT INTO {PREFIX}entrycat (entryid, categoryid) SELECT id, categoryid FROM {PREFIX}entries;
  12  
  13  ALTER TABLE {PREFIX}entries DROP categoryid;
  14  
  15  ALTER TABLE {PREFIX}comments ADD parent_id int(10) {UNSIGNED} default '0' not null;