asd

DROP DATABASE IF EXISTS abubakar;
CREATE DATABASE abubakar;
USE abubakar;

/* table */
CREATE TABLE services(
service_id INT ,
service_details VARCHAR(255),
PRIMARY KEY (service_id));

CREATE TABLE Travel_Agencies (
travel_agency_id INT,
travel_agency_name CHAR(50),
PRIMARY KEY (travel_agency_id));

CREATE TABLE Ref_Booking_Status (
status_code INT(20),
status_description CHAR(50),
PRIMARY KEY (status_code));

CREATE TABLE Promo (
promo_id INT(50),
promo_startdate DATE,
promo_enddate DATE,
promo_percentage INT(20),
promo_name CHAR(20),
PRIMARY KEY (promo_id));

CREATE TABLE Customer (
customer_id INT(20),
customer_address_id INT(20),
customer_name CHAR(50),
age INT(3),
email_address VARCHAR(50),
occupation CHAR(50),
PRIMARY KEY (customer_id));

CREATE TABLE blacklist(
bl_id INT,
customer_id INT(20),
PRIMARY KEY (bl_id),
FOREIGN KEY (customer_id) REFERENCES Customer (customer_id));

CREATE TABLE Customer_contact_number (
contact_id INT(20),
customer_id INT(20),
phone_number_1 INT(255),
phone_number_2 INT(255),
home_number INT(255),
office_number INT(255),
emergency_number INT(255),
PRIMARY KEY (contact_id),
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id));

CREATE TABLE Address(
address_id INT(20),
address VARCHAR(255),
customer_address_id INT(20),
PRIMARY KEY (address_id));

CREATE TABLE Customers_Addresses (
customer_address_id INT(20),
customer_id INT(20),
address_id INT(20),
PRIMARY KEY (customer_address_id),
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id),
FOREIGN KEY (address_id) REFERENCES Address(address_id));

CREATE TABLE Staff(
staff_id INT(20),
staff_name CHAR(50),
PRIMARY KEY (staff_id));



CREATE TABLE Bookings (
booking_id INT(50),
customer_id INT(50),
status_code INT(50),
staff_id INT(20),
payment_id INT(50),
travel_agency_id INT(50),
date_of_booking DATE,
PRIMARY KEY (booking_id),
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id),
FOREIGN KEY (status_code) REFERENCES Ref_Booking_Status(status_code),
FOREIGN KEY (staff_id) REFERENCES Staff(staff_id),
FOREIGN KEY (travel_agency_id) REFERENCES Travel_Agencies(travel_agency_id));

CREATE TABLE service_bookings(
service_id INT(20),
booking_id INT(20),
booking_start_date DATE,
booking_end_code DATE,
other_details VARCHAR (255),
FOREIGN KEY (service_id) REFERENCES services(service_id),
FOREIGN KEY (booking_id) REFERENCES bookings (booking_id));

CREATE TABLE airline (
airline_id INT(20),
airline_details VARCHAR (255),
service_id INT,
PRIMARY KEY (airline_id),
FOREIGN KEY (service_id) REFERENCES services (service_id));


CREATE TABLE cars(
car_id INT(20),
car_details VARCHAR (255),
service_id INT,
PRIMARY KEY (car_id),
FOREIGN KEY (service_id) REFERENCES services (service_id));

CREATE TABLE hotels (
hotel_id INT(20),
hotel_details VARCHAR (255),
service_id INT,
PRIMARY KEY (hotel_id),
FOREIGN KEY (service_id) REFERENCES services (service_id));

CREATE TABLE restaurants (
restaurant_id INT(20),
restaurant_details VARCHAR (255),
service_id INT(20),
PRIMARY KEY (restaurant_id),
FOREIGN KEY (service_id) REFERENCES services (service_id));

CREATE TABLE Payments (
payment_id INT(20),
booking_id INT(20),
promo_id INT(20),
cost_amount INT(20),
payment_amount INT(20),
payment_date datetime,
other_details CHAR(50),
PRIMARY KEY (payment_id),
FOREIGN KEY (booking_id) REFERENCES Bookings(booking_id),
FOREIGN KEY (promo_id) REFERENCES Promo(promo_id));

/* insert */

INSERT INTO travel_agencies
VALUES (7777,'ABUBAKAR');
INSERT INTO travel_agencies
VALUES (6666,'ABUBAKAR');

