dev-01

分支 (2)

管理

管理

dev-01

master

ssm
/
szjt_jpl.sql

/*
SQLyog Enterprise - MySQL GUI v6.14
MySQL - 5.6.26-log : Database - szjt_jpl
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `szjt_jpl`;

USE `szjt_jpl`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `camera` */

DROP TABLE IF EXISTS `camera`;

CREATE TABLE `camera` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `cameraID` varchar(50) DEFAULT NULL,
  `area` varchar(50) DEFAULT NULL,
  `administrator` varchar(50) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `IP` varchar(50) DEFAULT NULL,
  `functionn` varchar(10) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `camera` */

insert  into `camera`(`ID`,`cameraID`,`area`,`administrator`,`username`,`password`,`IP`,`functionn`,`status`) values (1,'camer_1','大戏院南','刘占磊','admin','admin12345','192.168.1.70','进',NULL),(2,'camer_2','大戏院南','刘占磊','admin','admin12345','192.168.1.71','出',NULL),(3,'camer_3','大戏院北','刘占磊','admin','admin12345','192.168.1.72','进',NULL),(4,'camer_4','大戏院北','刘占磊','admin','admin12345','192.168.1.74','出',NULL);

/*Table structure for table `category` */

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `category` */

insert  into `category`(`ID`,`name`) values (1,'监理'),(2,'管理人员'),(3,'施工人员'),(4,'轨道公司');

/*Table structure for table `fire` */

DROP TABLE IF EXISTS `fire`;

CREATE TABLE `fire` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `dateTime` varchar(255) DEFAULT NULL,
  `cameraIP` varchar(255) DEFAULT NULL,
  `imgPath` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `fire` */

insert  into `fire`(`ID`,`dateTime`,`cameraIP`,`imgPath`) values (1,'2017-10-4 16:10:11','1',NULL),(2,'2017-10-2 16:10:11','2',NULL),(3,'2017-10-3 16:10:11','1',NULL),(4,'2017-10-5 16:10:11','1',NULL);

/*Table structure for table `gate` */

DROP TABLE IF EXISTS `gate`;

