[Sommaire] [Imprimer]

   1  create table {PREFIX}tempcomments (
   2    id {AUTOINCREMENT} {PRIMARY},
   3    entry_id int(10) {UNSIGNED} not null default '0',
   4    parent_id int(10) {UNSIGNED} not null default '0',
   5    timestamp int(10) {UNSIGNED} default null,
   6    title varchar(150) default null,
   7    author varchar(80) default null,
   8    email varchar(200) default null,
   9    url varchar(200) default null,
  10    ip varchar(15) default null,
  11    body text,
  12    type varchar(100) default 'regular',
  13    subscribed {BOOLEAN},
  14    status varchar(50) not null
  15  );
  16  
  17  INSERT INTO {PREFIX}tempcomments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}comments;
  18  DROP TABLE {PREFIX}comments;
  19  
  20  create table {PREFIX}comments (
  21    id {AUTOINCREMENT} {PRIMARY},
  22    entry_id int(10) {UNSIGNED} not null default '0',
  23    parent_id int(10) {UNSIGNED} not null default '0',
  24    timestamp int(10) {UNSIGNED} default null,
  25    title varchar(150) default null,
  26    author varchar(80) default null,
  27    email varchar(200) default null,
  28    url varchar(200) default null,
  29    ip varchar(15) default null,
  30    body text,
  31    type varchar(100) default 'regular',
  32    subscribed {BOOLEAN},
  33    status varchar(50) not null,
  34    referer varchar(200) default null
  35  );
  36  
  37  INSERT INTO {PREFIX}comments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}tempcomments;
  38  DROP TABLE {PREFIX}tempcomments;