[Sommaire] [Imprimer]

   1  CREATE TABLE {PREFIX}tempimages (
   2    id {AUTOINCREMENT} {PRIMARY},
   3    name varchar(255) not null default '',
   4    extension varchar(5) not null default '',
   5    mime varchar(255) not null default '',
   6    size int(11) not null default '0',
   7    dimensions_width int(11) not null default '0',
   8    dimensions_height int(11) not null default '0',
   9    date int(11) not null default '0',
  10    thumbnail_name varchar(255) not null default '',
  11    authorid int(11) default '0',
  12    path text,
  13    hotlink int(1)
  14  );
  15  
  16  INSERT INTO {PREFIX}tempimages (id, name, extension, mime, size, dimensions_width, dimensions_height, date, thumbnail_name, authorid, path) SELECT id, name, extension, mime, size, dimensions_width, dimensions_height, date, thumbnail_name, authorid, path FROM {PREFIX}images;
  17  DROP TABLE {PREFIX}images;
  18  
  19  CREATE TABLE {PREFIX}images (
  20    id {AUTOINCREMENT} {PRIMARY},
  21    name varchar(255) not null default '',
  22    extension varchar(5) not null default '',
  23    mime varchar(255) not null default '',
  24    size int(11) not null default '0',
  25    dimensions_width int(11) not null default '0',
  26    dimensions_height int(11) not null default '0',
  27    date int(11) not null default '0',
  28    thumbnail_name varchar(255) not null default '',
  29    authorid int(11) default '0',
  30    path text,
  31    hotlink int(1)
  32  );
  33  
  34  INSERT INTO {PREFIX}images (id, name, extension, mime, size, dimensions_width, dimensions_height, date, thumbnail_name, authorid, path) SELECT id, name, extension, mime, size, dimensions_width, dimensions_height, date, thumbnail_name, authorid, path FROM {PREFIX}tempimages;
  35  DROP TABLE {PREFIX}tempimages;