[Sommaire] [Imprimer]

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