[Sommaire] [Imprimer]

   1  create table {PREFIX}mediaproperties (
   2    mediaid int(11) not null,
   3    property varchar(128) not null,
   4    property_group varchar(50) not null default '',
   5    property_subgroup varchar(50) not null default '',
   6    value text
   7  ) {UTF_8};
   8  
   9  CREATE INDEX mediapropid_idx ON {PREFIX}mediaproperties (mediaid);
  10  CREATE UNIQUE INDEX media_idx ON {PREFIX}mediaproperties (mediaid, property, property_group, property_subgroup);