create database userinfo charset="utf-8";
use userinfo;
create table it user info(
ui_user_id bigint auto_increment comment ‘用户ID',
ui_name varchar(64) not null comment ‘用户名’,
ui_passwd varchar(128) not null comment '密码’,
ui_age int null comment '年龄’,
ui_mobile char(11) not null comment '手机号',
ui avatar varchar(128) null comment '头像’,
ui_ctime datetime not null default current_timestamp comment '创建时间’，
ui.utime datetime not null default current_timestamp on
update current_timestamp comment '更新',
primary key (ui_user_id),
unique (ui_mobile),
) engine=InnoDB default charset=utf8 comment '用户表';
/*==============================================================*/
/* Database name: jysxdb */
/* DBMS name: MySQL 5.0 */
/* Created on: 2017/10/31 9:40:45 */
/*==============================================================*/
drop database if exists jysxdb;
/*==============================================================*/
/* Database: jysxdb */
/*==============================================================*/
set names utf8;
create database jysxdb;
use jysxdb;
/*==============================================================*/
/* Table: cabinets */
/*==============================================================*/
create table cabinets
(
cabinet_id int not null auto_increment comment '机柜编号',
sector_id int not null comment '机柜所属单位的编号',
cabinet_addtime bigint not null default 0 comment '机柜加入系统的时间',
cabinet_state int not null default 0 comment '机柜状态
0：可用
1：不可用',
cabinet_name varchar(100) not null default '' comment '机柜名称，机柜的别名方便管理和查看',
cabinet_rfid varchar(50) not null default '' comment '机柜的唯一射频码，也是机柜的唯一标识',
cabinet_cip varchar(50) not null default '' comment '机柜内IP摄像头的IP地址',
cabinet_cport varchar(50) not null default '' comment '机柜内IP摄像头的端口号',
cabinet_cuser varchar(50) not null default '' comment '机柜内置摄像头用户名',
cabinet_cpasswd varchar(50) not null default '' comment 'IP摄像头登录密码',
cabinet_ip varchar(50) not null default '' comment '机柜控制主机的IP地址',
cabinet_port varchar(50) not null default '' comment '机柜控制主机的端口号',
cabinet_imgpath varchar(255) not null default '' comment '开门牌照的图片存储路径，保存相对路径，不包含主项目名称，如：
img/upload/10/',
cabinet_heartrate bigint not null default 0 comment '机柜心跳包时间戳，机柜每隔30秒上传心跳包，收到心跳包则刷新此字段，若超过40秒没有收到新的心跳包则判定当前机柜断网，采集端模拟机柜生成外网异常报警信息',
cabinet_message text not null comment '机柜备注及描述信息',
primary key (cabinet_id)
)
auto_increment=1000
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table cabinets comment '机柜表，保存所有机柜的信息,新增机柜时需要通知数据采集服务器刷新机柜列表，并在currentdatas表中新增该机柜对应';
alter table cabinets
add unique ak_key_2 (cabinet_rfid);
alter table cabinets
add unique ak_key_3 (cabinet_cip, cabinet_cport);
alter table cabinets
add unique ak_key_4 (cabinet_ip, cabinet_port);
/*==============================================================*/
/* Table: currentdatas */
/*==============================================================*/
create table currentdatas
(
currdata_id int not null auto_increment comment '数据编号',
currdata_time bigint not null default 0 comment '时间戳',
cabinet_id int comment '机柜编号',
dataitem_id int comment '数据项编号',
dstate_id int not null comment '数据项状态编号，表示当前记录的含义',
currdata_data varchar(100) not null default '' comment '数据内容
如果是温度或者湿度等有具体值的数字量则插入具体的数据
其他状态量时此字段为空
例如
温度25.8度则直接插入25.8
默认为空字符串',
currdata_state int not null default 0 comment '处理状态，表示当前记录的处理状态
0：不用处理
1：表示需要处理但未处理
2：表示已处理',
primary key (currdata_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table currentdatas comment '保存当前最新数据';
/*==============================================================*/
/* Table: dataitems */
/*==============================================================*/
create table dataitems
(
dataitem_id int not null auto_increment comment '编号',
dataitem_name varchar(30) not null default '' comment '名称',
dataitem_charttype int not null default 0 comment '页面图表类型
-1：不显示
0：曲线图
1：分组柱状图',
dataitem_unit varchar(15) not null default '' comment '数据单位符号，如温度符号℃,湿度单位%',
dataitem_priority int not null default 10000 comment '数据项优先级，
机柜缩略图中按照优先级显示图标，
数字越小优先级越高，
0最高',
primary key (dataitem_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table dataitems comment '数据项表，保存机柜上传的所有数据项相关内容';
/*==============================================================*/
/* Table: dataitemstates */
/*==============================================================*/
create table dataitemstates
(
dstate_id int not null auto_increment comment '数据项状态值编号',
dataitem_id int not null comment '数据项编号，标识当前状态属于哪个数据项',
dstate_value int not null comment '状态值
-1表示数据项初始化状态，数据字段显示为''--''
0表示正常，大于0的整数表示不同的状态
例如0正常，1温度过高，2温度过低',
dstate_islog int not null default 0 comment 'log选项，表示当前状态是否出现在系统日志中',
dstate_option int not null default 0 comment '当前数据项状态应执行的操作
0：不做任何操作
1：报警
其他：未定义',
dstate_text varchar(100) not null comment '当前状态的含义',
primary key (dstate_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table dataitemstates comment '数据项状态表，描述所有数据项的状态及含义';
/*==============================================================*/
/* Table: functions */
/*==============================================================*/
create table functions
(
function_id int not null auto_increment comment '功能ID：function_id',
function_name varchar(50) not null default '' comment '功能名称：function_name',
primary key (function_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table functions comment '系统功能表，描述系统中不同的功能模块，用于设置用户对该模块是否有操作权限。';
/*==============================================================*/
/* Table: permissions */
/*==============================================================*/
create table permissions
(
perm_id int not null auto_increment comment '权限编号',
user_id int not null comment '用户编号',
function_id int not null comment '功能编号，表示用户可以使用的功能',
sector_id int not null default 0 comment '单位编号，0表示对所有单位有操作权限，其他值来源与单位表主键列',
primary key (perm_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table permissions comment '用户权限表';
/*==============================================================*/
/* Table: savedatas */
/*==============================================================*/
create table savedatas
(
savedata_id int not null auto_increment comment '数据编号',
savedata_time bigint not null default 0 comment '时间戳',
cabinet_id int comment '机柜编号',
dataitem_id int comment '数据项编号',
dstate_id int not null comment '当前数据项状态编号，表示当前数据的内容',
savedata_data varchar(100) not null default '' comment '数据内容
如果是温度或者湿度等有具体值的数字量则插入具体的数据
其他状态量时此字段为空
例如
温度25.8度则直接插入25.8',
primary key (savedata_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table savedatas comment '当前数据表';
/*==============================================================*/
/* Index: index_1 */
/*==============================================================*/
create index index_1 on savedatas
(
savedata_time
);
/*==============================================================*/
/* Table: sectors */
/*==============================================================*/
create table sectors
(
sector_id int not null auto_increment comment '单位编号',
sector_name varchar(50) not null default '' comment '单位名称',
sector_pid int not null default 0 comment '上级单位编号',
primary key (sector_id)
)
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table sectors comment '单位表，保存整个机构的各级单文名称及隶属关系';
/*==============================================================*/
/* Table: userinfo */
/*==============================================================*/
create table userinfo
(
user_id int not null auto_increment comment '用户编号：user_id',
user_name varchar(50) not null default '' comment '用户名：user_name',
user_password varchar(100) not null default '' comment '密码：user_password',
user_realname varchar(30) not null default '' comment '真实姓名：user_realname',
user_gender int not null default 0 comment '性别，0男，1女',
sector_id int not null comment '所在单位编号：sector_id',
user_dept varchar(100) not null default '' comment '所在部门：user_department',
user_title varchar(100) not null default '' comment '职位',
user_state int not null default 0 comment '用户状态：user_state
0：可用
1：不可用',
user_message text not null comment '备注：user_message',
primary key (user_id)
)
auto_increment=1000
engine = innodb
default character set = utf8
collate = utf8_bin;
alter table userinfo comment '用户信息表';
alter table userinfo
add unique ak_key_2 (user_name);
alter table cabinets add constraint fk_reference_2 foreign key (sector_id)
references sectors (sector_id) on delete restrict on update restrict;
alter table currentdatas add constraint fk_reference_10 foreign key (cabinet_id)
references cabinets (cabinet_id) on delete restrict on update restrict;
alter table currentdatas add constraint fk_reference_11 foreign key (dstate_id)
references dataitemstates (dstate_id) on delete restrict on update restrict;
alter table currentdatas add constraint fk_reference_13 foreign key (dataitem_id)
references dataitems (dataitem_id) on delete restrict on update restrict;
alter table dataitemstates add constraint fk_reference_8 foreign key (dataitem_id)
references dataitems (dataitem_id) on delete restrict on update restrict;
alter table permissions add constraint fk_reference_5 foreign key (function_id)
references functions (function_id) on delete restrict on update restrict;
alter table permissions add constraint fk_reference_7 foreign key (user_id)
references userinfo (user_id) on delete restrict on update restrict;
alter table savedatas add constraint fk_reference_12 foreign key (dataitem_id)
references dataitems (dataitem_id) on delete restrict on update restrict;
alter table savedatas add constraint fk_reference_4 foreign key (cabinet_id)
references cabinets (cabinet_id) on delete restrict on update restrict;
alter table savedatas add constraint fk_reference_9 foreign key (dstate_id)
references dataitemstates (dstate_id) on delete restrict on update restrict;
alter table userinfo add constraint fk_reference_1 foreign key (sector_id)
references sectors (sector_id) on delete restrict on update restrict;
INSERT INTO `functions` VALUES (1, '系统管理');
INSERT INTO `functions` VALUES (2, '管辖单位查看管理');
-- create user 'jysx'@'%' identified by 'briup';
grant all on jysxdb.* to 'jysx'@'%';
USE JYSXDB;
SET NAMES UTF8;
/*创建地区数据*/
-- 先降低安全等级
SET SQL_SAFE_UPDATES = 0;
DELETE FROM SECTORS WHERE 1;
INSERT INTO `sectors` VALUES (1, '江苏省', 0);
INSERT INTO `sectors` VALUES (2, '南京市', 1);
INSERT INTO `sectors` VALUES (3, '无锡市', 1);
INSERT INTO `sectors` VALUES (4, '徐州市', 1);
INSERT INTO `sectors` VALUES (5, '常州市', 1);
INSERT INTO `sectors` VALUES (6, '苏州市', 1);
INSERT INTO `sectors` VALUES (7, '南通市', 1);
INSERT INTO `sectors` VALUES (8, '连云港市', 1);
INSERT INTO `sectors` VALUES (9, '淮安市', 1);
INSERT INTO `sectors` VALUES (10, '盐城市', 1);
INSERT INTO `sectors` VALUES (11, '扬州市', 1);
INSERT INTO `sectors` VALUES (12, '镇江市', 1);
INSERT INTO `sectors` VALUES (13, '泰州市', 1);
INSERT INTO `sectors` VALUES (14, '宿迁市', 1);
INSERT INTO `sectors` VALUES (15, '江苏铁路', 1);
INSERT INTO `sectors` VALUES (16, '玄武区', 2);
INSERT INTO `sectors` VALUES (17, '秦淮区', 2);
INSERT INTO `sectors` VALUES (18, '建邺区', 2);
INSERT INTO `sectors` VALUES (19, '鼓楼区', 2);
INSERT INTO `sectors` VALUES (20, '浦口区', 2);
INSERT INTO `sectors` VALUES (21, '栖霞区', 2);
INSERT INTO `sectors` VALUES (22, '雨花台区', 2);
INSERT INTO `sectors` VALUES (23, '江宁区', 2);
INSERT INTO `sectors` VALUES (24, '六合区', 2);
INSERT INTO `sectors` VALUES (25, '溧水区', 2);
INSERT INTO `sectors` VALUES (26, '高淳区', 2);
INSERT INTO `sectors` VALUES (27, '梁溪区', 3);
INSERT INTO `sectors` VALUES (28, '湖滨区', 3);
INSERT INTO `sectors` VALUES (29, '高新区', 3);
INSERT INTO `sectors` VALUES (30, '锡山区', 3);
INSERT INTO `sectors` VALUES (31, '惠山区', 3);
INSERT INTO `sectors` VALUES (32, '江阴市', 3);
INSERT INTO `sectors` VALUES (33, '宜兴市', 3);
INSERT INTO `sectors` VALUES (34, '云龙区', 4);
INSERT INTO `sectors` VALUES (35, '鼓楼区', 4);
INSERT INTO `sectors` VALUES (36, '贾汪区', 4);
INSERT INTO `sectors` VALUES (37, '泉山区', 4);
INSERT INTO `sectors` VALUES (38, '铜山区', 4);
INSERT INTO `sectors` VALUES (39, '丰县', 4);
INSERT INTO `sectors` VALUES (40, '沛县', 4);
INSERT INTO `sectors` VALUES (41, '睢宁县', 4);
INSERT INTO `sectors` VALUES (42, '邳州市', 4);
INSERT INTO `sectors` VALUES (43, '新沂市', 4);
INSERT INTO `sectors` VALUES (44, '经济技术开发区', 4);
INSERT INTO `sectors` VALUES (45, '天宁区', 5);
INSERT INTO `sectors` VALUES (46, '钟楼区', 5);
INSERT INTO `sectors` VALUES (47, '新北区', 5);
INSERT INTO `sectors` VALUES (48, '武进区', 5);
INSERT INTO `sectors` VALUES (49, '金坛区', 5);
INSERT INTO `sectors` VALUES (50, '溧阳市', 5);
INSERT INTO `sectors` VALUES (51, '天目湖地区', 5);
INSERT INTO `sectors` VALUES (52, '经济开发区', 5);
INSERT INTO `sectors` VALUES (53, '姑苏区', 6);
INSERT INTO `sectors` VALUES (54, '虎丘区', 6);
INSERT INTO `sectors` VALUES (55, '吴中区', 6);
INSERT INTO `sectors` VALUES (56, '相城区', 6);
INSERT INTO `sectors` VALUES (57, '吴江区', 6);
INSERT INTO `sectors` VALUES (58, '张家港市', 6);
INSERT INTO `sectors` VALUES (59, '昆山市', 6);
INSERT INTO `sectors` VALUES (60, '太仓市', 6);
INSERT INTO `sectors` VALUES (61, '常熟市', 6);
INSERT INTO `sectors` VALUES (62, '工业园区', 6);
INSERT INTO `sectors` VALUES (63, '崇川区', 7);
INSERT INTO `sectors` VALUES (64, '港闸区', 7);
INSERT INTO `sectors` VALUES (65, '通州区', 7);
INSERT INTO `sectors` VALUES (66, '海安区', 7);
INSERT INTO `sectors` VALUES (67, '如东县', 7);
INSERT INTO `sectors` VALUES (68, '如皋市', 7);
INSERT INTO `sectors` VALUES (69, '海门市', 7);
INSERT INTO `sectors` VALUES (70, '启东市', 7);
INSERT INTO `sectors` VALUES (71, '经济技术开发区', 7);
INSERT INTO `sectors` VALUES (72, '东海县', 8);
INSERT INTO `sectors` VALUES (73, '灌云县', 8);
INSERT INTO `sectors` VALUES (74, '灌南县', 8);
INSERT INTO `sectors` VALUES (75, '赣榆区', 8);
INSERT INTO `sectors` VALUES (76, '海州区', 8);
INSERT INTO `sectors` VALUES (77, '连云区', 8);
INSERT INTO `sectors` VALUES (78, '清江浦区', 9);
INSERT INTO `sectors` VALUES (79, '淮安区', 9);
INSERT INTO `sectors` VALUES (80, '淮阴区', 9);
INSERT INTO `sectors` VALUES (81, '洪泽区', 9);
INSERT INTO `sectors` VALUES (82, '涟水县', 9);
INSERT INTO `sectors` VALUES (83, '盱眙县', 9);
INSERT INTO `sectors` VALUES (84, '金湖县', 9);
INSERT INTO `sectors` VALUES (85, '开发区', 9);
INSERT INTO `sectors` VALUES (86, '亭湖区', 10);
INSERT INTO `sectors` VALUES (87, '盐都区', 10);
INSERT INTO `sectors` VALUES (88, '大丰区', 10);
INSERT INTO `sectors` VALUES (89, '滨海县', 10);
INSERT INTO `sectors` VALUES (90, '射阳县', 10);
INSERT INTO `sectors` VALUES (91, '阜宁县', 10);
INSERT INTO `sectors` VALUES (92, '建湖县', 10);
INSERT INTO `sectors` VALUES (93, '响水县', 10);
INSERT INTO `sectors` VALUES (94, '东台市', 10);
INSERT INTO `sectors` VALUES (95, '经济技术开发区', 10);
INSERT INTO `sectors` VALUES (96, '大中地区', 10);
INSERT INTO `sectors` VALUES (97, '广陵区', 11);
INSERT INTO `sectors` VALUES (98, '邗江区', 11);
INSERT INTO `sectors` VALUES (99, '江都区', 11);
INSERT INTO `sectors` VALUES (100, '经济技术开发区', 11);
INSERT INTO `sectors` VALUES (101, '宝应县', 11);
INSERT INTO `sectors` VALUES (102, '仪征市', 11);
INSERT INTO `sectors` VALUES (103, '高邮市', 11);
INSERT INTO `sectors` VALUES (104, '京口区', 12);
INSERT INTO `sectors` VALUES (105, '润州区', 12);
INSERT INTO `sectors` VALUES (106, '丹徒区', 12);
INSERT INTO `sectors` VALUES (107, '丹阳市', 12);
INSERT INTO `sectors` VALUES (108, '扬中市', 12);
INSERT INTO `sectors` VALUES (109, '句容市', 12);
INSERT INTO `sectors` VALUES (110, '金山地区', 12);
INSERT INTO `sectors` VALUES (111, '经济开发区', 12);
INSERT INTO `sectors` VALUES (112, '海陵区', 13);
INSERT INTO `sectors` VALUES (113, '高港区', 13);
INSERT INTO `sectors` VALUES (114, '姜堰区', 13);
INSERT INTO `sectors` VALUES (115, '兴化市', 13);
INSERT INTO `sectors` VALUES (116, '泰兴市', 13);
INSERT INTO `sectors` VALUES (117, '靖江市', 13);
INSERT INTO `sectors` VALUES (118, '医药高新', 13);
INSERT INTO `sectors` VALUES (119, '宿城区', 14);
INSERT INTO `sectors` VALUES (120, '宿豫区', 14);
INSERT INTO `sectors` VALUES (121, '沭阳县', 14);
INSERT INTO `sectors` VALUES (122, '泗阳县', 14);
INSERT INTO `sectors` VALUES (123, '泗洪县', 14);
INSERT INTO `sectors` VALUES (124, '洪泽湖地区', 14);
INSERT INTO `sectors` VALUES (125, '南京铁路', 15);
INSERT INTO `sectors` VALUES (126, '徐州铁路', 15);
/*新增数据项*/
DELETE FROM `dataitems` WHERE 1;
INSERT INTO `dataitems` VALUES (1, '故障', -1, '', 10000);
INSERT INTO `dataitems` VALUES (2, '温度', 0, '℃', 10);
INSERT INTO `dataitems` VALUES (3, '湿度', 0, '%', 11);
INSERT INTO `dataitems` VALUES (4, '振动', 1, '', 2);
INSERT INTO `dataitems` VALUES (5, '主电源', 1, '', 3);
INSERT INTO `dataitems` VALUES (6, '备电源', 1, '', 4);
INSERT INTO `dataitems` VALUES (7, 'UPS', 1, '', 5);
INSERT INTO `dataitems` VALUES (8, '烟雾', 1, '', 8);
INSERT INTO `dataitems` VALUES (9, '门状态', 1, '', 0);
INSERT INTO `dataitems` VALUES (10, '锁状态', 1, '', 1);
INSERT INTO `dataitems` VALUES (11, '漏磁', 1, '', 9);
INSERT INTO `dataitems` VALUES (12, '内网', 1, '', 6);
INSERT INTO `dataitems` VALUES (13, '外网', 1, '', 7);
/*新增数据项状态*/
DELETE FROM `dataitemstates` WHERE 1;
INSERT INTO `dataitemstates` VALUES (1, 1, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (2, 1, 1, 0, 1, '多异常并存');
INSERT INTO `dataitemstates` VALUES (3, 1, 2, 0, 1, '外网异常');
INSERT INTO `dataitemstates` VALUES (4, 1, 3, 0, 1, '内网异常');
INSERT INTO `dataitemstates` VALUES (5, 1, 4, 0, 1, '温湿传感器异常');
INSERT INTO `dataitemstates` VALUES (6, 1, 5, 0, 1, '高温异常');
INSERT INTO `dataitemstates` VALUES (7, 1, 6, 0, 1, '低温异常');
INSERT INTO `dataitemstates` VALUES (8, 1, 7, 0, 1, '高湿异常');
INSERT INTO `dataitemstates` VALUES (9, 1, 8, 0, 1, '低湿异常');
INSERT INTO `dataitemstates` VALUES (10, 1, 9, 0, 1, '振动异常');
INSERT INTO `dataitemstates` VALUES (11, 1, 10, 0, 1, '烟雾异常');
INSERT INTO `dataitemstates` VALUES (12, 1, 11, 0, 1, '门锁故障');
INSERT INTO `dataitemstates` VALUES (13, 1, 12, 0, 1, '漏磁故障');
INSERT INTO `dataitemstates` VALUES (14, 1, 13, 0, 1, '主电故障');
INSERT INTO `dataitemstates` VALUES (15, 1, 14, 0, 1, '备电故障');
INSERT INTO `dataitemstates` VALUES (16, 1, 15, 0, 1, 'UPS故障');
INSERT INTO `dataitemstates` VALUES (17, 2, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (18, 2, 1, 1, 1, '高温');
INSERT INTO `dataitemstates` VALUES (19, 2, 2, 1, 1, '低温');
INSERT INTO `dataitemstates` VALUES (20, 3, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (21, 3, 1, 1, 1, '高湿');
INSERT INTO `dataitemstates` VALUES (22, 3, 2, 1, 1, '低湿');
INSERT INTO `dataitemstates` VALUES (23, 4, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (24, 4, 1, 1, 1, '异常');
INSERT INTO `dataitemstates` VALUES (25, 5, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (26, 5, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (27, 6, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (28, 6, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (29, 7, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (30, 7, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (31, 8, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (32, 8, 1, 1, 1, '异常');
INSERT INTO `dataitemstates` VALUES (33, 9, 0, 0, 0, '关闭');
INSERT INTO `dataitemstates` VALUES (34, 9, 1, 1, 1, '未关');
INSERT INTO `dataitemstates` VALUES (35, 10, 0, 0, 0, '关闭');
INSERT INTO `dataitemstates` VALUES (36, 10, 1, 1, 1, '开锁');
INSERT INTO `dataitemstates` VALUES (37, 11, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (38, 11, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (39, 12, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (40, 12, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (41, 13, 0, 0, 0, '正常');
INSERT INTO `dataitemstates` VALUES (42, 13, 1, 1, 1, '故障');
INSERT INTO `dataitemstates` VALUES (43, 2, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (44, 3, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (45, 4, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (46, 5, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (47, 6, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (48, 7, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (49, 8, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (50, 9, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (51, 10, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (52, 11, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (53, 12, -1, 0, 0, '--');
INSERT INTO `dataitemstates` VALUES (54, 13, -1, 0, 0, '--');
/*新增系统功能模块*/
DELETE FROM `functions` WHERE 1;
INSERT INTO `functions`(`function_id`,`function_name`)
VALUES (1,'系统管理'),(2,'管辖单位查看管理');
/*初始化新增系统管理员相关信息：个人信息、权限管理，用户名admin,密码是admin123*/
DELETE FROM `userinfo` WHERE 1;
INSERT INTO `userinfo`(`user_id`,`user_name`,`user_password`,`user_realname`,`sector_id`,`user_dept`,`user_title`,`user_state`,`user_message`,`user_gender`)
VALUES (1,'admin','*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C','系统管理员',1,'江苏省','系统管理员',0,'',0);
DELETE FROM `permissions` WHERE 1;
INSERT INTO `permissions`(`perm_id`,`user_id`,`function_id`,`sector_id`) VALUES (1,1,1,0),(2,1,2,0);
-- 恢复安全等级
SET SQL_SAFE_UPDATES = 1;
INSERT INTO `cabinets` VALUES (1, 1, 0, 0, '测试1号', '1234567890abc', '10.0.6.5', '554', 'birup','briup','10.0.6.5', '9527', '01/',0, 'briup测试1号');
INSERT INTO `cabinets` VALUES (2, 1, 0, 0, '测试2号', '1234567890def', '10.0.6.5', '555', 'birup','briup','10.0.6.6', '9527', '02/',0, 'briup测试2号');
INSERT INTO `currentdatas` VALUES (1, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 1, 1, '', 0);
INSERT INTO `currentdatas` VALUES (2, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 2, 17, '2560', 0);
INSERT INTO `currentdatas` VALUES (3, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 3, 18, '4500', 0);
INSERT INTO `currentdatas` VALUES (4, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 4, 19, '', 0);
INSERT INTO `currentdatas` VALUES (5, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 5, 21, '', 0);
INSERT INTO `currentdatas` VALUES (6, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 6, 23, '', 0);
INSERT INTO `currentdatas` VALUES (7, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 7, 25, '', 0);
INSERT INTO `currentdatas` VALUES (8, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 8, 27, '', 0);
INSERT INTO `currentdatas` VALUES (9, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 9, 29, '', 0);
INSERT INTO `currentdatas` VALUES (10, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 10,31, '', 0);
INSERT INTO `currentdatas` VALUES (11, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 11,33, '', 0);
INSERT INTO `currentdatas` VALUES (12, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 12,35, '', 0);
INSERT INTO `currentdatas` VALUES (13, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 1, 13,37, '', 0);
INSERT INTO `currentdatas` VALUES (14, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 1, 1 ,'', 0);
INSERT INTO `currentdatas` VALUES (15, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 2, 17,'2560', 0);
INSERT INTO `currentdatas` VALUES (16, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 3, 18,'4500', 0);
INSERT INTO `currentdatas` VALUES (17, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 4, 19,'', 0);
INSERT INTO `currentdatas` VALUES (18, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 5, 21,'', 0);
INSERT INTO `currentdatas` VALUES (19, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 6, 23,'', 0);
INSERT INTO `currentdatas` VALUES (20, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 7, 25,'', 0);
INSERT INTO `currentdatas` VALUES (21, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 8, 27,'', 0);
INSERT INTO `currentdatas` VALUES (22, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 9, 29,'', 0);
INSERT INTO `currentdatas` VALUES (23, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 10,31, '', 0);
INSERT INTO `currentdatas` VALUES (24, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 11,33, '', 0);
INSERT INTO `currentdatas` VALUES (25, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 12,35, '', 0);
INSERT INTO `currentdatas` VALUES (26, UNIX_TIMESTAMP('2017-09-11 17:33:59'), 2, 13,37, '', 0);
备份地址: 【sql】