[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}category ADD COLUMN parentid INT4;
   2  ALTER TABLE {PREFIX}category ADD COLUMN category_left INT4;
   3  ALTER TABLE {PREFIX}category ADD COLUMN category_right INT4;
   4  UPDATE {PREFIX}category SET parentid=0, category_left=0, category_right=0;
   5  
   6  ALTER TABLE {PREFIX}category ALTER COLUMN parentid SET NOT NULL;
   7  ALTER TABLE {PREFIX}category ALTER COLUMN category_left SET NOT NULL;
   8  ALTER TABLE {PREFIX}category ALTER COLUMN category_right SET NOT NULL;
   9  
  10  CREATE TABLE {PREFIX}entrycat (
  11    entryid int4 not null,
  12    categoryid int4 not null
  13  );
  14  
  15  INSERT INTO {PREFIX}entrycat (entryid, categoryid)  (SELECT id, categoryid FROM {PREFIX}entries);
  16  
  17  ALTER TABLE {PREFIX}entries DROP COLUMN categoryid;
  18  
  19  ALTER TABLE {PREFIX}comments ADD COLUMN parent_id int4;
  20  UPDATE {PREFIX}comments SET parent_id=0;
  21  ALTER TABLE {PREFIX}comments ALTER COLUMN parent_id SET NOT NULL;