use cps_pt; /*商户信息*/ ALTER TABLE merchant_base ADD COLUMN collect_money_notice_title_sn VARCHAR(22) DEFAULT NULL COMMENT '收款通知书抬头信息编号'; ALTER TABLE merchant_base ADD COLUMN is_tax_amount CHAR(1) DEFAULT NULL COMMENT '是否计算开票税额,0:否;1:是'; update merchant_base set is_tax_amount='1'; INSERT INTO `sys_menu` (`menu_sn`,`menu_name`,`menu_ename`,`parent_menu_sn`,`root_menu_sn`,`menu_tier`,`menu_url`,`menu_order`,`menu_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('menu578177512583213056','收款通知书抬头信息','collect_money_notice_title','menu000000000003001000','menu000000000003000000','3','#/views/bizbase/biz-collect-money-notice-title.html','9','0',NULL,NULL,NULL,'user000000000000000001','2019-05-15 11:11:01','user000000000000000001','2019-05-15 11:11:01','2019-05-15 11:11:01'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func578177648122146816','新增','add','menu578177512583213056','0',NULL,NULL,NULL,'user000000000000000001','2019-05-15 11:11:33','user000000000000000001','2019-05-15 11:11:33','2019-05-15 11:11:33'),('func578177692820844544','修改','upd','menu578177512583213056','0',NULL,NULL,NULL,'user000000000000000001','2019-05-15 11:11:43','user000000000000000001','2019-05-15 11:11:43','2019-05-15 11:11:44'),('func578177740271005696','删除','del','menu578177512583213056','0',NULL,NULL,NULL,'user000000000000000001','2019-05-15 11:11:55','user000000000000000001','2019-05-15 11:11:55','2019-05-15 11:11:55'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func583245856845864960','提交','sub','menu000000000001002002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:50:48','user000000000000000001','2019-05-29 10:50:48','2019-05-29 10:50:48'),('func583245872469647360','提交','sub','menu000000000001002003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:50:52','user000000000000000001','2019-05-29 10:50:52','2019-05-29 10:50:52'),('func583245891897663488','提交','sub','menu000000000001002004','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:50:56','user000000000000000001','2019-05-29 10:50:56','2019-05-29 10:50:56'),('func583245906921660416','提交','sub','menu000000000001002005','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:00','user000000000000000001','2019-05-29 10:51:00','2019-05-29 10:51:00'),('func583245921173905408','提交','sub','menu000000000001002006','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:03','user000000000000000001','2019-05-29 10:51:03','2019-05-29 10:51:03'),('func583245939402350592','提交','sub','menu000000000001002007','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:08','user000000000000000001','2019-05-29 10:51:08','2019-05-29 10:51:08'),('func583245955974045696','提交','sub','menu000000000001002008','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:12','user000000000000000001','2019-05-29 10:51:12','2019-05-29 10:51:12'),('func583245970452783104','提交','sub','menu000000000001002009','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:15','user000000000000000001','2019-05-29 10:51:15','2019-05-29 10:51:15'),('func583245988278575104','提交','sub','menu000000000001002010','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:19','user000000000000000001','2019-05-29 10:51:19','2019-05-29 10:51:19'),('func583246002686009344','提交','sub','menu000000000001002011','0',NULL,NULL,NULL,'user000000000000000001','2019-05-29 10:51:23','user000000000000000001','2019-05-29 10:51:23','2019-05-29 10:51:23'); /*收款通知书抬头信息*/ drop table if exists biz_collect_money_notice_title; create table biz_collect_money_notice_title ( sn varchar(22) not null comment '数据编号', comp_name_zn varchar(255) comment '抬头公司中文名称', comp_name_en varchar(255) comment '抬头公司英文名称', remark varchar(255) comment '备注', is_valid char(1) comment '是否有效,0:有效,1:无效', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (sn) ); alter table biz_collect_money_notice_title comment '收款通知书抬头信息'; INSERT INTO `biz_collect_money_notice_title` (`sn`,`comp_name_zn`,`comp_name_en`,`remark`,`is_valid`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('bcmn578178163136540672','深圳前海电商供应链管理有限公司','ShenZhen Qianhai Electric Supply Chain Management CO.,Ltd',NULL,'0','user000000000000000001','2019-05-15 11:13:36','user000000000000000001','2019-05-15 11:13:36','2019-05-16 17:33:16'); update merchant_base set collect_money_notice_title_sn='bcmn578178163136540672'; ALTER TABLE tmp_cp_data_order_pkg ADD COLUMN is_mother_order CHAR(1) DEFAULT NULL COMMENT '是否是母单(0:否;1:是)'; ALTER TABLE cp_data_whse ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_zone_stevedore ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_whse_op ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_cnsmb ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_record ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_cls_cus ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_cmb_zone_chgs ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; ALTER TABLE cp_data_trans ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd'; alter table cp_data_trans drop column shipping_bill; ALTER TABLE cp_data_trans ADD COLUMN shipping_bill_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '舱单费'; ALTER TABLE merch_rate_whse ADD COLUMN mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '最低收费'; ALTER TABLE merch_rate_whse_op ADD COLUMN talling_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '理货最低收费'; ALTER TABLE merch_rate_whse_op ADD COLUMN rcpt_chk_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '收货验货最低收费'; ALTER TABLE merch_rate_whse_op ADD COLUMN prod_repaste_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '收货验货最低收费'; ALTER TABLE merch_rate_trans ADD COLUMN hk_deliv_stvd_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '港车装卸最低收费,起始地为中港车适用'; ALTER TABLE supplier_rate_trans ADD COLUMN hk_stvd_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '港车装卸最低收费,起始地为中港车适用'; /*运输起始地*/ drop index Index_code on biz_trans_ori_place_type; drop table if exists biz_trans_ori_place_type; create table biz_trans_ori_place_type ( sn varchar(22) not null comment '数据编号', ori_place_type_code varchar(10) not null comment '起始地代码', ori_place_type_name varchar(255) comment '起始地名称', is_hk char(1) comment '是否计算中港车费用,0:否;1:是', remark varchar(255) comment '备注', is_valid char(1) comment '是否有效,0:有效,1:无效', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (sn) ); alter table biz_trans_ori_place_type comment '运输起始地'; create unique index Index_code on biz_trans_ori_place_type ( ori_place_type_code ); INSERT INTO `biz_trans_ori_place_type` (`sn`,`ori_place_type_code`,`ori_place_type_name`,`is_hk`,`remark`,`is_valid`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('btop580326292777222144','00','前海湾保税港区深圳门店','0','','0','user000000000000000001','2019-05-21 09:29:30','user000000000000000001','2019-05-21 09:29:30','2019-05-21 09:29:30'),('btop580326353397497856','01','前海湾保税港区-深圳门店(单点)','0','','0','user000000000000000001','2019-05-21 09:29:44','user000000000000000001','2019-05-21 09:29:44','2019-05-21 09:29:45'),('btop580326398398185472','10','中港车','1','','0','user000000000000000001','2019-05-21 09:29:55','user000000000000000001','2019-05-21 09:29:55','2019-05-21 09:29:56'),('btop580326438999048192','20','蛇口码头运输费用','0','','0','user000000000000000001','2019-05-21 09:30:05','user000000000000000001','2019-05-21 09:30:05','2019-05-21 09:30:05'),('btop580326486319185920','30','深圳机场-前海湾保税港','0','','0','user000000000000000001','2019-05-21 09:30:16','user000000000000000001','2019-05-21 09:30:16','2019-05-21 09:30:16'); INSERT INTO `sys_menu` (`menu_sn`,`menu_name`,`menu_ename`,`parent_menu_sn`,`root_menu_sn`,`menu_tier`,`menu_url`,`menu_order`,`menu_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('menu580092194468806656','运输起始地','ori_place_type','menu000000000003001000','menu000000000003000000','3','#/views/bizbase/biz-trans-ori-place-type.html','10','0',NULL,NULL,NULL,'user000000000000000001','2019-05-20 17:59:16','user000000000000000001','2019-05-20 17:59:16','2019-05-20 17:59:16'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func580092325536612352','新增','add','menu580092194468806656','0',NULL,NULL,NULL,'user000000000000000001','2019-05-20 17:59:48','user000000000000000001','2019-05-20 17:59:48','2019-05-20 17:59:47'),('func580092362178052096','修改','upd','menu580092194468806656','0',NULL,NULL,NULL,'user000000000000000001','2019-05-20 17:59:56','user000000000000000001','2019-05-20 17:59:56','2019-05-20 17:59:56'),('func580092398886600704','删除','del','menu580092194468806656','0',NULL,NULL,NULL,'user000000000000000001','2019-05-20 18:00:05','user000000000000000001','2019-05-20 18:00:05','2019-05-20 18:00:04'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func580395729937907712','复核回退','rollback','menu000000000001003008','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:05:25','user000000000000000001','2019-05-21 14:05:25','2019-05-21 14:05:25'),('func580398193726603264','复核回退','rollback','menu000000000001003001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:12','user000000000000000001','2019-05-21 14:15:12','2019-05-21 14:15:12'),('func580398211615309824','复核回退','rollback','menu000000000001003002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:16','user000000000000000001','2019-05-21 14:15:16','2019-05-21 14:15:17'),('func580398225947246592','复核回退','rollback','menu000000000001003003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:20','user000000000000000001','2019-05-21 14:15:20','2019-05-21 14:15:20'),('func580398242158231552','复核回退','rollback','menu000000000001003004','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:24','user000000000000000001','2019-05-21 14:15:24','2019-05-21 14:15:24'),('func580398257308057600','复核回退','rollback','menu000000000001003005','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:27','user000000000000000001','2019-05-21 14:15:27','2019-05-21 14:15:28'),('func580398272608878592','复核回退','rollback','menu000000000001003006','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:31','user000000000000000001','2019-05-21 14:15:31','2019-05-21 14:15:31'),('func580398288165552128','复核回退','rollback','menu000000000001003007','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:35','user000000000000000001','2019-05-21 14:15:35','2019-05-21 14:15:35'),('func580398319874490368','复核回退','rollback','menu000000000001003009','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:42','user000000000000000001','2019-05-21 14:15:42','2019-05-21 14:15:42'),('func580398336488128512','复核回退','rollback','menu000000000001003010','0',NULL,NULL,NULL,'user000000000000000001','2019-05-21 14:15:46','user000000000000000001','2019-05-21 14:15:46','2019-05-21 14:15:46'); /*商户圆通快递加收费率*/ drop table if exists merch_rate_expr_add_yto; create table merch_rate_expr_add_yto ( merch_yto_add_rate_sn varchar(22) not null comment '商户圆通加收费费率编号', merch_sn varchar(22) not null comment '商户编号', expr_type varchar(8) comment '物流运送类型 ,00:普通', consignee_province varchar(64) comment '送达省份 ', cal_type char(1) comment '计算方式:0:按重量;1:一口价', fst_weight numeric(19,2) comment '首重(<=),包含此重量', fst_price numeric(19,2) comment '首重价', snd_weight numeric(19,2) comment '续重', snd_price numeric(19,2) comment '续重价', unified_price numeric(19,2) comment '一口价', is_valid char(1) comment '是否有效,0:有效,1:无效', remark varchar(200) comment '备注', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (merch_yto_add_rate_sn) ); alter table merch_rate_expr_add_yto comment '商户圆通快递加收费率'; /*商户韵达快递加收费率*/ drop table if exists merch_rate_expr_add_yunda; create table merch_rate_expr_add_yunda ( merch_yunda_add_rate_sn varchar(22) not null comment '商户韵达加收费费率编号', merch_sn varchar(22) not null comment '商户编号', expr_type varchar(8) comment '物流运送类型 ,00:普通,01:保价,02:COD,03:到付,04:内件,', consignee_province varchar(64) comment '送达省份 ', fst_max_weight numeric(19,2) comment '一档最大重量(<),不包含此重量', fst_price numeric(19,2) comment '一档价', snd_max_weight numeric(19,2) comment '二档最大重量(<),不包含此重量', snd_gear_weight numeric(19,2) comment '二档续重', snd_gear_price numeric(19,2) comment '二档续重价', trd_gear_weight numeric(19,2) comment '三档续重', trd_gear_price numeric(19,2) comment '三档续重价', is_valid char(1) comment '是否有效,0:有效,1:无效', remark varchar(200) comment '备注', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (merch_yunda_add_rate_sn) ); alter table merch_rate_expr_add_yunda comment '商户韵达快递加收费率'; /*供应商韵达快递加收费率*/ drop table if exists supplier_rate_expr_add_yunda; create table supplier_rate_expr_add_yunda ( supp_yunda_add_rate_sn varchar(22) not null comment '供应商韵达加收费费率编号', expr_type varchar(8) comment '物流运送类型 ,00:普通,01:保价,02:COD,03:到付,04:内件,', consignee_province varchar(64) comment '送达省份 ', fst_max_weight numeric(19,2) comment '一档最大重量(<),不包含此重量', fst_price numeric(19,2) comment '一档价', snd_max_weight numeric(19,2) comment '二档最大重量(<),不包含此重量', snd_gear_weight numeric(19,2) comment '二档续重', snd_gear_price numeric(19,2) comment '二档续重价', trd_gear_weight numeric(19,2) comment '三档续重', trd_gear_price numeric(19,2) comment '三档续重价', is_valid char(1) comment '是否有效,0:有效,1:无效', remark varchar(200) comment '备注', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (supp_yunda_add_rate_sn) ); alter table supplier_rate_expr_add_yunda comment '供应商韵达快递加收费率'; /*供应商圆通快递加收费率*/ drop table if exists supplier_rate_expr_add_yto; create table supplier_rate_expr_add_yto ( supp_yto_add_rate_sn varchar(22) not null comment '供应商圆通加收费费率编号', expr_type varchar(8) comment '物流运送类型 ,00:普通', consignee_province varchar(64) comment '送达省份 ', cal_type char(1) comment '计算方式:0:按重量;1:一口价', fst_weight numeric(19,2) comment '首重(<=),包含此重量', fst_price numeric(19,2) comment '首重价', snd_weight numeric(19,2) comment '续重', snd_price numeric(19,2) comment '续重价', unified_price numeric(19,2) comment '一口价', is_valid char(1) comment '是否有效,0:有效,1:无效', remark varchar(200) comment '备注', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (supp_yto_add_rate_sn) ); alter table supplier_rate_expr_add_yto comment '供应商圆通快递加收费率'; INSERT INTO `sys_menu` (`menu_sn`,`menu_name`,`menu_ename`,`parent_menu_sn`,`root_menu_sn`,`menu_tier`,`menu_url`,`menu_order`,`menu_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('menu580687708987211776','韵达快递加收费率','merch_rate_expr_add_yunda','menu000000000002002000','menu000000000002000000','3','#/views/merchant/merchrate/merch-rate-expr-add-yunda.html','314','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:25:38','user000000000000000001','2019-05-22 09:25:38','2019-05-22 09:25:39'),('menu580687853577453568','圆通快递加收费率','merch_rate_expr_add_yto','menu000000000002002000','menu000000000002000000','3','#/views/merchant/merchrate/merch-rate-expr-add-yto.html','315','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:26:12','user000000000000000001','2019-05-22 09:26:12','2019-05-22 09:26:13'),('menu580688088194236416','圆通快递加收费率','supp_rate_expr_add_yto','menu000000000002004000','menu000000000002000000','3','#/views/merchant/supplierrate/supplier-rate-expr-add-yto.html','508','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:27:08','user000000000000000001','2019-05-22 09:27:08','2019-05-22 09:27:53'),('menu580688215474585600','韵达快递加收费率','supp_rate_expr_add_yunda','menu000000000002004000','menu000000000002000000','3','#/views/merchant/supplierrate/supplier-rate-expr-add-yunda.html','507','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:27:39','user000000000000000001','2019-05-22 09:27:39','2019-05-22 09:27:40'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func580688456064057344','新增','add','menu580687708987211776','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:28:36','user000000000000000001','2019-05-22 09:28:36','2019-05-22 09:28:37'),('func580688475903115264','新增','add','menu580687853577453568','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:28:41','user000000000000000001','2019-05-22 09:28:41','2019-05-22 09:28:42'),('func580688509008756736','新增','add','menu580688088194236416','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:28:49','user000000000000000001','2019-05-22 09:28:49','2019-05-22 09:28:50'),('func580688527006515200','新增','add','menu580688215474585600','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:28:53','user000000000000000001','2019-05-22 09:28:53','2019-05-22 09:28:54'),('func580688583336017920','修改','upd','menu580687708987211776','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:06','user000000000000000001','2019-05-22 09:29:06','2019-05-22 09:29:07'),('func580688598947217408','修改','upd','menu580687853577453568','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:10','user000000000000000001','2019-05-22 09:29:10','2019-05-22 09:29:11'),('func580688617238577152','修改','upd','menu580688088194236416','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:15','user000000000000000001','2019-05-22 09:29:15','2019-05-22 09:29:15'),('func580688634766573568','修改','upd','menu580688215474585600','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:19','user000000000000000001','2019-05-22 09:29:19','2019-05-22 09:29:20'),('func580688682078322688','删除','del','menu580687708987211776','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:30','user000000000000000001','2019-05-22 09:29:30','2019-05-22 09:29:31'),('func580688697660162048','删除','del','menu580687853577453568','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:34','user000000000000000001','2019-05-22 09:29:34','2019-05-22 09:29:35'),('func580688717532774400','删除','del','menu580688088194236416','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:38','user000000000000000001','2019-05-22 09:29:38','2019-05-22 09:29:39'),('func580688733328523264','删除','del','menu580688215474585600','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 09:29:42','user000000000000000001','2019-05-22 09:29:42','2019-05-22 09:29:43'); ALTER TABLE tmp_cp_data_order_pkg ADD COLUMN pkg_expr_add_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '快递加收费'; ALTER TABLE cp_data_order_pkg ADD COLUMN pkg_expr_aggr_add_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '快递加收总额'; update sys_function set func_name='全部汇总',func_ename='summaryAll' where func_sn='func556068980818567168'; update sys_function set func_name='全部汇总',func_ename='summaryAll' where func_sn='func556068969078710272'; INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func580796032013975552','选择汇总','summarySelect','menu000000000001001001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 16:36:04','user000000000000000001','2019-05-22 16:36:04','2019-05-22 16:36:05'),('func580796056429019136','选择汇总','summarySelect','menu000000000001001002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-22 16:36:10','user000000000000000001','2019-05-22 16:36:10','2019-05-22 16:36:11'); update sys_function set func_name='全部完成',func_ename='settAll' where func_ename='sett'; INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func581120196046766080','选择完成','settSelect','menu000000000001003001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:11','user000000000000000001','2019-05-23 14:04:11','2019-05-23 14:04:13'),('func581120212735901696','选择完成','settSelect','menu000000000001003002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:15','user000000000000000001','2019-05-23 14:04:15','2019-05-23 14:04:17'),('func581120227650846720','选择完成','settSelect','menu000000000001003003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:18','user000000000000000001','2019-05-23 14:04:18','2019-05-23 14:04:21'),('func581120245732491264','选择完成','settSelect','menu000000000001003004','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:23','user000000000000000001','2019-05-23 14:04:23','2019-05-23 14:04:25'),('func581120260597104640','选择完成','settSelect','menu000000000001003005','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:26','user000000000000000001','2019-05-23 14:04:26','2019-05-23 14:04:29'),('func581120275302334464','选择完成','settSelect','menu000000000001003006','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:30','user000000000000000001','2019-05-23 14:04:30','2019-05-23 14:04:32'),('func581120290192113664','选择完成','settSelect','menu000000000001003007','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:33','user000000000000000001','2019-05-23 14:04:33','2019-05-23 14:04:36'),('func581120305752981504','选择完成','settSelect','menu000000000001003008','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:37','user000000000000000001','2019-05-23 14:04:37','2019-05-23 14:04:40'),('func581120322937044992','选择完成','settSelect','menu000000000001003009','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:41','user000000000000000001','2019-05-23 14:04:41','2019-05-23 14:04:44'),('func581120338539855872','选择完成','settSelect','menu000000000001003010','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 14:04:45','user000000000000000001','2019-05-23 14:04:45','2019-05-23 14:04:47'); update sys_function set func_name='全部归集',func_ename='mergeAll' where func_ename='merge'; INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func581145720513380352','选择归集','mergeSelect','menu000000000001004001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:36','user000000000000000001','2019-05-23 15:45:36','2019-05-23 15:45:39'),('func581145735919058944','选择归集','mergeSelect','menu000000000001004002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:40','user000000000000000001','2019-05-23 15:45:40','2019-05-23 15:45:42'),('func581145750901112832','选择归集','mergeSelect','menu000000000001004003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:44','user000000000000000001','2019-05-23 15:45:44','2019-05-23 15:45:46'),('func581145765321129984','选择归集','mergeSelect','menu000000000001004004','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:47','user000000000000000001','2019-05-23 15:45:47','2019-05-23 15:45:49'),('func581145780449984512','选择归集','mergeSelect','menu000000000001004005','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:51','user000000000000000001','2019-05-23 15:45:51','2019-05-23 15:45:53'),('func581145796098932736','选择归集','mergeSelect','menu000000000001004006','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:54','user000000000000000001','2019-05-23 15:45:54','2019-05-23 15:45:57'),('func581145811764658176','选择归集','mergeSelect','menu000000000001004007','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:45:58','user000000000000000001','2019-05-23 15:45:58','2019-05-23 15:46:00'),('func581145828835475456','选择归集','mergeSelect','menu000000000001004008','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:02','user000000000000000001','2019-05-23 15:46:02','2019-05-23 15:46:04'),('func581145844358594560','选择归集','mergeSelect','menu000000000001004009','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:06','user000000000000000001','2019-05-23 15:46:06','2019-05-23 15:46:08'),('func581145858719891456','选择归集','mergeSelect','menu000000000001004010','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:09','user000000000000000001','2019-05-23 15:46:09','2019-05-23 15:46:12'),('func581145877657174016','选择归集','mergeSelect','menu000000000001005001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:14','user000000000000000001','2019-05-23 15:46:14','2019-05-23 15:46:16'),('func581145893712969728','选择归集','mergeSelect','menu000000000001005002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:18','user000000000000000001','2019-05-23 15:46:18','2019-05-23 15:46:20'),('func581145908120403968','选择归集','mergeSelect','menu000000000001005003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 15:46:21','user000000000000000001','2019-05-23 15:46:21','2019-05-23 15:46:23'); update sys_function set func_name='全部生成应收',func_ename='genrcvAll' where func_name='生成应收'; update sys_function set func_name='全部生成应付',func_ename='genrcvAll' where func_name='生成应付'; INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func581163098202980352','选择生成应收','genrcvSelect','menu000000000001005005','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:40','user000000000000000001','2019-05-23 16:54:40','2019-05-23 16:54:42'),('func581163115680645120','选择生成应收','genrcvSelect','menu000000000001006001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:44','user000000000000000001','2019-05-23 16:54:44','2019-05-23 16:54:46'),('func581163129484099584','选择生成应收','genrcvSelect','menu000000000001006002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:47','user000000000000000001','2019-05-23 16:54:47','2019-05-23 16:54:49'),('func581163146282287104','选择生成应收','genrcvSelect','menu000000000001006003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:51','user000000000000000001','2019-05-23 16:54:51','2019-05-23 16:54:53'),('func581163161214009344','选择生成应收','genrcvSelect','menu000000000001006004','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:55','user000000000000000001','2019-05-23 16:54:55','2019-05-23 16:54:57'),('func581163176154120192','选择生成应收','genrcvSelect','menu000000000001006006','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:54:58','user000000000000000001','2019-05-23 16:54:58','2019-05-23 16:55:00'),('func581163191475912704','选择生成应收','genrcvSelect','menu000000000001006007','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:55:02','user000000000000000001','2019-05-23 16:55:02','2019-05-23 16:55:04'),('func581163231871254528','选择生成应付','genrcvSelect','menu000000000001007001','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:55:11','user000000000000000001','2019-05-23 16:55:11','2019-05-23 16:55:13'),('func581163257024495616','选择生成应付','genrcvSelect','menu000000000001007002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:55:17','user000000000000000001','2019-05-23 16:55:17','2019-05-23 16:55:19'),('func581163272983822336','选择生成应付','genrcvSelect','menu000000000001007003','0',NULL,NULL,NULL,'user000000000000000001','2019-05-23 16:55:21','user000000000000000001','2019-05-23 16:55:21','2019-05-23 16:55:23'); /*商户税费扣减异常表*/ drop table if exists merch_cus_tax_cut_error; create table merch_cus_tax_cut_error ( sn varchar(22) not null comment '数据编号', order_sn varchar(22) comment 'oms订单编号', remark varchar(200) comment '备注', is_handle char(1) comment '是否处理,0:否;1:是', creater_sn varchar(22) comment '创建人编号', create_time varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss', moder_sn varchar(22) comment '修改人编号', mod_time varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss', tstm timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳', primary key (sn) ); alter table merch_cus_tax_cut_error comment '商户税费扣减异常表'; create unique index index_order on merch_cus_tax_cut_error ( order_sn ); INSERT INTO `sys_menu` (`menu_sn`,`menu_name`,`menu_ename`,`parent_menu_sn`,`root_menu_sn`,`menu_tier`,`menu_url`,`menu_order`,`menu_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('menu581784726815264768','错误记录','error','menu000000000001000000','menu000000000001000000','2','#','110','0',NULL,NULL,NULL,'user000000000000000001','2019-05-25 10:04:47','user000000000000000001','2019-05-25 10:04:47','2019-05-25 10:09:29'),('menu581785069666062336','税费扣减错误记录','cus_tax_cut_error','menu581784726815264768','menu000000000001000000','3','#/views/bizpayments/error/cus-tax-cut-error.html','1101','0',NULL,NULL,NULL,'user000000000000000001','2019-05-25 10:06:09','user000000000000000001','2019-05-25 10:06:09','2019-05-25 10:09:39'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func581785186024443904','处理','handle','menu581785069666062336','0',NULL,NULL,NULL,'user000000000000000001','2019-05-25 10:06:37','user000000000000000001','2019-05-25 10:06:37','2019-05-25 10:06:38'),('func581785219264303104','删除','del','menu581785069666062336','0',NULL,NULL,NULL,'user000000000000000001','2019-05-25 10:06:45','user000000000000000001','2019-05-25 10:06:45','2019-05-25 10:06:46'); INSERT INTO `sys_function` (`func_sn`,`func_name`,`func_ename`,`menu_sn`,`func_status`,`remarks`,`deleter_sn`,`delete_time`,`creater_sn`,`create_time`,`moder_sn`,`mod_time`,`tstm`) VALUES ('func581796664454696960','重新抓取','grasp','menu000000000001001002','0',NULL,NULL,NULL,'user000000000000000001','2019-05-25 10:52:14','user000000000000000001','2019-05-25 10:52:14','2019-05-25 10:52:15');