/*
Navicat Premium Data Transfer
Source Server : 111.198.10.15-mysql8
Source Server Type : MySQL
Source Server Version : 80016
Source Host : 111.198.10.15:11336
Source Schema : casic-production-safety
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 20/06/2024 15:15:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for bus_device_info
-- ----------------------------
DROP TABLE IF EXISTS bus_device_info;
CREATE TABLE bus_device_info (
id bigint(20) NULL DEFAULT NULL COMMENT '主键',
station_name varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场站名称',
monitor_name varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
device_ip varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备IP',
device_port int(11) NULL DEFAULT NULL COMMENT '设备端口',
device_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备用户名',
device_password varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备密码',
nvr_ip varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'NVRip',
nvr_port int(11) NULL DEFAULT NULL COMMENT 'NVRport',
nvr_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'nvr用户名',
nvr_password varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'nvr密码',
nvr_channel varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'nvr通道',
device_type varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备类型',
description varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
device_status smallint(6) NULL DEFAULT NULL COMMENT '设备状态(0离线 1 在线 字典status)',
secret_level smallint(6) NULL DEFAULT NULL COMMENT '密级（0，一般 1 重要 2 秘密）',
dept_id bigint(20) NULL DEFAULT NULL COMMENT '所属组织',
longitude decimal(10, 6) NULL DEFAULT NULL COMMENT '经度',
latitude decimal(10, 6) NULL DEFAULT NULL COMMENT '纬度',
bf_flag smallint(6) NULL DEFAULT NULL COMMENT '布防状态(1,布防 0 撤防)',
create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
area varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域(区域编码)',
play_url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流地址信息',
camera_index_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备监控点唯一码',
location varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
nvr_manufacture varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'NVR厂家',
device_manufacture varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备厂家'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of bus_device_info
-- ----------------------------
INSERT INTO bus_device_info VALUES (1788491058556604418, NULL, '大华-监控1', '192.168.83.172', 37777, 'admin', 'admin123', '192.168.83.171', 5060, 'admin', 'admin123', '1', '0', NULL, 1, 0, 1394541964580085762, 116.258555, 39.908447, 0, '2024-05-09 08:47:52', '2024-05-09 08:47:52', '1788158902110785537', NULL, '34020000001110000013', '永定路社区设备点', 'Dahua', 'Dahua');
INSERT INTO bus_device_info VALUES (1788491058556604419, NULL, '海康-监控2', '192.168.83.170', 8000, 'admin', '1234qwer', '192.168.83.41', 5060, 'admin', '1234qwer', '5', '0', NULL, 1, 0, 1394541964580085762, NULL, NULL, 0, '2024-05-09 08:47:52', '2024-05-09 08:47:52', '1788158902110785537', NULL, '34020000001320000003', NULL, 'HIKVISION', 'Manufacturer');
-- ----------------------------
-- Table structure for device_group_info
-- ----------------------------
DROP TABLE IF EXISTS device_group_info;
CREATE TABLE device_group_info (
id bigint(20) NULL DEFAULT NULL COMMENT '主键',
create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
group_name varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组名称',
camera_num int(11) NULL DEFAULT NULL COMMENT '分组相机数量',
description varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
camera_ids text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '分组相机id,用逗号隔开',
safe tinyint(4) NULL DEFAULT 0 COMMENT '密级（0，一般 1 重要 2 秘密）'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备分组管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of device_group_info
-- ----------------------------
INSERT INTO device_group_info VALUES (1789196828496109569, '2024-05-11 07:32:20', '2024-05-11 07:32:20', 'all', 2, '', '1788491058556604418,1788491058556604419', 0);
-- ----------------------------
-- Table structure for device_online_log
-- ----------------------------
DROP TABLE IF EXISTS device_online_log;
CREATE TABLE device_online_log (
id bigint(20) NULL DEFAULT NULL COMMENT '主键',
area varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域字典',
online_num int(11) NULL DEFAULT NULL COMMENT '在线量',
offline_num int(11) NULL DEFAULT NULL COMMENT '离线数量',
total int(11) NULL DEFAULT NULL COMMENT '总数',
log_time varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录时间',
update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备在线日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of device_online_log
-- ----------------------------
INSERT INTO device_online_log VALUES (1, '0', 10, 2, 12, '2024-04-08', NULL);
INSERT INTO device_online_log VALUES (2, '0', 11, 1, 12, '2024-04-09', NULL);
-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS sys_area;
CREATE TABLE sys_area (
ID bigint(20) NOT NULL COMMENT '编码',
PID bigint(20) NULL DEFAULT NULL COMMENT '父级',
AREA_NAME varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称',
SIMPLE_NAME varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域简称',
LNG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
LAT varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
LEVEL int(11) NULL DEFAULT NULL COMMENT '层级',
PIDS varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全部父级别',
NUM tinyint(4) NULL DEFAULT NULL COMMENT '排序',
SYNC_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步id',
SYNC_PID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步父ID',
IS_SYNC tinyint(4) NULL DEFAULT NULL COMMENT '是否同步',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_area
-- ----------------------------
INSERT INTO sys_area VALUES (110000, 0, '根节点', '根节点', '116.405289', '39.904987', 1, '[0],', 1, 'root00000000', '-1', NULL, NULL);
INSERT INTO sys_area VALUES (1788158902110785537, 110000, '永定路A区域', '永定路A区域', NULL, NULL, 2, '[0],[110000],', NULL, 'd141f1a3bd2645aeb3bed2f5bfe5a929', 'root00000000', NULL, NULL);
INSERT INTO sys_area VALUES (1788158904023388162, 110000, '成都A区', '成都A区', NULL, NULL, 2, '[0],[110000],', NULL, '2222f9c4bb6548e3ac005826e5d60b55', 'root00000000', NULL, NULL);
-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS sys_config;
CREATE TABLE sys_config (
ID bigint(20) NOT NULL,
VALUE varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量值(相关json串)',
TARGET_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量KEY',
CLASS_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名全称(保留)',
DESCRIPTION varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量描述',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO sys_config VALUES (1, '1.0.0.191209_alpha', 'casic.base.version', NULL, '版本号', NULL);
INSERT INTO sys_config VALUES (2, 'false', 'casic.db.init.enable', NULL, '默认启用', NULL);
INSERT INTO sys_config VALUES (3, 'false', 'casic.db.init.enable', NULL, '默认启用', NULL);
INSERT INTO sys_config VALUES (9, '150', 'casic.base.device.offLine', NULL, '设备离线时间判定(分钟)', NULL);
INSERT INTO sys_config VALUES (10, 'false', 'casic.base.user.onLineListenerEnable', NULL, '默认不开启（是否开启用户在线状态）', NULL);
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS sys_dept;
CREATE TABLE sys_dept (
ID bigint(20) NOT NULL COMMENT '主键id',
NUM tinyint(4) NULL DEFAULT NULL COMMENT '排序',
PID bigint(20) NULL DEFAULT NULL COMMENT '父部门ID',
PIDS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级IDS',
SIMPLE_NAME varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
FULL_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
TIPS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
VERSION int(11) NULL DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
SYNC_ID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部组织ID',
SYNC_PID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部父类主键',
IS_SYNC tinyint(4) NULL DEFAULT NULL COMMENT '是否同步数据 1为同步',
IS_PARENT tinyint(4) NULL DEFAULT NULL COMMENT '是否是父类',
IP_SEGMENT varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP段限制(逗号拼接)',
DEPT_TYPE char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织类型(03 公司 04 部门/组)',
TENANT_ID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
CREATE_USER bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
UPDATE_USER bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
DEL_FLAG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO sys_dept VALUES (0, 1, -1, NULL, '顶级', '顶级', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO sys_dept VALUES (24, 1, 0, '[0],', '运行指挥调度中心', '运行指挥调度中心', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', '1', NULL, NULL, NULL, NULL, '0');
INSERT INTO sys_dept VALUES (1394541964580085762, 2, 0, '[0],', '203', '203所', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO sys_dept VALUES (1429999819396530178, 1, 0, '[0],', '中国航天科工1', '中国航天科工集团203所', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '03', NULL, 1, 1, '2021-08-24 02:51:40', '2021-08-24 03:26:40', '0');
INSERT INTO sys_dept VALUES (1780179168070664194, 0, 1429999819396530178, '[0],[1429999819396530178],', '测试组织', '测试组织', '', NULL, NULL, NULL, NULL, NULL, NULL, '03', NULL, 1, NULL, '2024-04-16 10:19:22', NULL, '0');
-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS sys_dict;
CREATE TABLE sys_dict (
ID bigint(20) UNSIGNED NOT NULL COMMENT '主键id',
NUM varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
PID bigint(20) NULL DEFAULT NULL COMMENT '父级字典',
NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
TIPS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
CODE varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO sys_dict VALUES (35, '0', 0, '账号状态', NULL, 'accountStatus', NULL);
INSERT INTO sys_dict VALUES (36, '1', 35, '启用', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (37, '2', 35, '已冻结', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (38, '3', 35, '已删除', NULL, '3', NULL);
INSERT INTO sys_dict VALUES (57, '0', 0, '日志类型', NULL, 'logType', NULL);
INSERT INTO sys_dict VALUES (58, '0', 57, '业务日志', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (59, '1', 57, '异常日志', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (75, '0', 0, '组织类型', '组织类型', 'deptType', NULL);
INSERT INTO sys_dict VALUES (76, '1', 75, '公司', NULL, '03', NULL);
INSERT INTO sys_dict VALUES (77, '2', 75, '组/部门', NULL, '04', NULL);
INSERT INTO sys_dict VALUES (159, '0', 0, '数据权限类型', NULL, 'dataScopeType', NULL);
INSERT INTO sys_dict VALUES (160, '0', 159, '所有数据', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (161, '0', 159, '所属及下级部门', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (162, '0', 159, '本部门', NULL, '3', NULL);
INSERT INTO sys_dict VALUES (163, '0', 159, '自定义', NULL, '4', NULL);
INSERT INTO sys_dict VALUES (1191959474021052418, '0', 0, '状态', NULL, 'sysStatus', NULL);
INSERT INTO sys_dict VALUES (1191959474033635330, '1', 1191959474021052418, '启用', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1191959474037829633, '2', 1191959474021052418, '禁用', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1191961164497457154, '0', 0, '性别', NULL, 'sysSex', NULL);
INSERT INTO sys_dict VALUES (1191961164510040066, '1', 1191961164497457154, '男', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1191961164535205890, '2', 1191961164497457154, '女', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1345920683299459074, '0', 0, '性别', NULL, 'sex', NULL);
INSERT INTO sys_dict VALUES (1345920683299459075, '0', 1345920683299459074, '男', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1345920683366567938, '0', 1345920683299459074, '女', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1392315332146458625, '0', 0, '资源类型', NULL, 'resourceType', NULL);
INSERT INTO sys_dict VALUES (1392315332163235841, '1', 1392315332146458625, '菜单', NULL, '03', NULL);
INSERT INTO sys_dict VALUES (1392315332175818753, '2', 1392315332146458625, '按钮', NULL, '04', NULL);
INSERT INTO sys_dict VALUES (1392315332200984577, '0', 1392315332146458625, '系统', NULL, '02', NULL);
INSERT INTO sys_dict VALUES (1392315332213567489, '5', 1392315332146458625, '移动端模块', NULL, '05', NULL);
INSERT INTO sys_dict VALUES (1397019628332453889, '0', 0, '结果集类型', NULL, 'viewResType', NULL);
INSERT INTO sys_dict VALUES (1397019628403757057, '0', 1397019628332453889, '实体对象', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1397019628462477313, '0', 1397019628332453889, '集合', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1397021674825650177, '0', 0, '访问类型', 'view视图是访问类型', 'viewRouteType', NULL);
INSERT INTO sys_dict VALUES (1397021674846621697, '0', 1397021674825650177, '资源库', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1397021674896953345, '0', 1397021674825650177, '接口', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1397021674896953346, '0', 0, '开启状态', NULL, 'trackStatus', NULL);
INSERT INTO sys_dict VALUES (1397021674896953347, '0', 1397021674896953346, '未开启', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1397021674896953348, '0', 1397021674896953346, '已开启', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1774628055008579585, '0', 0, '密级', '', 'secretLevel', NULL);
INSERT INTO sys_dict VALUES (1774628055008579586, '0', 1774628055008579585, '一般', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1774628055008579587, '1', 1774628055008579585, '秘密', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1774628055008579588, '2', 1774628055008579585, '机密', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1774629992403734530, '0', 0, '角色日志类型', '', 'logRoleType', NULL);
INSERT INTO sys_dict VALUES (1774629992403734531, '0', 1774629992403734530, '普通用户', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1774629992403734532, '1', 1774629992403734530, '管理员', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1774629992403734533, '2', 1774629992403734530, '保密员', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1774629992403734534, '3', 1774629992403734530, '审计员', NULL, '3', NULL);
INSERT INTO sys_dict VALUES (1777504193142067202, '0', 0, '是否关键区域', '是否关键区域', 'keyArea', NULL);
INSERT INTO sys_dict VALUES (1777504193267896321, '0', 1777504193142067202, '否', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1777504193389531138, '1', 1777504193142067202, '是', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1777508904209485825, '0', 0, '布防状态', '', 'bfFlag', NULL);
INSERT INTO sys_dict VALUES (1777508904373063681, '0', 1777508904209485825, '撤防', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1777508904566001665, '1', 1777508904209485825, '布防', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1777589297931620353, '0', 0, '所属区域', '', 'area', NULL);
INSERT INTO sys_dict VALUES (1777589298011312129, '0', 1777589297931620353, '永定路', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1777589298074226689, '1', 1777589297931620353, '成都', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1778309657278812162, '0', 0, '设备类型', '', 'deviceType', NULL);
INSERT INTO sys_dict VALUES (1778309657434001409, '0', 1778309657278812162, '枪机', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1778309657547247617, '1', 1778309657278812162, '半球', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1778309657547247618, '1', 1778309657278812162, '快球', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1778309657547247619, '1', 1778309657278812162, '云台枪机', NULL, '3', NULL);
INSERT INTO sys_dict VALUES (1788482431670235138, '0', 0, '区域类型', '', 'levelType', NULL);
INSERT INTO sys_dict VALUES (1788482432190328833, '0', 1788482431670235138, '一级', NULL, '1', NULL);
INSERT INTO sys_dict VALUES (1788482432639119361, '0', 1788482431670235138, '二级', NULL, '2', NULL);
INSERT INTO sys_dict VALUES (1788482434295869442, '0', 1788482431670235138, '三级', NULL, '3', NULL);
INSERT INTO sys_dict VALUES (1788482434815963137, '0', 1788482431670235138, '四级', NULL, '4', NULL);
INSERT INTO sys_dict VALUES (1788484551878266882, '0', 0, '设备状态', '', 'status', NULL);
INSERT INTO sys_dict VALUES (1788484552519995393, '0', 1788484551878266882, '离线', NULL, '0', NULL);
INSERT INTO sys_dict VALUES (1788484553107197953, '1', 1788484551878266882, '在线', NULL, '1', NULL);
-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS sys_login_log;
CREATE TABLE sys_login_log (
ID bigint(20) NOT NULL COMMENT '主键',
LOG_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
USER_ID bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
SUCCEED varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否执行成功',
MESSAGE text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '具体消息',
IP varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录记录' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS sys_operation_log;
CREATE TABLE sys_operation_log (
ID bigint(20) NOT NULL COMMENT '主键',
LOG_TYPE varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志类型',
LOG_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
USER_ID bigint(20) NULL DEFAULT NULL COMMENT '用户id',
CLASS_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
METHOD text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '方法名称',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
SUCCEED varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成功',
MESSAGE text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
APP_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用',
ROLE_TYPE tinyint(4) NULL DEFAULT 0 COMMENT '0 普通用户 1 管理员 2 保密员 3 审计员',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_operation_log
-- ----------------------------
-- ----------------------------
-- Table structure for sys_person
-- ----------------------------
DROP TABLE IF EXISTS sys_person;
CREATE TABLE sys_person (
ID bigint(20) NOT NULL COMMENT '主键',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
CREATE_USER bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
UPDATE_USER bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
DEL_FLAG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识',
PERSON_NAME varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
SEX char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别(1:男 2:女)',
CARD_TYPE char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件类型',
ID_CARD_NO varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件号码',
DEPTID bigint(20) NULL DEFAULT NULL COMMENT '所属部门',
PERSON_TYPE varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员类型',
REMARKS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
PERSON_CODE varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员编码',
NATION varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
BIRTHDAY datetime(0) NULL DEFAULT NULL COMMENT '出生日期',
PHOTO varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件照',
PHONE varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员信息管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_person
-- ----------------------------
-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS sys_resource;
CREATE TABLE sys_resource (
ID bigint(20) NOT NULL COMMENT '主键id',
PID bigint(20) NULL DEFAULT NULL COMMENT '父ID',
CODE varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单编号',
P_CODE varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单父编号',
P_CODES varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前菜单的所有父菜单编号',
NAME varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
ICON varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
URL varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL地址',
NUM tinyint(4) NULL DEFAULT NULL COMMENT '菜单排序号',
LEVELS tinyint(4) NULL DEFAULT NULL COMMENT '菜单层级',
IS_MENU char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否是菜单（1：是 0：不是）',
TIPS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
IS_OPEN char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否打开: 1:打开 0:不打开',
RESOURCE_TYPE char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型',
CREATE_USER bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
UPDATE_USER bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
DEL_FLAG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
STATUS char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
PRIMARY KEY (ID) USING BTREE,
INDEX AK_KEY_CODE(CODE) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_resource
-- ----------------------------
INSERT INTO sys_resource VALUES (105, 0, 'system', '0', '[0],', '系统管理', 'icon-setting', '/system', 4, 1, '1', NULL, '1', '03', NULL, 1, NULL, '2023-03-10 07:06:42', '0', NULL, NULL);
INSERT INTO sys_resource VALUES (106, 105, 'mgr', 'system', '[0],[system]', '用户管理', NULL, '/sys/mgr', 1, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (107, 106, 'mgr_add', 'mgr', '[0],[system],[mgr]', '添加用户', NULL, '/sys/mgr/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (108, 106, 'mgr_edit', 'mgr', '[0],[system],[mgr]', '修改用户', NULL, '/sys/mgr/update', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (109, 106, 'mgr_delete', 'mgr', '[0],[system],[mgr]', '删除用户', NULL, '/sys/mgr/delete', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (110, 106, 'mgr_reset', 'mgr', '[0],[system],[mgr]', '重置密码', NULL, '/sys/mgr/reset', 4, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (111, 106, 'mgr_freeze', 'mgr', '[0],[system],[mgr]', '冻结用户', NULL, '/sys/mgr/freeze', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (112, 106, 'mgr_unfreeze', 'mgr', '[0],[system],[mgr]', '解除冻结用户', NULL, '/sys/mgr/unfreeze', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (113, 106, 'mgr_setRole', 'mgr', '[0],[system],[mgr]', '分配角色', NULL, '/sys/mgr/roleAssign', 7, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (114, 105, 'role', 'system', '[0],[system]', '角色管理', NULL, '/sys/role', 2, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (115, 114, 'role_add', 'role', '[0],[system],[role]', '添加角色', NULL, '/sys/role/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (116, 114, 'role_edit', 'role', '[0],[system],[role]', '修改角色', NULL, '/sys/role/update', 2, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (117, 114, 'role_remove', 'role', '[0],[system],[role]', '删除角色', NULL, '/sys/role/delete', 3, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (118, 114, 'role_setAuthority', 'role', '[0],[system],[role]', '配置权限', NULL, '/sys/role/funcAuthor', 4, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (119, 105, 'menu', 'system', '[0],[system]', '资源管理', NULL, '/sys/resource', 4, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (120, 119, 'menu_add', 'menu', '[0],[system],[menu]', '添加菜单', NULL, '/sys/resource/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (121, 119, 'menu_edit', 'menu', '[0],[system],[menu]', '修改菜单', NULL, '/sys/resource/update', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (122, 119, 'menu_remove', 'menu', '[0],[system],[menu]', '删除菜单', NULL, '/sys/resource/delete', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (128, 105, 'log', 'system', '[0],[system]', '日志管理', NULL, '/sys/log', 6, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (131, 105, 'dept', 'system', '[0],[system]', '组织管理', NULL, '/sys/dept', 3, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (132, 105, 'dict', 'system', '[0],[system]', '字典管理', NULL, '/sys/dict', 4, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (133, 105, 'loginLog', 'system', '[0],[system]', '登录日志', NULL, '/sys/loginLog', 6, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (134, 128, 'log_clean', 'log', '[0],[system][log],', '清空日志', '', '/sys/log/biz/delLog', 3, 4, '0', NULL, '0', '04', NULL, 1, NULL, '2024-03-27 03:26:23', '0', NULL, NULL);
INSERT INTO sys_resource VALUES (135, 131, 'dept_add', 'dept', '[0],[system],[dept]', '添加部门', NULL, '/sys/dept/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (136, 131, 'dept_update', 'dept', '[0],[system],[dept]', '修改部门', NULL, '/sys/dept/update', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (137, 131, 'dept_delete', 'dept', '[0],[system],[dept]', '删除部门', NULL, '/sys/dept/delete', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (138, 132, 'dict_add', 'dict', '[0],[system],[dict]', '添加字典', NULL, '/sys/dict/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (139, 132, 'dict_update', 'dict', '[0],[system],[dict]', '修改字典', NULL, '/sys/dict/update', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (140, 132, 'dict_delete', 'dict', '[0],[system],[dict]', '删除字典', NULL, '/sys/dict/delete', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (151, 119, 'menu_list', 'menu', '[0],[system],[menu]', '菜单列表', NULL, '/sys/resource/list', 5, 2, '0', NULL, '0', '0', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (153, 131, 'dept_list', 'dept', '[0],[system],[dept]', '部门列表', NULL, '/sys/dept/list', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (154, 131, 'dept_detail', 'dept', '[0],[system],[dept]', '部门详情', NULL, '/sys/dept/detail', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (156, 132, 'dict_list', 'dict', '[0],[system],[dict]', '字典列表', NULL, '/sys/dict/list', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (157, 132, 'dict_detail', 'dict', '[0],[system],[dict]', '字典详情', NULL, '/sys/dict/detail', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (158, 128, 'log_list', 'log', '[0],[system][log],', '日志列表', '', '/sys/log/biz/list', 2, 4, '1', NULL, '0', '03', NULL, 1, NULL, '2024-03-27 03:28:29', '0', NULL, NULL);
INSERT INTO sys_resource VALUES (159, 128, 'log_detail', 'log', '[0],[system],[log]', '日志详情', NULL, '/sys/log/biz/detail', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (160, 133, 'del_login_log', 'loginLog', '[0],[system],[loginLog]', '清空登录日志', NULL, '/sys/loginLog/delLoginLog', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (161, 133, 'login_log_list', 'loginLog', '[0],[system],[loginLog]', '登录日志列表', NULL, '/sys/loginLog/list', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (164, 114, 'role_list', 'role', '[0],[system],[role]', '角色列表', NULL, '/sys/role/list', 7, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (167, 106, 'mgr_list', 'mgr', '[0],[system],[mgr]', '用户列表', NULL, '/sys/mgr/list', 10, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1138364388198715393, 114, 'data_author', 'role', '[0],[system],[role]', '数据权限', '', '/sys/role/dataAuthor', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1170945119300976642, 105, 'AreaAdmin', 'system', '[0],[system]', '区域管理', NULL, '/sys/area', 0, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1191975090689810434, 1170945119300976642, 'area_listPage', 'AreaAdmin', '[0],[system],[AreaAdmin]', '区域列表', NULL, '/sys/area/listPage', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1191975312815955969, 1170945119300976642, 'area_add', 'AreaAdmin', '[0],[system],[AreaAdmin]', '新增区域', NULL, '/sys/area/add', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1191975427559530497, 1170945119300976642, 'area_update', 'AreaAdmin', '[0],[system],[AreaAdmin]', '修改区域', NULL, '/sys/area/update', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1191975543687225346, 1170945119300976642, 'area_delete', 'AreaAdmin', '[0],[system],[AreaAdmin]', '区域删除', NULL, '/sys/area/delete', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO sys_resource VALUES (1780485097439432706, 0, 'dashboard', '0', '[0],', '首页', 'icon-map', '/dashboard', 0, 1, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:35:02', '2024-04-17 06:41:04', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780485390394789889, 0, 'monitor', '0', '[0],', '远程监控', 'icon-yc', '/monitor', 0, 1, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:36:12', '2024-04-17 06:41:41', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780485479381143554, 1780485390394789889, 'realTime', 'monitor', '[0],[monitor],', '实时监控', 'icon-camera', '/realTime', 0, 2, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:36:33', '2024-04-17 06:45:42', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780485764610592770, 1780485390394789889, 'broadcast', 'monitor', '[0],[monitor],', '安全播报', 'icon-bb', '/broadcast', 0, 2, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:37:41', '2024-04-17 06:42:30', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780485860056174593, 1780485390394789889, 'playback', 'monitor', '[0],[monitor],', '场景回放', 'icon-hf', '/playback', 0, 2, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:38:04', '2024-04-17 06:42:39', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780485944827252738, 1780485390394789889, 'statistics', 'monitor', '[0],[monitor],', '数据统计', 'icon-line', '/statistics', 0, 2, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:38:24', '2024-04-17 06:42:49', '0', NULL, '0');
INSERT INTO sys_resource VALUES (1780486033650028545, 1780485390394789889, 'device', 'monitor', '[0],[monitor],', '设备管理', 'icon-device', '/device', 0, 2, '1', NULL, '0', '03', 1, 1, '2024-04-17 06:38:45', '2024-04-17 06:42:55', '0', NULL, '0');
-- ----------------------------
-- Table structure for sys_rm_relation
-- ----------------------------
DROP TABLE IF EXISTS sys_rm_relation;
CREATE TABLE sys_rm_relation (
ID bigint(20) NOT NULL COMMENT '主键',
MENUID bigint(20) NULL DEFAULT NULL COMMENT '菜单id',
ROLEID bigint(20) NULL DEFAULT NULL COMMENT '角色id',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '授权时间',
OPERATOR_ID bigint(20) NULL DEFAULT NULL COMMENT '授权人',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_rm_relation
-- ----------------------------
INSERT INTO sys_rm_relation VALUES (1772826538576408578, 105, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517441, 106, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517442, 110, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517443, 111, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517444, 112, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517445, 113, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517446, 167, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517447, 114, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538643517448, 115, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432001, 116, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432002, 118, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432003, 164, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432004, 1138364388198715393, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432005, 128, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432006, 134, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432007, 158, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1772826538706432008, 159, 2, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1776850835934433281, 105, 3, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1776850835934433282, 128, 3, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1776850835934433283, 158, 3, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1776850835934433284, 159, 3, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486167611904002, 105, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486167704178689, 106, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486167767093250, 107, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486167888728065, 108, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486167985197058, 109, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168090054657, 113, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168199106562, 167, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168274604034, 114, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168392044545, 115, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168551428097, 116, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168639508481, 117, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168723394562, 118, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168815669249, 164, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486168916332545, 1138364388198715393, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169042161666, 119, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169176379394, 120, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169352540162, 121, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169528700930, 122, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169679695874, 151, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486169830690818, 128, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170036211714, 134, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170141069314, 158, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170275287042, 159, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170367561729, 131, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170447253505, 135, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170577276929, 136, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170652774402, 137, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170761826305, 153, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486170870878210, 154, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171026067457, 132, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171139313666, 138, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171214811138, 139, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171298697218, 140, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171353223170, 156, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171437109250, 157, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171512606721, 133, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171621658625, 160, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171709739010, 161, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171818790914, 1170945119300976642, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171906871298, 1191975090689810434, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486171982368769, 1191975312815955969, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172070449153, 1191975427559530497, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172171112449, 1191975543687225346, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172275970050, 1780485097439432706, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172347273218, 1780485390394789889, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172431159298, 1780485479381143554, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172728954882, 1780485764610592770, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172871561218, 1780485860056174593, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486172972224514, 1780485944827252738, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486173030944769, 1780486033650028545, 1, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214164484098, 1780485097439432706, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214244175874, 1780485390394789889, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214286118913, 1780485479381143554, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214395170817, 1780485764610592770, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214474862594, 1780485860056174593, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214550360066, 1780485944827252738, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_rm_relation VALUES (1780486214613274625, 1780486033650028545, 1398227452970446850, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS sys_role;
CREATE TABLE sys_role (
ID bigint(20) NOT NULL COMMENT '主键id',
NUM tinyint(4) NULL DEFAULT NULL COMMENT '序号',
PID bigint(20) NULL DEFAULT NULL COMMENT '父角色ID',
NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
DEPT_ID bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
VERSION int(11) NULL DEFAULT NULL COMMENT '保留字段(暂时没用）',
TIPS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色标识',
DATASCOPE varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限',
IS_DEFAULT smallint(6) NULL DEFAULT NULL COMMENT '是否是默认角色(同步)',
DATA_SCOPE_TYPE char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限类型( 1 所有数据 2 当前及子级部门 3 本部门 4 自定义)',
CREATE_USER bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
UPDATE_USER bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
DEL_FLAG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除状态',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
IS_SYS tinyint(4) NULL DEFAULT 0 COMMENT '是否系统内置',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO sys_role VALUES (1, 1, 0, '系统管理角色', 0, 1, 'administrator', '0,24', 0, '1', NULL, 1, NULL, '2024-04-07 05:39:43', '0', NULL, 0);
INSERT INTO sys_role VALUES (2, 0, 0, '安全保密角色', 0, NULL, 'security_admin', NULL, 0, '1', 1, NULL, '2024-03-26 07:25:45', NULL, '0', NULL, 0);
INSERT INTO sys_role VALUES (3, 0, 0, '安全审计角色', 0, NULL, 'audit_admin', NULL, 0, '1', 1, 2, '2024-03-26 07:50:37', '2024-03-27 05:58:30', '0', NULL, 0);
INSERT INTO sys_role VALUES (1398227452970446850, 99, 1, '普通管理角色', 24, NULL, 'normalAdmin', NULL, 0, '4', NULL, NULL, NULL, NULL, '0', NULL, 0);
-- ----------------------------
-- Table structure for sys_ru_relation
-- ----------------------------
DROP TABLE IF EXISTS sys_ru_relation;
CREATE TABLE sys_ru_relation (
ID bigint(20) NOT NULL COMMENT '主键',
USERID bigint(20) NULL DEFAULT NULL COMMENT '用户id',
ROLEID bigint(20) NULL DEFAULT NULL COMMENT '角色id',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '授权时间',
OPERATOR_ID bigint(20) NULL DEFAULT NULL COMMENT '授权人',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色人员关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_ru_relation
-- ----------------------------
INSERT INTO sys_ru_relation VALUES (1397015476227346433, 1, 1, NULL, NULL, NULL);
INSERT INTO sys_ru_relation VALUES (1772556646371479553, 3, 3, NULL, NULL, NULL);
INSERT INTO sys_ru_relation VALUES (1772556646371479554, 3, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO sys_ru_relation VALUES (1780491863451570178, 1780491861748682754, 1, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_table_view_config
-- ----------------------------
DROP TABLE IF EXISTS sys_table_view_config;
CREATE TABLE sys_table_view_config (
ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
VIEW_KEY varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视图key值',
SQL_CONTENT varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行sql',
TITLE varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
RES_TYPE varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1 实体对象 2 集合',
REMARKS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
PARAMS_NUM int(11) NULL DEFAULT 0 COMMENT '参数个数',
ROUTE_TYPE char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转发类型(1 本地库读取 2 接口访问 3 转换数据)',
HOST varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
RULE_CLASS varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转换规则类',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_table_view_config
-- ----------------------------
INSERT INTO sys_table_view_config VALUES (1, 'data_demo', 'SELECT * FROM sys_user where name = {0} or name like {1}', '数据前置查询测试', '2', NULL, 1, '1', NULL, NULL);
-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS sys_tenant;
CREATE TABLE sys_tenant (
ID bigint(20) NULL DEFAULT NULL COMMENT '自增主键',
TENANT_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户名称',
TENANT_CODE varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户编码',
LINK_PERSON varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
TEL varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
CLEARDAY int(11) NULL DEFAULT NULL COMMENT '历史数据保存天数',
FLAG char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
TS datetime(0) NULL DEFAULT NULL COMMENT '更新时间戳'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
ID bigint(20) NOT NULL COMMENT '主键id',
AVATAR varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
ACCOUNT varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
PASSWORD varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
SALT varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5密码盐',
NAME varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
BIRTHDAY datetime(0) NULL DEFAULT NULL COMMENT '生日',
SEX char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
EMAIL varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',
PHONE varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
ROLE_ID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id(停用)',
DEPT_ID bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
STATUS char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
VERSION int(11) NULL DEFAULT NULL COMMENT '保留字段',
SYNC_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原ID',
SYNC_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原名称',
SYNC_PWD varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步密码',
SYNC_DEPTID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步组织ID',
IS_SYNC smallint(6) NULL DEFAULT 0 COMMENT '是否是同步数据',
LOGIN_IP varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录限制IP',
LOGIN_MAC varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录MAC地址',
POSITION_LNG decimal(19, 8) NULL DEFAULT NULL COMMENT '定位经度',
POSITION_LAT decimal(19, 8) NULL DEFAULT NULL COMMENT '定位纬度',
ATTR1 varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预留字段',
LAST_TIME timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '登录时间',
CREATE_USER bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
UPDATE_USER bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
CREATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
DEL_FLAG varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除状态',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
IS_SYS tinyint(4) NULL DEFAULT 0 COMMENT '是否系统内置',
SECRET_LEVEL tinyint(4) NULL DEFAULT 0 COMMENT '密级（0，一般 1 重要 2 秘密）',
PRIMARY KEY (ID) USING BTREE,
UNIQUE INDEX AK_CONSTRAINT_ACCOUNT(ACCOUNT) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO sys_user VALUES (1, 'girl.gif', 'admin', '270fa3ef938fb1277d1ab23e9971566a', 'jg8q8', '系统管理员', '2017-05-04 16:00:00', '1', 'sn93@qq.com', '18200000000', '1,1398227452970446850', 0, '1', 25, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2024-04-12 13:59:44', NULL, NULL, '2016-01-29 00:49:53', NULL, '0', NULL, 0, 0);
INSERT INTO sys_user VALUES (2, 'girl.gif', 'security_admin', '270fa3ef938fb1277d1ab23e9971566a', 'jg8q8', '安全管理员', '2017-05-04 16:00:00', '1', 'sn93@qq.com', '18200000000', '2', 0, '1', 25, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2024-04-07 05:53:46', NULL, 2, '2016-01-29 00:49:53', '2024-03-27 02:53:49', '0', NULL, 1, 0);
INSERT INTO sys_user VALUES (3, 'girl.gif', 'audit_admin', '270fa3ef938fb1277d1ab23e9971566a', 'jg8q8', '安全审计员', '2017-05-04 16:00:00', '1', 'sn93@qq.com', '18200000000', '3,1398227452970446850', 0, '1', 25, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2024-04-07 06:20:34', NULL, NULL, '2016-01-29 00:49:53', NULL, '0', NULL, 1, 0);
INSERT INTO sys_user VALUES (1780491861748682754, NULL, 'wxt', '09e3d04c2c44e96095446e4af12db5ab', '59vmr', 'wxt', NULL, NULL, '', '', '1', 1394541964580085762, '1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2024-04-17 15:01:54', 1, NULL, '2024-04-17 07:01:54', NULL, '0', NULL, 0, 0);
-- ----------------------------
-- Table structure for sys_user_device
-- ----------------------------
DROP TABLE IF EXISTS sys_user_device;
CREATE TABLE sys_user_device (
ID bigint(20) NOT NULL,
IMEI varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户设备IMEI号',
USER_ID bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
NETWORK_NUMBER varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入网号',
TARGET_ID varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步数据ID',
LAST_TIME timestamp(0) NULL DEFAULT NULL COMMENT '最后在线时间',
POSITION_LNG decimal(19, 8) NULL DEFAULT NULL COMMENT '经度',
POSITION_LAT decimal(19, 8) NULL DEFAULT NULL COMMENT '纬度',
DEVICE_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
TENANT_ID varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user_device
-- ----------------------------
-- ----------------------------
-- Table structure for upload_log
-- ----------------------------
DROP TABLE IF EXISTS upload_log;
CREATE TABLE upload_log (
id bigint(20) NULL DEFAULT NULL COMMENT '主键',
file_path varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径',
file_name varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
device_id bigint(20) NULL DEFAULT NULL COMMENT '设备ID',
create_id bigint(20) NULL DEFAULT NULL COMMENT '创建者ID'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '图片上传日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of upload_log
-- ----------------------------
INSERT INTO upload_log VALUES (1783011404882759682, '2024-04/42edc0eedfa54a3c8a63be0fd073fb76.png', NULL, '2024-04-24 05:53:40', 1, 1);
INSERT INTO upload_log VALUES (1789174408078958593, '2024-05\\9b06b839357d4b33a9bd92364cb772a2.jpeg', NULL, '2024-05-11 06:03:15', 1788491058556604418, 1);
-- ----------------------------
-- Table structure for voice_log
-- ----------------------------
DROP TABLE IF EXISTS voice_log;
CREATE TABLE voice_log (
id bigint(20) NULL DEFAULT NULL COMMENT '主键',
create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
voice_long varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '时长',
voice_url varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '音频文件',
voice_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广播名称',
group_id bigint(20) NULL DEFAULT NULL COMMENT '分组ID'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '历史广播记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of voice_log
-- ----------------------------
INSERT INTO voice_log VALUES (1781223352342462465, '2024-04-19 07:28:35', '2024-04-19 07:28:35', '1.36', 'http://111.198.10.15:22109/static/2024-04/5c56f170c2644c29bf38b78c16514eef.mp3', 'dddd', 1781133934470479874);
-- ----------------------------
-- Function structure for getAreaParentList
-- ----------------------------
DROP FUNCTION IF EXISTS getAreaParentList;
delimiter ;;
CREATE FUNCTION getAreaParentList(rootId integer)
RETURNS varchar(512) CHARSET utf8
NO SQL
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(1000);
SET sParentTemp =CAST(rootId AS CHAR);
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,',');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(PID) INTO sParentTemp FROM sys_area WHERE FIND_IN_SET(ID,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
-- ----------------------------
-- Function structure for getDeptPids
-- ----------------------------
DROP FUNCTION IF EXISTS getDeptPids;
delimiter ;;
CREATE FUNCTION getDeptPids(rootId VARCHAR(1000))
RETURNS varchar(1000) CHARSET utf8
NO SQL
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(1000);
SET sParentTemp =CAST(rootId AS CHAR);
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,'');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(PID) INTO sParentTemp FROM SYS_DEPT WHERE FIND_IN_SET(ID,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
-- ----------------------------
-- Function structure for getMenuParentCodes
-- ----------------------------
DROP FUNCTION IF EXISTS getMenuParentCodes;
delimiter ;;
CREATE FUNCTION getMenuParentCodes(rootId varchar(512))
RETURNS varchar(512) CHARSET utf8
READS SQL DATA
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(100);
SET sParentTemp =rootId ;
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,'');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(p_code) INTO sParentTemp FROM SYS_MENU WHERE FIND_IN_SET(CODE,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;