CREATE TABLE `gate` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `gateID` varchar(50) DEFAULT NULL,
  `gateIP` varchar(50) DEFAULT NULL,
  `gateSN` varchar(50) DEFAULT NULL,
  `gateDN` varchar(50) DEFAULT NULL,
  `cameraID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `gate` */

insert  into `gate`(`ID`,`gateID`,`gateIP`,`gateSN`,`gateDN`,`cameraID`) values (1,'gate_1','192.168.1.201','2170223477','1','camer_1'),(2,'gate_1','192.168.1.201','2170223477','2','camer_2'),(3,'gate_2','192.168.1.202','2170223244','1','camer_3'),(4,'gate_2','192.168.1.202','2170223244','2','camer_4');

/*Table structure for table `handregist` */

DROP TABLE IF EXISTS `handregist`;

CREATE TABLE `handregist` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `IDNum` varchar(100) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `registPic` longblob,
  `IDPic` longblob,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `handregist` */

/*Table structure for table `person` */

DROP TABLE IF EXISTS `person`;

CREATE TABLE `person` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `gender` varchar(2) DEFAULT NULL,
  `IDNum` varchar(18) DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `registerPicPath` varchar(255) DEFAULT NULL,
  `IDPicPath` varchar(255) DEFAULT NULL,
  `featID` int(10) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `birth` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

/*Data for the table `person` */

insert  into `person`(`ID`,`name`,`gender`,`IDNum`,`category`,`registerPicPath`,`IDPicPath`,`featID`,`province`,`birth`) values (1,'李四','男','130982187311136754','销售',NULL,NULL,12122,'河北省',NULL),(2,'莉莉','女','320434199312093238','工程师',NULL,NULL,33,'河北省',NULL),(3,'张三',NULL,'320434199112093238',NULL,NULL,NULL,NULL,'河南省',NULL),(4,'胡志敏',NULL,'320434199512093238',NULL,NULL,NULL,NULL,'河南省',NULL),(5,'金三胖',NULL,'320434199412093238',NULL,NULL,NULL,NULL,'内蒙古自治区',NULL),(6,'金日成',NULL,'320434200012093238',NULL,NULL,NULL,NULL,'四川省',NULL),(7,'都敏俊',NULL,'320434198312093238',NULL,NULL,NULL,NULL,'安徽省',NULL),(8,'胖东来',NULL,'320434197312093238',NULL,NULL,NULL,NULL,'安徽省',NULL),(9,'金喜善',NULL,'320434196312093238',NULL,NULL,NULL,NULL,'湖南省',NULL),(10,'今天',NULL,'320434195312093238',NULL,NULL,NULL,NULL,'甘肃省',NULL),(11,'成龙',NULL,'320434198611093238',NULL,NULL,NULL,NULL,'陕西省',NULL),(12,'韩红',NULL,'320434196412093238',NULL,NULL,NULL,NULL,'广东省',NULL),(13,'王五',NULL,'283743196608239393',NULL,NULL,NULL,NULL,'西藏',NULL),(14,'赵柳',NULL,'231992198812092312',NULL,NULL,NULL,NULL,'黑龙江',NULL);

/*Table structure for table `record` */

DROP TABLE IF EXISTS `record`;

CREATE TABLE `record` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `gender` varchar(2) DEFAULT NULL,
  `IDNum` varchar(18) DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `cameraID` varchar(50) DEFAULT NULL,
  `area` varchar(50) DEFAULT NULL,
  `administrator` varchar(50) DEFAULT NULL,
  `functionn` varchar(10) DEFAULT NULL,
  `recoTime` datetime DEFAULT NULL,
  `sim` float DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `record` */

insert  into `record`(`ID`,`name`,`gender`,`IDNum`,`category`,`cameraID`,`area`,`administrator`,`functionn`,`recoTime`,`sim`) values (1,'张三','男','130583199204274038','访客',NULL,'河北',NULL,'进','2017-10-03 11:47:22',NULL),(2,'徐子健','男','320932198712092309','总监',NULL,NULL,NULL,'出','2017-10-03 11:47:22',NULL),(3,'赵柳','女','32456199909239032','人事',NULL,NULL,NULL,'进','2017-10-03 05:47:22',NULL);

/*Table structure for table `safecap` */

DROP TABLE IF EXISTS `safecap`;

CREATE TABLE `safecap` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `dateTime` varchar(255) DEFAULT NULL,
  `cameraIP` varchar(255) DEFAULT NULL,
  `imgPath` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `safecap` */

insert  into `safecap`(`ID`,`dateTime`,`cameraIP`,`imgPath`) values (1,'2017-10-3 16:10:11','3','/resources/images/icon/index/logo.jpg'),(2,'2017-10-3 15:10:11','4','/images/icon/index/logo.jpg'),(3,'2017-10-3 14:10:11','5',NULL),(4,'2017-10-2 16:10:11','1',NULL),(5,'2017-10-1 16:10:11','3',NULL),(6,'2017-10-4 16:10:11','2','/resources/images/icon/index/logo.jpg'),(7,'2017-10-4 16:10:11','3',NULL),(8,'2017-10-4 16:10:11','3',NULL),(9,'2017-10-4 16:10:11','3',NULL),(10,'2017-10-4 16:10:11','3',NULL),(11,'2017-10-4 16:10:11','3',NULL);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`ID`,`username`,`password`) values (1,'admin','admin'),(2,'张三','111111'),(3,'李四','1232'),(4,'李思思','234'),(5,'wangchao','111111');

/*Table structure for table `workingtime` */

DROP TABLE IF EXISTS `workingtime`;

CREATE TABLE `workingtime` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `inTime` datetime DEFAULT NULL,
  `outTime` datetime DEFAULT NULL,
  `duration` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `workingtime` */

insert  into `workingtime`(`ID`,`name`,`inTime`,`outTime`,`duration`) values (1,'王五','2017-10-02 06:06:06','2017-10-02 18:02:02',222),(2,'赵六','2017-10-02 07:02:02','2017-10-02 19:02:03',333);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;