· 7 years ago · Oct 06, 2018, 09:12 PM
1CREATE DATABASE IF NOT EXISTS `lot` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `lot`;
3-- MySQL dump 10.13 Distrib 8.0.12, for Win64 (x86_64)
4--
5-- Host: localhost Database: lot
6-- ------------------------------------------------------
7-- Server version 8.0.12
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 SET NAMES utf8 ;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `avail`
22--
23
24DROP TABLE IF EXISTS `avail`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26 SET character_set_client = utf8mb4 ;
27CREATE TABLE `avail` (
28 `spot` varchar(3) NOT NULL,
29 `available` tinyint(1) DEFAULT NULL,
30 PRIMARY KEY (`spot`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `avail`
36--
37
38LOCK TABLES `avail` WRITE;
39/*!40000 ALTER TABLE `avail` DISABLE KEYS */;
40INSERT INTO `avail` VALUES ('A1',1),('A2',1);
41/*!40000 ALTER TABLE `avail` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `employees`
46--
47
48DROP TABLE IF EXISTS `employees`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50 SET character_set_client = utf8mb4 ;
51CREATE TABLE `employees` (
52 `emp_id` int(11) NOT NULL AUTO_INCREMENT,
53 `name` varchar(40) DEFAULT NULL,
54 `designation` varchar(20) DEFAULT NULL,
55 `salary` int(11) DEFAULT NULL,
56 `address` varchar(100) DEFAULT NULL,
57 `dob` date DEFAULT NULL,
58 `car_no` varchar(10) DEFAULT NULL,
59 PRIMARY KEY (`emp_id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `employees`
65--
66
67LOCK TABLES `employees` WRITE;
68/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
69/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `nonemployees`
74--
75
76DROP TABLE IF EXISTS `nonemployees`;
77/*!40101 SET @saved_cs_client = @@character_set_client */;
78 SET character_set_client = utf8mb4 ;
79CREATE TABLE `nonemployees` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `name` varchar(40) DEFAULT NULL,
82 `address` varchar(100) DEFAULT NULL,
83 `dob` date DEFAULT NULL,
84 `car_no` varchar(10) DEFAULT NULL,
85 PRIMARY KEY (`id`)
86) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `nonemployees`
91--
92
93LOCK TABLES `nonemployees` WRITE;
94/*!40000 ALTER TABLE `nonemployees` DISABLE KEYS */;
95INSERT INTO `nonemployees` VALUES (1,'Hemant Singh','212, Vijay Nagar, Lucknow, UP','1997-09-27','UP32EP1936'),(2,'Akash Purandare','A107, ','1997-12-19','CG07LT2850');
96/*!40000 ALTER TABLE `nonemployees` ENABLE KEYS */;
97UNLOCK TABLES;
98
99--
100-- Table structure for table `parkers`
101--
102
103DROP TABLE IF EXISTS `parkers`;
104/*!40101 SET @saved_cs_client = @@character_set_client */;
105 SET character_set_client = utf8mb4 ;
106CREATE TABLE `parkers` (
107 `log_no` int(11) NOT NULL AUTO_INCREMENT,
108 `intime` datetime DEFAULT NULL,
109 `outtime` datetime DEFAULT NULL,
110 `car_no` varchar(10) DEFAULT NULL,
111 `spot` varchar(3) DEFAULT NULL,
112 PRIMARY KEY (`log_no`)
113) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `parkers`
118--
119
120LOCK TABLES `parkers` WRITE;
121/*!40000 ALTER TABLE `parkers` DISABLE KEYS */;
122INSERT INTO `parkers` VALUES (4,'2018-10-07 02:24:39','2018-10-07 02:24:40','CG07LT2850','A1');
123/*!40000 ALTER TABLE `parkers` ENABLE KEYS */;
124UNLOCK TABLES;
125
126--
127-- Table structure for table `vehicles`
128--
129
130DROP TABLE IF EXISTS `vehicles`;
131/*!40101 SET @saved_cs_client = @@character_set_client */;
132 SET character_set_client = utf8mb4 ;
133CREATE TABLE `vehicles` (
134 `car_no` varchar(10) NOT NULL,
135 `company` varchar(40) DEFAULT NULL,
136 `model` varchar(20) DEFAULT NULL,
137 `color` varchar(20) DEFAULT NULL,
138 PRIMARY KEY (`car_no`)
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140/*!40101 SET character_set_client = @saved_cs_client */;
141
142--
143-- Dumping data for table `vehicles`
144--
145
146LOCK TABLES `vehicles` WRITE;
147/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
148INSERT INTO `vehicles` VALUES ('CG07LT2850','Bajaj','Pulsar 220 DTSI','Black'),('UP32EP1936','Honda','Aviator','Black');
149/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
150UNLOCK TABLES;
151/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
152
153/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
154/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
155/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
156/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
157/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
158/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
159/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
160
161-- Dump completed on 2018-10-07 2:36:55