-- phpMyAdmin SQL Dump
-- version 4.7.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2018-07-12 03:29:53
-- 服务器版本： 5.5.56-MariaDB
-- PHP Version: 7.0.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `factory8`
--

-- --------------------------------------------------------

--
-- 表的结构 `ao_com_notice`
--

CREATE TABLE IF NOT EXISTS `ao_com_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `published_on` datetime NOT NULL COMMENT '发布时间',
  `published_by` varchar(20) DEFAULT NULL COMMENT '发布人',
  `published_by_dept_name` varchar(30) NOT NULL COMMENT '发布部门',
  `notice_type` char(1) DEFAULT NULL COMMENT '通告类型A全体,F飞行,C乘务员,S安全员',
  `notice_level` char(1) DEFAULT NULL COMMENT '通告等级G局方，C公司，D部门',
  `notice_cat` varchar(20) DEFAULT NULL COMMENT '通告类型:字典 安全提示签派提示',
  `language` varchar(5) NOT NULL COMMENT '语言zh-CN,en',
  `is_must_reed` tinyint(1) DEFAULT '0' COMMENT '1必读，0选读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公司公告';

-- --------------------------------------------------------

--
-- 表的结构 `ao_file_learning`
--

CREATE TABLE IF NOT EXISTS `ao_file_learning` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL COMMENT '标题',
  `content` varchar(2000) DEFAULT NULL COMMENT '内容',
  `published_on` datetime NOT NULL COMMENT '发布时间',
  `published_by` varchar(20) DEFAULT NULL COMMENT '发布人',
  `published_by_dept_name` varchar(30) NOT NULL COMMENT '发布部门',
  `notice_type` char(1) DEFAULT NULL COMMENT '通告类型A全体,F飞行,C乘务员,S安全员',
  `file_path` varchar(20) DEFAULT NULL COMMENT '文件路径',
  `language` varchar(5) NOT NULL COMMENT '语言zh-CN,en',
  `is_must_reed` tinyint(1) DEFAULT '0' COMMENT '1必读，0选读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件学习';

-- --------------------------------------------------------

--
-- 表的结构 `com_dictionary`
--

CREATE TABLE IF NOT EXISTS `com_dictionary` (
  `dict_id` int(11) NOT NULL AUTO_INCREMENT,
  `dict_code` varchar(20) NOT NULL COMMENT '字典编码',
  `dict_name` varchar(50) NOT NULL COMMENT '字典名称',
  `dict_type` varchar(20) NOT NULL COMMENT '字典类型,clientLevel,certType',
  `parent_dict_id` int(11) DEFAULT NULL COMMENT '父类型ID默认为0',
  `dict_name_en` varchar(50) DEFAULT NULL COMMENT '字典英文名称',
  `enable_state` char(1) NOT NULL COMMENT '启用状态，1为启用，0禁用',
  `order_no` tinyint(4) DEFAULT NULL COMMENT '排序值',
  `dict_ico` varchar(50) DEFAULT NULL COMMENT '字典图标地址',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`dict_id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8 COMMENT='数据字典';

--
-- 转存表中的数据 `com_dictionary`
--

