[Sommaire] [Imprimer]

   1  create table {PREFIX}entryproperties (
   2    entryid int(11) not null,
   3    property varchar(255) not null,
   4    value text
   5  );
   6  
   7  CREATE UNIQUE INDEX prop_idx ON {PREFIX}entryproperties (entryid, property);
   8  CREATE INDEX entrypropid_idx ON {PREFIX}entryproperties (entryid);