Главная Обзор Помощь
Вход
zhushouping
/
cps-doc
ответвлено от project/cps-doc
1
0
Ответвить 0
Файлы
Дерево: 40ef56e0ad
Ветки Метки
cps-doc
/
10技术支持文档
/
cps二期sql修改语句.txt

cps二期sql修改语句.txt 35 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288 
  1. use cps_pt;
    2. 

  2. 

  3. /*商户信息*/
    4. 

  4. ALTER TABLE merchant_base ADD COLUMN collect_money_notice_title_sn VARCHAR(22) DEFAULT NULL COMMENT '收款通知书抬头信息编号';
    5. 

  5. 

  6. ALTER TABLE merchant_base ADD COLUMN is_tax_amount CHAR(1) DEFAULT NULL COMMENT '是否计算开票税额,0:否;1:是';
    7. 

  7. 

  8. update merchant_base set is_tax_amount='1';
    9. 

  9. 

  10. 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');
    11. 

  11. 

  12. 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');
    13. 

  13. 

  14. 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');
    15. 

  15. 

  16. /*收款通知书抬头信息*/
    17. 

  17. 

  18. drop table if exists biz_collect_money_notice_title;
    19. 

  19. 

  20. create table biz_collect_money_notice_title
    21. 

  21. (
    22. 

  22.    sn                   varchar(22) not null comment '数据编号',
    23. 

  23.    comp_name_zn         varchar(255) comment '抬头公司中文名称',
    24. 

  24.    comp_name_en         varchar(255) comment '抬头公司英文名称',
    25. 

  25.    remark               varchar(255) comment '备注',
    26. 

  26.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    27. 

  27.    creater_sn           varchar(22) comment '创建人编号',
    28. 

  28.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    29. 

  29.    moder_sn             varchar(22) comment '修改人编号',
    30. 

  30.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    31. 

  31.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    32. 

  32.    primary key (sn)
    33. 

  33. );
    34. 

  34. 

  35. alter table biz_collect_money_notice_title comment '收款通知书抬头信息';
    36. 

  36. 

  37. 

  38. 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');
    39. 

  39. 

  40. 

  41. update merchant_base set collect_money_notice_title_sn='bcmn578178163136540672';
    42. 

  42. 

  43. 

  44. 

  45. 

  46. ALTER TABLE tmp_cp_data_order_pkg ADD COLUMN is_mother_order CHAR(1) DEFAULT NULL COMMENT '是否是母单(0:否;1:是)';
    47. 

  47. 

  48. 

  49. ALTER TABLE cp_data_whse ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    50. 

  50. ALTER TABLE cp_data_zone_stevedore ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    51. 

  51. ALTER TABLE cp_data_whse_op ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    52. 

  52. ALTER TABLE cp_data_cnsmb ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    53. 

  53. ALTER TABLE cp_data_record ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    54. 

  54. ALTER TABLE cp_data_cls_cus ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    55. 

  55. ALTER TABLE cp_data_cmb_zone_chgs ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    56. 

  56. ALTER TABLE cp_data_trans ADD COLUMN happen_date VARCHAR(19) DEFAULT NULL COMMENT '发生日期,yyyy-MM-dd';
    57. 

  57. 

  58. 

  59. alter table cp_data_trans drop column shipping_bill;
    60. 

  60. ALTER TABLE cp_data_trans ADD COLUMN shipping_bill_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '舱单费';
    61. 

  61. 

  62. 

  63. ALTER TABLE merch_rate_whse ADD COLUMN mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '最低收费';
    64. 

  64. ALTER TABLE merch_rate_whse_op ADD COLUMN talling_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '理货最低收费';
    65. 

  65. ALTER TABLE merch_rate_whse_op ADD COLUMN rcpt_chk_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '收货验货最低收费';
    66. 

  66. ALTER TABLE merch_rate_whse_op ADD COLUMN prod_repaste_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '收货验货最低收费';
    67. 

  67. ALTER TABLE merch_rate_trans ADD COLUMN hk_deliv_stvd_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '港车装卸最低收费，起始地为中港车适用';
    68. 

  68. ALTER TABLE supplier_rate_trans ADD COLUMN hk_stvd_mini_charge NUMERIC(19,2) DEFAULT NULL COMMENT '港车装卸最低收费，起始地为中港车适用';
    69. 

  69. 

  70. 

  71. /*运输起始地*/
    72. 

  72. 

  73. drop index Index_code on biz_trans_ori_place_type;
    74. 

  74. 

  75. drop table if exists biz_trans_ori_place_type;
    76. 

  76. 

  77. create table biz_trans_ori_place_type
    78. 

  78. (
    79. 

  79.    sn                   varchar(22) not null comment '数据编号',
    80. 

  80.    ori_place_type_code  varchar(10) not null comment '起始地代码',
    81. 

  81.    ori_place_type_name  varchar(255) comment '起始地名称',
    82. 

  82.    is_hk                char(1) comment '是否计算中港车费用,0:否;1:是',
    83. 

  83.    remark               varchar(255) comment '备注',
    84. 

  84.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    85. 

  85.    creater_sn           varchar(22) comment '创建人编号',
    86. 

  86.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    87. 

  87.    moder_sn             varchar(22) comment '修改人编号',
    88. 

  88.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    89. 

  89.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    90. 

  90.    primary key (sn)
    91. 

  91. );
    92. 

  92. 

  93. alter table biz_trans_ori_place_type comment '运输起始地';
    94. 

  94. 

  95. create unique index Index_code on biz_trans_ori_place_type
    96. 

  96. (
    97. 

  97.    ori_place_type_code
    98. 

  98. );
    99. 

  99. 

  100. 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');
    101. 

  101. 

  102. 

  103. 

  104. 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');
    105. 

  105. 

  106. 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');
    107. 

  107. 

  108. 

  109. 

  110. 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');
    111. 

  111. 

  112. 

  113. /*商户圆通快递加收费率*/
    114. 

  114. drop table if exists merch_rate_expr_add_yto;
    115. 

  115. 

  116. create table merch_rate_expr_add_yto
    117. 

  117. (
    118. 

  118.    merch_yto_add_rate_sn varchar(22) not null comment '商户圆通加收费费率编号',
    119. 

  119.    merch_sn             varchar(22) not null comment '商户编号',
    120. 

  120.    expr_type            varchar(8) comment '物流运送类型 ,00:普通',
    121. 

  121.    consignee_province   varchar(64) comment '送达省份 ',
    122. 

  122.    cal_type             char(1) comment '计算方式:0:按重量;1:一口价',
    123. 

  123.    fst_weight           numeric(19,2) comment '首重(<=),包含此重量',
    124. 

  124.    fst_price            numeric(19,2) comment '首重价',
    125. 

  125.    snd_weight           numeric(19,2) comment '续重',
    126. 

  126.    snd_price            numeric(19,2) comment '续重价',
    127. 

  127.    unified_price        numeric(19,2) comment '一口价',
    128. 

  128.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    129. 

  129.    remark               varchar(200) comment '备注',
    130. 

  130.    creater_sn           varchar(22) comment '创建人编号',
    131. 

  131.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    132. 

  132.    moder_sn             varchar(22) comment '修改人编号',
    133. 

  133.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    134. 

  134.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    135. 

  135.    primary key (merch_yto_add_rate_sn)
    136. 

  136. );
    137. 

  137. 

  138. alter table merch_rate_expr_add_yto comment '商户圆通快递加收费率';
    139. 

  139. 

  140. 

  141. /*商户韵达快递加收费率*/
    142. 

  142. 

  143. drop table if exists merch_rate_expr_add_yunda;
    144. 

  144. 

  145. create table merch_rate_expr_add_yunda
    146. 

  146. (
    147. 

  147.    merch_yunda_add_rate_sn varchar(22) not null comment '商户韵达加收费费率编号',
    148. 

  148.    merch_sn             varchar(22) not null comment '商户编号',
    149. 

  149.    expr_type            varchar(8) comment '物流运送类型 ,00:普通,01:保价,02:COD,03:到付,04:内件,',
    150. 

  150.    consignee_province   varchar(64) comment '送达省份 ',
    151. 

  151.    fst_max_weight       numeric(19,2) comment '一档最大重量(<),不包含此重量',
    152. 

  152.    fst_price            numeric(19,2) comment '一档价',
    153. 

  153.    snd_max_weight       numeric(19,2) comment '二档最大重量(<),不包含此重量',
    154. 

  154.    snd_gear_weight      numeric(19,2) comment '二档续重',
    155. 

  155.    snd_gear_price       numeric(19,2) comment '二档续重价',
    156. 

  156.    trd_gear_weight      numeric(19,2) comment '三档续重',
    157. 

  157.    trd_gear_price       numeric(19,2) comment '三档续重价',
    158. 

  158.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    159. 

  159.    remark               varchar(200) comment '备注',
    160. 

  160.    creater_sn           varchar(22) comment '创建人编号',
    161. 

  161.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    162. 

  162.    moder_sn             varchar(22) comment '修改人编号',
    163. 

  163.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    164. 

  164.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    165. 

  165.    primary key (merch_yunda_add_rate_sn)
    166. 

  166. );
    167. 

  167. 

  168. alter table merch_rate_expr_add_yunda comment '商户韵达快递加收费率';
    169. 

  169. 

  170. 

  171. /*供应商韵达快递加收费率*/
    172. 

  172. 

  173. drop table if exists supplier_rate_expr_add_yunda;
    174. 

  174. 

  175. create table supplier_rate_expr_add_yunda
    176. 

  176. (
    177. 

  177.    supp_yunda_add_rate_sn varchar(22) not null comment '供应商韵达加收费费率编号',
    178. 

  178.    expr_type            varchar(8) comment '物流运送类型 ,00:普通,01:保价,02:COD,03:到付,04:内件,',
    179. 

  179.    consignee_province   varchar(64) comment '送达省份 ',
    180. 

  180.    fst_max_weight       numeric(19,2) comment '一档最大重量(<),不包含此重量',
    181. 

  181.    fst_price            numeric(19,2) comment '一档价',
    182. 

  182.    snd_max_weight       numeric(19,2) comment '二档最大重量(<),不包含此重量',
    183. 

  183.    snd_gear_weight      numeric(19,2) comment '二档续重',
    184. 

  184.    snd_gear_price       numeric(19,2) comment '二档续重价',
    185. 

  185.    trd_gear_weight      numeric(19,2) comment '三档续重',
    186. 

  186.    trd_gear_price       numeric(19,2) comment '三档续重价',
    187. 

  187.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    188. 

  188.    remark               varchar(200) comment '备注',
    189. 

  189.    creater_sn           varchar(22) comment '创建人编号',
    190. 

  190.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    191. 

  191.    moder_sn             varchar(22) comment '修改人编号',
    192. 

  192.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    193. 

  193.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    194. 

  194.    primary key (supp_yunda_add_rate_sn)
    195. 

  195. );
    196. 

  196. 

  197. alter table supplier_rate_expr_add_yunda comment '供应商韵达快递加收费率';
    198. 

  198. 

  199. 

  200. /*供应商圆通快递加收费率*/
    201. 

  201. drop table if exists supplier_rate_expr_add_yto;
    202. 

  202. 

  203. create table supplier_rate_expr_add_yto
    204. 

  204. (
    205. 

  205.    supp_yto_add_rate_sn varchar(22) not null comment '供应商圆通加收费费率编号',
    206. 

  206.    expr_type            varchar(8) comment '物流运送类型 ,00:普通',
    207. 

  207.    consignee_province   varchar(64) comment '送达省份 ',
    208. 

  208.    cal_type             char(1) comment '计算方式:0:按重量;1:一口价',
    209. 

  209.    fst_weight           numeric(19,2) comment '首重(<=),包含此重量',
    210. 

  210.    fst_price            numeric(19,2) comment '首重价',
    211. 

  211.    snd_weight           numeric(19,2) comment '续重',
    212. 

  212.    snd_price            numeric(19,2) comment '续重价',
    213. 

  213.    unified_price        numeric(19,2) comment '一口价',
    214. 

  214.    is_valid             char(1) comment '是否有效,0:有效，1:无效',
    215. 

  215.    remark               varchar(200) comment '备注',
    216. 

  216.    creater_sn           varchar(22) comment '创建人编号',
    217. 

  217.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    218. 

  218.    moder_sn             varchar(22) comment '修改人编号',
    219. 

  219.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    220. 

  220.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    221. 

  221.    primary key (supp_yto_add_rate_sn)
    222. 

  222. );
    223. 

  223. 

  224. alter table supplier_rate_expr_add_yto comment '供应商圆通快递加收费率';
    225. 

  225. 

  226. 

  227. 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');
    228. 

  228. 

  229. 

  230. 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');
    231. 

  231. 

  232. 

  233. ALTER TABLE tmp_cp_data_order_pkg ADD COLUMN pkg_expr_add_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '快递加收费';
    234. 

  234. 

  235. 

  236. ALTER TABLE cp_data_order_pkg ADD COLUMN pkg_expr_aggr_add_chgs NUMERIC(19,2) DEFAULT NULL COMMENT '快递加收总额';
    237. 

  237. 

  238. 

  239. update sys_function set func_name='全部汇总',func_ename='summaryAll' where func_sn='func556068980818567168';
    240. 

  240. 

  241. update sys_function set func_name='全部汇总',func_ename='summaryAll' where func_sn='func556068969078710272';
    242. 

  242. 

  243. 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');
    244. 

  244. 

  245. 

  246. update sys_function set func_name='全部完成',func_ename='settAll' where func_ename='sett';
    247. 

  247. 

  248. 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');
    249. 

  249. 

  250. update sys_function set func_name='全部归集',func_ename='mergeAll' where func_ename='merge';
    251. 

  251. 

  252. 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');
    253. 

  253. 

  254. update sys_function set func_name='全部生成应收',func_ename='genrcvAll' where func_name='生成应收';
    255. 

  255. update sys_function set func_name='全部生成应付',func_ename='genrcvAll' where func_name='生成应付';
    256. 

  256. 

  257. 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');
    258. 

  258. 

  259. 

  260. /*商户税费扣减异常表*/
    261. 

  261. drop table if exists merch_cus_tax_cut_error;
    262. 

  262. 

  263. create table merch_cus_tax_cut_error
    264. 

  264. (
    265. 

  265.    sn                   varchar(22) not null comment '数据编号',
    266. 

  266.    order_sn             varchar(22) comment 'oms订单编号',
    267. 

  267.    remark               varchar(200) comment '备注',
    268. 

  268.    is_handle            char(1) comment '是否处理,0:否;1:是',
    269. 

  269.    creater_sn           varchar(22) comment '创建人编号',
    270. 

  270.    create_time          varchar(19) comment '创建时间,yyyy-MM-dd HH:mm:ss',
    271. 

  271.    moder_sn             varchar(22) comment '修改人编号',
    272. 

  272.    mod_time             varchar(19) comment '修改时间,yyyy-MM-dd HH:mm:ss',
    273. 

  273.    tstm                 timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '时间戳',
    274. 

  274.    primary key (sn)
    275. 

  275. );
    276. 

  276. 

  277. alter table merch_cus_tax_cut_error comment '商户税费扣减异常表';
    278. 

  278. 

  279. create unique index index_order on merch_cus_tax_cut_error
    280. 

  280. (
    281. 

  281.    order_sn
    282. 

  282. );
    283. 

  283. 

  284. 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');
    285. 

  285. 

  286. 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');
    287. 

  287. 

  288. 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');
    289.