Paul J Stevens wrote:
Jorge Bastos wrote:
> I saw that there is a "update_headervalue_01.mysql" in svn,
> Should i run it? I have the last svn 2109.
If you use mysql (you do), and if your dbmail_headervalue.headervalue is
VARCHAR(255) (most likely) you should run it.
I am running dbmail 2.2.5 and I noticed too 'dbmail-2.2.5/sql/mysql/update_headervalue_01.mysql' file. However my 'dbmail_headervalue.headervalue' storagetype is already TEXT but there is index which I don't have. Same index is also missing from 'create_tables.mysql' file. The alter statement goes:
alter table dbmail_headervalue add index (headervalue(255));
What I should do about it?
My 'dbmail_headervalue' looks like this:
CREATE TABLE `dbmail_headervalue` (
`headername_id` bigint(20) NOT NULL,
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`headervalue` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`headername_id`,`headervalue`(255)),
KEY `headername_id` (`headername_id`),
KEY `physmessage_id_3` (`physmessage_id`),
CONSTRAINT `dbmail_headervalue_ibfk_1` FOREIGN KEY (`headername_id`) REFERENCES `dbmail_headername` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dbmail_headervalue_ibfk_2` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
regards,
petteri
Some parts of this message have been removed.
Learn more about Nabble's security policy.
