· 5 years ago · Nov 13, 2020, 12:48 AM
1-- MySQL dump 10.13 Distrib 5.6.49, for Linux (x86_64)
2--
3-- Host: localhost Database: soapandbasil_database
4--
5-- Leaked By Mr.MF33
6-- Buitenzorg Syndicate || Dark 3xploit Cyber || Clan X_12
7-- Date Leaked : 13 November 2020
8--
9
10-- ------------------------------------------------------
11-- Server version 5.6.49-cll-lve
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
18/*!40103 SET TIME_ZONE='+00:00' */;
19/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
20/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
21/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
22/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
23
24--
25-- Current Database: `soapandbasil_database`
26--
27
28CREATE DATABASE /*!32312 IF NOT EXISTS*/ `soapandbasil_database` /*!40100 DEFAULT CHARACTER SET latin1 */;
29
30USE `soapandbasil_database`;
31
32--
33-- Table structure for table `login_cart`
34--
35
36DROP TABLE IF EXISTS `login_cart`;
37/*!40101 SET @saved_cs_client = @@character_set_client */;
38/*!40101 SET character_set_client = utf8 */;
39CREATE TABLE `login_cart` (
40 `lg_id` int(11) NOT NULL AUTO_INCREMENT,
41 `lg_user_id` int(11) NOT NULL,
42 `lg_product_id` int(11) NOT NULL,
43 `lg_qty` int(11) NOT NULL,
44 `lg_size_name` varchar(110) DEFAULT NULL,
45 PRIMARY KEY (`lg_id`)
46) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=latin1;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Dumping data for table `login_cart`
51--
52
53LOCK TABLES `login_cart` WRITE;
54/*!40000 ALTER TABLE `login_cart` DISABLE KEYS */;
55INSERT INTO `login_cart` VALUES (6,28,7,3,'large'),(8,23,14,1,'small'),(10,38,41,1,'Medium'),(12,57,17,1,'Medium'),(13,60,32,1,'Medium'),(14,56,58,2,'Xs'),(15,28,58,1,'Xs'),(16,61,21,1,'Xs'),(17,61,58,1,'Xs'),(18,62,47,1,'Large'),(19,62,37,1,'Large'),(20,63,59,1,'Small'),(21,63,43,1,'Medium'),(22,63,21,1,'Medium'),(23,64,21,1,'Medium'),(24,68,23,1,'Small'),(25,71,21,1,'Xs'),(26,72,48,2,'Small'),(27,73,34,1,'Medium'),(31,84,27,1,'Small'),(32,85,21,1,'Small'),(35,89,25,1,'Small'),(37,91,25,1,'Small'),(42,93,25,1,'Small'),(43,93,38,1,'Small'),(45,94,25,1,'Xs'),(46,94,26,1,'Free'),(49,96,23,1,'Medium'),(50,96,41,1,'Medium'),(51,100,23,1,'Medium'),(53,102,25,1,'Xl'),(54,102,18,1,'Xl'),(55,102,28,1,'Xl'),(59,104,20,1,'Xl'),(60,104,42,1,'Xl'),(61,104,26,1,'Free'),(62,104,23,1,'Xl'),(63,104,44,1,'Xl'),(77,110,59,1,'Xl'),(78,110,25,1,'Xl'),(79,111,34,1,'Medium'),(81,111,25,1,'Small'),(82,111,15,1,'Medium'),(83,111,23,1,'Medium'),(87,114,56,1,'Medium'),(89,117,21,1,'Xs'),(95,90,17,1,'S/M'),(96,127,44,1,'Large'),(97,127,59,1,'Large'),(99,41,21,1,'Medium'),(100,129,26,1,'Free'),(101,131,25,1,'S/M'),(102,30,59,1,'Small'),(103,135,39,1,'Small'),(104,139,25,1,'S/M'),(105,143,48,1,'S');
56/*!40000 ALTER TABLE `login_cart` ENABLE KEYS */;
57UNLOCK TABLES;
58
59--
60-- Table structure for table `multi_order_data`
61--
62
63DROP TABLE IF EXISTS `multi_order_data`;
64/*!40101 SET @saved_cs_client = @@character_set_client */;
65/*!40101 SET character_set_client = utf8 */;
66CREATE TABLE `multi_order_data` (
67 `multi_id` int(11) NOT NULL AUTO_INCREMENT,
68 `multi_user_id` int(11) NOT NULL,
69 `multi_order_id` int(11) DEFAULT NULL,
70 `multi_p_id` int(11) DEFAULT NULL,
71 `multi_p_qty` int(11) DEFAULT NULL,
72 `multi_p_size` varchar(100) DEFAULT NULL,
73 `multi_p_old_price` decimal(15,2) DEFAULT NULL,
74 `multi_p_discount` decimal(15,2) DEFAULT NULL,
75 `multi_p_gst` decimal(15,2) DEFAULT NULL,
76 `multi_p_finalamount` decimal(15,2) DEFAULT NULL,
77 `multi_p_currency` varchar(10) DEFAULT NULL,
78 PRIMARY KEY (`multi_id`)
79) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;
80/*!40101 SET character_set_client = @saved_cs_client */;
81
82--
83-- Dumping data for table `multi_order_data`
84--
85
86LOCK TABLES `multi_order_data` WRITE;
87/*!40000 ALTER TABLE `multi_order_data` DISABLE KEYS */;
88INSERT INTO `multi_order_data` VALUES (1,21,1,7,2,'medium',3999.00,25.00,3.00,6178.00,NULL),(2,21,1,12,3,'small',2500.00,5.00,2.00,7268.00,NULL),(3,23,2,7,6,'xxxl',3999.00,25.00,3.00,18534.00,NULL),(4,23,2,12,3,'small',2500.00,5.00,2.00,7268.00,NULL),(5,23,3,9,2,'large',699.00,25.00,2.00,1069.00,NULL),(6,23,3,7,3,'small',3999.00,25.00,3.00,9267.00,NULL),(7,26,4,9,1,'xxxl',699.00,25.00,2.00,534.00,NULL),(8,27,5,9,1,'medium',699.00,25.00,2.00,534.00,NULL),(9,23,6,8,3,'small',33.68,10.00,2.00,92.75,'USD'),(10,23,6,13,2,'small',7.00,40.00,4.00,101.49,'USD'),(11,23,7,8,4,'medium',33.68,10.00,2.00,123.66,'USD'),(12,28,8,13,5,'medium',7.00,40.00,4.00,21.84,'USD'),(13,28,8,12,3,'xxxl',33.65,5.00,2.00,119.67,'USD'),(14,21,9,9,3,'medium',9.42,25.00,2.00,21.63,'USD'),(15,23,10,14,1,'small',1890.00,15.00,4.00,1670.76,'INR'),(16,23,11,14,1,'small',1890.00,15.00,4.00,1670.76,'INR'),(17,38,12,41,1,'Medium',1890.00,15.00,12.00,1799.28,'INR'),(18,56,13,27,1,'Xs',2415.00,15.00,12.00,2299.08,'INR'),(19,57,14,17,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(20,57,15,17,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(21,28,16,58,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(22,64,17,21,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(23,64,18,21,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(24,69,19,21,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(25,69,20,21,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(26,73,21,34,1,'Medium',3270.00,15.00,12.00,3113.04,'INR'),(27,39,22,29,1,'Large',2700.00,15.00,12.00,2570.40,'INR'),(28,75,23,18,1,'Large',2700.00,15.00,12.00,2570.40,'INR'),(29,77,24,24,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(30,77,24,40,1,'Medium',3450.00,15.00,12.00,4874.24,'INR'),(31,83,25,21,1,'Medium',1670.00,15.00,12.00,1589.84,'INR'),(32,85,26,21,1,'Small',1670.00,15.00,12.00,1589.84,'INR'),(33,21,27,58,1,'Small',1890.00,15.00,12.00,1799.28,'INR'),(34,21,27,54,5,'Xs',2475.00,15.00,12.00,13580.28,'INR'),(35,21,28,58,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(36,88,27,25,1,'Small',2820.00,15.00,12.00,2684.64,'INR'),(37,30,28,25,1,'Xs',2820.00,15.00,12.00,2684.64,'INR'),(38,30,29,38,1,'Xs',2700.00,15.00,12.00,2570.40,'INR'),(39,94,30,26,1,'Free',1890.00,15.00,12.00,1799.28,'INR'),(40,94,30,25,1,'Xs',2820.00,15.00,12.00,4483.92,'INR'),(41,97,31,25,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(42,95,32,22,1,'Xs',2700.00,15.00,12.00,2570.40,'INR'),(43,102,33,28,1,'Xl',2820.00,15.00,12.00,2684.64,'INR'),(44,102,33,18,1,'Xl',2700.00,15.00,12.00,5255.04,'INR'),(45,102,33,25,1,'Xl',2820.00,15.00,12.00,7939.68,'INR'),(46,102,34,28,1,'Xl',2820.00,15.00,12.00,2684.64,'INR'),(47,102,34,18,1,'Xl',2700.00,15.00,12.00,5255.04,'INR'),(48,102,34,25,1,'Xl',2820.00,15.00,12.00,7939.68,'INR'),(49,21,35,58,1,'Xs',19.85,15.00,12.00,18.89,'GBP'),(50,103,36,25,1,'Large',2820.00,15.00,12.00,2684.64,'INR'),(51,21,37,48,1,'Small',25.76,15.00,12.00,24.53,'USD'),(52,30,37,52,1,'Xs',2475.00,15.00,12.00,2356.20,'INR'),(53,30,37,42,1,'Xxl',1890.00,15.00,12.00,4155.48,'INR'),(54,30,37,56,1,'Xs',2700.00,15.00,12.00,6725.88,'INR'),(55,30,37,15,1,'Xs',1670.00,15.00,12.00,8315.72,'INR'),(56,30,37,17,1,'S/M',2820.00,15.00,12.00,11000.36,'INR'),(57,108,38,25,1,'Xs',2820.00,15.00,12.00,2684.64,'INR'),(58,109,39,25,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(59,109,40,25,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(60,112,41,26,1,'Free',1890.00,15.00,12.00,1799.28,'INR'),(61,112,42,26,1,'Free',1890.00,15.00,12.00,1799.28,'INR'),(62,113,43,44,1,'Large',2515.00,15.00,12.00,2394.28,'INR'),(63,113,43,26,1,'Free',1890.00,15.00,12.00,4193.56,'INR'),(64,101,44,23,1,'Medium',2700.00,15.00,12.00,2570.40,'INR'),(65,101,45,23,1,'Medium',2700.00,15.00,12.00,2570.40,'INR'),(66,101,46,23,1,'Medium',2700.00,15.00,12.00,2570.40,'INR'),(67,118,47,21,1,'Xs',1670.00,15.00,12.00,1589.84,'INR'),(68,118,48,21,1,'Xs',1670.00,15.00,12.00,1589.84,'INR'),(69,118,49,21,1,'Xs',1670.00,15.00,12.00,1589.84,'INR'),(70,119,50,27,1,'Small',2415.00,15.00,12.00,2299.08,'INR'),(71,120,51,25,1,'Small',2820.00,15.00,12.00,2684.64,'INR'),(72,121,52,25,1,'Medium',2820.00,15.00,12.00,2684.64,'INR'),(73,122,53,24,1,'Xs',1670.00,15.00,12.00,1589.84,'INR'),(74,122,53,25,1,'Xs',2820.00,15.00,12.00,4274.48,'INR'),(75,123,54,31,1,'Small',2415.00,15.00,12.00,2299.08,'INR'),(76,124,55,25,1,'Xs',2820.00,15.00,12.00,2684.64,'INR'),(77,125,56,25,1,'Small',2820.00,15.00,12.00,2684.64,'INR'),(78,132,57,25,1,'S/M',2820.00,15.00,12.00,2684.64,'INR'),(79,30,58,17,1,'S/M',2820.00,15.00,12.00,2684.64,'INR'),(80,30,58,15,1,'Xs',1670.00,15.00,12.00,4274.48,'INR'),(81,87,59,25,1,'Small',2820.00,15.00,12.00,2684.64,'INR'),(82,134,60,23,1,'Xs',2700.00,15.00,12.00,2570.40,'INR'),(83,134,60,25,1,'S/M',2820.00,15.00,12.00,5255.04,'INR'),(84,21,61,35,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(85,21,61,58,1,'Small',1890.00,15.00,12.00,3598.56,'INR'),(86,21,61,59,1,'Medium',2700.00,15.00,12.00,6168.96,'INR'),(87,21,61,42,1,'Medium',1890.00,15.00,12.00,7968.24,'INR'),(88,21,62,48,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(89,21,63,48,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(90,21,64,48,1,'Xs',1890.00,15.00,12.00,1799.28,'INR'),(91,137,65,38,1,'Medium',2700.00,15.00,12.00,2570.40,'INR'),(92,31,66,36,1,'xl',2700.00,15.00,12.00,2570.40,'INR'),(93,21,67,25,2,'S/M',2800.00,12.50,12.00,5488.00,'INR'),(94,81,68,21,1,'Small',1850.00,20.00,12.00,1657.60,'INR'),(95,81,68,18,1,'Small',2700.00,15.00,12.00,4228.00,'INR'),(96,81,69,21,1,'Small',1850.00,20.00,12.00,1657.60,'INR'),(97,81,69,18,1,'Small',2700.00,15.00,12.00,4228.00,'INR');
89/*!40000 ALTER TABLE `multi_order_data` ENABLE KEYS */;
90UNLOCK TABLES;
91
92--
93-- Table structure for table `order_checkout`
94--
95
96DROP TABLE IF EXISTS `order_checkout`;
97/*!40101 SET @saved_cs_client = @@character_set_client */;
98/*!40101 SET character_set_client = utf8 */;
99CREATE TABLE `order_checkout` (
100 `order_id` int(11) NOT NULL AUTO_INCREMENT,
101 `order_user_id` int(11) NOT NULL,
102 `order_name` varchar(200) NOT NULL,
103 `order_company` varchar(200) DEFAULT NULL,
104 `order_streetaddress` text,
105 `order_appartment` text,
106 `order_city` varchar(200) DEFAULT NULL,
107 `order_state` varchar(200) DEFAULT NULL,
108 `order_pincode` int(11) DEFAULT NULL,
109 `order_mobile` varchar(200) NOT NULL,
110 `order_email` varchar(200) NOT NULL,
111 `order_message` text,
112 `order_amount` decimal(15,2) NOT NULL,
113 `order_gst_amount` decimal(15,2) NOT NULL,
114 `order_final_amount` decimal(15,2) NOT NULL,
115 `order_status` int(2) DEFAULT '1',
116 `order_type` int(4) DEFAULT NULL,
117 `payment_order_id` varchar(240) DEFAULT NULL,
118 `payment_order_amount_res` decimal(15,2) DEFAULT NULL,
119 `payment_amount` decimal(15,2) DEFAULT NULL,
120 `payment_payment_id` varchar(240) DEFAULT NULL,
121 `payment_json` text,
122 `payment_status` varchar(240) DEFAULT NULL,
123 `payment_method` varchar(200) DEFAULT NULL,
124 `payment_bank` varchar(200) DEFAULT NULL,
125 `payment_card` varchar(200) DEFAULT NULL,
126 `payment_transaction` varchar(200) DEFAULT NULL,
127 `payment_wallet` varchar(200) DEFAULT NULL,
128 `order_currency` varchar(10) DEFAULT NULL,
129 `order_creation_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
130 `order_last_update` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
131 `order_coupon_code` varchar(240) DEFAULT NULL,
132 `order_per` decimal(15,2) DEFAULT NULL,
133 `order_coupon_status` smallint(3) DEFAULT '1',
134 `order_dis_amount` decimal(15,2) DEFAULT NULL,
135 PRIMARY KEY (`order_id`)
136) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Dumping data for table `order_checkout`
141--
142
143LOCK TABLES `order_checkout` WRITE;
144/*!40000 ALTER TABLE `order_checkout` DISABLE KEYS */;
145INSERT INTO `order_checkout` VALUES (12,38,'Test','Test','Test','Test','Test','Rajasthan',252536,'9898888877','Hsjsjj@hdhx.co','',1606.50,192.78,1799.28,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-08-30 10:14:35','2020-09-02 14:13:07',NULL,NULL,1,NULL),(13,56,'Archana','','Flat no.-0002, Tower 9, Emaar Palm Terrace Select','Sector - 66','Gurugram','Haryana',122018,'9953681942','p14archana@iimidr.ac.in','',2052.75,246.33,2299.08,8,2,'order_FXjWS4sJ0azy3E',229908.00,2299.08,'pay_FXjXCYgQNsEPXL','{}','paid','card',NULL,'card_FXjXCfRWdCQdoJ','',NULL,'INR','2020-09-01 10:30:37','2020-10-23 12:52:01',NULL,NULL,1,NULL),(14,57,'Annie','','H number 36, 2C, E block, palam vihar, vyapar kendra','Unit','Gurugram','Haryana',122017,'9803343455','esserevoii@gmail.com','',2397.00,287.64,2684.64,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-01 16:31:04','2020-09-01 16:31:04',NULL,NULL,1,NULL),(15,57,'Annie','','H number 36, 2C, E block, palam vihar vyapar kendra','Unit','Gurugram','Haryana',122017,'9803343455','asanniesharma.099@gmail.com','',2397.00,287.64,2684.64,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-01 16:32:15','2020-09-01 16:32:15',NULL,NULL,1,NULL),(16,28,'Manish','dfsdsf','phulera jaipur (raj.)','dfsdf','Jaipur','Rajasthan',303338,'+911234567895','mk@gmail.com','test',1606.50,192.78,1799.28,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-04 14:24:28','2020-09-04 14:24:28',NULL,NULL,1,NULL),(17,64,'Gargi','Icertis ','683,jk apartment,sector 11,first floor','Jk apartment','Udaipur','Rajasthan',313001,'9146938275','gargis37@gmail.com','',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-06 03:41:13','2020-09-06 03:41:13',NULL,NULL,1,NULL),(18,64,'Gargi','Icertis ','683,jk apartment,sector 11,first floor','Jk apartment','Udaipur','Rajasthan',313001,'9146938275','gargis37@gmail.com','',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-06 03:43:17','2020-09-06 03:43:17',NULL,NULL,1,NULL),(19,69,'Saniyya Mecca','','No. 14, L. Jey Avenue, Akkarai ','No. 14','Chennai','Tamil Nadu',600119,'9840450002','saniyya@yahoo.com','Turn left from Sunrise Avenue',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-09 16:16:27','2020-09-09 16:16:27',NULL,NULL,1,NULL),(20,69,'Saniyya Mecca','','No. 14, L. Jey Avenue','Akkarai, ECR','Chennai ','Tamil Nadu',600119,'9840450002','saniyya@yahoo.com','Turn left from Sunrise Avenue',1419.50,170.34,1589.84,8,2,'order_FasZgrZqLA5wlT',158984.00,1589.84,'pay_Fasjtidp1JYnPX','{}','paid','card',NULL,'card_FasjtpG76MJJDn','',NULL,'INR','2020-09-09 16:18:54','2020-10-23 12:52:39',NULL,NULL,1,NULL),(21,73,'Bonsy Mehta','','D3703/4/5/6, Ashok Towers,','Dr. Babasaheb Ambedkar Rd., Parel,','Mumbai','Maharashtra',400012,'+919820583542','mehtabonsy@gmail.com','',2779.50,333.54,3113.04,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-09-14 22:37:05','2020-09-14 22:37:05',NULL,NULL,1,NULL),(22,39,'Nidhi Agarwal','','T 985, B 22, Ashiana Vrinda Gardens, Jagatpura','near JNU, near new RTO,','Jaipur','Rajasthan',302017,'08800937057','nidag7@gmail.com','',2295.00,275.40,2570.40,8,2,'order_Fd9ipRYdt54s4v',257040.00,2570.40,'pay_Fd9jXlIhp8qzxj','{}','paid','upi',NULL,NULL,'',NULL,'INR','2020-09-15 10:23:22','2020-10-23 12:52:55',NULL,NULL,1,NULL),(23,75,'SHAMAL WARLIKAR','','805-MARATHON MONTE VISTA BLDG, ','MADAN MOHAN MALVIYA RD, NEAR MTNL COLONY, MULUND WEST','MUMBAI','Maharashtra',400080,'09920754437','shamal.warlikar12@gmail.com','',2295.00,275.40,2570.40,2,2,'order_FeOHWLMBrY2Vu1',257040.00,2570.40,'pay_FeOKehzu8i7thX','{}','paid','card',NULL,'card_FeOKenHsZBV5WH','',NULL,'INR','2020-09-18 13:16:55','2020-09-18 13:20:34',NULL,NULL,1,NULL),(24,77,'Swati Mishra','','C-106, Purva Westend Service Road','Kudlu Gate, Garebhavipalya','Bengaluru','Karnataka',560068,'+919818537770','ravipojha@yahoo.com','Please ensure delivery by 25 September 2020',4352.00,522.24,4874.24,2,2,'order_FfGF3lsUF38QnV',487424.00,4874.24,'pay_FfGHH7hQEhWmoK','{}','paid','card',NULL,'card_FfGHHDoWfUbVV5','',NULL,'INR','2020-09-20 18:04:03','2020-09-20 18:06:48',NULL,NULL,1,NULL),(25,83,'diksha agrawal','','3-B,rustam bagh view apartment','rustam bagh layout ','bangalore ','Karnataka',560017,'9886269461','agrawal.diksha@gmail.com','',1419.50,170.34,1589.84,2,2,'order_FkVu1oK7TKnQi7',158984.00,1589.84,'pay_FkVw6p7gY0ds5A','{}','paid','upi',NULL,NULL,'',NULL,'INR','2020-10-04 00:38:15','2020-10-04 00:40:42',NULL,NULL,1,NULL),(26,85,'Renu ','','Shinde niwas 2nd floor maratha kolsewadi','Near st judes chruch','Kalyan east','Maharashtra',421306,'9975599172','renubmeena@gmail.com','',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-07 19:44:42','2020-10-07 19:44:42',NULL,NULL,1,NULL),(27,88,'Sneha sabnani','','1001 E Block , Iscon Platiniun , Bopal Char Rasta','Bopal','Ahmedabad','Gujarat',380058,'7211199991','tarunsabnani@gmail.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-14 17:14:51','2020-10-14 17:14:51',NULL,NULL,1,NULL),(28,30,'Priya','','C 201','Mahesh nagar','Jaipur','Rajasthan',302015,'+918696339489','Pm32690@gmail.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-14 18:18:55','2020-10-14 18:18:55',NULL,NULL,1,NULL),(29,30,'Priya','','C 201','Mahesh nagar','Jaipur','Rajasthan',302015,'+918696339489','Pm32690@gmail.com','',2295.00,275.40,2570.40,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-14 18:21:23','2020-10-14 18:21:23',NULL,NULL,1,NULL),(30,94,'jenifer karai','','Dinshaw Master Road Parsee Colony Dadar ','695, 1st floor flat no-06,','Mumbai','Maharashtra',400014,'09833177985','jenifer.karai@hotmail.com','',4003.50,480.42,4483.92,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-15 01:00:03','2020-10-15 01:00:03',NULL,NULL,1,NULL),(31,97,'Paulomi','','14 saket bunglows besides takshashila flats ','Near mansi tower vastrapur ','Ahmedabad ','Gujarat',380015,'9099951374','Paulomirajdev@yahoo.com ','Call on 9099951374 and then deliver ',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-15 16:04:36','2020-10-15 16:04:36',NULL,NULL,1,NULL),(32,95,'Radhika','','102, Landmark building, carmichael road','10th floor','Mumbai','Maharashtra',400026,'09821471247','radhikadoshi@gmail.com','',2295.00,275.40,2570.40,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-16 13:01:04','2020-10-16 13:01:04',NULL,NULL,1,NULL),(33,102,'SHILPIKA','','1503, the Capital, BKC','Opp ICICI Bank','Mumbai','Maharashtra',400051,'7506727119','shilpikadas@gmail.com','Shipping address is different ',7089.00,850.68,7939.68,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-19 10:48:06','2020-10-19 10:48:06',NULL,NULL,1,NULL),(34,102,'SHILPIKA','','302, Tower 5, Crescent Bay','Bhoiwada, Parel','Mumbai','Maharashtra',400012,'7506727119','shilpikadas@gmail.com','',7089.00,850.68,7939.68,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-19 10:50:32','2020-10-19 10:50:32',NULL,NULL,1,NULL),(35,21,'Manish','testing developer','jaipur bani park','jaipur park','jaipur','Rajasthan',353235,'1231231232','mkjajoriya745@gmail.com','',16.87,2.02,18.89,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'GBP','2020-10-19 15:05:48','2020-10-29 23:40:00',NULL,NULL,2,NULL),(36,103,'Pallavi Punamiya','','1302/1402,Imperial Residency,Gulmohar Cross Road No 12 , Juhu','1302','Mumbai','Andaman and Nicobar Islands',400049,'9820445407','pallavipunamiya2014@gmail.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-19 15:06:18','2020-10-19 15:06:18',NULL,NULL,1,NULL),(37,30,'Priya','','C 201','Mahesh nagar','Jaipur','Rajasthan',302015,'+918696339489','Pm32690@gmail.com','',9821.75,1178.61,11000.36,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-20 19:47:29','2020-10-20 19:47:29',NULL,NULL,1,NULL),(38,108,'Jinal nagda','','A/401, riddhi apt., 10A, jawahar nagar, sv road, goregaon west, ','A wing 401, riidhi apartment','Mumbai','Maharashtra',400062,'9920607333','jinal_gala@yahoo.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-20 21:40:23','2020-10-20 21:40:23',NULL,NULL,1,NULL),(39,109,'Rajashree Lala','','#5, Kaveeta Apts, 34, Minoo Desai Road, Next to Fariyas hotel, Colaba ','5th floor','Mumbai ','Maharashtra',400005,'9821141944','rage713@gmail.com ','',2397.00,287.64,2684.64,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-20 21:51:14','2020-10-20 21:51:14',NULL,NULL,1,NULL),(40,109,'Rajashree Lala','','#5, Kaveeta Apts, 34, Minoo Desai Road, Next to Fariyas hotel, Colaba ','5th floor','Mumbai','Maharashtra',400005,'9821141944','rage713@gmail.com ','',2397.00,287.64,2684.64,2,2,'order_FrCA05vT8G0WdC',268464.00,2684.64,'pay_FrCABuqeWFIL3O','{}','paid','netbanking','HDFC',NULL,'202949809105',NULL,'INR','2020-10-20 21:52:30','2020-10-20 21:54:03',NULL,NULL,1,NULL),(41,112,'Risha Merchant','','Flat No 9, 2nd Floor, Heliopolis Building, Sagar Sangeet Compound, Azad Nagar, Colaba','Heliopolis ','Mumbai','Maharashtra',400005,'9819197001','risha.merchant@gmail.com','',1606.50,192.78,1799.28,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-20 23:51:50','2020-10-20 23:51:50',NULL,NULL,1,NULL),(42,112,'Risha Merchant','','Flat No 9, 2nd Floor, Heliopolis Building, Sagar Sangeet Compound, Azad Nagar, Colaba','Heliopolis','Mumbai','Maharashtra',400005,'9819197001','risha.merchant@gmail.com','',1606.50,192.78,1799.28,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-20 23:53:36','2020-10-20 23:53:36',NULL,NULL,1,NULL),(43,113,'Anisha Sawant','','B-6 Pranam, plot no 94, Model Town ','Andheri West ','Mumbai ','Maharashtra',400053,'9822448724','anisha.sawant18@gmail.com','',3744.25,449.31,4193.56,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 00:02:59','2020-10-21 00:02:59',NULL,NULL,1,NULL),(44,101,'Riti Taherbhoy','','164 Delmar Tower 1, Clover Village Wanorie ','Near Reliance Fresh on Salunki Vihar Road ','Pune','Maharashtra',411040,'09823621602','Ritibhatia@gmail.com','Pls make it according to 39 chest (body measurement) with lossing along with a thin lining. Thank you.',2295.00,275.40,2570.40,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 11:34:19','2020-10-21 11:34:19',NULL,NULL,1,NULL),(45,101,'Riti Taherbhoy','','164 Delmar Tower 1, Clover Village Wanorie ','Near Reliance Fresh on Salunki Vihar Road ','Pune','Maharashtra',411040,'09823621602','Ritibhatia@gmail.com','Pls make it according to 39 chest (body measurement) with lossing along with a thin lining. Thank you.',2295.00,275.40,2570.40,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 11:34:40','2020-10-21 11:34:40',NULL,NULL,1,NULL),(46,101,'Riti Taherbhoy','','164 Delmar Tower 1, Clover Village Wanorie','Near Reliance Fresh on Salunki Vihar Road','Pune','Maharashtra',411040,'09823621602','Ritibhatia@gmail.com','Body measurement of chest is 39. Pls add a thin lining to the dress. ',2295.00,275.40,2570.40,2,2,'order_FrQBrrvVrMJCc2',257040.00,2570.40,'pay_FrQCq6Fm6gOQnq','{}','paid','card',NULL,'card_FrQCqBcacEMhGc','',NULL,'INR','2020-10-21 11:35:59','2020-10-21 11:37:22',NULL,NULL,1,NULL),(47,118,'shilpi seth','','D-74 vijay nagar chetakpuri','D74','gwalior','Madhya Pradesh',474001,'8960668418','shilpi.seth08@gmail.com','',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 15:56:12','2020-10-21 15:56:12',NULL,NULL,1,NULL),(48,118,'shilpi seth','','vijay nagar (near chetakpuri)','D74','gwalior','Madhya Pradesh',474001,'8960668418','shilpi.seth08@gmail.com','',1419.50,170.34,1589.84,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 16:02:06','2020-10-21 16:02:06',NULL,NULL,1,NULL),(49,118,'shilpi seth','','vijay nagar (near chetakpuri)','D74','gwalior','Madhya Pradesh',474001,'8960668418','shilpi.seth08@gmail.com','',1419.50,170.34,1589.84,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 16:07:54','2020-10-21 16:07:54',NULL,NULL,1,NULL),(50,119,'Kanupriya kejriwal ','','102, jolly maker, apt. No. 3','Cuffe parade','Mumbai','Maharashtra',400005,'9820665131','kanupriyakejriwal1989@gmail.com','',2052.75,246.33,2299.08,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 20:10:42','2020-10-21 20:10:42',NULL,NULL,1,NULL),(51,120,'Niharika Trivedi','','805 8th Floor Lokhandwala Andheri West Mumbai 400053','Opposite Love and Latte','Mumbai','Maharashtra',400053,'9819742293','writetoniharika@gmail.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-21 23:06:24','2020-10-21 23:06:24',NULL,NULL,1,NULL),(52,121,'Dipti kalwani','','C 304 GOLDEN CHARIOT, NEAR ASHOKA ACADEMY','LOKHANDWALA, ANDHERI WEST','MUMBAI','Maharashtra',452003,'9819699344','kalwanidipti@gmail.com','',2397.00,287.64,2684.64,2,2,'order_Frdrlr3JgTty5n',268464.00,2684.64,'pay_FrdtBgKqqgte9o','{}','paid','card',NULL,'card_FrdtBrpSTuyljN','',NULL,'INR','2020-10-22 00:58:40','2020-10-22 01:00:29',NULL,NULL,1,NULL),(53,122,'Kadambari Kapoor','','25 Ballygunge park ','Rajnigandha 15th floor ','Kolkata ','West Bengal',700019,'9830076936','kadambari.kapoor@me.com','',3816.50,457.98,4274.48,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-22 03:42:41','2020-10-22 03:42:41',NULL,NULL,1,NULL),(54,123,'Fleur','','502, Hill Queen, Dr Ambedkar Road, above Union Bank','Khar west','Mumbai ','Maharashtra',400052,'9820030353','fleur_ann@hotmail.com','',2052.75,246.33,2299.08,2,2,'order_FrrUQzvaEeDCkV',229908.00,2299.08,'pay_FrrVJ6PuIUVSXS','{}','paid','card',NULL,'card_FrrVJCvFDa8EM2','',NULL,'INR','2020-10-22 14:18:17','2020-10-22 14:19:42',NULL,NULL,1,NULL),(55,124,'Flavia Swain','','Flat No.5, Cyrus House,','Junction of 24 & 30 Road, Above Eat Around the Corner Restaurant','Bandra West, Mumbai ','Maharashtra',400050,'9820302016','Flaviaswain@gmail.com','',2397.00,287.64,2684.64,2,2,'order_FrrualQogA0FA7',268464.00,2684.64,'pay_Frrv4TvvpgT9eS','{}','paid','netbanking','UTIB',NULL,'777842636',NULL,'INR','2020-10-22 14:43:03','2020-10-22 14:44:39',NULL,NULL,1,NULL),(56,125,'Divyanshu Jha','','Residence of DC','Residence of DC Chatra, Jharkhand','Chatra','Jharkhand',825401,'7979960074','shahimeghna9@gmail.com','',2397.00,287.64,2684.64,2,2,'order_FsDAjASw4a5V9u',268464.00,2684.64,'pay_FsDByliGY2ufIM','{}','paid','card',NULL,'card_FsDBz2aWgFePuq','',NULL,'INR','2020-10-23 11:30:53','2020-10-23 11:32:32',NULL,NULL,1,NULL),(57,132,'Rajlakshmi ','','B-45 udadhi tarng chs ','Juhu Tara Road next to j.w Marriott hotel','Mumbai ','Maharashtra',400049,'9999675529','rajlakshmisingh888@gmail.com','',2397.00,287.64,2684.64,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-25 12:30:47','2020-10-25 12:30:47',NULL,NULL,1,NULL),(58,30,'Priya','','C 201','Mahesh nagar','Jaipur','Rajasthan',302015,'08696339489','Pm32690@gmail.com','',3816.50,457.98,4274.48,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-26 12:55:28','2020-10-26 12:55:28',NULL,NULL,1,NULL),(59,87,'Nikita Sanyal','','202 Mayflower Plot No 31A Union Park, Khar West','Flat No 202','Mumbai','Maharashtra',400052,'09820182519','nikitasanyal@gmail.com','',2397.00,287.64,2684.64,2,2,'order_FttpQaP8qVQlmo',268464.00,2684.64,'pay_Fttpek5OaMj5wc','{}','paid','card',NULL,'card_FttpepoKfh9fZe','',NULL,'INR','2020-10-27 17:53:33','2020-10-27 17:54:10',NULL,NULL,1,NULL),(60,134,'Riddhi doshi ','','21 ashutosh 38A nepeansea road','Opp. Matruashish','Mumbai','Maharashtra',400006,'9820201238','ridsdoshi@gmail.com','Confused about the Xs and s in the dress\r\nPlease send both so I can try please',4692.00,563.04,5255.04,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-27 20:28:21','2020-10-27 20:28:21',NULL,NULL,1,NULL),(63,21,'Manish','testing','tesing payemtn lnk','testing payment link','jaipur','Rajasthan',342343,'1231231232','mkjajoriya745@gmail.com','',1606.50,192.78,1799.28,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-10-29 23:39:59','2020-10-29 16:50:20','ABC123',20.00,2,359.85),(65,137,'Manjari Shah','','Altamount road ','11 Chitrakoot ','Mumbai','Maharashtra',400026,'9820700873','Sampatmanjari@gmail.com','Please deliver by nov 10',2295.00,275.40,2570.40,2,2,'order_FvoKlVobOheNua',257040.00,2570.40,'pay_FvoLk2dDNsbUbq','{}','paid','card',NULL,'card_FvoLkCI4QdZTmD','',NULL,'INR','2020-11-01 13:49:03','2020-11-01 13:51:45',NULL,NULL,1,NULL),(66,31,'Shreya Ajesh','','403, D-136, Govindam Appartments','Savitri Path, Bapu Nagar','Jaipur','Rajasthan',302015,'09636030322','shreya.ajesh@gmail.com','',2295.00,275.40,2570.40,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-11-03 11:51:26','2020-11-03 11:51:26',NULL,NULL,1,NULL),(67,21,'Developer Manish','Developer Company','House, plot no. O, G-2, Ground floor, Green, 15, Ashok Marg Closed ? Opens 9AM Thu · 1800 2080','Plot No C, 6, Harikishan Somani Marg Closed ? Opens 9:30AM Thu · 1800 1200 1200','Jaipur','Rajasthan',303338,'1231231232','mkjajoriya745@gmail.com','test',4900.00,588.00,5488.00,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-11-05 12:54:18','2020-11-05 12:54:18',NULL,NULL,1,NULL),(68,81,'Smita Singh','','803, tower-22, orchid petals, sector-49','sohna road, gurgaon','gurgaon','Haryana',122018,'9650100564','smitasingh18@gmail.com','',3775.00,453.00,4228.00,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'INR','2020-11-07 20:57:51','2020-11-07 20:57:51',NULL,NULL,1,NULL),(69,81,'Smita Singh','','803, tower-22, orchid petals, sector-49','sohna road, gurgaon','gurgaon','Haryana',122018,'9650100564','smitasingh18@gmail.com','',3775.00,453.00,4228.00,2,2,'order_FyDEpu5wNM9C3m',422800.00,4228.00,'pay_FyDExv32WlVTEl','{}','paid','netbanking','HDFC',NULL,'203122901076',NULL,'INR','2020-11-07 20:58:47','2020-11-07 20:59:28',NULL,NULL,1,NULL);
146/*!40000 ALTER TABLE `order_checkout` ENABLE KEYS */;
147UNLOCK TABLES;
148
149--
150-- Table structure for table `states`
151--
152
153DROP TABLE IF EXISTS `states`;
154/*!40101 SET @saved_cs_client = @@character_set_client */;
155/*!40101 SET character_set_client = utf8 */;
156CREATE TABLE `states` (
157 `id` int(11) NOT NULL AUTO_INCREMENT,
158 `name` varchar(30) NOT NULL,
159 `country_id` int(11) NOT NULL DEFAULT '1',
160 PRIMARY KEY (`id`)
161) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
162/*!40101 SET character_set_client = @saved_cs_client */;
163
164--
165-- Dumping data for table `states`
166--
167
168LOCK TABLES `states` WRITE;
169/*!40000 ALTER TABLE `states` DISABLE KEYS */;
170INSERT INTO `states` VALUES (1,'Andaman and Nicobar Islands',101),(2,'Andhra Pradesh',101),(3,'Arunachal Pradesh',101),(4,'Assam',101),(5,'Bihar',101),(6,'Chandigarh',101),(7,'Chhattisgarh',101),(8,'Dadra and Nagar Haveli',101),(9,'Daman and Diu',101),(10,'Delhi',101),(11,'Goa',101),(12,'Gujarat',101),(13,'Haryana',101),(14,'Himachal Pradesh',101),(15,'Jammu and Kashmir',101),(16,'Jharkhand',101),(17,'Karnataka',101),(18,'Kenmore',101),(19,'Kerala',101),(20,'Lakshadweep',101),(21,'Madhya Pradesh',101),(22,'Maharashtra',101),(23,'Manipur',101),(24,'Meghalaya',101),(25,'Mizoram',101),(26,'Nagaland',101),(29,'Odisha',101),(31,'Pondicherry',101),(32,'Punjab',101),(33,'Rajasthan',101),(34,'Sikkim',101),(35,'Tamil Nadu',101),(36,'Telangana',101),(37,'Tripura',101),(38,'Uttar Pradesh',101),(39,'Uttarakhand',101),(41,'West Bengal',101);
171/*!40000 ALTER TABLE `states` ENABLE KEYS */;
172UNLOCK TABLES;
173
174--
175-- Table structure for table `user`
176--
177
178DROP TABLE IF EXISTS `user`;
179/*!40101 SET @saved_cs_client = @@character_set_client */;
180/*!40101 SET character_set_client = utf8 */;
181CREATE TABLE `user` (
182 `id` int(11) NOT NULL AUTO_INCREMENT,
183 `name` varchar(30) NOT NULL,
184 `email` varchar(30) NOT NULL,
185 `phone` varchar(15) NOT NULL,
186 `username` varchar(10) NOT NULL,
187 `usertype` varchar(30) NOT NULL,
188 `address` varchar(500) NOT NULL,
189 `pincode` varchar(20) NOT NULL,
190 `password` varchar(30) NOT NULL,
191 `s_date` varchar(50) NOT NULL,
192 `s_time` varchar(50) NOT NULL,
193 `status` int(4) NOT NULL,
194 `otp` int(6) DEFAULT NULL,
195 `fb_id` varchar(200) DEFAULT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;
198/*!40101 SET character_set_client = @saved_cs_client */;
199
200--
201-- Dumping data for table `user`
202--
203
204LOCK TABLES `user` WRITE;
205/*!40000 ALTER TABLE `user` DISABLE KEYS */;
206INSERT INTO `user` VALUES (2,'ADMIN','anavila@gmail.com','1234567890','anavila','admin','18 laxmi nager 2nd jai singhpura khor jaipur','302027','Bubble.2820','','',1,NULL,NULL),(4,'Ram','ram@gmail.com','7878787878','','user','','','1','2020-07-15','01:23:48',1,NULL,NULL),(5,'syam','shayam@gmail.com','8989898989','','user','','','2','2020-07-15','01:25:52',1,NULL,NULL),(21,'Manish Kumar Jajoriya','mk@gmail.com','9783379578','','user','jaipur rajsthan','152525','manish','2020-08-07','05:24:26',2,0,NULL),(22,'Anavilla Studios','anavillastudios2020@gmail.com','','','user','','','anavillastudios2020@gmail.com','2020-08-09','05:11:41',2,NULL,NULL),(23,'Manish ','manish@gmail.com','9783379570','','user','','','manish','2020-08-23','06:34:33',2,0,NULL),(24,'mkTutorial ','omp41072@gmail.com','','','user','','','omp41071@gmail.com','2020-08-23','06:55:58',2,NULL,NULL),(25,'Om','omp41071@gmail.com','1231231232','','user','','','manish','2020-08-23','07:24:46',2,0,NULL),(26,'Shyari-Ey-Zindagi Page','anksamma@gmail.com','','','user','','','anksamma@gmail.com','2020-08-24','06:56:16',2,NULL,NULL),(27,'Anup sarkar','anup.sarkar.aks@gmail.com','','','user','','','anup.sarkar.aks@gmail.com','2020-08-24','04:21:19',2,NULL,NULL),(28,'Manish kumar','mkjajoriya745@gmail.com','1235252522','','user','','','manish','2020-08-26','09:34:44',2,0,NULL),(29,'Ankit Samant','anksamma@gmail.com','9694987776','','user','','','23','2020-08-26','07:17:09',2,0,NULL),(30,'PRIYA MAHESHWARI','priya.baldi@anavilastudios.com','8696339489','','user','','','Priya@123','2020-08-29','05:57:12',2,0,NULL),(31,'Shreya Ajesh','shreya.ajesh@gmail.com','9636030322','','user','','','spencer.2820','2020-08-29','09:03:37',2,0,NULL),(32,'nikita','nikitabothra28@gmail.com','9707171129','','user','','','Bothra@28','2020-08-29','06:03:46',1,509860,NULL),(33,'Rhushita','rhush7patel@gmail.com','9016122224','','user','','','1234','2020-08-29','07:19:21',1,889203,NULL),(34,'Annie Sharma','asanniesharma.099@gmail.com','9803343455','','user','','','Walmart1111','2020-08-29','07:49:40',1,408052,NULL),(35,'Sparsh Prasad','sprshprsd@gmail.com','9765322333','','user','','','golden','2020-08-30','07:29:11',1,723900,NULL),(36,'Subrata','neon.bangalore@gmail.com','7406517855','','user','','','9844311170','2020-08-30','09:04:01',1,910134,NULL),(37,'Ankita Priya','ankita.p58@gmail.com','9799487300','','user','','','Ayan@2019va','2020-08-30','09:18:39',1,963420,NULL),(38,'Test','contactankushjain@gmail.com','3636363636','','user','','','test','2020-08-30','10:11:01',2,0,NULL),(39,'Nidhi Agarwal','nidag7@gmail.com','8800937057','','user','','','nidag7@gmail.com','2020-08-30','11:01:37',2,0,NULL),(40,'Anjali Soman','mefive2@gmail.com','8884555084','','user','','','1Cynosure#','2020-08-30','12:46:02',1,732018,NULL),(41,'Hannah Patel','hannahpatel25@gmail.com','8879358339','','user','','','zaroon@2020','2020-08-31','05:21:02',2,0,NULL),(42,'Ani','anksamma@gmail.com','7878787875','','user','','','swapnil','2020-08-31','06:41:26',2,0,NULL),(43,'Hello','anksamma@gmail.com','9655369566','','user','','','biku','2020-08-31','01:45:57',2,0,NULL),(44,'Manish Jajoriya','','','','user','','','Manish Jajoriya','2020-08-31','03:08:10',2,NULL,NULL),(45,'Manish Jajoriya','','','','user','','','Manish Jajoriya','2020-08-31','03:13:43',2,NULL,NULL),(46,'Ankit Samant','','','','user','','','Ankit Samant','2020-08-31','03:17:02',2,NULL,NULL),(47,'manish kumar jajoriya','mks@gmail.com','9783379578','','user','','','manish','2020-08-31','03:20:37',2,0,NULL),(48,'Ani Bro','aniketsamant100@gmail.com','7976838089','','user','','','biku','2020-08-31','05:54:40',2,0,NULL),(49,'Swapnil Bhatnagar','swapnilbhatnagar@aol.com','8094444551','','user','','','Qwerty@99','2020-09-01','05:28:07',2,0,NULL),(50,'Social Trendzz','officialsocialtrendzz@gmail.co','','','user','','','officialsocialtrendzz@gmail.co','2020-09-01','06:20:44',2,NULL,NULL),(51,'Ankit Samant','','','','user','','','Ankit Samant','2020-09-01','07:47:20',2,NULL,NULL),(52,'Ankush Jain','ankushjain01997@gmail.com','9799003772','','user','','','ankush','2020-09-01','07:47:53',1,779414,NULL),(53,'Ankush Jain','ankushjain01997@gmail.com','9293229321','','user','','','1','2020-09-01','07:52:08',1,320681,NULL),(54,'Ankit','ankit.samant.ank@gmail.com','8005779031','','user','','','bikua','2020-09-01','08:09:59',2,0,NULL),(55,'Shashank Awasthi','skawasthi93@gmail.com','9829437939','','user','','','shashank','2020-09-01','08:59:09',2,0,NULL),(56,'Archana','p14archana@iimidr.ac.in','9953681942','','user','','','shivansh','2020-09-01','09:09:07',2,0,NULL),(57,'Annie Sharma','','','','user','','','Annie Sharma','2020-09-01','09:59:07',2,NULL,NULL),(58,'Nidhi Sharma','NIDHI.SHARMA@ANAVILASTUDIOS.CO','9166064000','','user','','','nidhi@2820','2020-09-02','01:01:42',2,0,NULL),(59,'Yug Jangir','yugjangir@gmail.com','7688887883','','user','','','jarvis','2020-09-02','01:09:37',2,0,NULL),(60,'nidhi','nidhi.kumari29@gmail.com','8949474113','','user','','','bubble','2020-09-02','01:15:21',2,0,NULL),(61,'Shraddha Tiwari','shraddhatiwari19@gmail.com','8982522246','','user','','','fatlady19','2020-09-04','06:33:04',2,0,NULL),(62,'Luvleen Asrani','luasrani@rediffmail.com','9819010300','','user','','','213141','2020-09-05','02:56:27',2,0,NULL),(63,'fatima razvi','frazvi007@gmail.com','','','user','','','frazvi007@gmail.com','2020-09-05','04:59:58',2,NULL,NULL),(64,'Gargi Singhal','gargis37@gmail.com','9146938275','','user','','','Sanvish@31','2020-09-05','08:39:35',2,0,NULL),(65,'pratiksha mishra','mishra.pratiksha11@gmail.com','7837332542','','user','','','pranjal22','2020-09-06','05:03:27',2,0,NULL),(66,'Shasank','awasthi.shashank93@gmail.com','7521919991','','user','','','shashank','2020-09-07','08:09:37',2,0,NULL),(67,'rutika m','rutika2290@gmail.com','9819819344','','user','','','rutika123','2020-09-07','04:43:54',2,0,NULL),(68,'pooja Sawant ','','9821550840 ','','user','','','','2020-09-08','10:30:15',2,0,NULL),(69,'Saniyya Mecca','saniyya@yahoo.com','9840450002','','user','','','denruC-zovtat-2didco','2020-09-09','05:39:41',2,0,NULL),(70,'Jayni Dedhia','','','','user','','','Jayni Dedhia','2020-09-13','07:37:45',2,NULL,NULL),(71,'Jayni Dedhia ','j_dedhia@hotmail.com','9820252647','','user','','','j7bookbuddy','2020-09-13','07:43:55',2,0,NULL),(72,'kannan Priya','','','','user','','','kannan Priya','2020-09-14','06:31:49',2,NULL,NULL),(73,'Bonsy Mehta','mehtabonsy@gmail.com','','','user','','','mehtabonsy@gmail.com','2020-09-14','03:31:04',2,NULL,NULL),(74,'Twisha','twishapriya@gmail.com','7864647088','','user','','','spicejet','2020-09-16','08:30:57',1,998171,NULL),(75,'SHAMAL WARLIKAR','','09920754437','','user','','','','2020-09-18','06:10:34',2,0,NULL),(76,'Priyanka Garg','','9033700030','','user','','','','2020-09-19','08:09:06',2,0,NULL),(77,'Ravi P Ojha','','+919818537770','','user','','','','2020-09-20','10:49:33',2,0,NULL),(78,'Jake Peralta','','','','user','','','Jake Peralta','2020-09-21','04:44:40',2,NULL,NULL),(79,'Jake Peralta','','','','user','','','Jake Peralta','2020-09-21','04:47:40',2,NULL,NULL),(80,'Jake Peralta','','','','user','','','Jake Peralta','2020-09-21','04:48:59',2,NULL,NULL),(81,'smita singh','smitasingh18@gmail.com','9650100564','','user','','','amitkamal','2020-09-25','09:45:50',2,0,NULL),(82,'Twisha','','+447864647088','','user','','','','2020-09-28','10:25:41',1,778186,NULL),(83,'diksha ','','9886269461','','user','','','','2020-10-03','05:33:39',2,0,NULL),(84,'Shalini Singh','aashi.scorpion@gmail.com','8699214261','','user','','','aashi30ishi31','2020-10-05','08:01:26',2,0,NULL),(85,'Renu Shinde','renubmeena@gmail.com','9975599172','','user','','','Gopiram@03','2020-10-07','12:20:28',2,0,NULL),(86,'Amiya','','9818528122','','user','','','','2020-10-10','04:35:57',1,572307,NULL),(87,'Nikita Sanyal','nikitasanyal@gmail.com','','','user','','','nikitasanyal@gmail.com','2020-10-14','10:01:23',2,NULL,NULL),(88,'sneha sabnani','','7211199991','','user','','','','2020-10-14','10:09:36',2,0,NULL),(89,'Jhalak Sagar ','jhalaksagar27@gmail.com','9458413635','','user','','','123456789a','2020-10-14','10:13:31',2,0,NULL),(90,'Twinkle ','twinklea660@gmail.com','9960163532','','user','','','Twinklesahil1234','2020-10-14','10:24:05',2,0,NULL),(91,'Meeta Johar','','9897014304','','user','','','','2020-10-14','10:42:26',2,0,NULL),(92,'Karishma Mehta','','9871331777','','user','','','','2020-10-14','11:31:21',2,0,NULL),(93,'priyanka ','','9818606130 ','','user','','','','2020-10-14','04:25:50',2,0,NULL),(94,'jenifer karai','','9833177985','','user','','','','2020-10-14','05:56:07',2,0,NULL),(95,'Radhika ','radhikadoshi@gmail.com','9821471247','','user','','','arjun7606','2020-10-15','06:55:59',2,0,NULL),(96,'kashmira shah','','9820975601','','user','','','','2020-10-15','07:46:59',2,0,NULL),(97,'Paulomi','paulomirajdev@yahoo.com','9099951374','','user','','','soapnbasil4971','2020-10-15','09:01:09',2,0,NULL),(98,'LAVANYA AJESH','lavanya.ajesh@gmail.com','971523486572','','user','','','Bandook@83','2020-10-18','07:22:53',2,0,NULL),(99,'priyanka seth','','9819678809','','user','','','','2020-10-18','12:57:06',2,0,NULL),(100,'Riti','','9823621602','','user','','','','2020-10-18','01:36:13',2,0,NULL),(101,'Riti Taherbhoy','','09823621602','','user','','','','2020-10-19','02:14:06',2,0,NULL),(102,'SHILPIKA DAS','shilpikadas@gmail.com','7506727119','','user','','','Aubade99sd','2020-10-19','03:36:25',2,0,NULL),(103,'Pallavi Punamiya','','9820445407','','user','','','','2020-10-19','08:02:44',2,0,NULL),(104,'Anusha Chandrasekaran ','anusha.c.shop@gmail.com','7358238235','','user','','','Anush1982$*$','2020-10-19','08:47:07',2,0,NULL),(105,'My Name is khan','','9696858574','','user','','','','2020-10-20','06:21:02',1,573916,NULL),(106,'_','','7976802174','','user','','','','2020-10-20','06:22:19',2,0,NULL),(107,'Vijayta Ratusaria','','9996200006','','user','','','','2020-10-20','02:28:42',2,0,NULL),(108,'jinal nagda','jinal_gala@yahoo.com','9920607333','','user','','','jmap6789','2020-10-20','02:37:55',2,0,NULL),(109,'Rajashree Lala','rage713@gmail.com','9821141944','','user','','','paridnyan','2020-10-20','02:46:10',2,0,NULL),(110,'rashi grover','','9911000012','','user','','','','2020-10-20','02:58:14',2,0,NULL),(111,'Mrs Sheetal Savla','','9825066541','','user','','','','2020-10-20','04:20:34',2,0,NULL),(112,'Risha Merchant','','9819197001','','user','','','','2020-10-20','04:45:59',2,0,NULL),(113,'anisha sawant','','9822448724','','user','','','','2020-10-20','04:49:54',2,0,NULL),(114,'Ridhi Mahajan','','9833377342','','user','','','','2020-10-20','06:15:05',2,0,NULL),(115,'shilpi seth','','+6586781847','','user','','','','2020-10-21','02:27:39',1,372450,NULL),(116,'shilpi seth','shilpi.seth08@gmail.com','6586781847','','user','','','remem8er','2020-10-21','02:34:14',1,194115,NULL),(117,'shilpi seth','shilpi.seth08@gmail.com','9753545763','','user','','','remem8er','2020-10-21','07:12:56',2,0,NULL),(118,'shilpi seth','','8960668418','','user','','','','2020-10-21','08:53:13',2,0,NULL),(119,'Kanupriya Kejriwal','kanupriyakejriwal1989@gmail.co','9820665131','','user','','','Body123.','2020-10-21','12:53:55',2,0,NULL),(120,'Niharika Trivedi','','9819742293','','user','','','','2020-10-21','04:03:53',2,0,NULL),(121,'Dipti kalwani','kalwanidipti@gmail.com','9819699344','','user','','','liferocks','2020-10-21','05:55:57',2,0,NULL),(122,'Kadambari Kapoor','','9830076936','','user','','','','2020-10-21','08:34:13',2,0,NULL),(123,'Fleur','fleur_ann@hotmail.com','9820030353','','user','','','flowers123','2020-10-22','07:11:07',2,0,NULL),(124,'Flavia Swain','flaviaswain@gmail.com','9820302016','','user','','','mangodolly@123','2020-10-22','07:37:40',2,0,NULL),(125,'Meghna Shahi','','7979960074','','user','','','','2020-10-22','09:20:32',2,0,NULL),(126,'Pooja palan','','+16465919461','','user','','','','2020-10-22','03:51:41',1,510011,NULL),(127,'Saloni Dhingra','saloni.dhingra@gmail.com','9899520100','','user','','','India@123','2020-10-22','06:58:10',2,0,NULL),(128,'Priyanka ','priyankamanohar@hotmail.com','9845266812','','user','','','Ashpiyu2029','2020-10-23','12:14:52',1,711458,NULL),(129,'Priyanka ','','9886255597','','user','','','','2020-10-23','12:16:32',2,0,NULL),(130,'aparna','','00971507682094','','user','','','','2020-10-24','06:26:58',1,616548,NULL),(131,'MINI MATHUR','','9820183725','','user','','','','2020-10-24','07:44:55',2,0,NULL),(132,'Rajlakshmi Singh','darling.singh89@gmail.com','','','user','','','darling.singh89@gmail.com','2020-10-25','05:28:10',2,NULL,NULL),(133,'Swati Bansal','palms145@gmail.com','','','user','','','palms145@gmail.com','2020-10-25','10:24:36',2,NULL,NULL),(134,'riddhi doshi ','','9820201238','','user','','','','2020-10-27','01:23:40',2,0,NULL),(135,'Komal Baheti','komalmalu@yahoo.co.in','9649911527','','user','','','naveen1206','2020-10-29','08:31:26',2,0,NULL),(136,'Shweta','b.shwetaa@gmail.com','9829162264','','user','','','nandini30','2020-10-30','06:19:16',2,0,NULL),(137,'manjari','sampatmanjari@gmail.com','9820700873','','user','','','apples28','2020-10-31','09:26:18',2,0,NULL),(138,'Tarun Sabnani','','9099199991','','user','','','','2020-11-01','05:43:39',2,0,NULL),(139,'Isha Sanghrajka','','9819017189','','user','','','','2020-11-02','05:23:52',2,0,NULL),(140,'Vijaya lakshmi Kotha','','6565656788','','user','','','','2020-11-05','04:12:21',1,287815,NULL),(141,'anita','','6591198962','','user','','','','2020-11-06','05:25:38',1,341734,NULL),(142,'Uttara Chattopadhyay','','+971559337532','','user','','','','2020-11-09','12:09:55',1,129581,NULL),(143,'Swetha Guhan','swetha.guhan@gmail.com','7760040201','','user','','','archer','2020-11-10','10:46:53',2,0,NULL);
207/*!40000 ALTER TABLE `user` ENABLE KEYS */;
208UNLOCK TABLES;
209
210--
211-- Dumping events for database 'soapandbasil_database'
212--
213/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
214
215/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
216/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
217/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
218/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
219/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
220/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
221/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
222
223-- Dump completed on 2020-11-10 23:39:02
224