forked from hzhoanglee/PythonCarParking
-
Notifications
You must be signed in to change notification settings - Fork 0
/
test-db.sql
82 lines (71 loc) · 12 KB
/
test-db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
-- MariaDB dump 10.19 Distrib 10.5.18-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: python_parking
-- ------------------------------------------------------
-- Server version 10.5.18-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `check_ins`
--
DROP TABLE IF EXISTS `check_ins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `check_ins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`car_license_plate` text NOT NULL,
`car_driver_name` text DEFAULT NULL,
`checkin_time` datetime NOT NULL DEFAULT current_timestamp(),
`checkout_time` datetime DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`slot_code` text NOT NULL,
`checkout_fee` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `check_ins`
--
LOCK TABLES `check_ins` WRITE;
/*!40000 ALTER TABLE `check_ins` DISABLE KEYS */;
INSERT INTO `check_ins` VALUES (21,'123','John','2023-03-29 07:44:29','2023-04-02 02:56:19',0,'B1-F2',0),(22,'123','John','2023-03-29 07:44:29','2023-04-02 06:48:00',0,'B2-F0',0),(23,'123','John','2023-03-29 07:44:30','2023-04-02 10:13:02',0,'B2-F1',0),(24,'123','John','2023-03-29 07:44:30','2023-04-02 09:08:25',0,'B2-F2',0),(25,'123','John','2023-03-29 07:44:30','2023-04-02 06:43:44',0,'B3-F0',0),(26,'123','John','2023-03-29 07:44:30','2023-04-02 10:16:56',0,'B3-F1',0),(27,'123','John','2023-03-29 07:44:31','2023-04-02 10:17:56',0,'B3-F2',0),(28,'123','John','2023-03-29 07:44:31','2023-04-02 06:10:12',0,'B4-F0',0),(29,'123','John','2023-03-29 07:44:31','2023-04-02 10:19:20',0,'B4-F1',0),(30,'123','John','2023-03-29 07:44:31','2023-04-02 10:26:58',0,'B4-F2',0),(31,'123','John','2023-03-29 07:44:32','2023-04-02 06:43:34',0,'C0-F0',0),(32,'123','John','2023-03-29 07:44:32','2023-04-02 10:23:29',0,'C0-F1',0),(33,'123','John','2023-03-29 07:44:32',NULL,1,'C0-F2',0),(34,'123','John','2023-03-29 07:44:32','2023-04-02 06:36:34',0,'C1-F0',0),(35,'123','John','2023-03-29 07:44:32','2023-04-18 12:01:33',0,'C1-F1',84000),(36,'123','John','2023-03-29 07:44:33',NULL,1,'C1-F2',0),(37,'123','John','2023-03-29 07:44:33','2023-04-02 06:56:46',0,'C2-F0',0),(38,'123','John','2023-03-29 07:44:33','2023-04-18 12:19:57',0,'C2-F1',84000),(39,'123','John','2023-03-29 07:44:34',NULL,1,'C2-F2',0),(40,'123','John','2023-03-29 07:44:34','2023-04-01 20:01:19',0,'C3-F0',0),(41,'123','John','2023-03-29 07:44:34','2023-04-18 12:29:37',0,'C3-F1',84000),(42,'123','John','2023-03-29 07:44:34',NULL,1,'C3-F2',0),(43,'123','John','2023-03-29 07:44:35','2023-04-02 06:10:21',0,'C4-F0',0),(44,'123','John','2023-03-29 07:44:35','2023-04-18 13:22:21',0,'C4-F1',105000),(45,'123','John','2023-03-29 07:44:35',NULL,1,'C4-F2',0),(46,'123','John','2023-03-29 07:44:35','2023-04-02 00:53:11',0,'D0-F0',0),(47,'123','John','2023-03-29 07:44:36',NULL,1,'D0-F1',0),(48,'123','John','2023-03-29 07:44:37',NULL,1,'D0-F2',0),(49,'123','John','2023-03-29 07:44:37','2023-04-02 00:55:06',0,'D1-F0',0),(50,'123','John','2023-03-29 07:44:37',NULL,1,'D1-F1',0),(51,'123','John','2023-03-29 07:44:37',NULL,1,'D1-F2',0),(52,'123','John','2023-03-29 07:44:37','2023-04-02 00:58:10',0,'D2-F0',0),(53,'123','John','2023-03-29 07:44:38',NULL,1,'D2-F1',0),(54,'123','John','2023-03-29 07:44:38',NULL,1,'D2-F2',0),(55,'123','John','2023-03-29 07:44:38','2023-04-02 07:18:31',0,'D3-F0',0),(56,'123','John','2023-03-29 07:44:38',NULL,1,'D3-F1',0),(57,'123','John','2023-03-29 07:44:39',NULL,1,'D3-F2',0),(58,'123','John','2023-03-29 07:44:39','2023-04-02 07:24:43',0,'D4-F0',0),(59,'123','John','2023-03-29 07:44:39',NULL,1,'D4-F1',0),(60,'123','John','2023-03-29 07:44:40',NULL,1,'D4-F2',0),(61,'123','John','2023-03-29 07:44:40','2023-04-02 07:28:44',0,'E0-F0',0),(62,'123','John','2023-03-29 07:44:40',NULL,1,'E0-F1',0),(63,'123','John','2023-03-29 07:44:41',NULL,1,'E0-F2',0),(64,'123','John','2023-03-29 07:44:42','2023-04-17 05:30:56',0,'E1-F0',95000),(65,'123','John','2023-03-29 07:44:42',NULL,1,'E1-F1',0),(66,'123','John','2023-03-29 07:44:42',NULL,1,'E1-F2',0),(67,'123','John','2023-03-29 07:44:44','2023-04-17 05:32:15',0,'E2-F0',95000),(68,'123','John','2023-03-29 07:44:45',NULL,1,'E2-F1',0),(69,'123','John','2023-03-29 07:44:45',NULL,1,'E2-F2',0),(70,'123','John','2023-03-29 07:44:46','2023-04-02 07:30:41',0,'E3-F0',0),(71,'123','John','2023-03-29 07:44:46',NULL,1,'E3-F1',0),(123,'test11','huy11','2023-04-01 21:48:23','2023-04-02 04:48:49',0,'A0-F0',0),(124,'test12','huy12','2023-04-01 21:48:47','2023-04-02 10:26:13',0,'A1-F1',0),(155,'huy111','huy1111','2023-04-01 21:59:33','2023-04-02 04:58:23',0,'A1-F0',0),(156,'234','plsvalid','2023-04-01 21:59:38',NULL,1,'E3-F2',0),(157,'4545','EHE','2023-04-01 22:02:37',NULL,1,'E4-F1',0),(158,'939','huyledeptrai','2023-04-01 22:03:35','2023-04-02 09:07:38',0,'A4-F2',0),(159,'Ola','Alo','2023-04-02 00:43:30','2023-04-02 07:03:15',0,'A3-F0',0),(160,'123','OK','2023-04-02 00:44:30','2023-04-02 05:03:04',0,'A2-F0',0),(161,'23','HoLe','2023-04-02 00:46:40','2023-04-02 01:02:49',0,'B1-F0',0),(162,'b0f0','huy12','2023-04-02 01:03:30','2023-04-02 01:20:20',0,'B0-F0',0),(163,'t11111','huy1','2023-04-02 01:25:23','2023-04-02 01:40:12',0,'B0-F0',0),(164,'huytest11','huy1111','2023-04-02 01:41:05','2023-04-02 01:41:18',0,'B0-F0',0),(165,'111111','huy111','2023-04-02 01:45:02','2023-04-02 01:45:34',0,'B0-F0',0),(166,'222222234','HoangNguyen','2023-04-02 02:33:28','2023-04-02 06:37:56',0,'E4-F0',0),(168,'huy11','gh11','2023-04-02 04:45:00','2023-04-02 06:18:19',0,'B1-F2',0),(169,'hell01','h11122','2023-04-02 05:12:30','2023-04-02 05:13:21',0,'A1-F0',0),(170,'hello01','test11','2023-04-02 05:13:52','2023-04-02 05:15:07',0,'A1-F0',0),(171,'tt333','dkdfjkd','2023-04-02 05:16:35','2023-04-02 05:21:32',0,'A2-F0',0),(172,'testin','in11111','2023-04-02 05:22:17','2023-04-02 05:24:43',0,'A2-F0',0),(173,'huy','huy111','2023-04-02 05:24:53','2023-04-02 05:27:24',0,'A2-F0',0),(174,'huy11','huy1111','2023-04-02 05:27:36','2023-04-02 05:37:18',0,'A2-F0',0),(175,'huy12131','hfhfhfh','2023-04-02 06:14:36','2023-04-02 06:15:11',0,'A2-F0',0),(176,'testint34','jfksfldks','2023-04-02 07:05:23','2023-04-02 07:06:44',0,'A0-F0',0),(177,'huyhfhfhh','fhfhfhhdhd','2023-04-02 07:31:39','2023-04-02 07:32:09',0,'E0-F0',0),(178,'123213213','Hhh','2023-04-02 07:36:28','2023-04-17 22:55:00',0,'D3-F0',80000),(179,'134134124214','trrwer','2023-04-02 07:38:40','2023-04-17 05:22:50',0,'D2-F0',75000),(180,'46364567547','hoangagneiqa fhr','2023-04-02 07:39:13','2023-04-02 10:51:28',0,'B1-F0',0),(181,'313498187349','h','2023-04-02 07:41:09','2023-04-02 09:28:54',0,'C1-F0',0),(182,'124214','hoang','2023-04-02 08:19:40','2023-04-02 09:49:32',0,'B0-F0',0),(183,'2132132132132131','hoang ','2023-04-02 08:24:44','2023-04-03 04:30:40',0,'B2-F0',0),(184,'123213213124214','hoang ','2023-04-02 08:27:59','2023-04-03 04:42:14',0,'B3-F0',0),(185,'13545','h','2023-04-02 08:38:15','2023-04-02 10:03:46',0,'A2-F0',0),(186,'test1114','test1114','2023-04-02 09:14:29','2023-04-02 09:15:50',0,'A0-F0',0),(187,'OK2','OK','2023-04-02 09:21:39','2023-04-02 09:30:07',0,'C0-F0',0),(188,'s002','huy11','2023-04-02 09:21:54','2023-04-02 09:22:26',0,'A0-F0',0),(189,'Ok2','Ok','2023-04-02 09:22:37','2023-04-02 09:22:45',0,'D0-F0',0),(190,'s002','huy2','2023-04-02 09:23:11','2023-04-02 09:23:17',0,'A0-F0',0),(191,'OK2','Ok','2023-04-02 09:24:11','2023-04-12 22:30:41',0,'D0-F0',0),(192,'OK2','OK','2023-04-02 09:24:44','2023-04-02 10:26:26',0,'E0-F0',0),(193,'3','2','2023-04-02 09:26:43','2023-04-17 04:14:40',0,'D1-F0',0),(194,'s002','huy2','2023-04-02 09:28:00','2023-04-02 09:28:07',0,'A0-F0',0),(195,'B','AB','2023-04-02 09:32:11','2023-04-05 21:14:44',0,'C0-F0',0),(196,'s002','huy2','2023-04-02 09:32:35','2023-04-02 09:33:45',0,'A0-F0',0),(197,'2','OK','2023-04-02 09:33:45','2023-04-02 09:37:14',0,'C2-F0',0),(198,'Alo','Hoang','2023-04-02 09:34:32','2023-04-05 21:18:03',0,'C1-F0',0),(199,'40F-9999','HoLe','2023-04-02 09:37:10','2023-04-05 21:24:21',0,'C3-F0',0),(200,'99F-9999','Hoàng Lê','2023-04-02 09:41:49','2023-04-18 08:19:44',0,'E4-F0',80000),(201,'131331','s002','2023-04-02 09:47:35','2023-04-02 09:47:42',0,'A0-F0',0),(202,'2','OK','2023-04-02 10:01:52','2023-04-05 21:23:16',0,'C2-F0',0),(203,'djkshfkajs','huy1','2023-04-02 10:04:03','2023-04-02 10:04:31',0,'A0-F0',0),(204,'Le','Hoang','2023-04-02 10:05:15','2023-04-17 23:27:05',0,'A4-F0',80000),(205,'jhadkfhk','s001','2023-04-02 10:13:15','2023-04-02 10:14:39',0,'A0-F0',0),(206,'huy111','s0002','2023-04-02 10:19:35','2023-04-02 10:19:38',0,'A0-F0',0),(207,'huy111','s001','2023-04-02 10:20:47','2023-04-02 10:20:54',0,'A0-F0',0),(208,'HoleF9','HoLe','2023-04-02 10:25:27',NULL,1,'A0-F2',0),(209,'Alo','Hoang Le','2023-04-02 10:44:07','2023-04-02 10:44:11',0,'A0-F0',0),(210,'Le','Hoang','2023-04-02 10:47:14','2023-04-02 10:51:13',0,'A1-F0',0),(211,'dkdkkd','huy111','2023-04-03 04:30:55','2023-04-03 04:34:13',0,'A0-F0',0),(212,'dkdfdkjf','huy22','2023-04-03 04:35:23','2023-04-03 04:35:34',0,'A0-F0',0),(213,'djfjdhfjd','huy1','2023-04-03 04:41:43','2023-04-03 04:41:51',0,'A0-F0',0),(214,'30F-9999','Hoang','2023-04-12 22:30:52','2023-04-13 07:06:25',0,'C0-F0',0),(215,'545','huylehehehe','2023-04-15 08:34:38','2023-04-17 22:56:56',0,'C2-F3',15000),(216,'17-04-23','huy1704','2023-04-17 04:08:30','2023-04-17 04:09:55',0,'A0-F0',0),(217,'djn','huy','2023-04-17 23:01:10','2023-04-17 23:02:49',0,'A0-F0',5000),(218,'131313','huy22','2023-04-17 23:06:46','2023-04-17 23:08:17',0,'B0-F0',5000),(219,'1212121','huyu1111','2023-04-17 23:08:43','2023-04-17 23:27:00',0,'B0-F0',5000),(220,'1313131','huyuy','2023-04-18 12:23:53','2023-04-18 12:24:12',0,'C0-F1',4000),(221,'11112222','huytest','2023-04-18 12:57:00','2023-04-18 13:01:49',0,'A0-F0',4000),(222,'hdhfhfh','huy1414','2023-04-18 13:22:32','2023-04-18 13:58:58',0,'A0-F0',5000),(223,'dkfkdjfd','driver01','2023-04-18 13:59:30',NULL,1,'A0-F0',NULL),(224,'djfiajdfjsf','driver02','2023-04-18 13:59:46',NULL,1,'C2-F0',NULL),(225,'ffkfjgkfdjgk','driver03','2023-04-18 14:00:17','2023-04-18 14:28:50',0,'E4-F0',5000),(226,'kdjfksjdf','driver04','2023-04-18 14:00:34',NULL,1,'C1-F0',NULL),(227,'djfhfh4747','jdhhfkhsdf','2023-04-18 14:28:39',NULL,1,'A4-F0',NULL);
/*!40000 ALTER TABLE `check_ins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`conf_key` varchar(191) NOT NULL,
`conf_value` varchar(191) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'X_VALUE','5'),(2,'Y_VALUE','5'),(3,'Z_VALUE','6'),(4,'name','Vịt Quay Parking'),(5,'password','admin'),(6,'parking_fee','5000');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-04-19 23:44:16