/*
Navicat MySQL Data Transfer
Source Server : mytask
Source Server Version : 50560
Source Host : localhost:3306
Source Database : scms
Target Server Type : MYSQL
Target Server Version : 50560
File Encoding : 65001
Date: 2019-05-29 13:43:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`aid` int(4) NOT NULL AUTO_INCREMENT COMMENT '编号',
`aname` varchar(10) NOT NULL COMMENT '用户名',
`password` varchar(50) NOT NULL COMMENT '密码',
PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', '李鸿鹄', 'e10adc3949ba59abbe56e057f20f883e');
INSERT INTO `t_admin` VALUES ('2', '陈泰宏', 'e10adc3949ba59abbe56e057f20f883e');
-- ----------------------------
-- Table structure for `t_adver`
-- ----------------------------
DROP TABLE IF EXISTS `t_adver`;
CREATE TABLE `t_adver` (
`id` int(4) NOT NULL COMMENT '编号',
`adtitle` varchar(50) NOT NULL COMMENT '公告标题',
`adcontent` varchar(500) NOT NULL COMMENT '公告内容',
`adtime` varchar(20) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_adver
-- ----------------------------
INSERT INTO `t_adver` VALUES ('85', 'sss ', 'sssrrr', '2019-03-30');
INSERT INTO `t_adver` VALUES ('2222', '243 ', '43242', '2019-03-29');
INSERT INTO `t_adver` VALUES ('3123', '23123 ', '77777', '2019-03-22');
INSERT INTO `t_adver` VALUES ('3344', '2423', '3423423', '2019-03-14');
INSERT INTO `t_adver` VALUES ('22221', '43242', '423423', '2019-03-30');
INSERT INTO `t_adver` VALUES ('85323', 'sd ', 'sda', '2019-03-22');
INSERT INTO `t_adver` VALUES ('555666', '555 ', '555', '2019-03-14');
INSERT INTO `t_adver` VALUES ('789456', '动阀 ', '而通过', '2019-03-26');
INSERT INTO `t_adver` VALUES ('867865', 'dw', 'www', '2019-03-16');
INSERT INTO `t_adver` VALUES ('56456888', 'f\'s\'f\'s ', '发涩发', '2019-03-19');
-- ----------------------------
-- Table structure for `t_car`
-- ----------------------------
DROP TABLE IF EXISTS `t_car`;
CREATE TABLE `t_car` (
`carnumber` varchar(50) NOT NULL COMMENT '车牌',
`username` varchar(20) NOT NULL COMMENT '姓名',
`cartype` varchar(10) NOT NULL COMMENT '车类型',
`tel` varchar(20) NOT NULL COMMENT '联系电话',
`class` varchar(10) NOT NULL COMMENT '分类',
`park` varchar(50) NOT NULL COMMENT '停车位',
PRIMARY KEY (`carnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_car
-- ----------------------------
INSERT INTO `t_car` VALUES ('55', '55 ', '中型车', '1825647852 ', '教师', '否');
INSERT INTO `t_car` VALUES ('cccc', '--', '小型车', '18564785952', '访客', '否');
INSERT INTO `t_car` VALUES ('dfhdfhs', '--', '小型车', '14578524756', '访客', '否');
INSERT INTO `t_car` VALUES ('efwsef', '--', '小型车', '14578524756', '访客', '否');
INSERT INTO `t_car` VALUES ('fcca', '--', '小型车', '18564785952', '访客', '否');
INSERT INTO `t_car` VALUES ('fkguhjg', '--', '小型车', '15478957452', '访客', '否');
INSERT INTO `t_car` VALUES ('fssssss', '--', '小型车', '14578524756', '访客', '否');
INSERT INTO `t_car` VALUES ('fxcaadas', '--', '小型车', '14562748952', '访客', '否');
INSERT INTO `t_car` VALUES ('gsgsdg', '--', '小型车', '14578524756', '访客', '否');
INSERT INTO `t_car` VALUES ('苏ETS521', '李欣 ', '中型车', '1825647852', '信息学院', '否');
-- ----------------------------
-- Table structure for `t_hiscar`
-- ----------------------------
DROP TABLE IF EXISTS `t_hiscar`;
CREATE TABLE `t_hiscar` (
`carnumber` varchar(50) NOT NULL COMMENT '车牌',
`username` varchar(20) NOT NULL COMMENT '姓名',
`cartype` varchar(10) NOT NULL COMMENT '车类型',
`tel` varchar(20) NOT NULL COMMENT '联系电话',
`carnum` int(3) NOT NULL,
`class` varchar(10) NOT NULL COMMENT '分类',
`starttime` date NOT NULL,
`endtime` date DEFAULT NULL,
PRIMARY KEY (`carnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_hiscar
-- ----------------------------
INSERT INTO `t_hiscar` VALUES ('1', '123 ', '中型车', '1825647852', '3', '信息学院', '2019-05-23', '2019-05-23');
INSERT INTO `t_hiscar` VALUES ('55', '55 ', '小型车', '1825647852', '8', '教师', '2019-04-09', '2019-04-09');
INSERT INTO `t_hiscar` VALUES ('asfs', '--', '大型车', '18475632547', '1', '访客', '2019-04-01', '2019-04-01');
INSERT INTO `t_hiscar` VALUES ('cccc', '--', '小型车', '18564785952', '1', '访客', '2019-04-12', null);
INSERT INTO `t_hiscar` VALUES ('dfhdfhs', '--', '小型车', '14578524756', '1', '访客', '2019-04-04', null);
INSERT INTO `t_hiscar` VALUES ('dgferge', '--', '中型车', 'dgdfdgf', '2', '访客', '2019-04-04', '2019-05-17');
INSERT INTO `t_hiscar` VALUES ('dsfs', '--', '小型车', '14788854231', '1', '访客', '2019-04-02', '2019-04-02');
INSERT INTO `t_hiscar` VALUES ('efwsef', '--', '小型车', '14578524756', '1', '访客', '2019-04-04', null);
INSERT INTO `t_hiscar` VALUES ('fcca', '--', '小型车', '18564785952', '1', '访客', '2019-04-14', null);
INSERT INTO `t_hiscar` VALUES ('fcxassa', '--', '小型车', '15478957452', '2', '访客', '2019-04-14', '2019-04-14');
INSERT INTO `t_hiscar` VALUES ('fete4tre', '--', '小型车', 'gdsfgs', '2', '访客', '2019-04-04', '2019-04-14');
INSERT INTO `t_hiscar` VALUES ('fffssssss', '--', '小型车', '15478957452', '2', '访客', '2019-04-14', '2019-04-14');
INSERT INTO `t_hiscar` VALUES ('fgrtrt', '--', '小型车', 'rt', '2', '访客', '2019-04-09', '2019-05-17');
INSERT INTO `t_hiscar` VALUES ('fkguhjg', '--', '小型车', '15478957452', '1', '访客', '2019-04-14', null);
INSERT INTO `t_hiscar` VALUES ('fsdf', '--', '大型车', '12365874586', '1', '访客', '2019-04-04', '2019-04-05');
INSERT INTO `t_hiscar` VALUES ('fssssss', '--', '小型车', '14578524756', '1', '访客', '2019-04-14', null);
INSERT INTO `t_hiscar` VALUES ('fxcaadas', '--', '小型车', '14562748952', '1', '访客', '2019-04-14', null);
INSERT INTO `t_hiscar` VALUES ('gsgsdg', '--', '小型车', '14578524756', '1', '访客', '2019-04-09', null);
INSERT INTO `t_hiscar` VALUES ('jkgjg', '--', '小型车', '18856325412', '1', '访客', '2019-03-29', '2019-03-29');
INSERT INTO `t_hiscar` VALUES ('kkkkk', '--', '小型车', '15478957452', '2', '访客', '2019-04-05', '2019-04-05');
INSERT INTO `t_hiscar` VALUES ('s', 'cwk', '小型车', '18256478523', '1', '教师', '2019-04-05', '2019-04-05');
INSERT INTO `t_hiscar` VALUES ('sdf', '--', '小型车', '14744785632', '1', '访客', '2019-03-31', '2019-03-31');
INSERT INTO `t_hiscar` VALUES ('sdfs', '--', '小型车', '14578568742', '1', '访客', '2019-04-03', '2019-04-03');
INSERT INTO `t_hiscar` VALUES ('sdfsds', '--', '小型车', '17888745235', '1', '访客', '2019-03-30', '2019-03-30');
INSERT INTO `t_hiscar` VALUES ('sfvgsefgs', '--', '中型车', '14524556587', '2', '访客', '2019-04-11', null);
INSERT INTO `t_hiscar` VALUES ('苏ETS521', '李欣 ', '中型车', '1825647852', '1', '信息学院', '2019-04-04', null);
-- ----------------------------
-- Table structure for `t_outline`
-- ----------------------------
DROP TABLE IF EXISTS `t_outline`;
CREATE TABLE `t_outline` (
`olnum` int(10) NOT NULL,
`carnumber` varchar(50) NOT NULL COMMENT '车牌号',
`oltype` varchar(10) NOT NULL COMMENT '违规类型',
`intro` var