[Sommaire] [Imprimer]

   1  -- You can simply execute this file in your database.
   2  --
   3  -- Run as:
   4  --
   5  -- $ psql <db name> -f 2.2_to_3.0.postgresql.sql
   6  
   7  BEGIN;
   8  ALTER TABLE horde_prefs ADD COLUMN pref_uid_new VARCHAR(200);
   9  UPDATE horde_prefs SET pref_uid_new = pref_uid;
  10  ALTER TABLE horde_prefs DROP pref_uid;
  11  ALTER TABLE horde_prefs RENAME pref_uid_new TO pref_uid;
  12  ALTER TABLE horde_prefs ALTER COLUMN pref_uid SET NOT NULL;
  13  COMMIT;
  14  DELETE FROM horde_prefs WHERE pref_name = 'last_login' AND pref_scope = 'imp';
  15  
  16  CREATE TABLE horde_datatree (
  17         datatree_id INT NOT NULL,
  18         group_uid VARCHAR(255) NOT NULL,
  19         user_uid VARCHAR(255) NOT NULL,
  20         datatree_name VARCHAR(255) NOT NULL,
  21         datatree_parents VARCHAR(255) NOT NULL,
  22         datatree_order INT,
  23         datatree_data TEXT,
  24         datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
  25         datatree_updated TIMESTAMP,
  26  
  27         PRIMARY KEY (datatree_id)
  28  );
  29  
  30  CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
  31  CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
  32  CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
  33  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  34  
  35  CREATE TABLE horde_datatree_attributes (
  36      datatree_id INT NOT NULL,
  37      attribute_name VARCHAR(255) NOT NULL,
  38      attribute_key VARCHAR(255) DEFAULT '' NOT NULL,
  39      attribute_value TEXT
  40  );
  41  
  42  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  43  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  44  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  45  
  46  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde;
  47  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde;
  48  
  49  CREATE TABLE horde_tokens (
  50      token_address    VARCHAR(8) NOT NULL,
  51      token_id         VARCHAR(32) NOT NULL,
  52      token_timestamp  BIGINT NOT NULL,
  53  
  54      PRIMARY KEY (token_address, token_id)
  55  );
  56  
  57  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_tokens TO horde;
  58  
  59  CREATE TABLE horde_vfs (
  60      vfs_id        BIGINT NOT NULL,
  61      vfs_type      SMALLINT NOT NULL,
  62      vfs_path      VARCHAR(255) NOT NULL,
  63      vfs_name      VARCHAR(255) NOT NULL,
  64      vfs_modified  BIGINT NOT NULL,
  65      vfs_owner     VARCHAR(255) NOT NULL,
  66      vfs_data      TEXT,
  67  
  68      PRIMARY KEY   (vfs_id)
  69  );
  70  
  71  CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
  72  CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);
  73  
  74  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_vfs TO horde;
  75