| 4736 |
rajveer |
1 |
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
|
|
|
2 |
--
|
|
|
3 |
-- Host: localhost Database: user_test
|
|
|
4 |
-- ------------------------------------------------------
|
|
|
5 |
-- Server version 5.1.41-3ubuntu12.10
|
|
|
6 |
|
|
|
7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
|
8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
|
9 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
|
10 |
/*!40101 SET NAMES utf8 */;
|
|
|
11 |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
|
12 |
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
|
13 |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
|
14 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
|
15 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
|
16 |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
17 |
|
|
|
18 |
--
|
|
|
19 |
-- Dumping data for table `address`
|
|
|
20 |
--
|
|
|
21 |
|
|
|
22 |
LOCK TABLES `address` WRITE;
|
|
|
23 |
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
|
|
|
24 |
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);
|
|
|
25 |
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
|
|
|
26 |
UNLOCK TABLES;
|
|
|
27 |
|
|
|
28 |
--
|
|
|
29 |
-- Dumping data for table `affiliate`
|
|
|
30 |
--
|
|
|
31 |
|
|
|
32 |
LOCK TABLES `affiliate` WRITE;
|
|
|
33 |
/*!40000 ALTER TABLE `affiliate` DISABLE KEYS */;
|
|
|
34 |
/*!40000 ALTER TABLE `affiliate` ENABLE KEYS */;
|
|
|
35 |
UNLOCK TABLES;
|
|
|
36 |
|
|
|
37 |
--
|
|
|
38 |
-- Dumping data for table `cart`
|
|
|
39 |
--
|
|
|
40 |
|
|
|
41 |
LOCK TABLES `cart` WRITE;
|
|
|
42 |
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
|
|
|
43 |
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);
|
|
|
44 |
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
|
|
|
45 |
UNLOCK TABLES;
|
|
|
46 |
|
|
|
47 |
--
|
|
|
48 |
-- Dumping data for table `coupon`
|
|
|
49 |
--
|
|
|
50 |
|
|
|
51 |
LOCK TABLES `coupon` WRITE;
|
|
|
52 |
/*!40000 ALTER TABLE `coupon` DISABLE KEYS */;
|
|
|
53 |
/*!40000 ALTER TABLE `coupon` ENABLE KEYS */;
|
|
|
54 |
UNLOCK TABLES;
|
|
|
55 |
|
|
|
56 |
--
|
|
|
57 |
-- Dumping data for table `internalinfo`
|
|
|
58 |
--
|
|
|
59 |
|
|
|
60 |
LOCK TABLES `internalinfo` WRITE;
|
|
|
61 |
/*!40000 ALTER TABLE `internalinfo` DISABLE KEYS */;
|
|
|
62 |
/*!40000 ALTER TABLE `internalinfo` ENABLE KEYS */;
|
|
|
63 |
UNLOCK TABLES;
|
|
|
64 |
|
|
|
65 |
--
|
|
|
66 |
-- Dumping data for table `ipmap`
|
|
|
67 |
--
|
|
|
68 |
|
|
|
69 |
LOCK TABLES `ipmap` WRITE;
|
|
|
70 |
/*!40000 ALTER TABLE `ipmap` DISABLE KEYS */;
|
|
|
71 |
/*!40000 ALTER TABLE `ipmap` ENABLE KEYS */;
|
|
|
72 |
UNLOCK TABLES;
|
|
|
73 |
|
|
|
74 |
--
|
|
|
75 |
-- Dumping data for table `line`
|
|
|
76 |
--
|
|
|
77 |
|
|
|
78 |
LOCK TABLES `line` WRITE;
|
|
|
79 |
/*!40000 ALTER TABLE `line` DISABLE KEYS */;
|
|
|
80 |
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);
|
|
|
81 |
/*!40000 ALTER TABLE `line` ENABLE KEYS */;
|
|
|
82 |
UNLOCK TABLES;
|
|
|
83 |
|
|
|
84 |
--
|
|
|
85 |
-- Dumping data for table `masteraffiliate`
|
|
|
86 |
--
|
|
|
87 |
|
|
|
88 |
LOCK TABLES `masteraffiliate` WRITE;
|
|
|
89 |
/*!40000 ALTER TABLE `masteraffiliate` DISABLE KEYS */;
|
|
|
90 |
/*!40000 ALTER TABLE `masteraffiliate` ENABLE KEYS */;
|
|
|
91 |
UNLOCK TABLES;
|
|
|
92 |
|
|
|
93 |
--
|
|
|
94 |
-- Dumping data for table `phone`
|
|
|
95 |
--
|
|
|
96 |
|
|
|
97 |
LOCK TABLES `phone` WRITE;
|
|
|
98 |
/*!40000 ALTER TABLE `phone` DISABLE KEYS */;
|
|
|
99 |
/*!40000 ALTER TABLE `phone` ENABLE KEYS */;
|
|
|
100 |
UNLOCK TABLES;
|
|
|
101 |
|
|
|
102 |
--
|
|
|
103 |
-- Dumping data for table `promotion`
|
|
|
104 |
--
|
|
|
105 |
|
|
|
106 |
LOCK TABLES `promotion` WRITE;
|
|
|
107 |
/*!40000 ALTER TABLE `promotion` DISABLE KEYS */;
|
|
|
108 |
/*!40000 ALTER TABLE `promotion` ENABLE KEYS */;
|
|
|
109 |
UNLOCK TABLES;
|
|
|
110 |
|
|
|
111 |
--
|
|
|
112 |
-- Dumping data for table `promotiontracker`
|
|
|
113 |
--
|
|
|
114 |
|
|
|
115 |
LOCK TABLES `promotiontracker` WRITE;
|
|
|
116 |
/*!40000 ALTER TABLE `promotiontracker` DISABLE KEYS */;
|
|
|
117 |
/*!40000 ALTER TABLE `promotiontracker` ENABLE KEYS */;
|
|
|
118 |
UNLOCK TABLES;
|
|
|
119 |
|
|
|
120 |
--
|
|
|
121 |
-- Dumping data for table `socialhandle`
|
|
|
122 |
--
|
|
|
123 |
|
|
|
124 |
LOCK TABLES `socialhandle` WRITE;
|
|
|
125 |
/*!40000 ALTER TABLE `socialhandle` DISABLE KEYS */;
|
|
|
126 |
/*!40000 ALTER TABLE `socialhandle` ENABLE KEYS */;
|
|
|
127 |
UNLOCK TABLES;
|
|
|
128 |
|
|
|
129 |
--
|
|
|
130 |
-- Dumping data for table `socialservice`
|
|
|
131 |
--
|
|
|
132 |
|
|
|
133 |
LOCK TABLES `socialservice` WRITE;
|
|
|
134 |
/*!40000 ALTER TABLE `socialservice` DISABLE KEYS */;
|
|
|
135 |
/*!40000 ALTER TABLE `socialservice` ENABLE KEYS */;
|
|
|
136 |
UNLOCK TABLES;
|
|
|
137 |
|
|
|
138 |
--
|
|
|
139 |
-- Dumping data for table `tracker`
|
|
|
140 |
--
|
|
|
141 |
|
|
|
142 |
LOCK TABLES `tracker` WRITE;
|
|
|
143 |
/*!40000 ALTER TABLE `tracker` DISABLE KEYS */;
|
|
|
144 |
/*!40000 ALTER TABLE `tracker` ENABLE KEYS */;
|
|
|
145 |
UNLOCK TABLES;
|
|
|
146 |
|
|
|
147 |
--
|
|
|
148 |
-- Dumping data for table `tracklog`
|
|
|
149 |
--
|
|
|
150 |
|
|
|
151 |
LOCK TABLES `tracklog` WRITE;
|
|
|
152 |
/*!40000 ALTER TABLE `tracklog` DISABLE KEYS */;
|
|
|
153 |
/*!40000 ALTER TABLE `tracklog` ENABLE KEYS */;
|
|
|
154 |
UNLOCK TABLES;
|
|
|
155 |
|
|
|
156 |
--
|
|
|
157 |
-- Dumping data for table `user`
|
|
|
158 |
--
|
|
|
159 |
|
|
|
160 |
LOCK TABLES `user` WRITE;
|
|
|
161 |
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
|
|
|
162 |
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');
|
|
|
163 |
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
|
|
|
164 |
UNLOCK TABLES;
|
|
|
165 |
|
|
|
166 |
--
|
|
|
167 |
-- Dumping data for table `usercommunication`
|
|
|
168 |
--
|
|
|
169 |
|
|
|
170 |
LOCK TABLES `usercommunication` WRITE;
|
|
|
171 |
/*!40000 ALTER TABLE `usercommunication` DISABLE KEYS */;
|
|
|
172 |
/*!40000 ALTER TABLE `usercommunication` ENABLE KEYS */;
|
|
|
173 |
UNLOCK TABLES;
|
|
|
174 |
|
|
|
175 |
--
|
|
|
176 |
-- Dumping data for table `usernote`
|
|
|
177 |
--
|
|
|
178 |
|
|
|
179 |
LOCK TABLES `usernote` WRITE;
|
|
|
180 |
/*!40000 ALTER TABLE `usernote` DISABLE KEYS */;
|
|
|
181 |
/*!40000 ALTER TABLE `usernote` ENABLE KEYS */;
|
|
|
182 |
UNLOCK TABLES;
|
|
|
183 |
|
|
|
184 |
--
|
|
|
185 |
-- Dumping data for table `userstate`
|
|
|
186 |
--
|
|
|
187 |
|
|
|
188 |
LOCK TABLES `userstate` WRITE;
|
|
|
189 |
/*!40000 ALTER TABLE `userstate` DISABLE KEYS */;
|
|
|
190 |
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);
|
|
|
191 |
/*!40000 ALTER TABLE `userstate` ENABLE KEYS */;
|
|
|
192 |
UNLOCK TABLES;
|
|
|
193 |
|
|
|
194 |
--
|
|
|
195 |
-- Dumping data for table `userwidgetitem`
|
|
|
196 |
--
|
|
|
197 |
|
|
|
198 |
LOCK TABLES `userwidgetitem` WRITE;
|
|
|
199 |
/*!40000 ALTER TABLE `userwidgetitem` DISABLE KEYS */;
|
|
|
200 |
/*!40000 ALTER TABLE `userwidgetitem` ENABLE KEYS */;
|
|
|
201 |
UNLOCK TABLES;
|
|
|
202 |
|
|
|
203 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
204 |
|
|
|
205 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
206 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
207 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
208 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
209 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
210 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
|
211 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
212 |
|
|
|
213 |
-- Dump completed on 2011-09-21 19:20:44
|