INSERT INTO Customer
VALUES (0001,1001,'Dex',19,'Dex@hotmail.com', 'Salesman');
INSERT INTO Customer
VALUES (0002,1002,'Tarhu',20,'Tarhu@hotmail.com', 'Businessman');
INSERT INTO Customer
VALUES (0003,1003,'Usaha',21,'Usaha@hotmail.com', 'Businessman');
INSERT INTO Customer
VALUES (0004,1004,'Niaga',25,'Niaga@hotmail.com', 'Account Collector');
INSERT INTO Customer
VALUES (0005,1005,'Mandy',28,'Minn@hotmail.com', 'Air Crew Officer');
INSERT INTO Customer
VALUES (0006,1006,'Salah',30,'Salakeh@hotmail.com', 'Air Crew Officer');
INSERT INTO Customer
VALUES (0007,1007,'Akmal',28,'Malu@hotmail.com', 'Saleman');
INSERT INTO Customer
VALUES (0008,1008,'Ahman',28,'Uluman@hotmail.com', 'Air Crew Officer');
INSERT INTO Customer
VALUES (0009,1009,'Sabrina',29,'Mixer@hotmail.com', 'Accountant');
INSERT INTO Customer
VALUES (0010,1010,'Hilux',30,'Lancer@hotmail.com', 'Accountant');
INSERT INTO Customer
VALUES (0011,1011,'Yao',35,'Zykhor@hotmail.com', 'Secutity');
INSERT INTO Customer
VALUES (0012,1012,'Ryan',45,'Ryan@hotmail.com', 'Security');
INSERT INTO Customer
VALUES (0013,1013,'Rem',25,'Ramly@hotmail.com', 'Teacher');
INSERT INTO Customer
VALUES (0014,1014,'SooYoon',27,'Yoonso@hotmail.com', 'Teacher');
INSERT INTO Customer
VALUES (0015,1015,'TiekSoon',40,'SoonTeik@hotmail.com', 'Teacher');
INSERT INTO Customer
VALUES (0016,1016,'Nimei',30,'Laobu@hotmail.com', 'Cooker');
INSERT INTO Customer
VALUES (00017,1017,'Alma',23,'Laoba@hotmail.com', 'Cooker');
INSERT INTO Customer
VALUES (0018,1018,'Ahmad',24,'hi1234@hotmail.com', 'Promoter');
INSERT INTO Customer
VALUES (0019,1019,'Steven',35,'steven@hotmail.com', 'Manager');
INSERT INTO Customer
VALUES (0020,1020,'Tom',35,'Jobby@hotmail.com', 'Manager');

INSERT INTO Address
VALUES (2001,'Gerai Umno 5 Jln Kepong Ulu Frim 52100 Kepong 52100 Malaysia 52100 Malaysia',1001);
INSERT INTO Address
VALUES (2002,'72 Lurah Temerloh 28000 Temerloh Temerloh Pahang 28000 Malaysia Temerloh Pahang 28000 Malaysia',1002);
INSERT INTO Address
VALUES (2003,'A0854882 Kampung Gabus 09100 Baling Baling Kedah 09100 Malaysia Baling Kedah 09100 Malaysia',1003);
INSERT INTO Address
VALUES (2004,'772 Jln Ah Cheong 36000 Teluk Intan Teluk Intan Perak 36000 Malaysia Teluk Intan Perak 36000 Malaysi',1004);
INSERT INTO Address
VALUES (2005,'1 Jln U1/31 Hicom Glenmarie Industrial 40000 Shah Alam Shah Alam 40000 Malaysia Shah Alam 40000 Mala',1005);
INSERT INTO Address
VALUES (2006,'Kedai Luar Bandar 6 Jln Meru Taman Seri Pekan 41050 41050 Malaysia 41050 Malaysia',1006);
INSERT INTO Address
VALUES (2007,'No. 19 Mini Stadium Jln Pasir Pekan 17000 Pasir Mas Kelantan Pasir Mas Kelantan 17000 Malaysia',1007);
INSERT INTO Address
VALUES (2008,'Club House Jln 3/109C Taman Abadi Indah 58100 Wilayah Persekutuan 58100 Malaysia 58100 Malaysia',1008);
INSERT INTO Address
VALUES (2009,'No. 31 1St Floor Lrg Dato Kaya Kecil 5 Taman Indah 42200 Kapar Kapar 42200 Malaysia',1009);
INSERT INTO Address
VALUES (2010,'No. 1 Jln Taiping 33000 Kuala Kangsar Perak Kuala Kangsar Perak 33000 Malaysia',1010);
INSERT INTO Address
VALUES (2011,'3 11 Jln Au1A/4B Taman Keramat Permai 54200 Wilayah Persekutuan 54200 Malaysia 54200 Malaysia',1011);
INSERT INTO Address
VALUES (2012,'11 Jalan Kota Raja H 27/H Seksyen 27 40400 Shah Alam Malaysia',1012);
INSERT INTO Address
VALUES (2013,'Ground Floor Safuan Plaza Jln Raja Alang 50300 Wilayah Persekutuan 50300 Malaysia',1013);
INSERT INTO Address
VALUES (2014,'2 1 Jln Haji Yaakub Kampung Air 88000 Kota Kinabalu Kota Kinabalu Sabah 88000 Malaysia Kota Kinabalu',1014);
INSERT INTO Address
VALUES (2015,'A 4 Jln Cemperai Kampung Baru Pandan 81100 Johor 81100 Malaysia Johor 81100 Malaysia',1015);
INSERT INTO Address
VALUES (2016,'No. 14 Jln Sungai Tua Kampung Laksamana 68100 Batu Caves Batu Caves 68100 Malaysia',1016);
INSERT INTO Address
VALUES (2017,'Komplek Perdagangan Jln Stulang Laut 80300 Johor 80300 Malaysia Johor 80300 Malaysia',1017);
INSERT INTO Address
VALUES (2018,'No. 1502 Jln Mata Air Kampung Mata Air 02500 Kangar Perlis Kangar Perlis 02500 Malaysia',1018);
INSERT INTO Address
VALUES (2019,'G9 Gerai Makan Pasar Jawa Jln Pasar Kaw 18 41400 41400 Malaysia',1019);
INSERT INTO Address
VALUES (2020,'2 26 Jln 14/48A Off Jln Sentul 51100 Wilayah Persekutuan 51100 Malaysia 51100 Malaysia',1020);

