Subversion Repositories SmartDukaan

-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (i486)

--

-- Host: localhost    Database: transaction_test

-- ------------------------------------------------------

-- Server version	5.1.41-3ubuntu12.10

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!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 */;

--

-- Dumping data for table `batchnogenerator`

--

LOCK TABLES `batchnogenerator` WRITE;

/*!40000 ALTER TABLE `batchnogenerator` DISABLE KEYS */;

/*!40000 ALTER TABLE `batchnogenerator` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Dumping data for table `invoiceidgenerator`

--

LOCK TABLES `invoiceidgenerator` WRITE;

/*!40000 ALTER TABLE `invoiceidgenerator` DISABLE KEYS */;

/*!40000 ALTER TABLE `invoiceidgenerator` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Dumping data for table `lineitem`

--

LOCK TABLES `lineitem` WRITE;

/*!40000 ALTER TABLE `lineitem` DISABLE KEYS */;

INSERT INTO `lineitem` (`id`, `item_id`, `productGroup`, `brand`, `model_number`, `model_name`, `color`, `extra_info`, `quantity`, `unit_price`, `unit_weight`, `total_price`, `transfer_price`, `total_weight`, `order_id`, `serial_number`, `item_number`) VALUES (75,163,'Handsets','Spice','QT68',NULL,'Black',NULL,1,3700,0.37,3700,NULL,0.37,75,NULL,NULL),(76,202,'Bluetooth Heads','Nokia','BH-217',NULL,NULL,NULL,1,1949,NULL,1949,NULL,NULL,76,NULL,NULL),(77,978,'Handsets','Sony Ericsson','R800i','Xperia Play','Black',NULL,1,30450,0.44,30450,NULL,0.44,77,NULL,NULL),(78,978,'Handsets','Sony Ericsson','R800i','Xperia Play','Black',NULL,1,30450,0.44,30450,NULL,0.44,78,NULL,NULL),(79,985,'Handsets','Spice ','M5100',NULL,NULL,NULL,1,1650,NULL,1650,NULL,NULL,79,NULL,NULL);

/*!40000 ALTER TABLE `lineitem` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Dumping data for table `order`

--

LOCK TABLES `order` WRITE;

/*!40000 ALTER TABLE `order` DISABLE KEYS */;

INSERT INTO `order` (`id`, `warehouse_id`, `logistics_provider_id`, `airwaybill_no`, `tracking_id`, `expected_delivery_time`, `customer_id`, `customer_name`, `customer_mobilenumber`, `customer_pincode`, `customer_address1`, `customer_address2`, `customer_city`, `customer_state`, `customer_email`, `status`, `statusDescription`, `total_amount`, `total_weight`, `invoice_number`, `billed_by`, `created_timestamp`, `accepted_timestamp`, `billing_timestamp`, `shipping_timestamp`, `pickup_timestamp`, `delivery_timestamp`, `outofstock_timestamp`, `transaction_id`, `jacket_number`, `receiver`, `batchNo`, `serialNo`, `doaFlag`, `pickupRequestNo`, `purchase_order_id`, `doa_auth_timestamp`, `doa_pickup_timestamp`, `received_return_timestamp`, `reship_timestamp`, `refund_timestamp`, `new_order_id`, `cod`, `verification_timestamp`, `refunded_by`, `refund_reason`) VALUES (75,NULL,2,'4112280501092330',NULL,NULL,7,'My Accounts User','9876543210','201301','MyAddress Line1','MyAddress Line2','Noida','Uttar Pradesh','myaccountuser@mailinator.com',7,'Payment Pending',3700,0.37,NULL,NULL,'2011-05-02 13:04:22',NULL,NULL,NULL,NULL,NULL,NULL,30,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(76,NULL,2,'4252621801241844',NULL,NULL,7,'My Accounts User','9876543210','201301','MyAddress Line1','MyAddress Line2','Noida','Uttar Pradesh','myaccountuser@mailinator.com',11,'Payment Pending',1949,NULL,NULL,NULL,'2011-05-02 13:04:22',NULL,NULL,NULL,NULL,NULL,NULL,30,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(77,NULL,1,'43726930402',NULL,NULL,7,'My Accounts User','9876543210','201301','MyAddress Line1','MyAddress Line2','Noida','Uttar Pradesh','myaccountuser@mailinator.com',12,'Payment Pending',30450,0.44,NULL,NULL,'2011-05-02 13:04:22',NULL,NULL,NULL,NULL,NULL,NULL,30,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(78,NULL,NULL,NULL,NULL,NULL,8,'paymentuser','8766586577','500016','test','new','hyderabad','Andhra Pradesh','paymentuser@mailinator.com',0,'Payment Pending',30450,0.44,NULL,NULL,'2011-08-31 15:42:21',NULL,NULL,NULL,NULL,NULL,NULL,37,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,NULL,NULL,NULL,NULL,NULL,8,'paymentuser','8766586577','500016','test','new','hyderabad','Andhra Pradesh','paymentuser@mailinator.com',0,'Payment Pending',1650,NULL,NULL,NULL,'2011-08-31 15:42:21',NULL,NULL,NULL,NULL,NULL,NULL,37,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `order` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Dumping data for table `returnorder`

--

LOCK TABLES `returnorder` WRITE;

/*!40000 ALTER TABLE `returnorder` DISABLE KEYS */;

/*!40000 ALTER TABLE `returnorder` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Dumping data for table `transaction`

--

LOCK TABLES `transaction` WRITE;

/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;

INSERT INTO `transaction` (`id`, `createdOn`, `status`, `status_message`, `customer_id`, `shopping_cart_id`, `coupon_code`, `session_source`, `session_start_time`) VALUES (30,'2011-05-02 13:04:22',0,'New transaction',7,8,NULL,NULL,NULL),(37,'2011-08-31 15:42:21',0,'New transaction',8,9,NULL,'DIRECT : (http://www.shop2020.in/pay-successpaymentId=120)','2011-08-25 11:32:20');

/*!40000 ALTER TABLE `transaction` 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 2011-09-21 19:20:44