· 9 years ago · Aug 24, 2017, 11:50 AM
1-- MySQL dump 10.13 Distrib 5.7.11, for Win64 (x86_64)
2--
3-- Host: localhost Database: viflord_1
4-- ------------------------------------------------------
5-- Server version 5.7.11-log
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 `accesslevel`
20--
21
22DROP TABLE IF EXISTS `accesslevel`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `accesslevel` (
26 `AccessId` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `AccessUserId` int(10) unsigned NOT NULL,
28 `Access` enum('user','premium_user','platinum_user') DEFAULT 'user',
29 PRIMARY KEY (`AccessId`),
30 KEY `AccessUserId` (`AccessUserId`),
31 CONSTRAINT `accesslevel_ibfk_1` FOREIGN KEY (`AccessUserId`) REFERENCES `userprofiles` (`UserID`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `accesslevel`
37--
38
39LOCK TABLES `accesslevel` WRITE;
40/*!40000 ALTER TABLE `accesslevel` DISABLE KEYS */;
41/*!40000 ALTER TABLE `accesslevel` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `address`
46--
47
48DROP TABLE IF EXISTS `address`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `address` (
52 `AddressID` int(10) unsigned NOT NULL,
53 `AddressUserId` int(10) unsigned NOT NULL,
54 `StreetName` varchar(50) NOT NULL,
55 `City` varchar(30) NOT NULL,
56 `State` varchar(40) NOT NULL,
57 `OtherAddressDetails` varchar(50) DEFAULT NULL,
58 PRIMARY KEY (`AddressID`),
59 KEY `AddressUserId` (`AddressUserId`),
60 CONSTRAINT `address_ibfk_1` FOREIGN KEY (`AddressUserId`) REFERENCES `userprofiles` (`UserID`) ON DELETE CASCADE
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `address`
66--
67
68LOCK TABLES `address` WRITE;
69/*!40000 ALTER TABLE `address` DISABLE KEYS */;
70/*!40000 ALTER TABLE `address` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `commentedonitem`
75--
76
77DROP TABLE IF EXISTS `commentedonitem`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `commentedonitem` (
81 `CommentedOnItemID` int(10) unsigned NOT NULL AUTO_INCREMENT,
82 `CommentedOnItemUserID` int(10) unsigned NOT NULL,
83 `CommentDate` date DEFAULT NULL,
84 `Visiblity` tinyint(1) DEFAULT '1',
85 PRIMARY KEY (`CommentedOnItemID`),
86 KEY `CommentedOnItemUserID` (`CommentedOnItemUserID`),
87 CONSTRAINT `commentedonitem_ibfk_1` FOREIGN KEY (`CommentedOnItemUserID`) REFERENCES `userprofiles` (`UserID`)
88) ENGINE=InnoDB DEFAULT CHARSET=utf8;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `commentedonitem`
93--
94
95LOCK TABLES `commentedonitem` WRITE;
96/*!40000 ALTER TABLE `commentedonitem` DISABLE KEYS */;
97/*!40000 ALTER TABLE `commentedonitem` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `commentsforblog`
102--
103
104DROP TABLE IF EXISTS `commentsforblog`;
105/*!40101 SET @saved_cs_client = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `commentsforblog` (
108 `CommentOnBlogID` int(10) unsigned NOT NULL AUTO_INCREMENT,
109 `CommentesForBlogUserID` int(10) unsigned NOT NULL,
110 `Message` varchar(100) DEFAULT NULL,
111 `CommentDate` date DEFAULT NULL,
112 `Visiblity` tinyint(1) DEFAULT '1',
113 PRIMARY KEY (`CommentOnBlogID`),
114 KEY `CommentesForBlogUserID` (`CommentesForBlogUserID`),
115 CONSTRAINT `commentsforblog_ibfk_1` FOREIGN KEY (`CommentesForBlogUserID`) REFERENCES `userprofiles` (`UserID`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Dumping data for table `commentsforblog`
121--
122
123LOCK TABLES `commentsforblog` WRITE;
124/*!40000 ALTER TABLE `commentsforblog` DISABLE KEYS */;
125/*!40000 ALTER TABLE `commentsforblog` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `fabric`
130--
131
132DROP TABLE IF EXISTS `fabric`;
133/*!40101 SET @saved_cs_client = @@character_set_client */;
134/*!40101 SET character_set_client = utf8 */;
135CREATE TABLE `fabric` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `name` varchar(30) NOT NULL,
138 `image_link` varchar(100) NOT NULL,
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `image_link` (`image_link`)
141) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `fabric`
146--
147
148LOCK TABLES `fabric` WRITE;
149/*!40000 ALTER TABLE `fabric` DISABLE KEYS */;
150INSERT INTO `fabric` VALUES (13,'blue moon','E:\\myUploads\\blue moon1496669093948.jpg');
151/*!40000 ALTER TABLE `fabric` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `followers`
156--
157
158DROP TABLE IF EXISTS `followers`;
159/*!40101 SET @saved_cs_client = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `followers` (
162 `FollowID` int(10) unsigned NOT NULL AUTO_INCREMENT,
163 `FollowerID` int(10) unsigned NOT NULL,
164 `FolloweeID` int(10) unsigned NOT NULL,
165 `Date` date DEFAULT NULL,
166 `Visiblity` tinyint(1) DEFAULT '1',
167 PRIMARY KEY (`FollowID`),
168 UNIQUE KEY `FollowerID` (`FollowerID`,`FolloweeID`),
169 KEY `FolloweeID` (`FolloweeID`),
170 CONSTRAINT `followers_ibfk_1` FOREIGN KEY (`FollowerID`) REFERENCES `userprofiles` (`UserID`),
171 CONSTRAINT `followers_ibfk_2` FOREIGN KEY (`FolloweeID`) REFERENCES `userprofiles` (`UserID`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `followers`
177--
178
179LOCK TABLES `followers` WRITE;
180/*!40000 ALTER TABLE `followers` DISABLE KEYS */;
181/*!40000 ALTER TABLE `followers` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `items`
186--
187
188DROP TABLE IF EXISTS `items`;
189/*!40101 SET @saved_cs_client = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `items` (
192 `ItemID` int(10) unsigned NOT NULL AUTO_INCREMENT,
193 `ItemsUserID` int(10) unsigned NOT NULL,
194 `ItemName` varchar(80) NOT NULL,
195 `ItemDescription` varchar(100) NOT NULL,
196 `ItemCreationDate` date DEFAULT NULL,
197 `ItemLink` varchar(100) DEFAULT NULL,
198 `ItemPicLink` varchar(100) DEFAULT NULL,
199 `ItemPrice` double(10,2) DEFAULT NULL,
200 `ItemTempStatus` tinyint(1) DEFAULT '1',
201 `ItemVisibility` tinyint(1) DEFAULT '1',
202 PRIMARY KEY (`ItemID`),
203 KEY `ItemsUserID` (`ItemsUserID`),
204 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`ItemsUserID`) REFERENCES `userprofiles` (`UserID`)
205) ENGINE=InnoDB DEFAULT CHARSET=utf8;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `items`
210--
211
212LOCK TABLES `items` WRITE;
213/*!40000 ALTER TABLE `items` DISABLE KEYS */;
214/*!40000 ALTER TABLE `items` ENABLE KEYS */;
215UNLOCK TABLES;
216
217--
218-- Table structure for table `level1`
219--
220
221DROP TABLE IF EXISTS `level1`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE `level1` (
225 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
226 `division` varchar(20) NOT NULL,
227 PRIMARY KEY (`id`),
228 UNIQUE KEY `division` (`division`)
229) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `level1`
234--
235
236LOCK TABLES `level1` WRITE;
237/*!40000 ALTER TABLE `level1` DISABLE KEYS */;
238INSERT INTO `level1` VALUES (6,'Back'),(5,'Front'),(7,'Neck'),(9,'Pocket'),(8,'Sleeve');
239/*!40000 ALTER TABLE `level1` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `level2`
244--
245
246DROP TABLE IF EXISTS `level2`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `level2` (
250 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
251 `level1id` int(10) unsigned NOT NULL,
252 `type` varchar(20) DEFAULT NULL,
253 `imagelink` varchar(100) DEFAULT NULL,
254 `noofobjects` tinyint(3) unsigned NOT NULL,
255 `status` tinyint(1) NOT NULL DEFAULT '0',
256 PRIMARY KEY (`id`),
257 UNIQUE KEY `level1id` (`level1id`,`type`),
258 CONSTRAINT `level2_ibfk_1` FOREIGN KEY (`level1id`) REFERENCES `level1` (`id`) ON DELETE CASCADE
259) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
260/*!40101 SET character_set_client = @saved_cs_client */;
261
262--
263-- Dumping data for table `level2`
264--
265
266LOCK TABLES `level2` WRITE;
267/*!40000 ALTER TABLE `level2` DISABLE KEYS */;
268INSERT INTO `level2` VALUES (8,7,'Crew','E:\\myUploads\\NeckCrew1495982120772.png',1,1),(11,8,'Full','E:\\myUploads\\SleeveFull1495982246620.png',2,1),(12,5,'Vertical','E:\\myUploads\\FrontVertical1495982369468.png',2,1),(18,5,'Halfhorizontal','E:\\myUploads\\FrontHalfhorizontal1495982977456.png',2,1),(19,6,'Halfhorizontal','E:\\myUploads\\BackHalfhorizontal1495983013151.png',2,1),(31,5,'Horizontal','E:\\myUploads\\FrontHorizontal1496243518744.png',3,1),(32,6,'Horizontal','E:\\myUploads\\BackHorizontal1496243545594.png',3,1),(33,5,'Diagonal','E:\\myUploads\\FrontDiagonal1496243566059.png',3,1),(34,6,'Diagonal','E:\\myUploads\\BackDiagonal1496243592754.png',3,1),(36,5,'Plain','E:\\myUploads\\FrontPlain1496243737984.png',1,1),(37,6,'Plain','E:\\myUploads\\BackPlain1496243762827.png',1,1),(38,6,'Vertical','E:\\myUploads\\BackVertical1496243967040.png',2,1),(39,7,'Vneck','E:\\myUploads\\NeckVneck1496244613912.png',1,1),(40,7,'Scoope','E:\\myUploads\\NeckScoope1496244653728.png',1,1),(41,7,'Collar','E:\\myUploads\\NeckCollar1496244746080.png',1,1),(42,7,'Sweetheart','E:\\myUploads\\NeckSweetheart1496244792977.png',1,1),(43,8,'Half','E:\\myUploads\\SleeveHalf1496310218119.png',2,1),(44,8,'Qwarter','E:\\myUploads\\SleeveQwarter1496310263528.png',2,1),(45,8,'Sleeve Less','E:\\myUploads\\SleeveSleeve Less1496310307094.png',2,1),(48,9,'Jett','E:\\myUploads\\PocketJett1496404711211.jpg',3,0);
269/*!40000 ALTER TABLE `level2` ENABLE KEYS */;
270UNLOCK TABLES;
271
272--
273-- Table structure for table `level3`
274--
275
276DROP TABLE IF EXISTS `level3`;
277/*!40101 SET @saved_cs_client = @@character_set_client */;
278/*!40101 SET character_set_client = utf8 */;
279CREATE TABLE `level3` (
280 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
281 `level2id` int(10) unsigned NOT NULL,
282 `forlevel2` int(10) unsigned DEFAULT NULL,
283 `level5id` int(10) unsigned DEFAULT NULL,
284 PRIMARY KEY (`id`),
285 UNIQUE KEY `level2id` (`level2id`,`forlevel2`),
286 UNIQUE KEY `level2id_2` (`level2id`,`forlevel2`,`level5id`),
287 KEY `forlevel2` (`forlevel2`),
288 KEY `level5id` (`level5id`),
289 CONSTRAINT `level3_ibfk_1` FOREIGN KEY (`level2id`) REFERENCES `level2` (`id`) ON DELETE CASCADE,
290 CONSTRAINT `level3_ibfk_2` FOREIGN KEY (`forlevel2`) REFERENCES `level2` (`id`) ON DELETE CASCADE,
291 CONSTRAINT `level3_ibfk_3` FOREIGN KEY (`level5id`) REFERENCES `level5` (`id`)
292) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;
293/*!40101 SET character_set_client = @saved_cs_client */;
294
295--
296-- Dumping data for table `level3`
297--
298
299LOCK TABLES `level3` WRITE;
300/*!40000 ALTER TABLE `level3` DISABLE KEYS */;
301INSERT INTO `level3` VALUES (21,8,NULL,NULL),(12,11,NULL,NULL),(13,12,8,4),(32,12,39,4),(48,12,40,4),(53,12,41,4),(58,12,42,4),(17,18,8,4),(33,18,39,4),(44,18,40,4),(50,18,41,4),(55,18,42,4),(20,19,8,3),(38,19,39,3),(68,19,40,3),(63,19,41,3),(73,19,42,3),(25,31,8,4),(34,31,39,4),(45,31,40,4),(51,31,41,4),(56,31,42,4),(28,32,8,3),(39,32,39,3),(69,32,40,3),(64,32,41,3),(74,32,42,3),(26,33,8,4),(35,33,39,4),(43,33,40,4),(49,33,41,4),(54,33,42,4),(29,34,8,3),(40,34,39,3),(67,34,40,3),(62,34,41,3),(72,34,42,3),(27,36,8,4),(36,36,39,4),(46,36,40,4),(52,36,41,4),(57,36,42,4),(30,37,8,3),(41,37,39,3),(70,37,40,3),(65,37,41,3),(75,37,42,3),(31,38,8,3),(42,38,39,3),(71,38,40,3),(66,38,41,3),(76,38,42,3),(37,39,NULL,NULL),(60,40,NULL,NULL),(59,41,NULL,NULL),(61,42,NULL,NULL),(77,43,NULL,NULL),(78,44,NULL,NULL),(79,45,NULL,NULL);
302/*!40000 ALTER TABLE `level3` ENABLE KEYS */;
303UNLOCK TABLES;
304
305--
306-- Table structure for table `level4`
307--
308
309DROP TABLE IF EXISTS `level4`;
310/*!40101 SET @saved_cs_client = @@character_set_client */;
311/*!40101 SET character_set_client = utf8 */;
312CREATE TABLE `level4` (
313 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
314 `level3` int(10) unsigned NOT NULL,
315 `serialno` tinyint(3) unsigned NOT NULL,
316 `objectlink` varchar(100) NOT NULL,
317 PRIMARY KEY (`id`),
318 UNIQUE KEY `level3` (`level3`,`serialno`),
319 CONSTRAINT `level4_ibfk_1` FOREIGN KEY (`level3`) REFERENCES `level3` (`id`) ON DELETE CASCADE
320) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8;
321/*!40101 SET character_set_client = @saved_cs_client */;
322
323--
324-- Dumping data for table `level4`
325--
326
327LOCK TABLES `level4` WRITE;
328/*!40000 ALTER TABLE `level4` DISABLE KEYS */;
329INSERT INTO `level4` VALUES (13,12,1,'E:\\myUploads\\SleeveFullNone11495983450470.obj'),(14,12,2,'E:\\myUploads\\SleeveFullNone21495983450477.obj'),(15,13,1,'E:\\myUploads\\FrontVerticalCrew11495983520857.obj'),(16,13,2,'E:\\myUploads\\FrontVerticalCrew21495983520861.obj'),(25,17,1,'E:\\myUploads\\FrontHalfhorizontalCrew11495983729835.obj'),(26,17,2,'E:\\myUploads\\FrontHalfhorizontalCrew21495983729841.obj'),(33,20,1,'E:\\myUploads\\BackHalfhorizontalCrew11495984056646.obj'),(34,20,2,'E:\\myUploads\\BackHalfhorizontalCrew21495984056652.obj'),(35,21,1,'E:\\myUploads\\NeckCrewNone11495985912007.obj'),(39,25,1,'E:\\myUploads\\FrontHorizontalCrew11496244059513.obj'),(40,25,2,'E:\\myUploads\\FrontHorizontalCrew21496244059519.obj'),(41,25,3,'E:\\myUploads\\FrontHorizontalCrew31496244059523.obj'),(42,26,1,'E:\\myUploads\\FrontDiagonalCrew11496244117225.obj'),(43,26,2,'E:\\myUploads\\FrontDiagonalCrew21496244117230.obj'),(44,26,3,'E:\\myUploads\\FrontDiagonalCrew31496244117235.obj'),(45,27,1,'E:\\myUploads\\FrontPlainCrew11496244150205.obj'),(46,28,1,'E:\\myUploads\\BackHorizontalCrew11496244219185.obj'),(47,28,2,'E:\\myUploads\\BackHorizontalCrew21496244219190.obj'),(48,28,3,'E:\\myUploads\\BackHorizontalCrew31496244219195.obj'),(49,29,1,'E:\\myUploads\\BackDiagonalCrew11496244260165.obj'),(50,29,2,'E:\\myUploads\\BackDiagonalCrew21496244260172.obj'),(51,29,3,'E:\\myUploads\\BackDiagonalCrew31496244260177.obj'),(52,30,1,'E:\\myUploads\\BackPlainCrew11496244286431.obj'),(53,31,1,'E:\\myUploads\\BackVerticalCrew11496244407834.obj'),(54,31,2,'E:\\myUploads\\BackVerticalCrew21496244407839.obj'),(55,32,1,'E:\\myUploads\\FrontVerticalVneck11496245038785.obj'),(56,32,2,'E:\\myUploads\\FrontVerticalVneck21496245038791.obj'),(57,33,1,'E:\\myUploads\\FrontHalfhorizontalVneck11496245124294.obj'),(58,33,2,'E:\\myUploads\\FrontHalfhorizontalVneck21496245124300.obj'),(59,34,1,'E:\\myUploads\\FrontHorizontalVneck11496245172636.obj'),(60,34,2,'E:\\myUploads\\FrontHorizontalVneck21496245172642.obj'),(61,34,3,'E:\\myUploads\\FrontHorizontalVneck31496245172664.obj'),(62,35,1,'E:\\myUploads\\FrontDiagonalVneck11496245218756.obj'),(63,35,2,'E:\\myUploads\\FrontDiagonalVneck21496245218761.obj'),(64,35,3,'E:\\myUploads\\FrontDiagonalVneck31496245218767.obj'),(65,36,1,'E:\\myUploads\\FrontPlainVneck11496245258269.obj'),(66,37,1,'E:\\myUploads\\NeckVneckNone11496245277410.obj'),(67,38,1,'E:\\myUploads\\BackHalfhorizontalVneck11496245413576.obj'),(68,38,2,'E:\\myUploads\\BackHalfhorizontalVneck21496245413582.obj'),(69,39,1,'E:\\myUploads\\BackHorizontalVneck11496245443587.obj'),(70,39,2,'E:\\myUploads\\BackHorizontalVneck21496245443592.obj'),(71,39,3,'E:\\myUploads\\BackHorizontalVneck31496245443597.obj'),(72,40,1,'E:\\myUploads\\BackDiagonalVneck11496245478007.obj'),(73,40,2,'E:\\myUploads\\BackDiagonalVneck21496245478031.obj'),(74,40,3,'E:\\myUploads\\BackDiagonalVneck31496245478036.obj'),(75,41,1,'E:\\myUploads\\BackPlainVneck11496245512705.obj'),(76,42,1,'E:\\myUploads\\BackVerticalVneck11496245541770.obj'),(77,42,2,'E:\\myUploads\\BackVerticalVneck21496245541792.obj'),(78,43,1,'E:\\myUploads\\FrontDiagonalScoope11496307665872.obj'),(79,43,2,'E:\\myUploads\\FrontDiagonalScoope21496307665997.obj'),(80,43,3,'E:\\myUploads\\FrontDiagonalScoope31496307666001.obj'),(81,44,1,'E:\\myUploads\\FrontHalfhorizontalScoope11496307767925.obj'),(82,44,2,'E:\\myUploads\\FrontHalfhorizontalScoope21496307767941.obj'),(83,45,1,'E:\\myUploads\\FrontHorizontalScoope11496307808310.obj'),(84,45,2,'E:\\myUploads\\FrontHorizontalScoope21496307808315.obj'),(85,45,3,'E:\\myUploads\\FrontHorizontalScoope31496307808334.obj'),(86,46,1,'E:\\myUploads\\FrontPlainScoope11496307850311.obj'),(89,48,1,'E:\\myUploads\\FrontVerticalScoope11496307986236.obj'),(90,48,2,'E:\\myUploads\\FrontVerticalScoope21496307986260.obj'),(91,49,1,'E:\\myUploads\\FrontDiagonalCollar11496308057666.obj'),(92,49,2,'E:\\myUploads\\FrontDiagonalCollar21496308057671.obj'),(93,49,3,'E:\\myUploads\\FrontDiagonalCollar31496308057689.obj'),(94,50,1,'E:\\myUploads\\FrontHalfhorizontalCollar11496308096587.obj'),(95,50,2,'E:\\myUploads\\FrontHalfhorizontalCollar21496308096592.obj'),(96,51,1,'E:\\myUploads\\FrontHorizontalCollar11496308137047.obj'),(97,51,2,'E:\\myUploads\\FrontHorizontalCollar21496308137070.obj'),(98,51,3,'E:\\myUploads\\FrontHorizontalCollar31496308137074.obj'),(99,52,1,'E:\\myUploads\\FrontPlainCollar11496308168759.obj'),(100,53,1,'E:\\myUploads\\FrontVerticalCollar11496308974975.obj'),(101,53,2,'E:\\myUploads\\FrontVerticalCollar21496308974982.obj'),(102,54,1,'E:\\myUploads\\FrontDiagonalSweetheart11496309024455.obj'),(103,54,2,'E:\\myUploads\\FrontDiagonalSweetheart21496309024480.obj'),(104,54,3,'E:\\myUploads\\FrontDiagonalSweetheart31496309024484.obj'),(105,55,1,'E:\\myUploads\\FrontHalfhorizontalSweetheart11496309052761.obj'),(106,55,2,'E:\\myUploads\\FrontHalfhorizontalSweetheart21496309052766.obj'),(107,56,1,'E:\\myUploads\\FrontHorizontalSweetheart11496309101551.obj'),(108,56,2,'E:\\myUploads\\FrontHorizontalSweetheart21496309101556.obj'),(109,56,3,'E:\\myUploads\\FrontHorizontalSweetheart31496309101561.obj'),(110,57,1,'E:\\myUploads\\FrontPlainSweetheart11496309123422.obj'),(111,58,1,'E:\\myUploads\\FrontVerticalSweetheart11496309155141.obj'),(112,58,2,'E:\\myUploads\\FrontVerticalSweetheart21496309155146.obj'),(113,59,1,'E:\\myUploads\\NeckCollarNone11496309219660.obj'),(114,60,1,'E:\\myUploads\\NeckScoopeNone11496309243351.obj'),(115,61,1,'E:\\myUploads\\NeckSweetheartNone11496309278626.obj'),(116,62,1,'E:\\myUploads\\BackDiagonalCollar11496309412996.obj'),(117,62,2,'E:\\myUploads\\BackDiagonalCollar21496309413001.obj'),(118,62,3,'E:\\myUploads\\BackDiagonalCollar31496309413006.obj'),(119,63,1,'E:\\myUploads\\BackHalfhorizontalCollar11496309445516.obj'),(120,63,2,'E:\\myUploads\\BackHalfhorizontalCollar21496309445521.obj'),(121,64,1,'E:\\myUploads\\BackHorizontalCollar11496309483745.obj'),(122,64,2,'E:\\myUploads\\BackHorizontalCollar21496309483750.obj'),(123,64,3,'E:\\myUploads\\BackHorizontalCollar31496309483771.obj'),(124,65,1,'E:\\myUploads\\BackPlainCollar11496309507480.obj'),(125,66,1,'E:\\myUploads\\BackVerticalCollar11496309543121.obj'),(126,66,2,'E:\\myUploads\\BackVerticalCollar21496309543125.obj'),(127,67,1,'E:\\myUploads\\BackDiagonalScoope11496309691616.obj'),(128,67,2,'E:\\myUploads\\BackDiagonalScoope21496309691621.obj'),(129,67,3,'E:\\myUploads\\BackDiagonalScoope31496309691626.obj'),(130,68,1,'E:\\myUploads\\BackHalfhorizontalScoope11496309749613.obj'),(131,68,2,'E:\\myUploads\\BackHalfhorizontalScoope21496309749630.obj'),(132,69,1,'E:\\myUploads\\BackHorizontalScoope11496309786862.obj'),(133,69,2,'E:\\myUploads\\BackHorizontalScoope21496309786866.obj'),(134,69,3,'E:\\myUploads\\BackHorizontalScoope31496309786871.obj'),(135,70,1,'E:\\myUploads\\BackPlainScoope11496309804810.obj'),(136,71,1,'E:\\myUploads\\BackVerticalScoope11496309843287.obj'),(137,71,2,'E:\\myUploads\\BackVerticalScoope21496309843292.obj'),(138,72,1,'E:\\myUploads\\BackDiagonalSweetheart11496309898187.obj'),(139,72,2,'E:\\myUploads\\BackDiagonalSweetheart21496309898206.obj'),(140,72,3,'E:\\myUploads\\BackDiagonalSweetheart31496309898211.obj'),(141,73,1,'E:\\myUploads\\BackHalfhorizontalSweetheart11496309938274.obj'),(142,73,2,'E:\\myUploads\\BackHalfhorizontalSweetheart21496309938279.obj'),(143,74,1,'E:\\myUploads\\BackHorizontalSweetheart11496310000758.obj'),(144,74,2,'E:\\myUploads\\BackHorizontalSweetheart21496310000763.obj'),(145,74,3,'E:\\myUploads\\BackHorizontalSweetheart31496310000768.obj'),(146,75,1,'E:\\myUploads\\BackPlainSweetheart11496310028306.obj'),(147,76,1,'E:\\myUploads\\BackVerticalSweetheart11496310072773.obj'),(148,76,2,'E:\\myUploads\\BackVerticalSweetheart21496310072777.obj'),(149,77,1,'E:\\myUploads\\SleeveHalfNone11496310449032.obj'),(150,77,2,'E:\\myUploads\\SleeveHalfNone21496310449037.obj'),(151,78,1,'E:\\myUploads\\SleeveQwarterNone11496310476934.obj'),(152,78,2,'E:\\myUploads\\SleeveQwarterNone21496310476950.obj'),(153,79,1,'E:\\myUploads\\SleeveSleeve LessNone11496310506340.obj'),(154,79,2,'E:\\myUploads\\SleeveSleeve LessNone21496310506345.obj');
330/*!40000 ALTER TABLE `level4` ENABLE KEYS */;
331UNLOCK TABLES;
332
333--
334-- Table structure for table `level5`
335--
336
337DROP TABLE IF EXISTS `level5`;
338/*!40101 SET @saved_cs_client = @@character_set_client */;
339/*!40101 SET character_set_client = utf8 */;
340CREATE TABLE `level5` (
341 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
342 `dependent` int(10) unsigned NOT NULL,
343 `supporter` int(10) unsigned NOT NULL,
344 PRIMARY KEY (`id`),
345 UNIQUE KEY `dependent` (`dependent`),
346 UNIQUE KEY `dependent_2` (`dependent`,`supporter`),
347 KEY `supporter` (`supporter`),
348 CONSTRAINT `level5_ibfk_1` FOREIGN KEY (`dependent`) REFERENCES `level1` (`id`) ON DELETE CASCADE,
349 CONSTRAINT `level5_ibfk_2` FOREIGN KEY (`supporter`) REFERENCES `level1` (`id`) ON DELETE CASCADE
350) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
351/*!40101 SET character_set_client = @saved_cs_client */;
352
353--
354-- Dumping data for table `level5`
355--
356
357LOCK TABLES `level5` WRITE;
358/*!40000 ALTER TABLE `level5` DISABLE KEYS */;
359INSERT INTO `level5` VALUES (4,5,7),(3,6,7);
360/*!40000 ALTER TABLE `level5` ENABLE KEYS */;
361UNLOCK TABLES;
362
363--
364-- Table structure for table `objectoptions`
365--
366
367DROP TABLE IF EXISTS `objectoptions`;
368/*!40101 SET @saved_cs_client = @@character_set_client */;
369/*!40101 SET character_set_client = utf8 */;
370CREATE TABLE `objectoptions` (
371 `ObjectOpID` int(10) unsigned NOT NULL AUTO_INCREMENT,
372 `OptionCat` varchar(20) DEFAULT NULL,
373 `MainCategory` varchar(20) DEFAULT NULL,
374 `ObjectType` varchar(20) DEFAULT NULL,
375 `CustomStyle` varchar(30) DEFAULT NULL,
376 `ImageLink` varchar(100) DEFAULT NULL,
377 `totalObject` tinyint(3) unsigned NOT NULL,
378 PRIMARY KEY (`ObjectOpID`),
379 UNIQUE KEY `ImageLink` (`ImageLink`)
380) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
381/*!40101 SET character_set_client = @saved_cs_client */;
382
383--
384-- Dumping data for table `objectoptions`
385--
386
387LOCK TABLES `objectoptions` WRITE;
388/*!40000 ALTER TABLE `objectoptions` DISABLE KEYS */;
389INSERT INTO `objectoptions` VALUES (1,'Aaaaa ','Bbbb ','Hjjhhjhhj ','Nbbjhhhh ','E:\\myUploads\\1492569246105b hem.mtl',2),(2,'Regular ','Neck ','V Neck ','Three V ','E:\\myUploads\\1492569549246logo final.png',2);
390/*!40000 ALTER TABLE `objectoptions` ENABLE KEYS */;
391UNLOCK TABLES;
392
393--
394-- Table structure for table `objects`
395--
396
397DROP TABLE IF EXISTS `objects`;
398/*!40101 SET @saved_cs_client = @@character_set_client */;
399/*!40101 SET character_set_client = utf8 */;
400CREATE TABLE `objects` (
401 `ObjectID` int(10) unsigned NOT NULL AUTO_INCREMENT,
402 `SerialNo` tinyint(3) unsigned NOT NULL,
403 `ObjectLink` varchar(100) DEFAULT NULL,
404 `ObjectOptionsID` int(10) unsigned NOT NULL,
405 PRIMARY KEY (`ObjectID`),
406 UNIQUE KEY `SerialNo` (`SerialNo`,`ObjectLink`),
407 UNIQUE KEY `ObjectLink` (`ObjectLink`),
408 UNIQUE KEY `ObjectLink_2` (`ObjectLink`),
409 KEY `ObjectOptionsID` (`ObjectOptionsID`),
410 CONSTRAINT `objects_ibfk_1` FOREIGN KEY (`ObjectOptionsID`) REFERENCES `objectoptions` (`ObjectOpID`)
411) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
412/*!40101 SET character_set_client = @saved_cs_client */;
413
414--
415-- Dumping data for table `objects`
416--
417
418LOCK TABLES `objects` WRITE;
419/*!40000 ALTER TABLE `objects` DISABLE KEYS */;
420INSERT INTO `objects` VALUES (1,1,'E:\\myUploads\\1492569549253right sleeve.obj',2),(2,2,'E:\\myUploads\\1492569549274left sleeve.obj',2);
421/*!40000 ALTER TABLE `objects` ENABLE KEYS */;
422UNLOCK TABLES;
423
424--
425-- Table structure for table `orderdetails`
426--
427
428DROP TABLE IF EXISTS `orderdetails`;
429/*!40101 SET @saved_cs_client = @@character_set_client */;
430/*!40101 SET character_set_client = utf8 */;
431CREATE TABLE `orderdetails` (
432 `OrderID` int(10) unsigned NOT NULL AUTO_INCREMENT,
433 `OrderDetailsUserID` int(10) unsigned NOT NULL,
434 `Date` date NOT NULL,
435 PRIMARY KEY (`OrderID`),
436 KEY `OrderDetailsUserID` (`OrderDetailsUserID`),
437 CONSTRAINT `orderdetails_ibfk_1` FOREIGN KEY (`OrderDetailsUserID`) REFERENCES `userprofiles` (`UserID`)
438) ENGINE=InnoDB DEFAULT CHARSET=utf8;
439/*!40101 SET character_set_client = @saved_cs_client */;
440
441--
442-- Dumping data for table `orderdetails`
443--
444
445LOCK TABLES `orderdetails` WRITE;
446/*!40000 ALTER TABLE `orderdetails` DISABLE KEYS */;
447/*!40000 ALTER TABLE `orderdetails` ENABLE KEYS */;
448UNLOCK TABLES;
449
450--
451-- Table structure for table `orders`
452--
453
454DROP TABLE IF EXISTS `orders`;
455/*!40101 SET @saved_cs_client = @@character_set_client */;
456/*!40101 SET character_set_client = utf8 */;
457CREATE TABLE `orders` (
458 `SerialNoOfOrders` int(10) unsigned NOT NULL AUTO_INCREMENT,
459 `OrderID` int(10) unsigned NOT NULL,
460 `OrderedItemID` int(10) unsigned NOT NULL,
461 PRIMARY KEY (`SerialNoOfOrders`),
462 KEY `OrderedItemID` (`OrderedItemID`),
463 KEY `OrderID` (`OrderID`),
464 CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`OrderedItemID`) REFERENCES `items` (`ItemID`) ON DELETE CASCADE,
465 CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`OrderID`) REFERENCES `orderdetails` (`OrderID`) ON DELETE CASCADE
466) ENGINE=InnoDB DEFAULT CHARSET=utf8;
467/*!40101 SET character_set_client = @saved_cs_client */;
468
469--
470-- Dumping data for table `orders`
471--
472
473LOCK TABLES `orders` WRITE;
474/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
475/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
476UNLOCK TABLES;
477
478--
479-- Table structure for table `prints`
480--
481
482DROP TABLE IF EXISTS `prints`;
483/*!40101 SET @saved_cs_client = @@character_set_client */;
484/*!40101 SET character_set_client = utf8 */;
485CREATE TABLE `prints` (
486 `printId` int(10) unsigned NOT NULL AUTO_INCREMENT,
487 `userIdprint` int(10) unsigned NOT NULL,
488 `printlink` varchar(100) NOT NULL,
489 PRIMARY KEY (`printId`),
490 KEY `userIdprint` (`userIdprint`),
491 CONSTRAINT `prints_ibfk_1` FOREIGN KEY (`userIdprint`) REFERENCES `userprofiles` (`UserID`)
492) ENGINE=InnoDB DEFAULT CHARSET=utf8;
493/*!40101 SET character_set_client = @saved_cs_client */;
494
495--
496-- Dumping data for table `prints`
497--
498
499LOCK TABLES `prints` WRITE;
500/*!40000 ALTER TABLE `prints` DISABLE KEYS */;
501/*!40000 ALTER TABLE `prints` ENABLE KEYS */;
502UNLOCK TABLES;
503
504--
505-- Table structure for table `promotions`
506--
507
508DROP TABLE IF EXISTS `promotions`;
509/*!40101 SET @saved_cs_client = @@character_set_client */;
510/*!40101 SET character_set_client = utf8 */;
511CREATE TABLE `promotions` (
512 `PromotionID` int(10) unsigned NOT NULL AUTO_INCREMENT,
513 `PromoterUserID` int(10) unsigned NOT NULL,
514 `PromotedItemID` int(10) unsigned NOT NULL,
515 `PromotionDate` date NOT NULL,
516 PRIMARY KEY (`PromotionID`),
517 KEY `PromoterUserID` (`PromoterUserID`),
518 KEY `PromotedItemID` (`PromotedItemID`),
519 CONSTRAINT `promotions_ibfk_1` FOREIGN KEY (`PromoterUserID`) REFERENCES `userprofiles` (`UserID`),
520 CONSTRAINT `promotions_ibfk_2` FOREIGN KEY (`PromotedItemID`) REFERENCES `items` (`ItemID`)
521) ENGINE=InnoDB DEFAULT CHARSET=utf8;
522/*!40101 SET character_set_client = @saved_cs_client */;
523
524--
525-- Dumping data for table `promotions`
526--
527
528LOCK TABLES `promotions` WRITE;
529/*!40000 ALTER TABLE `promotions` DISABLE KEYS */;
530/*!40000 ALTER TABLE `promotions` ENABLE KEYS */;
531UNLOCK TABLES;
532
533--
534-- Table structure for table `shipping`
535--
536
537DROP TABLE IF EXISTS `shipping`;
538/*!40101 SET @saved_cs_client = @@character_set_client */;
539/*!40101 SET character_set_client = utf8 */;
540CREATE TABLE `shipping` (
541 `ShippingID` int(10) unsigned NOT NULL AUTO_INCREMENT,
542 `ShippingAddressID` int(10) unsigned NOT NULL,
543 `MobileNo` varchar(20) NOT NULL,
544 PRIMARY KEY (`ShippingID`),
545 KEY `ShippingAddressID` (`ShippingAddressID`),
546 CONSTRAINT `shipping_ibfk_1` FOREIGN KEY (`ShippingAddressID`) REFERENCES `address` (`AddressID`)
547) ENGINE=InnoDB DEFAULT CHARSET=utf8;
548/*!40101 SET character_set_client = @saved_cs_client */;
549
550--
551-- Dumping data for table `shipping`
552--
553
554LOCK TABLES `shipping` WRITE;
555/*!40000 ALTER TABLE `shipping` DISABLE KEYS */;
556/*!40000 ALTER TABLE `shipping` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Table structure for table `userprofiles`
561--
562
563DROP TABLE IF EXISTS `userprofiles`;
564/*!40101 SET @saved_cs_client = @@character_set_client */;
565/*!40101 SET character_set_client = utf8 */;
566CREATE TABLE `userprofiles` (
567 `UserID` int(10) unsigned NOT NULL AUTO_INCREMENT,
568 `UserName` varchar(60) NOT NULL,
569 `Email` varchar(40) NOT NULL,
570 `DOB` date DEFAULT NULL,
571 `Sex` enum('Male','Female') DEFAULT NULL,
572 `MobileNo` varchar(20) DEFAULT NULL,
573 `Password` varchar(20) NOT NULL,
574 `ProfilePicLink` varchar(100) DEFAULT NULL,
575 `CreationDate` date NOT NULL,
576 `Reputation` int(10) unsigned DEFAULT '0',
577 `Wallet` double(10,2) DEFAULT '0.00',
578 `Access` enum('user','premium_user','platinum_user') DEFAULT 'user',
579 PRIMARY KEY (`UserID`),
580 UNIQUE KEY `Email` (`Email`),
581 UNIQUE KEY `MobileNo` (`MobileNo`)
582) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
583/*!40101 SET character_set_client = @saved_cs_client */;
584
585--
586-- Dumping data for table `userprofiles`
587--
588
589LOCK TABLES `userprofiles` WRITE;
590/*!40000 ALTER TABLE `userprofiles` DISABLE KEYS */;
591INSERT INTO `userprofiles` VALUES (1,'Sagar Verma ','sagartheocean24@gmail.com','1992-12-24','Male',NULL,'ocean.2412','E:\\myUploads\\male.png','2017-04-03',0,0.00,'user'),(2,'Viflord Co.','viflord_admin@viflord.com',NULL,NULL,NULL,'123456789','E:\\myUploads\\male.png','2017-04-15',0,0.00,'platinum_user'),(3,'Suraj Nayak ','srjnk@gmail.com','1994-12-08','Male',NULL,'123123','E:\\myUploads\\female.png','2017-04-19',0,0.00,'user'),(4,'Chakrapani Ravi Oraon ','ivar@gmail.com','1993-06-07','Male',NULL,'12121212','E:\\myUploads\\male.png','2017-04-19',0,0.00,'user'),(5,'Suraj Nayak ','srjnk27@gmail.com','1994-12-09','Male',NULL,'123456789','E:/myUploads/male.png','2017-08-22',0,0.00,'user');
592/*!40000 ALTER TABLE `userprofiles` ENABLE KEYS */;
593UNLOCK TABLES;
594/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
595
596/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
597/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
598/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
599/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
600/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
601/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
602/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
603
604-- Dump completed on 2017-08-24 17:16:37