ALTER TABLE `charging_pile_order`.`t_order_invoice`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

CREATE INDEX `idx_order_invoice_site_id` ON `charging_pile_order`.`t_order_invoice` (`site_id`);
CREATE INDEX `idx_order_invoice_partner_id` ON `charging_pile_order`.`t_order_invoice` (`partner_id`);
CREATE INDEX `idx_order_invoice_status` ON `charging_pile_order`.`t_order_invoice` (`status`);

ALTER TABLE `charging_pile_order`.`t_order_invoice_0`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_1`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_2`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_3`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_4`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_5`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_6`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_7`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_8`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;

ALTER TABLE `charging_pile_order`.`t_order_invoice_9`
    ADD COLUMN `site_id` int NULL COMMENT '归属电站id' AFTER `app_user_id`,
    ADD COLUMN `partner_id` int NULL COMMENT '归属合作商id' AFTER `site_id`,
    ADD COLUMN `remark` varchar(500) NULL COMMENT '备注' AFTER `mailbox`,
    ADD COLUMN `cancel_time` datetime NULL COMMENT '取消时间' AFTER `billing_user_id`;