Hello Guys,
When trying to create tables according to README.sql-mysql that
ships with amavisd-2.6.0, i have some troubles. After some researching,
i found that the problem was on the foreign key on msg table(sid field),
which references maddr (id field).
maddr.id is created with bigint unsigned and msg.sid is created with
integer unsigned. Columns being created with different data types do not
allow them to be linked in foreign key.
interesting is that web documentation, located on
http://www.ijs.si/software/amavisd/README.sql-mysql.txt
is different from README.sql-mysql shipped with 2.6.0. On the web
document, everything is created with integer unsigned field .... but
that document seems to be not updated, as table definitions have some
differences from the 2.6.0 shipped one and the web available one.
on the 2.6.0 shipped, maddr has the partition_tag column, which does
not exists on web available one. So, seems web document is not updated ....
Changing 'bigint unsigned' to 'integer unsigned' on msg table
definition, all the rest works fine.
But i think bigint is there for some reason .....
could you investigate that please ??? the document, as shipped with
2.6.0, is not working because this bigint/integer difference thing.
--
Atenciosamente / Sincerily,
Leonardo Rodrigues
Solutti Tecnologia
http://www.solutti.com.br
Minha armadilha de SPAM, NÃO mandem email
[EMAIL PROTECTED]
My SPAMTRAP, do not email it
-------------------------------------------------------------------------
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/
