SpringCloudBase/sql/archives_mgr.sql

/*
Navicat MariaDB Data Transfer

Source Server         : archives
Source Server Version : 100032
Source Host           : 192.168.1.124:3307
Source Database       : archives_mgr

Target Server Type    : MariaDB
Target Server Version : 100032
File Encoding         : 65001

Date: 2018-04-03 16:08:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for mgr_archives_classification
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_classification`;
CREATE TABLE `mgr_archives_classification` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类表ID',
  `classification_code` varchar(50) DEFAULT NULL COMMENT '分类代码',
  `name` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `connection_code` varchar(10) DEFAULT NULL COMMENT '连接符',
  `classification_model` varchar(255) DEFAULT NULL COMMENT '分类模式',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='分类表';

-- ----------------------------
-- Records of mgr_archives_classification
-- ----------------------------
INSERT INTO `mgr_archives_classification` VALUES ('2', '1234948491', '测试测试分类', null, '+', '32', '0', '测试测试', '2018-03-19 07:38:14', 'admin', null, null);
INSERT INTO `mgr_archives_classification` VALUES ('3', '1564', '测试测试添加', null, '-', '3,3', '1', '测试', '2018-03-19 07:43:52', 'admin', null, null);
INSERT INTO `mgr_archives_classification` VALUES ('4', '2009', '2009', null, '#', '3,3', '1', '2009', '2018-03-19 09:07:04', 'admin', '2018-03-19 10:21:45', 'admin');
INSERT INTO `mgr_archives_classification` VALUES ('5', '2001', '2001', null, '|', '2,2,3', '1', '2001', '2018-03-19 09:08:07', 'admin', null, null);
INSERT INTO `mgr_archives_classification` VALUES ('6', '2003', '2003', null, '-', '1,2,3', '1', '2003', '2018-03-19 09:09:27', 'admin', null, null);

-- ----------------------------
-- Table structure for mgr_archives_complicationdetail
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_complicationdetail`;
CREATE TABLE `mgr_archives_complicationdetail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编研详细信息ID',
  `fonds_no` varchar(50) DEFAULT NULL COMMENT '全宗号',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `year` varchar(20) DEFAULT NULL COMMENT '年度',
  `unit_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `part_no` varchar(10) DEFAULT NULL COMMENT '件号',
  `title` varchar(20) DEFAULT NULL COMMENT '题名',
  `archives_no` varchar(50) DEFAULT NULL COMMENT '档号',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='编研详细信息';

-- ----------------------------
-- Records of mgr_archives_complicationdetail
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_complicationfilehang
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_complicationfilehang`;
CREATE TABLE `mgr_archives_complicationfilehang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编研挂接ID',
  `url` varchar(50) DEFAULT NULL COMMENT '文件保存地址',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `title` varchar(20) DEFAULT NULL COMMENT '标题',
  `page_no` varchar(20) DEFAULT NULL COMMENT '页数',
  `sort_no` int(11) DEFAULT NULL COMMENT '序号',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='编研文件挂接信息';

-- ----------------------------
-- Records of mgr_archives_complicationfilehang
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_complicationmanage
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_complicationmanage`;
CREATE TABLE `mgr_archives_complicationmanage` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编研库ID',
  `warehouse_name` varchar(50) DEFAULT NULL COMMENT '编研库名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `type` varchar(20) DEFAULT NULL COMMENT '编研类型',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='编研库信息';

-- ----------------------------
-- Records of mgr_archives_complicationmanage
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_constants
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_constants`;
CREATE TABLE `mgr_archives_constants` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '综合信息库ID',
  `repertory_name` varchar(50) DEFAULT NULL COMMENT '库名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='综合信息管理库';

-- ----------------------------
-- Records of mgr_archives_constants
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_datamanage
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_datamanage`;
CREATE TABLE `mgr_archives_datamanage` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '资料ID',
  `title` varchar(50) DEFAULT NULL COMMENT '标题',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `press` varchar(50) DEFAULT NULL COMMENT '出版社',
  `press_time` varchar(20) DEFAULT NULL COMMENT '出版日期',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资料管理';

-- ----------------------------
-- Records of mgr_archives_datamanage
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_devicemanage
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_devicemanage`;
CREATE TABLE `mgr_archives_devicemanage` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '设备ID',
  `device_name` varchar(50) DEFAULT NULL COMMENT '设备名称',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `device_number` int(10) DEFAULT NULL COMMENT '设备数量',
  `device_status` varchar(10) DEFAULT NULL COMMENT '设备状态',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备管理';

-- ----------------------------
-- Records of mgr_archives_devicemanage
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_document
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_document`;
CREATE TABLE `mgr_archives_document` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `file_id` bigint(20) DEFAULT NULL COMMENT '案卷id',
  `enable` bit(1) DEFAULT NULL COMMENT '可用性',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注/附注',
  `create_by` varchar(20) DEFAULT NULL COMMENT '登记人',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '登记日期',
  `update_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `filing_by` varchar(20) DEFAULT NULL COMMENT '归档人',
  `filing_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '归档日期',
  `fonds_no` varchar(20) DEFAULT NULL COMMENT '全宗号',
  `catalogue_code` int(11) DEFAULT NULL COMMENT '案卷目录号',
  `file_code` varchar(20) DEFAULT NULL COMMENT '案卷号',
  `archival_code` varchar(20) DEFAULT NULL COMMENT '档号',
  `page_code` varchar(20) DEFAULT NULL COMMENT '页号',
  `part_no` varchar(20) DEFAULT NULL COMMENT '件号',
  `responsible_person` varchar(50) DEFAULT NULL COMMENT '责任者',
  `document_code` varchar(10) DEFAULT NULL COMMENT '文件编号',
  `document_title` varchar(255) DEFAULT NULL COMMENT '文件题名',
  `pages_count` int(11) DEFAULT NULL COMMENT '页数',
  `written_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '成文时间',
  `year` varchar(10) DEFAULT NULL COMMENT '年度',
  `box_code` varchar(20) DEFAULT NULL COMMENT '盒号',
  `security_classification` int(11) DEFAULT NULL COMMENT '密级。（0无密；1秘密；2机密；3绝密；）',
  `archives_type_code` int(11) DEFAULT NULL COMMENT '分类号',
  `electronic_record_title` varchar(50) DEFAULT NULL COMMENT '电子档案名称',
  `descriptor` varchar(100) DEFAULT NULL COMMENT '主题词',
  `organization_problem` varchar(100) DEFAULT NULL COMMENT '机构（问题）',
  `personage` varchar(20) DEFAULT NULL COMMENT '人物',
  `archives_name` varchar(100) DEFAULT NULL COMMENT '档案馆名称',
  `attachment_title` varchar(100) DEFAULT NULL COMMENT '附件题名',
  `control_sign` varchar(10) DEFAULT NULL COMMENT '控制标识',
  `archives_code` varchar(10) DEFAULT NULL COMMENT '档案馆代码',
  `produce_way` varchar(20) DEFAULT NULL COMMENT '电子档案生成方式',
  `secrecy_period` int(11) DEFAULT NULL COMMENT '保密期限',
  `retention_period` int(11) DEFAULT NULL COMMENT '保管期限',
  `filing_status` int(1) DEFAULT '0' COMMENT '档案归档状态（0未归档；1归档）',
  `del_flag` int(1) DEFAULT '0' COMMENT '删除标识（0未删除；1删除）',
  `digitization_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '数字化时间',
  `digitization_obj_describe` varchar(100) DEFAULT NULL COMMENT '数字化对象描述',
  `digitization_authorize_describe` varchar(100) DEFAULT NULL COMMENT '数字化授权描述',
  `format_name` varchar(20) DEFAULT NULL COMMENT '格式名称',
  `format_version` varchar(20) DEFAULT NULL COMMENT '格式版本',
  `color_space` varchar(20) DEFAULT '' COMMENT '色彩空间',
  `compress_scheme` varchar(20) DEFAULT '' COMMENT '压缩方案',
  `compression_ratio` varchar(10) DEFAULT '' COMMENT '压缩率',
  `horizontal_resolution` varchar(10) DEFAULT '' COMMENT '水平分辨率',
  `vertical_resolution` varchar(10) DEFAULT '' COMMENT '垂直分辨率',
  `image_width` varchar(10) DEFAULT NULL COMMENT '图像宽度',
  `image_height` varchar(10) DEFAULT NULL COMMENT '图像高度',
  `equipment_type` varchar(20) DEFAULT '' COMMENT '设备类型',
  `equipment_manufacturer` varchar(50) DEFAULT '' COMMENT '设备制造商',
  `equipment_model` varchar(20) DEFAULT '' COMMENT '设备型号',
  `equipment_series_number` varchar(50) DEFAULT '' COMMENT '设备系列号',
  `equipment_photoreceptor` varchar(20) DEFAULT '' COMMENT '设备感光器',
  `digital_software_name` varchar(50) DEFAULT NULL COMMENT '数字化软件名称',
  `digital_software_version` varchar(20) DEFAULT NULL COMMENT '数字化软件版本',
  `digital_software_manufacturer` varchar(50) DEFAULT NULL COMMENT '数字化软件生产商',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文书档案文件';

-- ----------------------------
-- Records of mgr_archives_document
-- ----------------------------
INSERT INTO `mgr_archives_document` VALUES ('1', '1', '
', null, null, '2018-04-02 11:51:50', null, '2018-04-02 11:51:50', 'admin', '2018-04-02 11:51:50', null, null, 'ffddfdfd', 'fdfd', 'fdfdfd', 'fdfdf', 'ffdd', null, 'E:\\\\test\\\\in\\\\a\\\\b\\\\新建 Microsoft Word 文档.docx', null, '2018-04-02 11:51:50', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', '0', '2018-04-02 11:51:50', null, null, null, null, '', '', '', '', '', null, null, '', '', '', '', '', null, null, null);
INSERT INTO `mgr_archives_document` VALUES ('2', '1', '
', null, null, '2018-04-02 15:06:05', null, '2018-04-02 15:06:05', 'admin', '2018-04-02 15:06:05', null, null, 'dssv', 'svssd', 'dsvs', 'dsa', 'da', null, 'E:\\\\test\\\\in\\\\a\\\\c\\\\新建 Microsoft PowerPoint 演示文稿.pptx', null, '2018-04-02 15:06:05', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', '0', '2018-04-02 15:06:05', null, null, null, null, '', '', '', '', '', null, null, '', '', '', '', '', null, null, null);
INSERT INTO `mgr_archives_document` VALUES ('3', '2', '
', null, null, '2018-04-02 12:01:56', null, '2018-04-02 12:01:56', 'admin', '2018-04-02 12:01:56', null, null, 'ds', 'dsddsd', 'ssd', 'dad', 'a', null, 'E:\\\\test\\\\in\\\\a\\\\d\\\\新建文本文档.txt', null, '2018-04-02 12:01:56', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', '0', '2018-04-02 12:01:56', null, null, null, null, '', '', '', '', '', null, null, '', '', '', '', '', null, null, null);
INSERT INTO `mgr_archives_document` VALUES ('4', '2', '
', null, null, '2018-04-02 12:01:58', null, '2018-04-02 12:01:58', 'admin', '2018-04-02 12:01:58', null, null, 'asdad', 'sada', 'ada', 'd', 'adad', null, 'E:\\\\test\\\\in\\\\a\\\\e\\\\新建 Microsoft Visio 绘图.vsdx', null, '2018-04-02 12:01:58', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', '0', '2018-04-02 12:01:58', null, null, null, null, '', '', '', '', '', null, null, '', '', '', '', '', null, null, null);

-- ----------------------------
-- Table structure for mgr_archives_electronic_record
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_electronic_record`;
CREATE TABLE `mgr_archives_electronic_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `enable` bit(1) DEFAULT b'1' COMMENT '可用性（1可用；0不可用）',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改日期',
  `document_id` bigint(20) DEFAULT NULL COMMENT '文件id（mgr_archives_document表的id）',
  `electronic_record_title` varchar(50) DEFAULT NULL COMMENT '电子文件标题',
  `connect_configure_name` varchar(20) DEFAULT NULL COMMENT '挂接配置名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电子档案文件';

-- ----------------------------
-- Records of mgr_archives_electronic_record
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_file
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_file`;
CREATE TABLE `mgr_archives_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `enable` bit(1) DEFAULT b'1' COMMENT '可用性（1可用；0不可用）',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注/附注',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `filing_by` varchar(20) DEFAULT NULL COMMENT '归档人',
  `filing_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '归档日期',
  `archival_code` varchar(20) DEFAULT NULL COMMENT '案卷级档号',
  `fonds_no` varchar(20) DEFAULT NULL COMMENT '全宗号',
  `fonds_name` varchar(50) DEFAULT NULL,
  `catalogue_code` int(11) DEFAULT NULL COMMENT '目录号',
  `file_code` int(11) DEFAULT NULL COMMENT '案卷号',
  `year` varchar(10) DEFAULT NULL COMMENT '年度',
  `retention_period` int(11) DEFAULT NULL COMMENT '保管期限',
  `retention_period_code` varchar(10) DEFAULT NULL COMMENT '保管期限代码',
  `file_title` varchar(500) DEFAULT NULL COMMENT '案卷题名',
  `start_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '起时间',
  `end_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '止时间',
  `responsible_person` varchar(50) DEFAULT NULL COMMENT '责任者',
  `written_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '成文时间',
  `pages_count` int(11) DEFAULT NULL COMMENT '页数',
  `document_count` int(11) DEFAULT NULL COMMENT '文件件数',
  `personage` varchar(20) DEFAULT NULL COMMENT '人物',
  `box_code` varchar(20) DEFAULT NULL COMMENT '盒号',
  `secrecy_period` int(11) DEFAULT NULL COMMENT '保密期限',
  `security_classification` int(11) DEFAULT '0' COMMENT '密级（0无密；1秘密；2机密；3绝密；）',
  `archives_name` varchar(100) DEFAULT NULL COMMENT '档案馆名称',
  `descriptor` varchar(100) DEFAULT NULL COMMENT '主题词',
  `archives_code` varchar(10) DEFAULT NULL COMMENT '档案馆代码',
  `attachment_title` varchar(100) DEFAULT NULL COMMENT '附件题名',
  `RFID` varchar(20) DEFAULT NULL COMMENT 'RFID',
  `filing_status` int(1) DEFAULT '0' COMMENT '归档状态（0：未归档，1归档）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='文书档案案卷';

-- ----------------------------
-- Records of mgr_archives_file
-- ----------------------------
INSERT INTO `mgr_archives_file` VALUES ('1', '
', null, 'admin', '2018-03-30 09:59:59', null, '2018-03-30 09:59:59', 's', '2018-03-30 09:59:59', 'ds', 'ds', 'dsd', null, null, 'sds', null, null, null, '2018-03-30 09:59:59', '2018-03-30 09:59:59', null, '2018-03-30 09:59:59', null, null, null, null, null, '0', null, null, null, null, null, '1');
INSERT INTO `mgr_archives_file` VALUES ('2', '
', null, 'admi', '2018-03-30 10:00:01', null, '2018-03-30 10:00:01', 'sdsd', '2018-03-30 10:00:01', 'sdcx', 'vc', 'xvcxvxv', null, null, 'vcxv', null, null, null, '2018-03-30 10:00:01', '2018-03-30 10:00:01', null, '2018-03-30 10:00:01', null, null, null, null, null, '0', null, null, null, null, null, '1');

-- ----------------------------
-- Table structure for mgr_archives_file_note
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_file_note`;
CREATE TABLE `mgr_archives_file_note` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `enable` bit(1) DEFAULT b'1' COMMENT '可用性（0不可用；1可用）',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注/附注',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `fonds_name` varchar(50) DEFAULT NULL COMMENT '全宗名称',
  `fonds_no` varchar(20) DEFAULT NULL COMMENT '全宗号',
  `detail` varchar(500) DEFAULT NULL COMMENT '档案说明',
  `collator` varchar(20) DEFAULT NULL COMMENT '整理人',
  `inspector` varchar(20) DEFAULT NULL COMMENT '检查人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文书档案备考表';

-- ----------------------------
-- Records of mgr_archives_file_note
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_filestorageset
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_filestorageset`;
CREATE TABLE `mgr_archives_filestorageset` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '文件存储ID',
  `config_name` varchar(50) DEFAULT NULL COMMENT '配置名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `config_type` varchar(10) DEFAULT NULL COMMENT '配置方式',
  `file_url` varchar(30) DEFAULT NULL COMMENT '文件存储路径',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件存储设置表';

-- ----------------------------
-- Records of mgr_archives_filestorageset
-- ----------------------------

-- ----------------------------
-- Table structure for mgr_archives_fonds
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_fonds`;
CREATE TABLE `mgr_archives_fonds` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '全宗ID',
  `fonds_no` varchar(32) DEFAULT NULL COMMENT '全宗号',
  `fonds_name` varchar(50) DEFAULT NULL COMMENT '全宗名',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='全宗表';

-- ----------------------------
-- Records of mgr_archives_fonds
-- ----------------------------
INSERT INTO `mgr_archives_fonds` VALUES ('41', '001', '1七星关区委办', '1', '1七星关区委办', '2018-03-31 02:13:18', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('42', '002', '2七星关区宣传部', '1', '2七星关区宣传部', '2018-03-31 02:15:23', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('43', '003', '3七星关区妇联', '1', '3七星关区妇联', '2018-03-31 02:15:36', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('44', '004', '4七星关区纪委', '1', '4七星关区纪委', '2018-03-31 02:15:49', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('45', '005', '5七星关区政府办', '1', '5七星关区政府办', '2018-03-31 02:16:07', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('46', '006', '6七星关区教育局', '1', '七星关区教育局', '2018-03-31 02:16:23', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('47', '007', '7七星关区档案局', '1', '7七星关区档案局', '2018-03-31 02:16:37', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('48', '008', '8七星关区住建局', '1', '8七星关区住建局', '2018-03-31 02:16:49', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('49', '009', '9七星关区人社局', '1', '七星关区人社局', '2018-03-31 02:17:08', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('50', '0011', '11七星关区毕节县商会', '1', '七星关区毕节县商会', '2018-03-31 02:17:43', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('51', '0012', '12计生局', '1', '12计生局', '2018-03-31 02:18:03', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('52', '0013', '13七星关区党校', '1', '七星关区党校', '2018-03-31 02:18:22', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('53', '0014', '14七星关区城管', '1', '七星关区城管', '2018-03-31 02:18:40', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('54', '0015', '15七星关区信访办', '1', '信访办', '2018-03-31 02:19:23', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('55', '0016', '16海子街镇', '1', '海子街镇', '2018-03-31 02:19:47', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('56', '0017', '17杨家湾镇', '1', '杨家湾镇', '2018-03-31 02:20:23', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('57', '0018', '18林口镇', '1', '林口镇', '2018-03-31 02:20:41', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('58', '0019', '19普宜镇', '1', '普宜镇', '2018-03-31 02:21:14', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('59', '0021', '21生机镇', '1', '生机镇', '2018-03-31 02:21:35', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('60', '0020', '20田坝桥镇', '1', '田坝桥镇', '2018-03-31 02:22:15', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('61', '0022', '22七星关区红十字会', '1', '七星关区红十字会', '2018-03-31 02:22:41', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('62', '0023', '23地区海事局', '1', '地区海事局', '2018-03-31 02:23:08', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('63', '0024', '涉外', '1', '涉外', '2018-03-31 02:44:14', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('64', '0025', '结婚', '1', '结婚', '2018-03-31 02:44:25', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('65', '0026', '离婚', '1', '离婚', '2018-03-31 02:44:35', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('66', '0027', '七星关区质监站', '1', '七星关区质监站', '2018-03-31 02:44:59', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('67', '0028', '0028会计核算中心', '1', '会计核算中心', '2018-03-31 02:45:27', 'admin', null, null);
INSERT INTO `mgr_archives_fonds` VALUES ('68', '0029', '独生子女档案', '1', '独生子女档案', '2018-03-31 02:48:51', 'admin', null, null);

-- ----------------------------
-- Table structure for mgr_archives_relation
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_relation`;
CREATE TABLE `mgr_archives_relation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '目录树关系表ID',
  `node_id` bigint(20) DEFAULT NULL COMMENT '节点ID(0：其他类型；只保存档案类型和全宗的ID)',
  `node_name` varchar(50) DEFAULT NULL COMMENT '节点名称',
  `pnode_id` bigint(20) DEFAULT NULL COMMENT '父节点ID',
  `node_type` int(10) unsigned NOT NULL COMMENT '节点类型(1：根节点；2：档案类型；3：全宗；4：分类)',
  `node_code` varchar(255) DEFAULT NULL COMMENT '节点代码，节点标识',
  `archival_id` bigint(20) DEFAULT NULL COMMENT '档案类型ID',
  `archival_catalog` varchar(100) DEFAULT NULL COMMENT '档案类型管理模式(档案目录是否包含案卷，项目等)',
  `fonds_id` bigint(20) DEFAULT NULL COMMENT '分类节点下的全宗ID',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=utf8 COMMENT='目录树关系表';

-- ----------------------------
-- Records of mgr_archives_relation
-- ----------------------------
INSERT INTO `mgr_archives_relation` VALUES ('111', '1', '七星关区档案局', null, '1', '123456789', null, null, null, '1', '七星关区档案局', '2018-03-27 10:11:53', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('169', '0', '文书档案', '111', '2', '0000001111', null, null, null, '1', '文书档案分类', '2018-03-31 02:46:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('170', '23', '文书档案（新）', '169', '2', '0000001111', null, '2,0', null, '1', '文书档案分类', '2018-03-31 02:46:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('171', '24', '文书档案（旧）', '169', '2', '0000001111', null, '1,2,0', null, '1', '文书档案分类', '2018-03-31 02:46:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('172', '41', '1七星关区委办', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('173', '42', '2七星关区宣传部', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('174', '43', '3七星关区妇联', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('175', '44', '4七星关区纪委', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('176', '45', '5七星关区政府办', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('177', '46', '6七星关区教育局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('178', '47', '7七星关区档案局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('179', '48', '8七星关区住建局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('180', '49', '9七星关区人社局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('181', '50', '11七星关区毕节县商会', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('182', '51', '12计生局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('183', '52', '13七星关区党校', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('184', '53', '14七星关区城管', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('185', '54', '15七星关区信访办', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('186', '55', '16海子街镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:51', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('187', '56', '17杨家湾镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('188', '57', '18林口镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('189', '58', '19普宜镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('190', '59', '21生机镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('191', '60', '20田坝桥镇', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('192', '61', '22七星关区红十字会', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('193', '62', '23地区海事局', '170', '3', '', '23', '2,0', null, '1', '', '2018-03-31 02:46:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('194', '41', '1七星关区委办', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:18', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('195', '42', '2七星关区宣传部', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:18', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('196', '43', '3七星关区妇联', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('197', '44', '4七星关区纪委', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('198', '45', '5七星关区政府办', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('199', '46', '6七星关区教育局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('200', '47', '7七星关区档案局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('201', '48', '8七星关区住建局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('202', '49', '9七星关区人社局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('203', '50', '11七星关区毕节县商会', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('204', '51', '12计生局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('205', '52', '13七星关区党校', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('206', '53', '14七星关区城管', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('207', '54', '15七星关区信访办', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('208', '55', '16海子街镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('209', '56', '17杨家湾镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('210', '57', '18林口镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('211', '58', '19普宜镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('212', '59', '21生机镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('213', '60', '20田坝桥镇', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('214', '61', '22七星关区红十字会', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('215', '62', '23地区海事局', '171', '3', '', '24', '1,2,0', null, '1', '', '2018-03-31 02:47:20', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('216', '0', '专门档案', '111', '2', '00000222222', '24', null, null, '1', '专门档案', '2018-03-31 02:48:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('217', '25', '婚姻档案', '216', '2', '00000222222', '24', '0', null, '1', '专门档案', '2018-03-31 02:48:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('218', '32', '危改档案', '216', '2', '00000222222', '24', '0', null, '1', '专门档案', '2018-03-31 02:48:19', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('219', '33', '独生子女档案', '216', '2', '', '0', '0,1', null, '1', '', '2018-03-31 02:49:53', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('220', '0', '科技档案', '111', '4', '000003333333', '0', '', null, '0', '科技档案分类', '2018-03-31 02:50:48', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('221', '43', '3七星关区妇联', '220', '3', '000003333333', '0', '', null, '0', '科技档案分类', '2018-03-31 02:51:16', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('222', '66', '七星关区质监站', '220', '3', '000003333333', '0', '', null, '0', '科技档案分类', '2018-03-31 02:51:16', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('223', '27', '科技档案', '111', '2', '000003333333', '0', '0', null, '1', '科技档案分类', '2018-03-31 02:52:16', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('224', '43', '3七星关区妇联', '223', '3', '000003333333', '27', '0', null, '1', '科技档案分类', '2018-03-31 02:52:30', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('225', '66', '七星关区质监站', '223', '3', '000003333333', '27', '0', null, '1', '科技档案分类', '2018-03-31 02:52:30', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('226', '26', '会计档案', '111', '2', '000003333333', '27', '0', null, '1', '科技档案分类', '2018-03-31 02:53:05', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('227', '67', '0028会计核算中心', '226', '3', '000003333333', '26', '0', null, '1', '科技档案分类', '2018-03-31 02:53:27', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('228', '64', '结婚', '217', '3', '000003333333', '25', '0', null, '1', '科技档案分类', '2018-03-31 02:53:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('229', '65', '离婚', '217', '3', '000003333333', '25', '0', null, '1', '科技档案分类', '2018-03-31 02:53:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('230', '63', '涉外', '217', '3', '000003333333', '25', '0', null, '1', '科技档案分类', '2018-03-31 02:53:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('231', '0', '并发症', '182', '4', '00000333444', '23', '2,0', '51', '1', '并发症', '2018-03-31 02:55:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('232', '0', '两户认定', '111', '4', '0000033555', '23', '2,0', null, '0', '两户认定', '2018-03-31 02:55:45', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('233', '0', '两户认定', '182', '4', '0000033555', '23', '2,0', '51', '1', '两户认定', '2018-03-31 02:56:38', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('234', '0', '节育奖励', '182', '4', '00000336666', '23', '2,0', '51', '1', '节育奖励', '2018-03-31 02:57:09', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('235', '0', '少生快富', '182', '4', '00000337777', '23', '2,0', '51', '1', '少生快富', '2018-03-31 02:57:41', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('236', '0', '独生子女', '182', '4', '000003388888', '23', '2,0', '51', '1', '独生子女', '2018-03-31 02:58:15', 'admin', null, null);
INSERT INTO `mgr_archives_relation` VALUES ('237', '0', '生育计划', '182', '4', '1231564', '23', '2,0', '51', '1', '生育计划', '2018-04-02 02:09:37', 'admin', null, null);

-- ----------------------------
-- Table structure for mgr_archives_relation_copy
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_relation_copy`;
CREATE TABLE `mgr_archives_relation_copy` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '目录树关系表ID',
  `node_id` bigint(20) DEFAULT NULL COMMENT '节点ID',
  `node_name` varchar(50) DEFAULT NULL COMMENT '节点名称',
  `pnode_id` bigint(20) DEFAULT NULL COMMENT '父节点ID',
  `node_type` int(10) unsigned NOT NULL COMMENT '节点类型',
  `node_code` varchar(255) DEFAULT NULL COMMENT '节点代码',
  `archival_id` bigint(20) DEFAULT NULL COMMENT '档案类型ID',
  `archival_catalog` varchar(100) DEFAULT NULL COMMENT '档案类型管理模式(档案目录)',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='目录树关系表';

-- ----------------------------
-- Records of mgr_archives_relation_copy
-- ----------------------------
INSERT INTO `mgr_archives_relation_copy` VALUES ('47', '1', '七星关区档案局', null, '1', '0001', null, null, '1', '备注', '2018-03-24 03:12:48', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('48', '0', '文书档案', '47', '2', '0002', null, null, '0', null, '2018-03-24 03:13:43', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('49', '14', '档案类型测试', '48', '2', '0002', null, '1,2', '0', null, '2018-03-24 03:13:43', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('50', '10', '测试', '48', '2', '0002', null, '2', '0', null, '2018-03-24 03:13:43', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('51', '0', '文书档案', '47', '2', '0002', null, null, '1', null, '2018-03-24 03:14:50', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('52', '14', '档案类型测试', '51', '2', '0002', null, '1,2', '1', null, '2018-03-24 03:14:50', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('53', '10', '测试', '51', '2', '0002', null, '2', '1', null, '2018-03-24 03:14:50', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('54', '0', '全宗分类001', '53', '3', '0000001', null, '2', '1', null, '2018-03-24 03:20:45', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('55', '7', '测试全宗6', '54', '3', '0000001', null, '2', '1', null, '2018-03-24 03:20:46', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('56', '9', '测试全宗7', '54', '3', '0000001', null, '2', '0', null, '2018-03-24 03:20:46', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('57', '10', '测试全宗9', '54', '3', '0000001', null, '2', '1', null, '2018-03-24 03:20:46', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('58', '11', '测试全宗10', '54', '3', '0000001', null, '2', '1', null, '2018-03-24 03:20:46', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('59', '12', '全宗测试001', '54', '3', '0000001', null, '2', '1', null, '2018-03-24 03:20:46', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('60', '0', '测试分类', '56', '4', '123456', null, '2', '0', null, '2018-03-24 03:22:42', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('61', '0', '测试测试分类', '57', '4', '135153496', null, '2', '1', '测试彩色', '2018-03-24 08:01:41', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('62', '0', '测试测试分类', '57', '4', '135153496', null, '2', '1', '测试彩色', '2018-03-24 08:02:40', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('63', '0', '测试测试分类', '57', '4', '135153496', null, '2', '1', '测试彩色', '2018-03-24 08:02:59', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('64', '0', '再分类', '63', '4', '13418940', null, '2', '1', '备注', '2018-03-24 08:13:52', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('65', '0', '再分类', '62', '4', '13418940', null, '2', '1', '备注', '2018-03-24 08:15:29', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('66', '11', '独生子女', '47', '2', '', null, '1,2', '1', '', '2018-03-24 08:18:01', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('67', '12', '独生子女档案', '47', '2', '', null, '2,1', '1', '', '2018-03-24 08:18:01', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('68', '9', '测试全宗7', '67', '3', '', null, '2,1', '1', '', '2018-03-24 08:18:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('69', '10', '测试全宗9', '67', '3', '', null, '2,1', '1', '', '2018-03-24 08:18:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('70', '36', '七星关档案局12', '67', '3', '', null, '2,1', '1', '', '2018-03-24 08:18:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('71', '35', '七星关档案局1', '67', '3', '', null, '2,1', '1', '', '2018-03-24 08:18:17', 'admin', null, null);
INSERT INTO `mgr_archives_relation_copy` VALUES ('72', '37', '七星关档案局123', '67', '3', '', null, '2,1', '1', '', '2018-03-24 08:18:17', 'admin', null, null);

-- ----------------------------
-- Table structure for mgr_archives_setarchivalcode
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_setarchivalcode`;
CREATE TABLE `mgr_archives_setarchivalcode` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '档号ID',
  `file_rule` varchar(255) DEFAULT NULL COMMENT '案卷级档号规则',
  `record_rule` varchar(255) DEFAULT NULL COMMENT '案件级档号规则',
  `archivaltype_id` bigint(20) NOT NULL COMMENT '档案类型ID',
  `link_code` varchar(10) DEFAULT NULL COMMENT '连接符',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='档号设置表';

-- ----------------------------
-- Records of mgr_archives_setarchivalcode
-- ----------------------------
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('7', '全宗号,案卷,年度', '年度,案卷,年度', '8', '-', '1', null, '2018-03-27 08:34:20', 'liusen', '2018-03-27 09:27:54', 'admin');
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('8', '全宗号-案卷-年度', '年度-案卷-年度', '7', '-', '1', null, '2018-03-27 09:31:47', 'liusen', '2018-03-27 10:44:45', 'admin');
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('9', '全宗号+案卷+年度', '全宗号+年度+件号', '11', '+', '1', null, '2018-03-27 09:32:59', 'liusen ', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('10', '', '', '7', '+', '0', null, '2018-03-27 11:02:15', '草拟吗', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('11', '', '', '7', '+', '0', null, '2018-03-27 11:02:33', '草拟吗', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('12', '', '', '7', '+', '0', null, '2018-03-27 11:06:47', '草拟大爷', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('13', '', '', '8', '+', '0', null, '2018-03-27 11:07:58', '草你妈的逼', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('14', '', '', '9', '-', '0', null, '2018-03-27 11:09:42', '擦擦擦', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('15', '', '', '9', '-', '0', null, '2018-03-27 11:09:42', '擦擦擦', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('16', '年度+件号+件号', '全宗号+年度+件号', '12', '+', '1', null, '2018-03-27 11:10:40', '啛啛喳喳错', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('17', '年度-件号-案卷', '件号-全宗号-件号', '10', '-', '1', null, '2018-03-27 11:11:40', '啛啛喳喳', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('18', '全宗号+案卷+件号', '年度+案卷+件号', '10', '+', '1', null, '2018-03-27 11:12:42', '草拟吗', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('19', '年度+案卷+年度', '年度+件号+年度', '8', '+', '1', null, '2018-03-27 11:13:09', '草拟吗', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('20', '案卷+年度+年度', '年度+件号+件号', '7', '+', '1', null, '2018-03-27 11:14:02', '15634561', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('21', '全宗号-年度-件号', '年度-案卷-年度', '8', '-', '1', null, '2018-03-27 11:15:06', '草拟吗逼', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('22', '全宗号+案卷+年度', '案卷+件号+年度', '8', '+', '1', null, '2018-03-27 11:18:26', '13156', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('23', '全宗号-案卷-年度', '全宗号-年度-年度', '9', '-', '1', null, '2018-03-27 11:21:26', '查查塞擦声', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('24', '全宗号-年度-年度', '年度-案卷-年度', '7', '-', '1', null, '2018-03-27 11:24:51', '23213456', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('25', '年度-案卷-年度', '案卷-件号-件号', '9', '-', '1', null, '2018-03-27 11:25:51', '擦拭大Vas', null, null);
INSERT INTO `mgr_archives_setarchivalcode` VALUES ('26', '全宗号+案卷+件号', '年度+件号+年度', '8', '+', '1', null, '2018-03-27 11:28:41', '134156', null, null);

-- ----------------------------
-- Table structure for mgr_archives_type
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_type`;
CREATE TABLE `mgr_archives_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '档案类型ID',
  `name` varchar(50) DEFAULT NULL COMMENT '类型名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `manage_model` varchar(50) DEFAULT NULL COMMENT '档案管理模式',
  `archival_catalog` varchar(50) DEFAULT NULL COMMENT '档案类型的档案目录（包含案卷还是件）（0:只包含件;1:包含案卷;2:包含分类表;3:包含项目）',
  `filepage_number` int(10) unsigned DEFAULT NULL COMMENT '立卷设置卷内页数',
  `type_code` varchar(255) DEFAULT NULL COMMENT '档案类型代码',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='档案类型表';

-- ----------------------------
-- Records of mgr_archives_type
-- ----------------------------
INSERT INTO `mgr_archives_type` VALUES ('23', '文书档案（新）', null, '3', '2,0', null, null, '1', '文书档案（新）', '2018-03-31 02:40:23', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('24', '文书档案（旧）', null, '2', '1,2,0', null, null, '1', '文书档案（旧）', '2018-03-31 02:40:38', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('25', '婚姻档案', null, '1', '0', null, null, '1', '婚姻档案', '2018-03-31 02:41:22', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('26', '会计档案', null, '1', '0', null, null, '1', '会计档案', '2018-03-31 02:41:51', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('27', '科技档案', null, '1', '0', null, null, '1', '科技档案', '2018-03-31 02:42:01', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('28', '图片档案', null, '1', '0', null, null, '1', '图片档案', '2018-03-31 02:42:18', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('29', '照片档案', null, '1', '0', null, null, '1', '照片档案', '2018-03-31 02:42:30', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('30', '实物档案', null, '1', '0', null, null, '1', '实物档案', '2018-03-31 02:42:44', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('31', '视频档案', null, '1', '0', null, null, '1', '视频档案', '2018-03-31 02:43:02', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('32', '危改档案', null, '1', '0', null, null, '1', '危改档案', '2018-03-31 02:43:22', '', null, null);
INSERT INTO `mgr_archives_type` VALUES ('33', '独生子女档案', null, '1', '0,1', null, null, '1', '独生子女', '2018-03-31 02:49:38', '', null, null);

-- ----------------------------
-- Table structure for mgr_archives_warehousemanage
-- ----------------------------
DROP TABLE IF EXISTS `mgr_archives_warehousemanage`;
CREATE TABLE `mgr_archives_warehousemanage` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '库房ID',
  `name` varchar(50) DEFAULT NULL COMMENT '库房名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父ID',
  `manager` varchar(20) DEFAULT NULL COMMENT '管理员',
  `temperature` double DEFAULT NULL COMMENT '温度',
  `humidity` double DEFAULT NULL COMMENT '湿度',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态',
  `remark` varchar(1024) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='库房管理';

-- ----------------------------
-- Records of mgr_archives_warehousemanage
-- ----------------------------