[Sommaire] [Imprimer]

   1  -- $Horde: horde/scripts/sql/horde_prefs.mssql.sql,v 1.1.2.2 2006/06/29 16:29:03 jan Exp $
   2  
   3  CREATE TABLE horde_prefs (
   4      pref_uid        VARCHAR(255) NOT NULL,
   5      pref_scope      VARCHAR(16) NOT NULL DEFAULT '',
   6      pref_name       VARCHAR(32) NOT NULL,
   7      pref_value      VARCHAR(MAX),
   8  --
   9      PRIMARY KEY (pref_uid, pref_scope, pref_name)
  10  );
  11  
  12  CREATE INDEX pref_uid_idx ON horde_prefs (pref_uid);
  13  CREATE INDEX pref_scope_idx ON horde_prefs (pref_scope);
  14  
  15  GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde;