[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}authors ADD COLUMN oldusername varchar(32);
   2  UPDATE {PREFIX}authors SET oldusername = username;
   3  ALTER TABLE {PREFIX}authors DROP username;
   4  
   5  ALTER TABLE {PREFIX}authors ADD COLUMN username varchar(32);
   6  UPDATE {PREFIX}authors SET username = oldusername;
   7  ALTER TABLE {PREFIX}authors DROP COLUMN oldusername;