Re: SQL Update

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