Blame | Last modification | View Log | RSS feed
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)---- Host: localhost Database: user_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 `address`--LOCK TABLES `address` WRITE;/*!40000 ALTER TABLE `address` DISABLE KEYS */;INSERT INTO `address` (`id`, `line_1`, `line_2`, `landmark`, `city`, `state`, `pin`, `country`, `enabled`, `type`, `added_on`, `name`, `phone`, `user_id`) VALUES (1,'MyAddress Line1','MyAddress Line2',NULL,'Noida','Uttar Pradesh','201301',NULL,1,1,'1970-01-01 05:30:00','My Accounts User','9876543210',7),(2,'test','new',NULL,'hyderabad','Andhra Pradesh','500016',NULL,1,1,'1970-01-01 05:30:00','paymentuser','8766586577',8);/*!40000 ALTER TABLE `address` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `affiliate`--LOCK TABLES `affiliate` WRITE;/*!40000 ALTER TABLE `affiliate` DISABLE KEYS */;/*!40000 ALTER TABLE `affiliate` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `cart`--LOCK TABLES `cart` WRITE;/*!40000 ALTER TABLE `cart` DISABLE KEYS */;INSERT INTO `cart` (`id`, `user_id`, `cart_status`, `address_id`, `checked_out_on`, `created_on`, `updated_on`, `total_price`, `discounted_price`, `coupon_code`) VALUES (1,1,1,NULL,NULL,'2011-04-12 17:09:12','2011-04-12 17:09:12',NULL,NULL,NULL),(2,1,0,NULL,NULL,'2011-04-12 17:10:17','2011-04-12 17:10:17',NULL,NULL,NULL),(3,2,1,NULL,NULL,'2011-04-27 18:47:55','2011-04-27 18:47:55',NULL,NULL,NULL),(4,3,0,NULL,NULL,'2011-04-27 18:48:36','2011-04-27 18:48:36',NULL,NULL,NULL),(5,4,0,NULL,NULL,'2011-04-27 18:48:50','2011-04-27 18:48:50',NULL,NULL,NULL),(6,5,0,NULL,NULL,'2011-04-27 18:49:29','2011-04-27 18:49:29',NULL,NULL,NULL),(7,6,1,NULL,NULL,'2011-04-27 18:50:28','2011-04-27 18:50:28',NULL,NULL,NULL),(8,7,0,1,'2011-05-02 13:04:12','2011-05-02 12:40:11','2011-05-02 13:04:09',NULL,NULL,NULL),(9,8,0,2,'2011-08-09 16:14:43','2011-08-09 16:13:30','2011-08-09 16:13:51',30450,NULL,NULL);/*!40000 ALTER TABLE `cart` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `coupon`--LOCK TABLES `coupon` WRITE;/*!40000 ALTER TABLE `coupon` DISABLE KEYS */;/*!40000 ALTER TABLE `coupon` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `internalinfo`--LOCK TABLES `internalinfo` WRITE;/*!40000 ALTER TABLE `internalinfo` DISABLE KEYS */;/*!40000 ALTER TABLE `internalinfo` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `ipmap`--LOCK TABLES `ipmap` WRITE;/*!40000 ALTER TABLE `ipmap` DISABLE KEYS */;/*!40000 ALTER TABLE `ipmap` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `line`--LOCK TABLES `line` WRITE;/*!40000 ALTER TABLE `line` DISABLE KEYS */;INSERT INTO `line` (`cart_id`, `item_id`, `quantity`, `line_status`, `estimate`, `created_on`, `updated_on`, `actual_price`, `discounted_price`) VALUES (8,163,1,0,3,'2011-05-02 12:53:23','2011-05-02 12:53:23',NULL,NULL),(8,202,1,0,3,'2011-05-02 13:04:09','2011-05-02 13:04:09',NULL,NULL),(8,978,1,0,3,'2011-05-02 12:51:53','2011-05-02 12:51:53',NULL,NULL),(9,978,1,0,4,'2011-08-09 16:13:51','2011-08-09 16:13:51',30450,NULL);/*!40000 ALTER TABLE `line` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `masteraffiliate`--LOCK TABLES `masteraffiliate` WRITE;/*!40000 ALTER TABLE `masteraffiliate` DISABLE KEYS */;/*!40000 ALTER TABLE `masteraffiliate` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `phone`--LOCK TABLES `phone` WRITE;/*!40000 ALTER TABLE `phone` DISABLE KEYS */;/*!40000 ALTER TABLE `phone` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `promotion`--LOCK TABLES `promotion` WRITE;/*!40000 ALTER TABLE `promotion` DISABLE KEYS */;/*!40000 ALTER TABLE `promotion` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `promotiontracker`--LOCK TABLES `promotiontracker` WRITE;/*!40000 ALTER TABLE `promotiontracker` DISABLE KEYS */;/*!40000 ALTER TABLE `promotiontracker` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `socialhandle`--LOCK TABLES `socialhandle` WRITE;/*!40000 ALTER TABLE `socialhandle` DISABLE KEYS */;/*!40000 ALTER TABLE `socialhandle` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `socialservice`--LOCK TABLES `socialservice` WRITE;/*!40000 ALTER TABLE `socialservice` DISABLE KEYS */;/*!40000 ALTER TABLE `socialservice` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `tracker`--LOCK TABLES `tracker` WRITE;/*!40000 ALTER TABLE `tracker` DISABLE KEYS */;/*!40000 ALTER TABLE `tracker` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `tracklog`--LOCK TABLES `tracklog` WRITE;/*!40000 ALTER TABLE `tracklog` DISABLE KEYS */;/*!40000 ALTER TABLE `tracklog` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `user`--LOCK TABLES `user` WRITE;/*!40000 ALTER TABLE `user` DISABLE KEYS */;INSERT INTO `user` (`id`, `email`, `password`, `name`, `default_address_id`, `communication_email`, `active_cart_id`, `jsession_id`, `is_anonymous`, `date_of_birth`, `sex`, `mobile_number`, `source`, `source_start_time`) VALUES (1,'run-test@test.com','QShAZfTc2vw','run_test',NULL,'vikas.malik@shop2020.in',2,NULL,0,'',0,'','www.google.com',NULL),(3,'productuser@mailinator.com','SndS9gT3nDH24cXG3ZrlDA','productuser',NULL,'productuser@mailinator.com',4,NULL,0,'',2,'',NULL,NULL),(4,'cartuser@mailinator.com','Zkx4ADeCvTnCsyqbby8kpQ','cartuser',NULL,'cartuser@mailinator.com',5,NULL,0,'',2,'',NULL,NULL),(5,'forgetfuluser@mailinator.com','ZCN-2S8hm3G9L9biSB_n9g','forgetfuluser',NULL,'shippinguser@mailinator.com',6,NULL,0,'',2,'',NULL,NULL),(6,'82029AEBC8C6F15DCC2FD50C630B7B8C@anonymous.com','anonymous','anonymous',NULL,'82029AEBC8C6F15DCC2FD50C630B7B8C@anonymous.com',7,'82029AEBC8C6F15DCC2FD50C630B7B8C',1,NULL,2,NULL,NULL,NULL),(7,'myaccountuser@mailinator.com','_3pUk7LpajOxtG5INymZcw','My Accounts User',1,'myaccountuser@mailinator.com',8,NULL,0,'01/01/1991',0,'9876543210',NULL,NULL),(8,'paymentuser@mailinator.com','WdD2Pvafkbm2m9OTJWYAYw','paymentuser',2,'paymentuser@mailinator.com',9,NULL,0,'',0,'',NULL,'1970-01-01 05:30:00');/*!40000 ALTER TABLE `user` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `usercommunication`--LOCK TABLES `usercommunication` WRITE;/*!40000 ALTER TABLE `usercommunication` DISABLE KEYS */;/*!40000 ALTER TABLE `usercommunication` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `usernote`--LOCK TABLES `usernote` WRITE;/*!40000 ALTER TABLE `usernote` DISABLE KEYS */;/*!40000 ALTER TABLE `usernote` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `userstate`--LOCK TABLES `userstate` WRITE;/*!40000 ALTER TABLE `userstate` DISABLE KEYS */;INSERT INTO `userstate` (`id`, `last_login`, `last_logout`, `email_verification_sent_on`, `sms_verification_sent_on`, `is_email_verified`, `is_sms_verified`, `active_since`, `account_status`, `user_id`) VALUES (1,'2011-04-12 17:10:17',NULL,NULL,NULL,0,0,'2011-04-12 17:10:17',0,1),(3,'2011-04-27 18:48:36','2011-04-27 18:48:50',NULL,NULL,0,0,'2011-04-27 18:48:36',0,3),(4,'2011-04-27 18:49:26','2011-04-27 18:49:29',NULL,NULL,0,0,'2011-04-27 18:49:26',0,4),(5,'2011-04-27 18:50:25','2011-04-27 18:50:28',NULL,NULL,0,0,'2011-04-27 18:50:25',0,5),(6,NULL,NULL,NULL,NULL,0,0,'2011-05-02 12:39:11',0,6),(7,'2011-05-02 12:51:41','2011-05-02 12:51:23',NULL,NULL,0,0,'2011-05-02 12:40:11',0,7),(8,'2011-08-09 16:13:30',NULL,NULL,NULL,0,0,'2011-08-09 16:13:30',0,8);/*!40000 ALTER TABLE `userstate` ENABLE KEYS */;UNLOCK TABLES;---- Dumping data for table `userwidgetitem`--LOCK TABLES `userwidgetitem` WRITE;/*!40000 ALTER TABLE `userwidgetitem` DISABLE KEYS */;/*!40000 ALTER TABLE `userwidgetitem` 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