[Sommaire] [Imprimer]

   1  create table {PREFIX}tempauthors (
   2    realname varchar(255) NOT NULL default '',
   3    username varchar(20) default null,
   4    password varchar(32) default null,
   5    authorid {AUTOINCREMENT} {PRIMARY},
   6    mail_comments int(1) default '1',
   7    mail_trackbacks int(1) default '1',
   8    email varchar(128) not null default '',
   9    userlevel int(4) {UNSIGNED} not null default '0',
  10    right_publish int(1) default '1'
  11  );
  12  
  13  INSERT INTO {PREFIX}tempauthors (username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish) SELECT username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish FROM {PREFIX}authors;
  14  DROP TABLE {PREFIX}authors;
  15  
  16  create table {PREFIX}authors (
  17    realname varchar(255) NOT NULL default '',
  18    username varchar(20) default null,
  19    password varchar(32) default null,
  20    authorid {AUTOINCREMENT} {PRIMARY},
  21    mail_comments int(1) default '1',
  22    mail_trackbacks int(1) default '1',
  23    email varchar(128) not null default '',
  24    userlevel int(4) {UNSIGNED} not null default '0',
  25    right_publish int(1) default '1'
  26  );
  27  
  28  INSERT INTO {PREFIX}authors (username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish) SELECT username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish FROM {PREFIX}tempauthors;
  29  DROP TABLE {PREFIX}tempauthors;
  30  
  31  UPDATE {PREFIX}authors SET realname = username;