*users* table question

[Antoine Nguyen]

Le 01/07/2012 22:53, Mark Martinec a écrit :
>
> Well, yes. You are free to drop a DEFAULT attribute,
> or to provide some neutral policy record with id==1
> during installation.

I prefer the second solution. I guess a policy like the one below (taken 
from README.sql):

INSERT INTO policy (id, policy_name, virus_lover, spam_lover, 
bypass_virus_checks, bypass_spam_checks, spam_modifies_subj, 
spam_tag2_level, spam_kill_level) VALUES (1, 'default', NULL,NULL, 
NULL,NULL,
NULL, NULL, NULL)

could be a good choice ?

> Not really intentional. A '1' is not special or reserved.
> The DEFAULT is there for the sole purpose of making
> it easier to add new user records, without having
> to specify a policy_id with each insert for a
> common case.
>
>
Ok. So the default policy option is definitively the good one (at least 
for what I want to achieve).

Thanks for your answer!

-- 
Antoine Nguyen
Modoboa developer
http://modoboa.org/