View difference between Paste ID: iWQD8cn2 and R2y6QtSR

-Drop Database If Exists berbatik_java;
+-- MySQL dump 10.13  Distrib 5.1.61, for debian-linux-gnu (x86_64)
-Create Database berbatik_java;
+--
-Use berbatik_java;
+-- Host: localhost    Database: berbatik_java
 -- ------------------------------------------------------
-Drop Table If Exists booking;
+-- Server version	5.1.61-0ubuntu0.11.10.1
-Create Table booking(
+
-booking_id Long Not Null Primary Key,
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-person_id Long Not Null,
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-magento_customer_id Int Not Null,
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-status Varchar(20),
+/*!40101 SET NAMES utf8 */;
-created Date,
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-last_modified Date,
+/*!40103 SET TIME_ZONE='+00:00' */;
-sub_total Decimal(15, 2),
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-book_count Int,
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-decrease_count Int,
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-cancel_count Int,
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-person_name Varchar(50)
+
-);
+--
 -- Table structure for table `booking`
-Drop Table If Exists detail_booking;
+--
-Create Table detail_booking(
+
-booking_id Long Not Null,
+DROP TABLE IF EXISTS `booking`;
-product_id Char(10) Not Null,
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
-magento_product_id Int Not Null,
+/*!40101 SET character_set_client = utf8 */;
-shop_id Char(10),
+CREATE TABLE `booking` (
-price Decimal(15, 2),
+  `booking_id` bigint(20) NOT NULL,
-qty Int,
+  `person_id` varchar(255) NOT NULL,
-created Date,
+  `magento_customer_id` bigint(20) NOT NULL,
-last_modified Date,
+  `status` varchar(20) DEFAULT NULL,
-status Varchar(20),
+  `created` datetime DEFAULT NULL,
-name Varchar(50),
+  `last_modified` datetime DEFAULT NULL,
-local_sku Char(10),
+  `subtotal` decimal(15,4) DEFAULT NULL,
-attibutes Varchar(100),
+  `book_count` int(11) DEFAULT NULL,
-Constraint Primary Key (booking_id, product_id),
+  `decrease_count` int(11) DEFAULT NULL,
-Constraint Foreign Key (booking_id) References booking(booking_id)
+  `cancel_count` int(11) DEFAULT NULL,
-);
+  `person_name` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`booking_id`),
   KEY `person_id` (`person_id`),
   KEY `magento_customer_id` (`magento_customer_id`),
   KEY `status` (`status`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Dumping data for table `booking`
 --
 
 LOCK TABLES `booking` WRITE;
 /*!40000 ALTER TABLE `booking` DISABLE KEYS */;
 INSERT INTO `booking` VALUES (1,'1',1,'pending','2012-05-21 00:00:00','2012-05-21 00:00:00','55000.0000',2,1,0,'');
 /*!40000 ALTER TABLE `booking` ENABLE KEYS */;
 UNLOCK TABLES;
 
 --
 -- Table structure for table `booking_detail`
 --
 
 DROP TABLE IF EXISTS `booking_detail`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `booking_detail` (
   `booking_detail_id` bigint(20) NOT NULL,
   `booking_id` bigint(20) NOT NULL,
   `product_id` varchar(255) NOT NULL,
   `magento_product_id` bigint(20) NOT NULL,
   `shop_id` varchar(255) DEFAULT NULL,
   `currency_id` char(3) DEFAULT NULL,
   `price` decimal(15,4) DEFAULT NULL,
   `qty` decimal(15,4) DEFAULT NULL,
   `created` datetime DEFAULT NULL,
   `last_modified` datetime DEFAULT NULL,
   `status` varchar(20) DEFAULT NULL,
   `name` varchar(255) DEFAULT NULL,
   `local_sku` varchar(255) DEFAULT NULL,
   `attributes` text,
   PRIMARY KEY (`booking_detail_id`),
   KEY `booking_id` (`booking_id`),
   KEY `product_id` (`product_id`),
   KEY `magento_product_id` (`magento_product_id`),
   KEY `shop_id` (`shop_id`),
   KEY `status` (`status`),
   KEY `local_sku` (`local_sku`),
   KEY `fk_booking_detail_booking_id` (`booking_id`),
   KEY `currency_id` (`currency_id`),
   CONSTRAINT `fk_booking_detail_booking_id` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`booking_id`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Dumping data for table `booking_detail`
 --
 
 LOCK TABLES `booking_detail` WRITE;
 /*!40000 ALTER TABLE `booking_detail` DISABLE KEYS */;
 INSERT INTO `booking_detail` VALUES (0,1,'1',1,'2',NULL,'50000.0000','1.0000','2012-05-21 00:00:00','2012-05-21 00:00:00','confirmed','baju','1','');
 /*!40000 ALTER TABLE `booking_detail` 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 2012-05-21 16:06:22