[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/upgrades/3.0_to_3.1.sql,v 1.1.2.1 2006/03/29 21:27:52 jan Exp $
   2  
   3  ALTER TABLE horde_users ADD COLUMN user_soft_expiration_date INT;
   4  ALTER TABLE horde_users ADD COLUMN user_hard_expiration_date INT;
   5  
   6  CREATE TABLE horde_histories (
   7      history_id       BIGINT NOT NULL,
   8      object_uid       VARCHAR(255) NOT NULL,
   9      history_action   VARCHAR(32) NOT NULL,
  10      history_ts       BIGINT NOT NULL,
  11      history_desc     TEXT,
  12      history_who      VARCHAR(255),
  13      history_extra    TEXT,
  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);