基于SpringBoot+Vue智能停车场管理系统源码.zip

/*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`smart-parking` /*!40100 DEFAULT CHARACTER SET utf8 */; /*Table structure for table `app_car_manage` */ DROP TABLE IF EXISTS `app_car_manage`; CREATE TABLE `app_car_manage` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `gender` varchar(1) DEFAULT NULL, `gmt_create` datetime DEFAULT NULL, `gmt_modified` datetime DEFAULT NULL, `name` varchar(500) DEFAULT NULL, `nickname` varchar(100) DEFAULT NULL, `org_id` bigint(20) NOT NULL, `org_name` varchar(500) DEFAULT NULL, `park_manage_id` bigint(20) NOT NULL, `park_manage_name` varchar(500) DEFAULT NULL, `parking_lot` varchar(100) DEFAULT NULL, `plate_number` varchar(100) DEFAULT NULL, `remark` varchar(200) DEFAULT NULL, `status` smallint(6) DEFAULT NULL, `type` smallint(6) DEFAULT NULL, `user_id_create` bigint(20) DEFAULT NULL, `validity_time` datetime DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `app_car_manage` */ insert into `app_car_manage`(`id`,`gender`,`gmt_create`,`gmt_modified`,`name`,`nickname`,`org_id`,`org_name`,`park_manage_id`,`park_manage_name`,`parking_lot`,`plate_number`,`remark`,`status`,`type`,`user_id_create`,`validity_time`,`mobile`) values (1,'1','2021-04-11 21:58:50','2021-04-19 19:49:35',NULL,'212112',36,'青岛海信',2,'海克斯康','2121','212121',NULL,1,1,NULL,'2021-04-26 00:00:00','17762018584'); /*Table structure for table `app_car_park_manage` */ DROP TABLE IF EXISTS `app_car_park_manage`; CREATE TABLE `app_car_park_manage` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `free_time` int(11) DEFAULT NULL, `gmt_create` datetime DEFAULT NULL, `gmt_modified` datetime DEFAULT NULL, `max_money` decimal(18,2) DEFAULT NULL, `name` varchar(500) DEFAULT NULL, `org_id` bigint(20) NOT NULL, `org_name` varchar(500) DEFAULT NULL, `parking_space_number` int(11) DEFAULT NULL, `status` smallint(6) DEFAULT NULL, `time_unit` int(11) DEFAULT NULL, `unit_cost` decimal(18,2) DEFAULT NULL, `user_id_create` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `app_car_park_manage` */ insert into `app_car_park_manage`(`id`,`free_time`,`gmt_create`,`gmt_modified`,`max_money`,`name`,`org_id`,`org_name`,`parking_space_number`,`status`,`time_unit`,`unit_cost`,`user_id_create`) values (2,60,'2021-03-27 21:52:08','2021-03-27 21:52:08','100.00','海克斯康',36,'青岛海信',12,1,30,'5.00',NULL); /*Table structure for table `app_car_parking_record` */ DROP TABLE IF EXISTS `app_car_parking_record`; CREATE TABLE `app_car_parking_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `cost` decimal(18,2) DEFAULT NULL, `gmt_into` datetime DEFAULT NULL, `gmt_out` datetime DEFAULT NULL, `org_id` bigint(20) NOT NULL, `org_name` varchar(500) DEFAULT NULL, `park_manage_id` bigint(20) NOT NULL, `park_manage_name` varchar(500) DEFAULT NULL, `plate_number` varchar(100) DEFAULT NULL, `type` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `app_car_parking_record` */ insert into `app_car_parking_record`(`id`,`cost`,`gmt_into`,`gmt_out`,`org_id`,`org_name`,`park_manage_id`,`park_manage_name`,`plate_number`,`type`) values (1,NULL,'2021-04-19 21:43:41',NULL,36,'青岛海信',2,'海克斯康','苏E05EV8',2); /*Table structure for table `sys_config` */ DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `config_key` varchar(200) NOT NULL COMMENT '唯一标识', `config_value` varchar(500) NOT NULL COMMENT '值', `config_remark` varchar(1000) NOT NULL COMMENT '备注', `user_id_create` bigint(20) NOT NULL COMMENT '创建人', `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间', `gmt_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间', `status` tinyint(4) NOT NULL COMMENT '状态 0 禁用 1 可用', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='基础配置'; /*Data for the table `sys_config` */ /*Table structure for table `sys_landing_records` */ DROP TABLE IF EXISTS `sys_landing_records`; CREATE TABLE `sys_landing_records` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID', `login_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最近登录时间', `place` varchar(10) NOT NULL COMMENT '最近登录地点', `ip` char(15) NOT NULL COMMENT '最近登录IP', `login_way` char(10) NOT NULL COMMENT '登录方式', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='用户登录日志'; /*Data for the table `sys_landing_records` */ /*Table structure for table `sys_log` */ DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `user_id` bigint(20) DEFAULT NULL COMMENT '用户id', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `operation` varchar(50) DEFAULT NULL COMMENT '用户操作', `time` int(11) DEFAULT NULL COMMENT '响应时间', `method` varchar(200) DEFAULT NULL COMMENT '请求方法', `params` text COMMENT '请求参数', `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址', `device_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '访问方式 0:PC 1:手机 2:未知', `log_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型 0: 一般日志记录 1: 异常错误日志', `exception_detail` text COMMENT '异常详细信息', `gmt_create` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='系统日志'; /*Data for the table `sys_log` */ insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (1,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-03-08 19:58:39'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (2,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-03-16 20:26:27'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (3,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-03-26 20:51:14'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (4,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-03-26 21:10:51'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (5,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-04-11 20:45:05'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gmt_create`) values (6,1,'admin','登录',10,'','','0:0:0:0:0:0:0:1',0,0,'','2021-04-13 20:15:18'); insert into `sys_log`(`id`,`user_id`,`username`,`operation`,`time`,`method`,`params`,`ip`,`device_type`,`log_type`,`exception_detail`,`gm