Home Explore Help
Sign In
Gyee_web
/
Gyee_sis_phone_nx
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Gyee_sis_pho...
/
doc
/
gyee_frame.sql

gyee_frame.sql 63 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 127.0.0.1_3306
    5. 

  5. Source Server Version : 50725
    6. 

  6. Source Host           : 127.0.0.1:3306
    7. 

  7. Source Database       : gyee
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50725
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2019-11-21 00:26:22
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

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

  19. -- Table structure for t_sys_area
    20. 

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

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

  22. CREATE TABLE `t_sys_area` (
    23. 

  23.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
    24. 

  24.   `area_code` varchar(40) NOT NULL COMMENT '区代码',
    25. 

  25.   `city_code` varchar(40) DEFAULT NULL COMMENT '父级市代码',
    26. 

  26.   `area_name` varchar(40) NOT NULL COMMENT '市名称',
    27. 

  27.   `short_name` varchar(20) NOT NULL COMMENT '简称',
    28. 

  28.   `lng` varchar(20) DEFAULT NULL COMMENT '经度',
    29. 

  29.   `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
    30. 

  30.   `sort` int(6) DEFAULT NULL COMMENT '排序',
    31. 

  31.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    32. 

  32.   `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
    33. 

  33.   `memo` varchar(250) DEFAULT NULL COMMENT '备注',
    34. 

  34.   `data_state` int(11) DEFAULT NULL COMMENT '状态',
    35. 

  35.   PRIMARY KEY (`id`),
    36. 

  36.   KEY `Index_1` (`area_code`)
    37. 

  37. ) ENGINE=InnoDB AUTO_INCREMENT=2013 DEFAULT CHARSET=utf8 COMMENT='地区设置';
    38. 

  38. 

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

  40. -- Records of t_sys_area
    41. 

  41. -- ----------------------------
    42. 

  42. INSERT INTO `t_sys_area` VALUES ('1975', '500101', '500100', '万州区', '万州', '108.380249', '30.807808', '28', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    43. 

  43. INSERT INTO `t_sys_area` VALUES ('1976', '500102', '500100', '涪陵区', '涪陵', '107.394905', '29.703651', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    44. 

  44. INSERT INTO `t_sys_area` VALUES ('1977', '500103', '500100', '渝中区', '渝中', '106.562881', '29.556742', '37', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    45. 

  45. INSERT INTO `t_sys_area` VALUES ('1978', '500104', '500100', '大渡口区', '大渡口', '106.48613', '29.481003', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    46. 

  46. INSERT INTO `t_sys_area` VALUES ('1979', '500105', '500100', '江北区', '江北', '106.532845', '29.575352', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    47. 

  47. INSERT INTO `t_sys_area` VALUES ('1980', '500106', '500100', '沙坪坝区', '沙坪坝', '106.454201', '29.541224', '24', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    48. 

  48. INSERT INTO `t_sys_area` VALUES ('1981', '500107', '500100', '九龙坡区', '九龙坡', '106.480988', '29.523493', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    49. 

  49. INSERT INTO `t_sys_area` VALUES ('1982', '500108', '500100', '南岸区', '南岸', '106.560814', '29.523993', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    50. 

  50. INSERT INTO `t_sys_area` VALUES ('1983', '500109', '500100', '北碚区', '北碚', '106.437866', '29.82543', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    51. 

  51. INSERT INTO `t_sys_area` VALUES ('1984', '500112', '500100', '渝北区', '渝北', '106.512848', '29.601452', '35', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    52. 

  52. INSERT INTO `t_sys_area` VALUES ('1985', '500113', '500100', '巴南区', '巴南', '106.519424', '29.38192', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    53. 

  53. INSERT INTO `t_sys_area` VALUES ('1986', '500114', '500100', '黔江区', '黔江', '108.782578', '29.527548', '21', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    54. 

  54. INSERT INTO `t_sys_area` VALUES ('1987', '500115', '500100', '长寿区', '长寿', '107.074852', '29.833672', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    55. 

  55. INSERT INTO `t_sys_area` VALUES ('1988', '500222', '500100', '綦江区', '綦江', '106.651421', '29.028091', '22', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    56. 

  56. INSERT INTO `t_sys_area` VALUES ('1989', '500223', '500100', '潼南县', '潼南', '105.84182', '30.189554', '27', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    57. 

  57. INSERT INTO `t_sys_area` VALUES ('1990', '500224', '500100', '铜梁县', '铜梁', '106.054947', '29.839945', '26', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    58. 

  58. INSERT INTO `t_sys_area` VALUES ('1991', '500225', '500100', '大足区', '大足', '105.715317', '29.700499', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    59. 

  59. INSERT INTO `t_sys_area` VALUES ('1992', '500226', '500100', '荣昌县', '荣昌', '105.594063', '29.403627', '23', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    60. 

  60. INSERT INTO `t_sys_area` VALUES ('1993', '500227', '500100', '璧山县', '璧山', '106.231125', '29.59358', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    61. 

  61. INSERT INTO `t_sys_area` VALUES ('1994', '500228', '500100', '梁平县', '梁平', '107.800034', '30.672169', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    62. 

  62. INSERT INTO `t_sys_area` VALUES ('1995', '500229', '500100', '城口县', '城口', '108.664902', '31.946293', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    63. 

  63. INSERT INTO `t_sys_area` VALUES ('1996', '500230', '500100', '丰都县', '丰都', '107.732483', '29.866425', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    64. 

  64. INSERT INTO `t_sys_area` VALUES ('1997', '500231', '500100', '垫江县', '垫江', '107.348694', '30.330011', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    65. 

  65. INSERT INTO `t_sys_area` VALUES ('1998', '500232', '500100', '武隆县', '武隆', '107.756554', '29.323759', '29', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    66. 

  66. INSERT INTO `t_sys_area` VALUES ('1999', '500233', '500100', '忠县', '忠县', '108.037521', '30.291536', '38', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    67. 

  67. INSERT INTO `t_sys_area` VALUES ('2000', '500234', '500100', '开县', '开县', '108.413315', '31.167734', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    68. 

  68. INSERT INTO `t_sys_area` VALUES ('2001', '500235', '500100', '云阳县', '云阳', '108.697701', '30.930529', '36', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    69. 

  69. INSERT INTO `t_sys_area` VALUES ('2002', '500236', '500100', '奉节县', '奉节', '109.465775', '31.019966', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    70. 

  70. INSERT INTO `t_sys_area` VALUES ('2003', '500237', '500100', '巫山县', '巫山', '109.878929', '31.074842', '30', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    71. 

  71. INSERT INTO `t_sys_area` VALUES ('2004', '500238', '500100', '巫溪县', '巫溪', '109.628914', '31.396601', '31', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    72. 

  72. INSERT INTO `t_sys_area` VALUES ('2005', '500240', '500100', '石柱土家族自治县', '石柱', '108.11245', '29.998529', '25', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    73. 

  73. INSERT INTO `t_sys_area` VALUES ('2006', '500241', '500100', '秀山土家族苗族自治县', '秀山', '108.99604', '28.444773', '32', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    74. 

  74. INSERT INTO `t_sys_area` VALUES ('2007', '500242', '500100', '酉阳土家族苗族自治县', '酉阳', '108.767204', '28.839828', '34', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    75. 

  75. INSERT INTO `t_sys_area` VALUES ('2008', '500243', '500100', '彭水苗族土家族自治县', '彭水', '108.16655', '29.293856', '20', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    76. 

  76. INSERT INTO `t_sys_area` VALUES ('2009', '500381', '500100', '江津区', '江津', '106.253159', '29.283386', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    77. 

  77. INSERT INTO `t_sys_area` VALUES ('2010', '500382', '500100', '合川区', '合川', '106.265556', '29.990993', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    78. 

  78. INSERT INTO `t_sys_area` VALUES ('2011', '500383', '500100', '永川区', '永川', '105.894714', '29.348747', '33', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    79. 

  79. INSERT INTO `t_sys_area` VALUES ('2012', '500384', '500100', '南川区', '南川', '107.098152', '29.156647', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    80. 

  80. 

  81. -- ----------------------------
    82. 

  82. -- Table structure for t_sys_city
    83. 

  83. -- ----------------------------
    84. 

  84. DROP TABLE IF EXISTS `t_sys_city`;
    85. 

  85. CREATE TABLE `t_sys_city` (
    86. 

  86.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
    87. 

  87.   `city_code` varchar(40) NOT NULL COMMENT '市代码',
    88. 

  88.   `city_name` varchar(40) NOT NULL COMMENT '市名称',
    89. 

  89.   `short_name` varchar(20) NOT NULL COMMENT '简称',
    90. 

  90.   `province_code` varchar(40) DEFAULT NULL COMMENT '省代码',
    91. 

  91.   `lng` varchar(20) DEFAULT NULL COMMENT '经度',
    92. 

  92.   `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
    93. 

  93.   `sort` int(6) DEFAULT NULL COMMENT '排序',
    94. 

  94.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    95. 

  95.   `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
    96. 

  96.   `memo` varchar(250) DEFAULT NULL COMMENT '备注',
    97. 

  97.   `data_state` int(11) DEFAULT NULL COMMENT '状态',
    98. 

  98.   PRIMARY KEY (`id`),
    99. 

  99.   KEY `Index_1` (`city_code`)
    100. 

  100. ) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COMMENT='城市设置';
    101. 

  101. 

  102. -- ----------------------------
    103. 

  103. -- Records of t_sys_city
    104. 

  104. -- ----------------------------
    105. 

  105. INSERT INTO `t_sys_city` VALUES ('255', '500100', '重庆市', '重庆', '500000', '106.504959', '29.533155', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    106. 

  106. 

  107. -- ----------------------------
    108. 

  108. -- Table structure for t_sys_datas
    109. 

  109. -- ----------------------------
    110. 

  110. DROP TABLE IF EXISTS `t_sys_datas`;
    111. 

  111. CREATE TABLE `t_sys_datas` (
    112. 

  112.   `id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '主键',
    113. 

  113.   `file_path` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '文件地址',
    114. 

  114.   `file_suffix` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '后缀',
    115. 

  115.   PRIMARY KEY (`id`)
    116. 

  116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='文件表存储表';
    117. 

  117. 

  118. -- ----------------------------
    119. 

  119. -- Records of t_sys_datas
    120. 

  120. -- ----------------------------
    121. 

  121. INSERT INTO `t_sys_datas` VALUES ('354984152409444352', 'static/images_upload/655e075657837d5f18a8371b66b8a230.jpg', '.jpg');
    122. 

  122. 

  123. -- ----------------------------
    124. 

  124. -- Table structure for t_sys_dict_data
    125. 

  125. -- ----------------------------
    126. 

  126. DROP TABLE IF EXISTS `t_sys_dict_data`;
    127. 

  127. CREATE TABLE `t_sys_dict_data` (
    128. 

  128.   `id` varchar(255) NOT NULL COMMENT '主键',
    129. 

  129.   `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
    130. 

  130.   `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
    131. 

  131.   `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
    132. 

  132.   `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
    133. 

  133.   `css_class` varchar(100) DEFAULT '' COMMENT '样式属性（其他样式扩展）',
    134. 

  134.   `list_class` varchar(100) DEFAULT '' COMMENT '表格回显样式',
    135. 

  135.   `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    136. 

  136.   `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    137. 

  137.   `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
    138. 

  138.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    139. 

  139.   `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
    140. 

  140.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    141. 

  141.   `remark` varchar(500) DEFAULT '' COMMENT '备注',
    142. 

  142.   PRIMARY KEY (`id`)
    143. 

  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典数据表';
    144. 

  144. 

  145. -- ----------------------------
    146. 

  146. -- Records of t_sys_dict_data
    147. 

  147. -- ----------------------------
    148. 

  148. INSERT INTO `t_sys_dict_data` VALUES ('331043380933038080', '1', '一般', '1', 'sys_notice_type', '', 'info', 'Y', '0', 'admin', '2019-09-09 22:15:03', 'admin', '2019-09-09 22:15:43', '');
    149. 

  149. INSERT INTO `t_sys_dict_data` VALUES ('331043525137403904', '2', '重要', '2', 'sys_notice_type', '', 'important', 'N', '0', 'admin', '2019-09-09 22:15:37', 'admin', '2019-09-11 00:30:04', '');
    150. 

  150. INSERT INTO `t_sys_dict_data` VALUES ('340080322395901952', '1', '开启', '0', 'sys_province_state', '', 'info', 'Y', '0', 'admin', '2019-10-04 20:44:37', 'admin', '2019-10-04 20:46:41', '');
    151. 

  151. INSERT INTO `t_sys_dict_data` VALUES ('340080779201744896', '2', '关闭', '-1', 'sys_province_state', '', 'important', 'Y', '0', 'admin', '2019-10-04 20:46:26', 'admin', '2019-10-04 20:46:45', '');
    152. 

  152. 

  153. -- ----------------------------
    154. 

  154. -- Table structure for t_sys_dict_type
    155. 

  155. -- ----------------------------
    156. 

  156. DROP TABLE IF EXISTS `t_sys_dict_type`;
    157. 

  157. CREATE TABLE `t_sys_dict_type` (
    158. 

  158.   `id` varchar(255) NOT NULL COMMENT '主键',
    159. 

  159.   `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
    160. 

  160.   `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
    161. 

  161.   `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    162. 

  162.   `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
    163. 

  163.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    164. 

  164.   `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
    165. 

  165.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    166. 

  166.   `remark` varchar(500) DEFAULT '' COMMENT '备注',
    167. 

  167.   PRIMARY KEY (`id`),
    168. 

  168.   UNIQUE KEY `dict_type` (`dict_type`)
    169. 

  169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典类型表';
    170. 

  170. 

  171. -- ----------------------------
    172. 

  172. -- Records of t_sys_dict_type
    173. 

  173. -- ----------------------------
    174. 

  174. INSERT INTO `t_sys_dict_type` VALUES ('340079827459641344', '省份状态', 'sys_province_state', '0', 'admin', '2019-10-04 20:42:39', '', '2019-10-04 20:42:39', '省份状态');
    175. 

  175. INSERT INTO `t_sys_dict_type` VALUES ('6', '通知类型', 'sys_notice_type', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-09-15 00:29:19', '通知类型列表');
    176. 

  176. 

  177. -- ----------------------------
    178. 

  178. -- Table structure for t_sys_email
    179. 

  179. -- ----------------------------
    180. 

  180. DROP TABLE IF EXISTS `t_sys_email`;
    181. 

  181. CREATE TABLE `t_sys_email` (
    182. 

  182.   `id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '主键',
    183. 

  183.   `receivers_email` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '接收人电子邮件',
    184. 

  184.   `title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '邮件标题',
    185. 

  185.   `content` text COLLATE utf8_bin COMMENT '内容',
    186. 

  186.   `send_user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '发送人id',
    187. 

  187.   `send_user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '发送人账号',
    188. 

  188.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    189. 

  189.   PRIMARY KEY (`id`)
    190. 

  190. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='电子邮件';
    191. 

  191. 

  192. -- ----------------------------
    193. 

  193. -- Records of t_sys_email
    194. 

  194. -- ----------------------------
    195. 

  195. INSERT INTO `t_sys_email` VALUES ('595001021625794560', '87766867@qq.com', 'springbootv2测试邮件', 0x3C703EE6B58BE8AF95E6B58BE6B58BE6B58B3C2F703E, '1', 'admin', '2019-06-30 21:21:38');
    196. 

  196. 

  197. -- ----------------------------
    198. 

  198. -- Table structure for t_sys_file
    199. 

  199. -- ----------------------------
    200. 

  200. DROP TABLE IF EXISTS `t_sys_file`;
    201. 

  201. CREATE TABLE `t_sys_file` (
    202. 

  202.   `id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '主键',
    203. 

  203.   `file_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片名字',
    204. 

  204.   `create_user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人id',
    205. 

  205.   `create_user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人名字',
    206. 

  206.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    207. 

  207.   `update_user_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
    208. 

  208.   `update_user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人名字',
    209. 

  209.   `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    210. 

  210.   PRIMARY KEY (`id`)
    211. 

  211. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='文件信息表';
    212. 

  212. 

  213. -- ----------------------------
    214. 

  214. -- Records of t_sys_file
    215. 

  215. -- ----------------------------
    216. 

  216. INSERT INTO `t_sys_file` VALUES ('354984159875305472', '3333', '1', 'admin', '2019-11-14 23:47:09', null, null, null);
    217. 

  217. 

  218. -- ----------------------------
    219. 

  219. -- Table structure for t_sys_file_data
    220. 

  220. -- ----------------------------
    221. 

  221. DROP TABLE IF EXISTS `t_sys_file_data`;
    222. 

  222. CREATE TABLE `t_sys_file_data` (
    223. 

  223.   `id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '主键',
    224. 

  224.   `data_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '数据id',
    225. 

  225.   `file_id` varchar(255) COLLATE utf8_bin DEFAULT '文件id' COMMENT '文件id',
    226. 

  226.   PRIMARY KEY (`id`)
    227. 

  227. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='文件数据外键绑定表';
    228. 

  228. 

  229. -- ----------------------------
    230. 

  230. -- Records of t_sys_file_data
    231. 

  231. -- ----------------------------
    232. 

  232. INSERT INTO `t_sys_file_data` VALUES ('354984159875305473', '354984152409444352', '354984159875305472');
    233. 

  233. 

  234. -- ----------------------------
    235. 

  235. -- Table structure for t_sys_notice
    236. 

  236. -- ----------------------------
    237. 

  237. DROP TABLE IF EXISTS `t_sys_notice`;
    238. 

  238. CREATE TABLE `t_sys_notice` (
    239. 

  239.   `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
    240. 

  240.   `title` varchar(255) DEFAULT NULL COMMENT '标题',
    241. 

  241.   `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '内容',
    242. 

  242.   `type` int(5) DEFAULT NULL COMMENT '类型',
    243. 

  243.   `create_id` varchar(255) DEFAULT NULL COMMENT '创建人id',
    244. 

  244.   `create_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '创建人name',
    245. 

  245.   `create_time` datetime DEFAULT NULL COMMENT '发信时间',
    246. 

  246.   PRIMARY KEY (`id`)
    247. 

  247. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公告';
    248. 

  248. 

  249. -- ----------------------------
    250. 

  250. -- Records of t_sys_notice
    251. 

  251. -- ----------------------------
    252. 

  252. INSERT INTO `t_sys_notice` VALUES ('330381411007729664', '测试公告', '<p>啊啊啊<img src=\"http://img.baidu.com/hi/jx2/j_0002.gif\"/><img src=\"http://img.baidu.com/hi/jx2/j_0024.gif\"/></p>', '1', '1', 'admin', '2019-09-08 02:24:37');
    253. 

  253. INSERT INTO `t_sys_notice` VALUES ('330381806358630400', '鲜花视频', '<p>哈哈哈哈<img src=\"http://img.baidu.com/hi/jx2/j_0024.gif\"/></p>', '2', '1', 'admin', '2019-09-08 02:26:11');
    254. 

  254. INSERT INTO `t_sys_notice` VALUES ('330622143597514752', '水水水水水水水', '<p>水水水水水水水水水水水水水水水水水水水</p>', '1', '1', 'admin', '2019-09-08 18:21:12');
    255. 

  255. 

  256. -- ----------------------------
    257. 

  257. -- Table structure for t_sys_notice_user
    258. 

  258. -- ----------------------------
    259. 

  259. DROP TABLE IF EXISTS `t_sys_notice_user`;
    260. 

  260. CREATE TABLE `t_sys_notice_user` (
    261. 

  261.   `id` varchar(255) NOT NULL COMMENT '主键',
    262. 

  262.   `notice_id` varchar(255) DEFAULT NULL COMMENT '公告id',
    263. 

  263.   `user_id` varchar(255) DEFAULT NULL COMMENT '用户id',
    264. 

  264.   `state` int(2) DEFAULT NULL COMMENT '0未阅读 1 阅读',
    265. 

  265.   PRIMARY KEY (`id`)
    266. 

  266. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公告_用户外键';
    267. 

  267. 

  268. -- ----------------------------
    269. 

  269. -- Records of t_sys_notice_user
    270. 

  270. -- ----------------------------
    271. 

  271. INSERT INTO `t_sys_notice_user` VALUES ('330381411037089792', '330381411007729664', '1', '1');
    272. 

  272. INSERT INTO `t_sys_notice_user` VALUES ('330381411045478400', '330381411007729664', '488294747442511872', '0');
    273. 

  273. INSERT INTO `t_sys_notice_user` VALUES ('330381806375407616', '330381806358630400', '1', '0');
    274. 

  274. INSERT INTO `t_sys_notice_user` VALUES ('330381806379601920', '330381806358630400', '488294747442511872', '0');
    275. 

  275. INSERT INTO `t_sys_notice_user` VALUES ('330622143622680576', '330622143597514752', '1', '1');
    276. 

  276. INSERT INTO `t_sys_notice_user` VALUES ('330622143626874880', '330622143597514752', '488294747442511872', '0');
    277. 

  277. INSERT INTO `t_sys_notice_user` VALUES ('354984345649418240', '354984345632641024', '1', '1');
    278. 

  278. 

  279. -- ----------------------------
    280. 

  280. -- Table structure for t_sys_oper_log
    281. 

  281. -- ----------------------------
    282. 

  282. DROP TABLE IF EXISTS `t_sys_oper_log`;
    283. 

  283. CREATE TABLE `t_sys_oper_log` (
    284. 

  284.   `id` varchar(255) COLLATE utf8_bin NOT NULL,
    285. 

  285.   `title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '标题',
    286. 

  286.   `method` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '方法',
    287. 

  287.   `oper_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '操作人',
    288. 

  288.   `oper_url` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'url',
    289. 

  289.   `oper_param` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '参数',
    290. 

  290.   `error_msg` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    291. 

  291.   `oper_time` date DEFAULT NULL COMMENT '操作时间',
    292. 

  292.   PRIMARY KEY (`id`)
    293. 

  293. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='日志记录表';
    294. 

  294. 

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

  296. -- Records of t_sys_oper_log
    297. 

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

  298. INSERT INTO `t_sys_oper_log` VALUES ('353711021405376512', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin1111\"],\"password\":[\"admin11111111111111\"],\"nickname\":[\"111111111111\"],\"roles\":[\"488289006124007424\"]}', null, '2019-11-11');
    299. 

  299. INSERT INTO `t_sys_oper_log` VALUES ('353711251710414848', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin22\"],\"password\":[\"admin22\"],\"nickname\":[\"222\"]}', null, '2019-11-11');
    300. 

  300. INSERT INTO `t_sys_oper_log` VALUES ('353711483206635520', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin1111111111111\"],\"password\":[\"admin1111111111111\"],\"nickname\":[\"111\"]}', null, '2019-11-11');
    301. 

  301. INSERT INTO `t_sys_oper_log` VALUES ('353890395106709504', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/springboot_v2/UserController/add', '{\"username\":[\"admin2\"],\"password\":[\"admin2\"],\"nickname\":[\"2\"]}', null, '2019-11-11');
    302. 

  302. INSERT INTO `t_sys_oper_log` VALUES ('354984005894017024', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin22\"],\"password\":[\"admin22\"],\"nickname\":[\"222\"],\"roles\":[\"488243256161730560\"]}', null, '2019-11-14');
    303. 

  303. INSERT INTO `t_sys_oper_log` VALUES ('354988722611163136', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin222\"],\"password\":[\"admin22\"],\"nickname\":[\"22222\"],\"roles\":[\"488243256161730560\"]}', null, '2019-11-15');
    304. 

  304. INSERT INTO `t_sys_oper_log` VALUES ('354989789822455808', '用户新增', 'com.gyee.frame.controller.admin.UserController.add()', 'admin', '/UserController/add', '{\"username\":[\"admin33\"],\"password\":[\"admin33\"],\"nickname\":[\"333\"],\"roles\":[\"488305788310257664\"]}', null, '2019-11-15');
    305. 

  305. 

  306. -- ----------------------------
    307. 

  307. -- Table structure for t_sys_permission
    308. 

  308. -- ----------------------------
    309. 

  309. DROP TABLE IF EXISTS `t_sys_permission`;
    310. 

  310. CREATE TABLE `t_sys_permission` (
    311. 

  311.   `id` varchar(255) NOT NULL COMMENT 'id',
    312. 

  312.   `name` varchar(255) DEFAULT NULL COMMENT '权限名称',
    313. 

  313.   `descripion` varchar(255) DEFAULT NULL COMMENT '权限描述',
    314. 

  314.   `url` varchar(255) DEFAULT NULL COMMENT '授权链接',
    315. 

  315.   `is_blank` int(255) DEFAULT '0' COMMENT '是否跳转 0 不跳转 1跳转',
    316. 

  316.   `pid` varchar(255) DEFAULT NULL COMMENT '父节点id',
    317. 

  317.   `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
    318. 

  318.   `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
    319. 

  319.   `icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
    320. 

  320.   `order_num` int(11) DEFAULT NULL COMMENT '排序',
    321. 

  321.   `visible` int(255) DEFAULT NULL COMMENT '是否可见',
    322. 

  322.   PRIMARY KEY (`id`)
    323. 

  323. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限表';
    324. 

  324. 

  325. -- ----------------------------
    326. 

  326. -- Records of t_sys_permission
    327. 

  327. -- ----------------------------
    328. 

  328. INSERT INTO `t_sys_permission` VALUES ('1', '首页', '首页', '#', '0', '0', '#', '0', 'fa fa-home', '1', '0');
    329. 

  329. INSERT INTO `t_sys_permission` VALUES ('10', '角色集合', '角色集合', '/RoleController/list', '0', '9', 'system:role:list', '2', '', null, '0');
    330. 

  330. INSERT INTO `t_sys_permission` VALUES ('11', '角色添加', '角色添加', '/RoleController/add', '0', '9', 'system:role:add', '2', 'entypo-plus-squared', null, '0');
    331. 

  331. INSERT INTO `t_sys_permission` VALUES ('12', '角色删除', '角色删除', '/RoleController/remove', '0', '9', 'system:role:remove', '2', 'entypo-trash', null, '0');
    332. 

  332. INSERT INTO `t_sys_permission` VALUES ('13', '角色修改', '角色修改', '/RoleController/edit', '0', '9', 'system:role:edit', '2', 'fa fa-wrench', null, '0');
    333. 

  333. INSERT INTO `t_sys_permission` VALUES ('14', '权限展示', '权限展示', '/PermissionController/view', '0', '592059865673760768', 'system:permission:view', '1', 'fa fa-key', '3', '0');
    334. 

  334. INSERT INTO `t_sys_permission` VALUES ('15', '权限集合', '权限集合', '/PermissionController/list', '0', '14', 'system:permission:list', '2', '', null, '0');
    335. 

  335. INSERT INTO `t_sys_permission` VALUES ('16', '权限添加', '权限添加', '/permissionController/add', '0', '14', 'system:permission:add', '2', 'entypo-plus-squared', null, '0');
    336. 

  336. INSERT INTO `t_sys_permission` VALUES ('17', '权限删除', '权限删除', '/PermissionController/remove', '0', '14', 'system:permission:remove', '2', 'entypo-trash', null, '0');
    337. 

  337. INSERT INTO `t_sys_permission` VALUES ('18', '权限修改', '权限修改', '/PermissionController/edit', '0', '14', 'system:permission:edit', '2', 'fa fa-wrench', null, '0');
    338. 

  338. INSERT INTO `t_sys_permission` VALUES ('19', '文件展示', '文件展示', '/FileController/view', '0', '592059865673760768', 'system:file:view', '1', 'fa fa-file-image-o', '4', '0');
    339. 

  339. INSERT INTO `t_sys_permission` VALUES ('20', '文件添加', '文件添加', '/FileController/add', '0', '19', 'system:file:add', '2', 'entypo-plus-squared', null, '0');
    340. 

  340. INSERT INTO `t_sys_permission` VALUES ('21', '文件删除', '文件删除', '/FileController/remove', '0', '19', 'system:file:remove', '2', 'entypo-trash', null, '0');
    341. 

  341. INSERT INTO `t_sys_permission` VALUES ('22', '文件修改', '文件修改', '/FileController/edit', '0', '19', 'system:file:edit', '2', 'fa fa-wrench', null, '0');
    342. 

  342. INSERT INTO `t_sys_permission` VALUES ('23', '文件集合', '文件集合', '/FileController/list', '0', '19', 'system:file:list', '2', '', null, '0');
    343. 

  343. INSERT INTO `t_sys_permission` VALUES ('330365026642825216', '公告管理', '公告展示', '/SysNoticeController/view', '0', '592059865673760768', 'gen:sysNotice:view', '1', 'fa fa-telegram', '10', '0');
    344. 

  344. INSERT INTO `t_sys_permission` VALUES ('3303650266428252171', '公告集合', '公告集合', '/SysNoticeController/list', '0', '330365026642825216', 'gen:sysNotice:list', '2', '', null, '0');
    345. 

  345. INSERT INTO `t_sys_permission` VALUES ('3303650266428252182', '公告添加', '公告添加', '/SysNoticeController/add', '0', '330365026642825216', 'gen:sysNotice:add', '2', 'entypo-plus-squared', null, '0');
    346. 

  346. INSERT INTO `t_sys_permission` VALUES ('3303650266428252193', '公告删除', '公告删除', '/SysNoticeController/remove', '0', '330365026642825216', 'gen:sysNotice:remove', '2', 'entypo-trash', null, '0');
    347. 

  347. INSERT INTO `t_sys_permission` VALUES ('3303650266428252204', '公告修改', '公告修改', '/SysNoticeController/edit', '0', '330365026642825216', 'gen:sysNotice:edit', '2', 'fa fa-wrench', null, '0');
    348. 

  348. INSERT INTO `t_sys_permission` VALUES ('331778807298134016', '定时器表达式', '', '/quartz/view', '0', '592059865673760768', '#', '1', 'fa fa-flash', '12', '0');
    349. 

  349. INSERT INTO `t_sys_permission` VALUES ('332157860920299520', '定时任务', '定时任务调度表展示', '/SysQuartzJobController/view', '0', '592059865673760768', 'gen:sysQuartzJob:view', '1', 'fa fa-hourglass-1', '13', '0');
    350. 

  350. INSERT INTO `t_sys_permission` VALUES ('3321578609202995211', '定时任务调度表集合', '定时任务调度表集合', '/SysQuartzJobController/list', '0', '332157860920299520', 'gen:sysQuartzJob:list', '2', '', null, '0');
    351. 

  351. INSERT INTO `t_sys_permission` VALUES ('3321578609202995222', '定时任务调度表添加', '定时任务调度表添加', '/SysQuartzJobController/add', '0', '332157860920299520', 'gen:sysQuartzJob:add', '2', 'entypo-plus-squared', null, '0');
    352. 

  352. INSERT INTO `t_sys_permission` VALUES ('3321578609202995233', '定时任务调度表删除', '定时任务调度表删除', '/SysQuartzJobController/remove', '0', '332157860920299520', 'gen:sysQuartzJob:remove', '2', 'entypo-trash', null, '0');
    353. 

  353. INSERT INTO `t_sys_permission` VALUES ('3321578609202995244', '定时任务调度表修改', '定时任务调度表修改', '/SysQuartzJobController/edit', '0', '332157860920299520', 'gen:sysQuartzJob:edit', '2', 'fa fa-wrench', null, '0');
    354. 

  354. INSERT INTO `t_sys_permission` VALUES ('332857281479839744', '定时任务日志', '定时任务日志', '/SysQuartzJobLogController/view', '0', '592059865673760768', 'gen:sysQuartzJobLog:view', '1', 'fa fa-database', '14', '0');
    355. 

  355. INSERT INTO `t_sys_permission` VALUES ('3328572814798397451', '定时任务调度日志表集合', '定时任务调度日志表集合', '/SysQuartzJobLogController/list', '0', '332857281479839744', 'gen:sysQuartzJobLog:list', '2', '', null, '0');
    356. 

  356. INSERT INTO `t_sys_permission` VALUES ('3328572814798397473', '定时任务调度日志表删除', '定时任务调度日志表删除', '/SysQuartzJobLogController/remove', '0', '332857281479839744', 'gen:sysQuartzJobLog:remove', '2', 'entypo-trash', null, '0');
    357. 

  357. INSERT INTO `t_sys_permission` VALUES ('335330315113467904', 'Json工具', 'Json格式化工具', '/Json/view', '1', '617766548966211584', '#', '1', 'fa fa-retweet', '10', '0');
    358. 

  358. INSERT INTO `t_sys_permission` VALUES ('340066503263129600', '省份设置', '省份设置', null, '0', '1', null, '0', 'fa fa-building', '4', '0');
    359. 

  359. INSERT INTO `t_sys_permission` VALUES ('340067579836108800', '省份管理', '', '#', '0', '340066503263129600', '#', '1', 'fa fa-building-o', null, '0');
    360. 

  360. INSERT INTO `t_sys_permission` VALUES ('340068151804956672', '省份表管理', '省份表展示', '/SysProvinceController/view', '0', '340067579836108800', 'gen:sysProvince:view', '1', 'fa fa-quora', '2', '0');
    361. 

  361. INSERT INTO `t_sys_permission` VALUES ('3400681518049566731', '省份表集合', '省份表集合', '/SysProvinceController/list', '0', '340068151804956672', 'gen:sysProvince:list', '2', '', null, '0');
    362. 

  362. INSERT INTO `t_sys_permission` VALUES ('3400681518049566742', '省份表添加', '省份表添加', '/SysProvinceController/add', '0', '340068151804956672', 'gen:sysProvince:add', '2', 'entypo-plus-squared', null, '0');
    363. 

  363. INSERT INTO `t_sys_permission` VALUES ('3400681518049566753', '省份表删除', '省份表删除', '/SysProvinceController/remove', '0', '340068151804956672', 'gen:sysProvince:remove', '2', 'entypo-trash', null, '0');
    364. 

  364. INSERT INTO `t_sys_permission` VALUES ('3400681518049566764', '省份表修改', '省份表修改', '/SysProvinceController/edit', '0', '340068151804956672', 'gen:sysProvince:edit', '2', 'fa fa-wrench', null, '0');
    365. 

  365. INSERT INTO `t_sys_permission` VALUES ('340088022018166784', '城市表管理', '城市设置展示', '/SysCityController/view', '0', '340067579836108800', 'gen:sysCity:view', '1', 'fa fa-quora', '3', '0');
    366. 

  366. INSERT INTO `t_sys_permission` VALUES ('3400880220181667851', '城市设置集合', '城市设置集合', '/SysCityController/list', '0', '340088022018166784', 'gen:sysCity:list', '2', '', null, '0');
    367. 

  367. INSERT INTO `t_sys_permission` VALUES ('3400880220181667862', '城市设置添加', '城市设置添加', '/SysCityController/add', '0', '340088022018166784', 'gen:sysCity:add', '2', 'entypo-plus-squared', null, '0');
    368. 

  368. INSERT INTO `t_sys_permission` VALUES ('3400880220181667873', '城市设置删除', '城市设置删除', '/SysCityController/remove', '0', '340088022018166784', 'gen:sysCity:remove', '2', 'entypo-trash', null, '0');
    369. 

  369. INSERT INTO `t_sys_permission` VALUES ('3400880220181667884', '城市设置修改', '城市设置修改', '/SysCityController/edit', '0', '340088022018166784', 'gen:sysCity:edit', '2', 'fa fa-wrench', null, '0');
    370. 

  370. INSERT INTO `t_sys_permission` VALUES ('340096183135506432', '地区设置管理', '地区设置展示', '/SysAreaController/view', '0', '340067579836108800', 'gen:sysArea:view', '1', 'fa fa-quora', '4', '0');
    371. 

  371. INSERT INTO `t_sys_permission` VALUES ('3400961831355064331', '地区设置集合', '地区设置集合', '/SysAreaController/list', '0', '340096183135506432', 'gen:sysArea:list', '2', '', null, '0');
    372. 

  372. INSERT INTO `t_sys_permission` VALUES ('3400961831355064342', '地区设置添加', '地区设置添加', '/SysAreaController/add', '0', '340096183135506432', 'gen:sysArea:add', '2', 'entypo-plus-squared', null, '0');
    373. 

  373. INSERT INTO `t_sys_permission` VALUES ('3400961831355064353', '地区设置删除', '地区设置删除', '/SysAreaController/remove', '0', '340096183135506432', 'gen:sysArea:remove', '2', 'entypo-trash', null, '0');
    374. 

  374. INSERT INTO `t_sys_permission` VALUES ('3400961831355064364', '地区设置修改', '地区设置修改', '/SysAreaController/edit', '0', '340096183135506432', 'gen:sysArea:edit', '2', 'fa fa-wrench', null, '0');
    375. 

  375. INSERT INTO `t_sys_permission` VALUES ('340127412270534656', '街道设置管理', '街道设置展示', '/SysStreetController/view', '0', '340067579836108800', 'gen:sysStreet:view', '1', 'fa fa-quora', '5', '0');
    376. 

  376. INSERT INTO `t_sys_permission` VALUES ('3401274122705346571', '街道设置集合', '街道设置集合', '/SysStreetController/list', '0', '340127412270534656', 'gen:sysStreet:list', '2', '', null, '0');
    377. 

  377. INSERT INTO `t_sys_permission` VALUES ('3401274122705346582', '街道设置添加', '街道设置添加', '/SysStreetController/add', '0', '340127412270534656', 'gen:sysStreet:add', '2', 'entypo-plus-squared', null, '0');
    378. 

  378. INSERT INTO `t_sys_permission` VALUES ('3401274122705346593', '街道设置删除', '街道设置删除', '/SysStreetController/remove', '0', '340127412270534656', 'gen:sysStreet:remove', '2', 'entypo-trash', null, '0');
    379. 

  379. INSERT INTO `t_sys_permission` VALUES ('3401274122705346604', '街道设置修改', '街道设置修改', '/SysStreetController/edit', '0', '340127412270534656', 'gen:sysStreet:edit', '2', 'fa fa-wrench', null, '0');
    380. 

  380. INSERT INTO `t_sys_permission` VALUES ('340301160042860544', '省份联动', '省份联动', '/ProvinceLinkageController/view', '0', '340067579836108800', '#', '1', 'fa fa-etsy', '1', '0');
    381. 

  381. INSERT INTO `t_sys_permission` VALUES ('340381240911859712', 'JavaScript格式化', 'JavaScript格式化', '/static/admin/htmlformat/javascriptFormat.html', '1', '617766548966211584', '#', '1', 'fa fa-magic', '11', '0');
    382. 

  382. INSERT INTO `t_sys_permission` VALUES ('354851114446884864', '七牛文件上传', '七牛文件上传', '/QiNiuCloudController/view', '0', '592059865673760768', 'system:qiNiuCloud:view', '1', 'fa fa-globe', '15', '0');
    383. 

  383. INSERT INTO `t_sys_permission` VALUES ('354865752219717632', '云文件集合', '云文件集合', '/QiNiuCloudController/list', '0', '354851114446884864', 'system:qiNiuCloud:list', '2', null, null, '0');
    384. 

  384. INSERT INTO `t_sys_permission` VALUES ('4', '用户管理', '用户展示', '/UserController/view', '0', '592059865673760768', 'system:user:view', '1', 'icon icon-user', '1', '0');
    385. 

  385. INSERT INTO `t_sys_permission` VALUES ('486690002869157888', '用户密码修改', '用户密码修改', '/UserController/editPwd', '0', '4', 'system:user:editPwd', '2', 'entypo-tools', '3', '0');
    386. 

  386. INSERT INTO `t_sys_permission` VALUES ('496126970468237312', '日志展示', '日志管理', '/LogController/view', '0', '592059865673760768', 'system:log:view', '1', 'fa fa-info', '9', '0');
    387. 

  387. INSERT INTO `t_sys_permission` VALUES ('496127240363311104', '日志删除', '日志删除', '/LogController/remove', '0', '496126970468237312', 'system:log:remove', '2', 'entypo-trash', null, '0');
    388. 

  388. INSERT INTO `t_sys_permission` VALUES ('496127794879660032', '日志集合', '日志集合', '/LogController/list', '0', '496126970468237312', 'system:log:list', '2', null, null, '0');
    389. 

  389. INSERT INTO `t_sys_permission` VALUES ('496782496638173184', '系统设置', '后台设置', null, '0', '1', null, '0', 'fa fa-gear', '3', '0');
    390. 

  390. INSERT INTO `t_sys_permission` VALUES ('5', '用户集合', '用户集合', '/UserController/list', '0', '4', 'system:user:list', '2', '', null, '0');
    391. 

  391. INSERT INTO `t_sys_permission` VALUES ('581541547099553792', 'druid监控', 'druid监控', '/druid/', '0', '617766548966211584', 'user:list', '1', 'fa fa-line-chart', '6', '0');
    392. 

  392. INSERT INTO `t_sys_permission` VALUES ('583063272123531264', 'API文档', 'API文档', '/swagger-ui.html', '1', '617766548966211584', '--', '1', 'fa fa-font', '8', '0');
    393. 

  393. INSERT INTO `t_sys_permission` VALUES ('586003694080753664', '表单构建', '表单构建', '/ToolController/view', '0', '617766548966211584', 'system:tool:view', '1', 'fa fa-list-alt', '5', '0');
    394. 

  394. INSERT INTO `t_sys_permission` VALUES ('587453033487532032', '后台模板', '后台模板', '/static/admin/bootstarp/index.html', '1', '617766548966211584', 'system:htmb:view', '1', 'fa fa-telegram', '9', '0');
    395. 

  395. INSERT INTO `t_sys_permission` VALUES ('589559475422101504', '测试目录', '测试目录', null, '0', '1', null, '0', 'fa fa-etsy', '5', '0');
    396. 

  396. INSERT INTO `t_sys_permission` VALUES ('589559748521623552', '一级菜单', '测试菜单', '#', '0', '589559475422101504', '#', '1', 'fa fa-address-book', null, '0');
    397. 

  397. INSERT INTO `t_sys_permission` VALUES ('589559916704825344', '二级菜单', '二级菜单', '#', '0', '589559748521623552', '#', '1', 'fa fa-address-book', '1', '0');
    398. 

  398. INSERT INTO `t_sys_permission` VALUES ('592059865673760768', '系统管理', '后台管理', '#', '0', '496782496638173184', '#', '1', 'fa fa-home', '1', '0');
    399. 

  399. INSERT INTO `t_sys_permission` VALUES ('592067570522128384', '测试跳转', '测试跳转', 'http://www.baidu.com', '1', '589559748521623552', '#', '1', 'fa fa-address-book', null, '0');
    400. 

  400. INSERT INTO `t_sys_permission` VALUES ('592167738407911424', '系统监控', '系统监控', '/ServiceController/view', '0', '617766548966211584', 'system:service:view', '1', 'fa fa-video-camera', '7', '0');
    401. 

  401. INSERT INTO `t_sys_permission` VALUES ('594691026430459904', '电子邮件管理', '电子邮件展示', '/EmailController/view', '0', '592059865673760768', 'system:email:view', '1', 'fa fa-envelope', '8', '0');
    402. 

  402. INSERT INTO `t_sys_permission` VALUES ('5946910264304599041', '电子邮件集合', '电子邮件集合', '/EmailController/list', '0', '594691026430459904', 'system:email:list', '2', '', null, '0');
    403. 

  403. INSERT INTO `t_sys_permission` VALUES ('5946910264304599042', '电子邮件添加', '电子邮件添加', '/EmailController/add', '0', '594691026430459904', 'system:email:add', '2', 'entypo-plus-squared', null, '0');
    404. 

  404. INSERT INTO `t_sys_permission` VALUES ('5946910264304599043', '电子邮件删除', '电子邮件删除', '/EmailController/remove', '0', '594691026430459904', 'system:email:remove', '2', 'entypo-trash', null, '0');
    405. 

  405. INSERT INTO `t_sys_permission` VALUES ('5946910264304599044', '电子邮件修改', '电子邮件修改', '/EmailController/edit', '0', '594691026430459904', 'system:email:edit', '2', 'fa fa-wrench', null, '0');
    406. 

  406. INSERT INTO `t_sys_permission` VALUES ('6', '用户添加', '用户添加', '/UserController/add', '0', '4', 'system:user:add', '2', 'entypo-plus-squared', null, '0');
    407. 

  407. INSERT INTO `t_sys_permission` VALUES ('610635485890478080', '代码生成新', '代码生成2', '#', '0', '617751079701970944', '#', '1', 'fa fa-blind', '1', '0');
    408. 

  408. INSERT INTO `t_sys_permission` VALUES ('610635950447394816', '全局配置', '', '/autoCodeController/global', '0', '610635485890478080', 'system:autocode:global', '1', 'fa fa-university', null, '0');
    409. 

  409. INSERT INTO `t_sys_permission` VALUES ('610983815791247360', '单表生成', '', '/autoCodeController/one', '0', '610635485890478080', 'system:autocode:one', '1', 'fa fa-hand-peace-o', null, '0');
    410. 

  410. INSERT INTO `t_sys_permission` VALUES ('617751079701970944', '代码生成', '代码生成', null, '0', '1', null, '0', 'fa fa-500px', '4', '0');
    411. 

  411. INSERT INTO `t_sys_permission` VALUES ('617766548966211584', '系统工具', '系统工具', '#', '0', '496782496638173184', '#', '1', 'fa fa-th-large', '2', '0');
    412. 

  412. INSERT INTO `t_sys_permission` VALUES ('618918631769636864', '字典管理', '字典类型表展示', '/DictTypeController/view', '0', '592059865673760768', 'system:dictType:view', '1', 'fa fa-puzzle-piece', '11', '0');
    413. 

  413. INSERT INTO `t_sys_permission` VALUES ('6189186317738311681', '字典类型表集合', '字典类型表集合', '/DictTypeController/list', '0', '618918631769636864', 'system:dictType:list', '2', null, null, '0');
    414. 

  414. INSERT INTO `t_sys_permission` VALUES ('6189186317948026882', '字典类型表添加', '字典类型表添加', '/DictTypeController/add', '0', '618918631769636864', 'system:dictType:add', '2', null, null, '0');
    415. 

  415. INSERT INTO `t_sys_permission` VALUES ('6189186317948026883', '字典类型表删除', '字典类型表删除', '/DictTypeController/remove', '0', '618918631769636864', 'system:dictType:remove', '2', null, null, '0');
    416. 

  416. INSERT INTO `t_sys_permission` VALUES ('6189186317989969924', '字典类型表修改', '字典类型表修改', '/DictTypeController/edit', '0', '618918631769636864', 'system:dictType:edit', '2', null, null, '0');
    417. 

  417. INSERT INTO `t_sys_permission` VALUES ('6192095214866268161', '字典数据表集合', '字典数据表集合', '/DictDataController/list', '0', '618918631769636864', 'system:dictData:list', '2', null, null, '0');
    418. 

  418. INSERT INTO `t_sys_permission` VALUES ('6192095214866268162', '字典数据表添加', '字典数据表添加', '/DictDataController/add', '0', '618918631769636864', 'system:dictData:add', '2', null, null, '0');
    419. 

  419. INSERT INTO `t_sys_permission` VALUES ('6192095215075983363', '字典数据表删除', '字典数据表删除', '/DictDataController/remove', '0', '618918631769636864', 'system:dictData:remove', '2', null, null, '0');
    420. 

  420. INSERT INTO `t_sys_permission` VALUES ('6192095215075983364', '字典数据表修改', '字典数据表修改', '/DictDataController/edit', '0', '618918631769636864', 'system:dictData:edit', '2', null, null, '0');
    421. 

  421. INSERT INTO `t_sys_permission` VALUES ('619836559427895296', '字典数据视图', '字典数据视图', '/DictDataController/view', '0', '618918631769636864', 'system:dictData:view', '2', null, null, '0');
    422. 

  422. INSERT INTO `t_sys_permission` VALUES ('7', '用户删除', '用户删除', '/UserController/remove', '0', '4', 'system:user:remove', '2', 'entypo-trash', null, '0');
    423. 

  423. INSERT INTO `t_sys_permission` VALUES ('8', '用户修改', '用户修改', '/UserController/edit', '0', '4', 'system:user:edit', '2', 'fa fa-wrench', null, '0');
    424. 

  424. INSERT INTO `t_sys_permission` VALUES ('9', '角色管理', '角色展示', '/RoleController/view', '0', '592059865673760768', 'system:role:view', '1', 'fa fa-group', '2', '0');
    425. 

  425. 

  426. -- ----------------------------
    427. 

  427. -- Table structure for t_sys_permission_role
    428. 

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

  429. DROP TABLE IF EXISTS `t_sys_permission_role`;
    430. 

  430. CREATE TABLE `t_sys_permission_role` (
    431. 

  431.   `id` varchar(255) NOT NULL,
    432. 

  432.   `role_id` varchar(255) DEFAULT NULL COMMENT '角色id',
    433. 

  433.   `permission_id` varchar(255) DEFAULT NULL COMMENT '权限id',
    434. 

  434.   PRIMARY KEY (`id`)
    435. 

  435. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限中间表';
    436. 

  436. 

  437. -- ----------------------------
    438. 

  438. -- Records of t_sys_permission_role
    439. 

  439. -- ----------------------------
    440. 

  440. INSERT INTO `t_sys_permission_role` VALUES ('0090d5c9-1876-492f-bb3c-3efc7cb1c666', '488243256161730560', '3401274122705346604');
    441. 

  441. INSERT INTO `t_sys_permission_role` VALUES ('03a88782-7d67-49f1-8bb8-b896ff887f28', '488243256161730560', '3400961831355064331');
    442. 

  442. INSERT INTO `t_sys_permission_role` VALUES ('0c540c9e-b56c-442c-b387-3af08f25d0e4', '488243256161730560', '3400880220181667862');
    443. 

  443. INSERT INTO `t_sys_permission_role` VALUES ('0d97d3d5-2e84-4048-9e94-1b14f32a29b2', '488243256161730560', '10');
    444. 

  444. INSERT INTO `t_sys_permission_role` VALUES ('0e03ce36-bcaf-4f8e-ac09-df8ebfaa6f5d', '488243256161730560', '3303650266428252193');
    445. 

  445. INSERT INTO `t_sys_permission_role` VALUES ('0f4498e2-5312-42f9-829c-bdad1ed62999', '488243256161730560', '9');
    446. 

  446. INSERT INTO `t_sys_permission_role` VALUES ('1a7f2cdb-791b-443f-9864-432442b94f57', '488243256161730560', '14');
    447. 

  447. INSERT INTO `t_sys_permission_role` VALUES ('1ebfcbc3-ae48-4b0e-938e-7c23606f8be5', '488243256161730560', '3303650266428252171');
    448. 

  448. INSERT INTO `t_sys_permission_role` VALUES ('211fb1a5-dcd6-4ed9-a030-8d240db78ed3', '488243256161730560', '19');
    449. 

  449. INSERT INTO `t_sys_permission_role` VALUES ('290c05af-d1a5-4ab2-99f5-b5ac3b9a8b3d', '488243256161730560', '6192095215075983363');
    450. 

  450. INSERT INTO `t_sys_permission_role` VALUES ('299688d1-7693-4760-8003-a9dafb94a177', '488243256161730560', '354851114446884864');
    451. 

  451. INSERT INTO `t_sys_permission_role` VALUES ('2d400632-a55e-4c51-8d55-d9f1f8393c63', '488243256161730560', '594691026430459904');
    452. 

  452. INSERT INTO `t_sys_permission_role` VALUES ('2dcb219c-1c8b-4630-8d4f-1ad5c4bb4acf', '488243256161730560', '3303650266428252204');
    453. 

  453. INSERT INTO `t_sys_permission_role` VALUES ('2e313899-b8e2-49f2-924d-4afea3e0218b', '488243256161730560', '496126970468237312');
    454. 

  454. INSERT INTO `t_sys_permission_role` VALUES ('365b4bf9-4de4-46ed-948e-2ce634de3adb', '488243256161730560', '496127794879660032');
    455. 

  455. INSERT INTO `t_sys_permission_role` VALUES ('37cb39da-1b96-471e-80fe-e9e5493b8575', '488243256161730560', '5946910264304599042');
    456. 

  456. INSERT INTO `t_sys_permission_role` VALUES ('38fd8a7f-6c95-4bf6-8773-26d312e7359b', '488243256161730560', '6');
    457. 

  457. INSERT INTO `t_sys_permission_role` VALUES ('39bc81c3-b9e7-4be4-a72e-1c70749abfea', '488243256161730560', '617751079701970944');
    458. 

  458. INSERT INTO `t_sys_permission_role` VALUES ('3cbced01-80b1-41a6-b449-e33936ce9232', '488243256161730560', '17');
    459. 

  459. INSERT INTO `t_sys_permission_role` VALUES ('4085b466-36f5-4d63-97fc-d1fa5e67813b', '488243256161730560', '619836559427895296');
    460. 

  460. INSERT INTO `t_sys_permission_role` VALUES ('4405da52-6acd-4740-9b85-1ab47114c171', '488243256161730560', '340068151804956672');
    461. 

  461. INSERT INTO `t_sys_permission_role` VALUES ('455c9886-28aa-44e4-bbff-a3308495662a', '488243256161730560', '4');
    462. 

  462. INSERT INTO `t_sys_permission_role` VALUES ('457bdd8b-d0d1-4e52-bae1-3aadf255eeee', '488243256161730560', '332857281479839744');
    463. 

  463. INSERT INTO `t_sys_permission_role` VALUES ('45fa8d8f-696f-44e9-887c-978700d21d4a', '488243256161730560', '3400961831355064342');
    464. 

  464. INSERT INTO `t_sys_permission_role` VALUES ('46d1e57c-390c-434d-b5cd-0c5c56612adb', '488243256161730560', '592059865673760768');
    465. 

  465. INSERT INTO `t_sys_permission_role` VALUES ('4b0744e9-822b-46ef-ba14-934edb980949', '488243256161730560', '1');
    466. 

  466. INSERT INTO `t_sys_permission_role` VALUES ('4cdc3dd6-e413-486f-a5d9-d748d0805175', '488243256161730560', '21');
    467. 

  467. INSERT INTO `t_sys_permission_role` VALUES ('4d739a52-e255-4765-a37b-1ab190009673', '488243256161730560', '610635950447394816');
    468. 

  468. INSERT INTO `t_sys_permission_role` VALUES ('5522c3d4-a77b-40c2-84a9-98690bb19088', '488243256161730560', '589559748521623552');
    469. 

  469. INSERT INTO `t_sys_permission_role` VALUES ('5885a0c0-b3ea-462a-982f-e3c2563879be', '488243256161730560', '16');
    470. 

  470. INSERT INTO `t_sys_permission_role` VALUES ('5ab7408b-c4b2-40f1-a7c2-eba57c22f937', '488243256161730560', '3400961831355064364');
    471. 

  471. INSERT INTO `t_sys_permission_role` VALUES ('5ac4b1e9-97d5-40da-ad54-37e8bc7170a9', '488243256161730560', '8');
    472. 

  472. INSERT INTO `t_sys_permission_role` VALUES ('5d1fe335-b4d3-4b0d-9491-b516765f9021', '488243256161730560', '581541547099553792');
    473. 

  473. INSERT INTO `t_sys_permission_role` VALUES ('5f3c2d58-db6c-45b7-ac60-7ebf04b71b0b', '488243256161730560', '3401274122705346571');
    474. 

  474. INSERT INTO `t_sys_permission_role` VALUES ('63b4953c-92a2-45ee-9b98-9ebbf1ccf24f', '488243256161730560', '5');
    475. 

  475. INSERT INTO `t_sys_permission_role` VALUES ('6913358e-ba94-4405-b57b-75a9e8403f6e', '488243256161730560', '6189186317738311681');
    476. 

  476. INSERT INTO `t_sys_permission_role` VALUES ('6e555311-06e3-4c62-9efb-f22f2407f407', '488243256161730560', '332157860920299520');
    477. 

  477. INSERT INTO `t_sys_permission_role` VALUES ('702060c9-127f-41aa-a215-da5b4bfce437', '488243256161730560', '6189186317948026883');
    478. 

  478. INSERT INTO `t_sys_permission_role` VALUES ('73a1946a-cdb7-4e5a-bf8e-6c43ac5a2fa4', '488243256161730560', '3400681518049566742');
    479. 

  479. INSERT INTO `t_sys_permission_role` VALUES ('73cf0a3f-b495-4826-9416-e2caefa7aed5', '488243256161730560', '496782496638173184');
    480. 

  480. INSERT INTO `t_sys_permission_role` VALUES ('75b3c8a9-1d70-4886-b0fb-23b61bf8f229', '488243256161730560', '589559916704825344');
    481. 

  481. INSERT INTO `t_sys_permission_role` VALUES ('76eac718-c28e-41bf-a7e7-b0cfe5aa160b', '488243256161730560', '3400681518049566731');
    482. 

  482. INSERT INTO `t_sys_permission_role` VALUES ('77b52a5e-05d1-4412-bc77-fd937e4c3674', '488243256161730560', '617766548966211584');
    483. 

  483. INSERT INTO `t_sys_permission_role` VALUES ('77f34e60-272f-4a08-93c1-c66cd57d61c1', '488243256161730560', '583063272123531264');
    484. 

  484. INSERT INTO `t_sys_permission_role` VALUES ('7d18f463-7cef-4803-b2c7-619975d78ef7', '488243256161730560', '340381240911859712');
    485. 

  485. INSERT INTO `t_sys_permission_role` VALUES ('7dcb14a8-c5de-4a62-90f9-6be1f9b21315', '488243256161730560', '7');
    486. 

  486. INSERT INTO `t_sys_permission_role` VALUES ('7fc78a8f-68fb-413c-b467-42bd93dffbd5', '488243256161730560', '3400961831355064353');
    487. 

  487. INSERT INTO `t_sys_permission_role` VALUES ('843d5d46-6bb0-4926-ac0a-29946db39ea3', '488243256161730560', '354865752219717632');
    488. 

  488. INSERT INTO `t_sys_permission_role` VALUES ('868e4019-707c-408e-bd90-62ee48dd6777', '488243256161730560', '3321578609202995222');
    489. 

  489. INSERT INTO `t_sys_permission_role` VALUES ('87f7b4a9-8154-4426-be27-2c8f0ac7ef09', '488243256161730560', '23');
    490. 

  490. INSERT INTO `t_sys_permission_role` VALUES ('88c4a254-bd53-4d17-b03a-b7a5c0797aeb', '488243256161730560', '3321578609202995233');
    491. 

  491. INSERT INTO `t_sys_permission_role` VALUES ('897c5817-6d87-44c8-97d5-28bd1d9003ad', '488243256161730560', '3328572814798397473');
    492. 

  492. INSERT INTO `t_sys_permission_role` VALUES ('8a58798c-1345-4fa6-b8dd-55c53e0b044c', '488243256161730560', '5946910264304599043');
    493. 

  493. INSERT INTO `t_sys_permission_role` VALUES ('8e4cffe8-cb39-4ff0-81e4-56930936506f', '488243256161730560', '12');
    494. 

  494. INSERT INTO `t_sys_permission_role` VALUES ('94127884-ad8a-46dd-a410-f9b6e263efe4', '488243256161730560', '3400880220181667884');
    495. 

  495. INSERT INTO `t_sys_permission_role` VALUES ('959b731d-ea12-41aa-a84e-94f86882ed68', '488243256161730560', '335330315113467904');
    496. 

  496. INSERT INTO `t_sys_permission_role` VALUES ('969771a4-9b73-402b-8120-d3996ee9eb5a', '488243256161730560', '331778807298134016');
    497. 

  497. INSERT INTO `t_sys_permission_role` VALUES ('96bdc02d-88e9-4371-9861-9a9681d217f0', '488243256161730560', '5946910264304599044');
    498. 

  498. INSERT INTO `t_sys_permission_role` VALUES ('99819aea-4fe6-4768-8cfa-fc20a743c64f', '488243256161730560', '589559475422101504');
    499. 

  499. INSERT INTO `t_sys_permission_role` VALUES ('9b762be6-c6a2-4f99-98cb-144ccd3f31d0', '488243256161730560', '340088022018166784');
    500. 

  500. INSERT INTO `t_sys_permission_role` VALUES ('a4ef1c3a-cb65-4a31-95bb-ddea8a28ecad', '488243256161730560', '3400681518049566764');
    501. 

  501. INSERT INTO `t_sys_permission_role` VALUES ('a53330e8-f331-445d-b173-048e90850499', '488243256161730560', '18');
    502. 

  502. INSERT INTO `t_sys_permission_role` VALUES ('a7e62b90-8aac-4c68-b2b4-d1b94e6e9d35', '488243256161730560', '3401274122705346593');
    503. 

  503. INSERT INTO `t_sys_permission_role` VALUES ('ab406df5-b01d-4628-b6fe-344b1938a6bc', '488243256161730560', '592067570522128384');
    504. 

  504. INSERT INTO `t_sys_permission_role` VALUES ('aee228dd-098f-47d0-a957-c725e95e3a7c', '488243256161730560', '6192095214866268161');
    505. 

  505. INSERT INTO `t_sys_permission_role` VALUES ('af7124d8-eba8-4aaf-94f5-d79a20b86555', '488243256161730560', '15');
    506. 

  506. INSERT INTO `t_sys_permission_role` VALUES ('b3f83e32-031d-4f55-be06-f4db71b1d8a3', '488243256161730560', '5946910264304599041');
    507. 

  507. INSERT INTO `t_sys_permission_role` VALUES ('ba501b39-f17b-4872-8df7-0cb70e3481bf', '488243256161730560', '610635485890478080');
    508. 

  508. INSERT INTO `t_sys_permission_role` VALUES ('bcb7fede-678b-4bf1-b0c8-ffc8453e3504', '488243256161730560', '3400880220181667873');
    509. 

  509. INSERT INTO `t_sys_permission_role` VALUES ('bd1a51b6-6af2-4f66-9279-b04a4958f2ac', '488243256161730560', '587453033487532032');
    510. 

  510. INSERT INTO `t_sys_permission_role` VALUES ('bf7fc00a-0b2b-4db5-bc14-479a2576faf4', '488243256161730560', '6192095215075983364');
    511. 

  511. INSERT INTO `t_sys_permission_role` VALUES ('c231a93a-9820-4eac-a275-b25b750d299f', '488243256161730560', '3401274122705346582');
    512. 

  512. INSERT INTO `t_sys_permission_role` VALUES ('c2828dd0-a9a5-470a-8eef-7d81115b1f06', '488243256161730560', '20');
    513. 

  513. INSERT INTO `t_sys_permission_role` VALUES ('c35923c4-db40-4fcd-be57-b481198d22f9', '488243256161730560', '3328572814798397451');
    514. 

  514. INSERT INTO `t_sys_permission_role` VALUES ('c36838fd-2092-4e78-928f-27f4067442cc', '488243256161730560', '340066503263129600');
    515. 

  515. INSERT INTO `t_sys_permission_role` VALUES ('c7bebb4a-09ab-4d7f-b8ba-790eff827181', '488243256161730560', '486690002869157888');
    516. 

  516. INSERT INTO `t_sys_permission_role` VALUES ('c8106a7d-f233-4a59-b23c-485fc713a1dd', '488243256161730560', '330365026642825216');
    517. 

  517. INSERT INTO `t_sys_permission_role` VALUES ('ccb23c0f-3a92-4c7e-aa28-9a4cd8ff3cb2', '488243256161730560', '340127412270534656');
    518. 

  518. INSERT INTO `t_sys_permission_role` VALUES ('ceac98d2-393a-4096-a7c9-cc6fd037cf3b', '488243256161730560', '3321578609202995211');
    519. 

  519. INSERT INTO `t_sys_permission_role` VALUES ('d0eb0e6e-e009-4a37-ab91-1da8305dcfc4', '488243256161730560', '22');
    520. 

  520. INSERT INTO `t_sys_permission_role` VALUES ('d1069950-07df-4cc1-a84a-6be4582bb58b', '488243256161730560', '11');
    521. 

  521. INSERT INTO `t_sys_permission_role` VALUES ('d1810151-6e20-41b1-803a-cb84ef03ffa8', '488243256161730560', '3303650266428252182');
    522. 

  522. INSERT INTO `t_sys_permission_role` VALUES ('d28e1e18-7645-419d-bd3a-e9c1fa722d68', '488243256161730560', '586003694080753664');
    523. 

  523. INSERT INTO `t_sys_permission_role` VALUES ('d383ffdf-9e79-4240-b743-a97771632b80', '488243256161730560', '618918631769636864');
    524. 

  524. INSERT INTO `t_sys_permission_role` VALUES ('d7cbfd44-f4d8-4771-b91f-823750b81970', '488243256161730560', '6189186317989969924');
    525. 

  525. INSERT INTO `t_sys_permission_role` VALUES ('d96c35d0-b836-4120-adc3-95cb6c3bc199', '488243256161730560', '3400880220181667851');
    526. 

  526. INSERT INTO `t_sys_permission_role` VALUES ('de923fd7-934e-4a3e-b037-1840fec14c2c', '488243256161730560', '6189186317948026882');
    527. 

  527. INSERT INTO `t_sys_permission_role` VALUES ('dff41a0f-2467-4f9c-bc63-a0d62c856807', '488243256161730560', '592167738407911424');
    528. 

  528. INSERT INTO `t_sys_permission_role` VALUES ('e55a272d-c197-41df-97cc-6a6107d74f33', '488243256161730560', '3400681518049566753');
    529. 

  529. INSERT INTO `t_sys_permission_role` VALUES ('e70fd931-f762-49a0-b84e-886cdc23c75c', '488243256161730560', '340301160042860544');
    530. 

  530. INSERT INTO `t_sys_permission_role` VALUES ('ebe1b826-d30e-4463-ba6e-1855df4d67ed', '488243256161730560', '610983815791247360');
    531. 

  531. INSERT INTO `t_sys_permission_role` VALUES ('f0b25019-fe8a-4f7c-af63-83ce1e78ee55', '488243256161730560', '340096183135506432');
    532. 

  532. INSERT INTO `t_sys_permission_role` VALUES ('f14392d5-b6d4-442e-85cb-b203584594e6', '488243256161730560', '340067579836108800');
    533. 

  533. INSERT INTO `t_sys_permission_role` VALUES ('f1d5389d-b3ee-401b-aa01-6e40250532a0', '488243256161730560', '496127240363311104');
    534. 

  534. INSERT INTO `t_sys_permission_role` VALUES ('f8221a34-7759-4cdf-8215-f033e277a755', '488243256161730560', '3321578609202995244');
    535. 

  535. INSERT INTO `t_sys_permission_role` VALUES ('f983b7ff-cca6-4df5-b789-4ee6c7302646', '488243256161730560', '13');
    536. 

  536. INSERT INTO `t_sys_permission_role` VALUES ('fe51b7e1-ccf5-4e46-b4d7-c5fb6f3547cc', '488243256161730560', '6192095214866268162');
    537. 

  537. 

  538. -- ----------------------------
    539. 

  539. -- Table structure for t_sys_province
    540. 

  540. -- ----------------------------
    541. 

  541. DROP TABLE IF EXISTS `t_sys_province`;
    542. 

  542. CREATE TABLE `t_sys_province` (
    543. 

  543.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
    544. 

  544.   `province_code` varchar(40) NOT NULL COMMENT '省份代码',
    545. 

  545.   `province_name` varchar(50) NOT NULL COMMENT '省份名称',
    546. 

  546.   `short_name` varchar(20) NOT NULL COMMENT '简称',
    547. 

  547.   `lng` varchar(20) DEFAULT NULL COMMENT '经度',
    548. 

  548.   `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
    549. 

  549.   `sort` int(6) DEFAULT NULL COMMENT '排序',
    550. 

  550.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    551. 

  551.   `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
    552. 

  552.   `memo` varchar(250) DEFAULT NULL COMMENT '备注',
    553. 

  553.   `data_state` int(11) DEFAULT NULL COMMENT '状态',
    554. 

  554.   PRIMARY KEY (`id`),
    555. 

  555.   KEY `Index_1` (`province_code`)
    556. 

  556. ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='省份表';
    557. 

  557. 

  558. -- ----------------------------
    559. 

  559. -- Records of t_sys_province
    560. 

  560. -- ----------------------------
    561. 

  561. INSERT INTO `t_sys_province` VALUES ('22', '500000', '重庆', '重庆', '106.504959', '29.533155', '22', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    562. 

  562. 

  563. -- ----------------------------
    564. 

  564. -- Table structure for t_sys_quartz_job
    565. 

  565. -- ----------------------------
    566. 

  566. DROP TABLE IF EXISTS `t_sys_quartz_job`;
    567. 

  567. CREATE TABLE `t_sys_quartz_job` (
    568. 

  568.   `id` varchar(255) NOT NULL COMMENT '日志id',
    569. 

  569.   `job_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
    570. 

  570.   `job_group` varchar(255) DEFAULT NULL COMMENT '任务组名',
    571. 

  571.   `invoke_target` varchar(255) DEFAULT NULL COMMENT '调用目标字符串',
    572. 

  572.   `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron执行表达式',
    573. 

  573.   `misfire_policy` varchar(255) DEFAULT NULL COMMENT 'cron计划策略',
    574. 

  574.   `concurrent` varchar(255) DEFAULT NULL COMMENT '是否并发执行（0允许 1禁止）',
    575. 

  575.   `status` int(11) DEFAULT NULL COMMENT '任务状态（0正常 1暂停）',
    576. 

  576.   PRIMARY KEY (`id`)
    577. 

  577. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务调度表';
    578. 

  578. 

  579. -- ----------------------------
    580. 

  580. -- Records of t_sys_quartz_job
    581. 

  581. -- ----------------------------
    582. 

  582. INSERT INTO `t_sys_quartz_job` VALUES ('332182389491109888', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', '*/10 * * * * ?', '12', '1', '1');
    583. 

  583. 

  584. -- ----------------------------
    585. 

  585. -- Table structure for t_sys_quartz_job_log
    586. 

  586. -- ----------------------------
    587. 

  587. DROP TABLE IF EXISTS `t_sys_quartz_job_log`;
    588. 

  588. CREATE TABLE `t_sys_quartz_job_log` (
    589. 

  589.   `id` varchar(255) NOT NULL COMMENT '主键',
    590. 

  590.   `job_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
    591. 

  591.   `job_group` varchar(255) DEFAULT NULL COMMENT '任务组名',
    592. 

  592.   `invoke_target` varchar(255) DEFAULT NULL COMMENT '调用目标字符串',
    593. 

  593.   `job_message` varchar(255) DEFAULT NULL COMMENT '日志信息',
    594. 

  594.   `status` int(11) DEFAULT NULL COMMENT '执行状态（0正常 1失败）',
    595. 

  595.   `exception_info` varchar(255) DEFAULT NULL COMMENT '异常信息',
    596. 

  596.   `start_time` datetime DEFAULT NULL COMMENT '开始时间',
    597. 

  597.   `end_time` datetime DEFAULT NULL COMMENT '结束时间',
    598. 

  598.   PRIMARY KEY (`id`)
    599. 

  599. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务调度日志表';
    600. 

  600. 

  601. -- ----------------------------
    602. 

  602. -- Records of t_sys_quartz_job_log
    603. 

  603. -- ----------------------------
    604. 

  604. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610541354455040', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：3毫秒', '0', null, '2019-09-17 00:16:01', '2019-09-17 00:16:01');
    605. 

  605. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610547549442048', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：1毫秒', '0', null, '2019-09-17 00:16:03', '2019-09-17 00:16:03');
    606. 

  606. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610553832509440', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：0毫秒', '0', null, '2019-09-17 00:16:04', '2019-09-17 00:16:04');
    607. 

  607. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610558995697664', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：0毫秒', '0', null, '2019-09-17 00:16:06', '2019-09-17 00:16:06');
    608. 

  608. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610566486724608', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：0毫秒', '0', null, '2019-09-17 00:16:07', '2019-09-17 00:16:07');
    609. 

  609. INSERT INTO `t_sys_quartz_job_log` VALUES ('333610572270669824', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：0毫秒', '0', null, '2019-09-17 00:16:09', '2019-09-17 00:16:09');
    610. 

  610. INSERT INTO `t_sys_quartz_job_log` VALUES ('354984595927732224', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：3毫秒', '0', null, '2019-11-14 23:48:53', '2019-11-14 23:48:53');
    611. 

  611. INSERT INTO `t_sys_quartz_job_log` VALUES ('354990312722141184', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：2毫秒', '0', null, '2019-11-15 00:11:36', '2019-11-15 00:11:36');
    612. 

  612. INSERT INTO `t_sys_quartz_job_log` VALUES ('354996339316232192', 'v2Task2', 'SYSTEM', 'v2Task.runTask2(1,2l,\'asa\',true,2D)', 'v2Task2 总共耗时：3毫秒', '0', null, '2019-11-15 00:35:33', '2019-11-15 00:35:33');
    613. 

  613. 

  614. -- ----------------------------
    615. 

  615. -- Table structure for t_sys_role
    616. 

  616. -- ----------------------------
    617. 

  617. DROP TABLE IF EXISTS `t_sys_role`;
    618. 

  618. CREATE TABLE `t_sys_role` (
    619. 

  619.   `id` varchar(255) NOT NULL COMMENT 'id',
    620. 

  620.   `name` varchar(255) DEFAULT NULL COMMENT '角色名称',
    621. 

  621.   PRIMARY KEY (`id`)
    622. 

  622. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';
    623. 

  623. 

  624. -- ----------------------------
    625. 

  625. -- Records of t_sys_role
    626. 

  626. -- ----------------------------
    627. 

  627. INSERT INTO `t_sys_role` VALUES ('488243256161730560', '管理员');
    628. 

  628. INSERT INTO `t_sys_role` VALUES ('488289006124007424', '用户');
    629. 

  629. INSERT INTO `t_sys_role` VALUES ('488305788310257664', '能修改用户密码角色');
    630. 

  630. 

  631. -- ----------------------------
    632. 

  632. -- Table structure for t_sys_role_user
    633. 

  633. -- ----------------------------
    634. 

  634. DROP TABLE IF EXISTS `t_sys_role_user`;
    635. 

  635. CREATE TABLE `t_sys_role_user` (
    636. 

  636.   `id` varchar(255) NOT NULL,
    637. 

  637.   `sys_user_id` varchar(255) DEFAULT NULL COMMENT '用户id',
    638. 

  638.   `sys_role_id` varchar(255) DEFAULT NULL COMMENT '角色id',
    639. 

  639.   PRIMARY KEY (`id`)
    640. 

  640. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色中间表';
    641. 

  641. 

  642. -- ----------------------------
    643. 

  643. -- Records of t_sys_role_user
    644. 

  644. -- ----------------------------
    645. 

  645. INSERT INTO `t_sys_role_user` VALUES ('353711021275353089', '353711021275353088', '488289006124007424');
    646. 

  646. INSERT INTO `t_sys_role_user` VALUES ('353714370687143936', '488294747442511872', '488289006124007424');
    647. 

  647. INSERT INTO `t_sys_role_user` VALUES ('354984037766533120', '354984005751410688', '488243256161730560');
    648. 

  648. INSERT INTO `t_sys_role_user` VALUES ('354988722443390977', '354988722443390976', '488243256161730560');
    649. 

  649. INSERT INTO `t_sys_role_user` VALUES ('354989789679849472', '354989789675655168', '488305788310257664');
    650. 

  650. INSERT INTO `t_sys_role_user` VALUES ('594342089710370816', '1', '488243256161730560');
    651. 

  651. INSERT INTO `t_sys_role_user` VALUES ('612107905532952576', '612107905532952576', '488289006124007424');
    652. 

  652. INSERT INTO `t_sys_role_user` VALUES ('612107905537146880', '612107905532952576', '488305788310257664');
    653. 

  653. 

  654. -- ----------------------------
    655. 

  655. -- Table structure for t_sys_street
    656. 

  656. -- ----------------------------
    657. 

  657. DROP TABLE IF EXISTS `t_sys_street`;
    658. 

  658. CREATE TABLE `t_sys_street` (
    659. 

  659.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
    660. 

  660.   `street_code` varchar(40) NOT NULL COMMENT '街道代码',
    661. 

  661.   `area_code` varchar(40) DEFAULT NULL COMMENT '父级区代码',
    662. 

  662.   `street_name` varchar(50) NOT NULL COMMENT '街道名称',
    663. 

  663.   `short_name` varchar(30) NOT NULL COMMENT '简称',
    664. 

  664.   `lng` varchar(20) DEFAULT NULL COMMENT '经度',
    665. 

  665.   `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
    666. 

  666.   `sort` int(6) DEFAULT NULL COMMENT '排序',
    667. 

  667.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    668. 

  668.   `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
    669. 

  669.   `memo` varchar(250) DEFAULT NULL COMMENT '备注',
    670. 

  670.   `data_state` int(11) DEFAULT NULL COMMENT '状态',
    671. 

  671.   PRIMARY KEY (`id`),
    672. 

  672.   KEY `Index_1` (`street_code`)
    673. 

  673. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='街道设置';
    674. 

  674. 

  675. -- ----------------------------
    676. 

  676. -- Records of t_sys_street
    677. 

  677. -- ----------------------------
    678. 

  678. 

  679. -- ----------------------------
    680. 

  680. -- Table structure for t_sys_user
    681. 

  681. -- ----------------------------
    682. 

  682. DROP TABLE IF EXISTS `t_sys_user`;
    683. 

  683. CREATE TABLE `t_sys_user` (
    684. 

  684.   `id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '主键',
    685. 

  685.   `username` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户账号',
    686. 

  686.   `password` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户密码',
    687. 

  687.   `nickname` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '昵称',
    688. 

  688.   PRIMARY KEY (`id`)
    689. 

  689. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户表';
    690. 

  690. 

  691. -- ----------------------------
    692. 

  692. -- Records of t_sys_user
    693. 

  693. -- ----------------------------
    694. 

  694. INSERT INTO `t_sys_user` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '管理员');
    695. 

  695. 

  696. -- ----------------------------
    697. 

  697. -- Table structure for t_test
    698. 

  698. -- ----------------------------
    699. 

  699. DROP TABLE IF EXISTS `t_test`;
    700. 

  700. CREATE TABLE `t_test` (
    701. 

  701.   `id` varchar(255) NOT NULL COMMENT '主键',
    702. 

  702.   `name` varchar(255) DEFAULT NULL COMMENT '名称',
    703. 

  703.   `age` int(11) DEFAULT NULL COMMENT '性别',
    704. 

  704.   `cratetime` datetime DEFAULT NULL COMMENT '创建时间',
    705. 

  705.   PRIMARY KEY (`id`)
    706. 

  706. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='测试表';
    707. 

  707. 

  708. -- ----------------------------
    709. 

  709. -- Records of t_test
    710. 

  710. -- ----------------------------
    711.