/* 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 '奇偶校验外码失败 当DVDR读出解码器经过第一轮纠错后，不能校正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');