The following fails because it used add column laborsoldprice after 'partsinvoiced' — partsinvoiced has already been dropped right before…
Seems to me that drops need to happen after adds to resolve this problem.
It would also be very useful to sync multiple databases to one “master structure”.
Thanks
Tom
mysql> alter table `andrewsofprinceton`.`invoices`,
-> drop column `partsinvoiced`,
-> add column `partssoldprice` double NOT NULL DEFAULT '0' after `totalcost`,
-> drop column `laborinvoiced`,
-> add column `laborsoldprice` double NOT NULL DEFAULT '0' after `partsinvoiced`,
-> drop column `subletsinvoiced`,
-> add column `subletssoldprice` double NOT NULL DEFAULT '0' after `laborinvoiced`,
-> drop column `feesinvoiced`,
-> add column `feessoldprice` double NOT NULL DEFAULT '0' after `subletsinvoiced`,
-> drop column `totalinvoiced`,
-> add column `totalsoldprice` double NOT NULL DEFAULT '0' after `feesinvoiced`,
-> drop column `totalinvoicedtax`,
-> add column `totalsoldpricetax` double NOT NULL DEFAULT '0' after `totalinvoiced`,
-> drop column `totalinvoicedandtaxed`,
-> add column `totalsoldpriceandtaxed` double NOT NULL DEFAULT '0' after `totalinvoicedtax`,
-> add column `laborsoldpricequantity` double NOT NULL DEFAULT '0' after `totalinvoicedandtaxed`;
