[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/horde_datatree.mysql.sql,v 1.1.10.1 2006/05/22 21:27:33 jan Exp $
   2  
   3  CREATE TABLE horde_datatree (
   4         datatree_id INT NOT NULL,
   5         group_uid VARCHAR(255) NOT NULL,
   6         user_uid VARCHAR(255) NOT NULL,
   7         datatree_name VARCHAR(255) NOT NULL,
   8         datatree_parents VARCHAR(255) NOT NULL,
   9         datatree_order INT,
  10         datatree_data TEXT,
  11         datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
  12         PRIMARY KEY (datatree_id)
  13  );
  14  
  15  CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
  16  CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
  17  CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
  18  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  19  
  20  CREATE TABLE horde_datatree_attributes (
  21      datatree_id INT NOT NULL,
  22      attribute_name VARCHAR(255) NOT NULL,
  23      attribute_key VARCHAR(255) DEFAULT '' NOT NULL,
  24      attribute_value TEXT
  25  );
  26  
  27  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  28  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  29  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  30  
  31  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde@localhost;
  32  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde@localhost;