Код: Выделить всё
ALTER TABLE docs_acct ADD COLUMN `deposit` double(15,6) NOT NULL default '0.000000';
ALTER TABLE docs_acct ADD COLUMN `delivery_status` tinyint(2) unsigned NOT NULL default '0';
ALTER TABLE `docs_invoice_orders` ADD COLUMN `fees_id` int(11) unsigned NOT NULL default 0;
ALTER TABLE `docs_invoice_orders` ADD key fees_id (fees_id);
ALTER TABLE `docs_invoices` ADD COLUMN `deposit` double(15,6) NOT NULL default '0.000000';
ALTER TABLE `docs_invoices` ADD COLUMN `delivery_status` tinyint(2) unsigned NOT NULL default '0';
ALTER TABLE `docs_acct` ADD COLUMN `currency` smallint unsigned NOT NULL default 0;
ALTER TABLE `docs_acct_orders` ADD COLUMN `fees_id` int(11) unsigned NOT NULL default 0;
RENAME TABLE docs_invoice TO docs_receipts;
RENAME TABLE docs_invoice_orders TO docs_receipt_orders;
ALTER TABLE docs_receipts CHANGE COLUMN invoice_id receipt_num int(10) unsigned NOT NULL default '0';
ALTER TABLE docs_receipt_orders CHANGE COLUMN invoice_id receipt_id int(11) unsigned NOT NULL default '0';
ALTER TABLE docs_receipt_orders DROP KEY invoice_id;
ALTER TABLE docs_receipt_orders ADD KEY receipt_id (receipt_id);
RENAME TABLE docs_acct TO docs_invoices;
RENAME TABLE docs_acct_orders TO docs_invoice_orders;
ALTER TABLE docs_invoices CHANGE COLUMN acct_id invoice_num int(10) unsigned NOT NULL default '0';
ALTER TABLE docs_invoice_orders CHANGE COLUMN acct_id invoice_id int(10) unsigned NOT NULL default '0';
ALTER TABLE docs_invoice_orders DROP KEY aid;
ALTER TABLE docs_invoice_orders ADD KEY invoice_id (invoice_id);
ALTER TABLE payments ADD COLUMN currency smallint unsigned not null default 0;
ALTER TABLE payments ADD COLUMN amount double(10,2) NOT NULL default '0.00';
ALTER TABLE `docs_main` ADD COLUMN `invoice_date` date NOT NULL default '0000-00-00';
ALTER TABLE `docs_receipts` ADD COLUMN `exchange_rate` double(12,4) NOT NULL default '0.0000';
ALTER TABLE `docs_receipts` ADD COLUMN `currency` smallint(6) unsigned NOT NULL default 0;
ALTER TABLE `docs_invoices` ADD COLUMN `exchange_rate` double(12,4) NOT NULL default '0.0000';
ALTER TABLE `docs_invoices` ADD COLUMN `currency` smallint unsigned NOT NULL default 0;Вы пытаетесь добавить
ALTER TABLE `docs_invoices` ADD COLUMN `deposit` double(15,6) NOT NULL default '0.000000';
ALTER TABLE `docs_invoices` ADD COLUMN `delivery_status` tinyint(2) unsigned NOT NULL default '0';
До того как таблица создана в данном случае в нее переименовали
RENAME TABLE docs_acct TO docs_invoices;