View difference between Paste ID: 2RR39nPv and R2y6QtSR

 Drop Database If Exists berbatik_java;
 Create Database berbatik_java;
 Use berbatik_java;
 
 Drop Table If Exists booking;
 Create Table booking(
-booking_id Long Not Null Primary Key,
+booking_id Int Not Null Primary Key,
-person_id Long Not Null,
+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 Long Not Null,
+booking_id Int Not Null,
-product_id Char(10) Not Null,
+product_id Int Not Null,
 magento_product_id Int Not Null,
-shop_id Char(10),
+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)
 );