1643 lines
104 KiB
Transact-SQL
1643 lines
104 KiB
Transact-SQL
-- ----------------------------
|
||
-- 初始化-脚本数据(如果存在存储过程和函数等特殊类型，则新增一个sql文件为妥)
|
||
-- ----------------------------
|
||
|
||
|
||
|
||
--菜单表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_menu')
|
||
begin
|
||
create table sys_menu (
|
||
menu_id bigint identity (2000,1) not null , --菜单ID
|
||
menu_name varchar(50) not null , --菜单名称
|
||
parent_id bigint default 0 , --父菜单ID
|
||
order_num int default 0 , --显示顺序
|
||
path varchar(200) default '' , --路由地址
|
||
component varchar(255) default null , --组件路径
|
||
query varchar(255) default null , --路由参数
|
||
route_name varchar(50) default '' , --路由名称
|
||
is_frame int default 1 , --是否为外链（0是 1否）
|
||
is_cache int default 0 , --是否缓存（0缓存 1不缓存）
|
||
menu_type varchar(1) default '' , --菜单类型（M目录 C菜单 F按钮）
|
||
visible varchar(1) default 0 , --菜单状态（0显示 1隐藏）
|
||
status varchar(1) default 0 , --菜单状态（0正常 1停用）
|
||
perms varchar(100) default null , --权限标识
|
||
icon varchar(100) default '#' , --菜单图标
|
||
create_by varchar(64) default '' , --创建者
|
||
create_time datetime , --创建时间
|
||
update_by varchar(64) default '' , --更新者
|
||
update_time datetime , --更新时间
|
||
remark varchar(500) default '' , --备注
|
||
primary key (menu_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-菜单信息表数据
|
||
-- ----------------------------
|
||
|
||
SET IDENTITY_INSERT dbo.sys_menu ON
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, '系统管理', 0, 1, 'system', NULL, '', '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2025-05-05 11:40:48.75', '', NULL, '系统管理目录')
|
||
end
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '2')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2025-05-05 11:40:48.75', '', NULL, '系统监控目录')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '3')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2025-05-05 11:40:48.75', '', NULL, '系统工具目录')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '4')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (4, '若依官网', 0, 4, 'http://ruoyi.vip', NULL, '', '', 0, 0, 'M', '1', '0', '', 'guide', 'admin', '2025-05-05 11:40:48.75', '', NULL, '若依官网地址')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '100')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2025-05-05 11:40:48.75', '', NULL, '用户管理菜单')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '101')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2025-05-05 11:40:48.75', '', NULL, '角色管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '102')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2025-05-05 11:40:48.75', '', NULL, '菜单管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '103')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2025-05-05 11:40:48.75', '', NULL, '部门管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '104')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2025-05-05 11:40:48.75', '', NULL, '岗位管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '105')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2025-05-05 11:40:48.75', '', NULL, '字典管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '106')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2025-05-05 11:40:48.75', '', NULL, '参数设置菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '107')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2025-05-05 11:40:48.75', '', NULL, '通知公告菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '108')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (108, '日志管理', 1, 9, 'log', '', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2025-05-05 11:40:48.75', '', NULL, '日志管理菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '109')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2025-05-05 11:40:48.75', '', NULL, '在线用户菜单')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '110')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2025-05-05 11:40:48.75', '', NULL, '定时任务菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '111')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2025-05-05 11:40:48.75', '', NULL, '数据监控菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '112')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2025-05-05 11:40:48.75', '', NULL, '服务监控菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '113')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2025-05-05 11:40:48.75', '', NULL, '缓存监控菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '114')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2025-05-05 11:40:48.75', '', NULL, '缓存列表菜单')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '115')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2025-05-05 11:40:48.75', '', NULL, '表单构建菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '116')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2025-05-05 11:40:48.75', '', NULL, '代码生成菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '117')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2025-05-05 11:40:48.75', '', NULL, '系统接口菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '500')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2025-05-05 11:40:48.75', '', NULL, '操作日志菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '501')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2025-05-05 11:40:48.753', '', NULL, '登录日志菜单')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1000')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1000, '用户查询', 100, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1001')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1001, '用户新增', 100, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1002')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1002, '用户修改', 100, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1003')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1003, '用户删除', 100, 4, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1004')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1004, '用户导出', 100, 5, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1005')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1005, '用户导入', 100, 6, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1006')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1006, '重置密码', 100, 7, '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1007')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1007, '角色查询', 101, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1008')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1008, '角色新增', 101, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1009')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1009, '角色修改', 101, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1010')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1010, '角色删除', 101, 4, '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1011')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1011, '角色导出', 101, 5, '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1012')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1012, '菜单查询', 102, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1013')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1013, '菜单新增', 102, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1014')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1014, '菜单修改', 102, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1015')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1015, '菜单删除', 102, 4, '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1016')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1016, '部门查询', 103, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1017')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1017, '部门新增', 103, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1018')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1018, '部门修改', 103, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1019')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1019, '部门删除', 103, 4, '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1020')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1020, '岗位查询', 104, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1021')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1021, '岗位新增', 104, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1022')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1022, '岗位修改', 104, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1023')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1023, '岗位删除', 104, 4, '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1024')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1024, '岗位导出', 104, 5, '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1025')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1025, '字典查询', 105, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1026')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1026, '字典新增', 105, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1027')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1027, '字典修改', 105, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1028')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1028, '字典删除', 105, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1029')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1029, '字典导出', 105, 5, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1030')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1030, '参数查询', 106, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1031')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1031, '参数新增', 106, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1032')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1032, '参数修改', 106, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1033')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1033, '参数删除', 106, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1034')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1034, '参数导出', 106, 5, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1035')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1035, '公告查询', 107, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1036')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1036, '公告新增', 107, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1037')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1037, '公告修改', 107, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1038')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1038, '公告删除', 107, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1039')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1039, '操作查询', 500, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1040')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1040, '操作删除', 500, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1041')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1041, '日志导出', 500, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1041')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1042, '登录查询', 501, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1043')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1043, '登录删除', 501, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1044')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1044, '日志导出', 501, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1045')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1045, '账户解锁', 501, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1046')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1046, '在线查询', 109, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1047')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1047, '批量强退', 109, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2025-05-05 11:40:48.753', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1048')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1048, '单条强退', 109, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1049')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1049, '任务查询', 110, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1050')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1050, '任务新增', 110, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1051')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1051, '任务修改', 110, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1052')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1052, '任务删除', 110, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1053')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1053, '状态修改', 110, 5, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1054')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1054, '任务导出', 110, 6, '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1055')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1055, '生成查询', 116, 1, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1056')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1056, '生成修改', 116, 2, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1057')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1057, '生成删除', 116, 3, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1058')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1058, '导入代码', 116, 4, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1059')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1059, '预览代码', 116, 5, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '1060')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1060, '生成代码', 116, 6, '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2025-05-05 11:40:48.757', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_menu where menu_id = '2002')
|
||
begin
|
||
INSERT INTO dbo.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2002, '字典管理(blood)', 1, 10, 'comdict', 'liswork/dict/index', NULL, '', 1, 0, 'C', '0', '0', 'liswork:dict:list', 'dict', 'admin', '2025-05-09 11:01:23.03', 'admin', '2025-05-09 17:38:19.337', '')
|
||
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_menu OFF
|
||
|
||
|
||
|
||
--角色表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_role')
|
||
begin
|
||
create table sys_role (
|
||
role_id bigint identity(100,1) not null , --角色ID
|
||
role_name varchar(30) not null , --角色名称
|
||
role_key varchar(100) not null , --角色权限字符串
|
||
role_sort int not null , --显示顺序
|
||
data_scope varchar(1) default '1' , --数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）
|
||
menu_check_strictly int default 1 , --'菜单树选择项是否关联显示'
|
||
dept_check_strictly int default 1 , --'部门树选择项是否关联显示'
|
||
status varchar(1) not null , --角色状态（0正常 1停用）
|
||
del_flag varchar(1) default '0' , --删除标志（0代表存在 2代表删除）
|
||
create_by varchar(64) default '' , --创建者
|
||
create_time datetime , --创建时间
|
||
update_by varchar(64) default '' , --更新者
|
||
update_time datetime , --更新时间
|
||
remark varchar(500) default null , --备注
|
||
primary key (role_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-角色信息表数据
|
||
-- ----------------------------
|
||
SET IDENTITY_INSERT dbo.sys_role ON;
|
||
if not exists(select 1 from dbo.sys_role where role_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_role (role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2025-05-06 16:58:59.893', '', NULL, '超级管理员')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_role where role_id = '2')
|
||
begin
|
||
INSERT INTO dbo.sys_role (role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2025-05-06 16:58:59.893', 'admin', '2025-05-08 17:46:08.567', '普通角色')
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_role OFF;
|
||
|
||
|
||
--角色和菜单关联表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_role_menu')
|
||
begin
|
||
create table sys_role_menu (
|
||
role_id bigint not null , --角色ID
|
||
menu_id bigint not null , --菜单ID
|
||
primary key(role_id, menu_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-角色和菜单关联表数据
|
||
-- ----------------------------
|
||
|
||
|
||
|
||
--用户和角色关联表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_user_role')
|
||
begin
|
||
create table sys_user_role (
|
||
user_id bigint not null, --comment '用户ID'
|
||
role_id bigint not null, --comment '角色ID'
|
||
primary key(user_id, role_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-用户和角色关联表数据
|
||
-- ----------------------------
|
||
|
||
if not exists(select 1 from dbo.sys_user_role where user_id = '1' and role_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_user_role (user_id, role_id)
|
||
VALUES (1, 1)
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_user_role where user_id = '2' and role_id = '2')
|
||
begin
|
||
INSERT INTO dbo.sys_user_role (user_id, role_id)
|
||
VALUES (2, 2)
|
||
end
|
||
|
||
|
||
--操作日志表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_oper_log')
|
||
begin
|
||
create table sys_oper_log (
|
||
oper_id bigint identity(100,1) not null , --comment '日志主键',
|
||
title varchar(50) default '' , --comment '模块标题',
|
||
business_type int default 0 , --comment '业务类型（0其它 1新增 2修改 3删除）',
|
||
method varchar(200) default '' , --comment '方法名称',
|
||
request_method varchar(10) default '' , --comment '请求方式',
|
||
operator_type int default 0 , --comment '操作类别（0其它 1后台用户 2手机端用户）',
|
||
oper_name varchar(50) default '' , --comment '操作人员',
|
||
dept_name varchar(50) default '' , --comment '部门名称',
|
||
oper_url varchar(255) default '' , --comment '请求URL',
|
||
oper_ip varchar(128) default '' , --comment '主机地址',
|
||
oper_location varchar(255) default '' , --comment '操作地点',
|
||
oper_param varchar(2000) default '' , --comment '请求参数',
|
||
json_result varchar(2000) default '' , --comment '返回参数',
|
||
status int default 0 , --comment '操作状态（0正常 1异常）',
|
||
error_msg varchar(2000) default '' , --comment '错误消息',
|
||
oper_time datetime , --comment '操作时间',
|
||
cost_time bigint default 0 , --comment '消耗时间',
|
||
primary key (oper_id)
|
||
)
|
||
end
|
||
|
||
--部门表
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_dept')
|
||
begin
|
||
create table sys_dept (
|
||
dept_id bigint identity(200,1) not null, --comment '部门id',
|
||
parent_id bigint default 0, --comment '父部门id',
|
||
ancestors varchar(50) default '', --comment '祖级列表',
|
||
dept_name varchar(30) default '' , --comment '部门名称',
|
||
order_num int default 0 , --comment '显示顺序',
|
||
leader varchar(20) default null , --comment '负责人',
|
||
phone varchar(11) default null , --comment '联系电话',
|
||
email varchar(50) default null , --comment '邮箱',
|
||
status char(1) default '0' , --comment '部门状态（0正常 1停用）',
|
||
del_flag char(1) default '0' , --comment '删除标志（0代表存在 2代表删除）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
primary key (dept_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-部门表数据
|
||
-- ----------------------------
|
||
SET IDENTITY_INSERT dbo.sys_dept ON;
|
||
if not exists(select 1 from dbo.sys_dept where dept_id = '100' and parent_id = '0')
|
||
begin
|
||
INSERT INTO dbo.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time)
|
||
VALUES (100, 0, '0', '创智智慧医院', 0, 'lis', '15888888888', null, '0', '0', 'admin', '2025-05-05 11:09:44.197', '', NULL)
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dept where dept_id = '101' and parent_id = '100')
|
||
begin
|
||
INSERT INTO dbo.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time)
|
||
VALUES (101, 100, '0,100', '输血科', 1, 'lis', '15888888888', null, '0', '0', 'admin', '2025-05-05 11:09:44.197', '', NULL)
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dept where dept_id = '103' and parent_id = '101')
|
||
begin
|
||
INSERT INTO dbo.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time)
|
||
VALUES (103, 101, '0,100,101', '输血科', 1, 'lis', '15888888888', null, '0', '0', 'admin', '2025-05-05 11:09:44.197', '', NULL)
|
||
end
|
||
SET IDENTITY_INSERT dbo.sys_dept OFF;
|
||
|
||
-- ----------------------------
|
||
-- 2、用户信息表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_user')
|
||
begin
|
||
create table sys_user (
|
||
user_id bigint identity(100,1) not null , --comment '用户ID',
|
||
dept_id bigint default null, --comment '部门ID',
|
||
user_name varchar(30) not null , --comment '用户账号',
|
||
nick_name varchar(30) not null , --comment '用户昵称',
|
||
user_type varchar(2) default '00', --comment '用户类型（00系统用户）',
|
||
email varchar(50) default '' , --comment '用户邮箱',
|
||
phonenumber varchar(11) default '' , --comment '手机号码',
|
||
sex char(1) default '0' , --comment '用户性别（0男 1女 2未知）',
|
||
avatar varchar(100) default '' , --comment '头像地址',
|
||
password varchar(100) default '' , --comment '密码',
|
||
status char(1) default '0' , --comment '帐号状态（0正常 1停用）',
|
||
del_flag char(1) default '0' , --comment '删除标志（0代表存在 2代表删除）',
|
||
login_ip varchar(128) default '' , --comment '最后登录IP',
|
||
login_date datetime , --comment '最后登录时间',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null, --comment '备注',
|
||
primary key (user_id)
|
||
)
|
||
end
|
||
|
||
-- ----------------------------
|
||
-- 初始化-用户信息表数据
|
||
-- ----------------------------
|
||
SET IDENTITY_INSERT dbo.sys_user ON;
|
||
if not exists(select 1 from dbo.sys_user where user_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, 103, 'admin', '管理员', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2025-05-13 10:12:26.137', 'admin', '2025-05-05 11:37:08.19', '', '2025-05-13 10:12:26.137', '管理员')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_user where user_id = '2')
|
||
begin
|
||
INSERT INTO dbo.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, 103, 'ry', '管理员1', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2025-05-05 11:37:08.193', 'admin', '2025-05-05 11:37:08.193', '', NULL, '测试员')
|
||
end
|
||
SET IDENTITY_INSERT dbo.sys_user OFF;
|
||
|
||
-- ----------------------------
|
||
-- 3、岗位信息表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_post')
|
||
begin
|
||
create table sys_post
|
||
(
|
||
post_id bigint identity(1,1) not null , --comment '岗位ID',
|
||
post_code varchar(64) not null , --comment '岗位编码',
|
||
post_name varchar(50) not null , --comment '岗位名称',
|
||
post_sort int not null , --comment '显示顺序',
|
||
status char(1) not null , --comment '状态（0正常 1停用）',
|
||
create_by varchar(64) default '', --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '', --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null, --comment '备注',
|
||
primary key (post_id)
|
||
)
|
||
end
|
||
|
||
-- ----------------------------
|
||
-- 初始化-岗位信息表数据
|
||
-- ----------------------------
|
||
SET IDENTITY_INSERT dbo.sys_post ON;
|
||
if not exists(select 1 from dbo.sys_post where post_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2025-05-05 11:38:34.437', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_post where post_id = '1')
|
||
begin
|
||
INSERT INTO dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2025-05-05 11:38:34.437', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_post where post_id = '3')
|
||
begin
|
||
INSERT INTO dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2025-05-05 11:38:34.44', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_post where post_id = '4')
|
||
begin
|
||
INSERT INTO dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2025-05-05 11:38:34.44', '', NULL, '')
|
||
|
||
end
|
||
SET IDENTITY_INSERT dbo.sys_post OFF;
|
||
-- ----------------------------
|
||
-- 8、角色和部门关联表 角色1-N部门
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_role_dept')
|
||
begin
|
||
create table sys_role_dept (
|
||
role_id bigint not null, --comment '角色ID',
|
||
dept_id bigint not null, --comment '部门ID',
|
||
primary key(role_id, dept_id)
|
||
)
|
||
end
|
||
|
||
-- ----------------------------
|
||
-- 初始化-角色和部门关联表数据
|
||
-- ----------------------------
|
||
|
||
if not exists(select 1 from dbo.sys_role_dept where role_id = '2' and dept_id = '100')
|
||
begin
|
||
insert into sys_role_dept values ('2', '100');
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_role_dept where role_id = '2' and dept_id = '101')
|
||
begin
|
||
insert into sys_role_dept values ('2', '101');
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_role_dept where role_id = '2' and dept_id = '105')
|
||
begin
|
||
insert into sys_role_dept values ('2', '105');
|
||
end
|
||
|
||
|
||
|
||
-- ----------------------------
|
||
-- 9、用户与岗位关联表 用户1-N岗位
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_user_post')
|
||
begin
|
||
create table sys_user_post
|
||
(
|
||
user_id bigint not null, --comment '用户ID',
|
||
post_id bigint not null --comment '岗位ID',
|
||
primary key (user_id, post_id)
|
||
)
|
||
end
|
||
-- ----------------------------
|
||
-- 初始化-用户与岗位关联表数据
|
||
-- ----------------------------
|
||
|
||
if not exists(select 1 from dbo.sys_user_post where user_id = '1' and post_id = '1')
|
||
begin
|
||
insert into sys_user_post values ('1', '1');
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_user_post where user_id = '1' and post_id = '1')
|
||
begin
|
||
insert into sys_user_post values ('1', '1');
|
||
end
|
||
|
||
|
||
|
||
|
||
-- ----------------------------
|
||
-- 11、字典类型表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_dict_type')
|
||
begin
|
||
create table sys_dict_type
|
||
(
|
||
dict_id bigint identity(100,1) not null , --comment '字典主键',
|
||
dict_name varchar(100) default '' , --comment '字典名称',
|
||
dict_type varchar(100) default '' , --comment '字典类型',
|
||
status varchar(1) default '0', --comment '状态（0正常 1停用）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null, --comment '备注',
|
||
primary key (dict_id),
|
||
unique (dict_type)
|
||
)
|
||
end
|
||
|
||
|
||
SET IDENTITY_INSERT dbo.sys_dict_type ON;
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '1' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2025-05-06 09:06:43.143', '', NULL, '用户性别列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '2' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2025-05-06 09:06:43.143', '', NULL, '菜单状态列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '3' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2025-05-06 09:06:43.143', '', NULL, '系统开关列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '4' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '任务状态列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '5' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '任务分组列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '6' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '系统是否列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '7' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '通知类型列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '8' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '通知状态列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '9' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '操作类型列表')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_type where dict_id = '10' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2025-05-06 09:06:43.147', '', NULL, '登录状态列表')
|
||
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_dict_type OFF;
|
||
|
||
-- ----------------------------
|
||
-- 12、字典数据表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_dict_data')
|
||
begin
|
||
create table sys_dict_data
|
||
(
|
||
dict_code bigint identity(100,1) not null , --comment '字典编码',
|
||
dict_sort int default 0 , --comment '字典排序',
|
||
dict_label varchar(100) default '' , --comment '字典标签',
|
||
dict_value varchar(100) default '' , --comment '字典键值',
|
||
dict_type varchar(100) default '' , --comment '字典类型',
|
||
css_class varchar(100) default null, --comment '样式属性（其他样式扩展）',
|
||
list_class varchar(100) default null , --comment '表格回显样式',
|
||
is_default char(1) default 'N' , --comment '是否默认（Y是 N否）',
|
||
status char(1) default '0' , --comment '状态（0正常 1停用）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null , --comment '备注',
|
||
primary key (dict_code)
|
||
)
|
||
end
|
||
|
||
|
||
|
||
SET IDENTITY_INSERT dbo.sys_dict_data ON;
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '1' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '性别男')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '2' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '性别女')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '3' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '性别未知')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '4' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '显示菜单')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '5' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '隐藏菜单')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '6' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '正常状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '7' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '停用状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '8' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '正常状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '9' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '停用状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '10' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '默认分组')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '11' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '系统分组')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '12' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '系统默认是')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '13' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '系统默认否')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '14' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '通知')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '15' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '公告')
|
||
|
||
end
|
||
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '16' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '正常状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '17' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.913', '', NULL, '关闭状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '18' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '其他操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '19' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '新增操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '20' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '修改操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '21' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '删除操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '22' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '授权操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '23' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '导出操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '24' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '导入操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '25' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '强退操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '26' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '生成操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '27' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '清空操作')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '28' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '正常状态')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_dict_data where dict_code = '29' )
|
||
begin
|
||
INSERT INTO dbo.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2025-05-06 09:09:04.917', '', NULL, '停用状态')
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_dict_data OFF;
|
||
|
||
|
||
-- ----------------------------
|
||
-- 13、参数配置表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_config')
|
||
begin
|
||
create table sys_config (
|
||
config_id int identity(100,1) not null , --comment '参数主键',
|
||
config_name varchar(100) default '', --comment '参数名称',
|
||
config_key varchar(100) default '', --comment '参数键名',
|
||
config_value varchar(500) default '', --comment '参数键值',
|
||
config_type varchar(1) default 'N', --comment '系统内置（Y是 N否）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null, --comment '备注',
|
||
primary key (config_id)
|
||
)
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_config ON;
|
||
if not exists(select 1 from dbo.sys_config where config_id = '1' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_config where config_id = '2' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '初始化密码 123456')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_config where config_id = '3' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '深色主题theme-dark，浅色主题theme-light')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_config where config_id = '4' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'false', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '是否开启验证码功能（true开启，false关闭）')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_config where config_id = '5' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '是否开启注册用户功能（true开启，false关闭）')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_config where config_id = '6' )
|
||
begin
|
||
INSERT INTO dbo.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (6, '用户登录-黑名单列表', 'sys.login.blackIPList', '', 'Y', 'admin', '2025-05-13 11:40:21.12', '', NULL, '设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）')
|
||
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_config OFF;
|
||
|
||
|
||
-- ----------------------------
|
||
-- 14、系统访问记录
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_logininfor')
|
||
begin
|
||
create table sys_logininfor (
|
||
info_id bigint identity(100,1) not null , --comment '访问ID',
|
||
user_name varchar(50) default '', --comment '用户账号',
|
||
ipaddr varchar(128) default '', --comment '登录IP地址',
|
||
login_location varchar(255) default '', --comment '登录地点',
|
||
browser varchar(50) default '', --comment '浏览器类型',
|
||
os varchar(50) default '', --comment '操作系统',
|
||
status char(1) default '0', --comment '登录状态（0成功 1失败）',
|
||
msg varchar(255) default '' , --comment '提示消息',
|
||
login_time datetime , --comment '访问时间',
|
||
primary key (info_id)
|
||
)
|
||
CREATE NONCLUSTERED INDEX idx_sys_logininfor_s ON sys_logininfor (status);
|
||
CREATE NONCLUSTERED INDEX idx_sys_logininfor_lt ON sys_logininfor (login_time);
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 15、定时任务调度表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_job')
|
||
begin
|
||
create table sys_job (
|
||
job_id bigint identity(100,1) not null , --comment '任务ID',
|
||
job_name varchar(64) default '', --comment '任务名称',
|
||
job_group varchar(64) default 'DEFAULT', --comment '任务组名',
|
||
invoke_target varchar(500) not null , --comment '调用目标字符串',
|
||
cron_expression varchar(255) default '' , --comment 'cron执行表达式',
|
||
misfire_policy varchar(20) default '3', --comment '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
|
||
concurrent varchar(1) default '1', --comment '是否并发执行（0允许 1禁止）',
|
||
status varchar(1) default '0', --comment '状态（0正常 1暂停）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default '' , --comment '备注信息',
|
||
primary key (job_id, job_name, job_group)
|
||
)
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_job ON;
|
||
|
||
if not exists(select 1 from dbo.sys_job where job_id = '1' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2025-05-06 16:16:04.077', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where job_id = '2' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(''ry'')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2025-05-06 16:16:04.077', '', NULL, '')
|
||
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where job_id = '3' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2025-05-06 16:16:04.08', '', NULL, '')
|
||
|
||
end
|
||
|
||
SET IDENTITY_INSERT dbo.sys_job OFF;
|
||
|
||
-- ----------------------------
|
||
-- 16、定时任务调度日志表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_job_log')
|
||
begin
|
||
create table sys_job_log (
|
||
job_log_id bigint identity(100,1) not null , --comment '任务日志ID',
|
||
job_name varchar(64) not null , --comment '任务名称',
|
||
job_group varchar(64) not null , --comment '任务组名',
|
||
invoke_target varchar(500) not null , --comment '调用目标字符串',
|
||
job_message varchar(500) , --comment '日志信息',
|
||
status varchar(1) default '0', --comment '执行状态（0正常 1失败）',
|
||
exception_info varchar(2000) default '' , --comment '异常信息',
|
||
create_time datetime --comment '创建时间',
|
||
primary key (job_log_id)
|
||
)
|
||
end
|
||
|
||
|
||
|
||
|
||
|
||
-- ----------------------------
|
||
-- 17、通知公告表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_notice')
|
||
begin
|
||
create table sys_notice (
|
||
notice_id int identity(10,1) not null, --comment '公告ID',
|
||
notice_title varchar(50) not null , --comment '公告标题',
|
||
notice_type varchar(1) not null, --comment '公告类型（1通知 2公告）',
|
||
notice_content text default null, --comment '公告内容',
|
||
status char(1) default '0' , --comment '公告状态（0正常 1关闭）',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(255) default null --comment '备注',
|
||
primary key (notice_id)
|
||
)
|
||
end
|
||
|
||
|
||
-- ----------------------------
|
||
-- 初始化-公告信息表数据
|
||
-- ----------------------------
|
||
-- SET IDENTITY_INSERT dbo.sys_notice ON;
|
||
-- INSERT INTO dbo.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark)
|
||
-- VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', '新版本内容', '0', 'admin', '2025-05-06 17:29:36.113', '', NULL, '管理员')
|
||
--
|
||
-- INSERT INTO dbo.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark)
|
||
-- VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', '维护内容', '0', 'admin', '2025-05-06 17:29:36.117', '', NULL, '管理员')
|
||
--
|
||
-- SET IDENTITY_INSERT dbo.sys_notice OFF;
|
||
|
||
-- ----------------------------
|
||
-- 18、代码生成业务表
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'gen_table')
|
||
begin
|
||
create table gen_table (
|
||
table_id bigint identity(1,1) not null, --comment '编号',
|
||
table_name varchar(200) default '' , --comment '表名称',
|
||
table_comment varchar(500) default '' , --comment '表描述',
|
||
sub_table_name varchar(64) default null , --comment '关联子表的表名',
|
||
sub_table_fk_name varchar(64) default null , --comment '子表关联的外键名',
|
||
class_name varchar(100) default '' , --comment '实体类名称',
|
||
tpl_category varchar(200) default 'crud' , --comment '使用的模板（crud单表操作 tree树表操作）',
|
||
tpl_web_type varchar(30) default '' , --comment '前端模板类型（element-ui模版 element-plus模版）',
|
||
package_name varchar(100) , --comment '生成包路径',
|
||
module_name varchar(30) , --comment '生成模块名',
|
||
business_name varchar(30) , --comment '生成业务名',
|
||
function_name varchar(50) , --comment '生成功能名',
|
||
function_author varchar(50) , --comment '生成功能作者',
|
||
gen_type char(1) default '0' , --comment '生成代码方式（0zip压缩包 1自定义路径）',
|
||
gen_path varchar(200) default '/' , --comment '生成路径（不填默认项目路径）',
|
||
options varchar(1000) , --comment '其它生成选项',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
remark varchar(500) default null , --comment '备注',
|
||
primary key (table_id)
|
||
)
|
||
|
||
end
|
||
|
||
-- ----------------------------
|
||
-- 19、代码生成业务表字段
|
||
-- ----------------------------
|
||
if not exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'gen_table_column')
|
||
begin
|
||
create table gen_table_column (
|
||
column_id bigint identity(1,1) not null , --comment '编号',
|
||
table_id bigint , --comment '归属表编号',
|
||
column_name varchar(200) , --comment '列名称',
|
||
column_comment varchar(500) , --comment '列描述',
|
||
column_type varchar(100) , --comment '列类型',
|
||
java_type varchar(500) , --comment 'JAVA类型',
|
||
java_field varchar(200) , --comment 'JAVA字段名',
|
||
is_pk varchar(1) , --comment '是否主键（1是）',
|
||
is_increment varchar(1) , --comment '是否自增（1是）',
|
||
is_required varchar(1) , --comment '是否必填（1是）',
|
||
is_insert varchar(1) , --comment '是否为插入字段（1是）',
|
||
is_edit varchar(1) , --comment '是否编辑字段（1是）',
|
||
is_list varchar(1) , --comment '是否列表字段（1是）',
|
||
is_query varchar(1) , --comment '是否查询字段（1是）',
|
||
query_type varchar(200) default 'EQ' , --comment '查询方式（等于、不等于、大于、小于、范围）',
|
||
html_type varchar(200) , --comment '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
|
||
dict_type varchar(200) default '' , --comment '字典类型',
|
||
sort int , --comment '排序',
|
||
create_by varchar(64) default '' , --comment '创建者',
|
||
create_time datetime , --comment '创建时间',
|
||
update_by varchar(64) default '' , --comment '更新者',
|
||
update_time datetime , --comment '更新时间',
|
||
primary key (column_id)
|
||
)
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where invoke_target = 'lisTask.getDictDP' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES ('获取his科室信息', 'SYSTEM', 'lisTask.getDictDP', '0 0 23 * * ?', '3', '1', '1', 'admin', '2025-08-15 11:55:07.413', '', NULL, '')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where invoke_target = 'lisTask.getDictSRD' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES ('获取his人员信息', 'SYSTEM', 'lisTask.getDictSRD', '0 0 23 * * ?', '3', '1', '1', 'admin', '2025-08-15 11:56:04.073', '', NULL, '')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where invoke_target = 'lisTask.getDictWR' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES ('获取his病区信息', 'SYSTEM', 'lisTask.getDictWR', '0 0 23 * * ?', '3', '1', '1', 'admin', '2025-08-15 11:57:18.94', '', NULL, '')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where invoke_target = 'lisTask.getXmFee' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES ('获取his收费项目', 'SYSTEM', 'lisTask.getXmFee', '0 0 23 * * ?', '3', '1', '1', 'admin', '2025-08-15 11:58:04.853', '', NULL, '')
|
||
end
|
||
|
||
if not exists(select 1 from dbo.sys_job where invoke_target = 'lisTask.cleanPDF' )
|
||
begin
|
||
INSERT INTO dbo.sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
|
||
VALUES ('删除当天以前打印的pdf文件', 'SYSTEM', 'lisTask.cleanPDF', '0 0 23 * * ?', '1', '1', '1', 'admin', '2025-09-15 10:51:58.27', '', NULL, '')
|
||
end
|
||
|
||
|
||
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name LIKE '%DF__sys_oper___json%' AND type = 'D' AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]'))
|
||
begin
|
||
DECLARE @constraintName NVARCHAR(128)
|
||
SELECT @constraintName = name
|
||
FROM dbo.sysobjects
|
||
WHERE
|
||
name LIKE '%DF__sys_oper___json%'
|
||
AND type = 'D'
|
||
AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]')
|
||
|
||
-- 动态执行删除约束（因约束名称是变量，需用动态SQL）
|
||
EXEC('ALTER TABLE [dbo].[sys_oper_log] DROP CONSTRAINT [' + @constraintName + ']')
|
||
end
|
||
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name LIKE '%DF__sys_oper___oper%' AND type = 'D' AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]'))
|
||
begin
|
||
SELECT @constraintName = name
|
||
FROM dbo.sysobjects
|
||
WHERE
|
||
name LIKE '%DF__sys_oper___oper%'
|
||
AND type = 'D'
|
||
AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]')
|
||
|
||
-- 动态执行删除约束（因约束名称是变量，需用动态SQL）
|
||
EXEC('ALTER TABLE [dbo].[sys_oper_log] DROP CONSTRAINT [' + @constraintName + ']')
|
||
end
|
||
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name LIKE '%DF__sys_oper___error%' AND type = 'D' AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]'))
|
||
begin
|
||
SELECT @constraintName = name
|
||
FROM dbo.sysobjects
|
||
WHERE
|
||
name LIKE '%DF__sys_oper___error%'
|
||
AND type = 'D'
|
||
AND parent_obj = OBJECT_ID(N'[dbo].[sys_oper_log]')
|
||
|
||
-- 动态执行删除约束（因约束名称是变量，需用动态SQL）
|
||
EXEC('ALTER TABLE [dbo].[sys_oper_log] DROP CONSTRAINT [' + @constraintName + ']')
|
||
end
|
||
|
||
|
||
if exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_oper_log' AND COLUMN_NAME = 'oper_param')
|
||
begin
|
||
alter table sys_oper_log ALTER COLUMN oper_param nvarchar(max)
|
||
end
|
||
|
||
if exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_oper_log' AND COLUMN_NAME = 'json_result')
|
||
begin
|
||
alter table sys_oper_log ALTER COLUMN json_result nvarchar(max)
|
||
end
|
||
|
||
if exists(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_oper_log' AND COLUMN_NAME = 'error_msg')
|
||
begin
|
||
alter table sys_oper_log ALTER COLUMN error_msg nvarchar(max)
|
||
end |