| 13532 |
anikendra |
1 |
-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (i686)
|
|
|
2 |
--
|
|
|
3 |
-- Host: localhost Database: dtr
|
|
|
4 |
-- ------------------------------------------------------
|
|
|
5 |
-- Server version 5.5.40-0ubuntu0.12.04.1
|
|
|
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 |
-- Table structure for table `categories`
|
|
|
20 |
--
|
|
|
21 |
|
|
|
22 |
DROP TABLE IF EXISTS `categories`;
|
|
|
23 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
24 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
25 |
CREATE TABLE `categories` (
|
|
|
26 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
27 |
`parent_id` int(10) DEFAULT NULL,
|
|
|
28 |
`lft` int(10) DEFAULT NULL,
|
|
|
29 |
`rght` int(10) DEFAULT NULL,
|
|
|
30 |
`name` varchar(255) DEFAULT '',
|
|
|
31 |
PRIMARY KEY (`id`)
|
|
|
32 |
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
|
|
|
33 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
34 |
|
|
|
35 |
--
|
|
|
36 |
-- Dumping data for table `categories`
|
|
|
37 |
--
|
|
|
38 |
|
|
|
39 |
LOCK TABLES `categories` WRITE;
|
|
|
40 |
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
|
|
|
41 |
INSERT INTO `categories` VALUES (1,NULL,1,18,'Root'),(16,1,2,7,'Mobiles'),(17,1,8,13,'Tablets'),(18,1,14,15,'Laptops'),(19,1,16,17,'Accessories'),(20,16,3,4,'Android Phones'),(21,16,5,6,'Windows Phones'),(22,17,9,10,'Apple'),(23,17,11,12,'Samsung');
|
|
|
42 |
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
|
|
|
43 |
UNLOCK TABLES;
|
|
|
44 |
|
|
|
45 |
--
|
|
|
46 |
-- Table structure for table `clicks`
|
|
|
47 |
--
|
|
|
48 |
|
|
|
49 |
DROP TABLE IF EXISTS `clicks`;
|
|
|
50 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
51 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
52 |
CREATE TABLE `clicks` (
|
|
|
53 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
54 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
55 |
`store_product_id` int(10) unsigned NOT NULL,
|
|
|
56 |
`tag` varchar(16) NOT NULL,
|
|
|
57 |
`created` datetime NOT NULL,
|
|
|
58 |
PRIMARY KEY (`id`),
|
|
|
59 |
KEY `id_user_click` (`user_id`,`store_product_id`)
|
|
|
60 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
61 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
62 |
|
|
|
63 |
--
|
|
|
64 |
-- Dumping data for table `clicks`
|
|
|
65 |
--
|
|
|
66 |
|
|
|
67 |
LOCK TABLES `clicks` WRITE;
|
|
|
68 |
/*!40000 ALTER TABLE `clicks` DISABLE KEYS */;
|
|
|
69 |
/*!40000 ALTER TABLE `clicks` ENABLE KEYS */;
|
|
|
70 |
UNLOCK TABLES;
|
|
|
71 |
|
|
|
72 |
--
|
|
|
73 |
-- Table structure for table `gmail_messages`
|
|
|
74 |
--
|
|
|
75 |
|
|
|
76 |
DROP TABLE IF EXISTS `gmail_messages`;
|
|
|
77 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
78 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
79 |
CREATE TABLE `gmail_messages` (
|
|
|
80 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
81 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
82 |
`email` varchar(128) NOT NULL,
|
|
|
83 |
`threadid` int(11) NOT NULL,
|
|
|
84 |
`messageid` int(11) NOT NULL,
|
|
|
85 |
`subject` varchar(512) NOT NULL,
|
|
|
86 |
`body` text NOT NULL,
|
|
|
87 |
`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',
|
|
|
88 |
`created` datetime NOT NULL,
|
|
|
89 |
`modified` datetime NOT NULL,
|
|
|
90 |
PRIMARY KEY (`id`)
|
|
|
91 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
92 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
93 |
|
|
|
94 |
--
|
|
|
95 |
-- Dumping data for table `gmail_messages`
|
|
|
96 |
--
|
|
|
97 |
|
|
|
98 |
LOCK TABLES `gmail_messages` WRITE;
|
|
|
99 |
/*!40000 ALTER TABLE `gmail_messages` DISABLE KEYS */;
|
|
|
100 |
/*!40000 ALTER TABLE `gmail_messages` ENABLE KEYS */;
|
|
|
101 |
UNLOCK TABLES;
|
|
|
102 |
|
|
|
103 |
--
|
|
|
104 |
-- Table structure for table `groups`
|
|
|
105 |
--
|
|
|
106 |
|
|
|
107 |
DROP TABLE IF EXISTS `groups`;
|
|
|
108 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
109 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
110 |
CREATE TABLE `groups` (
|
|
|
111 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
112 |
`name` varchar(100) NOT NULL,
|
|
|
113 |
`created` datetime DEFAULT NULL,
|
|
|
114 |
`modified` datetime DEFAULT NULL,
|
|
|
115 |
PRIMARY KEY (`id`)
|
|
|
116 |
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
|
|
|
117 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
118 |
|
|
|
119 |
--
|
|
|
120 |
-- Dumping data for table `groups`
|
|
|
121 |
--
|
|
|
122 |
|
|
|
123 |
LOCK TABLES `groups` WRITE;
|
|
|
124 |
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
|
|
|
125 |
INSERT INTO `groups` VALUES (1,'user','2015-01-08 12:23:44','2015-01-08 12:23:44'),(2,'admin','2015-01-08 12:23:44','2015-01-08 12:23:44');
|
|
|
126 |
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
|
|
|
127 |
UNLOCK TABLES;
|
|
|
128 |
|
|
|
129 |
--
|
|
|
130 |
-- Table structure for table `orders`
|
|
|
131 |
--
|
|
|
132 |
|
|
|
133 |
DROP TABLE IF EXISTS `orders`;
|
|
|
134 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
135 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
136 |
CREATE TABLE `orders` (
|
|
|
137 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
138 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
139 |
`store_id` int(10) unsigned NOT NULL,
|
|
|
140 |
`store_order_id` varchar(32) NOT NULL,
|
|
|
141 |
`order_url` varchar(256) NOT NULL,
|
|
|
142 |
`rawhtml` longtext NOT NULL,
|
|
|
143 |
`product_name` varchar(256) NOT NULL,
|
|
|
144 |
`product_code` varchar(128) DEFAULT NULL,
|
|
|
145 |
`unit_price` float(6,2) DEFAULT NULL,
|
|
|
146 |
`total_amount` float(6,2) DEFAULT NULL,
|
|
|
147 |
`customer_name` varchar(256) NOT NULL,
|
|
|
148 |
`customer_email` varchar(256) NOT NULL,
|
|
|
149 |
`customer_mobile` varchar(15) NOT NULL,
|
|
|
150 |
`customer_address` varchar(512) NOT NULL,
|
|
|
151 |
`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',
|
|
|
152 |
`created` datetime NOT NULL,
|
|
|
153 |
`modified` datetime NOT NULL,
|
|
|
154 |
PRIMARY KEY (`id`)
|
|
|
155 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
156 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
157 |
|
|
|
158 |
--
|
|
|
159 |
-- Dumping data for table `orders`
|
|
|
160 |
--
|
|
|
161 |
|
|
|
162 |
LOCK TABLES `orders` WRITE;
|
|
|
163 |
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
|
|
|
164 |
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
|
|
|
165 |
UNLOCK TABLES;
|
|
|
166 |
|
|
|
167 |
--
|
|
|
168 |
-- Table structure for table `preferences`
|
|
|
169 |
--
|
|
|
170 |
|
|
|
171 |
DROP TABLE IF EXISTS `preferences`;
|
|
|
172 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
173 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
174 |
CREATE TABLE `preferences` (
|
|
|
175 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
176 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
177 |
`key` varchar(32) NOT NULL,
|
|
|
178 |
`value` varchar(128) NOT NULL,
|
|
|
179 |
`created` datetime NOT NULL,
|
|
|
180 |
`modified` datetime NOT NULL,
|
|
|
181 |
PRIMARY KEY (`id`)
|
|
|
182 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
183 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
184 |
|
|
|
185 |
--
|
|
|
186 |
-- Dumping data for table `preferences`
|
|
|
187 |
--
|
|
|
188 |
|
|
|
189 |
LOCK TABLES `preferences` WRITE;
|
|
|
190 |
/*!40000 ALTER TABLE `preferences` DISABLE KEYS */;
|
|
|
191 |
/*!40000 ALTER TABLE `preferences` ENABLE KEYS */;
|
|
|
192 |
UNLOCK TABLES;
|
|
|
193 |
|
|
|
194 |
--
|
|
|
195 |
-- Table structure for table `products`
|
|
|
196 |
--
|
|
|
197 |
|
|
|
198 |
DROP TABLE IF EXISTS `products`;
|
|
|
199 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
200 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
201 |
CREATE TABLE `products` (
|
|
|
202 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
203 |
`name` varchar(256) NOT NULL,
|
|
|
204 |
`category_id` int(10) unsigned NOT NULL,
|
|
|
205 |
`tag_line` varchar(128) DEFAULT NULL,
|
|
|
206 |
`created` datetime NOT NULL,
|
|
|
207 |
`modified` datetime NOT NULL,
|
|
|
208 |
PRIMARY KEY (`id`)
|
|
|
209 |
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
|
|
|
210 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
211 |
|
|
|
212 |
--
|
|
|
213 |
-- Dumping data for table `products`
|
|
|
214 |
--
|
|
|
215 |
|
|
|
216 |
LOCK TABLES `products` WRITE;
|
|
|
217 |
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
|
|
|
218 |
INSERT INTO `products` VALUES (1,'Android One Dream UNO',20,'Your Android One experience Spiced up','2015-01-08 15:08:05','2015-01-08 15:08:05'),(2,'Spice Stellar 361',16,'','2015-01-08 15:28:01','2015-01-08 15:28:01');
|
|
|
219 |
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
|
|
|
220 |
UNLOCK TABLES;
|
|
|
221 |
|
|
|
222 |
--
|
|
|
223 |
-- Table structure for table `productviews`
|
|
|
224 |
--
|
|
|
225 |
|
|
|
226 |
DROP TABLE IF EXISTS `productviews`;
|
|
|
227 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
228 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
229 |
CREATE TABLE `productviews` (
|
|
|
230 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
231 |
`product_id` int(10) unsigned NOT NULL,
|
|
|
232 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
233 |
`created` datetime NOT NULL,
|
|
|
234 |
`modified` datetime NOT NULL,
|
|
|
235 |
PRIMARY KEY (`id`)
|
|
|
236 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
237 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
238 |
|
|
|
239 |
--
|
|
|
240 |
-- Dumping data for table `productviews`
|
|
|
241 |
--
|
|
|
242 |
|
|
|
243 |
LOCK TABLES `productviews` WRITE;
|
|
|
244 |
/*!40000 ALTER TABLE `productviews` DISABLE KEYS */;
|
|
|
245 |
/*!40000 ALTER TABLE `productviews` ENABLE KEYS */;
|
|
|
246 |
UNLOCK TABLES;
|
|
|
247 |
|
|
|
248 |
--
|
|
|
249 |
-- Table structure for table `social_profiles`
|
|
|
250 |
--
|
|
|
251 |
|
|
|
252 |
DROP TABLE IF EXISTS `social_profiles`;
|
|
|
253 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
254 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
255 |
CREATE TABLE `social_profiles` (
|
|
|
256 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
257 |
`type` enum('google','facebook') NOT NULL DEFAULT 'google',
|
|
|
258 |
`social_id` varchar(64) NOT NULL,
|
|
|
259 |
`access_token` varchar(128) NOT NULL,
|
|
|
260 |
`refresh_token` varchar(128) DEFAULT NULL,
|
|
|
261 |
PRIMARY KEY (`id`)
|
|
|
262 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
263 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
264 |
|
|
|
265 |
--
|
|
|
266 |
-- Dumping data for table `social_profiles`
|
|
|
267 |
--
|
|
|
268 |
|
|
|
269 |
LOCK TABLES `social_profiles` WRITE;
|
|
|
270 |
/*!40000 ALTER TABLE `social_profiles` DISABLE KEYS */;
|
|
|
271 |
/*!40000 ALTER TABLE `social_profiles` ENABLE KEYS */;
|
|
|
272 |
UNLOCK TABLES;
|
|
|
273 |
|
|
|
274 |
--
|
|
|
275 |
-- Table structure for table `store_products`
|
|
|
276 |
--
|
|
|
277 |
|
|
|
278 |
DROP TABLE IF EXISTS `store_products`;
|
|
|
279 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
280 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
281 |
CREATE TABLE `store_products` (
|
|
|
282 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
283 |
`store_id` int(10) unsigned NOT NULL,
|
|
|
284 |
`product_id` int(10) unsigned NOT NULL,
|
|
|
285 |
`product_url` varchar(256) NOT NULL,
|
|
|
286 |
`img_url` varchar(256) NOT NULL,
|
|
|
287 |
`short_descrption` varchar(256) NOT NULL,
|
|
|
288 |
`price` float(6,2) NOT NULL,
|
|
|
289 |
`status` enum('active','paused','deleted') NOT NULL DEFAULT 'active',
|
|
|
290 |
`last_crawled` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
|
291 |
`created` datetime NOT NULL,
|
|
|
292 |
`modified` datetime NOT NULL,
|
|
|
293 |
PRIMARY KEY (`id`)
|
|
|
294 |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
|
|
|
295 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
296 |
|
|
|
297 |
--
|
|
|
298 |
-- Dumping data for table `store_products`
|
|
|
299 |
--
|
|
|
300 |
|
|
|
301 |
LOCK TABLES `store_products` WRITE;
|
|
|
302 |
/*!40000 ALTER TABLE `store_products` DISABLE KEYS */;
|
|
|
303 |
INSERT INTO `store_products` VALUES (1,2,1,'http://www.flipkart.com/spice-android-one-dream-uno-mi-498/p/itme3h7yzkvtvpgg?pid=MOBDZUAKFFAP5VMD','http://img6a.flixcart.com/image/mobile/v/m/d/spice-android-one-dream-uno-mi-498-400x400-imaeyzyqnxc9fqcw.jpeg','Android v4.4.4 OS; 5 MP Primary Camera; 2 MP Secondary Camera; Dual Sim (GSM + GSM)',5999.00,'active','2015-01-08 09:46:00','2015-01-08 15:18:56','2015-01-08 15:18:56'),(2,1,1,'http://www.amazon.in/Spice-Android-Dream-Mi-498-Black/dp/B00P0RFEZ4','http://ecx.images-amazon.com/images/I/611DJWZm6GL._SL1100_.jpg','Android one',6113.00,'active','2015-01-08 09:55:09','2015-01-08 15:23:16','2015-01-08 15:23:16'),(3,4,2,'http://www.saholic.com/mobile-phones/spice-stellar-361-1011378','http://static0.saholic.com/images/media/1011378/spice-stellar-361-default-1405761208000.jpg','Dual-SIM | Android Jelly Bean | 3.5 inch display | 1400 mAh battery | 2MP back cam, 1.3MP front cam | 1GHz dual core processor | Wi-Fi, Bluetooth',3349.00,'active','0000-00-00 00:00:00','2015-01-08 15:32:51','2015-01-08 15:32:51'),(4,3,2,'http://www.snapdeal.com/product/spice-stellar-361/836397359','http://n2.sdlcdn.com/imgs/a/l/5/large/Spice-Stellar-361-SDL886397828-1-ecf3b.jpg','Spice Stellar Mi-361 smartphone with 3.50-inch 320x480 display powered by 1GHz processor alongside 256MB RAM and 2-megapixel rear camera',3222.00,'active','0000-00-00 00:00:00','2015-01-08 15:48:55','2015-01-08 15:48:55');
|
|
|
304 |
/*!40000 ALTER TABLE `store_products` ENABLE KEYS */;
|
|
|
305 |
UNLOCK TABLES;
|
|
|
306 |
|
|
|
307 |
--
|
|
|
308 |
-- Table structure for table `stores`
|
|
|
309 |
--
|
|
|
310 |
|
|
|
311 |
DROP TABLE IF EXISTS `stores`;
|
|
|
312 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
313 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
314 |
CREATE TABLE `stores` (
|
|
|
315 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
316 |
`name` varchar(32) NOT NULL,
|
|
|
317 |
`status` enum('active','paused','deleted') NOT NULL DEFAULT 'paused',
|
|
|
318 |
`affiliate_id` varchar(32) NOT NULL,
|
|
|
319 |
`created` datetime NOT NULL,
|
|
|
320 |
`modified` datetime NOT NULL,
|
|
|
321 |
PRIMARY KEY (`id`)
|
|
|
322 |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
|
|
|
323 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
324 |
|
|
|
325 |
--
|
|
|
326 |
-- Dumping data for table `stores`
|
|
|
327 |
--
|
|
|
328 |
|
|
|
329 |
LOCK TABLES `stores` WRITE;
|
|
|
330 |
/*!40000 ALTER TABLE `stores` DISABLE KEYS */;
|
|
|
331 |
INSERT INTO `stores` VALUES (1,'Amazon','active','saholic-21','2015-01-08 14:59:02','2015-01-08 14:59:02'),(2,'Flipkart','active','saholic1g','2015-01-08 15:00:11','2015-01-08 15:00:11'),(3,'Snapdeal','active','16271','2015-01-08 15:01:49','2015-01-08 15:51:43'),(4,'Spice','active','dtr','2015-01-08 15:32:13','2015-01-08 15:32:13');
|
|
|
332 |
/*!40000 ALTER TABLE `stores` ENABLE KEYS */;
|
|
|
333 |
UNLOCK TABLES;
|
|
|
334 |
|
|
|
335 |
--
|
|
|
336 |
-- Table structure for table `user_accounts`
|
|
|
337 |
--
|
|
|
338 |
|
|
|
339 |
DROP TABLE IF EXISTS `user_accounts`;
|
|
|
340 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
341 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
342 |
CREATE TABLE `user_accounts` (
|
|
|
343 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
344 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
345 |
`account_type` enum('saholic','gcm_regid') NOT NULL DEFAULT 'saholic',
|
|
|
346 |
`account_key` varchar(128) NOT NULL,
|
|
|
347 |
PRIMARY KEY (`id`),
|
|
|
348 |
UNIQUE KEY `unique_key` (`user_id`,`account_type`,`account_key`)
|
|
|
349 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
350 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
351 |
|
|
|
352 |
--
|
|
|
353 |
-- Dumping data for table `user_accounts`
|
|
|
354 |
--
|
|
|
355 |
|
|
|
356 |
LOCK TABLES `user_accounts` WRITE;
|
|
|
357 |
/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;
|
|
|
358 |
/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;
|
|
|
359 |
UNLOCK TABLES;
|
|
|
360 |
|
|
|
361 |
--
|
|
|
362 |
-- Table structure for table `user_actions`
|
|
|
363 |
--
|
|
|
364 |
|
|
|
365 |
DROP TABLE IF EXISTS `user_actions`;
|
|
|
366 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
367 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
368 |
CREATE TABLE `user_actions` (
|
|
|
369 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
370 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
371 |
`store_product_id` int(10) unsigned NOT NULL,
|
|
|
372 |
`action` enum('like','dislike') DEFAULT NULL,
|
|
|
373 |
`created` datetime NOT NULL,
|
|
|
374 |
PRIMARY KEY (`id`),
|
|
|
375 |
UNIQUE KEY `uk_unique_action` (`user_id`,`store_product_id`,`action`)
|
|
|
376 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
377 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
378 |
|
|
|
379 |
--
|
|
|
380 |
-- Dumping data for table `user_actions`
|
|
|
381 |
--
|
|
|
382 |
|
|
|
383 |
LOCK TABLES `user_actions` WRITE;
|
|
|
384 |
/*!40000 ALTER TABLE `user_actions` DISABLE KEYS */;
|
|
|
385 |
/*!40000 ALTER TABLE `user_actions` ENABLE KEYS */;
|
|
|
386 |
UNLOCK TABLES;
|
|
|
387 |
|
|
|
388 |
--
|
|
|
389 |
-- Table structure for table `user_sms`
|
|
|
390 |
--
|
|
|
391 |
|
|
|
392 |
DROP TABLE IF EXISTS `user_sms`;
|
|
|
393 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
394 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
395 |
CREATE TABLE `user_sms` (
|
|
|
396 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
397 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
398 |
`message` varchar(160) NOT NULL,
|
|
|
399 |
`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',
|
|
|
400 |
`created` datetime NOT NULL,
|
|
|
401 |
`modified` datetime NOT NULL,
|
|
|
402 |
PRIMARY KEY (`id`)
|
|
|
403 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
404 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
405 |
|
|
|
406 |
--
|
|
|
407 |
-- Dumping data for table `user_sms`
|
|
|
408 |
--
|
|
|
409 |
|
|
|
410 |
LOCK TABLES `user_sms` WRITE;
|
|
|
411 |
/*!40000 ALTER TABLE `user_sms` DISABLE KEYS */;
|
|
|
412 |
/*!40000 ALTER TABLE `user_sms` ENABLE KEYS */;
|
|
|
413 |
UNLOCK TABLES;
|
|
|
414 |
|
|
|
415 |
--
|
|
|
416 |
-- Table structure for table `user_urls`
|
|
|
417 |
--
|
|
|
418 |
|
|
|
419 |
DROP TABLE IF EXISTS `user_urls`;
|
|
|
420 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
421 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
422 |
CREATE TABLE `user_urls` (
|
|
|
423 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
424 |
`user_id` int(10) unsigned NOT NULL,
|
|
|
425 |
`url` varchar(256) NOT NULL,
|
|
|
426 |
`created` datetime NOT NULL,
|
|
|
427 |
PRIMARY KEY (`id`)
|
|
|
428 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
429 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
430 |
|
|
|
431 |
--
|
|
|
432 |
-- Dumping data for table `user_urls`
|
|
|
433 |
--
|
|
|
434 |
|
|
|
435 |
LOCK TABLES `user_urls` WRITE;
|
|
|
436 |
/*!40000 ALTER TABLE `user_urls` DISABLE KEYS */;
|
|
|
437 |
/*!40000 ALTER TABLE `user_urls` ENABLE KEYS */;
|
|
|
438 |
UNLOCK TABLES;
|
|
|
439 |
|
|
|
440 |
--
|
|
|
441 |
-- Table structure for table `users`
|
|
|
442 |
--
|
|
|
443 |
|
|
|
444 |
DROP TABLE IF EXISTS `users`;
|
|
|
445 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
446 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
447 |
CREATE TABLE `users` (
|
|
|
448 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
449 |
`username` varchar(128) NOT NULL,
|
|
|
450 |
`email` varchar(128) NOT NULL,
|
|
|
451 |
`password` varchar(64) NOT NULL,
|
|
|
452 |
`first_name` varchar(64) NOT NULL,
|
|
|
453 |
`last_name` varchar(64) NOT NULL,
|
|
|
454 |
`mobile_number` varchar(15) NOT NULL,
|
|
|
455 |
`referral_url` varchar(256) NOT NULL,
|
|
|
456 |
`password_reset` varchar(64) DEFAULT NULL,
|
|
|
457 |
`activation_code` varchar(40) DEFAULT NULL,
|
|
|
458 |
`group_id` int(10) unsigned NOT NULL DEFAULT '1',
|
|
|
459 |
`status` tinyint(1) NOT NULL DEFAULT '1',
|
|
|
460 |
`created` datetime NOT NULL,
|
|
|
461 |
`modified` datetime NOT NULL,
|
|
|
462 |
PRIMARY KEY (`id`)
|
|
|
463 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
|
|
|
464 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
465 |
|
|
|
466 |
--
|
|
|
467 |
-- Dumping data for table `users`
|
|
|
468 |
--
|
|
|
469 |
|
|
|
470 |
LOCK TABLES `users` WRITE;
|
|
|
471 |
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
|
|
472 |
INSERT INTO `users` VALUES (1,'anikendra@gmail.com','anikendra@gmail.com','32b4781a9904f3241f770729663b5837972eeb6f','','','','http://bit.ly/1ArUXfP',NULL,'6714f8ffdaebcac085f83fc2af592b8266b12374',2,1,'2015-01-08 12:16:32','2015-01-08 12:16:32');
|
|
|
473 |
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
|
|
|
474 |
UNLOCK TABLES;
|
|
|
475 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
476 |
|
|
|
477 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
478 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
479 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
480 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
481 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
482 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
|
483 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
484 |
|
|
|
485 |
-- Dump completed on 2015-01-08 16:33:18
|