[Sommaire] [Imprimer]

   1  ###################################################################################
   2  sql for mysql
   3  
   4  drop table if exists ezimage;
   5  CREATE TABLE ezimage (
   6  contentobject_attribute_id int not null,
   7  version int not null,
   8  filename varchar(255) not null,
   9  original_filename varchar(255) not null,
  10  mime_type varchar(50) not null,
  11  primary key(contentobject_attribute_id, version) );
  12  
  13  drop table if exists ezimagevariation;
  14  create table ezimagevariation (
  15  contentobject_attribute_id int not null,
  16  version int not null,
  17  filename varchar( 255 ) not null,
  18  additional_path varchar( 255 ),
  19  requested_width int not null,
  20  requested_height int not null,
  21  width int not null,
  22  height int not null,
  23  primary key( contentobject_attribute_id,version,requested_width,requested_height) );
  24  
  25  ###################################################################################
  26  sql for postgresql
  27  /*
  28  Image
  29  */
  30  drop table ezimage;
  31  CREATE TABLE ezimage (
  32  contentobject_attribute_id int not null,
  33  version int not null,
  34  filename varchar(255) not null,
  35  original_filename varchar(255) not null,
  36  mime_type varchar(50) not null,
  37  primary key(contentobject_attribute_id,version) );
  38  
  39  drop table ezimagevariation;
  40  create table ezimagevariation (
  41  contentobject_attribute_id int not null,
  42  version int not null,
  43  filename varchar( 255 ) not null,
  44  additional_path varchar( 255 ),
  45  requested_width int not null,
  46  requested_height int not null,
  47  width int not null,
  48  height int not null,
  49  primary key( contentobject_attribute_id,version,requested_width,requested_height) );
  50  
  51  ###################################################################################
  52  sql for oracle
  53  
  54  /*
  55  Image
  56  */
  57  drop table ezimage;
  58  CREATE TABLE ezimage (
  59  contentobject_attribute_id int not null,
  60  version int not null,
  61  filename varchar(255) not null,
  62  original_filename varchar(255) not null,
  63  mime_type varchar(50) not null,
  64  primary key(contentobject_attribute_id,version) );
  65  
  66  drop table ezimagevariation;
  67  create table ezimagevariation (
  68  contentobject_attribute_id int not null,
  69  version int not null,
  70  filename varchar( 255 ) not null,
  71  additional_path varchar( 255 ),
  72  requested_width int not null,
  73  requested_height int not null,
  74  width int not null,
  75  height int not null,
  76  primary key( contentobject_attribute_id,version,requested_width,requested_height) );