[Sommaire] [Imprimer]

   1  create table {PREFIX}tempplugins (
   2    name varchar(128) not null,
   3    placement varchar(6) not null default 'right',
   4    sort_order int(4) not null default '0',
   5    authorid int(11) default '0',
   6    PRIMARY KEY(name)
   7  );
   8  
   9  INSERT INTO {PREFIX}tempplugins (name, placement, sort_order, authorid) SELECT name, placement, sort_order, authorid FROM {PREFIX}plugins;
  10  DROP TABLE {PREFIX}plugins;
  11  
  12  create table {PREFIX}plugins (
  13    name varchar(128) not null,
  14    placement varchar(6) not null default 'right',
  15    sort_order int(4) not null default '0',
  16    authorid int(11) default '0',
  17    path varchar(255) default null,
  18    PRIMARY KEY(name)
  19  );
  20  
  21  INSERT INTO {PREFIX}plugins (name, placement, sort_order, authorid) SELECT name, placement, sort_order, authorid FROM {PREFIX}tempplugins;
  22  DROP TABLE {PREFIX}tempplugins;