-- $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;
