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#a12774615 Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
