[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/upgrades/2.2_to_3.0.oci8.sql,v 1.1.2.1 2006/04/06 22:53:40 jan Exp $
   2  
   3  ALTER TABLE horde_prefs MODIFY pref_uid VARCHAR2(255);
   4  ALTER TABLE horde_prefs MODIFY pref_scope VARCHAR2(16);
   5  ALTER TABLE horde_prefs MODIFY pref_name VARCHAR2(32);
   6  UPDATE horde_prefs SET pref_uid = RTRIM(pref_uid);
   7  UPDATE horde_prefs SET pref_scope = RTRIM(pref_scope);
   8  UPDATE horde_prefs SET pref_name = RTRIM(pref_name);
   9  
  10  DELETE FROM horde_prefs WHERE pref_name = 'last_login' AND pref_scope = 'imp';
  11  
  12  CREATE TABLE horde_datatree (
  13      datatree_id          NUMBER(16) NOT NULL,
  14      group_uid            VARCHAR2(255) NOT NULL,
  15      user_uid             VARCHAR2(255),
  16      datatree_name        VARCHAR2(255) NOT NULL,
  17      datatree_parents     VARCHAR2(255),
  18      datatree_order       NUMBER(16),
  19      datatree_data        CLOB,
  20      datatree_serialized  NUMBER(8) DEFAULT 0 NOT NULL,
  21      datatree_updated     DATE,
  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_order_idx ON horde_datatree (datatree_order);
  30  CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
  31  
  32  CREATE TABLE horde_datatree_attributes (
  33      datatree_id      NUMBER(16) NOT NULL,
  34      attribute_name   VARCHAR2(255) NOT NULL,
  35      attribute_key    VARCHAR2(255),
  36      attribute_value  VARCHAR2(4000)
  37  );
  38  
  39  CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
  40  CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
  41  CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
  42  
  43  CREATE TABLE horde_tokens (
  44      token_address    VARCHAR2(100) NOT NULL,
  45      token_id         VARCHAR2(32) NOT NULL,
  46      token_timestamp  NUMBER(16) NOT NULL,
  47  
  48      PRIMARY KEY (token_address, token_id)
  49  );
  50  
  51  CREATE TABLE horde_vfs (
  52      vfs_id        NUMBER(16) NOT NULL,
  53      vfs_type      NUMBER(8) NOT NULL,
  54      vfs_path      VARCHAR2(255),
  55      vfs_name      VARCHAR2(255) NOT NULL,
  56      vfs_modified  NUMBER(16) NOT NULL,
  57      vfs_owner     VARCHAR2(255),
  58      vfs_data      BLOB,
  59  
  60      PRIMARY KEY   (vfs_id)
  61  );
  62  
  63  CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
  64  CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);
  65