INSERT INTO Customers_Addresses
VALUES (1001,0001,2001);
INSERT INTO Customers_Addresses
VALUES (1002,0002,2002);
INSERT INTO Customers_Addresses
VALUES (1003,0003,2003);
INSERT INTO Customers_Addresses
VALUES (1004,0004,2004);
INSERT INTO Customers_Addresses
VALUES (1005,0005,2005);
INSERT INTO Customers_Addresses
VALUES (1006,0006,2006);
INSERT INTO Customers_Addresses
VALUES (1007,0007,2007);
INSERT INTO Customers_Addresses
VALUES (1008,0008,2008);
INSERT INTO Customers_Addresses
VALUES (1009,0009,2009);
INSERT INTO Customers_Addresses
VALUES (1010,0010,2010);
INSERT INTO Customers_Addresses
VALUES (1011,0011,2011);
INSERT INTO Customers_Addresses
VALUES (1012,0012,2012);
INSERT INTO Customers_Addresses
VALUES (1013,0013,2013);
INSERT INTO Customers_Addresses
VALUES (1014,0014,2014);
INSERT INTO Customers_Addresses
VALUES (1015,0015,2015);
INSERT INTO Customers_Addresses
VALUES (1016,0016,2016);
INSERT INTO Customers_Addresses
VALUES (1017,0017,2017);
INSERT INTO Customers_Addresses
VALUES (1018,0018,2018);
INSERT INTO Customers_Addresses
VALUES (1019,0019,2019);
INSERT INTO Customers_Addresses
VALUES (1020,0020,2020);

INSERT INTO Ref_Booking_Status
VALUES (0000,'Confirm');
INSERT INTO Ref_Booking_Status
VALUES (9999,'Pending');
INSERT INTO Ref_Booking_Status
VALUES (8888,'Cancel');

INSERT INTO promo
VALUES (4000,'2017-04-01','2017-12-31',50,'Happy Anniversary');
INSERT INTO promo
VALUES (4001,'2016-01-01','2017-01-01',30,'Opening Offer');

INSERT INTO  services
VALUES(1234, 'very expensive');
INSERT INTO  services
VALUES(2234, 'expensive');
INSERT INTO  services
VALUES(3234, 'moderate');
INSERT INTO  services
VALUES(4234, 'affordable');

INSERT INTO airline
VALUES (1111, 'Minister Class', 1234);
INSERT INTO airline
VALUES (1112, 'First Class', 2234);
INSERT INTO airline
VALUES (1113, 'Business Class', 3234);
INSERT INTO airline
VALUES (1114, 'Economy Class', 4234);

INSERT INTO cars
VALUES (1121, 'MPV', 1234);
INSERT INTO cars
VALUES (1122, 'MPV', 2234);
INSERT INTO cars
VALUES (1123, 'SUV', 3234);
INSERT INTO cars
VALUES (1124, 'SEDAN', 4234);

