/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50711
Source Host           : localhost:3306
Source Database       : zc_admin

Target Server Type    : MYSQL
Target Server Version : 50711
File Encoding         : 65001

Date: 2018-10-23 10:10:05
*/


-- ----------------------------
-- Table structure for zc_admin_cate
-- ----------------------------
CREATE TABLE `zc_admin_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `permissions` text COMMENT '权限菜单',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `desc` text COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE,
  KEY `name` (`name`) USING BTREE,
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_admin_cate
-- ----------------------------
INSERT INTO `zc_admin_cate` VALUES ('1', '超级管理员', '1,42,43,44,45,47,48,49,46,50,51,2,29,30,31,32,33,34,35,36,37,38,39,40,41,57,58,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,55,56', '0', '1539327074', '超级管理员，拥有最高权限！');
INSERT INTO `zc_admin_cate` VALUES ('2', '教职工组', null, '1539327067', '1539327067', '');

-- ----------------------------
-- Table structure for zc_admin_log
-- ----------------------------
CREATE TABLE `zc_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_menu_id` int(11) NOT NULL COMMENT '操作菜单id',
  `admin_id` int(11) NOT NULL COMMENT '操作者id',
  `ip` varchar(100) DEFAULT NULL COMMENT '操作ip',
  `operation_id` varchar(200) DEFAULT NULL COMMENT '操作关联id',
  `create_time` int(11) NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE,
  KEY `admin_id` (`admin_id`) USING BTREE,
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=176 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_admin_log
-- ----------------------------
INSERT INTO `zc_admin_log` VALUES ('164', '21', '1', '0.0.0.0', '', '1539419805');
INSERT INTO `zc_admin_log` VALUES ('165', '23', '1', '0.0.0.0', '69', '1539419881');
INSERT INTO `zc_admin_log` VALUES ('166', '21', '1', '0.0.0.0', '', '1539419904');
INSERT INTO `zc_admin_log` VALUES ('167', '21', '1', '0.0.0.0', '', '1539419935');
INSERT INTO `zc_admin_log` VALUES ('168', '22', '1', '0.0.0.0', '', '1539420062');
INSERT INTO `zc_admin_log` VALUES ('169', '25', '1', '0.0.0.0', '', '1539420225');
INSERT INTO `zc_admin_log` VALUES ('170', '24', '1', '0.0.0.0', '', '1539420295');
INSERT INTO `zc_admin_log` VALUES ('171', '25', '1', '0.0.0.0', '', '1539420306');
INSERT INTO `zc_admin_log` VALUES ('172', '32', '1', '0.0.0.0', '', '1539564240');
INSERT INTO `zc_admin_log` VALUES ('173', '32', '1', '0.0.0.0', '', '1539564442');
INSERT INTO `zc_admin_log` VALUES ('174', '32', '1', '0.0.0.0', '', '1539564477');
INSERT INTO `zc_admin_log` VALUES ('175', '33', '1', '0.0.0.0', '', '1539919513');

-- ----------------------------
-- Table structure for zc_admin_menu
-- ----------------------------
CREATE TABLE `zc_admin_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `module` varchar(50) NOT NULL COMMENT '模块',
  `controller` varchar(100) NOT NULL COMMENT '控制器',
  `function` varchar(100) NOT NULL COMMENT '方法',
  `parameter` varchar(50) DEFAULT NULL COMMENT '参数',
  `description` varchar(250) DEFAULT NULL COMMENT '描述',
  `is_display` int(1) NOT NULL DEFAULT '1' COMMENT '1显示在左侧菜单2只作为节点',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '1权限节点2普通节点',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级菜单0为顶级菜单',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  `is_open` int(1) NOT NULL DEFAULT '0' COMMENT '0默认闭合1默认展开',
  `orders` int(11) NOT NULL DEFAULT '0' COMMENT '排序值，越小越靠前',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE,
  KEY `module` (`module`) USING BTREE,
  KEY `controller` (`controller`) USING BTREE,
  KEY `function` (`function`) USING BTREE,
  KEY `is_display` (`is_display`) USING BTREE,
  KEY `type` (`type`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

-- ----------------------------
-- Records of zc_admin_menu
-- ----------------------------
INSERT INTO `zc_admin_menu` VALUES ('1', '系统', '', '', '', '', '系统设置。', '1', '1', '0', '0', '1517015748', 'fa-cog', '1', '0');
INSERT INTO `zc_admin_menu` VALUES ('2', '资产管理', '', '', '', '', '资产管理', '1', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('3', '基础资料', ' ', ' ', '', null, '基础资料', '1', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('4', '基础资料-资产分类', 'admin', 'assetsclassify', 'index', '', '基础资料', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('5', '基础资料-资产分类-添加', 'admin', 'assetsclassify', 'add', '', '基础资料-资产分类-添加', '1', '1', '4', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('6', '基础资料-资产分类-编辑', 'admin', 'assetsclassify', 'edit', '', '基础资料-资产分类-编辑', '1', '1', '4', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('7', '基础资料-资产分类-删除', 'admin', 'assetsclassify', 'remove', '', '基础资料-资产分类-删除', '1', '1', '4', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('8', '基础资料-取得方式', 'admin', 'obtain', 'index', '', '取得方式', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('9', '基础资料-取得方式-添加', 'admin', 'obtain', 'add', '', '基础资料-取得方式-添加', '1', '1', '8', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('10', '基础资料-取得方式-编辑', 'admin', 'obtain', 'edit', '', '基础资料-取得方式-编辑', '1', '1', '8', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('11', '基础资料-取得方式删除', 'admin', 'obtain', 'remove', '', '基础资料-取得方式-删除', '1', '1', '8', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('12', '基础资料-处置方式', 'admin', 'disposal', 'index', '', '处置方式', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('13', '基础资料-处置方式-添加', 'admin', 'disposal', 'add', '', '基础资料-处置方式-添加', '1', '1', '12', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('14', '基础资料-处置方式-编辑', 'admin', 'disposal', 'edit', '', '基础资料-处置方式-编辑', '1', '1', '12', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('15', '基础资料-处置方式-删除', 'admin', 'disposal', 'remove', '', '基础资料-处置方式-删除', '1', '1', '12', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('16', '基础资料-维护方式', 'admin', 'maintain', 'index', '', '维护', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('17', '基础资料-维护方式-添加', 'admin', 'maintain', 'add', '', '基础资料-维护-添加', '1', '1', '16', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('18', '基础资料-维护方式-编辑', 'admin', 'maintain', 'edit', '', '基础资料-维护方式-编辑', '1', '1', '16', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('19', '基础资料-维护方式-删除', 'admin', 'maintain', 'remove', '', '基础资料-维护方式-删除', '1', '1', '16', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('20', '基础资料-领用人维护', 'admin', 'receive', 'index', '', '领用人维护', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('21', '基础资料-领用人维护-部门添加', 'admin', 'receive', 'deptadd', '', '基础资料-领用人维护-部门添加', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('22', '基础资料-领用人维护-部门编辑', 'admin', 'receive', 'deptedit', '', '基础资料-领用人维护-部门编辑', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('23', '基础资料-领用人维护-部门删除', 'admin', 'receive', 'deletedept', '', '基础资料-领用人维护-部门删除', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('24', '基础资料-领用人维护-人员添加', 'admin', 'receive', 'add', '', '基础资料-领用人维护-人员添加', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('25', '基础资料-领用人维护-人员编辑', 'admin', 'receive', 'edit', '', '基础资料-领用人维护-人员编辑', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('26', '基础资料-领用人维护-人员删除', 'admin', 'receive', 'deleteall', '', '基础资料-领用人维护-人员删除', '1', '1', '20', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('27', '基础资料-资产编号', 'admin', 'number', 'index', '', '基础资料-资产编号', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('28', '基础资料-属性字段', 'admin', 'attribute', 'index', '', '基础资料-属性字段', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('29', '资产管理-固定资产', 'admin', 'asset', 'index', '', '资产管理-固定资产', '1', '1', '2', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('30', '资产管理-固定资产-新增', 'admin', 'asset', 'add', '', '资产管理-固定资产-新增', '1', '1', '29', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('31', '资产管理-固定资产-编辑', 'admin', 'asset', 'edit', '', '资产管理-固定资产-编辑', '1', '1', '29', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('32', '资产管理-固定资产-删除', 'admin', 'asset', 'deleteall', '', '资产管理-固定资产-删除', '1', '1', '29', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('33', '资产管理-固定资产-登记', 'admin', 'asset', 'register', '', '资产管理-固定资产-登记', '1', '1', '29', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('34', '资产管理-固定资产-反登记', 'admin', 'asset', 'noregister', '', '资产管理-固定资产-反登记', '1', '1', '29', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('35', '资产管理-领用分配', 'admin', 'useon', 'index', '', '资产管理-领用分配', '1', '1', '2', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('36', '资产管理-领用分配-添加领用', 'admin', 'useon', 'Useon', '', '资产管理-领用分配-添加领用', '1', '1', '35', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('37', '资产管理-资产处置', 'admin', 'disposal', 'index', '', '资产管理-资产处置', '1', '1', '2', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('38', '资产管理-资产处置-处置', 'admin', 'disposal', 'management', '', '资产管理-资产处置-处置', '1', '1', '37', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('39', '资产管理-资产处置-反处置', 'admin', 'disposal', 'nomanagement', '', '资产管理-资产处置-反处置', '1', '1', '37', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('40', '资产管理-资产处置-作废', 'admin', 'disposal', 'cancel', '', '资产管理-资产处置-作废', '1', '1', '37', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('41', '资产管理-资产处置-反作废', 'admin', 'disposal', 'nocancel', '', '资产管理-资产处置-反作废', '1', '1', '37', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('42', '基础资料-组别', 'admin', 'Admincate', 'index', '', '基础资料-组别', '1', '1', '1', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('43', '基础资料-组别-添加', 'admin', 'Admincate', 'add', '', '基础资料-组别-添加', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('44', '基础资料-组别-编辑', 'admin', 'Admincate', 'edit', '', '基础资料-组别-编辑', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('45', '基础资料-组别-删除', 'admin', 'Admincate', 'remove', '', '基础资料-组别-删除', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('46', '基础资料-用户管理', 'admin', 'admin', 'index', '', '基础资料-用户管理', '1', '1', '1', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('47', '基础资料-用户管理-添加', 'admin', 'admin', 'add', '', '基础资料-用户管理-添加', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('48', '基础资料-用户管理-编辑', 'admin', 'admin', 'edit', '', '基础资料-用户管理-编辑', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('49', '基础资料-用户管理-删除', 'admin', 'admin', 'remove', '', '基础资料-用户管理-删除', '1', '1', '42', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('50', '基础资料-备份', 'admin', 'backups', 'index', '', '基础资料-备份', '1', '1', '1', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('51', '基础资料-日志', 'admin', 'adminlog', 'index', '', '基础资料-日志', '1', '1', '1', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('52', '统计分析', ' ', ' ', '', '', '统计分析', '1', '2', '0', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('53', '统计分析-首页', 'admin', 'index', 'index', '', '统计分析-首页', '1', '2', '52', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('54', '统计分析-费用分析', 'admin', 'index', 'analysis', '', '统计分析-费用分析', '1', '2', '52', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('55', '基础资料-条码模板', 'admin', 'code', 'index', '', '基础资料-条码模板', '1', '1', '3', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('56', '基础资料-条码模板-新增', 'admin', 'code', 'add', '', '基础资料-条码模板-新增', '1', '1', '55', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('57', '资产管理-我的领用', 'admin', 'useon', 'myuseon', '', '资产管理-我的领用', '1', '1', '2', '0', '0', '0', '0', '0');
INSERT INTO `zc_admin_menu` VALUES ('58', '资产管理-资产处置', 'admin', 'disposal', 'assetsdisposal', '', '资产管理-资产处置', '1', '1', '2', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for zc_assets
-- ----------------------------
CREATE TABLE `zc_assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` int(11) DEFAULT NULL COMMENT '编号',
  `assets_classify_id` int(11) NOT NULL COMMENT '分类ID',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `obtain_id` int(11) DEFAULT NULL COMMENT '取得方式id',
  `admin_id` int(11) NOT NULL COMMENT '录入人员',
  `obtain_time` int(11) DEFAULT NULL COMMENT '取得日期',
  `money` double(15,0) DEFAULT NULL COMMENT '金额',
  `receive_dept_id` int(11) unsigned zerofill DEFAULT NULL COMMENT '领用部门',
  `receive_man_id` int(11) unsigned zerofill DEFAULT NULL COMMENT '领用人',
  `receive_time` int(11) unsigned zerofill DEFAULT NULL COMMENT '领用日期',
  `enter_time` int(11) DEFAULT NULL COMMENT '录入日期',
  `thumb` int(11) DEFAULT NULL COMMENT '图片',
  `info` varchar(255) DEFAULT NULL COMMENT '详细信息',
  `status` tinyint(1) NOT NULL COMMENT '状态(0未登记，1已登记,2已处置，3已废除)',
  `disposal_id` int(11) DEFAULT NULL COMMENT '处置ID',
  `disposal_desc` varchar(255) DEFAULT NULL COMMENT '处置备注',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_assets
-- ----------------------------
INSERT INTO `zc_assets` VALUES ('1', '2001', '2', '测试哦', '1', '1', '1539878400', '1', '00000000000', '00000000000', '00000000000', '1539878400', null, '{\"7\":\"\",\"8\":\"\"}', '1', null, null, '1539919509', '1539919509');

-- ----------------------------
-- Table structure for zc_assets_classify
-- ----------------------------
CREATE TABLE `zc_assets_classify` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `pid` int(11) DEFAULT NULL COMMENT '上级ID',
  `SN` int(11) DEFAULT NULL COMMENT '序列号',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_assets_classify
-- ----------------------------
INSERT INTO `zc_assets_classify` VALUES ('1', '1', '0', '6', '1534747748', '1536657156');
INSERT INTO `zc_assets_classify` VALUES ('2', 'test123啊啊', '1', '2', '1534756505', '1538034353');
INSERT INTO `zc_assets_classify` VALUES ('3', 'test2', '1', '3', '1534756511', '1534756511');
INSERT INTO `zc_assets_classify` VALUES ('4', 'test3', '1', '4', '1534763129', '1534763129');
INSERT INTO `zc_assets_classify` VALUES ('5', 'test', '0', '5', '1534830649', '1537941992');
INSERT INTO `zc_assets_classify` VALUES ('8', '啊啊啊啊啊啊', '5', '123', '1538034327', '1538034347');

-- ----------------------------
-- Table structure for zc_attachment
-- ----------------------------
CREATE TABLE `zc_attachment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` char(15) NOT NULL DEFAULT '' COMMENT '所属模块',
  `filename` char(50) NOT NULL DEFAULT '' COMMENT '文件名',
  `filepath` char(200) NOT NULL DEFAULT '' COMMENT '文件路径+文件名',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `fileext` char(10) NOT NULL DEFAULT '' COMMENT '文件后缀',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `uploadip` char(15) NOT NULL DEFAULT '' COMMENT '上传IP',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未审核1已审核-1不通过',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `admin_id` int(11) NOT NULL COMMENT '审核者id',
  `audit_time` int(11) NOT NULL COMMENT '审核时间',
  `use` varchar(200) DEFAULT NULL COMMENT '用处',
  `download` int(11) NOT NULL DEFAULT '0' COMMENT '下载量',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `filename` (`filename`) USING BTREE,
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='附件表';

-- ----------------------------
-- Records of zc_attachment
-- ----------------------------

-- ----------------------------
-- Table structure for zc_attribute
-- ----------------------------
CREATE TABLE `zc_attribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '属性名',
  `assets_classify_id` int(11) NOT NULL COMMENT '分类ID',
  `SN` int(11) DEFAULT NULL COMMENT '序号',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态(0小框，1大框)',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_attribute
-- ----------------------------
INSERT INTO `zc_attribute` VALUES ('7', 'test1', '2', '1', '0', '1535008364', '1535008364');
INSERT INTO `zc_attribute` VALUES ('8', 'test2', '2', '2', '1', '1535008371', '1535008371');

-- ----------------------------
-- Table structure for zc_backups
-- ----------------------------
CREATE TABLE `zc_backups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  `admin_id` int(11) NOT NULL COMMENT '执行人',
  `location` varchar(255) NOT NULL COMMENT '备份地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_backups
-- ----------------------------
INSERT INTO `zc_backups` VALUES ('1', '1539581965', '1539581965', '1', '1539581965.sql');

-- ----------------------------
-- Table structure for zc_campus
-- ----------------------------
CREATE TABLE `zc_campus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_campus
-- ----------------------------
INSERT INTO `zc_campus` VALUES ('1', '主校区', '1540260549', '1540260549');

-- ----------------------------
-- Table structure for zc_code
-- ----------------------------
CREATE TABLE `zc_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` tinyint(1) DEFAULT NULL COMMENT '编码(二维码0,条形码1)',
  `style` tinyint(1) DEFAULT NULL COMMENT '文本行数(1行，2行，3行)',
  `field1` varchar(25) DEFAULT NULL COMMENT '字段一',
  `field1_name` varchar(255) DEFAULT NULL COMMENT '字段一自定义名称',
  `field2` varchar(25) DEFAULT NULL COMMENT '字段二',
  `field2_name` varchar(255) DEFAULT NULL COMMENT '字段二自定义名称',
  `field3` varchar(25) DEFAULT NULL COMMENT '字段三',
  `field3_name` varchar(255) DEFAULT NULL COMMENT '字段三自定义名称',
  `status` tinyint(1) NOT NULL COMMENT '状态(0未选中，1已选中)',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_code
-- ----------------------------
INSERT INTO `zc_code` VALUES ('1', '1', '3', 'number', '自定义名称', 'assets_classify_id', '自定义名称', 'assets_classify_id', '所属分类', '0', '1538125021', '1538125021');
INSERT INTO `zc_code` VALUES ('4', '1', '3', 'receive_man_id', '领用人', 'admin_id', '录入人', 'receive_dept_id', '领用部门', '1', '1539919839', '1539919839');

-- ----------------------------
-- Table structure for zc_dept
-- ----------------------------
CREATE TABLE `zc_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `campus_id` int(11) DEFAULT NULL,
  `SN` int(11) NOT NULL,
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_dept
-- ----------------------------
INSERT INTO `zc_dept` VALUES ('11', '董事会', '1', '13', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('12', '校委会', '1', '12', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('13', '教务处', '1', '11', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('14', '政教处', '1', '10', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('15', '语文组', '1', '9', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('16', '数学组', '1', '8', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('17', '英语组', '1', '7', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('18', '物理组', '1', '6', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('19', '化学组', '1', '5', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('21', '生物组', '1', '4', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('22', '政治组', '1', '3', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('23', '历史组', '1', '2', '1540260549', '1540260549');
INSERT INTO `zc_dept` VALUES ('24', '地理组', '1', '1', '1540260549', '1540260549');

-- ----------------------------
-- Table structure for zc_disposal
-- ----------------------------
CREATE TABLE `zc_disposal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `SN` int(11) NOT NULL,
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_disposal
-- ----------------------------
INSERT INTO `zc_disposal` VALUES ('1', '1', '1', '1537340999', '1537340999');
INSERT INTO `zc_disposal` VALUES ('2', '2', '2', '1537341001', '1537942081');

-- ----------------------------
-- Table structure for zc_fault
-- ----------------------------
CREATE TABLE `zc_fault` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assets_id` int(11) NOT NULL COMMENT '资产ID',
  `receive_dept_id` int(11) DEFAULT NULL COMMENT '领用部门',
  `receive_man_id` int(11) DEFAULT NULL COMMENT '领用人',
  `admin_id` int(11) NOT NULL COMMENT '录入人员',
  `desc` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '状态(0未修复，1已修复)',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_fault
-- ----------------------------

-- ----------------------------
-- Table structure for zc_maintain
-- ----------------------------
CREATE TABLE `zc_maintain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `SN` int(11) DEFAULT NULL,
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_maintain
-- ----------------------------
INSERT INTO `zc_maintain` VALUES ('1', 'test', '1', '1534926398', '1534933450');

-- ----------------------------
-- Table structure for zc_maintain_info
-- ----------------------------
CREATE TABLE `zc_maintain_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assets_id` int(11) NOT NULL COMMENT '资产ID',
  `receive_dept_id` int(11) DEFAULT NULL COMMENT '领用部门',
  `receive_man_id` int(11) DEFAULT NULL COMMENT '领用人',
  `admin_id` int(11) NOT NULL COMMENT '录入人员',
  `maintain_id` int(11) DEFAULT NULL COMMENT '维护类型',
  `money` double(15,0) DEFAULT NULL COMMENT '维护费用',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态(0未修复，1已修复)',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_maintain_info
-- ----------------------------
INSERT INTO `zc_maintain_info` VALUES ('1', '1', null, null, '1', null, '1', '2', '1539919513', '1539919513');

-- ----------------------------
-- Table structure for zc_obtain
-- ----------------------------
CREATE TABLE `zc_obtain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `SN` int(11) DEFAULT NULL,
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_obtain
-- ----------------------------
INSERT INTO `zc_obtain` VALUES ('1', '12312那么', '0', '1534901278', '1539224802');
INSERT INTO `zc_obtain` VALUES ('2', 'admin', '2', '1534901587', '1534901587');
INSERT INTO `zc_obtain` VALUES ('3', 'name', '3', '1534902763', '1537942023');
INSERT INTO `zc_obtain` VALUES ('5', 'test123123', '1', '1534925559', '1537433436');

-- ----------------------------
-- Table structure for zc_receive_dept
-- ----------------------------
CREATE TABLE `zc_receive_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `campus_id` int(11) DEFAULT NULL,
  `dept_id` int(11) DEFAULT NULL,
  `SN` int(11) NOT NULL,
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_receive_dept
-- ----------------------------
INSERT INTO `zc_receive_dept` VALUES ('152', '主校区集体', '1', '0', '0', '1539421932', '1539421932');
INSERT INTO `zc_receive_dept` VALUES ('299', '地理组', '1', '24', '1', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('300', '历史组', '1', '23', '2', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('301', '政治组', '1', '22', '3', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('302', '生物组', '1', '21', '4', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('303', '化学组', '1', '19', '5', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('304', '物理组', '1', '18', '6', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('305', '英语组', '1', '17', '7', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('306', '数学组', '1', '16', '8', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('307', '语文组', '1', '15', '9', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('308', '政教处', '1', '14', '10', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('309', '教务处', '1', '13', '11', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('310', '校委会', '1', '12', '12', '1540260549', '1540260549');
INSERT INTO `zc_receive_dept` VALUES ('311', '董事会', '1', '11', '13', '1540260549', '1540260549');

-- ----------------------------
-- Table structure for zc_receive_man
-- ----------------------------
CREATE TABLE `zc_receive_man` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `card` varchar(50) DEFAULT NULL COMMENT '工号',
  `nickname` varchar(20) DEFAULT NULL COMMENT '昵称',
  `admin_id` int(11) DEFAULT NULL,
  `receive_dept_id` int(3) DEFAULT NULL COMMENT '部门ID',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=257 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_receive_man
-- ----------------------------
INSERT INTO `zc_receive_man` VALUES ('1', 'test', 'test', null, '9', '1536645514', '1536645514');
INSERT INTO `zc_receive_man` VALUES ('2', '123', '教室', null, '150', '1', '1');
INSERT INTO `zc_receive_man` VALUES ('203', 'sa', '超级管理员', '1', '311', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('208', 'js49', '陈思伊', '109', '304', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('209', 'js48', '郭鹿', '108', '304', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('210', 'js47', '金娜', '107', '304', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('211', 'js46', '王铁农', '106', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('212', 'js45', '饶文秀', '105', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('213', 'js44', '廖莎莎', '104', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('214', 'js43', '姜洁', '103', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('215', 'js42', '赵红亮', '102', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('216', 'js41', '李静', '101', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('217', 'js40', '石建红', '100', '306', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('218', 'js39', '黄新军', '99', '302', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('219', 'js38', '严海天', '98', '302', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('220', 'js37', '骆思', '97', '303', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('221', 'js36', '徐方', '96', '302', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('222', 'js35', '龚依琴', '95', '303', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('223', 'js19', '徐  娟', '79', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('224', 'js18', '王桃瑞', '78', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('225', 'js17', '宋红辉', '77', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('226', 'js16', '李雄', '76', '301', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('227', 'js15', '吴启新', '75', '301', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('228', 'js14', '黄巢', '74', '301', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('229', 'js13', '骆伟', '73', '308', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('230', 'js12', '程碧华', '72', '308', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('231', 'js11', '程天明', '71', '308', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('232', 'js10', '钟泽宇', '70', '309', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('233', 'js09', '尧新良', '69', '309', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('234', 'js08', '庞伯良', '68', '309', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('235', 'js34', '陈安格', '94', '303', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('236', 'js33', '甘梦月', '93', '305', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('237', 'js32', '沈瑜', '92', '305', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('238', 'js31', '廖健平', '91', '305', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('239', 'js30', '曾炳林', '90', '305', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('240', 'js29', '刘锦芳', '89', '305', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('241', 'js28', '曾雅宾', '88', '299', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('242', 'js27', '杨伟新', '87', '300', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('243', 'js26', '任力凤', '86', '300', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('244', 'js25', '郭邹维', '85', '300', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('245', 'js24', '吴洁', '84', '299', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('246', 'js23', '方丽嫦', '83', '299', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('247', 'js22', '邓 欢', '82', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('248', 'js21', '魏灵丹', '81', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('249', 'js20', '吴助佳', '80', '307', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('250', 'js07', '陈卫东', '67', '310', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('251', 'js06', '舒其兵', '66', '310', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('252', 'js05', '汪梦思', '65', '310', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('253', 'js04', '孙恒', '64', '311', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('254', 'js03', '叶总丽', '63', '311', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('255', 'js02', '夏雷', '62', '311', '1540260551', '1540260551');
INSERT INTO `zc_receive_man` VALUES ('256', 'js01', '钟俊', '61', '311', '1540260551', '1540260551');

-- ----------------------------
-- Table structure for zc_useon
-- ----------------------------
CREATE TABLE `zc_useon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receive_dept_id` int(11) NOT NULL COMMENT '领用部门',
  `receive_man_id` int(11) DEFAULT NULL COMMENT '领用人',
  `receive_time` int(11) DEFAULT NULL COMMENT '领用日期',
  `assets_id` int(11) DEFAULT NULL,
  `tel` bigint(50) DEFAULT NULL,
  `site` varchar(255) DEFAULT NULL,
  `back_time` int(11) DEFAULT NULL,
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zc_useon
-- ----------------------------
INSERT INTO `zc_useon` VALUES ('4', '3', '0', '1537200000', '22', '0', '', '1537269035', '1537262478', '1537262478');
INSERT INTO `zc_useon` VALUES ('5', '5', '2', '1536768000', '19', null, null, null, '1537955114', '1537955114');
INSERT INTO `zc_useon` VALUES ('8', '2', '24', '1539014400', '41', '123', '123', null, '1539068166', '1539068166');
INSERT INTO `zc_useon` VALUES ('9', '2', '24', '1539100800', '38', '123', '', '1539219519', '1539219093', '1539219093');
INSERT INTO `zc_useon` VALUES ('10', '2', '24', '1539014400', '39', '123', '是答案是', '1539219916', '1539219905', '1539219905');
INSERT INTO `zc_useon` VALUES ('11', '2', '24', '1539187200', '39', '123', '', '1539220002', '1539219996', '1539219996');
INSERT INTO `zc_useon` VALUES ('12', '2', '24', '1539187200', '39', '13655542827', '', '1539220143', '1539220133', '1539220133');
