On Mon, 23 Jun 2008, Benny Pedersen wrote:
>
> can one show me a working table to mysql 4.1.x and above
>
> README.sql-mysql does not work for msgs table
CREATE TABLE `msgs` (
`mail_id` varchar(12) NOT NULL default '',
`secret_id` varchar(12) default '',
`am_id` varchar(20) NOT NULL default '',
`time_num` int(10) unsigned NOT NULL default '0',
`time_iso` varchar(16) NOT NULL default '',
`sid` int(10) unsigned NOT NULL default '0',
`policy` varchar(255) default '',
`client_addr` varchar(255) default '',
`size` int(10) unsigned NOT NULL default '0',
`content` char(1) default NULL,
`quar_type` char(1) default NULL,
`dsn_sent` char(1) default NULL,
`spam_level` float default NULL,
`message_id` varchar(255) default '',
`from_addr` varchar(255) default '',
`subject` varchar(255) default '',
`host` varchar(255) NOT NULL default '',
`quar_loc` varchar(255) default '',
PRIMARY KEY (`mail_id`),
KEY `sid` (`sid`),
KEY `msgs_idx_sid` (`sid`),
KEY `msgs_idx_mess_id` (`message_id`),
KEY `msgs_idx_time_num` (`time_num`)
);
This works with mysql 5.0.22 included with centos 5.
Regards
James
>
>
> Benny Pedersen
> Need more webspace ? http://www.servage.net/?coupon=cust37098
>
>
> -------------------------------------------------------------------------
> 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
> AMaViS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
>
>
--
James Bourne | Email: [EMAIL PROTECTED]
UNIX Systems Administration | WWW: http://www.hardrock.org
Custom UNIX Programming | Linux: The choice of a GNU generation
----------------------------------------------------------------------
"All you need's an occasional kick in the philosophy." Frank Herbert
Need an inexpensive domain alternative? http://fastforwarddomains.com
-------------------------------------------------------------------------
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
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
