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)
from me this feels a little to invasive, the last convertion took in summary 1 hour, i fear this would be increased a lot now | 2 | dbmail | localhost | dbmail | Query | 44 | copy to tmp table | ALTER TABLE dbmail_headervalue DROP FOREIGN KEY dbmail_headervalue_ibfk_1 | 2 | dbmail | localhost | dbmail | Query | 51 | copy to tmp table | ALTER TABLE dbmail_messageblks DROP FOREIGN KEY dbmail_messageblks_ibfk_1 Am 13.02.2012 11:58, schrieb ITronic Harald Leithner: > Hi, > > I hope thats correct. > > Harald > > Am 11.02.2012, 21:12 Uhr, schrieb Paul J Stevens <[email protected]>: > >> On 02/10/2012 10:04 PM, ITronic Harald Leithner wrote: >>> Hi, >>> >>> first there is an inconsistent in the create_table.sql and the upgrade >>> 2_2-3_0.sql >>> in create_table the some bigint columns are not unsigned for example: >>> part_id, physmessage_id, headername_id, headervalue_id >>> but in the upgrade file all bigint columns are unsigned, so I think that >>> all columns should be "BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0'". >>> >>> Second I created a upgrade sql which drops all foreign keys upgrades the >>> tables and add new keys. >>> I also changed most of the bigint(20) columns to bigint(20) UNSIGNED but >>> I'm sure if thats ok for Paul. >>> I hope that helps someone. If anyone confirms it functions maybe Paul >>> could add it to the packaged or I will add it to the wiki. >> >> Please don't use the wiki: send me git patches
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
