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

-- 
View this message in context: http://www.nabble.com/SQL-Update-tf2799494.html#a127746
15
Sent from the dbmail users mailing list archive at
Nabble.com.

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail