[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/upgrades/3.0_to_3.1.oci8.sql,v 1.1.2.1 2006/04/06 22:53:54 jan Exp $
   2  
   3  ALTER TABLE horde_users ADD user_soft_expiration_date NUMBER(16);
   4  ALTER TABLE horde_users ADD user_hard_expiration_date NUMBER(16);
   5  
   6  CREATE TABLE horde_histories (
   7      history_id       NUMBER(16) NOT NULL,
   8      object_uid       VARCHAR2(255) NOT NULL,
   9      history_action   VARCHAR2(32) NOT NULL,
  10      history_ts       NUMBER(16) NOT NULL,
  11      history_desc     CLOB,
  12      history_who      VARCHAR2(255),
  13      history_extra    CLOB,
  14  
  15      PRIMARY KEY (history_id)
  16  );
  17  
  18  CREATE INDEX history_action_idx ON horde_histories (history_action);
  19  CREATE INDEX history_ts_idx ON horde_histories (history_ts);
  20  CREATE INDEX history_uid_idx ON horde_histories (object_uid);