[Sommaire] [Imprimer]

   1  # The table which holds the structure
   2  CREATE TABLE tb_nodes (
   3    STRID int(11) NOT NULL auto_increment,
   4    ROOTID int(11) NOT NULL default '0',
   5    l int(11) NOT NULL default '0',
   6    r int(11) NOT NULL default '0',
   7    PARENT int(11) NOT NULL default '0',
   8    STREH int(11) NOT NULL default '0',
   9    LEVEL int(11) NOT NULL default '0',
  10    STRNA char(128) NOT NULL default '',
  11    PRIMARY KEY  (STRID),
  12    KEY ROOTID (ROOTID),
  13    KEY STREH (STREH),
  14    KEY l (l),
  15    KEY r (r),
  16    KEY LEVEL (LEVEL),
  17    KEY SRLR (ROOTID,l,r),
  18    KEY parent (PARENT)
  19  ) TYPE=MyISAM COMMENT='NestedSet table';
  20  
  21  # A table which is used for a little table locking to avoid conflicts
  22  CREATE TABLE tb_locks (
  23    lockID char(32) NOT NULL default '',
  24    lockTable char(32) NOT NULL default '',
  25    lockStamp int(11) NOT NULL default '0',
  26    PRIMARY KEY  (lockID,lockTable)
  27  ) TYPE=MyISAM COMMENT='Table locks for NestedSet';
  28