Drop Database If Exists berbatik_java;
Create Database berbatik_java;
Use berbatik_java;

Drop Table If Exists booking;
Create Table booking(
booking_id Int Not Null Primary Key,
person_id Int Not Null,
magento_customer_id Int Not Null,
status Varchar(20),
created Date,
last_modified Date,
sub_total Decimal(15, 2),
book_count Int,
decrease_count Int,
cancel_count Int,
person_name Varchar(50)
);

Drop Table If Exists detail_booking;
Create Table detail_booking(
booking_id Int Not Null,
product_id Int Not Null,
magento_product_id Int Not Null,
shop_id Int,
price Decimal(15, 2),
qty Int,
created Date,
last_modified Date,
status Varchar(20),
name Varchar(50),
local_sku Char(10),
attibutes Varchar(100),
Constraint Primary Key (booking_id, product_id),
Constraint Foreign Key (booking_id) References booking(booking_id)
);