[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/horde_histories.mssql.sql,v 1.1.2.1 2006/01/18 19:58:42 ben Exp $
   2  
   3  CREATE TABLE horde_histories (
   4      history_id       BIGINT NOT NULL,
   5      object_uid       VARCHAR(255) NOT NULL,
   6      history_action   VARCHAR(32) NOT NULL,
   7      history_ts       BIGINT NOT NULL,
   8      history_desc     VARCHAR(MAX),
   9      history_who      VARCHAR(255),
  10      history_extra    VARCHAR(MAX),
  11  --
  12      PRIMARY KEY (history_id)
  13  );
  14  
  15  CREATE INDEX history_action_idx ON horde_histories (history_action);
  16  CREATE INDEX history_ts_idx ON horde_histories (history_ts);
  17  CREATE INDEX history_uid_idx ON horde_histories (object_uid);
  18  
  19  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_histories TO horde;