INSERT INTO hotels
VALUES (1131, 'Six Star Hotel', 1234);
INSERT INTO hotels
VALUES (1132, 'Six Star Hotel', 2234);
INSERT INTO hotels
VALUES (1133, 'Five Star Hotel', 3234);
INSERT INTO hotels
VALUES (1134, 'Four Star Hotel', 4234);

INSERT INTO restaurants
VALUES (1141, '3 Michelin Star', 1234);
INSERT INTO restaurants
VALUES (1142, '2 Michelin Star', 2234);
INSERT INTO restaurants
VALUES (1143, '5 star', 3234);
INSERT INTO restaurants
VALUES (1144, '4 star', 4234);

INSERT INTO staff (staff_id, staff_name) VALUES (9001, 'Iggie Golton');
INSERT INTO staff (staff_id, staff_name) VALUES (9002, 'Dahlia Gasken');
INSERT INTO staff (staff_id, staff_name) VALUES (9003, 'Doloritas Paliser');
INSERT INTO staff (staff_id, staff_name) VALUES (9004, 'Joyan Yegorev');
INSERT INTO staff (staff_id, staff_name) VALUES (9005, 'Gery Cowpe');
INSERT INTO staff (staff_id, staff_name) VALUES (9006, 'Adan Scutcheon');

INSERT INTO Bookings
VALUES (7001, 0001, 0000,9001,8001,7777, '2016-01-01');
INSERT INTO Bookings
VALUES (7002, 0002, 0000,9001,8002,6666, '2016-04-05');
INSERT INTO Bookings
VALUES (7003, 0003, 0000,9001,8003,7777, '2016-05-15');
INSERT INTO Bookings
VALUES (7004, 0004, 0000,9002,8004,6666, '2016-07-01');
INSERT INTO Bookings
VALUES (7005, 0005, 0000,9002,8005,7777, '2016-10-15');
INSERT INTO Bookings
VALUES (7006, 0006, 0000,9002,8006,6666, '2016-12-01');
INSERT INTO Bookings
VALUES (7007, 0007, 0000,9003,8007,7777, '2017-01-10');
INSERT INTO Bookings
VALUES (7008, 0008, 0000,9003,8009,6666, '2017-03-19');
INSERT INTO Bookings
VALUES (7009, 0009, 9999,9003,8010,7777, '2017-05-21');
INSERT INTO Bookings
VALUES (7010, 0010, 9999,9004,8011,6666, '2017-06-01');
INSERT INTO Bookings
VALUES (7011, 0011, 9999,9004,8012,6666, '2017-07-01');
INSERT INTO Bookings
VALUES (7012, 0012, 9999,9004,8013,7777 ,'2017-09-15');
INSERT INTO Bookings
VALUES (7013, 0013, 8888,9004,8014,6666, '2017-12-25');
INSERT INTO Bookings
VALUES (7014, 0014, 8888,9005,8015,7777, '2018-01-01');
INSERT INTO Bookings
VALUES (7015, 0015, 8888,9005,8016,6666, '2018-05-15');
INSERT INTO Bookings
VALUES (7016, 0016, 8888,9006,8017,7777, '2018-05-20');
INSERT INTO Bookings
VALUES (7017, 0017, 8888,9006,8018,6666, '2018-07-21');
INSERT INTO Bookings
VALUES (7018, 0018, 9999,9006,8019,7777, '2018-08-21');
INSERT INTO Bookings
VALUES (7019, 0019, 9999,9006,8020,6666, '2018-10-28');
INSERT INTO Bookings
VALUES (7020, 0020, 0000,9006,8021,6666, '2018-12-08');


