-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathUser_travelapps.sql
72 lines (57 loc) · 2.85 KB
/
User_travelapps.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
/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 5.5.62 : Database - user
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`user` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `user`;
/*Table structure for table `pemesanan` */
DROP TABLE IF EXISTS `pemesanan`;
CREATE TABLE `pemesanan` (
`ID` int(3) NOT NULL AUTO_INCREMENT,
`username` varchar(30) DEFAULT NULL,
`nama_pemesan` varchar(30) DEFAULT NULL,
`booking_id` varchar(30) DEFAULT NULL,
`hotel_name` varchar(30) DEFAULT NULL,
`room_type` varchar(30) DEFAULT NULL,
`quantity` int(3) DEFAULT NULL,
`jumlah_malam` int(30) DEFAULT NULL,
`total_payment` int(30) DEFAULT NULL,
`status` varchar(30) DEFAULT NULL,
`tanggal_pemesanan` datetime DEFAULT NULL,
`tanggal_checkin` datetime DEFAULT NULL,
`tanggal_checkout` datetime DEFAULT NULL,
`tanggal_pembayaran` datetime DEFAULT NULL,
`tanggal_pembatalan` datetime DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*Data for the table `pemesanan` */
insert into `pemesanan`(`ID`,`username`,`nama_pemesan`,`booking_id`,`hotel_name`,`room_type`,`quantity`,`jumlah_malam`,`total_payment`,`status`,`tanggal_pemesanan`,`tanggal_checkin`,`tanggal_checkout`,`tanggal_pembayaran`,`tanggal_pembatalan`) values
(7,'[email protected]','Jansen','SEv9gQrl','JW Marriot','deluxe',10,10,195000000,'Canceled','2021-07-10 11:41:09','2021-07-10 14:00:00','2021-07-20 12:00:00',NULL,'2021-07-10 11:41:30'),
(12,'[email protected]','Lord Eko','LUC3Tteb','JW Marriot','suite',5,15,183750000,'Canceled','2021-07-12 00:31:13','2021-07-10 14:00:00','2021-07-25 12:00:00',NULL,'2021-07-12 00:31:33');
/*Table structure for table `user_travel` */
DROP TABLE IF EXISTS `user_travel`;
CREATE TABLE `user_travel` (
`id` bigint(3) NOT NULL AUTO_INCREMENT,
`username` varchar(30) DEFAULT NULL,
`password` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*Data for the table `user_travel` */
insert into `user_travel`(`id`,`username`,`password`) values
(1,'[email protected]','HesOyam_11'),
(2,'[email protected]','E_vita@12'),
(3,'[email protected]','Jo@han_72'),
(4,'[email protected]','Jo@han_72'),
(5,'[email protected]','J_axaA12'),
(6,'[email protected]','Lord90_as');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;