qimall/addons/AvoidTax/migrate.sql

ALTER TABLE `qimall_addons_tax_user_auth` ADD COLUMN `flowId` varchar(64) NULL AFTER `accountId`;


ALTER TABLE `qimall_addons_tax_config` 
DROP COLUMN `app_id`,
DROP COLUMN `private_key`,
DROP COLUMN `app_public_key`,
DROP COLUMN `alipay_public_key`,
DROP COLUMN `alipay_root`,
MODIFY COLUMN `created_at` int(11) NULL DEFAULT NULL AFTER `settle`,
ADD COLUMN `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 自用版，2服务商版' AFTER `mall_id`,
MODIFY COLUMN `updated_at` int(11) NULL DEFAULT NULL AFTER `created_at`;


ALTER TABLE `qimall_addons_tax_order_book` 
ADD COLUMN `book_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 税务方  2用工方' AFTER `mall_id`;


ALTER TABLE `qimall_addons_tax_account_book` 
ADD COLUMN `book_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 税务方  2用工方' AFTER `mall_id`;


ALTER TABLE `qimall_addons_tax_account` 
ADD COLUMN `book_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 税务方  2用工方' AFTER `mall_id`;