petteri larjos wrote: > > 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:
No it's not missing. Look again: > > 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)), there you go. > 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 > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
