[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}comments ADD COLUMN oldip varchar(64);
   2  UPDATE {PREFIX}comments SET oldip = ip;
   3  ALTER TABLE {PREFIX}comments DROP ip;
   4  ALTER TABLE {PREFIX}comments ADD COLUMN ip varchar(64);
   5  UPDATE {PREFIX}comments SET ip = oldip;
   6  ALTER TABLE {PREFIX}comments DROP COLUMN oldip;
   7  
   8  ALTER TABLE {PREFIX}suppress ADD COLUMN oldip varchar(64);
   9  UPDATE {PREFIX}suppress SET oldip = ip;
  10  ALTER TABLE {PREFIX}suppress DROP ip;
  11  ALTER TABLE {PREFIX}suppress ADD COLUMN ip varchar(64);
  12  UPDATE {PREFIX}suppress SET ip = oldip;
  13  ALTER TABLE {PREFIX}suppress DROP COLUMN oldip;