[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/create.sql,v 1.1.2.3 2006/05/22 21:27:33 jan Exp $
   2  
   3  CREATE TABLE horde_users (
   4      user_uid                    VARCHAR(255) NOT NULL,
   5      user_pass                   VARCHAR(255) NOT NULL,
   6      user_soft_expiration_date   INTEGER,
   7      user_hard_expiration_date   INTEGER,
   8  --
   9      PRIMARY KEY (user_uid)
  10  );
  11  
  12  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_users TO horde;
  13  
  14  
  15  CREATE TABLE horde_prefs (
  16      pref_uid        VARCHAR(255) NOT NULL,
  17      pref_scope      VARCHAR(16) DEFAULT '' NOT NULL,
  18      pref_name       VARCHAR(32) NOT NULL,
  19      pref_value      TEXT,
  20  --
  21      PRIMARY KEY (pref_uid, pref_scope, pref_name)
  22  );
  23  
  24  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde;
  25  
  26  
  27  CREATE TABLE horde_datatree (
  28      datatree_id INT NOT NULL,
  29      group_uid VARCHAR(255) NOT NULL,
  30      user_uid VARCHAR(255) NOT NULL,
  31      datatree_name VARCHAR(255) NOT NULL,
  32      datatree_parents VARCHAR(255) NOT NULL,
  33      datatree_order INT,
  34  
  35  -- There is no portable way to do this apparently. If your db doesn't
  36  -- allow TEXT columns, then maybe it allows large VARCHAR columns, so
  37  -- try the second line.
  38  --
  39      datatree_data TEXT,
  40  --  datatree_data VARCHAR(4096),
  41  
  42      datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
  43  
  44      PRIMARY KEY (datatree_id)
  45  );
  46  
  47  CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
  48  CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
  49  CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
  50  CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
  51  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  52  
  53  CREATE TABLE horde_datatree_attributes (
  54      datatree_id INT NOT NULL,
  55      attribute_name VARCHAR(255) NOT NULL,
  56      attribute_key VARCHAR(255),
  57      attribute_value TEXT
  58  );
  59  
  60  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  61  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  62  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  63  
  64  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde;
  65  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde;
  66  
  67  
  68  CREATE TABLE horde_tokens (
  69      token_address    VARCHAR(100) NOT NULL,
  70      token_id         VARCHAR(32) NOT NULL,
  71      token_timestamp  BIGINT NOT NULL,
  72  --
  73      PRIMARY KEY (token_address, token_id)
  74  );
  75  
  76  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_tokens TO horde;
  77  
  78  
  79  CREATE TABLE horde_vfs (
  80      vfs_id        BIGINT NOT NULL,
  81      vfs_type      SMALLINT NOT NULL,
  82      vfs_path      VARCHAR(255) NOT NULL,
  83      vfs_name      VARCHAR(255) NOT NULL,
  84      vfs_modified  BIGINT NOT NULL,
  85      vfs_owner     VARCHAR(255) NOT NULL,
  86      vfs_data      LONGBLOB,
  87  -- Or, on some DBMS systems:
  88  --  vfs_data      IMAGE,
  89      PRIMARY KEY   (vfs_id)
  90  );
  91  
  92  CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
  93  CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);
  94  
  95  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_vfs TO horde;
  96  
  97  
  98  CREATE TABLE horde_histories (
  99      history_id       BIGINT NOT NULL,
 100      object_uid       VARCHAR(255) NOT NULL,
 101      history_action   VARCHAR(32) NOT NULL,
 102      history_ts       BIGINT NOT NULL,
 103      history_desc     TEXT,
 104      history_who      VARCHAR(255),
 105      history_extra    TEXT,
 106  --
 107      PRIMARY KEY (history_id)
 108  );
 109  
 110  CREATE INDEX history_action_idx ON horde_histories (history_action);
 111  CREATE INDEX history_ts_idx ON horde_histories (history_ts);
 112  CREATE INDEX history_uid_idx ON horde_histories (object_uid);
 113  
 114  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_histories TO horde;
 115  
 116  
 117  CREATE TABLE horde_sessionhandler (
 118      session_id             VARCHAR(32) NOT NULL,
 119      session_lastmodified   INT NOT NULL,
 120      session_data           LONGBLOB,
 121  -- Or, on some DBMS systems:
 122  --  session_data           IMAGE,
 123  
 124      PRIMARY KEY (session_id)
 125  );
 126  
 127  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO horde;