INSERT INTO service_bookings
VALUES(1234,7001, '2016-02-01', '2016-02-06',' ' );
INSERT INTO service_bookings
VALUES(1234,7002, '2016-03-15', '2016-03-20', ' ' );
INSERT INTO service_bookings
VALUES(1234,7003, '2016-06-01', '2016-06-06', ' ');
INSERT INTO service_bookings
VALUES(1234,7004, '2016-08-10', '2016-08-15', ' ');
INSERT INTO service_bookings
VALUES(1234,7005, '2016-11-20', '2016-11-25',' ');
INSERT INTO service_bookings
VALUES(1234,7006, '2017-02-01', '2017-02-06', ' ');
INSERT INTO service_bookings
VALUES(2234,7007, '2017-02-10', '2017-02-15',' ');
INSERT INTO service_bookings
VALUES(2234,7008, '2017-04-16', '2017-04-20',' ');
INSERT INTO service_bookings
VALUES(2234,7009, '2017-06-26', '2017-06-30',' ');
INSERT INTO service_bookings
VALUES(2234,7010, '2017-07-01', '2017-07-06',' ');
INSERT INTO service_bookings
VALUES(2234,7011, '2017-08-07', '2017-08-13',' ');
INSERT INTO service_bookings
VALUES(3234,7012, '2017-10-15', '2017-10-20',' ');
INSERT INTO service_bookings
VALUES(3234,7013, '2018-01-01', '2018-01-06',' ');
INSERT INTO service_bookings
VALUES(3234,7014, '2018-02-01', '2018-02-06',' ');
INSERT INTO service_bookings
VALUES(3234,7015, '2018-06-10', '2018-06-15',' ');
INSERT INTO service_bookings
VALUES(4234,7016, '2018-06-25', '2018-06-26',' ');
INSERT INTO service_bookings
VALUES(4234,7017, '2018-08-01', '2018-08-06',' ');
INSERT INTO service_bookings
VALUES(4234,7018, '2018-09-10', '2018-09-15',' ');
INSERT INTO service_bookings
VALUES(4234,7019, '2018-11-21', '2018-11-25',' ');
INSERT INTO service_bookings
VALUES(4234,7020, '2018-12-20', '2018-12-26',' ');

INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8001, 1, 0189090930, 0189090123, 0181230930,0189456930, 0189789930);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8002, 2, 0159979801, 0106727976, 0159775365, 0168989805, 0102456755);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8003, 3, 0101991921, 0157307844, 0111446794, 0138924121, 013352892);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8004, 4, 0855758391, 0026805523, 0132454614, 0501363710, 0924827488);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8005, 5, 0073234721, 0474308128, 0236546734, 0695238767, 0225858681);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8006, 6, 0194482296, 0114371053, 0126163580, 0132806898, 0144861069);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8007, 7, 0189119804, 0117564057, 0168034121, 0177288065, 0132397238);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8008, 8, 0177633044, 0151005043, 0126588043, 0151048501, 0148439387);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8009, 10, 0127385412, 0124868515, 0142149447, 0112688928, 0118061714);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8010, 9, 0188309940, 0125557347, 0138920195, 0173613576, 0167188630);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8011, 11, 0131388521, 0168080108, 0103210134, 0176710052, 0172536104);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8012, 12, 0193259410, 0167651972, 0174294479, 0105580857, 0147883841);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8013, 13, 0191749160, 0195264789, 0106216217, 0154067632, 0142087107);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8014, 14, 0132673935, 0113105553, 0159524900, 0176001591, 0169724866);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8015, 15, 0195510912, 0197651733, 0127805663, 0186804937, 0191578494);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8016, 16, 0125613558, 0173111049, 0188281744, 0148823807, 0135088043);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8017, 17, 0147968507, 0155940363, 0181918026, 0111079561, 0141116793);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8018, 18, 0103713023, 0143086180, 0166624721, 0143907140, 0122014716);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8019, 19, 0129969780, 0169678919, 0102902140, 0134399631, 0172304910);
INSERT INTO Customer_contact_number (contact_id, customer_id, phone_number_1, phone_number_2, home_number, office_number, emergency_number) VALUES (8020, 20, 0197549328, 0179906434, 0143094385, 0109506414, 0154997636);

INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8001, 7001, 4001, 11178.58, 35451.59, '2016-01-01', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8002, 7002, 4001, 11180.51, 35238.02, '2016-04-05', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8003, 7003, 4001, 17322.32, 36433.78, '2016-05-15', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8004, 7004, 4001, 13907.3, 30761.07, '2016-07-01', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8005, 7005, 4001, 17759.7, 37424.34, '2016-10-15', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8006, 7006, 4001, 14026.91, 31203.08, '2016-12-01', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8007, 7007, '', 16005.78, 36851.55, '2017-01-10', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8008, 7008, '', 17689.08, 35681.41, '2017-03-19', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8009, 7009, 4000, 10471.04, 37682.45, '2017-05-21', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8010, 7010, 4000, 19260.0, 35358.52, '2017-06-01', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8011, 7011, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8012, 7012, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8013, 7013, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8014, 7014, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id,  cost_amount, payment_amount, payment_date, other_details) VALUES (8015, 7015, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8016, 7016, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8017, 7017, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8018, 7018, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8019, 7019, '', '', '', '');
INSERT INTO payments (payment_id, booking_id, promo_id, cost_amount, payment_amount, payment_date, other_details) VALUES (8020, 7020, '', '', '', '');

commit;