INSERT INTO `com_dictionary` (`dict_id`, `dict_code`, `dict_name`, `dict_type`, `parent_dict_id`, `dict_name_en`, `enable_state`, `order_no`, `dict_ico`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
(48, 'BORD', '登机证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(49, 'CTC', '乘务训练合格证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(50, 'AQY', '安全员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(51, 'APL', '空警执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(52, 'TC', '乘务训练合格证2', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(53, 'PASS', '国际护照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(54, 'TXZP', '港澳通行证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(55, 'TWOU', '大陆通行证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(56, 'TWIN', '入台许可证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(57, 'HEAL', '体检合格证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(58, 'DWSS', '是大法官', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(60, 'LDHT', '外籍合同', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(61, 'CP', '商用驾驶员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(62, 'AP', '航线运输驾驶员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(63, 'WEVI', '东南亚签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(64, 'AMVI', '美国签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(65, 'AUVI', '澳洲签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(66, 'EUVI', '欧洲签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(67, 'KOVI', '日韩签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(68, 'TWVI', '台湾签注', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(69, 'VISA', '签证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(70, 'GJJK', '国际健康证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 09:53:31', NULL, NULL, NULL),
(71, 'LDWK', '外籍工作证', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 10:01:08', NULL, NULL, NULL),
(72, 'TA', 'A类教员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 11:49:29', NULL, NULL, NULL),
(73, 'TB', 'B类教员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 11:49:29', NULL, NULL, NULL),
(74, 'TCHC', 'C类教员执照', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 11:49:29', NULL, NULL, NULL),
(75, 'APL', 'APL', 'certType', NULL, NULL, '', NULL, NULL, '2017-11-10 11:50:01', NULL, NULL, NULL),
(76, 'N001', '安全提示', 'N_TYPE', NULL, 'SAFETY SIGNS', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(77, 'N002', '操作通告', 'N_TYPE', NULL, 'OPERRATE NOTICE', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(78, 'N003', '运行规定', 'N_TYPE', NULL, 'OPERATING PROVISIONS', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(79, 'N004', '性能通告', 'N_TYPE', NULL, 'PROPERTY NOTICE', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(80, 'N005', '签派提示', 'N_TYPE', NULL, 'DISPATCH PROMPT', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(81, 'N010', '一般通知', 'N_TYPE', NULL, 'GENARAL NOTICE', '', NULL, NULL, '2017-11-11 05:59:52', NULL, NULL, NULL),
(82, 'F001', '手册', 'F_TYPE', NULL, 'MANUAL', '', NULL, NULL, '2017-11-11 06:02:41', NULL, NULL, NULL),
(83, 'F002', '文件', 'F_TYPE', NULL, 'FILE', '', NULL, NULL, '2017-11-11 06:02:41', NULL, NULL, NULL),
(84, 'FlightTechnicalManua', '飞行技术手册', 'handbook_type', NULL, 'SAFETY SIGNS', '', NULL, NULL, '2017-11-11 08:11:08', NULL, NULL, NULL),
(85, 'Operation_Specificat', '运行规范', 'handbook_type', NULL, 'OPERRATE NOTICE', '', NULL, NULL, '2017-11-11 08:11:08', NULL, NULL, NULL),
(86, 'Operation_Manual', '运行手册', 'handbook_type', NULL, 'OPERATING PROVISIONS', '', NULL, NULL, '2017-11-11 08:11:08', NULL, NULL, NULL),
(88, 'VVIP', 'VVIP', 'clientLevel', NULL, NULL, '', NULL, NULL, '2017-11-11 10:06:35', NULL, NULL, NULL),
(89, 'VIP', 'VIP', 'clientLevel', NULL, NULL, '', NULL, NULL, '2017-11-11 10:06:35', NULL, NULL, NULL),
(90, 'CIP', 'CIP', 'clientLevel', NULL, NULL, '', NULL, NULL, '2017-11-11 10:06:35', NULL, NULL, NULL),
(91, 'F', '飞行员', 'userType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(92, 'S', '安全员', 'userType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(93, 'C', '乘务员', 'userType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(95, '0', '无效', 'status', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(96, '1', '有效', 'status', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(97, 'zh_CN', '中文', 'language', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(98, 'en', '英文', 'language', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(99, 'F001', '手册', 'fileType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(100, 'F002', '文件', 'fileType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(101, 'MSG0100', '通知通告消息', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(102, 'MSG0200', '网上准备提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(103, 'MSG0300', '飞行任务提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(104, 'MSG0400', '证照过期提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(105, 'MSG0500', '培训训练提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(106, 'MSG0600', '签到提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(107, 'MSG0700', '酒测超标', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(108, 'MSG0800', '航班状态提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(109, 'MSG0900', '健康状况提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(110, 'MSG1000', '高端旅客提醒', 'msgType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(111, 'N001', '安全指示', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(112, 'N002', '操作通告', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(113, 'N003', '运行规定', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(114, 'N004', '性能通告', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(115, 'N005', '签派提示', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(116, 'N010', '一般通知', 'noticeCat', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(117, '0', '隐藏', 'openType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(118, '1', '公开', 'openType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(119, '0', '隐藏', 'openWx', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(120, '1', '公开', 'openWx', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(121, '0', '隐藏', 'openParAddr', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(122, '1', '公开', 'openParAddr', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(123, '0', '隐藏', 'openCarId', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(124, '1', '公开', 'openCarId', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(125, '0', '隐藏', 'openAddr', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(126, '1', '公开', 'openAddr', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(127, '1', '健康状况', 'checkType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(128, '2', '证照', 'checkType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(129, 'A', '所有统计', 'countType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(130, 'D', '日统计', 'countType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(131, 'M', '月统计', 'countType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(132, 'Q', '季统计', 'countType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(133, 'Y', '年统计', 'countType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(134, 'O', '其它考试题', 'examType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(135, 'P', '航前准备题', 'examType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(136, 'C', '乘务', 'fpType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(137, 'F', '飞行', 'fpType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(138, 'S', '安全', 'fpType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(139, '0', '非全天', 'isAllday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(140, '1', '全天', 'isAllday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(141, '0', '未完成', 'isFinished', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(142, '1', '完成', 'isFinished', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(143, '0', '选读', 'isMustReed', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(144, '1', '必读', 'isMustReed', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(145, '0', '未通过', 'isPassed', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(146, '1', '通过', 'isPassed', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(147, '0', '未读', 'isRead', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(148, '1', '已读', 'isRead', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(149, '0', '回答错误', 'isRight', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(150, '1', '回答正确', 'isRight', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(151, '0', '不显示', 'isShow', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(152, '1', '显示', 'isShow', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(153, 'DD', '特急报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(154, 'FF', '加急报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(155, 'GG', '急报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(156, 'JJ', '快报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(157, 'LL', '平报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(158, 'SS', '遇险报', 'noteLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(159, 'C', '公司', 'noticeLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(160, 'D', '部门', 'noticeLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(161, 'G', '局方', 'noticeLevel', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(162, 'A', '全部', 'noticeType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(163, 'C', '乘务员', 'noticeType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(164, 'F', '飞行员', 'noticeType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(165, 'S', '安全员', 'noticeType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(166, '1', '单项选择', 'questType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(167, '2', '多项选择', 'questType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(168, '3', '填空', 'questType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(169, '4', '问答题', 'questType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(170, '0', '未读', 'readState', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(171, '1', '已读', 'readState', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(172, 'B', '按钮', 'resType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(173, 'M', '菜单', 'resType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(174, 'C', '乘务', 'roleType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(175, 'F', '飞行', 'roleType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(176, 'S', '安全', 'roleType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(177, '0', '无效', 'state', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(178, '1', '有效', 'state', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(179, '1', '全部', 'targetUserType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(180, '2', '中方', 'targetUserType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(181, '3', '外籍', 'targetUserType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(182, '4', '港澳', 'targetUserType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(183, '5', '台湾', 'targetUserType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(184, 'A', '全部', 'userType', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(188, '0', '星期日', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(189, '1', '星期一', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(190, '2', '星期二', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(191, '3', '星期三', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(192, '4', '星期四', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(193, '5', '星期五', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(194, '6', '星期六', 'weekday', NULL, NULL, '1', NULL, NULL, '2017-11-13 09:50:49', NULL, NULL, NULL),
(195, 'IFS13', '乘务督查', 'C_Tech_Level', NULL, NULL, '', 14, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(196, 'IFS12', '乘务检查员', 'C_Tech_Level', NULL, NULL, '', 13, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(197, 'IFS11', '公司检查员', 'C_Tech_Level', NULL, NULL, '', 12, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(198, 'IFS1', '乘务教员', 'C_Tech_Level', NULL, NULL, '', 11, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(199, 'IFS9', '三级乘务长', 'C_Tech_Level', NULL, NULL, '', 10, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(200, 'IFS8', '二级乘务长', 'C_Tech_Level', NULL, NULL, '', 9, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(201, 'IPS', '一级乘务长', 'C_Tech_Level', NULL, NULL, '', 8, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(202, 'IFS6', '见习乘务长', 'C_Tech_Level', NULL, NULL, '', 7, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(203, 'IFS', '二级区域乘务长', 'C_Tech_Level', NULL, NULL, '', 6, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(204, 'IFS4', '一级区域乘务长', 'C_Tech_Level', NULL, NULL, '', 5, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(205, 'ISS', '乘务员', 'C_Tech_Level', NULL, NULL, '', 4, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(206, 'IFS2', '初级乘务员', 'C_Tech_Level', NULL, NULL, '', 3, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(207, 'IJS', '见习乘务员', 'C_Tech_Level', NULL, NULL, '', 2, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(208, 'IFS0', '乘务学员', 'C_Tech_Level', NULL, NULL, '', 1, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(209, 'IS7', '安全员教员', 'S_Tech_Level', NULL, NULL, '', 8, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(210, 'IS6', '资深安全员', 'S_Tech_Level', NULL, NULL, '', 7, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(211, 'IS5', '高级安全员', 'S_Tech_Level', NULL, NULL, '', 6, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(212, 'IS4', '中级安全员', 'S_Tech_Level', NULL, NULL, '', 5, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(213, 'IS3', '初级安全员', 'S_Tech_Level', NULL, NULL, '', 4, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(214, 'IS8', '安全员检查员', 'S_Tech_Level', NULL, NULL, '', 3, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(215, 'IS2', '见习安全员', 'S_Tech_Level', NULL, NULL, '', 2, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(216, 'IS1', '安全员学员', 'S_Tech_Level', NULL, NULL, '', 1, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(217, 'IB001', 'C类教员', 'F_Tech_Level', NULL, NULL, '', 15, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(218, 'IB002', 'B类教员', 'F_Tech_Level', NULL, NULL, '', 14, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(219, 'IB003', 'A类教员', 'F_Tech_Level', NULL, NULL, '', 13, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(220, 'IC003', '三级机长', 'F_Tech_Level', NULL, NULL, '', 12, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(221, 'IC002', '二级机长', 'F_Tech_Level', NULL, NULL, '', 11, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(222, 'IC001', '一级机长', 'F_Tech_Level', NULL, NULL, '', 10, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(223, 'IC004', '新机长', 'F_Tech_Level', NULL, NULL, '', 9, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(224, 'ID001', '资深副驾', 'F_Tech_Level', NULL, NULL, '', 8, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(225, 'ID002', '五级副驾', 'F_Tech_Level', NULL, NULL, '', 7, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(226, 'ID003', '四级副驾', 'F_Tech_Level', NULL, NULL, '', 6, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(227, 'ID004', '三级副驾', 'F_Tech_Level', NULL, NULL, '', 5, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(228, 'ID005', '二级副驾', 'F_Tech_Level', NULL, NULL, '', 4, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(229, 'ID006', '一级副驾', 'F_Tech_Level', NULL, NULL, '', 3, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(230, 'ID007', '初级副驾', 'F_Tech_Level', NULL, NULL, '', 2, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(231, 'ID008', '观察员', 'F_Tech_Level', NULL, NULL, '', 1, NULL, '2017-11-15 10:16:41', NULL, NULL, NULL),
(258, 'func_error', '功能问题', 'feedbackType', NULL, NULL, '', NULL, NULL, '2017-11-16 08:57:10', NULL, NULL, NULL),
(259, 'fit_error', '兼容性问题', 'feedbackType', NULL, NULL, '', NULL, NULL, '2017-11-16 08:57:10', NULL, NULL, NULL),
(260, 'crash_error', '闪退、卡顿问题', 'feedbackType', NULL, NULL, '', NULL, NULL, '2017-11-16 08:57:10', NULL, NULL, NULL),
(261, 'ue_error', '用户体验问题', 'feedbackType', NULL, NULL, '', NULL, NULL, '2017-11-16 08:57:10', NULL, NULL, NULL),
(262, 'other_error', '其他问题', 'feedbackType', NULL, NULL, '', NULL, NULL, '2017-11-16 08:57:10', NULL, NULL, NULL),
(263, '0', '错误', 'isRightKey', NULL, NULL, '1', NULL, NULL, '2017-11-21 10:59:16', NULL, NULL, NULL),
(264, '1', '正确', 'isRightKey', NULL, NULL, '1', NULL, NULL, '2017-11-21 10:59:16', NULL, NULL, NULL),
(265, '1', '全体', 'userScope', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(266, '2', '特定范围', 'userScope', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(267, '1', '随机', 'examQuestScope', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(268, '2', '指定', 'examQuestScope', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(269, 'A', '通用', 'foreignerPilot', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(270, 'D', '国内航线', 'foreignerPilot', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(271, 'I', '外籍航线', 'foreignerPilot', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(272, 'Z', '主用航路', 'routeType', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(273, 'B', '备用航路', 'routeType', NULL, NULL, '1', NULL, NULL, '2017-11-27 01:30:18', NULL, NULL, NULL),
(283, 'OSHOTEL', '酒店', 'outstationType', NULL, NULL, '', NULL, NULL, '2017-11-27 09:36:06', NULL, NULL, NULL),
(284, 'INNERBUS', '内场机组车', 'outstationType', NULL, NULL, '', NULL, NULL, '2017-11-27 09:36:06', NULL, NULL, NULL),
(285, 'OUTBUS', '外场机组车', 'outstationType', NULL, NULL, '', NULL, NULL, '2017-11-27 09:36:06', NULL, NULL, NULL),
(293, '0', '间隔扫描', 'trigerType', NULL, NULL, '1', NULL, NULL, '2017-12-04 07:04:03', NULL, NULL, NULL),
(294, '1', '定时扫描', 'trigerType', NULL, NULL, '1', NULL, NULL, '2017-12-04 07:04:03', NULL, NULL, NULL),
(295, '1', 'APP内推', 'sendType', NULL, NULL, '1', NULL, NULL, '2017-12-04 07:04:03', NULL, NULL, NULL),
(296, '2', '短信', 'sendType', NULL, NULL, '1', NULL, NULL, '2017-12-04 07:04:03', NULL, NULL, NULL),
(297, '1', '发布中版本', 'isCurrent', NULL, NULL, '1', NULL, NULL, '2017-12-06 05:46:40', NULL, NULL, NULL),
(298, '0', '历史版本', 'isCurrent', NULL, NULL, '1', NULL, NULL, '2017-12-06 05:46:40', NULL, NULL, NULL),
(299, '0', '不在', 'onBlackList', NULL, NULL, '1', NULL, NULL, '2017-12-06 05:46:40', NULL, NULL, NULL),
(300, '1', '在', 'onBlackList', NULL, NULL, '1', NULL, NULL, '2017-12-06 05:46:40', NULL, NULL, NULL),
(301, 'N006', '风险预警', 'N_TYPE', NULL, 'RISK NOTICE', '', NULL, NULL, '2017-12-07 06:38:55', NULL, NULL, NULL),
(302, 'N007', '业务通告', 'N_TYPE', NULL, 'BUSINESS NOTICE', '', NULL, NULL, '2017-12-07 06:38:55', NULL, NULL, NULL),
(303, 'F', '飞行员', 'crewType', NULL, NULL, '1', NULL, NULL, '2017-12-07 09:42:47', NULL, NULL, NULL),
(304, 'C', '乘务员', 'crewType', NULL, NULL, '1', NULL, NULL, '2017-12-07 09:42:47', NULL, NULL, NULL),
(305, 'S', '安全员', 'crewType', NULL, NULL, '1', NULL, NULL, '2017-12-07 09:42:47', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `com_dictionary_mapping`
--

CREATE TABLE IF NOT EXISTS `com_dictionary_mapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dict_type` varchar(30) DEFAULT NULL COMMENT '平台字典类型',
  `dict_code_cloud` varchar(20) NOT NULL COMMENT '平台字典项编号',
  `dict_code_third_sys` varchar(20) DEFAULT NULL COMMENT '第三方系统字典项编号',
  `dict_code_third_type` varchar(20) DEFAULT NULL COMMENT '第三方系统中字典类型，abnormal_reason不正常原因',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`id`),
  KEY `ind_dict_mapping_third_sys` (`dict_code_third_sys`,`dict_code_third_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='第三方数据字典com_dictionary与业务系统字典映射';

--
-- 转存表中的数据 `com_dictionary_mapping`
--

INSERT INTO `com_dictionary_mapping` (`id`, `dict_type`, `dict_code_cloud`, `dict_code_third_sys`, `dict_code_third_type`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
(1, 'certType', 'TCHC', 'TC', NULL, '2017-11-15 11:44:35', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `ep_board_spot`
--

CREATE TABLE IF NOT EXISTS `ep_board_spot` (
  `combine_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '对应关系编码',
  `ep_id` int(11) NOT NULL COMMENT '采集机ID',
  `board_id` int(11) NOT NULL COMMENT '控制板ID',
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `arg` int(11) NOT NULL COMMENT '附加参数',
  PRIMARY KEY (`combine_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='采集点对应';

-- --------------------------------------------------------

--
-- 表的结构 `ep_config`
--

CREATE TABLE IF NOT EXISTS `ep_config` (
  `ep_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '采集机ID',
  `flow_id` int(11) NOT NULL COMMENT '生产线ID',
  `spots` int(11) NOT NULL COMMENT '工位数量',
  `extra` varchar(5000) NOT NULL COMMENT '设置选项',
  PRIMARY KEY (`ep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='采集设置';

-- --------------------------------------------------------

--
-- 表的结构 `ep_state`
--

CREATE TABLE IF NOT EXISTS `ep_state` (
  `ep_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '采集机ID',
  `spot_data` varchar(5000) NOT NULL COMMENT '工位数据',
  `spot_worker` varchar(5000) NOT NULL COMMENT '工人产量数据',
  PRIMARY KEY (`ep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='采集状态';

-- --------------------------------------------------------

--
-- 表的结构 `ep_system`
--

CREATE TABLE IF NOT EXISTS `ep_system` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `ep_id` int(11) NOT NULL COMMENT '设备Id',
  `cpu` varchar(100) NOT NULL COMMENT 'CPU使用',
  `memory` varchar(100) NOT NULL COMMENT '内存使用',
  `processes` varchar(5000) NOT NULL COMMENT '进程信息',
  `os` varchar(100) NOT NULL COMMENT '操作系统',
  `runtime` varchar(2000) NOT NULL COMMENT '运行环境',
  PRIMARY KEY (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='采集机运行状态';

-- --------------------------------------------------------

--
-- 表的结构 `fc_bi_factory_daily`
--

CREATE TABLE IF NOT EXISTS `fc_bi_factory_daily` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据标识',
  `pass_num` int(11) NOT NULL COMMENT '合格品数量',
  `fc_day` date NOT NULL COMMENT '记录日期',
  `fail_num` int(11) NOT NULL COMMENT '坏品数量',
  `fail_rate` int(11) NOT NULL COMMENT '坏品率',
  `avg_due` int(11) NOT NULL COMMENT '平均堆积数',
  PRIMARY KEY (`data_id`),
  UNIQUE KEY `fc_day` (`fc_day`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='全厂按日统计';

-- --------------------------------------------------------

--
-- 表的结构 `fc_bi_flow_daily`
--

CREATE TABLE IF NOT EXISTS `fc_bi_flow_daily` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '统计ID',
  `flow_id` int(11) NOT NULL COMMENT '生产线ID',
  `fc_day` date NOT NULL COMMENT '记录日期',
  `fail_num` int(11) NOT NULL COMMENT '坏品数量',
  `fail_rate` int(11) NOT NULL COMMENT '坏品率',
  `avg_due` int(11) NOT NULL COMMENT '平均堆积数',
  `pass_num` int(11) NOT NULL COMMENT '合格品数量',
  PRIMARY KEY (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COMMENT='产线按日统计';

-- --------------------------------------------------------

--
-- 表的结构 `fc_bi_worker_daily`
--

CREATE TABLE IF NOT EXISTS `fc_bi_worker_daily` (
  `data_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '统计数据ID',
  `worker_id` int(11) NOT NULL COMMENT '员工ID',
  `fc_day` date NOT NULL COMMENT '记录日期',
  `fail_num` int(11) NOT NULL COMMENT '坏品数量',
  `fail_rate` int(11) NOT NULL COMMENT '坏品率',
  `avg_due` int(11) NOT NULL COMMENT '平均堆积数',
  `pass_num` int(11) NOT NULL COMMENT '合格品数量',
  PRIMARY KEY (`data_id`),
  UNIQUE KEY `worker_id` (`worker_id`,`fc_day`)
) ENGINE=InnoDB AUTO_INCREMENT=676 DEFAULT CHARSET=utf8 COMMENT='按日统计';

-- --------------------------------------------------------

--
-- 表的结构 `fc_flow`
--

CREATE TABLE IF NOT EXISTS `fc_flow` (
  `flow_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '生产线ID',
  `flow_name` varchar(100) NOT NULL COMMENT '生产线名称',
  `flow_place` varchar(100) NOT NULL COMMENT '生产线地点',
  `flow_master_id` int(11) NOT NULL COMMENT '负责人ID',
  `flow_spots` int(11) NOT NULL COMMENT '生产线工位数量',
  PRIMARY KEY (`flow_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='生产线信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_sector`
--

CREATE TABLE IF NOT EXISTS `fc_sector` (
  `sector_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '工序ID',
  `sector_name` varchar(200) NOT NULL COMMENT '工序名称',
  `flow_id` int(11) NOT NULL COMMENT '生产线ID',
  `sector_order` int(11) NOT NULL COMMENT '产线内顺序',
  `counter` int(11) DEFAULT '1' COMMENT '计数方法',
  PRIMARY KEY (`sector_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='工序定义';

-- --------------------------------------------------------

--
-- 表的结构 `fc_sector_spot`
--

CREATE TABLE IF NOT EXISTS `fc_sector_spot` (
  `combine_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关系ID',
  `sector_id` int(11) NOT NULL COMMENT '工序ID',
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `spot_order` int(11) NOT NULL COMMENT '工序内工位顺序',
  PRIMARY KEY (`combine_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='工序内部';

-- --------------------------------------------------------

--
-- 表的结构 `fc_spot`
--

CREATE TABLE IF NOT EXISTS `fc_spot` (
  `spot_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '工位ID',
  `flow_id` int(11) NOT NULL COMMENT '生产线ID',
  `spot_name` varchar(50) DEFAULT NULL COMMENT '工位名称',
  `order_num` int(11) NOT NULL COMMENT '生产线内顺序',
  `ratio` int(11) NOT NULL COMMENT '产能比例',
  PRIMARY KEY (`spot_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COMMENT='生产工位表';

-- --------------------------------------------------------

--
-- 表的结构 `fc_spot_extra`
--

CREATE TABLE IF NOT EXISTS `fc_spot_extra` (
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `spot_period` int(11) NOT NULL COMMENT '工位统计周期',
  `spot_threshold_failnum` int(11) NOT NULL COMMENT '坏品数阈值',
  `spot_threshold_failrate` decimal(10,0) NOT NULL COMMENT '坏品率阈值',
  `spot_threshold_min_output` int(11) NOT NULL COMMENT '产能阈值',
  PRIMARY KEY (`spot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='工位统计信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_system_event`
--

CREATE TABLE IF NOT EXISTS `fc_system_event` (
  `sysev_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '事件记录ID',
  `event_type` int(11) NOT NULL COMMENT '事件类型',
  `event_level` int(11) NOT NULL COMMENT '事件严重等级',
  `event_title` varchar(300) DEFAULT NULL COMMENT '事件标题',
  `event_detail` varchar(1000) DEFAULT NULL COMMENT '事件详情',
  `event_status` int(11) NOT NULL COMMENT '事件状态',
  `time_point` bigint(20) NOT NULL COMMENT '发生时间',
  PRIMARY KEY (`sysev_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12971 DEFAULT CHARSET=utf8 COMMENT='系统事件';

-- --------------------------------------------------------

--
-- 表的结构 `fc_worker`
--

CREATE TABLE IF NOT EXISTS `fc_worker` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '本系统用户ID',
  `user_local_no` char(30) DEFAULT NULL COMMENT '公司内工号',
  `user_login_name` varchar(50) DEFAULT NULL COMMENT '员工设备名',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `user_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `user_name_en` varchar(50) DEFAULT NULL COMMENT '拼音',
  `mobile_phone` varchar(50) DEFAULT NULL COMMENT '手机',
  `dept_id` varchar(50) DEFAULT NULL COMMENT '部门ID',
  `dept_name` varchar(30) DEFAULT NULL COMMENT '部门名称',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态1有效，0无效',
  `gender` varchar(1) DEFAULT NULL COMMENT '性别',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人的工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人的工号',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_local_no` (`user_local_no`),
  KEY `idx_userno` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='员工信息表';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_period`
--

CREATE TABLE IF NOT EXISTS `fc_work_period` (
  `period_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '时间段ID',
  `period_name` varchar(100) NOT NULL COMMENT '时间段名称',
  `start_second` int(11) NOT NULL COMMENT '开始时间',
  `end_second` int(11) NOT NULL COMMENT '结束时间',
  PRIMARY KEY (`period_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='工作时间段信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_raw`
--

CREATE TABLE IF NOT EXISTS `fc_work_raw` (
  `raw_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '原始数据ID',
  `schedule_id` int(11) NOT NULL DEFAULT '0' COMMENT '班次ID',
  `board_id` int(11) NOT NULL COMMENT '控制板ID',
  `timing` bigint(20) NOT NULL COMMENT '时间点',
  `handheld_id` int(11) NOT NULL COMMENT '手持ID',
  `pass_num` int(11) NOT NULL COMMENT '合格品数量',
  `total_num` int(11) NOT NULL COMMENT '总计数量',
  `hand_pass` int(11) NOT NULL COMMENT '手持合格数',
  `hand_total` int(11) NOT NULL COMMENT '手持总计数',
  PRIMARY KEY (`raw_id`),
  KEY `handheld_id` (`handheld_id`),
  KEY `board_id` (`board_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121611 DEFAULT CHARSET=utf8 COMMENT='原始工作量数据';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_schedule`
--

CREATE TABLE IF NOT EXISTS `fc_work_schedule` (
  `schedule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '班次ID',
  `work_day` date NOT NULL COMMENT '班次日期',
  `start_time` datetime NOT NULL COMMENT '实际开始',
  `end_time` datetime NOT NULL COMMENT '实际结束',
  `period_id` int(11) NOT NULL COMMENT '工作时间段ID',
  `flow_id` int(11) NOT NULL COMMENT '生产线ID',
  `start_uid` int(11) NOT NULL COMMENT '上班操作人',
  `end_uid` int(11) NOT NULL COMMENT '下班操作人',
  `status` int(11) NOT NULL COMMENT '班次状态',
  PRIMARY KEY (`schedule_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='班次信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_schedule_event`
--

CREATE TABLE IF NOT EXISTS `fc_work_schedule_event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '事件记录ID',
  `schedule_id` int(11) NOT NULL COMMENT '班次ID',
  `evtype` int(11) NOT NULL COMMENT '事件类型',
  `period_id` int(11) NOT NULL COMMENT '时间段ID',
  `worker_id` int(11) NOT NULL COMMENT '工人ID',
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `occurance` datetime NOT NULL COMMENT '实际发生时间',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='工作上下班信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_schedule_load`
--

CREATE TABLE IF NOT EXISTS `fc_work_schedule_load` (
  `load_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '班次产量ID',
  `schedule_id` int(11) NOT NULL COMMENT '班次ID',
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `user_id` int(11) NOT NULL COMMENT '员工ID',
  `pass_num` int(11) NOT NULL COMMENT '合格数量',
  `fail_num` int(11) NOT NULL COMMENT '坏品数量',
  `due` int(11) NOT NULL COMMENT '堆积数量',
  `time_point` bigint(20) NOT NULL COMMENT '时间点',
  PRIMARY KEY (`load_id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COMMENT='班次产量信息';

-- --------------------------------------------------------

--
-- 表的结构 `fc_work_schedule_outcome`
--

CREATE TABLE IF NOT EXISTS `fc_work_schedule_outcome` (
  `outcome_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '产能数据ID',
  `schedule_id` int(4) NOT NULL COMMENT '班次ID',
  `spot_id` int(11) NOT NULL COMMENT '工位ID',
  `worker_id` int(11) NOT NULL COMMENT '员工ID',
  `pass_num` int(11) NOT NULL COMMENT '合格数量',
  `fail_num` int(11) NOT NULL COMMENT '坏品数量',
  `avg_due` int(11) NOT NULL COMMENT '平均堆积数量',
  PRIMARY KEY (`outcome_id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 COMMENT='产能数据结算';

-- --------------------------------------------------------

--
-- 表的结构 `sys_atachment`
--

CREATE TABLE IF NOT EXISTS `sys_atachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_table_name` varchar(30) NOT NULL COMMENT '主表名',
  `parent_row_id` varchar(50) NOT NULL COMMENT '主表记录ID',
  `file_name` varchar(500) NOT NULL COMMENT '文件名',
  `file_ext_name` varchar(20) NOT NULL COMMENT '文件扩展名',
  `file_path` varchar(500) NOT NULL COMMENT '文件路径',
  `order_no` tinyint(4) DEFAULT NULL COMMENT '排序，正序1在前',
  `created_by_code` varchar(10) DEFAULT NULL COMMENT '创建人工号',
  `created_by_name` varchar(30) DEFAULT NULL COMMENT '创建人姓名',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='附件';

-- --------------------------------------------------------

--
-- 表的结构 `sys_feedback`
--

CREATE TABLE IF NOT EXISTS `sys_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_type` varchar(20) NOT NULL COMMENT '反馈类型字典值，字典feedbackType',
  `feedback_type_name` varchar(50) DEFAULT NULL COMMENT '反馈类型名称',
  `content` varchar(2000) NOT NULL COMMENT '内容',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='问题反馈';

-- --------------------------------------------------------

--
-- 表的结构 `sys_master_server`
--

CREATE TABLE IF NOT EXISTS `sys_master_server` (
  `item_id` int(10) UNSIGNED NOT NULL,
  `server_ip` int(10) UNSIGNED NOT NULL COMMENT '主控IP',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间戳',
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='负载均衡-定时任务主服务器';

-- --------------------------------------------------------

--
-- 表的结构 `sys_personal`
--

CREATE TABLE IF NOT EXISTS `sys_personal` (
  `user_no` varchar(20) NOT NULL COMMENT '用户工号',
  `head_img` varchar(200) DEFAULT NULL COMMENT '头像URL',
  `birthday` date DEFAULT NULL COMMENT '出生日期',
  `phone_bak` varchar(30) DEFAULT NULL COMMENT '备用电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `specialty` varchar(100) DEFAULT NULL COMMENT '特长',
  `wechat` varchar(30) DEFAULT NULL COMMENT '微信号',
  `open_wx` tinyint(1) DEFAULT '0' COMMENT '是否公开微信号 1公开0隐藏',
  `address` varchar(200) DEFAULT NULL COMMENT '深圳住址',
  `open_addr` tinyint(1) DEFAULT NULL COMMENT '是否公开深圳住址 1公开0隐藏',
  `car_id` varchar(20) DEFAULT NULL COMMENT '车牌号',
  `open_car_id` tinyint(1) DEFAULT NULL COMMENT '是否公开车牌 1公开0隐藏',
  `parent_addr` varchar(200) DEFAULT NULL COMMENT '父母住址',
  `open_par_addr` tinyint(1) DEFAULT NULL COMMENT '是否父母地址 1公开0隐藏',
  `life_photo_1` varchar(200) DEFAULT NULL COMMENT '生活照地址1',
  `life_photo_2` varchar(200) DEFAULT NULL COMMENT '生活照地址2',
  `life_photo_3` varchar(200) DEFAULT NULL COMMENT '生活照地址3',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`user_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='个人信息';

--
-- 转存表中的数据 `sys_personal`
--

INSERT INTO `sys_personal` (`user_no`, `head_img`, `birthday`, `phone_bak`, `email`, `specialty`, `wechat`, `open_wx`, `address`, `open_addr`, `car_id`, `open_car_id`, `parent_addr`, `open_par_addr`, `life_photo_1`, `life_photo_2`, `life_photo_3`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
('A0002', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-25 15:13:49', NULL, NULL, NULL),
('DS001', NULL, NULL, '', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-03-31 12:58:17', NULL, NULL, NULL),
('V0001', NULL, NULL, '', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2017-12-22 07:18:51', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `sys_resource`
--

CREATE TABLE IF NOT EXISTS `sys_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '名称',
  `code` varchar(80) DEFAULT NULL COMMENT '编码',
  `res_type` char(1) DEFAULT NULL COMMENT '资源类型(M菜单，B按钮)',
  `url` varchar(120) DEFAULT NULL COMMENT '菜单地址',
  `parent_id` int(11) DEFAULT NULL COMMENT '父ID',
  `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1显示，0不显示',
  `menu_order` tinyint(4) DEFAULT NULL COMMENT '顺序',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8 COMMENT='资源';

--
-- 转存表中的数据 `sys_resource`
--

INSERT INTO `sys_resource` (`id`, `name`, `code`, `res_type`, `url`, `parent_id`, `is_show`, `menu_order`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
(1, '系统管理', 'system', 'M', '#', 0, 1, 1, '2017-12-15 12:31:33', NULL, NULL, NULL),
(2, '员工管理', 'notiem', 'M', '#', 0, 1, 3, '2017-12-15 12:31:33', NULL, NULL, NULL),
(3, '生产线管理', 'message', 'M', '#', 0, 1, 4, '2017-12-15 12:31:33', NULL, NULL, NULL),
(4, '生产数据', 'manufact', 'M', '#', 0, 1, 5, '2017-12-15 12:31:33', NULL, NULL, NULL),
(5, '产量统计', 'bus', 'M', '#', 0, 1, 5, '2017-12-15 12:31:33', NULL, NULL, NULL),
(6, '班次信息', 'biz', 'M', '#', 0, 1, 6, '2017-12-15 12:31:33', NULL, NULL, NULL),
(7, '日志管理', 'log', 'M', '#', 0, 1, 7, '2017-12-15 12:31:33', NULL, NULL, NULL),
(11, '角色管理', 'sysRole.listPage', 'M', '/server/sysRole/listPage', 1, 1, 11, '2017-12-15 12:31:33', NULL, NULL, NULL),
(12, '人员管理', 'sysUser.listPage', 'M', '/server/sysUser/listPage', 1, 1, 12, '2017-12-15 12:31:33', NULL, NULL, NULL),
(14, '附件查询', 'sysAtachment.listPage', 'M', '/server/sysAtachment/listPage', 1, 1, 14, '2017-12-15 12:31:33', NULL, NULL, NULL),
(21, '员工管理', 'fcWorker.listPage', 'M', '/server/fcWorker/listPage', 2, 1, 21, '2017-12-15 12:31:33', NULL, NULL, NULL),
(31, '产线信息', 'fcFlow.listPage', 'M', '/server/fcFlow/listPage', 3, 1, 31, '2017-12-15 12:31:33', NULL, NULL, NULL),
(32, '工位信息', 'fcSector.listPage', 'M', '/server/fcSector/listPage', 3, 1, 32, '2017-12-15 12:31:33', NULL, NULL, NULL),
(33, '工位工作点对应', 'fcSectorSpot.listPage', 'M', '/server/fcSectorSpot/listPage', 3, 1, 33, '2017-12-15 12:31:33', NULL, NULL, NULL),
(34, '工作点信息', 'fcSpot.listPage', 'M', '/server/fcSpot/listPage', 3, 1, 34, '2017-12-15 12:31:33', NULL, NULL, NULL),
(35, '工作点参数', 'fcSpotExtra.listPage', 'M', '/server/fcSpotExtra/listPage', 3, 0, 35, '2017-12-15 12:31:33', NULL, NULL, NULL),
(37, '设备状态', 'epState.listPage', 'M', '/server/epState/listPage', 3, 1, 37, '2017-12-15 12:31:33', NULL, NULL, NULL),
(38, '设备配置信息', 'epConfig.listPage', 'M', '/server/epConfig/listPage', 3, 1, 38, '2017-12-15 12:31:33', NULL, NULL, NULL),
(39, '控制板对应', 'epBoardSpot.listPage', 'M', '/server/epBoardSpot/listPage', 3, 1, 39, '2017-12-15 12:31:33', NULL, NULL, NULL),
(41, '结算产量', 'fcWorkScheduleOutcome.listPage', 'M', '/server/fcWorkScheduleOutcome/listPage', 4, 1, 41, '2017-12-15 12:31:33', NULL, NULL, NULL),
(42, '实时产量', 'fcWorkScheduleLoad.listPage', 'M', '/server/fcWorkScheduleLoad/listPage', 4, 1, 42, '2017-12-15 12:31:33', NULL, NULL, NULL),
(43, '过程数据', 'fcWorkRaw.listPage', 'M', '/server/fcWorkRaw/listPage', 4, 1, 43, '2017-12-15 12:31:33', NULL, NULL, NULL),
(51, '工人日结', 'fcBiWorkerDaily.listPage', 'M', '/server/fcBiWorkerDaily/listPage', 5, 1, 51, '2017-12-15 12:31:33', NULL, NULL, NULL),
(52, '产线日结', 'fcBiFlowDaily.listPage', 'M', '/server/fcBiFlowDaily/listPage', 5, 1, 52, '2017-12-15 12:31:33', NULL, NULL, NULL),
(53, '工厂日结', 'fcBiFactoryDaily.listPage', 'M', '/server/fcBiFactoryDaily/listPage', 5, 1, 53, '2017-12-15 12:31:33', NULL, NULL, NULL),
(61, '时间段设置', 'fcWorkPeriod.listPage', 'M', '/server/fcWorkPeriod/listPage', 6, 1, 61, '2017-12-15 12:31:33', NULL, NULL, NULL),
(62, '班次记录', 'fcWorkSchedule.listPage', 'M', '/server/fcWorkSchedule/listPage', 6, 1, 62, '2017-12-15 12:31:33', NULL, NULL, NULL),
(63, '生产事件', 'fcWorkScheduleEvent.listPage', 'M', '/server/fcWorkScheduleEvent/listPage', 6, 1, 63, '2017-12-15 12:31:33', NULL, NULL, NULL),
(71, '运行事件', 'fcSystemEvent.listPage', 'M', '/server/fcSystemEvent/listPage', 7, 1, 71, '2018-06-21 11:19:45', NULL, NULL, NULL),
(72, '公告信息', 'aoComNotice.listPage', 'M', '/server/aoComNotice/listPage', 7, 1, 72, '2017-12-15 12:31:33', NULL, NULL, NULL),
(73, '文件信息', 'aoFileLearning.listPage', 'M', '/server/aoFileLearning/listPage', 7, 1, 73, '2017-12-15 12:31:33', NULL, NULL, NULL),
(74, '日志信息查询', 'sysVisitLog.listPage', 'M', '/server/sysVisitLog/listPage', 7, 1, 74, '2017-12-15 12:31:33', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `sys_role`
--

CREATE TABLE IF NOT EXISTS `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `role_code` varchar(20) DEFAULT NULL COMMENT '角色编号',
  `remark` varchar(200) DEFAULT NULL COMMENT '说明',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  `is_default` varchar(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COMMENT='角色';

--
-- 转存表中的数据 `sys_role`
--

INSERT INTO `sys_role` (`id`, `name`, `role_code`, `remark`, `created_on`, `created_by`, `modified_on`, `modified_by`, `is_default`) VALUES
(1, '系统管理员', 'A001', '系统开发测试保留', '2017-11-17 09:56:23', 'A0001', NULL, NULL, '0'),
(11, '厂长', 'N001', '高管', '2017-11-20 15:33:16', 'A0001', NULL, NULL, '0'),
(12, '管理员', 'N002', '管理添改删', '2017-11-20 15:33:33', 'A0001', NULL, NULL, '0'),
(13, '生产人员', 'AL01', '现场使用，登录', '2017-12-04 03:04:47', 'A0001', NULL, NULL, '0');

-- --------------------------------------------------------

--
-- 表的结构 `sys_role_resource`
--

CREATE TABLE IF NOT EXISTS `sys_role_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `resource_id` int(11) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1556 DEFAULT CHARSET=utf8 COMMENT='角色资源权限';

--
-- 转存表中的数据 `sys_role_resource`
--

INSERT INTO `sys_role_resource` (`id`, `role_id`, `resource_id`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
(516, 4, 21, '2017-12-04 02:55:19', NULL, NULL, NULL),
(517, 4, 22, '2017-12-04 02:55:19', NULL, NULL, NULL),
(518, 4, 24, '2017-12-04 02:55:19', NULL, NULL, NULL),
(519, 4, 25, '2017-12-04 02:55:19', NULL, NULL, NULL),
(520, 4, 2, '2017-12-04 02:55:19', NULL, NULL, NULL),
(521, 4, -1, '2017-12-04 02:55:19', NULL, NULL, NULL),
(522, 18, -1, '2017-12-04 03:04:47', NULL, NULL, NULL),
(523, 18, 11, '2017-12-04 03:04:47', NULL, NULL, NULL),
(524, 18, 12, '2017-12-04 03:04:47', NULL, NULL, NULL),
(525, 18, 15, '2017-12-04 03:04:47', NULL, NULL, NULL),
(526, 18, 21, '2017-12-04 03:04:47', NULL, NULL, NULL),
(527, 18, 22, '2017-12-04 03:04:47', NULL, NULL, NULL),
(528, 18, 24, '2017-12-04 03:04:47', NULL, NULL, NULL),
(529, 18, 25, '2017-12-04 03:04:47', NULL, NULL, NULL),
(530, 18, 31, '2017-12-04 03:04:47', NULL, NULL, NULL),
(531, 18, 32, '2017-12-04 03:04:47', NULL, NULL, NULL),
(532, 18, 33, '2017-12-04 03:04:47', NULL, NULL, NULL),
(533, 18, 34, '2017-12-04 03:04:47', NULL, NULL, NULL),
(534, 18, 35, '2017-12-04 03:04:47', NULL, NULL, NULL),
(535, 18, 41, '2017-12-04 03:04:47', NULL, NULL, NULL),
(536, 18, 42, '2017-12-04 03:04:47', NULL, NULL, NULL),
(537, 18, 43, '2017-12-04 03:04:47', NULL, NULL, NULL),
(538, 18, 51, '2017-12-04 03:04:47', NULL, NULL, NULL),
(539, 18, 52, '2017-12-04 03:04:47', NULL, NULL, NULL),
(540, 18, 53, '2017-12-04 03:04:47', NULL, NULL, NULL),
(541, 18, 54, '2017-12-04 03:04:47', NULL, NULL, NULL),
(542, 18, 55, '2017-12-04 03:04:47', NULL, NULL, NULL),
(543, 18, 61, '2017-12-04 03:04:47', NULL, NULL, NULL),
(544, 18, 62, '2017-12-04 03:04:47', NULL, NULL, NULL),
(545, 18, 63, '2017-12-04 03:04:47', NULL, NULL, NULL),
(546, 18, 71, '2017-12-04 03:04:47', NULL, NULL, NULL),
(547, 18, 1, '2017-12-04 03:04:47', NULL, NULL, NULL),
(548, 18, 2, '2017-12-04 03:04:47', NULL, NULL, NULL),
(549, 18, 3, '2017-12-04 03:04:47', NULL, NULL, NULL),
(550, 18, 4, '2017-12-04 03:04:47', NULL, NULL, NULL),
(551, 18, 5, '2017-12-04 03:04:47', NULL, NULL, NULL),
(552, 18, 6, '2017-12-04 03:04:47', NULL, NULL, NULL),
(553, 18, 7, '2017-12-04 03:04:47', NULL, NULL, NULL),
(649, 20, 3, '2017-12-04 07:52:38', NULL, NULL, NULL),
(650, 20, 31, '2017-12-04 07:52:38', NULL, NULL, NULL),
(651, 20, 32, '2017-12-04 07:52:38', NULL, NULL, NULL),
(652, 20, 33, '2017-12-04 07:52:38', NULL, NULL, NULL),
(653, 20, 34, '2017-12-04 07:52:38', NULL, NULL, NULL),
(654, 20, 35, '2017-12-04 07:52:38', NULL, NULL, NULL),
(655, 20, -1, '2017-12-04 07:52:38', NULL, NULL, NULL),
(734, 5, 11, '2017-12-08 03:35:57', NULL, NULL, NULL),
(735, 5, 12, '2017-12-08 03:35:57', NULL, NULL, NULL),
(736, 5, 15, '2017-12-08 03:35:57', NULL, NULL, NULL),
(737, 5, 21, '2017-12-08 03:35:57', NULL, NULL, NULL),
(738, 5, 22, '2017-12-08 03:35:57', NULL, NULL, NULL),
(739, 5, 24, '2017-12-08 03:35:57', NULL, NULL, NULL),
(740, 5, 25, '2017-12-08 03:35:57', NULL, NULL, NULL),
(741, 5, 31, '2017-12-08 03:35:57', NULL, NULL, NULL),
(742, 5, 32, '2017-12-08 03:35:57', NULL, NULL, NULL),
(743, 5, 33, '2017-12-08 03:35:57', NULL, NULL, NULL),
(744, 5, 34, '2017-12-08 03:35:57', NULL, NULL, NULL),
(745, 5, 35, '2017-12-08 03:35:57', NULL, NULL, NULL),
(746, 5, 41, '2017-12-08 03:35:57', NULL, NULL, NULL),
(747, 5, 42, '2017-12-08 03:35:57', NULL, NULL, NULL),
(748, 5, 43, '2017-12-08 03:35:57', NULL, NULL, NULL),
(749, 5, 51, '2017-12-08 03:35:57', NULL, NULL, NULL),
(750, 5, 52, '2017-12-08 03:35:57', NULL, NULL, NULL),
(751, 5, 53, '2017-12-08 03:35:57', NULL, NULL, NULL),
(752, 5, 54, '2017-12-08 03:35:57', NULL, NULL, NULL),
(753, 5, 55, '2017-12-08 03:35:57', NULL, NULL, NULL),
(754, 5, 61, '2017-12-08 03:35:57', NULL, NULL, NULL),
(755, 5, 62, '2017-12-08 03:35:57', NULL, NULL, NULL),
(756, 5, 71, '2017-12-08 03:35:57', NULL, NULL, NULL),
(757, 5, 2, '2017-12-08 03:35:57', NULL, NULL, NULL),
(758, 5, 3, '2017-12-08 03:35:57', NULL, NULL, NULL),
(759, 5, 5, '2017-12-08 03:35:57', NULL, NULL, NULL),
(760, 5, 7, '2017-12-08 03:35:57', NULL, NULL, NULL),
(761, 5, -1, '2017-12-08 03:35:57', NULL, NULL, NULL),
(762, 5, 1, '2017-12-08 03:35:57', NULL, NULL, NULL),
(763, 5, 4, '2017-12-08 03:35:57', NULL, NULL, NULL),
(764, 5, 6, '2017-12-08 03:35:57', NULL, NULL, NULL),
(1022, 22, 3, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1023, 22, 31, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1024, 22, 32, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1025, 22, 33, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1026, 22, 34, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1027, 22, 35, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1028, 22, -1, '2017-12-16 13:44:06', NULL, NULL, NULL),
(1040, 3, 11, '2018-01-25 15:14:01', NULL, NULL, NULL),
(1041, 3, 12, '2018-01-25 15:14:01', NULL, NULL, NULL),
(1042, 3, 13, '2018-01-25 15:14:01', NULL, NULL, NULL),
(1043, 3, 1, '2018-01-25 15:14:01', NULL, NULL, NULL),
(1044, 3, -1, '2018-01-25 15:14:01', NULL, NULL, NULL),
(1045, 23, 2, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1046, 23, 3, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1047, 23, 21, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1048, 23, 22, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1049, 23, 23, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1050, 23, 24, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1051, 23, 25, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1052, 23, 31, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1053, 23, 32, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1054, 23, 33, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1055, 23, 34, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1056, 23, 35, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1057, 23, 61, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1058, 23, 62, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1059, 23, 63, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1060, 23, -1, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1061, 23, 6, '2018-03-31 12:15:57', NULL, NULL, NULL),
(1095, 11, 1, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1096, 11, 2, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1097, 11, 3, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1098, 11, 5, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1099, 11, 6, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1100, 11, 7, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1101, 11, 11, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1102, 11, 12, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1103, 11, 14, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1104, 11, 15, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1105, 11, 21, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1106, 11, 22, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1107, 11, 23, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1108, 11, 24, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1109, 11, 25, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1110, 11, 31, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1111, 11, 32, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1112, 11, 33, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1113, 11, 34, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1114, 11, 35, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1115, 11, 51, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1116, 11, 52, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1117, 11, 53, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1118, 11, 54, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1119, 11, 55, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1120, 11, 56, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1121, 11, 61, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1122, 11, 62, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1123, 11, 63, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1124, 11, 64, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1125, 11, 65, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1126, 11, 71, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1127, 11, -1, '2018-03-31 12:32:45', NULL, NULL, NULL),
(1128, 52, 2, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1129, 52, 3, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1130, 52, 6, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1131, 52, 21, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1132, 52, 22, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1133, 52, 23, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1134, 52, 24, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1135, 52, 25, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1136, 52, 31, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1137, 52, 32, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1138, 52, 33, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1139, 52, 34, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1140, 52, 35, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1141, 52, 61, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1142, 52, 62, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1143, 52, 63, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1144, 52, 64, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1145, 52, 65, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1146, 52, -1, '2018-03-31 12:37:17', NULL, NULL, NULL),
(1147, 40, 2, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1148, 40, 3, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1149, 40, 6, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1150, 40, 21, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1151, 40, 22, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1152, 40, 23, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1153, 40, 24, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1154, 40, 25, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1155, 40, 31, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1156, 40, 32, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1157, 40, 33, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1158, 40, 34, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1159, 40, 35, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1160, 40, 61, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1161, 40, 62, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1162, 40, 63, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1163, 40, 64, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1164, 40, 65, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1165, 40, -1, '2018-03-31 12:38:17', NULL, NULL, NULL),
(1185, 71, 2, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1186, 71, 3, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1187, 71, 6, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1188, 71, 21, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1189, 71, 22, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1190, 71, 23, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1191, 71, 24, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1192, 71, 25, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1193, 71, 31, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1194, 71, 32, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1195, 71, 33, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1196, 71, 34, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1197, 71, 35, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1198, 71, 61, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1199, 71, 62, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1200, 71, 63, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1201, 71, 64, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1202, 71, 65, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1203, 71, -1, '2018-03-31 12:39:51', NULL, NULL, NULL),
(1237, 41, 22, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1238, 41, 23, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1239, 41, 24, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1240, 41, 25, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1241, 41, 21, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1242, 41, 31, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1243, 41, 33, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1244, 41, 34, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1245, 41, 35, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1246, 41, 32, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1247, 41, 62, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1248, 41, 63, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1249, 41, 64, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1250, 41, 65, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1251, 41, 61, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1252, 41, 2, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1253, 41, 3, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1254, 41, 6, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1255, 41, -1, '2018-03-31 20:46:28', NULL, NULL, NULL),
(1527, 1, 1, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1528, 1, 2, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1529, 1, 4, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1530, 1, 5, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1531, 1, 6, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1532, 1, 11, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1533, 1, 12, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1534, 1, 14, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1535, 1, 21, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1536, 1, 31, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1537, 1, 32, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1538, 1, 33, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1539, 1, 34, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1540, 1, 35, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1541, 1, 39, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1542, 1, 41, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1543, 1, 42, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1544, 1, 43, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1545, 1, 51, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1546, 1, 52, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1547, 1, 53, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1548, 1, 61, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1549, 1, 62, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1550, 1, 63, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1551, 1, 71, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1552, 1, 74, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1553, 1, -1, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1554, 1, 3, '2018-07-05 09:57:51', NULL, NULL, NULL),
(1555, 1, 7, '2018-07-05 09:57:51', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `sys_user`
--

CREATE TABLE IF NOT EXISTS `sys_user` (
  `user_no` varchar(20) NOT NULL COMMENT '用户工号',
  `user_login_name` varchar(50) DEFAULT NULL COMMENT '账号',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `user_name` varchar(50) DEFAULT NULL,
  `user_name_en` varchar(50) DEFAULT NULL,
  `mobile_phone` varchar(50) DEFAULT NULL COMMENT '手机',
  `p_code` varchar(20) DEFAULT NULL COMMENT 'FOC代码',
  `dept_id` varchar(50) DEFAULT NULL COMMENT '部门ID',
  `dept_name` varchar(30) DEFAULT NULL COMMENT '部门名称',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态1有效，0无效',
  `gender` varchar(1) DEFAULT NULL COMMENT '性别',
  `crew_type` char(1) DEFAULT NULL COMMENT '机组人员类型F飞行,C乘务员,S安全员',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `created_by` varchar(20) DEFAULT NULL COMMENT '创建人工号',
  `modified_on` timestamp NULL DEFAULT NULL COMMENT '修改日期',
  `modified_by` varchar(20) DEFAULT NULL COMMENT '修改人工号',
  PRIMARY KEY (`user_no`),
  KEY `idx_userno` (`user_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

--
-- 转存表中的数据 `sys_user`
--

INSERT INTO `sys_user` (`user_no`, `user_login_name`, `password`, `user_name`, `user_name_en`, `mobile_phone`, `p_code`, `dept_id`, `dept_name`, `status`, `gender`, `crew_type`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
('A0001', 'admin', '3C2C28608BF517CBF83E2345779C804B', '系统管理员', 'admin', '18611825550', '01', '4E732CED3463D06DE0CA9A15B6153677', '222', 1, '1', '', '2017-12-17 15:36:11', NULL, NULL, NULL),
('DS001', 'district', 'C1CD346996E502C3CC243BEADD9C0FB5', '领导', 'district', '', '01', '4E732CED3463D06DE0CA9A15B6153677', '333', 1, '1', 'S', '2018-03-31 12:35:50', NULL, NULL, NULL),
('UC18611825550', 'uc18611825550', '6F80105604DFF9E6DEEF51DCC4C8B079', '用户_18611825550', '用户_18611825550', '18611825550', NULL, NULL, NULL, 1, NULL, NULL, '2018-03-31 23:58:43', NULL, NULL, NULL),
('UC18611825551', 'uc18611825551', 'F4390E2B6C5D583B2CAF2AA4E2008EA6', '用户_18611825551', '用户_18611825551', '18611825551', NULL, NULL, NULL, 1, NULL, NULL, '2018-03-31 23:59:28', NULL, NULL, NULL),
('UC18611825552', 'uc18611825552', 'B2B7EE3C6BF4D256C33990137AFFE968', '用户_18611825552', '用户_18611825552', '18611825552', NULL, NULL, NULL, 1, NULL, NULL, '2018-03-31 23:59:48', NULL, NULL, NULL),
('UC18611825553', 'uc18611825553', '6DC5CA568C5C299514FCFE44FA964EB3', '用户_18611825553', '用户_18611825553', '18611825553', NULL, NULL, NULL, 1, NULL, NULL, '2018-04-01 00:00:11', NULL, NULL, NULL),
('V0001', 'test', '5C5A040319576CCF37774044553B7D77', '教师Test', 'MengD', '', '01', '4E732CED3463D06DE0CA9A15B6153677', 'VMC', 1, '0', 'S', '2017-12-22 07:18:51', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `sys_user_device_binding`
--

CREATE TABLE IF NOT EXISTS `sys_user_device_binding` (
  `id` int(11) DEFAULT NULL,
  `user_no` tinytext,
  `client_id` tinytext,
  `device_name` tinytext,
  `bind_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_login_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `on_black_list` tinyint(4) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` tinytext,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='用户绑定设备表';

-- --------------------------------------------------------

--
-- 表的结构 `sys_user_role`
--

CREATE TABLE IF NOT EXISTS `sys_user_role` (
  `id` int(11) DEFAULT NULL,
  `user_no` tinytext CHARACTER SET latin1,
  `role_id` int(11) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` tinytext CHARACTER SET latin1,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` tinytext CHARACTER SET latin1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色';

--
-- 转存表中的数据 `sys_user_role`
--

INSERT INTO `sys_user_role` (`id`, `user_no`, `role_id`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES
(1, 'A0001', 1, '2017-11-27 03:41:57', NULL, '2018-01-12 15:20:37', NULL),
(7, 'A03076', 20, '2017-12-04 07:56:35', NULL, '2018-01-12 15:20:37', NULL),
(8, 'A00334', 20, '2017-12-04 10:17:35', NULL, '2018-01-12 15:20:37', NULL),
(10, 'A01936', 20, '2017-12-04 10:46:25', NULL, '2018-01-12 15:20:37', NULL),
(11, 'A00060', 20, '2017-12-04 10:46:37', NULL, '2018-01-12 15:20:37', NULL),
(12, 'A00220', 20, '2017-12-04 11:03:46', NULL, '2018-01-12 15:20:37', NULL),
(13, 'A00421', 20, '2017-12-04 11:05:01', NULL, '2018-01-12 15:20:37', NULL),
(14, 'A01626', 20, '2017-12-05 01:47:37', NULL, '2018-01-12 15:20:37', NULL),
(15, 'A03057', 20, '2017-12-05 02:11:05', NULL, '2018-01-12 15:20:37', NULL),
(16, 'A02513', 20, '2017-12-05 02:35:31', NULL, '2018-01-12 15:20:37', NULL),
(17, 'A00186', 20, '2017-12-06 01:49:07', NULL, '2018-01-12 15:20:37', NULL),
(18, 'A01949', 20, '2017-12-06 01:57:31', NULL, '2018-01-12 15:20:37', NULL),
(19, 'A02201', 20, '2017-12-06 01:58:59', NULL, '2018-01-12 15:20:37', NULL),
(20, 'A02287', 20, '2017-12-06 02:06:43', NULL, '2018-01-12 15:20:37', NULL),
(21, 'A01456', 20, '2017-12-06 02:07:39', NULL, '2018-01-12 15:20:37', NULL),
(22, 'A02371', 1, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(23, 'A02371', 3, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(24, 'A02371', 4, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(25, 'A02371', 5, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(26, 'A02371', 6, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(27, 'A02371', 16, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(28, 'A02371', 18, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(29, 'A02371', 20, '2017-12-06 03:35:26', NULL, '2018-01-12 15:20:37', NULL),
(30, 'W88801', 16, '2017-12-08 02:50:45', NULL, '2018-01-12 15:20:37', NULL),
(31, 'A00056', 4, '2017-12-08 03:53:09', NULL, '2018-01-12 15:20:37', NULL),
(32, 'A00056', 5, '2017-12-08 03:53:09', NULL, '2018-01-12 15:20:37', NULL),
(33, 'A00056', 18, '2017-12-08 03:53:09', NULL, '2018-01-12 15:20:37', NULL),
(34, '00001', 3, '2017-12-16 13:02:31', NULL, '2018-01-12 15:20:37', NULL),
(36, '000001', 22, '2017-12-16 15:13:11', NULL, '2018-01-12 15:20:37', NULL),
(NULL, 'A0002', 3, '2018-01-25 15:13:49', NULL, '0000-00-00 00:00:00', NULL),
(NULL, 'V0001', 41, '2018-03-31 12:42:16', NULL, '0000-00-00 00:00:00', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `sys_visit_log`
--

CREATE TABLE IF NOT EXISTS `sys_visit_log` (
  `log_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `call_api` tinytext,
  `api_desc` varchar(200) DEFAULT NULL,
  `user_no` tinytext,
  `device` tinytext,
  `remote_addr` tinytext,
  `remote_host` tinytext,
  `input_params` varchar(200) DEFAULT NULL,
  `error` int(11) DEFAULT NULL,
  `time_consuming` int(11) DEFAULT NULL,
  `bak` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='系统API调用日志表';
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
