[Sommaire] [Imprimer]

   1  CREATE TABLE {PREFIX}permalinks (
   2      permalink varchar(255) not null default '',
   3      entry_id int(10) {UNSIGNED} not null default '0',
   4      type varchar(200) not null default '',
   5      data text
   6  );
   7  
   8  CREATE INDEX pl_idx ON {PREFIX}permalinks (permalink);
   9  CREATE INDEX ple_idx ON {PREFIX}permalinks (entry_id);
  10  CREATE INDEX plt_idx ON {PREFIX}permalinks (type);
  11  CREATE INDEX plcomb_idx ON {PREFIX}permalinks (permalink, type);
  12  
  13  CREATE INDEX commentry_idx ON {PREFIX}comments (entry_id);
  14  CREATE INDEX commpentry_idx ON {PREFIX}comments (parent_id);
  15  CREATE INDEX commtype_idx ON {PREFIX}comments (type);
  16  CREATE INDEX commstat_idx ON {PREFIX}comments (status);
  17  
  18  CREATE INDEX edraft_idx ON {PREFIX}entries (isdraft);
  19  CREATE INDEX eauthor_idx ON {PREFIX}entries (authorid);
  20  
  21  CREATE INDEX refentry_idx ON {PREFIX}references (entry_id);
  22  
  23  CREATE INDEX exits_idx ON {PREFIX}exits (entry_id,day);
  24  
  25  CREATE INDEX referrers_idx ON {PREFIX}referrers (entry_id,day);
  26  CREATE INDEX urllast_idx on {PREFIX}suppress (last);
  27  CREATE INDEX pluginplace_idx ON {PREFIX}plugins (placement);
  28  
  29  CREATE INDEX categorya_idx ON {PREFIX}category (authorid);
  30  CREATE INDEX categoryp_idx ON {PREFIX}category (parentid);
  31  CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right);