CREATE DATABASE IF NOT EXISTS spamassassin;

USE spamassassin;

CREATE TABLE IF NOT EXISTS userpref (
  horde_id varchar(255) NOT NULL default '',
  username varchar(100) NOT NULL default '',
  preference varchar(30) NOT NULL default '',
  value varchar(100) NOT NULL default '',
  prefid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (prefid),
  KEY username (username)
) TYPE=MyISAM;

INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'required_hits', '5', 1);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'spam_level_stars', '1', 3);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'report_header', '1', 4);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'defang_mime', '0', 5);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'use_terse_report', '0', 6);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'skip_rbl_checks', '0', 7);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'subject_tag', '*****SPAM*****', 8);
INSERT INTO userpref VALUES ('@GLOBAL', '@GLOBAL', 'rewrite_subject', '1', 2);