Home Esplora Aiuto
Registrati Accedi
gongdc
/
uni_xs
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Ramo (Branch): master
Rami (Branch) Tag
uni_xs
/
sql
/
unimall_tmp.sql

unimall_tmp.sql 51 KB
Permalink Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 中天昊元
    5. 

  5. Source Server Version : 50649
    6. 

  6. Source Host           : 47.100.3.209:3306
    7. 

  7. Source Database       : unimall_tmp
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50649
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2022-05-15 13:06:24
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

  18. -- ----------------------------
    19. 

  19. -- Table structure for sys_dict_data
    20. 

  20. -- ----------------------------
    21. 

  21. DROP TABLE IF EXISTS `sys_dict_data`;
    22. 

  22. CREATE TABLE `sys_dict_data` (
    23. 

  23.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
    24. 

  24.   `dict_name` varchar(255) DEFAULT NULL COMMENT '字典编号',
    25. 

  25.   `dict_type` varchar(100) NOT NULL COMMENT '类型',
    26. 

  26.   `label` varchar(100) NOT NULL COMMENT '标签名',
    27. 

  27.   `value` varchar(100) NOT NULL COMMENT '数据值',
    28. 

  28.   `sort` int(10) DEFAULT NULL COMMENT '排序（升序）',
    29. 

  29.   `gmt_create` datetime DEFAULT NULL,
    30. 

  30.   `gmt_update` datetime DEFAULT NULL,
    31. 

  31.   `admin_id` int(11) DEFAULT NULL,
    32. 

  32.   `company_id` bigint(20) DEFAULT NULL,
    33. 

  33.   PRIMARY KEY (`id`),
    34. 

  34.   UNIQUE KEY `sys_dict_data_id_uindex` (`id`) USING BTREE
    35. 

  35. ) ENGINE=InnoDB AUTO_INCREMENT=234 DEFAULT CHARSET=utf8;
    36. 

  36. 

  37. -- ----------------------------
    38. 

  38. -- Records of sys_dict_data
    39. 

  39. -- ----------------------------
    40. 

  40. INSERT INTO `sys_dict_data` VALUES ('59', '销售状态', 'sale_status', '未申请', '10', '8', '2020-10-22 08:33:36', '2020-11-03 10:17:46', null, '1');
    41. 

  41. INSERT INTO `sys_dict_data` VALUES ('60', '销售状态', 'sale_status', '未定价', '20', '9', '2020-10-22 08:34:20', '2020-11-03 10:14:47', null, '1');
    42. 

  42. INSERT INTO `sys_dict_data` VALUES ('61', '销售状态', 'sale_status', '销售中', '30', '10', '2020-10-22 08:34:50', '2020-11-03 10:14:53', null, '1');
    43. 

  43. INSERT INTO `sys_dict_data` VALUES ('63', '采购状态', 'buy_status', '未生效', '10', '12', '2020-10-22 09:01:23', '2020-11-13 10:48:17', null, '1');
    44. 

  44. INSERT INTO `sys_dict_data` VALUES ('64', '采购状态', 'buy_status', '已生效', '20', '11', '2020-10-22 09:01:41', '2020-11-13 10:48:27', null, '1');
    45. 

  45. INSERT INTO `sys_dict_data` VALUES ('65', '采购状态', 'buy_status', '待审核', '15', '13', '2020-10-22 09:02:03', '2020-11-13 10:48:34', null, '1');
    46. 

  46. INSERT INTO `sys_dict_data` VALUES ('68', '新闻类型', 'news_type', '工厂价格', '0', '15', '2020-10-22 14:14:32', '2020-11-03 10:15:45', null, '1');
    47. 

  47. INSERT INTO `sys_dict_data` VALUES ('69', '新闻类型', 'news_type', '港口价格', '1', '16', '2020-10-22 14:15:04', '2020-11-03 10:15:50', null, '1');
    48. 

  48. INSERT INTO `sys_dict_data` VALUES ('70', '新闻类型', 'news_type', '行业新闻', '2', '17', '2020-10-22 14:15:40', '2020-11-03 10:15:55', null, '1');
    49. 

  49. INSERT INTO `sys_dict_data` VALUES ('71', '发运状态', 'tran_status', '生效中', '30', '18', '2020-10-22 14:40:20', '2020-11-03 16:16:20', null, '1');
    50. 

  50. INSERT INTO `sys_dict_data` VALUES ('72', '发运状态', 'tran_status', '已完成', '40', '19', '2020-10-22 14:40:38', '2020-11-03 16:16:38', null, '1');
    51. 

  51. INSERT INTO `sys_dict_data` VALUES ('73', '发运状态', 'tran_status', '待定价', '20', '20', '2020-10-22 14:40:51', '2020-11-04 09:14:09', null, '1');
    52. 

  52. INSERT INTO `sys_dict_data` VALUES ('74', '承运状态', 'car_status', '待审核', '10', '21', '2020-10-22 15:13:41', '2020-11-06 09:50:05', null, '1');
    53. 

  53. INSERT INTO `sys_dict_data` VALUES ('75', '承运状态', 'car_status', '可发运', '20', '22', '2020-10-22 15:14:01', '2020-11-06 11:01:45', null, '1');
    54. 

  54. INSERT INTO `sys_dict_data` VALUES ('76', '承运状态', 'car_status', '已发运', '30', '23', '2020-10-22 15:14:14', '2020-11-06 09:52:18', null, '1');
    55. 

  55. INSERT INTO `sys_dict_data` VALUES ('80', '合同类型', 'contract_type', '销售', '0', '0', '2020-11-01 12:29:45', '2020-11-03 10:17:28', null, '1');
    56. 

  56. INSERT INTO `sys_dict_data` VALUES ('81', '合同类型', 'contract_type', '采购', '1', '1', '2020-11-01 12:30:03', '2020-11-03 10:17:33', null, '1');
    57. 

  57. INSERT INTO `sys_dict_data` VALUES ('82', '销售状态', 'sale_status', '已下架', '40', '11', '2020-11-02 12:53:40', '2020-11-03 10:17:52', null, '1');
    58. 

  58. INSERT INTO `sys_dict_data` VALUES ('83', '销售状态', 'sale_status', '未审核', '21', '13', '2020-11-02 12:57:54', '2020-11-03 10:17:59', null, '1');
    59. 

  59. INSERT INTO `sys_dict_data` VALUES ('84', '产品等级', 'food_type', '一等品', '0', '27', '2020-11-02 13:23:57', '2020-11-03 10:18:19', null, '1');
    60. 

  60. INSERT INTO `sys_dict_data` VALUES ('85', '产品等级', 'food_type', '二等品', '1', '28', '2020-11-02 13:24:34', '2020-11-03 10:18:30', null, '1');
    61. 

  61. INSERT INTO `sys_dict_data` VALUES ('86', '产品等级', 'food_type', '三等品', '2', '29', '2020-11-02 13:24:56', '2020-11-03 10:18:35', null, '1');
    62. 

  62. INSERT INTO `sys_dict_data` VALUES ('87', '出库方式', 'sale_type', '移库', '0', '0', '2020-11-03 08:57:37', '2020-11-03 10:14:48', null, '1');
    63. 

  63. INSERT INTO `sys_dict_data` VALUES ('88', '出库方式', 'sale_type', '散船平仓', '1', '1', '2020-11-03 08:57:57', '2020-11-03 10:15:11', null, '1');
    64. 

  64. INSERT INTO `sys_dict_data` VALUES ('89', '出库方式', 'sale_type', '装箱进港', '2', '2', '2020-11-03 08:58:33', '2020-11-03 10:15:26', null, '1');
    65. 

  65. INSERT INTO `sys_dict_data` VALUES ('90', '出库方式', 'sale_type', '库内销售', '3', '3', '2020-11-03 10:15:50', '2020-11-03 10:15:50', null, '1');
    66. 

  66. INSERT INTO `sys_dict_data` VALUES ('91', '出库方式', 'sale_type', '运送到厂', '4', '4', '2020-11-03 10:18:02', '2020-11-03 10:18:02', null, '1');
    67. 

  67. INSERT INTO `sys_dict_data` VALUES ('92', '发运状态', 'tran_status', '待审核', '10', '10', '2020-11-03 16:17:30', '2020-11-03 16:17:30', null, '1');
    68. 

  68. INSERT INTO `sys_dict_data` VALUES ('93', '发运状态', 'tran_status', '已驳回', '25', null, '2020-11-05 08:27:55', '2020-11-05 08:28:08', null, '1');
    69. 

  69. INSERT INTO `sys_dict_data` VALUES ('94', '承运状态', 'car_status', '已接货', '40', null, '2020-11-06 09:53:14', '2020-11-06 09:53:14', null, '1');
    70. 

  70. INSERT INTO `sys_dict_data` VALUES ('95', '承运状态', 'car_status', '待结算', '50', null, '2020-11-06 09:53:30', '2020-11-06 09:53:30', null, '1');
    71. 

  71. INSERT INTO `sys_dict_data` VALUES ('97', '承运状态', 'car_status', '待付款', '70', null, '2020-11-06 09:55:00', '2020-11-10 08:27:25', null, '1');
    72. 

  72. INSERT INTO `sys_dict_data` VALUES ('98', '承运状态', 'car_status', '已付款', '80', null, '2020-11-06 09:55:14', '2020-11-06 09:55:14', null, '1');
    73. 

  73. INSERT INTO `sys_dict_data` VALUES ('99', '承运状态', 'car_status', '待匹配', '15', null, '2020-11-06 10:00:37', '2020-11-06 10:00:37', null, '1');
    74. 

  74. INSERT INTO `sys_dict_data` VALUES ('101', '承运状态', 'car_status', '待接单', '13', null, '2020-11-09 09:06:30', '2020-11-09 09:06:30', null, '1');
    75. 

  75. INSERT INTO `sys_dict_data` VALUES ('102', '承运状态', 'car_status', '待完善', '12', null, '2020-11-09 09:06:49', '2020-11-09 09:06:49', null, '1');
    76. 

  76. INSERT INTO `sys_dict_data` VALUES ('103', '承运状态', 'car_status', '已拒接', '90', null, '2020-11-09 10:10:41', '2020-11-09 10:10:41', null, '1');
    77. 

  77. INSERT INTO `sys_dict_data` VALUES ('104', '承运状态', 'car_status', '待签运输合同', '25', null, '2020-11-09 14:43:01', '2020-11-09 14:43:01', null, '1');
    78. 

  78. INSERT INTO `sys_dict_data` VALUES ('105', '物流部电话', 'tran_phone', '电话1', '15663330336', null, '2020-11-16 08:28:53', '2020-12-14 18:15:43', null, '1');
    79. 

  79. INSERT INTO `sys_dict_data` VALUES ('106', '订单状态', 'work_status', '待审核', '10', null, '2020-11-16 16:39:14', '2020-11-16 16:39:14', null, '1');
    80. 

  80. INSERT INTO `sys_dict_data` VALUES ('107', '订单状态', 'work_status', '待发运', '20', null, '2020-11-16 16:39:58', '2020-11-16 16:39:58', null, '1');
    81. 

  81. INSERT INTO `sys_dict_data` VALUES ('108', '订单状态', 'work_status', '已驳回', '25', null, '2020-11-16 16:40:33', '2020-11-16 16:40:33', null, '1');
    82. 

  82. INSERT INTO `sys_dict_data` VALUES ('109', '订单状态', 'work_status', '待完货', '30', null, '2020-11-16 16:40:53', '2020-11-17 11:23:34', null, '1');
    83. 

  83. INSERT INTO `sys_dict_data` VALUES ('110', '订单状态', 'work_status', '已完成', '40', null, '2020-11-16 16:41:12', '2020-11-16 16:41:12', null, '1');
    84. 

  84. INSERT INTO `sys_dict_data` VALUES ('111', '收款状态', 'collect_status', '待回款', '10', null, '2020-11-16 17:24:33', '2020-11-16 17:24:33', null, '1');
    85. 

  85. INSERT INTO `sys_dict_data` VALUES ('112', '收款状态', 'collect_status', '已完成', '20', null, '2020-11-16 17:24:50', '2020-11-16 17:24:50', null, '1');
    86. 

  86. INSERT INTO `sys_dict_data` VALUES ('113', '订单详情状态', 'workDetail_status', '已发运', '10', null, '2020-11-17 10:36:56', '2020-11-17 10:39:45', null, '1');
    87. 

  87. INSERT INTO `sys_dict_data` VALUES ('114', '订单详情状态', 'workDetail_status', '已交货', '20', null, '2020-11-17 10:37:27', '2020-11-19 09:27:49', null, '1');
    88. 

  88. INSERT INTO `sys_dict_data` VALUES ('115', '付款类型', 'pay_type', '装车付款', '0', null, '2020-11-17 15:36:31', '2020-11-17 15:36:31', null, '1');
    89. 

  89. INSERT INTO `sys_dict_data` VALUES ('116', '付款类型', 'pay_type', '预付款', '1', null, '2020-11-17 15:36:58', '2020-11-17 15:36:58', null, '1');
    90. 

  90. INSERT INTO `sys_dict_data` VALUES ('117', '订单详情状态', 'workDetail_status', '待完善', '0', null, '2020-11-18 08:53:20', '2020-11-18 08:53:20', null, '1');
    91. 

  91. INSERT INTO `sys_dict_data` VALUES ('118', '订单详情状态', 'workDetail_status', '已放货', '30', null, '2020-11-19 09:28:10', '2020-11-19 09:28:10', null, '1');
    92. 

  92. INSERT INTO `sys_dict_data` VALUES ('119', '订单详情状态', 'workDetail_status', '已完成', '40', null, '2020-11-19 09:28:36', '2020-11-19 09:28:36', null, '1');
    93. 

  93. INSERT INTO `sys_dict_data` VALUES ('120', '付款状态', 'pay_status', '待回款', '10', null, '2020-12-13 14:07:57', '2020-12-13 14:07:57', null, '1');
    94. 

  94. INSERT INTO `sys_dict_data` VALUES ('121', '付款状态', 'pay_status', '已完成', '20', null, '2020-12-13 14:08:22', '2020-12-13 14:08:22', null, '1');
    95. 

  95. INSERT INTO `sys_dict_data` VALUES ('124', '发运状态', 'tran_status', '未填报', '15', null, '2020-12-14 14:08:39', '2020-12-14 14:08:39', null, '1');
    96. 

  96. INSERT INTO `sys_dict_data` VALUES ('125', '收款方式', 'payment_method', '现金收款', '30', null, '2021-01-26 14:37:44', '2021-01-26 14:37:44', null, '1');
    97. 

  97. INSERT INTO `sys_dict_data` VALUES ('126', '收款方式', 'payment_method', '网银收款', '20', null, '2021-01-26 14:38:09', '2021-01-26 14:38:09', null, '1');
    98. 

  98. INSERT INTO `sys_dict_data` VALUES ('127', '收款方式', 'payment_method', '预收款', '10', null, '2021-01-26 14:38:27', '2021-01-26 14:38:27', null, '1');
    99. 

  99. INSERT INTO `sys_dict_data` VALUES ('128', '发运状态', 'tran_status', '已回款', '50', null, '2021-02-01 10:38:55', '2021-02-01 10:38:55', null, '1');
    100. 

  100. INSERT INTO `sys_dict_data` VALUES ('129', '订单状态', 'work_status', '已回款', '50', null, '2021-02-01 10:39:14', '2021-02-01 10:39:14', null, '1');
    101. 

  101. INSERT INTO `sys_dict_data` VALUES ('130', '采购类型', 'work_type', '库内自采', '10', null, '2021-02-02 11:21:40', '2021-02-02 11:24:33', null, '1');
    102. 

  102. INSERT INTO `sys_dict_data` VALUES ('131', '采购类型', 'work_type', '外采(含运费)', '20', null, '2021-02-02 11:23:26', '2021-02-02 11:24:37', null, '1');
    103. 

  103. INSERT INTO `sys_dict_data` VALUES ('132', '采购类型', 'work_type', '外采(不含运费)', '30', null, '2021-02-02 11:23:58', '2021-02-02 11:24:40', null, '1');
    104. 

  104. INSERT INTO `sys_dict_data` VALUES ('133', '承运状态', 'car_status', '待付粮款', '27', null, '2021-02-02 15:30:34', '2021-02-02 15:30:34', null, '1');
    105. 

  105. INSERT INTO `sys_dict_data` VALUES ('134', '承运状态', 'car_status', '待付运费', '45', null, '2021-02-02 15:57:38', '2021-02-02 15:57:38', null, '1');
    106. 

  106. INSERT INTO `sys_dict_data` VALUES ('135', '销售状态', 'sale_status', '未申请', '10', '8', '2020-10-22 08:33:00', '2020-11-03 10:17:00', null, '2');
    107. 

  107. INSERT INTO `sys_dict_data` VALUES ('136', '销售状态', 'sale_status', '未定价', '20', '9', '2020-10-22 08:34:00', '2020-11-03 10:14:00', null, '2');
    108. 

  108. INSERT INTO `sys_dict_data` VALUES ('137', '销售状态', 'sale_status', '销售中', '30', '10', '2020-10-22 08:34:00', '2020-11-03 10:14:00', null, '2');
    109. 

  109. INSERT INTO `sys_dict_data` VALUES ('138', '采购状态', 'buy_status', '未生效', '10', '12', '2020-10-22 09:01:00', '2020-11-13 10:48:00', null, '2');
    110. 

  110. INSERT INTO `sys_dict_data` VALUES ('139', '采购状态', 'buy_status', '已生效', '20', '11', '2020-10-22 09:01:00', '2020-11-13 10:48:00', null, '2');
    111. 

  111. INSERT INTO `sys_dict_data` VALUES ('140', '采购状态', 'buy_status', '待审核', '15', '13', '2020-10-22 09:02:00', '2020-11-13 10:48:00', null, '2');
    112. 

  112. INSERT INTO `sys_dict_data` VALUES ('141', '新闻类型', 'news_type', '工厂价格', '0', '15', '2020-10-22 14:14:00', '2020-11-03 10:15:00', null, '2');
    113. 

  113. INSERT INTO `sys_dict_data` VALUES ('142', '新闻类型', 'news_type', '港口价格', '1', '16', '2020-10-22 14:15:00', '2020-11-03 10:15:00', null, '2');
    114. 

  114. INSERT INTO `sys_dict_data` VALUES ('143', '新闻类型', 'news_type', '行业新闻', '2', '17', '2020-10-22 14:15:00', '2020-11-03 10:15:00', null, '2');
    115. 

  115. INSERT INTO `sys_dict_data` VALUES ('144', '发运状态', 'tran_status', '生效中', '30', '18', '2020-10-22 14:40:00', '2020-11-03 16:16:00', null, '2');
    116. 

  116. INSERT INTO `sys_dict_data` VALUES ('145', '发运状态', 'tran_status', '已完成', '40', '19', '2020-10-22 14:40:00', '2020-11-03 16:16:00', null, '2');
    117. 

  117. INSERT INTO `sys_dict_data` VALUES ('146', '发运状态', 'tran_status', '待定价', '20', '20', '2020-10-22 14:40:00', '2020-11-04 09:14:00', null, '2');
    118. 

  118. INSERT INTO `sys_dict_data` VALUES ('147', '承运状态', 'car_status', '待审核', '10', '21', '2020-10-22 15:13:00', '2020-11-06 09:50:00', null, '2');
    119. 

  119. INSERT INTO `sys_dict_data` VALUES ('148', '承运状态', 'car_status', '可发运', '20', '22', '2020-10-22 15:14:00', '2020-11-06 11:01:00', null, '2');
    120. 

  120. INSERT INTO `sys_dict_data` VALUES ('149', '承运状态', 'car_status', '已发运', '30', '23', '2020-10-22 15:14:00', '2020-11-06 09:52:00', null, '2');
    121. 

  121. INSERT INTO `sys_dict_data` VALUES ('150', '合同类型', 'contract_type', '销售', '0', '0', '2020-11-01 12:29:00', '2020-11-03 10:17:00', null, '2');
    122. 

  122. INSERT INTO `sys_dict_data` VALUES ('151', '合同类型', 'contract_type', '采购', '1', '1', '2020-11-01 12:30:00', '2020-11-03 10:17:00', null, '2');
    123. 

  123. INSERT INTO `sys_dict_data` VALUES ('152', '销售状态', 'sale_status', '已下架', '40', '11', '2020-11-02 12:53:00', '2020-11-03 10:17:00', null, '2');
    124. 

  124. INSERT INTO `sys_dict_data` VALUES ('153', '销售状态', 'sale_status', '未审核', '21', '13', '2020-11-02 12:57:00', '2020-11-03 10:17:00', null, '2');
    125. 

  125. INSERT INTO `sys_dict_data` VALUES ('154', '产品等级', 'food_type', '一等品', '0', '27', '2020-11-02 13:23:00', '2020-11-03 10:18:00', null, '2');
    126. 

  126. INSERT INTO `sys_dict_data` VALUES ('155', '产品等级', 'food_type', '二等品', '1', '28', '2020-11-02 13:24:00', '2020-11-03 10:18:00', null, '2');
    127. 

  127. INSERT INTO `sys_dict_data` VALUES ('156', '产品等级', 'food_type', '三等品', '2', '29', '2020-11-02 13:24:00', '2020-11-03 10:18:00', null, '2');
    128. 

  128. INSERT INTO `sys_dict_data` VALUES ('157', '出库方式', 'sale_type', '移库', '0', '0', '2020-11-03 08:57:00', '2020-11-03 10:14:00', null, '2');
    129. 

  129. INSERT INTO `sys_dict_data` VALUES ('158', '出库方式', 'sale_type', '散船平仓', '1', '1', '2020-11-03 08:57:00', '2020-11-03 10:15:00', null, '2');
    130. 

  130. INSERT INTO `sys_dict_data` VALUES ('159', '出库方式', 'sale_type', '装箱进港', '2', '2', '2020-11-03 08:58:00', '2020-11-03 10:15:00', null, '2');
    131. 

  131. INSERT INTO `sys_dict_data` VALUES ('160', '出库方式', 'sale_type', '库内销售', '3', '3', '2020-11-03 10:15:00', '2020-11-03 10:15:00', null, '2');
    132. 

  132. INSERT INTO `sys_dict_data` VALUES ('161', '出库方式', 'sale_type', '运送到厂', '4', '4', '2020-11-03 10:18:00', '2020-11-03 10:18:00', null, '2');
    133. 

  133. INSERT INTO `sys_dict_data` VALUES ('162', '发运状态', 'tran_status', '待审核', '10', '10', '2020-11-03 16:17:00', '2020-11-03 16:17:00', null, '2');
    134. 

  134. INSERT INTO `sys_dict_data` VALUES ('163', '发运状态', 'tran_status', '已驳回', '25', null, '2020-11-05 08:27:00', '2020-11-05 08:28:00', null, '2');
    135. 

  135. INSERT INTO `sys_dict_data` VALUES ('164', '承运状态', 'car_status', '已接货', '40', null, '2020-11-06 09:53:00', '2020-11-06 09:53:00', null, '2');
    136. 

  136. INSERT INTO `sys_dict_data` VALUES ('165', '承运状态', 'car_status', '待结算', '50', null, '2020-11-06 09:53:00', '2020-11-06 09:53:00', null, '2');
    137. 

  137. INSERT INTO `sys_dict_data` VALUES ('166', '承运状态', 'car_status', '待付款', '70', null, '2020-11-06 09:55:00', '2020-11-10 08:27:00', null, '2');
    138. 

  138. INSERT INTO `sys_dict_data` VALUES ('167', '承运状态', 'car_status', '已付款', '80', null, '2020-11-06 09:55:00', '2020-11-06 09:55:00', null, '2');
    139. 

  139. INSERT INTO `sys_dict_data` VALUES ('168', '承运状态', 'car_status', '待匹配', '15', null, '2020-11-06 10:00:00', '2020-11-06 10:00:00', null, '2');
    140. 

  140. INSERT INTO `sys_dict_data` VALUES ('169', '承运状态', 'car_status', '待接单', '13', null, '2020-11-09 09:06:00', '2020-11-09 09:06:00', null, '2');
    141. 

  141. INSERT INTO `sys_dict_data` VALUES ('170', '承运状态', 'car_status', '待完善', '12', null, '2020-11-09 09:06:00', '2020-11-09 09:06:00', null, '2');
    142. 

  142. INSERT INTO `sys_dict_data` VALUES ('171', '承运状态', 'car_status', '已拒接', '90', null, '2020-11-09 10:10:00', '2020-11-09 10:10:00', null, '2');
    143. 

  143. INSERT INTO `sys_dict_data` VALUES ('172', '承运状态', 'car_status', '待签运输合同', '25', null, '2020-11-09 14:43:00', '2020-11-09 14:43:00', null, '2');
    144. 

  144. INSERT INTO `sys_dict_data` VALUES ('173', '物流部电话', 'tran_phone', '电话1', '15663330336', null, '2020-11-16 08:28:00', '2020-12-14 18:15:00', null, '2');
    145. 

  145. INSERT INTO `sys_dict_data` VALUES ('174', '订单状态', 'work_status', '待审核', '10', null, '2020-11-16 16:39:00', '2020-11-16 16:39:00', null, '2');
    146. 

  146. INSERT INTO `sys_dict_data` VALUES ('175', '订单状态', 'work_status', '待发运', '20', null, '2020-11-16 16:39:00', '2020-11-16 16:39:00', null, '2');
    147. 

  147. INSERT INTO `sys_dict_data` VALUES ('176', '订单状态', 'work_status', '已驳回', '25', null, '2020-11-16 16:40:00', '2020-11-16 16:40:00', null, '2');
    148. 

  148. INSERT INTO `sys_dict_data` VALUES ('177', '订单状态', 'work_status', '待完货', '30', null, '2020-11-16 16:40:00', '2020-11-17 11:23:00', null, '2');
    149. 

  149. INSERT INTO `sys_dict_data` VALUES ('178', '订单状态', 'work_status', '已完成', '40', null, '2020-11-16 16:41:00', '2020-11-16 16:41:00', null, '2');
    150. 

  150. INSERT INTO `sys_dict_data` VALUES ('179', '收款状态', 'collect_status', '待回款', '10', null, '2020-11-16 17:24:00', '2020-11-16 17:24:00', null, '2');
    151. 

  151. INSERT INTO `sys_dict_data` VALUES ('180', '收款状态', 'collect_status', '已完成', '20', null, '2020-11-16 17:24:00', '2020-11-16 17:24:00', null, '2');
    152. 

  152. INSERT INTO `sys_dict_data` VALUES ('181', '订单详情状态', 'workDetail_status', '已发运', '10', null, '2020-11-17 10:36:00', '2020-11-17 10:39:00', null, '2');
    153. 

  153. INSERT INTO `sys_dict_data` VALUES ('182', '订单详情状态', 'workDetail_status', '已交货', '20', null, '2020-11-17 10:37:00', '2020-11-19 09:27:00', null, '2');
    154. 

  154. INSERT INTO `sys_dict_data` VALUES ('183', '付款类型', 'pay_type', '装车付款', '0', null, '2020-11-17 15:36:00', '2020-11-17 15:36:00', null, '2');
    155. 

  155. INSERT INTO `sys_dict_data` VALUES ('184', '付款类型', 'pay_type', '预付款', '1', null, '2020-11-17 15:36:00', '2020-11-17 15:36:00', null, '2');
    156. 

  156. INSERT INTO `sys_dict_data` VALUES ('185', '订单详情状态', 'workDetail_status', '待完善', '0', null, '2020-11-18 08:53:00', '2020-11-18 08:53:00', null, '2');
    157. 

  157. INSERT INTO `sys_dict_data` VALUES ('186', '订单详情状态', 'workDetail_status', '已放货', '30', null, '2020-11-19 09:28:00', '2020-11-19 09:28:00', null, '2');
    158. 

  158. INSERT INTO `sys_dict_data` VALUES ('187', '订单详情状态', 'workDetail_status', '已完成', '40', null, '2020-11-19 09:28:00', '2020-11-19 09:28:00', null, '2');
    159. 

  159. INSERT INTO `sys_dict_data` VALUES ('188', '付款状态', 'pay_status', '待回款', '10', null, '2020-12-13 14:07:00', '2020-12-13 14:07:00', null, '2');
    160. 

  160. INSERT INTO `sys_dict_data` VALUES ('189', '付款状态', 'pay_status', '已完成', '20', null, '2020-12-13 14:08:00', '2020-12-13 14:08:00', null, '2');
    161. 

  161. INSERT INTO `sys_dict_data` VALUES ('190', '发运状态', 'tran_status', '未填报', '15', null, '2020-12-14 14:08:00', '2020-12-14 14:08:00', null, '2');
    162. 

  162. INSERT INTO `sys_dict_data` VALUES ('191', '收款方式', 'payment_method', '现金收款', '30', null, '2021-01-26 14:37:00', '2021-01-26 14:37:00', null, '2');
    163. 

  163. INSERT INTO `sys_dict_data` VALUES ('192', '收款方式', 'payment_method', '网银收款', '20', null, '2021-01-26 14:38:00', '2021-01-26 14:38:00', null, '2');
    164. 

  164. INSERT INTO `sys_dict_data` VALUES ('193', '收款方式', 'payment_method', '预收款', '10', null, '2021-01-26 14:38:00', '2021-01-26 14:38:00', null, '2');
    165. 

  165. INSERT INTO `sys_dict_data` VALUES ('194', '发运状态', 'tran_status', '已回款', '50', null, '2021-02-01 10:38:00', '2021-02-01 10:38:00', null, '2');
    166. 

  166. INSERT INTO `sys_dict_data` VALUES ('195', '订单状态', 'work_status', '已回款', '50', null, '2021-02-01 10:39:00', '2021-02-01 10:39:00', null, '2');
    167. 

  167. INSERT INTO `sys_dict_data` VALUES ('196', '采购类型', 'work_type', '库内自采', '10', null, '2021-02-02 11:21:00', '2021-02-02 11:24:00', null, '2');
    168. 

  168. INSERT INTO `sys_dict_data` VALUES ('197', '采购类型', 'work_type', '外采(含运费)', '20', null, '2021-02-02 11:23:00', '2021-02-02 11:24:00', null, '2');
    169. 

  169. INSERT INTO `sys_dict_data` VALUES ('198', '采购类型', 'work_type', '外采(不含运费)', '30', null, '2021-02-02 11:23:00', '2021-02-02 11:24:00', null, '2');
    170. 

  170. INSERT INTO `sys_dict_data` VALUES ('199', '承运状态', 'car_status', '待付粮款', '27', null, '2021-02-02 15:30:00', '2021-02-02 15:30:00', null, '2');
    171. 

  171. INSERT INTO `sys_dict_data` VALUES ('200', '承运状态', 'car_status', '待付运费', '45', null, '2021-02-02 15:57:00', '2021-02-02 15:57:00', null, '2');
    172. 

  172. INSERT INTO `sys_dict_data` VALUES ('201', '运输类型', 'tran_type', '汽运', '0', null, '2021-03-10 09:11:15', '2021-03-10 09:11:15', null, '1');
    173. 

  173. INSERT INTO `sys_dict_data` VALUES ('202', '运输类型', 'tran_type', '火运', '1', null, '2021-03-10 09:11:28', '2021-03-10 09:11:28', null, '1');
    174. 

  174. INSERT INTO `sys_dict_data` VALUES ('204', '运输条款', 'tran_clause', '门-门', 'DR-DR', null, '2021-03-18 16:12:47', '2021-03-18 16:12:47', null, '1');
    175. 

  175. INSERT INTO `sys_dict_data` VALUES ('205', '运输条款', 'tran_clause', '港-门', 'CY-DR', null, '2021-03-18 16:14:58', '2021-03-18 16:14:58', null, '1');
    176. 

  176. INSERT INTO `sys_dict_data` VALUES ('206', '运输条款', 'tran_clause', '门-港', 'DR-CY', null, '2021-03-18 16:15:44', '2021-03-18 16:15:44', null, '1');
    177. 

  177. INSERT INTO `sys_dict_data` VALUES ('207', '运输条款', 'tran_clause', '港-港', 'CY-CY', null, '2021-03-18 16:16:08', '2021-03-18 16:16:08', null, '1');
    178. 

  178. INSERT INTO `sys_dict_data` VALUES ('208', '运输条款', 'train_clause', '门-站', 'DR-ST', null, '2021-03-18 16:20:19', '2021-03-18 16:35:17', null, '1');
    179. 

  179. INSERT INTO `sys_dict_data` VALUES ('209', '运输条款', 'train_clause', '站-门', 'ST-DR', null, '2021-03-18 16:20:41', '2021-03-18 16:35:10', null, '1');
    180. 

  180. INSERT INTO `sys_dict_data` VALUES ('210', '运输条款', 'train_clause', '站-站', 'ST-ST', null, '2021-03-18 16:21:09', '2021-03-18 16:35:05', null, '1');
    181. 

  181. INSERT INTO `sys_dict_data` VALUES ('211', '运输条款', 'train_clause', '门-门', 'DR-DR', null, '2021-03-18 16:36:23', '2021-03-18 16:36:36', null, '1');
    182. 

  182. INSERT INTO `sys_dict_data` VALUES ('212', '报表状态', 'report_status', '未审核', '0', null, '2021-04-01 11:38:39', '2021-04-01 11:38:39', null, '1');
    183. 

  183. INSERT INTO `sys_dict_data` VALUES ('213', '报表状态', 'report_status', '统计已审核', '1', null, '2021-04-01 11:38:55', '2021-04-01 11:38:55', null, '1');
    184. 

  184. INSERT INTO `sys_dict_data` VALUES ('214', '报表状态', 'report_status', '财务已审核', '2', null, '2021-04-01 11:39:15', '2021-04-01 11:39:15', null, '1');
    185. 

  185. INSERT INTO `sys_dict_data` VALUES ('215', '报表状态', 'report_status', '决策人已审核', '3', null, '2021-04-01 11:39:33', '2021-04-01 11:39:33', null, '1');
    186. 

  186. INSERT INTO `sys_dict_data` VALUES ('216', '报表状态', 'report_status', '已付款', '4', null, '2021-04-01 11:39:52', '2021-04-01 11:39:52', null, '1');
    187. 

  187. INSERT INTO `sys_dict_data` VALUES ('217', '报表状态', 'report_status', '未审核', '0', null, '2021-04-01 15:31:44', '2021-04-01 15:31:44', null, '2');
    188. 

  188. INSERT INTO `sys_dict_data` VALUES ('218', '报表状态', 'report_status', '统计已审核', '1', null, '2021-04-01 15:32:13', '2021-04-01 15:32:13', null, '2');
    189. 

  189. INSERT INTO `sys_dict_data` VALUES ('219', '报表状态', 'report_status', '财务已审核', '2', null, '2021-04-01 15:32:31', '2021-04-01 15:32:31', null, '2');
    190. 

  190. INSERT INTO `sys_dict_data` VALUES ('220', '报表状态', 'report_status', '决策人已审核', '3', null, '2021-04-01 15:32:58', '2021-04-01 15:32:58', null, '2');
    191. 

  191. INSERT INTO `sys_dict_data` VALUES ('221', '报表状态', 'report_status', '部分付款', '4', null, '2021-04-01 15:33:12', '2021-04-15 10:05:27', null, '2');
    192. 

  192. INSERT INTO `sys_dict_data` VALUES ('222', '货品名称', 'goods_name', '玉米', '0', null, '2021-04-08 10:05:45', '2021-04-08 10:05:45', null, '1');
    193. 

  193. INSERT INTO `sys_dict_data` VALUES ('223', '货品名称', 'goods_name', '大豆', '1', null, '2021-04-08 10:06:00', '2021-04-08 10:06:00', null, '1');
    194. 

  194. INSERT INTO `sys_dict_data` VALUES ('224', '货品名称', 'goods_name', '玉米', '0', null, '2021-04-08 10:05:45', '2021-04-08 10:05:45', null, '2');
    195. 

  195. INSERT INTO `sys_dict_data` VALUES ('225', '货品名称', 'goods_name', '大豆', '1', null, '2021-04-08 10:06:00', '2021-04-08 10:06:00', null, '2');
    196. 

  196. INSERT INTO `sys_dict_data` VALUES ('226', '物流类型', 'trans_type', '我司派车', '0', null, '2021-04-08 15:26:30', '2021-04-08 15:26:30', null, '1');
    197. 

  197. INSERT INTO `sys_dict_data` VALUES ('227', '物流类型', 'trans_type', '客户自理', '1', null, '2021-04-08 15:26:56', '2021-04-08 15:26:56', null, '1');
    198. 

  198. INSERT INTO `sys_dict_data` VALUES ('228', '报表状态', 'report_status', '已付款', '5', null, '2021-04-15 10:05:42', '2021-04-15 10:05:42', null, '2');
    199. 

  199. INSERT INTO `sys_dict_data` VALUES ('229', '交易状态', 'trade_status', '未审核', '0', null, '2021-04-23 08:13:21', '2021-04-23 08:13:21', null, '2');
    200. 

  200. INSERT INTO `sys_dict_data` VALUES ('230', '交易状态', 'trade_status', '待决策人审核', '1', null, '2021-04-23 08:13:46', '2021-04-23 08:13:46', null, '2');
    201. 

  201. INSERT INTO `sys_dict_data` VALUES ('231', '交易状态', 'trade_status', '已审核', '2', null, '2021-04-23 08:14:18', '2021-04-23 08:14:18', null, '2');
    202. 

  202. INSERT INTO `sys_dict_data` VALUES ('232', '交易状态', 'trade_status', '已成交', '3', null, '2021-04-23 08:14:41', '2021-04-23 08:14:41', null, '2');
    203. 

  203. INSERT INTO `sys_dict_data` VALUES ('233', '交易状态', 'trade_status', '已完成', '4', null, '2021-05-10 14:30:09', '2021-05-10 14:30:09', null, '2');
    204. 

  204. 

  205. -- ----------------------------
    206. 

  206. -- Table structure for unimall_admin
    207. 

  207. -- ----------------------------
    208. 

  208. DROP TABLE IF EXISTS `unimall_admin`;
    209. 

  209. CREATE TABLE `unimall_admin` (
    210. 

  210.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键ID',
    211. 

  211.   `username` varchar(255) DEFAULT NULL COMMENT '管理员昵称',
    212. 

  212.   `password` varchar(255) DEFAULT NULL COMMENT '管理员登录密码',
    213. 

  213.   `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
    214. 

  214.   `realname` varchar(255) DEFAULT NULL COMMENT '真实姓名',
    215. 

  215.   `company_id` bigint(20) DEFAULT NULL COMMENT '公司ID',
    216. 

  216.   `avatar_url` varchar(255) DEFAULT NULL COMMENT '头像地址',
    217. 

  217.   `role_ids` varchar(255) DEFAULT NULL COMMENT '管理员角色 JSON 数据',
    218. 

  218.   `status` int(11) NOT NULL COMMENT '0.冻结 1.激活',
    219. 

  219.   `last_login_ip` varchar(255) DEFAULT NULL COMMENT '最后登录ip',
    220. 

  220.   `gmt_last_login` datetime NOT NULL COMMENT '最后登录时间',
    221. 

  221.   `gmt_update` datetime NOT NULL COMMENT '更新时间',
    222. 

  222.   `gmt_create` datetime NOT NULL COMMENT '创建时间',
    223. 

  223.   PRIMARY KEY (`id`),
    224. 

  224.   UNIQUE KEY `unimall_admin_id_uindex` (`id`) USING BTREE,
    225. 

  225.   UNIQUE KEY `username` (`username`(30)) USING BTREE
    226. 

  226. ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4;
    227. 

  227. 

  228. -- ----------------------------
    229. 

  229. -- Records of unimall_admin
    230. 

  230. -- ----------------------------
    231. 

  231. INSERT INTO `unimall_admin` VALUES ('1', 'admin', '2c71711fd16eaebf8e43b86a9afb0b48', '18241771147', '系统管理员11', '1', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/ef1c5af8d1c34582a5bcda0d48ef9437.png', '[1]', '1', '127.0.0.1', '2019-04-08 22:12:04', '2022-05-15 13:01:24', '2019-04-08 22:12:12');
    232. 

  232. 

  233. -- ----------------------------
    234. 

  234. -- Table structure for unimall_company
    235. 

  235. -- ----------------------------
    236. 

  236. DROP TABLE IF EXISTS `unimall_company`;
    237. 

  237. CREATE TABLE `unimall_company` (
    238. 

  238.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键ID',
    239. 

  239.   `company_name` varchar(255) DEFAULT NULL COMMENT '公司名称',
    240. 

  240.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    241. 

  241.   `gmt_update` datetime DEFAULT NULL COMMENT '更新时间',
    242. 

  242.   `admin_id` bigint(20) DEFAULT NULL COMMENT '管理员id',
    243. 

  243.   `identification_no` varchar(100) DEFAULT NULL COMMENT '纳税人识别号',
    244. 

  244.   `company_bank` varchar(100) DEFAULT NULL COMMENT '公司开户行',
    245. 

  245.   `account_no` varchar(100) DEFAULT NULL COMMENT '公司账户',
    246. 

  246.   `company_place` varchar(100) DEFAULT NULL COMMENT '公司地址',
    247. 

  247.   `company_phone` varchar(100) DEFAULT NULL COMMENT '公司电话',
    248. 

  248.   `user_id` bigint(20) DEFAULT NULL,
    249. 

  249.   `person_no_img` varchar(100) DEFAULT NULL,
    250. 

  250.   `person_no_img1` varchar(100) DEFAULT NULL,
    251. 

  251.   `bank_img` varchar(100) DEFAULT NULL,
    252. 

  252.   `bank_img1` varchar(100) DEFAULT NULL,
    253. 

  253.   `bank_name_zhi` varchar(100) DEFAULT NULL,
    254. 

  254.   `person_name` varchar(100) DEFAULT NULL,
    255. 

  255.   `person_no` varchar(100) DEFAULT NULL,
    256. 

  256.   `renown` int(20) DEFAULT NULL,
    257. 

  257.   `collect_name` varchar(100) DEFAULT NULL COMMENT '收款人姓名',
    258. 

  258.   `bond` double(20,4) DEFAULT '0.0000' COMMENT '保证金',
    259. 

  259.   `margin_level` varchar(50) DEFAULT NULL COMMENT '保证金比例',
    260. 

  260.   `used_deposit` double(20,4) DEFAULT '0.0000' COMMENT '已用保证金',
    261. 

  261.   `return_flag` varchar(20) DEFAULT NULL COMMENT '退回保证金标识',
    262. 

  262.   PRIMARY KEY (`id`)
    263. 

  263. ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4;
    264. 

  264. 

  265. -- ----------------------------
    266. 

  266. -- Records of unimall_company
    267. 

  267. -- ----------------------------
    268. 

  268. INSERT INTO `unimall_company` VALUES ('1', '黑龙江中天昊元贸易有限公司', '2021-02-02 19:14:12', '2021-02-02 19:14:12', '1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0.0000', '700', '0.0000', '0');
    269. 

  269. INSERT INTO `unimall_company` VALUES ('2', '辽宁佳屹农商贸有限公司', '2021-02-03 10:12:49', '2021-02-03 10:12:49', '1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0.0000', '700', '0.0000', '1');
    270. 

  270. 

  271. -- ----------------------------
    272. 

  272. -- Table structure for unimall_config
    273. 

  273. -- ----------------------------
    274. 

  274. DROP TABLE IF EXISTS `unimall_config`;
    275. 

  275. CREATE TABLE `unimall_config` (
    276. 

  276.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    277. 

  277.   `key_word` varchar(60) DEFAULT NULL COMMENT '关键字',
    278. 

  278.   `value_worth` varchar(100) DEFAULT NULL COMMENT '值',
    279. 

  279.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    280. 

  280.   `gmt_update` datetime DEFAULT NULL COMMENT '更新时间',
    281. 

  281.   `company_id` bigint(20) DEFAULT NULL COMMENT '公司ID',
    282. 

  282.   PRIMARY KEY (`id`)
    283. 

  283. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
    284. 

  284. 

  285. -- ----------------------------
    286. 

  286. -- Records of unimall_config
    287. 

  287. -- ----------------------------
    288. 

  288. INSERT INTO `unimall_config` VALUES ('1', 'title', '5', '2019-07-20 11:23:37', '2019-07-20 11:23:37', null);
    289. 

  289. INSERT INTO `unimall_config` VALUES ('2', 'logoUrl', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/3a20237b18c44356891890f6e2260c03.jpg', '2019-07-20 11:23:37', '2019-07-20 11:23:37', null);
    290. 

  290. INSERT INTO `unimall_config` VALUES ('3', 'description', '6', '2019-07-20 11:23:37', '2019-07-20 11:23:37', null);
    291. 

  291. INSERT INTO `unimall_config` VALUES ('4', 'address', '7', '2019-07-20 11:23:37', '2019-07-20 11:23:37', null);
    292. 

  292. INSERT INTO `unimall_config` VALUES ('5', 'showType', '2', '2019-07-20 11:23:37', '2019-07-20 11:23:37', null);
    293. 

  293. INSERT INTO `unimall_config` VALUES ('6', 'bankAppCode', '2d59bfa794994f5f94d1d98b7b5bd102', '2020-11-12 16:45:53', '2020-11-12 16:45:53', null);
    294. 

  294. 

  295. -- ----------------------------
    296. 

  296. -- Table structure for unimall_img
    297. 

  297. -- ----------------------------
    298. 

  298. DROP TABLE IF EXISTS `unimall_img`;
    299. 

  299. CREATE TABLE `unimall_img` (
    300. 

  300.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    301. 

  301.   `biz_type` int(11) NOT NULL,
    302. 

  302.   `biz_id` bigint(20) NOT NULL,
    303. 

  303.   `url` varchar(255) NOT NULL,
    304. 

  304.   `gmt_update` datetime NOT NULL,
    305. 

  305.   `gmt_create` datetime NOT NULL,
    306. 

  306.   `company_id` bigint(20) DEFAULT NULL,
    307. 

  307.   PRIMARY KEY (`id`)
    308. 

  308. ) ENGINE=InnoDB AUTO_INCREMENT=3046 DEFAULT CHARSET=utf8mb4;
    309. 

  309. 

  310. -- ----------------------------
    311. 

  311. -- Records of unimall_img
    312. 

  312. -- ----------------------------
    313. 

  313. INSERT INTO `unimall_img` VALUES ('200', '2', '2', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/2e801f1184bf45bc819791f0a7d2f573.png', '2019-04-25 19:15:55', '2019-04-25 19:15:55', null);
    314. 

  314. INSERT INTO `unimall_img` VALUES ('201', '2', '1', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/2e801f1184bf45bc819791f0a7d2f573.png', '2019-04-25 19:15:55', '2019-04-25 19:15:55', null);
    315. 

  315. INSERT INTO `unimall_img` VALUES ('202', '2', '3', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/2e801f1184bf45bc819791f0a7d2f573.png', '2019-04-25 19:15:55', '2019-04-25 19:15:55', null);
    316. 

  316. INSERT INTO `unimall_img` VALUES ('203', '2', '4', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/2e801f1184bf45bc819791f0a7d2f573.png', '2019-04-25 19:15:55', '2019-04-25 19:15:55', null);
    317. 

  317. INSERT INTO `unimall_img` VALUES ('204', '2', '5', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/ef1c5af8d1c34582a5bcda0d48ef9437.png', '2019-07-07 00:30:37', '2019-07-07 00:30:37', null);
    318. 

  318. INSERT INTO `unimall_img` VALUES ('205', '2', '6', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/ef1c5af8d1c34582a5bcda0d48ef9437.png', '2019-07-07 00:32:02', '2019-07-07 00:32:02', null);
    319. 

  319. INSERT INTO `unimall_img` VALUES ('206', '2', '7', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/imgs/3FzdQarcKQr5kkt.png', '2019-07-11 17:49:25', '2019-07-11 17:49:25', null);
    320. 

  320. INSERT INTO `unimall_img` VALUES ('208', '2', '9', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/imgs/eMSD6B5D5BEH8zH.jpg', '2019-07-14 09:58:45', '2019-07-14 09:58:45', null);
    321. 

  321. INSERT INTO `unimall_img` VALUES ('209', '2', '9', 'https://easycampus-ops.oss-cn-shenzhen.aliyuncs.com/imgs/yrmCrRE5FR8XWMH.jpg', '2019-07-14 09:58:45', '2019-07-14 09:58:45', null);
    322. 

  322. INSERT INTO `unimall_img` VALUES ('3014', '1', '1236769', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/55c59f82af4e4aefb9f78ce2484b9f36.png', '2019-08-21 12:53:05', '2019-08-21 12:53:05', null);
    323. 

  323. INSERT INTO `unimall_img` VALUES ('3015', '1', '1236769', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/8ffee2727cbe4c07ab95cf25ca1946bd.png', '2019-08-21 12:53:05', '2019-08-21 12:53:05', null);
    324. 

  324. INSERT INTO `unimall_img` VALUES ('3016', '1', '1236770', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/2b86ba9cfc0c40fc82f7741c06270f36.jpg', '2019-08-21 12:53:11', '2019-08-21 12:53:11', null);
    325. 

  325. INSERT INTO `unimall_img` VALUES ('3017', '1', '1236770', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/a705b7cc22f14d80b5107b9f8b9f7713.jpg', '2019-08-21 12:53:11', '2019-08-21 12:53:11', null);
    326. 

  326. INSERT INTO `unimall_img` VALUES ('3018', '1', '1236771', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/86338c9e576342baa0d079bc1caef9cc.jpg', '2019-08-21 12:53:17', '2019-08-21 12:53:17', null);
    327. 

  327. INSERT INTO `unimall_img` VALUES ('3019', '1', '1236771', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/3f1e780b9f0c4cde948af3dcfbfe7ece.jpg', '2019-08-21 12:53:17', '2019-08-21 12:53:17', null);
    328. 

  328. INSERT INTO `unimall_img` VALUES ('3020', '1', '1236772', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/e48b4f8c1c824e1a9b9f349be0275648.jpg', '2019-08-21 12:53:23', '2019-08-21 12:53:23', null);
    329. 

  329. INSERT INTO `unimall_img` VALUES ('3021', '1', '1236772', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/1546107f29274241b539380f9eba41a2.jpg', '2019-08-21 12:53:23', '2019-08-21 12:53:23', null);
    330. 

  330. INSERT INTO `unimall_img` VALUES ('3022', '1', '1236772', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/d850d0faea3a406bb057cd1813fa9c78.jpg', '2019-08-21 12:53:23', '2019-08-21 12:53:23', null);
    331. 

  331. INSERT INTO `unimall_img` VALUES ('3023', '1', '1236773', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/4f817407a019439da765bf0dc5e7b3b7.jpg', '2019-08-21 12:53:36', '2019-08-21 12:53:36', null);
    332. 

  332. INSERT INTO `unimall_img` VALUES ('3024', '1', '1236773', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/435904c4297341839fc388679a550194.jpg', '2019-08-21 12:53:36', '2019-08-21 12:53:36', null);
    333. 

  333. INSERT INTO `unimall_img` VALUES ('3025', '1', '1236773', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/a9b89d4306fc4134965aabecd125636a.jpg', '2019-08-21 12:53:36', '2019-08-21 12:53:36', null);
    334. 

  334. INSERT INTO `unimall_img` VALUES ('3029', '1', '1236776', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/22014e1c20c441949b9e90ef63fa0f64.jpg', '2019-08-21 12:54:02', '2019-08-21 12:54:02', null);
    335. 

  335. INSERT INTO `unimall_img` VALUES ('3030', '1', '1236777', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/2e6c6eeefaf94fac94fcc1157d2fa037.jpeg', '2019-08-21 12:54:08', '2019-08-21 12:54:08', null);
    336. 

  336. INSERT INTO `unimall_img` VALUES ('3033', '1', '1236775', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/a407352b0c6745ceb3be31a8fa50820f.jpg', '2019-08-23 18:03:42', '2019-08-23 18:03:42', null);
    337. 

  337. INSERT INTO `unimall_img` VALUES ('3034', '1', '1236775', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/d424f75591254a5db702dad28467dee8.jpg', '2019-08-23 18:03:42', '2019-08-23 18:03:42', null);
    338. 

  338. INSERT INTO `unimall_img` VALUES ('3042', '1', '1236768', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/eae3baf6b6114139840320f06f4398f7.jpg', '2020-02-14 15:55:10', '2020-02-14 15:55:10', null);
    339. 

  339. INSERT INTO `unimall_img` VALUES ('3043', '1', '1236768', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/883b7d8828e24896889530884c76f88f.jpg', '2020-02-14 15:55:10', '2020-02-14 15:55:10', null);
    340. 

  340. INSERT INTO `unimall_img` VALUES ('3044', '1', '1236768', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/c5cbc9826fc242b1a251546141014197.jpg', '2020-02-14 15:55:10', '2020-02-14 15:55:10', null);
    341. 

  341. INSERT INTO `unimall_img` VALUES ('3045', '1', '1236782', 'https://unimall-demo.oss-cn-shenzhen.aliyuncs.com/bg/34a3a981bcb84f35aec8ceb7ef9a6f6f.png', '2020-02-14 16:37:42', '2020-02-14 16:37:42', null);
    342. 

  342. 

  343. -- ----------------------------
    344. 

  344. -- Table structure for unimall_message
    345. 

  345. -- ----------------------------
    346. 

  346. DROP TABLE IF EXISTS `unimall_message`;
    347. 

  347. CREATE TABLE `unimall_message` (
    348. 

  348.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    349. 

  349.   `customer` varchar(255) DEFAULT NULL,
    350. 

  350.   `operation` varchar(255) DEFAULT NULL,
    351. 

  351.   `result` varchar(255) DEFAULT NULL,
    352. 

  352.   `status` int(11) DEFAULT NULL,
    353. 

  353.   `task_id` bigint(20) DEFAULT NULL,
    354. 

  354.   `path` varchar(255) DEFAULT NULL COMMENT '消息跳转路径',
    355. 

  355.   `gmt_create` datetime DEFAULT NULL,
    356. 

  356.   `gmt_update` datetime DEFAULT NULL,
    357. 

  357.   `admin_id` bigint(20) DEFAULT NULL,
    358. 

  358.   `user_id` bigint(20) DEFAULT NULL,
    359. 

  359.   `company_id` bigint(20) DEFAULT NULL,
    360. 

  360.   PRIMARY KEY (`id`)
    361. 

  361. ) ENGINE=MyISAM AUTO_INCREMENT=1044 DEFAULT CHARSET=utf8mb4;
    362. 

  362. 

  363. -- ----------------------------
    364. 

  364. -- Records of unimall_message
    365. 

  365. -- ----------------------------
    366. 

  366. INSERT INTO `unimall_message` VALUES ('1003', '交易信息：THL202107204154211101', ' 已成交，', '请及时收款', null, null, '/finance/collect', '2021-07-24 09:27:36', '2021-07-24 09:27:36', null, null, '2');
    367. 

  367. INSERT INTO `unimall_message` VALUES ('1004', '交易单号:THL202107204154211101', '成交', '成交价:6000.0', null, null, '/sale/trade', '2021-07-24 09:27:36', '2021-07-24 09:27:36', null, '1781', '2');
    368. 

  368. INSERT INTO `unimall_message` VALUES ('1005', '交易单号:THL202107205133843103', '成交', '成交价:5990.0', null, null, '/sale/trade', '2021-07-24 13:54:18', '2021-07-24 13:54:18', null, '1781', '2');
    369. 

  369. INSERT INTO `unimall_message` VALUES ('1006', '交易单号:THL202107205140401105', '成交', '成交价:6000.0', null, null, '/sale/trade', '2021-07-24 14:12:33', '2021-07-24 14:12:33', null, '1781', '2');
    370. 

  370. INSERT INTO `unimall_message` VALUES ('1007', '交易单号:THL202107205143340101', '成交', '成交价:5850.0', null, null, '/sale/trade', '2021-07-24 14:43:34', '2021-07-24 14:43:34', null, '1781', '2');
    371. 

  371. INSERT INTO `unimall_message` VALUES ('1008', '交易单号:THL202107205150016102', '成交', '成交价:5980.0', null, null, '/sale/trade', '2021-07-24 15:06:34', '2021-07-24 15:06:34', null, '1781', '2');
    372. 

  372. INSERT INTO `unimall_message` VALUES ('1009', '客户[杨万峰]的车辆[0035]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-24 16:41:19', '2021-07-24 16:41:19', null, '1829', '2');
    373. 

  373. INSERT INTO `unimall_message` VALUES ('1010', '客户[杨万峰]的车辆[辽H84343]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-24 17:01:53', '2021-07-24 17:01:53', null, '1842', '2');
    374. 

  374. INSERT INTO `unimall_message` VALUES ('1011', '客户[杨万峰]的车辆[0035]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:15:37', '2021-07-25 09:15:37', null, '1842', '2');
    375. 

  375. INSERT INTO `unimall_message` VALUES ('1012', '客户[杨万峰]的车辆[4605]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:18:18', '2021-07-25 09:18:18', null, '1842', '2');
    376. 

  376. INSERT INTO `unimall_message` VALUES ('1013', '客户[杨万峰]的车辆[辽H17920]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:21:02', '2021-07-25 09:21:02', null, '1842', '2');
    377. 

  377. INSERT INTO `unimall_message` VALUES ('1014', '客户[杨万峰]的车辆[17920]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:24:37', '2021-07-25 09:24:37', null, '1842', '2');
    378. 

  378. INSERT INTO `unimall_message` VALUES ('1015', '客户[杨万峰]的车辆[辽H83437]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:26:01', '2021-07-25 09:26:01', null, '1842', '2');
    379. 

  379. INSERT INTO `unimall_message` VALUES ('1016', '客户[杨万峰]的车辆[辽H62967]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:28:02', '2021-07-25 09:28:02', null, '1842', '2');
    380. 

  380. INSERT INTO `unimall_message` VALUES ('1017', '客户[杨万峰]的车辆[辽H17920]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:29:40', '2021-07-25 09:29:40', null, '1842', '2');
    381. 

  381. INSERT INTO `unimall_message` VALUES ('1018', '客户[杨万峰]的车辆[83437]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:31:46', '2021-07-25 09:31:46', null, '1842', '2');
    382. 

  382. INSERT INTO `unimall_message` VALUES ('1019', '客户[杨万峰]的车辆[辽HK5896]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-25 09:33:49', '2021-07-25 09:33:49', null, '1842', '2');
    383. 

  383. INSERT INTO `unimall_message` VALUES ('1020', '客户[庞守涛]', ' 已确认[黑MB2938]车辆卸货，', '请及时申请付款', null, null, '/report/tradeTotal', '2021-07-26 08:44:51', '2021-07-26 08:44:51', null, null, '2');
    384. 

  384. INSERT INTO `unimall_message` VALUES ('1021', '客户[庞守涛]', ' 已确认[辽HA1676]车辆卸货，', '请及时申请付款', null, null, '/report/tradeTotal', '2021-07-26 08:45:04', '2021-07-26 08:45:04', null, null, '2');
    385. 

  385. INSERT INTO `unimall_message` VALUES ('1022', '客户[庞守涛]', ' 已确认[黑DA6662]车辆卸货，', '请及时申请付款', null, null, '/report/tradeTotal', '2021-07-26 08:45:06', '2021-07-26 08:45:06', null, null, '2');
    386. 

  386. INSERT INTO `unimall_message` VALUES ('1023', '客户[方子成]', ' 已确认[黑ME7937]车辆卸货，', '请及时申请付款', null, null, '/report/tradeTotal', '2021-07-26 08:45:52', '2021-07-26 08:45:52', null, null, '2');
    387. 

  387. INSERT INTO `unimall_message` VALUES ('1024', '交易信息：THL202107207085531101', ' 已成交，', '请及时收款', null, null, '/finance/collect', '2021-07-26 09:11:33', '2021-07-26 09:11:33', null, null, '2');
    388. 

  388. INSERT INTO `unimall_message` VALUES ('1025', '交易单号:THL202107207085531101', '成交', '成交价:6000.0', null, null, '/sale/trade', '2021-07-26 09:11:33', '2021-07-26 09:11:33', null, '1781', '2');
    389. 

  389. INSERT INTO `unimall_message` VALUES ('1026', '客户[庞守涛]', ' 已确认[黑B75687]车辆卸货，', '请及时申请付款', null, null, '/report/tradeTotal', '2021-07-26 09:45:29', '2021-07-26 09:45:29', null, null, '2');
    390. 

  390. INSERT INTO `unimall_message` VALUES ('1027', '客户[杨万峰]的车辆[1751]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 09:55:22', '2021-07-26 09:55:22', null, '1842', '2');
    391. 

  391. INSERT INTO `unimall_message` VALUES ('1028', '客户[杨万峰]的车辆[83460]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 09:56:39', '2021-07-26 09:56:39', null, '1842', '2');
    392. 

  392. INSERT INTO `unimall_message` VALUES ('1029', '客户[杨万峰]的车辆[60531]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 09:58:06', '2021-07-26 09:58:06', null, '1842', '2');
    393. 

  393. INSERT INTO `unimall_message` VALUES ('1030', '客户[杨万峰]的车辆[7155]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 09:59:29', '2021-07-26 09:59:29', null, '1842', '2');
    394. 

  394. INSERT INTO `unimall_message` VALUES ('1031', '客户[杨万峰]的车辆[1378]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:01:12', '2021-07-26 10:01:12', null, '1842', '2');
    395. 

  395. INSERT INTO `unimall_message` VALUES ('1032', '客户[杨万峰]的车辆[0035]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:02:20', '2021-07-26 10:02:20', null, '1842', '2');
    396. 

  396. INSERT INTO `unimall_message` VALUES ('1033', '客户[杨万峰]的车辆[7151]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:03:31', '2021-07-26 10:03:31', null, '1842', '2');
    397. 

  397. INSERT INTO `unimall_message` VALUES ('1034', '客户[杨万峰]的车辆[7155]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:04:35', '2021-07-26 10:04:35', null, '1842', '2');
    398. 

  398. INSERT INTO `unimall_message` VALUES ('1035', '客户[杨万峰]的车辆[1378]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:05:35', '2021-07-26 10:05:35', null, '1842', '2');
    399. 

  399. INSERT INTO `unimall_message` VALUES ('1036', '客户[杨万峰]的车辆[87463]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:06:46', '2021-07-26 10:06:46', null, '1842', '2');
    400. 

  400. INSERT INTO `unimall_message` VALUES ('1037', '客户[杨万峰]的车辆[4805]', '已经出库', '点击查看详细信息', null, null, '/report/tradeTotal', '2021-07-26 10:18:23', '2021-07-26 10:18:23', null, '1829', '2');
    401. 

  401. INSERT INTO `unimall_message` VALUES ('1038', '交易信息：THL202107207145620105', ' 已成交，', '请及时收款', null, null, '/finance/collect', '2021-07-26 15:12:08', '2021-07-26 15:12:08', null, null, '2');
    402. 

  402. INSERT INTO `unimall_message` VALUES ('1039', '交易单号:THL202107207145620105', '成交', '成交价:5000.0', null, null, '/sale/trade', '2021-07-26 15:12:08', '2021-07-26 15:12:08', null, '1611', '2');
    403. 

  403. INSERT INTO `unimall_message` VALUES ('1040', '交易信息：THL202107207145809106', ' 已成交，', '请及时收款', null, null, '/finance/collect', '2021-07-26 15:12:21', '2021-07-26 15:12:21', null, null, '2');
    404. 

  404. INSERT INTO `unimall_message` VALUES ('1041', '交易单号:THL202107207145809106', '成交', '成交价:5100.0', null, null, '/sale/trade', '2021-07-26 15:12:21', '2021-07-26 15:12:21', null, '1611', '2');
    405. 

  405. INSERT INTO `unimall_message` VALUES ('1042', '交易单号:THL202107207151617113', '成交', '成交价:6000.0', null, null, '/sale/trade', '2021-07-26 15:18:42', '2021-07-26 15:18:42', null, '1772', '2');
    406. 

  406. INSERT INTO `unimall_message` VALUES ('1043', '统计', ' 已审核，', '请及时审核', null, null, '/report/tradeTotal', '2021-07-26 16:33:37', '2021-07-26 16:33:37', null, null, '2');
    407. 

  407. 

  408. -- ----------------------------
    409. 

  409. -- Table structure for unimall_role
    410. 

  410. -- ----------------------------
    411. 

  411. DROP TABLE IF EXISTS `unimall_role`;
    412. 

  412. CREATE TABLE `unimall_role` (
    413. 

  413.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    414. 

  414.   `name` varchar(63) DEFAULT NULL,
    415. 

  415.   `desc` varchar(1023) DEFAULT NULL,
    416. 

  416.   `status` int(11) NOT NULL DEFAULT '1' COMMENT '0.冻结 1.激活',
    417. 

  417.   `gmt_update` datetime NOT NULL COMMENT '更新时间',
    418. 

  418.   `gmt_create` datetime NOT NULL,
    419. 

  419.   `company_id` bigint(20) DEFAULT NULL,
    420. 

  420.   PRIMARY KEY (`id`)
    421. 

  421. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
    422. 

  422. 

  423. -- ----------------------------
    424. 

  424. -- Records of unimall_role
    425. 

  425. -- ----------------------------
    426. 

  426. INSERT INTO `unimall_role` VALUES ('1', '超级管理员', '所有模块的权限', '1', '2019-04-08 22:40:45', '2019-04-08 22:40:50', '1');
    427. 

  427. 

  428. -- ----------------------------
    429. 

  429. -- Table structure for unimall_role_permission
    430. 

  430. -- ----------------------------
    431. 

  431. DROP TABLE IF EXISTS `unimall_role_permission`;
    432. 

  432. CREATE TABLE `unimall_role_permission` (
    433. 

  433.   `id` int(11) NOT NULL AUTO_INCREMENT,
    434. 

  434.   `role_id` int(11) NOT NULL COMMENT '角色ID',
    435. 

  435.   `permission` varchar(63) DEFAULT NULL,
    436. 

  436.   `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
    437. 

  437.   `gmt_update` datetime NOT NULL COMMENT '更新时间',
    438. 

  438.   `gmt_create` datetime NOT NULL COMMENT '创建时间',
    439. 

  439.   `company_id` bigint(20) DEFAULT NULL,
    440. 

  440.   PRIMARY KEY (`id`)
    441. 

  441. ) ENGINE=InnoDB AUTO_INCREMENT=7368 DEFAULT CHARSET=utf8mb4 COMMENT='权限表';
    442. 

  442. 

  443. -- ----------------------------
    444. 

  444. -- Records of unimall_role_permission
    445. 

  445. -- ----------------------------
    446. 

  446. INSERT INTO `unimall_role_permission` VALUES ('1', '1', '*', '0', '2020-08-02 20:33:44', '2020-08-02 20:33:47', null);
    447. 

  447. 

  448. -- ----------------------------
    449. 

  449. -- Table structure for unimall_user
    450. 

  450. -- ----------------------------
    451. 

  451. DROP TABLE IF EXISTS `unimall_user`;
    452. 

  452. CREATE TABLE `unimall_user` (
    453. 

  453.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    454. 

  454.   `phone` varchar(155) DEFAULT NULL,
    455. 

  455.   `password` varchar(155) DEFAULT NULL,
    456. 

  456.   `login_type` int(11) NOT NULL,
    457. 

  457.   `union_id` varchar(100) DEFAULT NULL,
    458. 

  458.   `open_id` varchar(155) DEFAULT NULL,
    459. 

  459.   `nickname` varchar(155) DEFAULT NULL,
    460. 

  460.   `role_ids` varchar(255) DEFAULT NULL,
    461. 

  461.   `avatar_url` varchar(155) DEFAULT NULL,
    462. 

  462.   `user_name` varchar(155) DEFAULT NULL,
    463. 

  463.   `birthday` date DEFAULT NULL,
    464. 

  464.   `gender` int(11) DEFAULT '-1',
    465. 

  465.   `gmt_last_login` datetime DEFAULT NULL,
    466. 

  466.   `last_login_ip` varchar(155) DEFAULT NULL,
    467. 

  467.   `status` int(11) DEFAULT '1',
    468. 

  468.   `gmt_update` datetime NOT NULL,
    469. 

  469.   `gmt_create` datetime NOT NULL,
    470. 

  470.   `sign_img` varchar(255) DEFAULT NULL,
    471. 

  471.   `wechat_no` varchar(100) DEFAULT NULL,
    472. 

  472.   `company_id` bigint(20) DEFAULT NULL,
    473. 

  473.   `access_token` varchar(255) DEFAULT NULL,
    474. 

  474.   `official_open_id` varchar(150) DEFAULT NULL COMMENT '公众号',
    475. 

  475.   `liangxin_id` varchar(150) DEFAULT NULL COMMENT '粮信userID',
    476. 

  476.   `cid` varchar(255) DEFAULT NULL COMMENT '推送id',
    477. 

  477.   PRIMARY KEY (`id`),
    478. 

  478.   UNIQUE KEY `unimall_user_phone_uindex` (`id`) USING BTREE
    479. 

  479. ) ENGINE=MyISAM AUTO_INCREMENT=2030 DEFAULT CHARSET=utf8mb4;
    480. 

  480. 

  481. -- ----------------------------
    482. 

  482. -- Records of unimall_user
    483. 

  483. -- ----------------------------
    484.