develop
/
digimeta-MultiSaas
12
0
Förgrening 0
Kod Ärenden 0 Pull-förfrågningar 0 Släpp 149 Wiki Aktiviteter
数字人管理平台
Du kan inte välja fler än 25 ämnen Ämnen måste starta med en bokstav eller siffra, kan innehålla bindestreck ('-') och vara max 35 tecken långa.
1506 Incheckningar
39 Grenar
647 MiB
 
 
 
 
 
 
Gren: main
Grenar Taggar
${ item.name }
Skapa branchen ${ searchTerm }
från 'main'
${ noResults }
digimeta-MultiSaas/sql/xueyi_1.sql

703 rader
91 KiB
Rå Permalänk Blame Historik 

  1. CREATE DATABASE  IF NOT EXISTS `xy-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

  2. 

  3. SET NAMES utf8mb4;

  4. 

  5. USE `xy-cloud`;

  6. -- ----------------------------

  7. -- 1、租户信息表

  8. -- ----------------------------

  9. drop table if exists te_tenant;

  10. create table te_tenant (

  11.   id		                bigint	            not null                                comment '租户Id',

  12.   strategy_id		        bigint	            not null                                comment '策略Id',

  13.   name		                varchar(50)	        not null	                            comment '租户账号',

  14.   system_name		        varchar(50)	        not null 	                            comment '系统名称',

  15.   nick		                varchar(50)	        not null 	                            comment '租户名称',

  16.   logo		                varchar(200)	    default ''	                            comment '租户logo',

  17.   name_frequency            tinyint             default 0                               comment '账号修改次数',

  18.   is_lessor                 char(1)             not null default 'N'	                comment '超管租户（Y是 N否）',

  19.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  20.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  21.   remark                    varchar(200)        default null                            comment '备注',

  22.   create_by                 bigint              default null                            comment '创建者',

  23.   create_time               datetime            default current_timestamp               comment '创建时间',

  24.   update_by                 bigint              default null                            comment '更新者',

  25.   update_time               datetime            on update current_timestamp             comment '更新时间',

  26.   is_default                char(1)             not null default 'N'	                comment '默认租户（Y是 N否）',

  27.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  28.   primary key (id)

  29. ) engine = innodb comment = '租户信息表';

  30. 

  31. -- ----------------------------

  32. -- 初始化-租户信息表数据

  33. -- ----------------------------

  34. insert into te_tenant (id, is_lessor, is_default, strategy_id,  name, system_name, nick, logo)

  35. values (1, 'Y', 'Y', 1, 'administrator', '租管租户', 'xueYi1', 'https://images.gitee.com/uploads/images/2021/1101/141601_d68e92a4_7382127.jpeg'),

  36.        (2, 'N', 'N', 1, 'xueYi', '雪忆科技', 'xueYi1', 'https://images.gitee.com/uploads/images/2021/1101/141601_d68e92a4_7382127.jpeg');

  37. 

  38. -- ----------------------------

  39. -- 2、策略信息表

  40. -- ----------------------------

  41. drop table if exists te_strategy;

  42. create table te_strategy (

  43.   id		                bigint	            not null                                comment '策略Id',

  44.   name                      varchar(100)	    not null default ''	                    comment '策略名称',

  45.   source_id                 bigint	            not null	                            comment '数据源Id',

  46.   source_slave              varchar(200)	    not null	                            comment '数据源编码',

  47.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  48.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  49.   remark                    varchar(200)        default null                            comment '备注',

  50.   create_by                 bigint              default null                            comment '创建者',

  51.   create_time               datetime            default current_timestamp               comment '创建时间',

  52.   update_by                 bigint              default null                            comment '更新者',

  53.   update_time               datetime            on update current_timestamp             comment '更新时间',

  54.   is_default                char(1)             not null default 'N'	                comment '默认策略（Y是 N否）',

  55.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  56.   primary key (id)

  57. ) engine = innodb comment = '数据源策略表';

  58. 

  59. -- ----------------------------

  60. -- 初始化-策略信息表数据

  61. -- ----------------------------

  62. insert into te_strategy(id, name, is_default, source_id, source_slave, sort)

  63. values (1, '默认注册策略', 'Y', 1, 'slave', 1);

  64. 

  65. -- ----------------------------

  66. -- 4、数据源表|管理系统数据源信息 | 主库有且只能有一个，用途：主要用于存储公共数据，具体看后续文档或视频

  67. -- ----------------------------

  68. drop table if exists te_source;

  69. create table te_source (

  70.   id		                bigint	            not null                                comment '数据源Id',

  71.   name		                varchar(50)	        not null                                comment '数据源名称',

  72.   slave		                varchar(200)	    not null	                            comment '数据源编码',

  73.   driver_class_name		    varchar(200)	    not null	                            comment '驱动',

  74.   url_prepend	            varchar(200)	    not null	                            comment '连接地址',

  75.   url_append	            varchar(200)	    not null default ''	                    comment '连接参数',

  76.   user_name	                varchar(100) 	    not null	                            comment '用户名',

  77.   password	                varchar(100) 	    not null default ''	                    comment '密码',

  78.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  79.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  80.   remark                    varchar(200)        default null                            comment '备注',

  81.   create_by                 bigint              default null                            comment '创建者',

  82.   create_time               datetime            default current_timestamp               comment '创建时间',

  83.   update_by                 bigint              default null                            comment '更新者',

  84.   update_time               datetime            on update current_timestamp             comment '更新时间',

  85.   is_default                char(1)             not null default 'N'	                comment '默认数据源（Y是 N否）',

  86.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  87.   primary key (id)

  88. ) engine = innodb comment = '数据源表';

  89. 

  90. -- ----------------------------

  91. -- 初始化-数据源表数据 | 这条数据为我的基础库，实际使用时调整成自己的库即可

  92. -- ----------------------------

  93. insert into te_source(id, name, is_default, slave, driver_class_name, url_prepend, url_append, user_name, password)

  94. values (1, '注册数据源', 'Y', 'slave', 'com.mysql.cj.jdbc.Driver', 'jdbc:mysql://172.17.0.1:3308/xy-cloud1', '?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8', 'root', 'password');

  95. 

  96. -- ----------------------------

  97. -- 6、模块信息表

  98. -- ----------------------------

  99. drop table if exists sys_module;

  100. create table sys_module (

  101.   id		                bigint	            not null                                comment '模块Id',

  102.   name		                varchar(50)	        not null	                            comment '模块名称',

  103.   logo                      varchar(200)	    default '' 	        	                comment '模块logo',

  104.   path                      varchar(200)        not null default ''                     comment '路由地址',

  105.   param_path                varchar(255)        default null                            comment '路由参数',

  106.   type		                char(1)	            not null default '0'	                comment '模块类型（0常规 1内嵌 2外链）',

  107.   hide_module		        char(1)	            not null default '0'	                comment '模块显隐状态（0显示 1隐藏）',

  108.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  109.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  110.   remark                    varchar(200)        default null                            comment '备注',

  111.   create_by                 bigint              default null                            comment '创建者',

  112.   create_time               datetime            default current_timestamp               comment '创建时间',

  113.   update_by                 bigint              default null                            comment '更新者',

  114.   update_time               datetime            on update current_timestamp             comment '更新时间',

  115.   is_common                 char(1)             not null default '1'	                comment '公共模块（0公共 1私有）',

  116.   is_default                char(1)             not null default 'N'	                comment '默认模块（Y是 N否）',

  117.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  118.   tenant_id		            bigint	            not null                                comment '租户Id',

  119.   primary key (id)

  120. ) engine = innodb comment = '模块信息表';

  121. 

  122. # ----------------------------

  123. # 初始化-模块信息表数据

  124. # ----------------------------

  125. insert into sys_module (id, name, type, path, param_path, is_default, hide_module, logo, remark, is_common, tenant_id)

  126. values (1, '基础平台' ,    '0', '', '', 'Y', '0', 'https://images.gitee.com/uploads/images/2021/1101/141155_f3dfce1d_7382127.jpeg', '基础平台', '0', 0),

  127.        (2, '开发者平台' , '0', '', '', 'Y', '0', 'https://images.gitee.com/uploads/images/2021/1101/141601_d68e92a4_7382127.jpeg', '开发者平台', '0', 0);

  128. 

  129. -- ----------------------------

  130. -- 7、菜单权限表

  131. -- ----------------------------

  132. drop table if exists sys_menu;

  133. create table sys_menu (

  134.   id                        bigint              not null                                comment '菜单Id',

  135.   parent_id                 bigint              not null default 0                      comment '父菜单Id',

  136.   name                      varchar(100)        not null                                comment '菜单名称',

  137.   title                     varchar(50)         not null                                comment '菜单标题 | 多语言',

  138.   level                     int                 not null                                comment '树层级',

  139.   ancestors                 varchar(500)        default ''                              comment '祖级列表',

  140.   path                      varchar(200)        default null                            comment '路由地址',

  141.   frame_src                 varchar(200)        default null                            comment '外链地址 | 仅页面类型为外链时生效',

  142.   component                 varchar(255)        default null                            comment '组件路径',

  143.   param_path                varchar(255)        default null                            comment '路由参数',

  144.   transition_name           varchar(255)        default null                            comment '路由切换动画',

  145.   ignore_route              char(1)             not null default  'N'                   comment '是否忽略路由（Y是 N否）',

  146.   is_cache                  char(1)             not null default  'N'                   comment '是否缓存（Y是 N否）',

  147.   is_affix                  char(1)             not null default  'N'                   comment '是否固定标签（Y是 N否）',

  148.   is_disabled               char(1)             not null default  'N'                   comment '是否禁用（Y是 N否）',

  149.   frame_type                char(1)             not null default  '0'                   comment '页面类型（0常规 1内嵌 2外链）',

  150.   menu_type                 char(1)             not null                                comment '菜单类型（M目录 C菜单 X详情 F按钮）',

  151.   hide_tab                  char(1)             not null default  '0'                   comment '标签显隐状态（0显示 1隐藏）',

  152.   hide_menu                 char(1)             not null default  '0'                   comment '菜单显隐状态（0显示 1隐藏）',

  153.   hide_breadcrumb           char(1)             not null default  '0'                   comment '面包屑路由显隐状态（0显示 1隐藏）',

  154.   hide_children             char(1)             not null default  '0'                   comment '子菜单显隐状态（0显示 1隐藏）',

  155.   hide_path_for_children    char(1)             not null default  '0'                   comment '是否在子级菜单的完整path中忽略本级path（0显示 1隐藏）',

  156.   dynamic_level             int                 not null default 1                      comment '详情页可打开Tab页数',

  157.   real_path                 varchar(255)        default null                            comment '详情页的实际Path',

  158.   perms                     varchar(100)        default null                            comment '权限标识',

  159.   icon                      varchar(100)        default null                            comment '菜单图标',

  160.   sort                      int unsigned        not null default  0                     comment '显示顺序',

  161.   status                    char(1)             not null default  '0'                   comment '状态（0正常 1停用）',

  162.   remark                    varchar(200)        default null                            comment '备注',

  163.   create_by                 bigint              default null                            comment '创建者',

  164.   create_time               datetime            default current_timestamp               comment '创建时间',

  165.   update_by                 bigint              default null                            comment '更新者',

  166.   update_time               datetime            on update current_timestamp             comment '更新时间',

  167.   is_common                 char(1)             not null default  '1'                   comment '公共菜单（0公共 1私有）',

  168.   is_default                char(1)             not null default  'N'                   comment '默认菜单（Y是 N否）',

  169.   del_flag                  tinyint             not null default  0                     comment '删除标志(0正常 1删除)',

  170.   module_id                 bigint              not null                                comment '模块Id',

  171.   tenant_id                 bigint              not null                                comment '租户Id',

  172.   primary key (id),

  173.   unique (name)

  174. ) engine = innodb comment = '菜单权限表';

  175. 

  176. insert into sys_menu (id, parent_id, name, title, level, ancestors, path, frame_src, component, param_path, transition_name, ignore_route, is_cache, is_affix, is_disabled, frame_type, menu_type, hide_tab, hide_menu, hide_breadcrumb, hide_children, hide_path_for_children, dynamic_level, real_path, perms, icon, sort, remark, is_common, is_default, module_id, tenant_id)

  177. values (0, 0, 'd346c7dbf265416086dbe2951a7465b2', '默认菜单', 0, '', 'default', null, null, null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, null, '', 1, '目录:默认菜单', '0', 'Y', 1, 0),

  178.        (13000000, 0, '4be0456e05a7422d9f1c82fb7bf19377', '组织管理', 1, '0', 'organize', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:apartment-outlined', 1, '目录:组织管理', '0', 'Y', 1, 0),

  179.            (13010000, 13000000, '0a612ebdfaa64ea4b8fd8cfd787042ea', '部门管理', 2, '0,13000000', 'dept', null, 'system/organize/dept/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'organize:dept:list', 'ant-design:partition-outlined', 1, '菜单:部门管理', '0', 'Y', 1, 0),

  180.                (13010100, 13010000, 'c67c9520af2c48d89e1bae0d2a0342d1', '部门详情', 3, '0,13000000,13010000', 'deptDetail/:id', null, 'system/organize/dept/DeptDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'organize:dept:single', null, 1, '详情:部门详情', '0', 'Y', 1, 0),

  181.                (13010200, 13010000, '5e50660b195a49c4860607aec14fc330', '部门新增', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:add', null, 2, '按钮:部门新增', '0', 'Y', 1, 0),

  182.                (13010300, 13010000, 'ad0a108f2c35433daf1864cf4cf93b64', '部门修改', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:edit', null, 3, '按钮:部门修改', '0', 'Y', 1, 0),

  183.                (13010400, 13010000, 'df7b77ef91c8433f97a9848ebe9b714b', '部门修改状态', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:es', null, 3, '按钮:部门修改状态', '0', 'Y', 1, 0),

  184.                (13010500, 13010000, 'a4c9cb1f239744b6bc7e6c5f11ba3268', '部门权限分配', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:auth', null, 5, '按钮:部门权限分配', '0', 'Y', 1, 0),

  185.                (13010600, 13010000, '83a7e4bafb154a938b2c67d7f3e540d5', '部门删除', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:delete', null, 6, '按钮:部门删除', '0', 'Y', 1, 0),

  186.                (13010700, 13010000, 'ba6fe94f191649468a35d1799efedd56', '部门导入', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:import', null, 7, '按钮:部门导入', '0', 'Y', 1, 0),

  187.                (13010800, 13010000, 'd3ae0d58b37d4bd6bd38db6a5ccefe7e', '部门导出', 3, '0,13000000,13010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:dept:export', null, 8, '按钮:部门导出', '0', 'Y', 1, 0),

  188.            (13020000, 13000000, 'ecdcabe9c00a408796626a83d0129fdb', '岗位管理', 2, '0,13000000', 'post', null, 'system/organize/post/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'organize:post:list', 'ant-design:idcard-outlined', 2, '菜单:岗位管理', '0', 'Y', 1, 0),

  189.                (13020100, 13020000, '270eab9abe6a4e58b8c06d1339b46009', '岗位详情', 3, '0,13000000,13020000', 'postDetail/:id', null, 'system/organize/post/PostDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'organize:post:single', null, 1, '详情:岗位详情', '0', 'Y', 1, 0),

  190.                (13020200, 13020000, '5ee95c2e5af8481ca6346faa82974251', '岗位新增', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:add', null, 3, '按钮:岗位新增', '0', 'Y', 1, 0),

  191.                (13020300, 13020000, '082b9043d201490badbb403e2de9d0e1', '岗位修改', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:edit', null, 4, '按钮:岗位修改', '0', 'Y', 1, 0),

  192.                (13020400, 13020000, '6a9ffc830afd4f3d8f74a047d0619e0f', '岗位修改状态', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:es', null, 5, '按钮:岗位修改状态', '0', 'Y', 1, 0),

  193.                (13020500, 13020000, '1af7167de8ba4f819149956fe5f166e9', '岗位权限分配', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:auth', null, 5, '按钮:岗位权限分配', '0', 'Y', 1, 0),

  194.                (13020600, 13020000, 'baf3aa4d771a4ac5b80c0192ae52964b', '岗位删除', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:delete', null, 6, '按钮:岗位删除', '0', 'Y', 1, 0),

  195.                (13020700, 13020000, 'f41ed2a5ba68445f9084bb6f2dee5db6', '岗位导入', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:import', null, 7, '按钮:岗位导入', '0', 'Y', 1, 0),

  196.                (13020800, 13020000, 'a5c252aace4243eea2c5102ea14e347a', '岗位导出', 3, '0,13000000,13020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:post:export', null, 8, '按钮:岗位导出', '0', 'Y', 1, 0),

  197.            (13030000, 13000000, 'f450bb13df9f42618ecbe62c46346d3e', '用户管理', 2, '0,13000000', 'user', null, 'system/organize/user/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'organize:user:list', 'ant-design:user-outlined', 3, '菜单:用户管理', '0', 'Y', 1, 0),

  198.                (13030100, 13030000, '3584b9c409ab49b79b2888936de01a2d', '用户详情', 3, '0,13000000,13030000', 'userDetail/:id', null, 'system/organize/user/UserDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'organize:user:single', null, 1, '详情:用户详情', '0', 'Y', 1, 0),

  199.                (13030200, 13030000, '679d5eccf32d43639898d6d5a347d643', '用户新增', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:add', null, 3, '按钮:用户新增', '0', 'Y', 1, 0),

  200.                (13030300, 13030000, 'bc20a8b4c70f42ada4666269cc6a7624', '用户修改', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:edit', null, 4, '按钮:用户修改', '0', 'Y', 1, 0),

  201.                (13030400, 13030000, '5fb9a4cbaa1f4059aff2f22ff02a78f0', '用户修改状态', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:es', null, 5, '按钮:用户修改状态', '0', 'Y', 1, 0),

  202.                (13030500, 13030000, 'b0d4e749c5eb49bdb3634fc5d4e57ecc', '用户权限分配', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:auth', null, 5, '按钮:用户权限分配', '0', 'Y', 1, 0),

  203.                (13030600, 13030000, '6669f111d1974ec28b82e830ad2195c2', '用户删除', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:delete', null, 6, '按钮:用户删除', '0', 'Y', 1, 0),

  204.                (13030700, 13030000, '2527782114544c53acdff12dc8e09a34', '用户导入', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:import', null, 7, '按钮:用户导入', '0', 'Y', 1, 0),

  205.                (13030800, 13030000, 'abc1c9ec3a73477184384bbfc37cf8a6', '用户导出', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:export', null, 8, '按钮:用户导出', '0', 'Y', 1, 0),

  206.                (13030900, 13030000, 'a79774cd4205485c9e5ea9c36be41573', '用户密码重置', 3, '0,13000000,13030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'organize:user:rp', null, 5, '按钮:用户密码修改', '0', 'Y', 1, 0),

  207.        (14000000, 0, '61ac2678fa5a4cd7977c118114ff1828', '权限管理', 1, '0', 'authority', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:safety-certificate-outlined', 2, '目录:权限管理', '0', 'Y', 1, 0),

  208.            (14010000, 14000000, '7fdc19cde2494105b5b1ee951a560904', '模块管理', 2, '0,14000000', 'module', null, 'system/authority/module/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'authority:module:list', 'ant-design:appstore-add-outlined', 1, '菜单:模块管理', '0', 'Y', 1, 0),

  209.                (14010100, 14010000, 'b6aeef72800e4082ace3673e454a66b6', '模块详情', 3, '0,14000000,14010000', 'moduleDetail/:id', null, 'system/authority/module/ModuleDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'authority:module:single', null, 1, '详情:模块详情', '0', 'Y', 1, 0),

  210.                (14010200, 14010000, '96047ce6aead414bab788070a65abab9', '模块新增', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:add', null, 2, '按钮:模块新增', '0', 'Y', 1, 0),

  211.                (14010300, 14010000, 'ec5c9fc0b5ba4c9794f5b87b031c3104', '模块修改', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:edit', null, 3, '按钮:模块修改', '0', 'Y', 1, 0),

  212.                (14010400, 14010000, 'ca53bb0ac4524d58baf1e647e0d0da68', '模块修改状态', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:es', null, 4, '按钮:模块修改状态', '0', 'Y', 1, 0),

  213.                (14010500, 14010000, '37a9b9cc2bcf4e7a98ea535526b3a597', '模块删除', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:delete', null, 5, '按钮:模块删除', '0', 'Y', 1, 0),

  214.                (14010600, 14010000, '01e246c784d04ef1951b2cade43e104b', '模块导入', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:import', null, 6, '按钮:模块导入', '0', 'Y', 1, 0),

  215.                (14010700, 14010000, '559dae9283fb41178ee16ca5f7838ac7', '模块导出', 3, '0,14000000,14010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:module:export', null, 7, '按钮:模块导出', '0', 'Y', 1, 0),

  216.            (14020000, 14000000, 'bba8d25857ec45f38a8946c8c74182c2', '菜单管理', 2, '0,14000000', 'menu', null, 'system/authority/menu/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'authority:menu:list', 'ant-design:bars-outlined', 2, '菜单:菜单管理', '0', 'Y', 1, 0),

  217.                (14020100, 14020000, '5e4b17aeae124b91b7bad8f4dd11b7b4', '菜单详情', 3, '0,14000000,14020000', 'menuDetail/:id', null, 'system/authority/menu/MenuDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'authority:menu:single', null, 1, '详情:菜单详情', '0', 'Y', 1, 0),

  218.                (14020200, 14020000, 'a1ea4b626a104a5380a6a2ba3eddcd2e', '菜单新增', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:add', null, 2, '按钮:菜单新增', '0', 'Y', 1, 0),

  219.                (14020300, 14020000, 'af5e2c3864eb4ef3a602f3d5619a53d4', '菜单修改', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:edit', null, 3, '按钮:菜单修改', '0', 'Y', 1, 0),

  220.                (14020400, 14020000, '69ebe38822d54e81b828c36a8dfdb479', '菜单修改状态', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:es', null, 4, '按钮:菜单修改状态', '0', 'Y', 1, 0),

  221.                (14020500, 14020000, 'ed7bdf2e22244a72b3963e9750d2df98', '菜单删除', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:delete', null, 5, '按钮:菜单删除', '0', 'Y', 1, 0),

  222.                (14020600, 14020000, 'ae18f8022bf74bf991c0711db16e3acc', '菜单导入', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:import', null, 6, '按钮:菜单导入', '0', 'Y', 1, 0),

  223.                (14020700, 14020000, '1c08bd6fa572486f805d7cea86d1d644', '菜单导出', 3, '0,14000000,14020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:menu:export', null, 7, '按钮:菜单导出', '0', 'Y', 1, 0),

  224.            (14030000, 14000000, '88c136711d98441699a6013ef27a356a', '角色管理', 2, '0,14000000', 'role', null, 'system/authority/role/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'authority:role:list', 'ant-design:team-outlined', 3, '菜单:角色管理', '0', 'Y', 1, 0),

  225.                (14030100, 14030000, '458c8e2ae43e47059b978504dd363a94', '角色详情', 3, '0,14000000,14030000', 'roleDetail/:id', null, 'system/authority/role/RoleDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'authority:role:single', null, 1, '详情:角色详情', '0', 'Y', 1, 0),

  226.                (14030200, 14030000, '949497ca68724eb18f43b550c4c4bf5d', '角色新增', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:add', null, 2, '按钮:角色新增', '0', 'Y', 1, 0),

  227.                (14030300, 14030000, '77604dc9a47b4cc296e9f41cb76f81f5', '角色修改', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:edit', null, 3, '按钮:角色修改', '0', 'Y', 1, 0),

  228.                (14030400, 14030000, 'ed3d7dfa06424f1abe271058aa3abbd9', '角色修改状态', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:es', null, 4, '按钮:角色修改状态', '0', 'Y', 1, 0),

  229.                (14030500, 14030000, '8bd13d9c71624e60a288d424a6a96670', '角色权限分配', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:auth', null, 5, '按钮:角色权限分配', '0', 'Y', 1, 0),

  230.                (14030600, 14030000, '54dc750a6076494ebc40e62b5d775db7', '角色删除', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:delete', null, 6, '按钮:角色删除', '0', 'Y', 1, 0),

  231.                (14030700, 14030000, '0cc43f7717ca4e2a9b0d8e4631fe1451', '角色导入', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:import', null, 7, '按钮:角色导入', '0', 'Y', 1, 0),

  232.                (14030800, 14030000, '8982c4c0b99f45b1a34c1cd146e6a116', '角色导出', 3, '0,14000000,14030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'authority:role:export', null, 8, '按钮:角色导出', '0', 'Y', 1, 0),

  233.        (15000000, 0, 'de6e93785ba944e1bde5538e92bd7b91', '公告管理', 1, '0', 'notice', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:schedule-outlined', 3, '目录:公告管理', '0', 'Y', 1, 0),

  234.            (15010000, 15000000, 'b7214522d55c4f1ebd381859dc6774bb', '通知公告', 2, '0,15000000', 'notice', null, 'system/notice/notice/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'system:notice:list', 'ant-design:notification-outlined', 1, '菜单:通知公告管理', '0', 'Y', 1, 0),

  235.                (15010100, 15010000, '3b77bf3ae1264e5a960262cd898a9279', '通知公告详情', 3, '0,15000000,15010000', 'noticeDetail/:id', null, 'system/notice/notice/NoticeDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'system:notice:single', null, 1, '详情:通知公告详情', '0', 'Y', 1, 0),

  236.                (15010200, 15010000, '9d21b1e6c2134ac9943db2d1ffa4d61f', '通知公告新增', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:add', null, 2, '按钮:通知公告新增', '0', 'Y', 1, 0),

  237.                (15010300, 15010000, '04b84309c6544e20bf40df26349b4212', '通知公告修改', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:edit', null, 3, '按钮:通知公告修改', '0', 'Y', 1, 0),

  238.                (15010400, 15010000, '4de8d945df96492ea79bcc1d98100051', '通知公告修改状态', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:es', null, 4, '按钮:通知公告修改状态', '0', 'Y', 1, 0),

  239.                (15010500, 15010000, '010e949049864492b046883b8571063d', '通知公告删除', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:delete', null, 5, '按钮:通知公告删除', '0', 'Y', 1, 0),

  240.                (15010600, 15010000, 'fb58b0e282154fe8802342fd4c0e14cf', '通知公告导入', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:import', null, 6, '按钮:通知公告导入', '0', 'Y', 1, 0),

  241.                (15010700, 15010000, '257064a1e547431bbfec47d5be281e67', '通知公告导出', 3, '0,15000000,15010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'system:notice:export', null, 7, '按钮:通知公告导出', '0', 'Y', 1, 0),

  242.        (16000000, 0, 'fa8965418a3540a99a62c805a4616e59', '系统管理', 1, '0', 'system', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:control-outlined', 4, '目录:系统管理', '0', 'Y', 1, 0),

  243.            (16010000, 16000000, '60a02b15ddcf45eab582a0c57af6ae62', '定时任务', 2, '0,16000000', 'job', null, 'system/system/job/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'schedule:job:list', 'ant-design:field-time-outlined', 1, '菜单:定时任务管理', '0', 'Y', 1, 0),

  244.                (16010100, 16010000, '101aeea275ce4c61b0652491f75125c0', '定时任务详情', 3, '0,16000000,16010000', 'jobDetail/:id', null, 'system/system/job/JobDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'schedule:job:single', null, 1, '详情:定时任务详情', '0', 'Y', 1, 0),

  245.                (16010200, 16010000, 'c48c23456ed144719fe6d0e35d9e8ddf', '调度日志', 3, '0,16000000,16010000', 'jobLogDetail/:id', null, 'system/system/jobLog/index', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'schedule:job:list', null, 2, '详情:调度日志', '0', 'Y', 1, 0),

  246.                (16010300, 16010000, '099a0d943a604d0198516e5f6766ac04', '定时任务新增', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:add', null, 3, '按钮:定时任务新增', '0', 'Y', 1, 0),

  247.                (16010400, 16010000, '0acf6076acca4ff689f3df52161099e7', '定时任务修改', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:edit', null, 4, '按钮:定时任务修改', '0', 'Y', 1, 0),

  248.                (16010500, 16010000, '83398a4cd3ce4aa1a26a00b0b8a7612b', '定时任务修改状态', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:es', null, 5, '按钮:定时任务修改状态', '0', 'Y', 1, 0),

  249.                (16010600, 16010000, '96bdff8d31be422b89cafb64d22ffd2c', '定时任务删除', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:delete', null, 6, '按钮:定时任务删除', '0', 'Y', 1, 0),

  250.                (16010700, 16010000, 'f53b8a8b511b470f836bc2b92450e641', '定时任务导入', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:import', null, 7, '按钮:定时任务导入', '0', 'Y', 1, 0),

  251.                (16010800, 16010000, 'd693fa7ca6b74ee9a2b4c87d0b3a2e8a', '定时任务导出', 3, '0,16000000,16010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'schedule:job:export', null, 8, '按钮:定时任务导出', '0', 'Y', 1, 0),

  252.        (17000000, 0, 'e24afc855afc485d961b865d5d999811', '系统监控', 1, '0', 'monitor', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:eye-outlined', 5, '目录:系统监控', '0', 'Y', 1, 0),

  253.            (17010000, 17000000, 'f4a053ab18c84a82be6b2f04d3adaaac', '在线用户', 2, '0,17000000', 'online', null, 'system/monitor/online/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:online:list', 'ant-design:contacts-outlined', 1, '菜单:在线用户管理', '0', 'Y', 1, 0),

  254.                (17010100, 17010000, '6829ff5c29894306b2d4fa0d6769e6e6', '在线用户强退', 3, '0,17000000,17010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:online:forceLogout', null, 1, '按钮:在线用户强退', '0', 'Y', 1, 0),

  255.            (17020000, 17000000, '693be0ee3df14643ba93acf1b0e2df97', '日志管理', 2, '0,17000000', 'log', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:file-text-outlined', 2, '目录:日志管理', '0', 'Y', 1, 0),

  256.                (17020100, 17020000, '89d2de0ab59248a59f41d097a41517b5', '登录日志', 3, '0,17000000,17020000', 'loginLog', null, 'system/monitor/loginLog/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:loginLog:list', 'ant-design:contacts-outlined', 3, '菜单:登录日志', '0', 'Y', 1, 0),

  257.                    (17020101, 17020100, '10afaa52d5be4a9ca9de5da3567d3d47', '登录日志删除', 4, '0,17000000,17020000,17020100', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:loginLog:delete', null, 1, '按钮:登录日志删除', '0', 'Y', 1, 0),

  258.                    (17020102, 17020100, 'f29ae2f1ec794de992109776f46743cc', '登录日志导出', 4, '0,17000000,17020000,17020100', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:loginLog:export', null, 2, '按钮:登录日志导出', '0', 'Y', 1, 0),

  259.                (17020200, 17020000, '7a3b5c396f8647499a9c9cd97712324a', '操作日志', 3, '0,17000000,17020000', 'operateLog', null, 'system/monitor/operateLog/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:operateLog:list', 'ant-design:contacts-twotone', 4, '菜单:操作日志管理', '0', 'Y', 1, 0),

  260.                    (17020201, 17020000, '8b4266f509f748baac4f86739d7bb8c9', '操作日志详情', 4, '0,17000000,17020000,17020200', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:operateLog:add', null, 1, '按钮:操作日志详情', '0', 'Y', 1, 0),

  261.                    (17020202, 17020000, '8340af3b5dcc44e2837ef92e7de4da9d', '操作日志删除', 4, '0,17000000,17020000,17020200', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:operateLog:delete', null, 2, '按钮:操作日志删除', '0', 'Y', 1, 0),

  262.                    (17020203, 17020000, '05598058a8794251b454025d863c6daa', '操作日志导出', 4, '0,17000000,17020000,17020200', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'monitor:operateLog:export', null, 3, '按钮:操作日志导出', '0', 'Y', 1, 0),

  263.        (23000000, 0, 'fbaad9604c74427592126a9a0e756067', '系统工具', 1, '0', 'generate', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:setting-outlined', 6, '目录:系统工具', '0', 'Y', 2, 0),

  264.            (23010000, 23000000, 'ebd46c2fd3c3429896de95a82bcf1d8b', '代码生成', 2, '0,23000000', 'gen', null, 'gen/generate/gen/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'generate:gen:list', 'ant-design:experiment-outlined', 1, '菜单:代码生成', '0', 'Y', 2, 0),

  265.                (23010100, 23010000, 'b489b7b0e645471eb42ed8b1f0365d32', '代码生成配置', 3, '0,23000000,23010000', 'generateDetail/:id', null, 'gen/generate/gen/GenDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'generate:gen:edit', null, 1, '详情:代码生成配置', '0', 'Y', 2, 0),

  266.                (23010200, 23010000, 'c49d2b1d7d6640e7bd331aa494b05e58', '代码生成预览', 3, '0,23000000,23010000', 'codeDetail/:id', null, 'gen/generate/gen/CodeDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'generate:gen:preview', null, 2, '详情:代码生成预览', '0', 'Y', 2, 0),

  267.                (23010300, 23010000, 'f264257d3d4948bd9204ee5ba39b1661', '代码生成导入', 3, '0,23000000,23010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'generate:gen:import', null, 3, '按钮:代码生成导入', '0', 'Y', 2, 0),

  268.                (23010400, 23010000, '828aa317e06b48a2adc9d783ee968d99', '代码生成下载', 3, '0,23000000,23010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'generate:gen:code', null, 4, '按钮:代码生成下载', '0', 'Y', 2, 0),

  269.                (23010500, 23010000, '29db55acc054471f8b68411f99be1dee', '代码生成删除', 3, '0,23000000,23010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'generate:gen:delete', null, 5, '按钮:代码生成删除', '0', 'Y', 2, 0),

  270.            (23020000, 23000000, '8fa8a4e494594496a865ab028483d28b', '系统接口', 2, '0,23000000', 'swagger', 'http://localhost:8080/webjars/swagger-ui/index.html', null, null, null, 'N', 'N', 'N', 'N', '1', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:swagger:list', 'ant-design:api-twotone', 2, '菜单:系统接口', '0', 'Y', 2, 0),

  271.        (21000000, 0, '65a261f21077447fa28db33268f5ae82', '租户管理', 1, '0', 'tenant', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:bank-outlined', 7, '目录:租户管理', '0', 'Y', 2, 0),

  272.            (21010000, 21000000, '0109cdb290144529a5153737dc5e93d6', '租户管理', 2, '0,21000000', 'tenant', null, 'tenant/tenant/tenant/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:list', 'ant-design:shop-twotone', 1, '菜单:租户管理', '0', 'Y', 2, 0),

  273.                (21010100, 21010000, 'a535eb84b07049f685005bb1c83a0981', '租户详情', 3, '0,21000000,21010000', 'tenantDetail/:id', null, 'tenant/tenant/tenant/TenantDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'tenant:tenant:single', null, 1, '详情:租户详情', '0', 'Y', 2, 0),

  274.                (21010200, 21010000, '942dfd9e742c4392beae3e5618769d5d', '租户新增', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:add', null, 2, '按钮:租户新增', '0', 'Y', 2, 0),

  275.                (21010300, 21010000, '9c081b0a1fea467fb2349145fa6b49fd', '租户修改', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:edit', null, 3, '按钮:租户修改', '0', 'Y', 2, 0),

  276.                (21010400, 21010000, '2ee5caad992d4a73b402931c038e21cf', '租户修改状态', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:es', null, 4, '按钮:租户修改状态', '0', 'Y', 2, 0),

  277.                (21010500, 21010000, 'dfd3f200a5c145c88b90c78bb91312a3', '租户权限分配', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:auth', null, 5, '按钮:租户权限分配', '0', 'Y', 2, 0),

  278.                (21010600, 21010000, '9398fdb1f5e34d52ba0df19a4ac66a5c', '租户删除', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:delete', null, 6, '按钮:租户删除', '0', 'Y', 2, 0),

  279.                (21010700, 21010000, '77eab2f22c0944e1a3e544787e21c874', '租户导入', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:import', null, 7, '按钮:租户导入', '0', 'Y', 2, 0),

  280.                (21010800, 21010000, '72dd64db42fb42d8ac4851d28a4d4946', '租户导出', 3, '0,21000000,21010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:tenant:export', null, 8, '按钮:租户导出', '0', 'Y', 2, 0),

  281.            (21020000, 21000000, '6b1f5a23273f4be2a7aeaaec16d5a972', '源策略管理', 2, '0,21000000', 'strategy', null, 'tenant/tenant/strategy/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:list', 'ant-design:code-sandbox-outlined', 2, '菜单:数据源策略管理', '0', 'Y', 2, 0),

  282.                (21020100, 21020000, 'bb6ecc8a720a4793bd93c6d060abd4d0', '源策略详情', 3, '0,21000000,21020000', 'strategyDetail/:id', null, 'tenant/tenant/strategy/StrategyDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'tenant:strategy:single', null, 1, '详情:数据源策略详情', '0', 'Y', 2, 0),

  283.                (21020200, 21020000, 'eb999cfc3b924c5d9973cfd3d24ee221', '源策略新增', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:add', null, 2, '按钮:数据源策略新增', '0', 'Y', 2, 0),

  284.                (21020300, 21020000, '7063e7b32edb49769dbf4a66c69470c6', '源策略修改', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:edit', null, 3, '按钮:数据源策略修改', '0', 'Y', 2, 0),

  285.                (21020400, 21020000, '303eb6f1190e4f288f6019a5197f0de6', '源策略修改状态', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:es', null, 4, '按钮:数据源策略修改状态', '0', 'Y', 2, 0),

  286.                (21020500, 21020000, '4866eca79112480c8791ab3b01acc15a', '源策略删除', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:delete', null, 5, '按钮:数据源策略删除', '0', 'Y', 2, 0),

  287.                (21020600, 21020000, '7fc8f11b95cd497ab8b93f1d93107124', '源策略导入', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:import', null, 6, '按钮:数据源策略导入', '0', 'Y', 2, 0),

  288.                (21020700, 21020000, '6fe711d2c5b648149f52e5e8a1be809a', '源策略导出', 3, '0,21000000,21020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:strategy:export', null, 7, '按钮:数据源策略导出', '0', 'Y', 2, 0),

  289.            (21030000, 21000000, 'eebe7073cbe54614baec1507c90795a5', '数据源管理', 2, '0,21000000', 'source', null, 'tenant/source/source/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'tenant:source:list', 'ant-design:link-outlined', 3, '菜单:数据源管理', '0', 'Y', 2, 0),

  290.                (21030100, 21030000, '55b4eab094a540a6b0ad4584108566ef', '数据源详情', 3, '0,21000000,21030000', 'sourceDetail/:id', null, 'tenant/source/source/SourceDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'tenant:source:single', null, 1, '详情:数据源详情', '0', 'Y', 2, 0),

  291.                (21030200, 21030000, '2f8484ccb4944f5780535c5a6835fe65', '数据源新增', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:add', null, 2, '按钮:数据源新增', '0', 'Y', 2, 0),

  292.                (21030300, 21030000, '558308f42a1e4a269fa9fa33b294d730', '数据源修改', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:edit', null, 3, '按钮:数据源修改', '0', 'Y', 2, 0),

  293.                (21030400, 21030000, '7a4d22dd4a1a4a51818408d516ca6b04', '数据源修改状态', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:es', null, 4, '按钮:数据源修改状态', '0', 'Y', 2, 0),

  294.                (21030500, 21030000, '6d55a92a567c423cb6efc7dcba120821', '数据源删除', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:delete', null, 5, '按钮:数据源删除', '0', 'Y', 2, 0),

  295.                (21030600, 21030000, 'c06e8f136c704ca686527d9f1ad6b983', '数据源导入', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:import', null, 6, '按钮:数据源导入', '0', 'Y', 2, 0),

  296.                (21030700, 21030000, '0ce47238e4794f709985a0f8505756a7', '数据源导出', 3, '0,21000000,21030000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'tenant:source:export', null, 7, '按钮:数据源导出', '0', 'Y', 2, 0),

  297.        (22000000, 0, 'fe8bad86fdf34ed7ab584887e1e0f786', '系统管理', 1, '0', 'system', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:key-outlined', 8, '目录:系统管理', '0', 'Y', 2, 0),

  298.            (22010000, 22000000, 'b08569b9c6044608913cae26f427f842', '字典管理', 2, '0,22000000', 'dictType', null, 'tenant/dict/dictType/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'dict:dict:list', 'ant-design:file-text-outlined', 1, '菜单:字典管理', '0', 'Y', 2, 0),

  299.                (22010100, 22010000, 'bf7ca66a708f4ee88d5e58df65b558fb', '字典详情', 3, '0,22000000,22010000', 'dictTypeDetail/:id', null, 'tenant/dict/dictType/DictTypeDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'dict:dict:single', null, 1, '详情:字典详情', '0', 'Y', 2, 0),

  300.                (22010200, 22010000, '71b7dcc4d4a74f5fb78b1d4457c6829e', '字典新增', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:add', null, 2, '按钮:字典新增', '0', 'Y', 2, 0),

  301.                (22010300, 22010000, '72f4012cdc744c048367c50de2bf603b', '字典数据', 3, '0,22000000,22010000', 'dictDataDetail/:code', null, 'tenant/dict/dictData/index', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 1, null, 'dict:dict:dict', null, 3, '按钮:字典数据', '0', 'Y', 2, 0),

  302.                (22010400, 22010000, '2df41ed5aed44909ab4ea3f66ea5f4d4', '字典修改', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:edit', null, 4, '按钮:字典修改', '0', 'Y', 2, 0),

  303.                (22010500, 22010000, 'bfa0a7b8d5be4189acf8933b4dd9bf94', '字典修改状态', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:es', null, 5, '按钮:字典修改状态', '0', 'Y', 2, 0),

  304.                (22010600, 22010000, '8808bad6108546439e560ead38715aba', '字典删除', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:delete', null, 6, '按钮:字典删除', '0', 'Y', 2, 0),

  305.                (22010700, 22010000, 'ab20e0bfafc441fc90409e1096d3eebd', '字典导入', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:import', null, 7, '按钮:字典导入', '0', 'Y', 2, 0),

  306.                (22010800, 22010000, 'e50e7bbf131f413ebf0c4ec09cfa3b70', '字典导出', 3, '0,22000000,22010000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:dict:export', null, 8, '按钮:字典导出', '0', 'Y', 2, 0),

  307.            (22020000, 22000000, '71c9c40055b44052a27c5b3775c42054', '参数管理', 2, '0,22000000', 'config', null, 'tenant/dict/config/index', null, null, 'N', 'N', 'N', 'N', '0', 'C', '0', '0', '0', '0', '0', 1, null, 'dict:config:list', 'ant-design:function-outlined', 2, '菜单:参数管理', '0', 'Y', 2, 0),

  308.                (22020100, 22020000, '9fdfef2871974adcb8dcd546af0f4aa2', '参数详情', 3, '0,22000000,22020000', 'configDetail/:id', null, 'tenant/dict/config/ConfigDetail', null, null, 'N', 'Y', 'N', 'N', '0', 'X', '0', '1', '0', '0', '0', 5, null, 'dict:config:single', null, 1, '详情:参数详情', '0', 'Y', 2, 0),

  309.                (22020200, 22020000, '504ce298004f4a7fa93794ea974500cf', '参数新增', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:add', null, 2, '按钮:参数新增', '0', 'Y', 2, 0),

  310.                (22020300, 22020000, 'aa46bd42a43b4921afa392107b062749', '参数修改', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:edit', null, 3, '按钮:参数修改', '0', 'Y', 2, 0),

  311.                (22020400, 22020000, '25c63be4b66e4b05b40c7393ac773fd3', '参数删除', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:delete', null, 4, '按钮:参数删除', '0', 'Y', 2, 0),

  312.                (22020500, 22020000, '0f86293fc6904e26bc22410611faaad5', '参数强制删除', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:delForce', null, 5, '按钮:参数强制删除', '0', 'Y', 2, 0),

  313.                (22020600, 22020000, 'b03f82fb6e1148329c03816a1a892b32', '参数导入', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:import', null, 6, '按钮:参数导入', '0', 'Y', 2, 0),

  314.                (22020700, 22020000, '72db9651b40e4bd6bc6ff5e3f6dcc1d1', '参数导出', 3, '0,22000000,22020000', null, null, null, null, null, 'N', 'N', 'N', 'N', '0', 'F', '0', '0', '0', '0', '0', 1, null, 'dict:config:export', null, 7, '按钮:参数导出', '0', 'Y', 2, 0),

  315.        (24000000, 0, 'e24afc855afc485d96135999811', '系统监控', 1, '0', 'monitor', null, '', null, null, 'N', 'N', 'N', 'N', '0', 'M', '0', '0', '0', '0', '0', 1, null, '', 'ant-design:eye-outlined', 9, '目录:系统监控', '0', 'Y', 2, 0),

  316.            (24010000, 24000000, '8fa8a4e494594496a89635028483d28b', '流量监控', 2, '0,24000000', 'sentinel', 'http://123.57.75.177:8718', null, null, null, 'N', 'N', 'N', 'N', '1', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:sentinel:list', 'ant-design:fund-projection-screen-outlined', 1, '菜单:流量监控', '0', 'Y', 2, 0),

  317.            (24020000, 24000000, '8fa8a4e494594496a865a6428483d28b', '服务治理', 2, '0,24000000', 'nacos', 'http://123.57.75.177:18848/nacos', null, null, null, 'N', 'N', 'N', 'N', '1', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:nacos:list', 'ant-design:control-outlined', 2, '菜单:服务治理', '0', 'Y', 2, 0),

  318.            (24030000, 24000000, '8fa8a4e494594496a32586534583d28b', '服务监控', 2, '0,24000000', 'server', 'http://123.57.75.177:9100/login', null, null, null, 'N', 'N', 'N', 'N', '1', 'C', '0', '0', '0', '0', '0', 1, null, 'monitor:server:list', 'ant-design:radar-chart-outlined', 3, '菜单:服务监控', '0', 'Y', 2, 0);

  319. 

  320. -- ----------------------------

  321. -- 8、字典类型表

  322. -- ----------------------------

  323. drop table if exists sys_dict_type;

  324. create table sys_dict_type (

  325.   id                        bigint              not null                                comment '字典主键',

  326.   name                      varchar(100)        default ''                              comment '字典名称',

  327.   code                      varchar(100)        default ''                              comment '字典类型',

  328.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  329.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  330.   remark                    varchar(200)        default null                            comment '备注',

  331.   create_by                 bigint              default null                            comment '创建者',

  332.   create_time               datetime            default current_timestamp               comment '创建时间',

  333.   update_by                 bigint              default null                            comment '更新者',

  334.   update_time               datetime            on update current_timestamp             comment '更新时间',

  335.   primary key (id)

  336. ) engine = innodb comment = '字典类型表';

  337. 

  338. insert into sys_dict_type (id, name, code, remark)

  339. values (10001, '用户性别', 'sys_user_sex', '用户性别列表'),

  340.        (10002, '常规：显隐', 'sys_show_hide', '常规：显隐列表'),

  341.        (10003, '常规：公共私有', 'sys_common_private', '常规：公共私有列表'),

  342.        (10004, '系统开关', 'sys_normal_disable', '系统开关列表'),

  343.        (10005, '任务状态', 'sys_job_status', '任务状态列表'),

  344.        (10006, '任务策略', 'sys_job_policy', '任务策略列表'),

  345.        (10007, '任务并发', 'sys_job_concurrent', '任务并发列表'),

  346.        (10008, '任务分组', 'sys_job_group', '任务分组列表'),

  347.        (10009, '常规-是否', 'sys_yes_no', '常规：是否列表'),

  348.        (10010, '通知类型', 'sys_notice_type', '通知：类型列表'),

  349.        (10011, '通知状态', 'sys_notice_status', '通知：状态列表'),

  350.        (10012, '日志：操作类型', 'sys_operate_business', '日志：操作类型列表'),

  351.        (10013, '日志：操作类别', 'sys_operate_type', '日志：操作类别列表'),

  352.        (10014, '日志：操作状态', 'sys_operate_status', '日志：操作状态列表'),

  353.        (10015, '状态：成功失败', 'sys_message_status', '状态：成功失败列表'),

  354.        (10016, '字典：颜色', 'sys_dict_color', '字典：颜色列表'),

  355.        (10017, '授权类型', 'sys_grant_type', '授权类型列表'),

  356.        (10018, '权限：页面类型', 'auth_frame_type', '权限：页面类型列表'),

  357.        (10019, '权限：菜单类型', 'auth_menu_type', '权限：菜单类型列表'),

  358.        (10020, '权限：数据范围', 'auth_data_scope', '权限：数据范围列表'),

  359.        (10021, '读写类型', 'sys_source_type', '读写类型列表'),

  360.        (10022, '数据源类型', 'sys_database_type', '数据源类型列表'),

  361.        (10023, '配置类型', 'te_configuration_type', '配置类型列表'),

  362.        (10024, '代码生成：模板类型', 'gen_template_type', '代码生成：模板类型列表'),

  363.        (10025, '代码生成：属性类型', 'gen_java_type', '代码生成：属性类型列表'),

  364.        (10026, '代码生成：查询类型', 'gen_query_type', '代码生成：查询类型列表'),

  365.        (10027, '代码生成：显示类型', 'gen_display_type', '代码生成：显示类型列表'),

  366.        (10028, '代码生成：生成方式', 'gen_generation_mode', '代码生成：生成方式列表'),

  367.        (10029, '代码生成：源策略模式', 'gen_source_mode', '代码生成：源策略模式列表');

  368. 

  369. -- ----------------------------

  370. -- 9、字典数据表

  371. -- ----------------------------

  372. drop table if exists sys_dict_data;

  373. create table sys_dict_data (

  374.   id                        bigint              not null                                comment '数据Id',

  375.   code                      varchar(100)        default ''                              comment '字典编码',

  376.   value                     varchar(100)        default ''                              comment '数据键值',

  377.   label                     varchar(100)        default ''                              comment '数据标签',

  378.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  379.   is_default                char(1)             default 'N'                             comment '是否默认（Y是 N否）',

  380.   css_class                 varchar(100)        default null                            comment '样式属性（其他样式扩展）',

  381.   list_class                varchar(100)        default null                            comment '表格回显样式',

  382.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  383.   remark                    varchar(200)        default null                            comment '备注',

  384.   create_by                 bigint              default null                            comment '创建者',

  385.   create_time               datetime            default current_timestamp               comment '创建时间',

  386.   update_by                 bigint              default null                            comment '更新者',

  387.   update_time               datetime            on update current_timestamp             comment '更新时间',

  388.   primary key (id)

  389. ) engine = innodb comment = '字典数据表';

  390. 

  391. insert into sys_dict_data (id, sort, label, value, code, css_class, list_class, is_default, remark)

  392. values (1000101, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '性别男'),

  393.        (1000102, 2, '女', '1', 'sys_user_sex', '', '', 'N', '性别女'),

  394.        (1000103, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '性别未知'),

  395.        (1000201, 1, '显示', '0', 'sys_show_hide', '', 'blue', 'Y', '常规-显隐：显示'),

  396.        (1000202, 2, '隐藏', '1', 'sys_show_hide', '', 'red', 'N', '常规-显隐：隐藏'),

  397.        (1000301, 1, '公共', '0', 'sys_common_private', '', 'cyan', 'N', '常规-公共私有：公共'),

  398.        (1000302, 2, '私有', '1', 'sys_common_private', '', 'purple', 'N', '常规-公共私有：私有'),

  399.        (1000401, 1, '正常', '0', 'sys_normal_disable', '', 'blue', 'Y', '正常状态'),

  400.        (1000402, 2, '停用', '1', 'sys_normal_disable', '', 'red', 'N', '停用状态'),

  401.        (1000501, 1, '正常', '0', 'sys_job_status', '', 'blue', 'Y', '正常状态'),

  402.        (1000502, 2, '暂停', '1', 'sys_job_status', '', 'red', 'N', '停用状态'),

  403.        (1000601, 1, '默认', '0', 'sys_job_policy', '', 'blue', 'N', '任务策略：默认'),

  404.        (1000602, 2, '立即执行', '1', 'sys_job_policy', '', 'green', 'N', '任务策略：立即执行'),

  405.        (1000603, 3, '执行一次', '2', 'sys_job_policy', '', 'cyan', 'N', '任务策略：执行一次'),

  406.        (1000604, 4, '放弃执行', '3', 'sys_job_policy', '', 'purple', 'N', '任务策略：放弃执行'),

  407.        (1000701, 1, '允许', '0', 'sys_job_concurrent', '', 'blue', 'N', '任务并发：允许'),

  408.        (1000702, 2, '禁止', '1', 'sys_job_concurrent', '', 'red', 'N', '任务并发：禁止'),

  409.        (1000801, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '默认分组'),

  410.        (1000802, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '系统分组'),

  411.        (1000901, 1, '是', 'Y', 'sys_yes_no', '', 'blue', 'Y', '常规-是否：是'),

  412.        (1000902, 2, '否', 'N', 'sys_yes_no', '', 'red', 'N', '常规-是否：否'),

  413.        (1001001, 1, '通知', '0', 'sys_notice_type', '', 'blue', 'Y', '通知'),

  414.        (1001002, 2, '公告', '1', 'sys_notice_type', '', 'green', 'N', '公告'),

  415.        (1001101, 1, '待发送', '0', 'sys_notice_status', '', 'blue', 'Y', '待发送'),

  416.        (1001102, 2, '已发送', '1', 'sys_notice_status', '', 'green', 'N', '已发送'),

  417.        (1001103, 3, '已关闭', '2', 'sys_notice_status', '', 'cyan', 'N', '已关闭'),

  418.        (1001104, 4, '发送失败', '3', 'sys_notice_status', '', 'orange', 'N', '发送失败'),

  419.        (1001105, 5, '发送异常', '4', 'sys_notice_status', '', 'red', 'N', '发送异常'),

  420.        (1001201, 1, '其它', '00', 'sys_operate_business', '', 'orange', 'N', '操作类型：其它'),

  421.        (1001202, 2, '新增', '01', 'sys_operate_business', '', 'blue', 'N', '操作类型：新增'),

  422.        (1001203, 3, '强制新增', '02', 'sys_operate_business', '', 'red', 'N', '操作类型：强制新增'),

  423.        (1001204, 4, '修改', '03', 'sys_operate_business', '', 'green', 'N', '操作类型：修改'),

  424.        (1001205, 5, '强制修改', '04', 'sys_operate_business', '', 'red', 'N', '操作类型：强制修改'),

  425.        (1001206, 6, '权限控制', '05', 'sys_operate_business', '', 'purple', 'N', '操作类型：权限控制'),

  426.        (1001207, 7, '修改状态', '06', 'sys_operate_business', '', 'purple', 'N', '操作类型：修改状态'),

  427.        (1001208, 8, '强制修改状态', '07', 'sys_operate_business', '', 'red', 'N', '操作类型：强制修改状态'),

  428.        (1001209, 9, '删除', '08', 'sys_operate_business', '', 'orange', 'N', '操作类型：删除'),

  429.        (1001210, 10, '强制删除', '09', 'sys_operate_business', '', 'red', 'N', '操作类型：强制删除'),

  430.        (1001211, 11, '授权', '10', 'sys_operate_business', '', 'orange', 'N', '操作类型：授权'),

  431.        (1001212, 12, '导出', '11', 'sys_operate_business', '', 'pink', 'N', '操作类型：导出'),

  432.        (1001213, 13, '导入', '12', 'sys_operate_business', '', 'cyan', 'N', '操作类型：导入'),

  433.        (1001214, 14, '强退', '13', 'sys_operate_business', '', 'orange', 'N', '操作类型：强退'),

  434.        (1001215, 15, '生成代码', '14', 'sys_operate_business', '', 'orange', 'N', '操作类型：生成代码'),

  435.        (1001216, 16, '清空数据', '15', 'sys_operate_business', '', 'orange', 'N', '操作类型：清空数据'),

  436.        (1001217, 17, '更新缓存', '16', 'sys_operate_business', '', 'orange', 'N', '操作类型：更新缓存'),

  437.        (1001301, 1, '其它', '00', 'sys_operate_type', '', 'green', 'N', '操作类别：其它'),

  438.        (1001302, 2, '后台用户', '01', 'sys_operate_type', '', 'blue', 'N', '操作类别：后台用户'),

  439.        (1001303, 3, '手机端用户', '02', 'sys_operate_type', '', 'red', 'N', '操作类别：手机端用户'),

  440.        (1001401, 1, '正常', '0', 'sys_operate_status', '', 'green', 'N', '操作状态：正常'),

  441.        (1001402, 2, '异常', '1', 'sys_operate_status', '', 'red', 'N', '操作状态：异常'),

  442.        (1001501, 1, '成功', '0', 'sys_message_status', '', 'blue', 'N', '状态：成功'),

  443.        (1001502, 2, '失败', '1', 'sys_message_status', '', 'red', 'N', '状态：失败'),

  444.        (1001601, 1, 'none', '', 'sys_dict_color', '', '', 'N', '字典颜色：none'),

  445.        (1001602, 2, 'red', 'red', 'sys_dict_color', '', 'red', 'N', '字典颜色：red'),

  446.        (1001603, 3, 'pink', 'pink', 'sys_dict_color', '', 'pink', 'N', '字典颜色：pink'),

  447.        (1001604, 4, 'orange', 'orange', 'sys_dict_color', '', 'orange', 'N', '字典颜色：orange'),

  448.        (1001605, 5, 'green', 'green', 'sys_dict_color', '', 'green', 'N', '字典颜色：green'),

  449.        (1001606, 6, 'blue', 'blue', 'sys_dict_color', '', 'blue', 'N', '字典颜色：blue'),

  450.        (1001607, 7, 'purple', 'purple', 'sys_dict_color', '', 'purple', 'N', '字典颜色：purple'),

  451.        (1001608, 8, 'cyan', 'cyan', 'sys_dict_color', '', 'cyan', 'N', '字典颜色：cyan'),

  452.        (1001701, 1, '授权码模式', 'authorization_code', 'sys_grant_type', '', '', 'N', '授权码模式'),

  453.        (1001702, 2, '密码模式', 'password', 'sys_grant_type', '', '', 'N', '密码模式'),

  454.        (1001703, 3, '客户端模式', 'client_credentials', 'sys_grant_type', '', '', 'N', '客户端模式'),

  455.        (1001704, 4, '简化模式', 'implicit', 'sys_grant_type', '', '', 'N', '简化模式'),

  456.        (1001705, 5, '刷新模式', 'refresh_token', 'sys_grant_type', '', '', 'N', '刷新模式'),

  457.        (1001801, 1, '常规', '0', 'auth_frame_type', '', 'pink', 'Y', '权限-页面类型：常规'),

  458.        (1001802, 2, '内嵌', '1', 'auth_frame_type', '', 'cyan', 'N', '权限-页面类型：内嵌'),

  459.        (1001803, 3, '外链', '2', 'auth_frame_type', '', 'green', 'N', '权限-页面类型：外链'),

  460.        (1001901, 1, '目录', 'M', 'auth_menu_type', '', 'pink', 'Y', '权限-菜单类型：目录'),

  461.        (1001902, 2, '菜单', 'C', 'auth_menu_type', '', 'cyan', 'N', '权限-菜单类型：菜单'),

  462.        (1001903, 3, '详情', 'X', 'auth_menu_type', '', 'purple', 'N', '权限-菜单类型：详情'),

  463.        (1001904, 4, '按钮', 'F', 'auth_menu_type', '', 'green', 'N', '权限-菜单类型：按钮'),

  464.        (1002001, 1, '全部数据权限', '1', 'auth_data_scope', '', '', 'Y', '权限-数据范围：全部数据权限'),

  465.        (1002002, 2, '自定数据权限', '2', 'auth_data_scope', '', '', 'N', '权限-数据范围：自定数据权限'),

  466.        (1002003, 3, '本部门数据权限', '3', 'auth_data_scope', '', '', 'N', '权限-数据范围：本部门数据权限'),

  467.        (1002004, 4, '本部门及以下数据权限', '4', 'auth_data_scope', '', '', 'N', '权限-数据范围：本部门及以下数据权限'),

  468.        (1002005, 5, '本岗位数据权限', '5', 'auth_data_scope', '', '', 'N', '权限-数据范围：本岗位数据权限'),

  469.        (1002006, 6, '仅本人数据权限', '6', 'auth_data_scope', '', '', 'N', '权限-数据范围：仅本人数据权限'),

  470.        (1002101, 1, '读&写', '0', 'sys_source_type', '', 'blue', 'Y', '读&写'),

  471.        (1002102, 2, '只读', '1', 'sys_source_type', '', 'green', 'N', '只读'),

  472.        (1002103, 3, '只写', '2', 'sys_source_type', '', 'red', 'N', '只写'),

  473.        (1002201, 1, '子数据源', '0', 'sys_database_type', '', 'green', 'Y', '子数据源'),

  474.        (1002202, 2, '主数据源', '1', 'sys_database_type', '', 'red', 'N', '主数据源'),

  475.        (1002301, 1, '自动配置', '0', 'te_configuration_type', '', '', 'N', '配置类型：自动配置'),

  476.        (1002302, 2, '手动配置', '1', 'te_configuration_type', '', '', 'N', '配置类型：手动配置'),

  477.        (1002401, 1, '单表', 'base', 'gen_template_type', '', '', 'Y', '代码生成-模板类型：单表'),

  478.        (1002402, 2, '树表', 'tree', 'gen_template_type', '', '', 'N', '代码生成-模板类型：树表'),

  479.        (1002403, 3, '关联表', 'merge', 'gen_template_type', '', '', 'N', '代码生成-模板类型：关联表'),

  480.        (1002501, 1, 'Long', 'Long', 'gen_java_type', '', '', 'N', '代码生成-属性类型：Long'),

  481.        (1002502, 2, 'String', 'String', 'gen_java_type', '', '', 'N', '代码生成-属性类型：String'),

  482.        (1002503, 3, 'Integer', 'Integer', 'gen_java_type', '', '', 'N', '代码生成-属性类型：Integer'),

  483.        (1002504, 4, 'Double', 'Double', 'gen_java_type', '', '', 'N', '代码生成-属性类型：Double'),

  484.        (1002505, 5, 'BigDecimal', 'BigDecimal', 'gen_java_type', '', '', 'N', '代码生成-属性类型：BigDecimal'),

  485.        (1002506, 6, 'LocalDateTime', 'LocalDateTime', 'gen_java_type', '', '', 'N', '代码生成-属性类型：LocalDateTime'),

  486.        (1002601, 1, '=', 'eq', 'gen_query_type', '', '', 'Y', '代码生成-查询类型：='),

  487.        (1002602, 2, '!=', 'ne', 'gen_query_type', '', '', 'N', '代码生成-查询类型：!='),

  488.        (1002603, 3, '>', 'gt', 'gen_query_type', '', '', 'N', '代码生成-查询类型：>'),

  489.        (1002604, 4, '>=', 'ge', 'gen_query_type', '', '', 'N', '代码生成-查询类型：>='),

  490.        (1002605, 5, '<', 'lt', 'gen_query_type', '', '', 'N', '代码生成-查询类型：<'),

  491.        (1002606, 6, '<=', 'le', 'gen_query_type', '', '', 'N', '代码生成-查询类型：<='),

  492.        (1002607, 7, 'LIKE', 'like', 'gen_query_type', '', '', 'N', '代码生成-查询类型：LIKE'),

  493.        (1002608, 8, 'NOT_LIKE', 'notLike', 'gen_query_type', '', '', 'N', '代码生成-查询类型：NOT_LIKE'),

  494.        (1002609, 9, 'LIKE_LEFT', 'likeLeft', 'gen_query_type', '', '', 'N', '代码生成-查询类型：LIKE_LEFT'),

  495.        (1002610, 10, 'LIKE_RIGHT', 'likeRight', 'gen_query_type', '', '', 'N', '代码生成-查询类型：LIKE_RIGHT'),

  496.        (1002611, 11, 'BETWEEN', 'between', 'gen_query_type', '', '', 'N', '代码生成-查询类型：BETWEEN'),

  497.        (1002612, 12, 'NOT_BETWEEN', 'notBetween', 'gen_query_type', '', '', 'N', '代码生成-查询类型：NOT_BETWEEN'),

  498.        (1002613, 13, 'ISNULL', 'isNull', 'gen_query_type', '', '', 'N', '代码生成-查询类型：ISNULL'),

  499.        (1002614, 14, 'IS_NOT_NULL', 'isNotNull', 'gen_query_type', '', '', 'N', '代码生成-查询类型：IS_NOT_NULL'),

  500.        (1002701, 1, '文本框', 'Input', 'gen_display_type', '', '', 'Y', '代码生成-显示类型：文本框'),

  501.        (1002702, 2, '密码框', 'InputPassword', 'gen_display_type', '', '', 'Y', '代码生成-显示类型：密码框'),

  502.        (1002703, 3, '数字输入框', 'InputNumber', 'gen_display_type', '', '', 'Y', '代码生成-显示类型：数字输入框'),

  503.        (1002704, 4, '文本域', 'InputTextArea', 'gen_display_type', '', '', 'N', '代码生成-显示类型：文本域'),

  504.        (1002705, 5, '下拉框', 'Select', 'gen_display_type', '', '', 'N', '代码生成-显示类型：下拉框'),

  505.        (1002706, 6, '单选框', 'CheckboxGroup', 'gen_display_type', '', '', 'N', '代码生成-显示类型：单选框'),

  506.        (1002707, 7, '按钮风格单选框', 'RadioButtonGroup', 'gen_display_type', '', '', 'N', '代码生成-显示类型：按钮风格单选框'),

  507.        (1002708, 8, '复选框', 'RadioGroup', 'gen_display_type', '', '', 'N', '代码生成-显示类型：复选框'),

  508.        (1002709, 9, '日期控件', 'DatePicker', 'gen_display_type', '', '', 'N', '代码生成-显示类型：日期控件'),

  509.        (1002710, 10, '时间控件', 'TimePicker', 'gen_display_type', '', '', 'N', '代码生成-显示类型：时间控件'),

  510.        (1002711, 11, '图片上传', 'ImageUpload', 'gen_display_type', '', '', 'N', '代码生成-显示类型：图片上传'),

  511.        (1002712, 12, '文件上传', 'Upload', 'gen_display_type', '', '', 'N', '代码生成-显示类型：文件上传'),

  512.        (1002713, 13, '富文本控件', 'tinymce', 'gen_display_type', '', '', 'N', '代码生成-显示类型：富文本控件'),

  513.        (1002714, 14, 'MarkDown编辑器控件', 'markdown', 'gen_display_type', '', '', 'N', '代码生成-显示类型：MarkDown编辑器控件'),

  514.        (1002801, 1, 'zip压缩包', '0', 'gen_generation_mode', '', '', 'Y', '代码生成-生成方式：zip压缩包'),

  515.        (1002802, 2, '自定义路径', '1', 'gen_generation_mode', '', '', 'N', '代码生成-生成方式：自定义路径'),

  516.        (1002901, 1, '策略源', 'Isolate', 'gen_source_mode', '', '', 'Y', '代码生成-源策略模式：策略源'),

  517.        (1002902, 2, '主数据源', 'Master', 'gen_source_mode', '', '', 'N', '代码生成-源策略模式：主数据源');

  518. 

  519. -- ----------------------------

  520. -- 10、参数配置表

  521. -- ----------------------------

  522. drop table if exists sys_config;

  523. create table sys_config (

  524.   id                        bigint              not null                                comment '参数Id',

  525.   name                      varchar(100)        default ''                              comment '参数名称',

  526.   code                      varchar(100)        default ''                              comment '参数编码',

  527.   value                     varchar(100)        default ''                              comment '参数键值',

  528.   type                      char(1)             default 'N'                             comment '系统内置（Y是 N否）',

  529.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  530.   remark                    varchar(200)        default null                            comment '备注',

  531.   create_by                 bigint              default null                            comment '创建者',

  532.   create_time               datetime            default current_timestamp               comment '创建时间',

  533.   update_by                 bigint              default null                            comment '更新者',

  534.   update_time               datetime            on update current_timestamp             comment '更新时间',

  535.   primary key (id)

  536. ) engine = innodb comment = '参数配置表';

  537. 

  538. insert into sys_config (id, name, code, value, type, remark)

  539. values (1, '主框架页-默认皮肤样式名称',           'sys.index.skinName',               'skin-blue',       'Y',    '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),

  540.        (2, '用户管理-账号初始密码',              'sys.user.initPassword',            '123456',          'Y',    '初始化密码 123456'),

  541.        (3, '主框架页-侧边栏主题',                'sys.index.sideTheme',              'theme-dark',      'Y',    '深色主题theme-dark，浅色主题theme-light'),

  542.        (4, '账号自助-是否开启租户注册功能',        'sys.account.registerTenant',       'false',           'Y',    '是否开启注册租户功能（true开启，false关闭）');

  543. 

  544. -- ----------------------------

  545. -- 11、定时任务调度表

  546. -- ----------------------------

  547. drop table if exists sys_job;

  548. create table sys_job (

  549.   id                        bigint              not null                                comment '任务Id',

  550.   name                      varchar(64)         default ''                              comment '任务名称',

  551.   job_group                 varchar(64)         default 'DEFAULT'                       comment '任务组名',

  552.   invoke_target             varchar(500)        not null                                comment '调用目标字符串',

  553.   invoke_tenant             varchar(500)        not null                                comment '调用租户字符串',

  554.   cron_expression           varchar(255)        default ''                              comment 'cron执行表达式',

  555.   misfire_policy            varchar(20)         default '3'                             comment '计划执行错误策略（0默认 1立即执行 2执行一次 3放弃执行）',

  556.   concurrent                char(1)             default '1'                             comment '是否并发执行（0允许 1禁止）',

  557.   status                    char(1)             not null default '0'                    comment '状态（0正常 1暂停）',

  558.   remark                    varchar(200)        default null                            comment '备注',

  559.   create_by                 bigint              default null                            comment '创建者',

  560.   create_time               datetime            default current_timestamp               comment '创建时间',

  561.   update_by                 bigint              default null                            comment '更新者',

  562.   update_time               datetime            on update current_timestamp             comment '更新时间',

  563.   del_flag		            tinyint             not null default 0                      comment '删除标志(0正常 1删除)',

  564.   tenant_id		            bigint	            not null                                comment '租户Id',

  565.   primary key (id)

  566. ) engine = innodb auto_increment = 100 comment = '定时任务调度表';

  567. 

  568. insert into sys_job (id, name, job_group, invoke_target, invoke_tenant, cron_expression, misfire_policy, concurrent, status, tenant_id)

  569. values (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams',   '1L, \'Y\', \'slave\'',     '0/10 * * * * ?', '3', '1', '1', 1),

  570.        (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')',   '1L, \'Y\', \'slave\'',  '0/15 * * * * ?', '3', '1', '1', 1),

  571.        (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)',   '1L, \'Y\', \'slave\'',  '0/20 * * * * ?', '3', '1', '1', 1);

  572. 

  573. -- ----------------------------

  574. -- 12、定时任务调度日志表

  575. -- ----------------------------

  576. drop table if exists sys_job_log;

  577. create table sys_job_log (

  578.   id                        bigint              not null auto_increment                 comment '任务日志Id',

  579.   job_id                    bigint              not null                                comment '任务Id',

  580.   name                      varchar(64)         not null                                comment '任务名称',

  581.   job_group                 varchar(64)         not null                                comment '任务组名',

  582.   invoke_target             varchar(500)        not null                                comment '调用目标字符串',

  583.   invoke_tenant             varchar(500)        not null                                comment '调用租户字符串',

  584.   job_message               varchar(500)                                                comment '日志信息',

  585.   status                    char(1)             not null default '0'                    comment '执行状态（0正常 1失败）',

  586.   exception_info            varchar(2000)       default ''                              comment '异常信息',

  587.   create_time               datetime            default current_timestamp               comment '创建时间',

  588.   del_time                  datetime            on update current_timestamp             comment '删除时间',

  589.   del_flag		            tinyint             not null default 0                      comment '删除标志(0正常 1删除)',

  590.   tenant_id		            bigint	            not null                                comment '租户Id',

  591.   primary key (id)

  592. ) engine = innodb comment = '定时任务调度日志表';

  593. 

  594. -- ----------------------------

  595. -- 13、文件信息表

  596. -- ----------------------------

  597. drop table if exists sys_file;

  598. create table sys_file (

  599.   id		                bigint	            not null                                comment '文件Id',

  600.   folder_id		            bigint	            not null default 0	                    comment '分类Id',

  601.   name		                varchar(100)	    not null	                            comment '文件名称',

  602.   nick	                    varchar(100)	    default null	                        comment '文件别名',

  603.   url		                varchar(500)	    not null 	                            comment '文件地址',

  604.   size		                decimal(8,4)	    not null 	                            comment '文件大小',

  605.   type		                char(1)	            not null default '0'	                comment '文件类型（0默认 1系统）',

  606.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  607.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  608.   create_by                 bigint              default null                            comment '创建者',

  609.   create_time               datetime            default current_timestamp               comment '创建时间',

  610.   update_by                 bigint              default null                            comment '更新者',

  611.   update_time               datetime            on update current_timestamp             comment '更新时间',

  612.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  613.   tenant_id		            bigint	            not null                                comment '租户Id',

  614.   primary key (id)

  615. ) engine = innodb comment = '文件信息表';

  616. 

  617. -- ----------------------------

  618. -- 14、文件分类信息表

  619. -- ----------------------------

  620. drop table if exists sys_file_folder;

  621. create table sys_file_folder (

  622.   id		                bigint	            not null                                comment '分类Id',

  623.   parent_id		            bigint	            not null default 0                      comment '父分类Id',

  624.   name		                varchar(100)	    not null	                            comment '分类名称',

  625.   level                     int                 not null                                comment '树层级',

  626.   ancestors                 varchar(500)        default ''                              comment '祖级列表',

  627.   type		                char(1)	            not null default '0'	                comment '分类类型（0默认文件夹 1系统文件夹）',

  628.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  629.   status                    char(1)             not null default '0'                    comment '状态（0正常 1停用）',

  630.   create_by                 bigint              default null                            comment '创建者',

  631.   create_time               datetime            default current_timestamp               comment '创建时间',

  632.   update_by                 bigint              default null                            comment '更新者',

  633.   update_time               datetime            on update current_timestamp             comment '更新时间',

  634.   del_flag		            tinyint             not null default 0                      comment '删除标志（0正常 1删除）',

  635.   tenant_id		            bigint	            not null                                comment '租户Id',

  636.   primary key (id)

  637. ) engine = innodb comment = '文件分类信息表';

  638. 

  639. -- ----------------------------

  640. -- 15、代码生成业务表

  641. -- ----------------------------

  642. drop table if exists gen_table;

  643. create table gen_table (

  644.   id                        bigint              not null auto_increment                 comment '表Id',

  645.   name                      varchar(200)        default ''                              comment '表名称',

  646.   comment                   varchar(200)        default ''                              comment '表描述',

  647.   class_name                varchar(50)         default ''                              comment '实体类名称',

  648.   prefix                    varchar(50)         default ''                              comment '前缀名称',

  649.   tpl_category              varchar(10)         not null default 'base'                 comment '使用的模板（base单表 tree树表 subBase主子单表 subTree主子树表 merge关联表）',

  650.   package_name              varchar(100)                                                comment '生成包路径',

  651.   authority_name            varchar(30)                                                 comment '生成权限名',

  652.   module_name               varchar(30)                                                 comment '生成模块名',

  653.   business_name             varchar(30)                                                 comment '生成业务名',

  654.   function_name             varchar(50)                                                 comment '生成功能名',

  655.   function_author           varchar(50)                                                 comment '生成功能作者',

  656.   gen_path                  varchar(200)        default '/'                             comment '后端生成路径（不填默认项目路径）',

  657.   ui_path                   varchar(200)        default '/'                             comment '前端生成路径（不填默认项目路径）',

  658.   options                   varchar(1000)                                               comment '其它生成选项',

  659.   remark                    varchar(200)        default null                            comment '备注',

  660.   create_by                 bigint              default null                            comment '创建者',

  661.   create_time               datetime            default current_timestamp               comment '创建时间',

  662.   update_by                 bigint              default null                            comment '更新者',

  663.   update_time               datetime            on update current_timestamp             comment '更新时间',

  664.   primary key (id)

  665. ) engine=innodb auto_increment=1 comment = '代码生成业务表';

  666. 

  667. -- ----------------------------

  668. -- 16、代码生成业务表字段

  669. -- ----------------------------

  670. drop table if exists gen_table_column;

  671. create table gen_table_column (

  672.   id                        bigint              not null auto_increment                 comment '字段Id',

  673.   table_id                  bigint              not null                                comment '表Id',

  674.   name                      varchar(100)                                                comment '列名称',

  675.   comment                   varchar(100)                                                comment '列描述',

  676.   type                      varchar(20)                                                 comment '列类型',

  677.   java_type                 varchar(20)                                                 comment 'JAVA类型',

  678.   java_field                varchar(100)                                                comment 'JAVA字段名',

  679.   is_pk                     tinyint(1)          not null default 0                      comment '主键字段（1是 0否）',

  680.   is_increment              tinyint(1)          not null default 0                      comment '自增字段（1是 0否）',

  681.   is_required               tinyint(1)          not null default 0                      comment '必填字段（1是 0否）',

  682.   is_view                   tinyint(1)          not null default 0                      comment '查看字段（1是 0否）',

  683.   is_insert                 tinyint(1)          not null default 0                      comment '新增字段（1是 0否）',

  684.   is_edit                   tinyint(1)          not null default 0                      comment '编辑字段（1是 0否）',

  685.   is_list                   tinyint(1)          not null default 0                      comment '列表字段（1是 0否）',

  686.   is_query                  tinyint(1)          not null default 0                      comment '查询字段（1是 0否）',

  687.   is_unique                 tinyint(1)          not null default 0                      comment '唯一字段（1是 0否）',

  688.   is_import                 tinyint(1)          not null default 0                      comment '导入字段（1是 0否）',

  689.   is_export                 tinyint(1)          not null default 0                      comment '导出字段（1是 0否）',

  690.   is_hide                   tinyint(1)          not null default 0                      comment '隐藏字段（1是 0否）',

  691.   is_cover                  tinyint(1)          not null default 0                      comment '覆盖字段（1是 0否）',

  692.   query_type                varchar(200)        default 'EQ'                            comment '查询方式（等于、不等于、大于、小于、范围）',

  693.   html_type                 varchar(200)                                                comment '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',

  694.   dict_type                 varchar(200)        default ''                              comment '字典类型',

  695.   sort                      int unsigned        not null default 0                      comment '显示顺序',

  696.   create_by                 bigint              default null                            comment '创建者',

  697.   create_time               datetime            default current_timestamp               comment '创建时间',

  698.   update_by                 bigint              default null                            comment '更新者',

  699.   update_time               datetime            on update current_timestamp             comment '更新时间',

  700.   primary key (id)

  701. ) engine=innodb auto_increment=1 comment = '代码生成业务表字段';