[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}images ADD COLUMN oldmime varchar(15);
   2  UPDATE {PREFIX}images SET oldmime = mime;
   3  ALTER TABLE {PREFIX}images DROP mime;
   4  
   5  ALTER TABLE {PREFIX}images ADD COLUMN mime varchar(255);
   6  UPDATE {PREFIX}images SET mime = oldmime;
   7  ALTER TABLE {PREFIX}images DROP COLUMN oldmime;
   8  ALTER TABLE {PREFIX}images ALTER COLUMN mime SET NOT NULL;
   9