Rev 13544 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (i686)---- Host: localhost Database: dtr-- -------------------------------------------------------- Server version 5.5.40-0ubuntu0.12.04.1/*!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 */;---- Table structure for table `categories`--DROP TABLE IF EXISTS `categories`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `categories` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`parent_id` int(10) DEFAULT NULL,`lft` int(10) DEFAULT NULL,`rght` int(10) DEFAULT NULL,`name` varchar(255) DEFAULT '',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `categories`--LOCK TABLES `categories` WRITE;/*!40000 ALTER TABLE `categories` DISABLE KEYS */;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');/*!40000 ALTER TABLE `categories` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `clicks`--DROP TABLE IF EXISTS `clicks`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `clicks` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`store_product_id` int(10) unsigned NOT NULL,`tag` varchar(16) NOT NULL,`created` datetime NOT NULL,PRIMARY KEY (`id`),KEY `id_user_click` (`user_id`,`store_product_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `clicks`--LOCK TABLES `clicks` WRITE;/*!40000 ALTER TABLE `clicks` DISABLE KEYS */;/*!40000 ALTER TABLE `clicks` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `gmail_messages`--DROP TABLE IF EXISTS `gmail_messages`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `gmail_messages` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`email` varchar(128) NOT NULL,`threadid` int(11) NOT NULL,`messageid` int(11) NOT NULL,`subject` varchar(512) NOT NULL,`body` text NOT NULL,`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `gmail_messages`--LOCK TABLES `gmail_messages` WRITE;/*!40000 ALTER TABLE `gmail_messages` DISABLE KEYS */;/*!40000 ALTER TABLE `gmail_messages` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `groups`--DROP TABLE IF EXISTS `groups`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `groups` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(100) NOT NULL,`created` datetime DEFAULT NULL,`modified` datetime DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `groups`--LOCK TABLES `groups` WRITE;/*!40000 ALTER TABLE `groups` DISABLE KEYS */;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');/*!40000 ALTER TABLE `groups` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `orders`--DROP TABLE IF EXISTS `orders`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `orders` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`store_id` int(10) unsigned NOT NULL,`store_order_id` varchar(32) NOT NULL,`order_url` varchar(256) NOT NULL,`rawhtml` longtext NOT NULL,`product_name` varchar(256) NOT NULL,`product_code` varchar(128) DEFAULT NULL,`unit_price` float(6,2) DEFAULT NULL,`total_amount` float(6,2) DEFAULT NULL,`customer_name` varchar(256) NOT NULL,`customer_email` varchar(256) NOT NULL,`customer_mobile` varchar(15) NOT NULL,`customer_address` varchar(512) NOT NULL,`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `orders`--LOCK TABLES `orders` WRITE;/*!40000 ALTER TABLE `orders` DISABLE KEYS */;/*!40000 ALTER TABLE `orders` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `preferences`--DROP TABLE IF EXISTS `preferences`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `preferences` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`key` varchar(32) NOT NULL,`value` varchar(128) NOT NULL,`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `preferences`--LOCK TABLES `preferences` WRITE;/*!40000 ALTER TABLE `preferences` DISABLE KEYS */;/*!40000 ALTER TABLE `preferences` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `products`--DROP TABLE IF EXISTS `products`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `products` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(256) NOT NULL,`category_id` int(10) unsigned NOT NULL,`tag_line` varchar(128) DEFAULT NULL,`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `products`--LOCK TABLES `products` WRITE;/*!40000 ALTER TABLE `products` DISABLE KEYS */;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');/*!40000 ALTER TABLE `products` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `productviews`--DROP TABLE IF EXISTS `productviews`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `productviews` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`product_id` int(10) unsigned NOT NULL,`user_id` int(10) unsigned NOT NULL,`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `productviews`--LOCK TABLES `productviews` WRITE;/*!40000 ALTER TABLE `productviews` DISABLE KEYS */;/*!40000 ALTER TABLE `productviews` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `social_profiles`--DROP TABLE IF EXISTS `social_profiles`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `social_profiles` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`type` enum('google','facebook') NOT NULL DEFAULT 'google',`social_id` varchar(64) NOT NULL,`access_token` varchar(128) NOT NULL,`refresh_token` varchar(128) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `social_profiles`--LOCK TABLES `social_profiles` WRITE;/*!40000 ALTER TABLE `social_profiles` DISABLE KEYS */;/*!40000 ALTER TABLE `social_profiles` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `store_products`--DROP TABLE IF EXISTS `store_products`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `store_products` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`store_id` int(10) unsigned NOT NULL,`product_id` int(10) unsigned NOT NULL,`product_url` varchar(256) NOT NULL,`img_url` varchar(256) NOT NULL,`short_descrption` varchar(256) NOT NULL,`price` float(6,2) NOT NULL,`status` enum('active','paused','deleted') NOT NULL DEFAULT 'active',`last_crawled` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `store_products`--LOCK TABLES `store_products` WRITE;/*!40000 ALTER TABLE `store_products` DISABLE KEYS */;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');/*!40000 ALTER TABLE `store_products` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `stores`--DROP TABLE IF EXISTS `stores`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `stores` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(32) NOT NULL,`status` enum('active','paused','deleted') NOT NULL DEFAULT 'paused',`affiliate_id` varchar(32) NOT NULL,`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `stores`--LOCK TABLES `stores` WRITE;/*!40000 ALTER TABLE `stores` DISABLE KEYS */;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');/*!40000 ALTER TABLE `stores` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `user_accounts`--DROP TABLE IF EXISTS `user_accounts`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `user_accounts` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`account_type` enum('saholic','gcm_regid') NOT NULL DEFAULT 'saholic',`account_key` varchar(128) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `unique_key` (`user_id`,`account_type`,`account_key`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `user_accounts`--LOCK TABLES `user_accounts` WRITE;/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `user_actions`--DROP TABLE IF EXISTS `user_actions`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `user_actions` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`store_product_id` int(10) unsigned NOT NULL,`action` enum('like','dislike') DEFAULT NULL,`created` datetime NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `uk_unique_action` (`user_id`,`store_product_id`,`action`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `user_actions`--LOCK TABLES `user_actions` WRITE;/*!40000 ALTER TABLE `user_actions` DISABLE KEYS */;/*!40000 ALTER TABLE `user_actions` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `user_sms`--DROP TABLE IF EXISTS `user_sms`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `user_sms` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`message` varchar(160) NOT NULL,`status` enum('new','processed','deleted') NOT NULL DEFAULT 'new',`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `user_sms`--LOCK TABLES `user_sms` WRITE;/*!40000 ALTER TABLE `user_sms` DISABLE KEYS */;/*!40000 ALTER TABLE `user_sms` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `user_urls`--DROP TABLE IF EXISTS `user_urls`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `user_urls` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`user_id` int(10) unsigned NOT NULL,`url` varchar(256) NOT NULL,`created` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `user_urls`--LOCK TABLES `user_urls` WRITE;/*!40000 ALTER TABLE `user_urls` DISABLE KEYS */;/*!40000 ALTER TABLE `user_urls` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `users`--DROP TABLE IF EXISTS `users`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `users` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`username` varchar(128) NOT NULL,`email` varchar(128) NOT NULL,`password` varchar(64) NOT NULL,`first_name` varchar(64) NOT NULL,`last_name` varchar(64) NOT NULL,`mobile_number` varchar(15) NOT NULL,`referral_url` varchar(256) NOT NULL,`password_reset` varchar(64) DEFAULT NULL,`activation_code` varchar(40) DEFAULT NULL,`group_id` int(10) unsigned NOT NULL DEFAULT '1',`status` tinyint(1) NOT NULL DEFAULT '1',`created` datetime NOT NULL,`modified` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `users`--LOCK TABLES `users` WRITE;/*!40000 ALTER TABLE `users` DISABLE KEYS */;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');/*!40000 ALTER TABLE `users` 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 2015-01-08 16:33:18