Show initial_load.sql syntax highlighted
-- This file is part of AmavisAdmin
--
-- Copyright (C) 2007 Stephen Reindl
--
-- Perform an intial load for an empty database
-- insert standard policies.
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Non-paying', 'N','N','N','N', 'Y','Y','Y','N', 'Y', 3.0, 7, 10);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Uncensored', 'Y','Y','Y','Y', 'N','N','N','N', 'N', 3.0, 999, 999);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Wants all spam','N','Y','N','N', 'N','N','N','N', 'Y', 3.0, 999, 999);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Wants viruses', 'Y','N','Y','Y', 'N','N','N','N', 'Y', 3.0, 6.9, 6.9);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Normal', 'N','N','N','N', 'N','N','N','N', 'Y', 3.0, 6.9, 6.9);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Trigger happy', 'N','N','N','N', 'N','N','N','N', 'Y', 3.0, 5, 5);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('Permissive', 'N','N','N','Y', 'N','N','N','N', 'Y', 3.0, 10, 20);
INSERT
INTO policy
(policy_name, virus_lover, spam_lover, banned_files_lover,
bad_header_lover, bypass_virus_checks, bypass_spam_checks,
bypass_banned_checks, bypass_header_checks, spam_modifies_subj,
spam_tag_level, spam_tag2_level, spam_kill_level)
VALUES ('6.5/7.8', 'N','N','N','N', 'N','N','N','N', 'N', 3.0, 6.5, 7.8);
-- insert a catchall user that will be used to
-- define the profile in case no other match
-- was done.
INSERT
INTO users
(priority, policy_id, email, local)
SELECT id, 5, '@.', 'N'
FROM policy
WHERE policy_name = 'Normal';
See more files for this project here