2022-10-18_update.sql

alter table `ecw_order` modify column `channel_id` bigint DEFAULT 0 COMMENT '渠道ID';
alter table `ecw_order_item` modify column `channel_id` bigint DEFAULT 0 COMMENT '渠道ID';
alter table `ecw_offer` modify column `channel_id` bigint DEFAULT 0 COMMENT '渠道ID';
alter table `ecw_offer_prod` modify column `channel_id` bigint DEFAULT 0 COMMENT '渠道ID';

--  正式环境 已执行
INSERT INTO `system_dict_type`(`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ('应收明细状态', 'receivable_state', 0, NULL, '115', '2022-10-29 17:48:09', '115', '2022-10-29 17:48:09', b'0');

INSERT INTO `system_dict_data`( `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES ( 0, '未收款', '0', 'receivable_state', 0, 'default', '', '未收款', '115', '2022-10-29 17:49:23', '115', '2022-10-29 17:49:23', b'0', 'not_receivale');
INSERT INTO `system_dict_data`( `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES ( 1, '收款中', '1', 'receivable_state', 0, 'default', '', '收款中', '115', '2022-10-29 17:50:39', '115', '2022-10-29 17:50:39', b'0', 'receivableing');
INSERT INTO `system_dict_data`( `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES ( 2, '已收款', '2', 'receivable_state', 0, 'default', '', '已收款', '115', '2022-10-29 17:51:25', '115', '2022-10-29 17:51:25', b'0', 'receivabled');