/*
Navicat MariaDB Data Transfer
Source Server : archives
Source Server Version : 100032
Source Host : 192.168.1.92:3307
Source Database : archives_save
Target Server Type : MariaDB
Target Server Version : 100032
File Encoding : 65001
Date: 2018-04-13 10:57:32
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for save_backups_offline
-- ----------------------------
DROP TABLE IF EXISTS `save_backups_offline`;
CREATE TABLE `save_backups_offline` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备份说明',
`create_time` datetime DEFAULT NULL COMMENT '经办时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '经办人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`backups_mode` varchar(20) DEFAULT NULL COMMENT '备份方式',
`backups_batch` varchar(50) DEFAULT NULL COMMENT '批次',
`backups_capacity` varchar(20) DEFAULT NULL COMMENT '每份备份大小 ',
`security_classification` varchar(20) DEFAULT NULL COMMENT '涉密情况',
`connect_tab` varchar(50) DEFAULT NULL COMMENT '交接表',
`leader_audit` int(1) DEFAULT NULL COMMENT '领导审核',
`rate_progress` int(1) DEFAULT NULL COMMENT '进度',
`medium` varchar(20) DEFAULT NULL COMMENT '备份介质',
`num` varchar(20) DEFAULT NULL COMMENT '备份套数',
`label` tinyint(10) DEFAULT NULL COMMENT '是否生成目录',
`backups_offline_tab` varchar(50) DEFAULT NULL COMMENT '离线备份表名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='离线备份表';
-- ----------------------------
-- Records of save_backups_offline
-- ----------------------------
INSERT INTO `save_backups_offline` VALUES ('29', '', '', '2018-04-13 02:47:47', 'admin', null, null, null, null, '34', '434', '4', '43', '34', 'fd', '3', null, '1523587667162');
-- ----------------------------
-- Table structure for save_backups_online
-- ----------------------------
DROP TABLE IF EXISTS `save_backups_online`;
CREATE TABLE `save_backups_online` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`backups_period` int(10) DEFAULT NULL COMMENT '备份周期',
`backups_status` varchar(20) DEFAULT NULL COMMENT '备份状态',
`exception` varchar(255) NOT NULL COMMENT '异常说明',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='在线备份表';
-- ----------------------------
-- Records of save_backups_online
-- ----------------------------
INSERT INTO `save_backups_online` VALUES ('1', '', null, '2018-03-14 11:37:15', 'admin', null, 'admin', '7', '已经备份', '');
INSERT INTO `save_backups_online` VALUES ('2', '', null, '2018-03-14 11:41:09', 'admin', null, 'admin', '9', '还未备份', '');
-- ----------------------------
-- Table structure for save_backups_record
-- ----------------------------
DROP TABLE IF EXISTS `save_backups_record`;
CREATE TABLE `save_backups_record` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注，备份说明',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`backups_type` varchar(20) DEFAULT NULL COMMENT '备份类别 有在线备份1 和离线备份2',
`status` varchar(20) DEFAULT NULL COMMENT '备份状态表',
`backups_offline_tab` varchar(50) DEFAULT NULL COMMENT '离线备份表',
`offline_status` int(1) DEFAULT '0' COMMENT '离线备份的状态检测',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='备份记录表';
-- ----------------------------
-- Records of save_backups_record
-- ----------------------------
INSERT INTO `save_backups_record` VALUES ('33', '', null, '2018-04-13 02:47:47', 'admin', null, null, '离线备份', '审核中', '1523587667162', '0');
-- ----------------------------
-- Table structure for save_backusps_status
-- ----------------------------
DROP TABLE IF EXISTS `save_backusps_status`;
CREATE TABLE `save_backusps_status` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) NOT NULL COMMENT '更新人',
`packaged` int(1) DEFAULT NULL COMMENT '备份已打包',
`leader_audited` int(1) DEFAULT NULL COMMENT '领导已审核',
`local_transfer` int(1) DEFAULT NULL COMMENT '本地人员交接中',
`transportation_received` int(1) DEFAULT NULL COMMENT '运输人员已接收',
`storekeeper_received` int(1) DEFAULT NULL COMMENT '库房人员已接收',
`achieves_stored` int(1) DEFAULT NULL COMMENT '档案已入库',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='备份状态表';
-- ----------------------------
-- Records of save_backusps_status
-- ----------------------------
-- ----------------------------
-- Table structure for save_connect
-- ----------------------------
DROP TABLE IF EXISTS `save_connect`;
CREATE TABLE `save_connect` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，移出时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人，移出填表人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`connect_name` varchar(20) DEFAULT NULL COMMENT '交接工作名',
`connect_content` varchar(255) DEFAULT NULL COMMENT '内容描述',
`connect_num` varchar(50) DEFAULT NULL COMMENT '移交电子数量',
`connect_unit` varchar(10) DEFAULT NULL COMMENT '移交数据量',
`serial` varchar(50) DEFAULT NULL COMMENT '载体起止顺序号',
`specification` varchar(50) DEFAULT NULL COMMENT '载体规格',
`accuracy_detection` int(1) DEFAULT NULL COMMENT '准确性检测',
`integrity_testing` int(1) DEFAULT NULL COMMENT '完整性检测',
`availability_detection` int(1) DEFAULT NULL COMMENT '可用性检测',
`safety_inspection` int(1) DEFAULT NULL COMMENT '安全性检测',
`appearance_detection` int(1) DEFAULT NULL COMMENT '载体外观检测',
`transfer_reviewer` varchar(10) DEFAULT NULL COMMENT '移交审核人',
`transfer_stamp` int(1) DEFAULT NULL COMMENT '移交单位签章',
`accession_reviewer` varchar(10) DEFAULT NULL COMMENT '接收审核人',
`accession_stamp` int(1) DEFAULT NULL COMMENT '接收单位签章',
`rate_progress` int(1) DEFAULT NULL COMMENT '进度',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='交接表';
-- ----------------------------
-- Records of save_connect
-- ----------------------------
-- ----------------------------
-- Table structure for save_disposition
-- ----------------------------
DROP TABLE IF EXISTS `save_disposition`;
CREATE TABLE `save_disposition` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`medium_num` varchar(20) DEFAULT NULL COMMENT '光盘编号',
`disposal_type` varchar(10) DEFAULT NULL COMMENT '处置类型',
`disposal_reason` varchar(50) DEFAULT NULL COMMENT '处置原因',
`reviewer` varchar(10) DEFAULT NULL COMMENT '审批人',
`disposal_opinion` varchar(10) DEFAULT NULL COMMENT '审批意见',
`disposal_person` varchar(10) DEFAULT NULL COMMENT '处置人',
`security_supervisor` varchar(10) DEFAULT NULL COMMENT '监销人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='处置表';
-- ----------------------------
-- Records of save_disposition
-- ----------------------------
INSERT INTO `save_disposition` VALUES ('1', '', 'dfddv', '2018-03-07 16:21:55', 'admin', null, null, 'fds', 'fdsfd', 'sfdsf', 'common', 'df', 'sdfds', 'fs');
INSERT INTO `save_disposition` VALUES ('2', '', null, '2018-03-22 08:42:08', 'admin', null, null, 'f\'d\'s', 'fsfsfsf', 'f\'d\'s\'f\'f', 'f\'s\'f\'s\'f', 'f\'d\'s', 'f\'s\'f', 'f\'d\'s\'');
-- ----------------------------
-- Table structure for save_label
-- ----------------------------
DROP TABLE IF EXISTS `save_label`;
CREATE TABLE `save_label` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`batch` varchar(50) DEFAULT NULL COMMENT '批次',
`num` varchar(20) DEFAULT NULL COMMENT '介质编号',
`medium` varchar(20) DEFAULT NULL COMMENT '介质',
`capacity` int(10) DEFAULT NULL COMMENT '每张介质大小',
`begin_time` date DEFAULT NULL COMMENT '全宗号',
`end_time` date DEFAULT NULL COMMENT '类别号',
`security_classification` varchar(20) DEFAULT NULL COMMENT '密级',
`retention_period` varchar(10) DEFAULT NULL COMMENT '保管期限',
`is_excel` tinyint(10) DEFAULT NULL COMMENT '是否生成excel表',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8 COMMENT='备份标签表';
-- ----------------------------
-- Records of save_label
-- ----------------------------
INSERT INTO `save_label` VALUES ('238', '', 'gdfd', '2018-04-11 01:16:44', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('239', '', 'gdfd', '2018-04-11 01:16:44', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('240', '', 'gdfd', '2018-04-11 01:16:44', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('241', '', '54', '2018-04-11 03:12:44', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('242', '', '54', '2018-04-11 03:12:44', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('243', '', '54', '2018-04-11 03:12:44', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('244', '', '54', '2018-04-11 03:15:58', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('245', '', '54', '2018-04-11 03:15:58', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('246', '', '54', '2018-04-11 03:15:58', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('247', '', '54', '2018-04-11 03:18:45', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('248', '', '54', '2018-04-11 03:18:45', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('249', '', '54', '2018-04-11 03:18:45', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('250', '', '54', '2018-04-11 03:20:58', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('251', '', '54', '2018-04-11 03:20:58', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('252', '', '54', '2018-04-11 03:20:58', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('253', '', '54', '2018-04-11 03:22:09', 'admin', null, null, '123', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('254', '', '54', '2018-04-11 03:22:09', 'admin', null, null, '123', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('255', '', '54', '2018-04-11 03:22:09', 'admin', null, null, '123', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('256', '', '544', '2018-04-11 03:22:55', 'admin', null, null, '5245', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('257', '', '544', '2018-04-11 03:22:55', 'admin', null, null, '5245', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('258', '', '544', '2018-04-11 03:22:55', 'admin', null, null, '5245', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('259', '', '', '2018-04-11 03:23:45', 'admin', null, null, '', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('260', '', '', '2018-04-11 03:23:45', 'admin', null, null, '', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('261', '', '', '2018-04-11 03:23:45', 'admin', null, null, '', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('262', '', '', '2018-04-11 03:24:31', 'admin', null, null, '', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('263', '', '', '2018-04-11 03:24:31', 'admin', null, null, '', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('264', '', '', '2018-04-11 03:24:31', 'admin', null, null, '', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('265', '', '', '2018-04-11 03:32:51', 'admin', null, null, '', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('266', '', '', '2018-04-11 03:32:51', 'admin', null, null, '', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('267', '', '', '2018-04-11 03:32:51', 'admin', null, null, '', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('268', '', '', '2018-04-11 03:33:59', 'admin', null, null, '', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('269', '', '', '2018-04-11 03:33:59', 'admin', null, null, '', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('270', '', '', '2018-04-11 03:33:59', 'admin', null, null, '', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('271', '', '', '2018-04-11 03:37:01', 'admin', null, null, '', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('272', '', '', '2018-04-11 03:37:01', 'admin', null, null, '', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('273', '', '', '2018-04-11 03:37:01', 'admin', null, null, '', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('274', '', '787', '2018-04-12 02:50:18', 'admin', null, null, '52572', '1套', '碟1', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('275', '', '787', '2018-04-12 02:50:18', 'admin', null, null, '52572', '1套', '碟2', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
INSERT INTO `save_label` VALUES ('276', '', '787', '2018-04-12 02:50:18', 'admin', null, null, '52572', '1套', '碟3', '3', '2018-04-10', '2018-04-10', '秘密', '30', null);
-- ----------------------------
-- Table structure for save_leader_audit
-- ----------------------------
DROP TABLE IF EXISTS `save_leader_audit`;
CREATE TABLE `save_leader_audit` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`type` varchar(20) DEFAULT NULL COMMENT '表类型',
`tab` varchar(50) DEFAULT NULL COMMENT '表名',
`status` varchar(50) DEFAULT NULL COMMENT '审核状态',
`statuss` int(1) DEFAULT '0' COMMENT '(0:待审核 1:通过 -1:不通过)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='领导审核表';
-- ----------------------------
-- Records of save_leader_audit
-- ----------------------------
INSERT INTO `save_leader_audit` VALUES ('21', '', '', '2018-04-13 02:47:47', 'admin', null, null, '离线备份表', '1523587667162', '待审核', '0');
-- ----------------------------
-- Table structure for save_migration
-- ----------------------------
DROP TABLE IF EXISTS `save_migration`;
CREATE TABLE `save_migration` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`medium_num` varchar(20) DEFAULT NULL COMMENT '光盘号',
`data_format` varchar(20) DEFAULT NULL COMMENT '数据格式',
`data_size` varchar(20) DEFAULT NULL COMMENT '数据大小',
`migration_reason` varchar(50) DEFAULT NULL COMMENT '迁移原因',
`reviewer` varchar(10) DEFAULT NULL COMMENT '审批人',
`new_medium` varchar(10) DEFAULT NULL COMMENT '新载体',
`new_medium_num` varchar(20) DEFAULT NULL COMMENT '新载体编号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='迁移表';
-- ----------------------------
-- Records of save_migration
-- ----------------------------
INSERT INTO `save_migration` VALUES ('1', '', 'dssv', '2018-03-22 17:09:54', null, null, 'admin', 'sd', 'fdsf', 'dsfdsf', 'fsf', 'f', 'sfd', 'sf');
INSERT INTO `save_migration` VALUES ('2', '', null, '2018-03-22 09:15:58', 'admin', null, null, 'fdsfs', 'fsf', 'fsdfd', 'sfs', 'sfsdf', 'fsdfsfd', 'sfd');
INSERT INTO `save_migration` VALUES ('3', '', null, '2018-03-22 09:16:13', 'admin', null, null, 'dsd', 'dds', 'sd', 'dds', 'dsd', 'dsdsds', 'd');
-- ----------------------------
-- Table structure for save_proin
-- ----------------------------
DROP TABLE IF EXISTS `save_proin`;
CREATE TABLE `save_proin` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '清点时间，创建时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人，清点人员',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`medium_num` varchar(50) DEFAULT NULL COMMENT '光盘号',
`archives_type` varchar(20) DEFAULT NULL COMMENT '档案类型',
`filing_num` varchar(50) DEFAULT NULL COMMENT '起止档号或归档号',
`medium_content` varchar(255) DEFAULT NULL COMMENT '光盘内容',
`file_format` varchar(10) DEFAULT NULL COMMENT '文件格式',
`data_size` varchar(10) DEFAULT NULL COMMENT '数据大小',
`backup_count` int(1) DEFAULT NULL COMMENT '备份套数',
`save_position` varchar(50) DEFAULT NULL COMMENT '存放位置',
`batch` varchar(50) DEFAULT NULL COMMENT '档案批次',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=768 DEFAULT CHARSET=utf8 COMMENT='入库表';
-- ----------------------------
-- Records of save_proin
-- ----------------------------
INSERT INTO `save_proin` VALUES ('1', '', 'wefefwfw', '2018-03-14 11:01:07', 'sdvsvs', null, null, 'vssdvs', 'vdsvdsv', 'vdsvs', 'svs', 'sv', 'svdsvs', '1', 'svvdvddsvv', null);
INSERT INTO `save_proin` VALUES ('2', '', null, '2018-03-17 09:51:15', null, null, null, '1123123123', '12313', '1123123', '123123', '123', '123', '123', '123123', null);
INSERT INTO `save_proin` VALUES ('3', '', null, '2018-03-19 02:50:43', null, null, null, 'ffdsfsd', 'fdsf', 'f\'f\'d\'s', 'fsf', 'd\'s\'f', 'sfs', '2', 'fsfsf', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('4', '', null, '2018-03-19 02:50:43', null, null, null, 'ffdsfsd', 'fdsf', 'f\'f\'d\'s', 'fsf', 'd\'s\'f', 'sfs', '2', 'fsfsf', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('8', '', null, '2018-03-19 06:50:37', null, null, null, '', 'dsds', 'dsds', '', 'ds', '', null, '', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('9', '', null, '2018-03-19 06:54:12', null, null, null, 'd', 'sdfsf', 'ddsdsd', 'sfsf', 'sdsdd', 'sfsf', '12', 'sf', null);
INSERT INTO `save_proin` VALUES ('10', '', null, '2018-03-19 06:54:49', null, null, null, 'd', 'sdfsf', 'ddsdsd', 'sfsf', 'sdsdd', 'sfsf', '12', 'sf', null);
INSERT INTO `save_proin` VALUES ('747', '', null, '2018-03-13 14:55:09', null, null, null, 'dsds', 'dsd', 'sdsd', 'sdsd', 's', null, null, null, '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('761', '', null, '2018-03-22 01:07:26', null, null, null, '', '', '', '', '', '', null, '', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('762', '', null, '2018-03-22 01:07:41', null, null, null, '', '', '111111111111111111111111', '', '', '', '11', '', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('763', '', null, '2018-03-22 02:34:56', 'admin', null, null, 'sdfdsfs', 'sfs', 'fsfsf', 'fsfs', 'fds', 'sfsf', '1', 'sf', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('764', '', null, '2018-03-22 02:35:06', 'admin', null, null, 'sdfdsfs', 'sfs', 'fsfsf', 'fsfs', 'fds', 'sfsf', '1', 'sf', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('765', '', null, '2018-03-22 02:35:41', 'admin', null, null, 'g', 'd', 'd', 'g', 'd', 'gd', null, '', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('766', '', null, '2018-03-22 02:36:26', 'admin', null, null, 'dg', 'dg', 'dg', 'gg', 'd', 'd', null, '', '1.2.3.4.5');
INSERT INTO `save_proin` VALUES ('767', '', null, '2018-03-22 02:36:31', 'admin', null, null, 'fdgdgdgg', 'gdg', 'fdg', 'gdg', 'dg', 'dgdg', null, '', '1.2.3.4.5');
-- ----------------------------
-- Table structure for save_recovery
-- ----------------------------
DROP TABLE IF EXISTS `save_recovery`;
CREATE TABLE `save_recovery` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`application_tab` varchar(50) DEFAULT NULL COMMENT '恢复申请表',
`record_tab` varchar(50) DEFAULT NULL COMMENT '恢复信息表',
`restoration_state` int(1) DEFAULT '0' COMMENT '(0:申请表待审核 1:申请表审核成功 -1申请表审核失败 2恢复完成，包括恢复信息表的提交)',
`status` varchar(50) DEFAULT NULL COMMENT '显示恢复的整个过程状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='恢复表';
-- ----------------------------
-- Records of save_recovery
-- ----------------------------
INSERT INTO `save_recovery` VALUES ('8', '', null, '2018-04-12 03:35:35', 'admin', '2018-04-13 02:19:49', 'admin', '1523504135386', '1523585989027', '1', '审核通过');
INSERT INTO `save_recovery` VALUES ('9', '', null, '2018-04-12 04:54:44', 'admin', '2018-04-12 04:55:39', 'admin', '1523508884315', null, '-1', '审核不通过');
INSERT INTO `save_recovery` VALUES ('10', '', null, '2018-04-12 07:36:43', 'admin', '2018-04-12 07:36:55', 'admin', '1523518603628', null, '1', '审核通过');
INSERT INTO `save_recovery` VALUES ('11', '', null, '2018-04-12 09:07:08', 'admin', '2018-04-12 09:09:54', 'admin', '1523524028387', null, '1', '审核通过');
INSERT INTO `save_recovery` VALUES ('12', '', null, '2018-04-12 09:46:32', 'admin', null, null, '1523526392185', null, '0', '待审核');
-- ----------------------------
-- Table structure for save_recovery_application
-- ----------------------------
DROP TABLE IF EXISTS `save_recovery_application`;
CREATE TABLE `save_recovery_application` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，申请时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人，申请人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`instruction` varchar(255) DEFAULT NULL COMMENT '申请说明',
`rate_progress` int(1) DEFAULT '0' COMMENT '进度 -1审核不通过 0审核中 1审核通过 2恢复成功 不是2的话都显示还未恢复',
`tab` varchar(20) DEFAULT NULL COMMENT '表名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='恢复申请表';
-- ----------------------------
-- Records of save_recovery_application
-- ----------------------------
INSERT INTO `save_recovery_application` VALUES ('14', '', null, '2018-04-12 03:35:35', 'admin', '2018-04-12 04:54:05', 'admin', 'sdsvsvdsvaaa', '1', '1523504135386');
INSERT INTO `save_recovery_application` VALUES ('15', '', null, '2018-04-12 04:54:44', 'admin', '2018-04-12 04:55:39', 'admin', 'sadvdsvsvsvdsv21313131', '-1', '1523508884315');
INSERT INTO `save_recovery_application` VALUES ('16', '', null, '2018-04-12 07:36:43', 'admin', '2018-04-12 07:36:56', 'admin', 'sdvssvsdvssfsfdsffffffffbfdbshfdmagjdslahkdsahkdsahgsa', '1', '1523518603628');
INSERT INTO `save_recovery_application` VALUES ('17', '', null, '2018-04-12 09:07:08', 'admin', '2018-04-12 09:09:54', 'admin', 'sdfsdgsdgsgs', '1', '1523524028387');
INSERT INTO `save_recovery_application` VALUES ('18', '', null, '2018-04-12 09:46:32', 'admin', null, null, 'sdfssvs', '0', '1523526392185');
-- ----------------------------
-- Table structure for save_recovery_record
-- ----------------------------
DROP TABLE IF EXISTS `save_recovery_record`;
CREATE TABLE `save_recovery_record` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，恢复时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人，操作人员',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`restoration_num` varchar(50) DEFAULT NULL COMMENT '恢复档案号',
`restoration_content` varchar(255) DEFAULT NULL COMMENT '恢复内容',
`tab` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='恢复信息表';
-- ----------------------------
-- Records of save_recovery_record
-- ----------------------------
INSERT INTO `save_recovery_record` VALUES ('1', '', null, '2018-03-15 06:58:36', 'admin', null, null, 'fwfwef', 'wfefw', null);
INSERT INTO `save_recovery_record` VALUES ('2', '', null, '2018-03-15 07:32:03', 'admin', null, null, 'fdsfsf', 'fdsf', null);
INSERT INTO `save_recovery_record` VALUES ('3', '', null, '2018-03-27 01:39:14', 'admin', null, null, 'dsd', 'sds', '1213321312321');
INSERT INTO `save_recovery_record` VALUES ('4', '', null, '2018-04-13 02:10:31', 'admin', null, null, 'ewfw', 'fwfwfwewfwefwfwefwfw', '1523585431728');
INSERT INTO `save_recovery_record` VALUES ('5', '', null, '2018-04-13 02:12:09', 'admin', null, null, 'sffsd', 'dvsvssv', '1523585529109');
INSERT INTO `save_recovery_record` VALUES ('6', '', null, '2018-04-13 02:19:49', 'admin', null, null, 'fdsfsf', 'dsfsf', '1523585989027');
-- ----------------------------
-- Table structure for save_repository
-- ----------------------------
DROP TABLE IF EXISTS `save_repository`;
CREATE TABLE `save_repository` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`batch` varchar(50) DEFAULT NULL COMMENT '档案批次',
`proin_tab` varchar(50) DEFAULT NULL COMMENT '入库表',
`dosposition_tab` varchar(50) DEFAULT NULL COMMENT '处置表',
`sampling_tab` varchar(50) DEFAULT NULL COMMENT '检测表',
`migration_tab` varchar(50) DEFAULT NULL COMMENT '迁移表',
`sampling_time` int(3) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='仓库表';
-- ----------------------------
-- Records of save_repository
-- ----------------------------
INSERT INTO `save_repository` VALUES ('1', '', 'dssdds', '2018-03-15 16:50:15', null, null, 'admin', '1.2.3.4.5', 'ds', 'dsdsd', 'sdd', 'sdsds', '12');
INSERT INTO `save_repository` VALUES ('2', '', 'fsf', '2018-03-15 10:00:40', 'admin', null, null, 'fdsf', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('3', '', 'sssfdsffsfdsfsfs', '2018-03-16 01:29:00', 'admin', null, null, 'dssssssssssssssssss', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('4', '', 'dsfsfsfs', '2018-03-20 07:26:43', null, null, null, '1.2.3.4.5', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('5', '', '', '2018-03-20 07:34:13', null, null, null, '', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('6', '', '', '2018-03-20 07:34:26', null, null, null, '', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('7', '', 'dwq', '2018-03-20 08:39:41', null, null, null, 'dqdqqw', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('8', '', '啊哈范德萨发的酸辣粉沙发撒发生发法萨芬撒范德萨范德萨发顺丰 第三方第三方大师法第三方', '2018-03-21 02:19:39', null, null, null, '2.3.4.5', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('9', '', 'fsfsfs', '2018-03-21 02:48:52', null, null, null, 'sdfsf', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('10', '', 'fsfsfsdsd', '2018-03-21 07:38:55', null, null, null, 'dfsf', null, null, null, null, null);
INSERT INTO `save_repository` VALUES ('11', '', '', '2018-03-22 01:17:35', null, null, null, '', null, null, null, null, null);
-- ----------------------------
-- Table structure for save_sampling
-- ----------------------------
DROP TABLE IF EXISTS `save_sampling`;
CREATE TABLE `save_sampling` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`medium_num` varchar(20) DEFAULT NULL COMMENT '光盘号',
`bler` varchar(10) DEFAULT NULL COMMENT '块错误率 CD-R光盘的块错误率是指每秒测得的错误块数量，CD-R光盘技术规范规定：BLER＜220数据块／秒',
`e32` varchar(10) DEFAULT NULL COMMENT '不可校正错误 读CD-R光盘时不能被解码器校正的错误的总数称为E32，CD-R光盘技术规范规定：E32 = 0',
`sym` varchar(10) DEFAULT NULL,
`jitter` varchar(10) DEFAULT NULL,
`pie` varchar(10) DEFAULT NULL COMMENT '奇偶校验内码错误 PI 与PO分别是ECC（错误校正编码）块中的奇偶校验内码和外码，DVD 光盘用PI 与PO 校验中发现错误的次数与程度来评价其记录质量，DVD-R和DVD+R技术规范规定PIE不能超过280',
`pof` varchar(10) DEFAULT NULL COMMENT '奇偶校验外码失败 当DVDR读出解码器经过第一轮纠错后，不能校正ECC块内数据就叫奇偶校验外码失败，DVD-R和DVD+R技术规范都规定POF = 0',
`asym` varchar(10) DEFAULT NULL,
`dc_jitter` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='检测表';
-- ----------------------------
-- Records of save_sampling
-- ----------------------------
INSERT INTO `save_sampling` VALUES ('1', '', 'sd', '2018-03-22 17:45:31', null, null, 'admin', 'sd', 'ds', 'd', 'd', 'd', 'd', 'd', 'd', 'd');
INSERT INTO `save_sampling` VALUES ('2', '', null, '2018-03-22 09:45:59', 'admin', null, null, '1', '1', '1', '1', null, '1', '1', '1', '1');
-- ----------------------------
-- Table structure for save_setcircle
-- ----------------------------
DROP TABLE IF EXISTS `save_setcircle`;
CREATE TABLE `save_setcircle` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除',
`remark` varchar(1024) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间，存入日期',
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
`backups_circle` int(10) DEFAULT NULL COMMENT '备份周期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='在线备份周期设置表';
-- ----------------------------
-- Records of save_setcircle
-- ----------------------------
INSERT INTO `save_setcircle` VALUES ('8', '', null, '2018-03-13 02:03:26', 'admin', null, null, '5435325');
INSERT INTO `save_setcircle` VALUES ('9', '', null, '2018-03-14 04:00:39', 'admin', null, null, '121212');
INSERT INTO `save_setcircle` VALUES ('10', '', null, '2018-03-24 08:15:07', 'admin', null, null, '12');
INSERT INTO `save_setcircle` VALUES ('11', '', null, '2018-03-24 08:15:49', 'admin', null, null, '12');
INSERT INTO `save_setcircle` VALUES ('12', '', null, '2018-03-24 08:17:36', 'admin', null, null, '12');
INSERT INTO `save_setcircle` VALUES ('13', '', null, '2018-03-24 08:17:57', 'admin', null, null, '122');
INSERT INTO `save_setcircle` VALUES ('14', '', null, '2018-03-24 08:19:12', 'admin', null, null, '12223');
INSERT INTO `save_setcircle` VALUES ('15', '', null, '2018-03-24 08:19:43', 'admin', null, null, '12223');
INSERT INTO `save_setcircle` VALUES ('16', '', null, '2018-03-26 01:14:57', 'admin', null, null, '1');
INSERT INTO `save_setcircle` VALUES ('17', '', null, '2018-03-28 01:19:14', 'admin', null, null, '1');
INSERT INTO `save_setcircle` VALUES ('18', '', null, '2018-04-02 09:32:36', 'admin', null, null, '12');
-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`sum` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1');
INSERT INTO `test` VALUES ('2');
INSERT INTO `test` VALUES ('3');
INSERT INTO `test` VALUES ('4');
INSERT INTO `test` VALUES ('5');
INSERT INTO `test` VALUES ('6');
INSERT INTO `test` VALUES ('7');
INSERT INTO `test` VALUES ('8');
INSERT INTO `test` VALUES ('9');
INSERT INTO `test` VALUES ('10');