[Sommaire] [Imprimer]

   1  create table {PREFIX}tempgroupconfig (
   2    id int(10) {UNSIGNED} not null default '0',
   3    property varchar(128) default null,
   4    value varchar(32) default null
   5  ) {UTF_8};
   6  
   7  INSERT INTO {PREFIX}tempgroupconfig (id,property,value) SELECT id,property,value FROM {PREFIX}groupconfig;
   8  DROP TABLE {PREFIX}groupconfig;
   9  
  10  create table {PREFIX}groupconfig (
  11    id int(10) {UNSIGNED} not null default '0',
  12    property varchar(128) default null,
  13    value varchar(32) default null
  14  ) {UTF_8};
  15  
  16  CREATE INDEX groupid_idx ON {PREFIX}groupconfig (id);
  17  CREATE INDEX groupprop_idx ON {PREFIX}groupconfig (id, property);
  18  
  19  INSERT INTO {PREFIX}groupconfig (id,property,value) SELECT id,property,value FROM {PREFIX}tempgroupconfig;
  20  DROP TABLE {PREFIX}tempgroupconfig;