README.sql-mysql.txt

[Luigi Rosa]

In MySQL Readme file the "INSERT INTO policy" query refers to a 
"spam_modifies_subj" field no longer present in policy table

A valid version of the query without that field is:

  INSERT INTO policy (id, 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_tag_level, spam_tag2_level, spam_kill_level) VALUES
   (1, 'Non-paying',    'N','N','N','N', 'Y','Y','Y','N', 3.0,   7, 10),
   (2, 'Uncensored',    'Y','Y','Y','Y', 'N','N','N','N', 3.0, 999, 999),
   (3, 'Wants all spam','N','Y','N','N', 'N','N','N','N', 3.0, 999, 999),
   (4, 'Wants viruses', 'Y','N','Y','Y', 'N','N','N','N', 3.0, 6.9, 6.9),
   (5, 'Normal',        'N','N','N','N', 'N','N','N','N', 3.0, 6.9, 6.9),
   (6, 'Trigger happy', 'N','N','N','N', 'N','N','N','N', 3.0,   5, 5),
   (7, 'Permissive',    'N','N','N','Y', 'N','N','N','N', 3.0,  10, 20),
   (8, '6.5/7.8',       'N','N','N','N', 'N','N','N','N', 3.0, 6.5, 7.8),
   (9, 'userB',         'N','N','N','Y', 'N','N','N','N', 3.0, 6.3, 6.3),
   (10,'userC',         'N','N','N','N', 'N','N','N','N', 3.0, 6.0, 6.0),
   (11,'userD',         'Y','N','Y','Y', 'N','N','N','N', 3.0,   7, 7);


(remove the char value before 3.0)



Ciao,
luigi

-- 
/
+--[Luigi Rosa]--
\

It is by will alone I set my mind in motion. It is by the juice of
Sapho that thoughts acquire speed, the lips acquire stains.
The stains become a warning.
It is by will alone I set my mind in motion.
        --Mentat mantra, Frank Herbert, "Dune"