[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/horde_datatree.mssql.sql,v 1.1.2.2 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 VARCHAR(MAX),
  11      datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
  12  
  13      PRIMARY KEY (datatree_id)
  14  );
  15  
  16  CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
  17  CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
  18  CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
  19  CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
  20  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  21  
  22  
  23  CREATE TABLE horde_datatree_attributes (
  24      datatree_id INT NOT NULL,
  25      attribute_name VARCHAR(255) NOT NULL,
  26      attribute_key VARCHAR(255),
  27      attribute_value VARCHAR(MAX)
  28  );
  29  
  30  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  31  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  32  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  33  
  34  
  35  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde;
  36  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde;