[Sommaire] [Imprimer]

   1  create table {PREFIX}access (
   2    groupid int(10) {UNSIGNED} not null default '0',
   3    artifact_id int(10) {UNSIGNED} not null default '0',
   4    artifact_type varchar(64) NOT NULL default '',
   5    artifact_mode varchar(64) NOT NULL default '',
   6    artifact_index varchar(64) NOT NULL default ''
   7  );
   8  
   9  CREATE INDEX accessgroup_idx ON {PREFIX}access(groupid);
  10  CREATE INDEX accessgroupT_idx ON {PREFIX}access(artifact_id,artifact_type,artifact_mode);
  11  CREATE INDEX accessforeign_idx ON {PREFIX}access(artifact_id);
  12