File: spamd_sql.pgsql.sql

package info (click to toggle)
horde-sam 0.1-1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 1,292 kB
  • ctags: 363
  • sloc: php: 1,449; xml: 646; makefile: 64; sql: 60; sh: 30
file content (13 lines) | stat: -rw-r--r-- 409 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- $Horde: sam/scripts/sql/spamd_sql.pgsql.sql,v 1.1 2004/09/18 20:18:58 chuck Exp $

CREATE TABLE userpref (
    prefid      SERIAL,
    username    VARCHAR(255) NOT NULL,
    preference  VARCHAR(30) NOT NULL,
    value       VARCHAR(100) NOT NULL,

    PRIMARY KEY (prefid)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON userpref TO horde;
GRANT SELECT, INSERT, UPDATE, DELETE ON userpref_prefid_seq TO horde;