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
>