/* Navicat Premium Data Transfer Source Server : 新网管 Source Server Type : MySQL Source Server Version : 50734 Source Host : 114.67.82.178:3306 Source Schema : iot_prison Target Server Type : MySQL Target Server Version : 50734 File Encoding : 65001 Date: 25/07/2022 16:52:30 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for qrtz_blob_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `BLOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `SCHED_NAME`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_calendars -- ---------------------------- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `CALENDAR_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_cron_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `CRON_EXPRESSION` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TIME_ZONE_ID` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_fired_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ENTRY_ID` varchar(95) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `INSTANCE_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `FIRED_TIME` bigint(13) NOT NULL, `SCHED_TIME` bigint(13) NOT NULL, `PRIORITY` int(11) NOT NULL, `STATE` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `JOB_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE, INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`(`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE, INDEX `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY`(`SCHED_NAME`, `INSTANCE_NAME`, `REQUESTS_RECOVERY`) USING BTREE, INDEX `IDX_QRTZ_FT_J_G`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_FT_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_FT_T_G`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `IDX_QRTZ_FT_TG`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_job_details -- ---------------------------- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `DESCRIPTION` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `IS_DURABLE` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `IS_NONCONCURRENT` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `IS_UPDATE_DATA` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `REQUESTS_RECOVERY` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME`, `REQUESTS_RECOVERY`) USING BTREE, INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_locks -- ---------------------------- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `LOCK_NAME` varchar(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_paused_trigger_grps -- ---------------------------- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_queue -- ---------------------------- DROP TABLE IF EXISTS `qrtz_queue`; CREATE TABLE `qrtz_queue` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT 'id', `job_id` int(8) NOT NULL COMMENT '任务id', `corn` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '表达式', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', `group_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '分组', `class_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '类名', `start_time` datetime(0) DEFAULT NULL COMMENT '生效开始时间', `end_time` datetime(0) DEFAULT NULL COMMENT '生效结束时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 212 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_scheduler_state -- ---------------------------- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `INSTANCE_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `LAST_CHECKIN_TIME` bigint(13) NOT NULL, `CHECKIN_INTERVAL` bigint(13) NOT NULL, PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_simple_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `REPEAT_COUNT` bigint(7) NOT NULL, `REPEAT_INTERVAL` bigint(12) NOT NULL, `TIMES_TRIGGERED` bigint(10) NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_simprop_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `STR_PROP_1` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `STR_PROP_2` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `STR_PROP_3` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `INT_PROP_1` int(11) DEFAULT NULL, `INT_PROP_2` int(11) DEFAULT NULL, `LONG_PROP_1` bigint(20) DEFAULT NULL, `LONG_PROP_2` bigint(20) DEFAULT NULL, `DEC_PROP_1` decimal(13, 4) DEFAULT NULL, `DEC_PROP_2` decimal(13, 4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `BOOL_PROP_2` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for qrtz_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `JOB_GROUP` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `DESCRIPTION` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, `PRIORITY` int(11) DEFAULT NULL, `TRIGGER_STATE` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `TRIGGER_TYPE` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `START_TIME` bigint(13) NOT NULL, `END_TIME` bigint(13) DEFAULT NULL, `CALENDAR_NAME` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `MISFIRE_INSTR` smallint(2) DEFAULT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `IDX_QRTZ_T_J`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_T_C`(`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE, INDEX `IDX_QRTZ_T_G`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME`, `TRIGGER_STATE`) USING BTREE, INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE, INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE, INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME`, `NEXT_FIRE_TIME`) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME`, `TRIGGER_STATE`, `NEXT_FIRE_TIME`) USING BTREE, INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_STATE`) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE, CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_alarm_event -- ---------------------------- DROP TABLE IF EXISTS `t_alarm_event`; CREATE TABLE `t_alarm_event` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `alarm_device_type` int(8) NOT NULL COMMENT '告警设备类型【数据字典表；ALARM_TYPE】', `alarm_event` int(8) NOT NULL COMMENT '告警事件【数据字典表；ALARM_EVENT】', `alarm_device_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警设备编号', `alarm_device_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警设备名称', `alarm_time` datetime(0) NOT NULL COMMENT '告警时间', `alarm_cause` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '告警原因', `online` int(1) DEFAULT NULL COMMENT '是否在线【1：在线，2：离线】', `alarm_source` int(1) DEFAULT NULL COMMENT '告警来源【1：设备推送。2：内部ping】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备告警事件表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_alarm_statistics -- ---------------------------- DROP TABLE IF EXISTS `t_alarm_statistics`; CREATE TABLE `t_alarm_statistics` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `alarm_device_type` int(8) NOT NULL COMMENT '告警设备类型【数据字典表；ALARM_TYPE】', `alarm_time` datetime(0) NOT NULL COMMENT '告警时间', `num` int(8) DEFAULT NULL COMMENT '告警数量', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_device -- ---------------------------- DROP TABLE IF EXISTS `t_device`; CREATE TABLE `t_device` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `device_type` int(8) NOT NULL COMMENT '设备类型【数据字典表；DEVICE_TYPE】', `device_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备编号', `device_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备名称', `device_brand` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备品牌', `device_model` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备型号', `device_ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备ip', `install_position` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备安装位置', `network_access_time` datetime(0) DEFAULT NULL COMMENT '设备入网时间', `maintenance_input_year` int(3) DEFAULT NULL COMMENT '维保其他输入年', `is_online` int(1) DEFAULT 1 COMMENT '是否在线【1：在线。2：离线】', `maintenance_time` int(8) DEFAULT NULL COMMENT '维保时间【数据字典表:WB_TIME】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_devops_tool -- ---------------------------- DROP TABLE IF EXISTS `t_devops_tool`; CREATE TABLE `t_devops_tool` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `ip_address` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ip地址', `result` int(1) NOT NULL COMMENT '结果【1：通过，2：未通过】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 276 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '运维工具表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_dict -- ---------------------------- DROP TABLE IF EXISTS `t_dict`; CREATE TABLE `t_dict` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `dict_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典名称', `dict_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典值', `dict_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典类型表编码', `dict_sub_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '数据字典编码', `dict_type_id` int(8) DEFAULT NULL COMMENT '数据字典类型表id', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据字典' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_dict_type -- ---------------------------- DROP TABLE IF EXISTS `t_dict_type`; CREATE TABLE `t_dict_type` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `dict_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典编码', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据字典类型' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_menu -- ---------------------------- DROP TABLE IF EXISTS `t_menu`; CREATE TABLE `t_menu` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `menu_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单组件', `redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '重定向', `menu_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单地址', `menu_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单编码', `menu_auth` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单权限（后端）', `order` int(2) DEFAULT NULL COMMENT '菜单顺序', `meta` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '基础属性', `hidden` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否显示', `parent_key` int(8) NOT NULL COMMENT '所属上级', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_model_config -- ---------------------------- DROP TABLE IF EXISTS `t_model_config`; CREATE TABLE `t_model_config` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `work_order_timeout` datetime(0) DEFAULT NULL COMMENT '工单超时时间', `event_max_day` int(5) DEFAULT NULL COMMENT '事件阈值设置：天数', `event_max_second` int(5) DEFAULT NULL COMMENT '事件阈值设置：次数', `alarm_chain_over` double(3, 2) DEFAULT NULL COMMENT '告警环比增长超过', `alarm_same_scale_over` double(3, 2) DEFAULT NULL COMMENT '告警同比增长超过', `high_incorrect_max_day` int(5) DEFAULT NULL COMMENT '高频故障阈值设置：天数', `high_incorrect_max_second` int(5) DEFAULT NULL COMMENT '高频故障阈值设置：次数', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '智能分析模型配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_patrol_plan -- ---------------------------- DROP TABLE IF EXISTS `t_patrol_plan`; CREATE TABLE `t_patrol_plan` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `plan_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '计划名称', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注说明', `start_time` datetime(0) NOT NULL COMMENT '生效开始时间', `end_time` datetime(0) NOT NULL COMMENT '生效结束时间', `is_enable` int(1) NOT NULL COMMENT '是否启用；【1：启用，2：禁用】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '巡检时间点', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检计划表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_patrol_record_detail -- ---------------------------- DROP TABLE IF EXISTS `t_patrol_record_detail`; CREATE TABLE `t_patrol_record_detail` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `patrol_id` int(8) NOT NULL COMMENT '巡检计划表id', `device_code` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备编号', `device_name` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备名称', `device_type` int(4) NOT NULL COMMENT '数据字典表id', `status` int(1) DEFAULT NULL COMMENT '在线离线状态【1：在线，2：离线】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检计划明细表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_patrol_record_log -- ---------------------------- DROP TABLE IF EXISTS `t_patrol_record_log`; CREATE TABLE `t_patrol_record_log` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `patrol_id` int(8) NOT NULL COMMENT '巡检计划表id', `patrol_plan_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '巡检计划名', `fail_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '失败原因', `status` int(1) NOT NULL COMMENT '巡检状态【1：执行中，2：执行结束】', `start_time` datetime(0) DEFAULT NULL COMMENT '执行的开始时间', `end_time` datetime(0) DEFAULT NULL COMMENT '执行的结束时间', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检计划日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_patrol_record_state -- ---------------------------- DROP TABLE IF EXISTS `t_patrol_record_state`; CREATE TABLE `t_patrol_record_state` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `patrol_id` int(8) NOT NULL COMMENT '日志id', `executed_num` int(5) NOT NULL COMMENT '已执行数量', `online_num` int(5) NOT NULL COMMENT '在线数量', `offline_num` int(5) NOT NULL COMMENT '离线数量', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', `device_type` int(8) DEFAULT NULL COMMENT '设备类型', `device_total` int(4) DEFAULT NULL COMMENT '设备总数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检计划状况表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_patrol_relation_date -- ---------------------------- DROP TABLE IF EXISTS `t_patrol_relation_date`; CREATE TABLE `t_patrol_relation_date` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `patrol_id` int(8) NOT NULL COMMENT '巡检计划表id', `patrol_date` int(1) NOT NULL COMMENT '【1：周一，2：周二，3：周三，4：周四，5：周五，6：周六，7：周日，8：全天】配置到数据字典WEEK_DAY', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 440 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检计划日期表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_role -- ---------------------------- DROP TABLE IF EXISTS `t_role`; CREATE TABLE `t_role` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称', `role_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编号', `order_no` int(3) NOT NULL COMMENT '顺序', `describe_info` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '描述', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_role_menu -- ---------------------------- DROP TABLE IF EXISTS `t_role_menu`; CREATE TABLE `t_role_menu` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `role_id` int(8) NOT NULL COMMENT '角色主键', `menu_id` int(8) NOT NULL COMMENT '菜单主键', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 399 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名', `account` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号', `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `salt` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '盐', `mobile_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', `status` int(1) NOT NULL COMMENT '【1：启动，2：禁用】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `account`(`account`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_role -- ---------------------------- DROP TABLE IF EXISTS `t_user_role`; CREATE TABLE `t_user_role` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `role_id` int(8) NOT NULL COMMENT '角色主键', `user_id` int(8) NOT NULL COMMENT '用户主键', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_work_order -- ---------------------------- DROP TABLE IF EXISTS `t_work_order`; CREATE TABLE `t_work_order` ( `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键id', `order_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工单编号', `event_type` int(8) NOT NULL COMMENT '事件类型【数据字典表；ALARM_TYPE】', `device_type` int(8) NOT NULL COMMENT '设备类型【数据字典DEVICE_TYPE】', `alarm_level` int(1) NOT NULL COMMENT '告警级别【1：紧急2：重要，3：提醒】', `device_code` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '故障设备编号', `device_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '故障设备名称', `fault_time` datetime(0) NOT NULL COMMENT '故障时间', `fault_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '故障原因', `result` int(1) DEFAULT 1 COMMENT '处理结果【1：待处理，2：已处理，3：已忽略】', `create_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人', `modify_by` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `modify_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `handler` int(4) DEFAULT NULL COMMENT '处理人', `handler_time` datetime(0) DEFAULT NULL COMMENT '处理时间', `logic_del` int(1) DEFAULT 0 COMMENT '0:未删除，1：已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 203 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- View structure for generator10 -- ---------------------------- DROP VIEW IF EXISTS `generator10`; CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINER VIEW `generator10` AS select 0 AS `n` union all select 1 AS `1` union all select 2 AS `2` union all select 3 AS `3` union all select 4 AS `4` union all select 5 AS `5` union all select 6 AS `6` union all select 7 AS `7` union all select 8 AS `8` union all select 9 AS `9`; SET FOREIGN_KEY_CHECKS = 1;