AFAIK this is from Fedora 10/11 2009 maybe they have backported constraints which was originally not there and with not exactly the same name :-(
dbmail_sievescripts | CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(10) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `script` text, `active` tinyint(3) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `dbmail_sievescripts_1` (`owner_idnr`,`name`), KEY `name` (`name`), KEY `owner_idnr` (`owner_idnr`), CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; Am 13.02.2012 16:18, schrieb ITronic Harald Leithner: > Can you show me your create statement for dbmail_sievescripts? > > Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald <h.rei...@thelounge.net>: > >> >> >> Am 13.02.2012 15:35, schrieb Paul J Stevens: >>> On 02/13/2012 03:24 PM, Reindl Harald wrote: >>>> hi >>>> >>>> is there a really good reason dropping all foreign keys >>>> and create them new? this queries are running a very >>>> long time (i am testing your convert-sql this moment) >>> >>> >>> This script was changed to be more robust in the face of slightly >>> different BIGINT columns. >>> >>> Changing the widths on columns involved in key constraints is only >>> possible after first dropping the key entirely. >>> >>> If the 'old' script (pre-today) worked for you: use that. >> >> i will play around, something does not work here with the new one >> transition is running, time measure later >> >> [root@dbmail-test:/data/dbmail3-migration]$ ./convert.sh >> ERROR 1091 (42000) at line 200: Can't DROP 'owner_idnr_2'; check that >> column/key exists > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail