[Sommaire] [Imprimer]

   1  create table {PREFIX}groups (
   2    id {AUTOINCREMENT} {PRIMARY},
   3    name varchar(64) default null
   4  );
   5  
   6  create table {PREFIX}groupconfig (
   7    id int(10) {UNSIGNED} not null default '0',
   8    property varchar(64) default null,
   9    value varchar(128) default null
  10  );
  11  
  12  CREATE INDEX groupid_idx ON {PREFIX}groupconfig (id);
  13  CREATE INDEX groupprop_idx ON {PREFIX}groupconfig (id, property);
  14  
  15  create table {PREFIX}authorgroups (
  16    groupid int(10) {UNSIGNED} not null default '0',
  17    authorid int(10) {UNSIGNED} not null default '0'
  18  );
  19  
  20  CREATE INDEX authorgroup_idxA ON {PREFIX}authorgroups (groupid);
  21  CREATE INDEX authorgroup_idxB ON {PREFIX}authorgroups (authorid);