[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/upgrades/3.0_to_3.1.mysql.sql,v 1.1.2.1 2006/01/06 10:41:13 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> < 3.0_to_3.1.mysql.sql
   8  
   9  ALTER TABLE horde_users ADD COLUMN user_soft_expiration_date INT;
  10  ALTER TABLE horde_users ADD COLUMN user_hard_expiration_date INT;
  11  
  12  CREATE TABLE horde_histories (
  13      history_id       BIGINT NOT NULL,
  14      object_uid       VARCHAR(255) NOT NULL,
  15      history_action   VARCHAR(32) NOT NULL,
  16      history_ts       BIGINT NOT NULL,
  17      history_desc     TEXT,
  18      history_who      VARCHAR(255),
  19      history_extra    TEXT,
  20  --
  21      PRIMARY KEY (history_id)
  22  );
  23  
  24  CREATE INDEX history_action_idx ON horde_histories (history_action);
  25  CREATE INDEX history_ts_idx ON horde_histories (history_ts);
  26  CREATE INDEX history_uid_idx ON horde_histories (object_uid);
  27  
  28  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_histories TO horde@localhost;