← Back to branch summary

~ubuntu-branches/ubuntu/saucy/horde3/saucy

« back to all changes in this revision

Viewing changes to scripts/sql/horde_prefs.sql

  • Committer: Bazaar Package Importer
  • Author(s): Ola Lundqvist
  • Date: 2005-05-04 23:08:08 UTC
  • Revision ID: james.westby@ubuntu.com-20050504230808-p4hf3hk28o3v7wir
Tags: upstream-3.0.4
Import upstream version 3.0.4

Show diffs side-by-side

added added

removed removed

Lines of Context:
scripts/sql/horde_prefs.sql
 
1
-- $Horde: horde/scripts/sql/horde_prefs.sql,v 1.2 2004/09/21 03:34:06 chuck 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      TEXT,
 
8
--
 
9
    PRIMARY KEY (pref_uid, pref_scope, pref_name)
 
10
);
 
11
 
 
12
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde;