/*
Navicat MySQL Data Transfer

Source Server         : 阿里云
Source Server Version : 50518
Source Host           : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database       : ars

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

Date: 2017-12-01 16:18:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for personimg
-- ----------------------------
DROP TABLE IF EXISTS `personimg`;
CREATE TABLE `personimg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `idNumber` varchar(20) DEFAULT NULL,
  `idImage` blob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `security_scope`;
CREATE TABLE `security_scope` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '安保范围',
  `active` bit(1) NOT NULL DEFAULT b'1',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of security_scope
-- ----------------------------
INSERT INTO `security_scope` VALUES ('1', '门卫', '', '2017-01-06 14:45:29', '2017-01-06 14:45:32', 'system');
INSERT INTO `security_scope` VALUES ('2', '巡逻', '', '2017-01-06 14:45:43', '2017-01-06 14:45:45', 'system');
INSERT INTO `security_scope` VALUES ('3', '守护', '', '2017-01-06 14:45:57', '2017-01-06 14:46:00', 'system');
INSERT INTO `security_scope` VALUES ('4', '随身护卫', '', '2017-01-06 14:46:14', '2017-01-06 14:46:17', 'system');
INSERT INTO `security_scope` VALUES ('5', '押运', '', '2017-01-06 14:46:29', '2017-01-06 14:46:29', 'system');
INSERT INTO `security_scope` VALUES ('6', '区域秩序维护', '', '2017-01-06 14:46:29', '2017-01-06 14:46:29', 'system');
INSERT INTO `security_scope` VALUES ('7', '安全检查', '', '2017-01-06 14:46:29', '2017-01-06 14:46:29', 'system');
INSERT INTO `security_scope` VALUES ('8', '安全风险评估', '', '2017-01-06 14:46:29', '2017-01-06 14:46:29', 'system');
INSERT INTO `security_scope` VALUES ('9', '安全技术防范', '', '2017-01-06 14:46:29', '2017-01-06 14:46:29', 'system');
