As we are talking about "better default db schemas" here some other
suggestions:
In current MySQL releases the following statements are true when using
CHAR datatypes:
"v" = "V"
BINARY("v") != BINARY("V")
As functions usually make all SQL searches on indexed fields slower I
decided to use
content binary(1), --- there can be 's' and 'S'
and
mail_id varbinary(12), --- otherwise not using BINARY() could lead
--- to unexpected behaviour for third-party
--- apps
One could also add
quar_type binary(1),
even if it is it not really needed right now.
Cheers,
Thomas Gelf
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
