[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/horde_datatree.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  
  11  -- There is no portable way to do this apparently. If your db doesn't
  12  -- allow TEXT columns, then maybe it allows large VARCHAR columns, so
  13  -- try the second line.
  14  --
  15      datatree_data TEXT,
  16  --  datatree_data VARCHAR(4096),
  17  
  18      datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
  19  
  20      PRIMARY KEY (datatree_id)
  21  );
  22  
  23  CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
  24  CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
  25  CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
  26  CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
  27  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  28  
  29  
  30  CREATE TABLE horde_datatree_attributes (
  31      datatree_id INT NOT NULL,
  32      attribute_name VARCHAR(255) NOT NULL,
  33      attribute_key VARCHAR(255),
  34      attribute_value TEXT
  35  );
  36  
  37  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  38  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  39  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  40  
  41  
  42  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde;
  43  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde;