· 5 years ago · Mar 06, 2020, 08:30 PM
1-- MySQL dump 10.17 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: forescient-mcslruvj96469-db.mysql.database.azure.com Database: qa
4-- ------------------------------------------------------
5-- Server version 5.6.42.0
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 utf8mb4 */;
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 `active_storage_attachments`
20--
21
22DROP TABLE IF EXISTS `active_storage_attachments`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `active_storage_attachments` (
26 `id` tinyint(4) DEFAULT NULL,
27 `name` varchar(5) DEFAULT NULL,
28 `record_type` varchar(10) DEFAULT NULL,
29 `record_id` tinyint(4) DEFAULT NULL,
30 `blob_id` tinyint(4) DEFAULT NULL,
31 `created_at` varchar(10) DEFAULT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `active_storage_attachments`
37--
38
39LOCK TABLES `active_storage_attachments` WRITE;
40/*!40000 ALTER TABLE `active_storage_attachments` DISABLE KEYS */;
41INSERT INTO `active_storage_attachments` VALUES (1,'image','Storefront',2,1,'2019-09-09'),(2,'image','Storefront',4,2,'2019-09-09'),(3,'image','Storefront',5,3,'2019-09-09'),(4,'image','Storefront',6,4,'2019-09-09'),(5,'image','Product',1,5,'2019-09-09'),(6,'image','Product',2,6,'2019-09-09'),(7,'image','Product',3,7,'2019-09-09'),(8,'image','Product',4,8,'2019-09-09'),(9,'image','Product',5,9,'2019-09-09'),(10,'image','Product',6,10,'2019-09-09'),(11,'image','Product',7,11,'2019-09-09'),(12,'image','Product',8,12,'2019-09-09'),(13,'image','Product',9,13,'2019-09-09'),(14,'image','Product',10,14,'2019-09-09'),(15,'image','Product',11,15,'2019-09-09'),(16,'image','Product',12,16,'2019-09-09'),(17,'image','Product',13,17,'2019-09-09'),(18,'image','Product',14,18,'2019-09-09'),(19,'image','Product',15,19,'2019-09-09'),(20,'image','Product',16,20,'2019-09-09'),(21,'image','Product',17,21,'2019-09-09'),(22,'image','Product',18,22,'2019-09-09'),(23,'image','Product',19,23,'2019-09-09'),(24,'image','Product',20,24,'2019-09-09'),(25,'image','Product',21,25,'2019-09-09'),(26,'image','Product',22,26,'2019-09-09'),(27,'image','Product',23,27,'2019-09-09'),(28,'image','Product',24,28,'2019-09-09'),(29,'image','Product',25,29,'2019-09-09'),(30,'image','Product',26,30,'2019-09-09'),(31,'image','Product',27,31,'2019-09-09'),(32,'image','Product',28,32,'2019-09-09');
42/*!40000 ALTER TABLE `active_storage_attachments` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `active_storage_blobs`
47--
48
49DROP TABLE IF EXISTS `active_storage_blobs`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `active_storage_blobs` (
53 `id` tinyint(4) DEFAULT NULL,
54 `key` varchar(24) DEFAULT NULL,
55 `filename` varchar(32) DEFAULT NULL,
56 `content_type` varchar(10) DEFAULT NULL,
57 `metadata` varchar(35) DEFAULT NULL,
58 `byte_size` int(11) DEFAULT NULL,
59 `checksum` varchar(24) DEFAULT NULL,
60 `created_at` varchar(10) DEFAULT NULL
61) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `active_storage_blobs`
66--
67
68LOCK TABLES `active_storage_blobs` WRITE;
69/*!40000 ALTER TABLE `active_storage_blobs` DISABLE KEYS */;
70INSERT INTO `active_storage_blobs` VALUES (1,'MF8TUguYGFDhvWrrius1nbWL','woven-purse-sf.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',173306,'76MRFzC40bnvcHpzoHzSpg==','2019-09-09'),(2,'QMXzpM7EzQSx7sLjuCwLxBqe','abstract-art-sf.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',273752,'AVGUrKbeBLuxFX5huBWZWw==','2019-09-09'),(3,'rMeT3g7XEXqURFD6EY9nAgvD','nautical-sf.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',155194,'cu2vlfjiNuPpNMym2gsX8w==','2019-09-09'),(4,'e2DUbc9LpezLirPQ42AAmhg7','ossio-sf.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',156147,'qy1JCrUldptI3UoyRCvU+g==','2019-09-09'),(5,'KFV5CpCkDE4vHEoUJXKDmL2P','boardgame-apologies.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',229110,'n9/UYSCyAFMltGqc8VQw8g==','2019-09-09'),(6,'ht4rLdr396MuX3qZT1gueB9Q','boardgame-corner-the-market.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',212100,'In7o2FIe9lQQB/iLRtveiQ==','2019-09-09'),(7,'Js4AMiMUpQAssTjNJfxHkhNd','assorted-dice.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',141850,'wWh4EP4s0v0FssOIc7ZXfw==','2019-09-09'),(8,'53Uc23DknkbfCpGKHj7Ge7LK','teddy-bear.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',63531,'f2k0BAofmVdh/IWTRgWtdQ==','2019-09-09'),(9,'wvA6rkgWmUqqFhm2EDKV1AxW','amethyst-ring.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',86537,'4KQ3vAA1xl5ZxYnsjYDQmg==','2019-09-09'),(10,'xngMJtv4ZCB2DLWJfN6yr2dy','opal-pendant.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',220303,'EjaswlAUJB0Nfiw3jxXZ1Q==','2019-09-09'),(11,'xyKenxJYT17NDbyCKUZabmQ3','blue-danglies.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',410872,'n228y+YTNMkCPBeJdvv81g==','2019-09-09'),(12,'roTM5Wxaej6BVinyXg42j7FD','woven-purse.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',288624,'pOqnyc525bxQoq74eMCkHQ==','2019-09-09'),(13,'wM6KSJfVLVF4d6Q6cj8kphJs','cool-sunglsses.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',71391,'vRJA67gd2Di1jQFAFKhzKg==','2019-09-09'),(14,'ojnNA8ErurARJYw1NP8AQvFP','hip-photographer-starterpack.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',285423,'YYiaKfF+g2jabjleqLVy2w==','2019-09-09'),(15,'bpDj2u4ZQGU9xoxXBA1D6aJC','abstract-art-01.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',400814,'57vDJKFGw9Ax/zSlv7cW1g==','2019-09-09'),(16,'jbXt886PseL21LdRLNq3otRE','abstract-art-02.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',470782,'CB6oQjdKKG0KWiXlvy8aNg==','2019-09-09'),(17,'jgBJ3B2XGNrP5eVDuyGfXv6H','abstract-art-03.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',489131,'xHikRQKWZOasIgFQVFKvvA==','2019-09-09'),(18,'TsHDe9FhukywtUaRADW8jkem','abstract-art-04.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',312741,'7+pqCMCoMcqBGdQPulGpGg==','2019-09-09'),(19,'bR5rJwQarncontKVALwE3L32','blue-glass-flower-decoration.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',181635,'IyAbSMTMEOLByY17w2//1g==','2019-09-09'),(20,'95YwTvuGxyDSWZ4NQrXTcFaW','fluffy-cozy-rug.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',255473,'CK4a/U0+qHY28BFUnhyL3g==','2019-09-09'),(21,'eUsaQUhwYVic8PZHdXiymJbt','floor-rug.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',291674,'iqr9yKNIwCBZyh4fIUF55Q==','2019-09-09'),(22,'6dCiUjPAA6Kzr6F4NGrT1qsS','canvas-20x24.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',152024,'1K4NnRpcUcORgErWp9QjBA==','2019-09-09'),(23,'Uqr6M94s7nz5NmBiZVytoZY6','easel-standard.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',105593,'QjjEENiS/YXw/NW9VhLIkA==','2019-09-09'),(24,'xpZ8ZVCCAT4CkbuC2S3Qoick','acrylic-paint-set.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',360062,'HLzsQZXtN5xgrFzSuXgKIQ==','2019-09-09'),(25,'UpNArhTn3UpHW6mdhBYeJ2qS','knot.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',131118,'46tHMTpdjpH2u0t+mnZ3SQ==','2019-09-09'),(26,'e4Qw2GHR7GMb3uD27nAb283r','buoys.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',154209,'jT7pGFkkH7WQ2r/koyDjow==','2019-09-09'),(27,'LyGNp6HHn541nLmYaYk4e2Th','flag1.jpg','image/png','{\"identified\":true,\"analyzed\":true}',65243,'PekGJV8ysf4EERYsjTkxlw==','2019-09-09'),(28,'C9xfVSURR86kh85r8dRD3bs2','flag2.jpg','image/png','{\"identified\":true,\"analyzed\":true}',26253,'t5Ods4pMgK7oEtaevn924A==','2019-09-09'),(29,'7gayGWcTfz3itjkhFYYHe4Qp','knit-sweater.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',217823,'ZcOLabtyq30uk04MfoX0IQ==','2019-09-09'),(30,'mt4M6CcBUpdhCR3R1TmxFkSw','fabric-sample.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',125471,'5HFRgAA0jVi9BMtJy1PzpA==','2019-09-09'),(31,'w4nd7k71HWCtr8aKVTwoPVL5','grande-blanket.jpg','image/jpeg','{\"identified\":true,\"analyzed\":true}',323099,'VVYhWTVrGWsBzbvKmJgwbA==','2019-09-09'),(32,'J5sB94TEcqci7nw4qCFNw1aZ','Screenshot_1567036985.png','image/png','{\"identified\":true,\"analyzed\":true}',1332905,'rTyDBRYJqKCiN3KL1ix6Ow==','2019-09-09');
71/*!40000 ALTER TABLE `active_storage_blobs` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `addresses`
76--
77
78DROP TABLE IF EXISTS `addresses`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `addresses` (
82 `id` tinyint(4) DEFAULT NULL,
83 `name` varchar(16) DEFAULT NULL,
84 `line_one` varchar(23) DEFAULT NULL,
85 `line_two` varchar(3) DEFAULT NULL,
86 `city` varchar(11) DEFAULT NULL,
87 `state` varchar(7) DEFAULT NULL,
88 `zipcode` varchar(10) DEFAULT NULL,
89 `user_id` tinyint(4) DEFAULT NULL,
90 `created_at` varchar(10) DEFAULT NULL,
91 `updated_at` varchar(10) DEFAULT NULL
92) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `addresses`
97--
98
99LOCK TABLES `addresses` WRITE;
100/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
101INSERT INTO `addresses` VALUES (1,'Dan Ryan\'s House','1756 Cloverfield Lane','','Bakersville','Vermont','44544',10,'2019-09-09','2019-09-09'),(2,'Kowalski Jackson','123 Fourth St. Unit 567','','Bakersville','Vermont','44544',11,'2019-09-09','2019-09-09'),(3,'Adam T Goobs','1152 Warden Ave N','208','SEATTLE','WA','98109-4997',17,'2019-09-09','2019-09-09');
102/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `ar_internal_metadata`
107--
108
109DROP TABLE IF EXISTS `ar_internal_metadata`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `ar_internal_metadata` (
113 `key` varchar(11) DEFAULT NULL,
114 `value` varchar(11) DEFAULT NULL,
115 `created_at` varchar(10) DEFAULT NULL,
116 `updated_at` varchar(10) DEFAULT NULL
117) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
118/*!40101 SET character_set_client = @saved_cs_client */;
119
120--
121-- Dumping data for table `ar_internal_metadata`
122--
123
124LOCK TABLES `ar_internal_metadata` WRITE;
125/*!40000 ALTER TABLE `ar_internal_metadata` DISABLE KEYS */;
126INSERT INTO `ar_internal_metadata` VALUES ('environment','development','2019-09-09','2019-09-09');
127/*!40000 ALTER TABLE `ar_internal_metadata` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `categories`
132--
133
134DROP TABLE IF EXISTS `categories`;
135/*!40101 SET @saved_cs_client = @@character_set_client */;
136/*!40101 SET character_set_client = utf8 */;
137CREATE TABLE `categories` (
138 `id` tinyint(4) DEFAULT NULL,
139 `name` varchar(14) DEFAULT NULL,
140 `description` varchar(69) DEFAULT NULL,
141 `created_at` varchar(10) DEFAULT NULL,
142 `updated_at` varchar(10) DEFAULT NULL
143) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `categories`
148--
149
150LOCK TABLES `categories` WRITE;
151/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
152INSERT INTO `categories` VALUES (1,'Clothing','Clothing and shoes','2019-09-09','2019-09-09'),(2,'Jewelry','Jewelry and other accessories','2019-09-09','2019-09-09'),(3,'Art','Art and collectables','2019-09-09','2019-09-09'),(4,'Home Goods','Furniture, home goods, and outdoor goods','2019-09-09','2019-09-09'),(5,'Events','Weddings and party supplies and gifts','2019-09-09','2019-09-09'),(6,'Entertainment','Movies, games, Consumer electronics','2019-09-09','2019-09-09'),(7,'Craft Supplies','Feathers, paint, canvas and everything else you may need for that DIY','2019-09-09','2019-09-09'),(8,'Vintage','Old items given new life','2019-09-09','2019-09-09'),(9,'Other','Everything else','2019-09-09','2019-09-09');
153/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `category_products`
158--
159
160DROP TABLE IF EXISTS `category_products`;
161/*!40101 SET @saved_cs_client = @@character_set_client */;
162/*!40101 SET character_set_client = utf8 */;
163CREATE TABLE `category_products` (
164 `id` tinyint(4) DEFAULT NULL,
165 `category_id` tinyint(4) DEFAULT NULL,
166 `product_id` tinyint(4) DEFAULT NULL,
167 `created_at` varchar(10) DEFAULT NULL,
168 `updated_at` varchar(10) DEFAULT NULL
169) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `category_products`
174--
175
176LOCK TABLES `category_products` WRITE;
177/*!40000 ALTER TABLE `category_products` DISABLE KEYS */;
178INSERT INTO `category_products` VALUES (1,6,1,'2019-09-09','2019-09-09'),(2,6,2,'2019-09-09','2019-09-09'),(3,6,3,'2019-09-09','2019-09-09'),(4,9,4,'2019-09-09','2019-09-09'),(5,2,5,'2019-09-09','2019-09-09'),(6,8,5,'2019-09-09','2019-09-09'),(7,2,6,'2019-09-09','2019-09-09'),(8,2,7,'2019-09-09','2019-09-09'),(9,1,8,'2019-09-09','2019-09-09'),(10,1,9,'2019-09-09','2019-09-09'),(11,1,10,'2019-09-09','2019-09-09'),(12,3,11,'2019-09-09','2019-09-09'),(13,3,12,'2019-09-09','2019-09-09'),(14,3,13,'2019-09-09','2019-09-09'),(15,3,14,'2019-09-09','2019-09-09'),(16,4,15,'2019-09-09','2019-09-09'),(17,8,15,'2019-09-09','2019-09-09'),(18,4,16,'2019-09-09','2019-09-09'),(19,4,17,'2019-09-09','2019-09-09'),(20,8,17,'2019-09-09','2019-09-09'),(21,7,18,'2019-09-09','2019-09-09'),(22,7,19,'2019-09-09','2019-09-09'),(23,7,20,'2019-09-09','2019-09-09'),(24,8,21,'2019-09-09','2019-09-09'),(25,3,21,'2019-09-09','2019-09-09'),(26,4,21,'2019-09-09','2019-09-09'),(27,8,22,'2019-09-09','2019-09-09'),(28,3,22,'2019-09-09','2019-09-09'),(29,4,22,'2019-09-09','2019-09-09'),(30,8,23,'2019-09-09','2019-09-09'),(31,3,23,'2019-09-09','2019-09-09'),(32,8,24,'2019-09-09','2019-09-09'),(33,3,24,'2019-09-09','2019-09-09'),(34,1,25,'2019-09-09','2019-09-09'),(35,7,26,'2019-09-09','2019-09-09'),(36,4,26,'2019-09-09','2019-09-09'),(37,4,27,'2019-09-09','2019-09-09'),(39,1,29,'2019-09-09','2019-09-09'),(40,1,30,'2019-09-09','2019-09-09'),(41,1,31,'2019-09-09','2019-09-09'),(42,1,32,'2019-09-09','2019-09-09'),(46,4,28,'2019-09-09','2019-09-09');
179/*!40000 ALTER TABLE `category_products` ENABLE KEYS */;
180UNLOCK TABLES;
181
182--
183-- Table structure for table `credit_cards`
184--
185
186DROP TABLE IF EXISTS `credit_cards`;
187/*!40101 SET @saved_cs_client = @@character_set_client */;
188/*!40101 SET character_set_client = utf8 */;
189CREATE TABLE `credit_cards` (
190 `id` tinyint(4) DEFAULT NULL,
191 `name` varchar(15) DEFAULT NULL,
192 `number` bigint(20) DEFAULT NULL,
193 `expiration` varchar(0) DEFAULT NULL,
194 `cvc` smallint(6) DEFAULT NULL,
195 `user_id` tinyint(4) DEFAULT NULL,
196 `created_at` varchar(10) DEFAULT NULL,
197 `updated_at` varchar(10) DEFAULT NULL,
198 `public_uid` varchar(8) DEFAULT NULL
199) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `credit_cards`
204--
205
206LOCK TABLES `credit_cards` WRITE;
207/*!40000 ALTER TABLE `credit_cards` DISABLE KEYS */;
208INSERT INTO `credit_cards` VALUES (1,'Dan Ryan',2494585873651234,'',4436,10,'2019-09-09','2019-09-09','cda3e7be'),(2,'Daniel A. Ryan',1234434320209483,'',7686,10,'2019-09-09','2019-09-09','e716c8b9'),(3,'Carrie P. Brown',2222434320543583,'',5546,11,'2019-09-09','2019-09-09','c93700c6'),(4,'Carrie P. Brown',9584939389094875,'',4452,11,'2019-09-09','2019-09-09','fe292eae'),(5,'blah blah',1234123412341234,'',156,17,'2019-09-09','2019-09-09','bd38be2f');
209/*!40000 ALTER TABLE `credit_cards` ENABLE KEYS */;
210UNLOCK TABLES;
211
212--
213-- Table structure for table `gift_cards`
214--
215
216DROP TABLE IF EXISTS `gift_cards`;
217/*!40101 SET @saved_cs_client = @@character_set_client */;
218/*!40101 SET character_set_client = utf8 */;
219CREATE TABLE `gift_cards` (
220 `id` varchar(0) DEFAULT NULL,
221 `number` varchar(0) DEFAULT NULL,
222 `cvc` varchar(0) DEFAULT NULL,
223 `user_id` varchar(0) DEFAULT NULL,
224 `created_at` varchar(0) DEFAULT NULL,
225 `updated_at` varchar(0) DEFAULT NULL
226) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
227/*!40101 SET character_set_client = @saved_cs_client */;
228
229--
230-- Dumping data for table `gift_cards`
231--
232
233LOCK TABLES `gift_cards` WRITE;
234/*!40000 ALTER TABLE `gift_cards` DISABLE KEYS */;
235/*!40000 ALTER TABLE `gift_cards` ENABLE KEYS */;
236UNLOCK TABLES;
237
238--
239-- Table structure for table `inventories`
240--
241
242DROP TABLE IF EXISTS `inventories`;
243/*!40101 SET @saved_cs_client = @@character_set_client */;
244/*!40101 SET character_set_client = utf8 */;
245CREATE TABLE `inventories` (
246 `id` smallint(6) DEFAULT NULL,
247 `product_id` tinyint(4) DEFAULT NULL,
248 `order_id` varchar(1) DEFAULT NULL,
249 `price` decimal(5,2) DEFAULT NULL,
250 `created_at` varchar(10) DEFAULT NULL,
251 `updated_at` varchar(10) DEFAULT NULL
252) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Dumping data for table `inventories`
257--
258
259LOCK TABLES `inventories` WRITE;
260/*!40000 ALTER TABLE `inventories` DISABLE KEYS */;
261INSERT INTO `inventories` VALUES (1,1,'',50.00,'2019-09-09','2019-09-09'),(2,1,'',50.00,'2019-09-09','2019-09-09'),(3,1,'',50.00,'2019-09-09','2019-09-09'),(4,1,'',50.00,'2019-09-09','2019-09-09'),(5,2,'5',45.00,'2019-09-09','2019-09-09'),(6,3,'',20.00,'2019-09-09','2019-09-09'),(7,3,'',20.00,'2019-09-09','2019-09-09'),(8,3,'',20.00,'2019-09-09','2019-09-09'),(9,3,'',20.00,'2019-09-09','2019-09-09'),(10,4,'',13.37,'2019-09-09','2019-09-09'),(11,4,'',13.37,'2019-09-09','2019-09-09'),(12,4,'',13.37,'2019-09-09','2019-09-09'),(13,4,'',13.37,'2019-09-09','2019-09-09'),(14,5,'',300.00,'2019-09-09','2019-09-09'),(15,5,'',300.00,'2019-09-09','2019-09-09'),(16,5,'',300.00,'2019-09-09','2019-09-09'),(17,6,'',30.00,'2019-09-09','2019-09-09'),(18,6,'',30.00,'2019-09-09','2019-09-09'),(19,6,'',30.00,'2019-09-09','2019-09-09'),(20,6,'',30.00,'2019-09-09','2019-09-09'),(21,6,'',30.00,'2019-09-09','2019-09-09'),(22,7,'',20.00,'2019-09-09','2019-09-09'),(23,7,'',20.00,'2019-09-09','2019-09-09'),(24,7,'',20.00,'2019-09-09','2019-09-09'),(25,8,'',75.00,'2019-09-09','2019-09-09'),(26,8,'',75.00,'2019-09-09','2019-09-09'),(27,9,'',75.00,'2019-09-09','2019-09-09'),(28,9,'',75.00,'2019-09-09','2019-09-09'),(29,9,'',75.00,'2019-09-09','2019-09-09'),(30,9,'',75.00,'2019-09-09','2019-09-09'),(31,9,'',75.00,'2019-09-09','2019-09-09'),(32,10,'',210.00,'2019-09-09','2019-09-09'),(33,10,'',210.00,'2019-09-09','2019-09-09'),(34,10,'',210.00,'2019-09-09','2019-09-09'),(35,10,'',210.00,'2019-09-09','2019-09-09'),(36,11,'',120.00,'2019-09-09','2019-09-09'),(37,11,'',120.00,'2019-09-09','2019-09-09'),(38,12,'',110.00,'2019-09-09','2019-09-09'),(39,13,'',115.00,'2019-09-09','2019-09-09'),(40,13,'',115.00,'2019-09-09','2019-09-09'),(41,14,'',300.00,'2019-09-09','2019-09-09'),(42,14,'',300.00,'2019-09-09','2019-09-09'),(43,14,'',300.00,'2019-09-09','2019-09-09'),(44,14,'',300.00,'2019-09-09','2019-09-09'),(45,14,'',300.00,'2019-09-09','2019-09-09'),(46,15,'',27.00,'2019-09-09','2019-09-09'),(47,16,'',27.00,'2019-09-09','2019-09-09'),(48,16,'',27.00,'2019-09-09','2019-09-09'),(49,16,'',27.00,'2019-09-09','2019-09-09'),(50,16,'',27.00,'2019-09-09','2019-09-09'),(51,16,'',27.00,'2019-09-09','2019-09-09'),(52,17,'',27.00,'2019-09-09','2019-09-09'),(53,17,'',27.00,'2019-09-09','2019-09-09'),(54,18,'',27.00,'2019-09-09','2019-09-09'),(55,18,'',27.00,'2019-09-09','2019-09-09'),(56,19,'',120.00,'2019-09-09','2019-09-09'),(57,19,'',120.00,'2019-09-09','2019-09-09'),(58,19,'',120.00,'2019-09-09','2019-09-09'),(59,19,'',120.00,'2019-09-09','2019-09-09'),(60,20,'',35.00,'2019-09-09','2019-09-09'),(61,21,'',20.00,'2019-09-09','2019-09-09'),(62,21,'',20.00,'2019-09-09','2019-09-09'),(63,21,'',20.00,'2019-09-09','2019-09-09'),(64,21,'',20.00,'2019-09-09','2019-09-09'),(65,21,'',20.00,'2019-09-09','2019-09-09'),(66,22,'',50.00,'2019-09-09','2019-09-09'),(67,22,'',50.00,'2019-09-09','2019-09-09'),(68,22,'',50.00,'2019-09-09','2019-09-09'),(69,22,'',50.00,'2019-09-09','2019-09-09'),(70,23,'',12.00,'2019-09-09','2019-09-09'),(71,23,'',12.00,'2019-09-09','2019-09-09'),(72,23,'',12.00,'2019-09-09','2019-09-09'),(73,23,'',12.00,'2019-09-09','2019-09-09'),(74,24,'',14.00,'2019-09-09','2019-09-09'),(75,24,'',14.00,'2019-09-09','2019-09-09'),(76,24,'',14.00,'2019-09-09','2019-09-09'),(77,24,'',14.00,'2019-09-09','2019-09-09'),(78,24,'',14.00,'2019-09-09','2019-09-09'),(79,25,'',392.00,'2019-09-09','2019-09-09'),(80,25,'',392.00,'2019-09-09','2019-09-09'),(81,25,'',392.00,'2019-09-09','2019-09-09'),(82,25,'',392.00,'2019-09-09','2019-09-09'),(83,25,'',392.00,'2019-09-09','2019-09-09'),(84,25,'',392.00,'2019-09-09','2019-09-09'),(85,25,'',392.00,'2019-09-09','2019-09-09'),(86,25,'',392.00,'2019-09-09','2019-09-09'),(87,25,'',392.00,'2019-09-09','2019-09-09'),(88,26,'',165.00,'2019-09-09','2019-09-09'),(89,26,'',165.00,'2019-09-09','2019-09-09'),(90,26,'',165.00,'2019-09-09','2019-09-09'),(91,26,'',165.00,'2019-09-09','2019-09-09'),(92,26,'',165.00,'2019-09-09','2019-09-09'),(93,26,'',165.00,'2019-09-09','2019-09-09'),(94,26,'',165.00,'2019-09-09','2019-09-09'),(95,26,'',165.00,'2019-09-09','2019-09-09'),(96,26,'',165.00,'2019-09-09','2019-09-09'),(97,26,'',165.00,'2019-09-09','2019-09-09'),(98,26,'',165.00,'2019-09-09','2019-09-09'),(99,26,'',165.00,'2019-09-09','2019-09-09'),(100,26,'',165.00,'2019-09-09','2019-09-09'),(101,26,'',165.00,'2019-09-09','2019-09-09'),(102,26,'',165.00,'2019-09-09','2019-09-09'),(103,26,'',165.00,'2019-09-09','2019-09-09'),(104,26,'',165.00,'2019-09-09','2019-09-09'),(105,26,'',165.00,'2019-09-09','2019-09-09'),(106,26,'',165.00,'2019-09-09','2019-09-09'),(107,26,'',165.00,'2019-09-09','2019-09-09'),(108,26,'',165.00,'2019-09-09','2019-09-09'),(109,26,'',165.00,'2019-09-09','2019-09-09'),(110,26,'',165.00,'2019-09-09','2019-09-09'),(111,26,'',165.00,'2019-09-09','2019-09-09'),(112,26,'',165.00,'2019-09-09','2019-09-09'),(113,26,'',165.00,'2019-09-09','2019-09-09'),(114,26,'',165.00,'2019-09-09','2019-09-09'),(115,26,'',165.00,'2019-09-09','2019-09-09'),(116,26,'',165.00,'2019-09-09','2019-09-09'),(117,26,'',165.00,'2019-09-09','2019-09-09'),(118,26,'',165.00,'2019-09-09','2019-09-09'),(119,26,'',165.00,'2019-09-09','2019-09-09'),(120,26,'',165.00,'2019-09-09','2019-09-09'),(121,26,'',165.00,'2019-09-09','2019-09-09'),(122,26,'',165.00,'2019-09-09','2019-09-09'),(123,26,'',165.00,'2019-09-09','2019-09-09'),(124,26,'',165.00,'2019-09-09','2019-09-09'),(125,26,'',165.00,'2019-09-09','2019-09-09'),(126,26,'',165.00,'2019-09-09','2019-09-09'),(127,26,'',165.00,'2019-09-09','2019-09-09'),(128,26,'',165.00,'2019-09-09','2019-09-09'),(129,26,'',165.00,'2019-09-09','2019-09-09'),(130,27,'',250.00,'2019-09-09','2019-09-09'),(131,27,'',250.00,'2019-09-09','2019-09-09'),(132,27,'',250.00,'2019-09-09','2019-09-09'),(133,27,'',250.00,'2019-09-09','2019-09-09'),(134,27,'',250.00,'2019-09-09','2019-09-09'),(135,27,'',250.00,'2019-09-09','2019-09-09'),(136,27,'',250.00,'2019-09-09','2019-09-09'),(137,27,'',250.00,'2019-09-09','2019-09-09'),(138,27,'',250.00,'2019-09-09','2019-09-09'),(139,27,'',250.00,'2019-09-09','2019-09-09'),(140,27,'',250.00,'2019-09-09','2019-09-09'),(141,27,'',250.00,'2019-09-09','2019-09-09'),(142,27,'',250.00,'2019-09-09','2019-09-09'),(143,27,'',250.00,'2019-09-09','2019-09-09'),(144,27,'',250.00,'2019-09-09','2019-09-09'),(145,27,'',250.00,'2019-09-09','2019-09-09'),(146,27,'',250.00,'2019-09-09','2019-09-09'),(147,27,'',250.00,'2019-09-09','2019-09-09'),(148,27,'',250.00,'2019-09-09','2019-09-09'),(149,28,'',5.00,'2019-09-09','2019-09-09'),(150,28,'',5.00,'2019-09-09','2019-09-09'),(151,28,'',5.00,'2019-09-09','2019-09-09'),(152,28,'',5.00,'2019-09-09','2019-09-09'),(153,28,'',5.00,'2019-09-09','2019-09-09'),(154,29,'',1.00,'2019-09-09','2019-09-09'),(155,30,'',3.00,'2019-09-09','2019-09-09'),(156,30,'',3.00,'2019-09-09','2019-09-09'),(157,30,'',3.00,'2019-09-09','2019-09-09'),(158,31,'',3.00,'2019-09-09','2019-09-09'),(159,31,'',3.00,'2019-09-09','2019-09-09'),(160,31,'',3.00,'2019-09-09','2019-09-09'),(161,32,'',123.00,'2019-09-09','2019-09-09'),(162,32,'',123.00,'2019-09-09','2019-09-09'),(163,32,'',123.00,'2019-09-09','2019-09-09'),(164,32,'',123.00,'2019-09-09','2019-09-09'),(165,32,'',123.00,'2019-09-09','2019-09-09'),(166,32,'',123.00,'2019-09-09','2019-09-09'),(167,32,'',123.00,'2019-09-09','2019-09-09'),(168,32,'',123.00,'2019-09-09','2019-09-09'),(169,32,'',123.00,'2019-09-09','2019-09-09'),(170,32,'',123.00,'2019-09-09','2019-09-09'),(171,32,'',123.00,'2019-09-09','2019-09-09'),(172,32,'',123.00,'2019-09-09','2019-09-09'),(173,32,'',123.00,'2019-09-09','2019-09-09'),(174,32,'',123.00,'2019-09-09','2019-09-09'),(175,32,'',123.00,'2019-09-09','2019-09-09'),(176,32,'',123.00,'2019-09-09','2019-09-09'),(177,32,'',123.00,'2019-09-09','2019-09-09'),(178,32,'',123.00,'2019-09-09','2019-09-09'),(179,32,'',123.00,'2019-09-09','2019-09-09'),(180,32,'',123.00,'2019-09-09','2019-09-09'),(181,32,'',123.00,'2019-09-09','2019-09-09'),(182,32,'',123.00,'2019-09-09','2019-09-09'),(183,32,'',123.00,'2019-09-09','2019-09-09'),(184,32,'',123.00,'2019-09-09','2019-09-09'),(185,32,'',123.00,'2019-09-09','2019-09-09'),(186,32,'',123.00,'2019-09-09','2019-09-09'),(187,32,'',123.00,'2019-09-09','2019-09-09'),(188,32,'',123.00,'2019-09-09','2019-09-09'),(189,32,'',123.00,'2019-09-09','2019-09-09'),(190,32,'',123.00,'2019-09-09','2019-09-09'),(191,32,'',123.00,'2019-09-09','2019-09-09'),(192,32,'',123.00,'2019-09-09','2019-09-09'),(193,32,'',123.00,'2019-09-09','2019-09-09'),(194,32,'',123.00,'2019-09-09','2019-09-09'),(195,32,'',123.00,'2019-09-09','2019-09-09'),(196,32,'',123.00,'2019-09-09','2019-09-09'),(197,32,'',123.00,'2019-09-09','2019-09-09'),(198,32,'',123.00,'2019-09-09','2019-09-09'),(199,32,'',123.00,'2019-09-09','2019-09-09'),(200,32,'',123.00,'2019-09-09','2019-09-09'),(201,32,'',123.00,'2019-09-09','2019-09-09'),(202,32,'',123.00,'2019-09-09','2019-09-09'),(203,32,'',123.00,'2019-09-09','2019-09-09'),(204,32,'',123.00,'2019-09-09','2019-09-09'),(205,32,'',123.00,'2019-09-09','2019-09-09'),(206,32,'',123.00,'2019-09-09','2019-09-09'),(207,32,'',123.00,'2019-09-09','2019-09-09'),(208,32,'',123.00,'2019-09-09','2019-09-09'),(209,32,'',123.00,'2019-09-09','2019-09-09'),(210,32,'',123.00,'2019-09-09','2019-09-09'),(211,32,'',123.00,'2019-09-09','2019-09-09'),(212,32,'',123.00,'2019-09-09','2019-09-09'),(213,32,'',123.00,'2019-09-09','2019-09-09'),(214,32,'',123.00,'2019-09-09','2019-09-09'),(215,32,'',123.00,'2019-09-09','2019-09-09'),(216,32,'',123.00,'2019-09-09','2019-09-09'),(217,32,'',123.00,'2019-09-09','2019-09-09'),(218,32,'',123.00,'2019-09-09','2019-09-09'),(219,32,'',123.00,'2019-09-09','2019-09-09'),(220,32,'',123.00,'2019-09-09','2019-09-09'),(221,32,'',123.00,'2019-09-09','2019-09-09'),(222,32,'',123.00,'2019-09-09','2019-09-09'),(223,32,'',123.00,'2019-09-09','2019-09-09'),(224,32,'',123.00,'2019-09-09','2019-09-09'),(225,32,'',123.00,'2019-09-09','2019-09-09'),(226,32,'',123.00,'2019-09-09','2019-09-09'),(227,32,'',123.00,'2019-09-09','2019-09-09'),(228,32,'',123.00,'2019-09-09','2019-09-09'),(229,32,'',123.00,'2019-09-09','2019-09-09'),(230,32,'',123.00,'2019-09-09','2019-09-09'),(231,32,'',123.00,'2019-09-09','2019-09-09'),(232,32,'',123.00,'2019-09-09','2019-09-09'),(233,32,'',123.00,'2019-09-09','2019-09-09'),(234,32,'',123.00,'2019-09-09','2019-09-09'),(235,32,'',123.00,'2019-09-09','2019-09-09'),(236,32,'',123.00,'2019-09-09','2019-09-09'),(237,32,'',123.00,'2019-09-09','2019-09-09'),(238,32,'',123.00,'2019-09-09','2019-09-09'),(239,32,'',123.00,'2019-09-09','2019-09-09'),(240,32,'',123.00,'2019-09-09','2019-09-09'),(241,32,'',123.00,'2019-09-09','2019-09-09'),(242,32,'',123.00,'2019-09-09','2019-09-09'),(243,32,'',123.00,'2019-09-09','2019-09-09'),(244,32,'',123.00,'2019-09-09','2019-09-09'),(245,32,'',123.00,'2019-09-09','2019-09-09'),(246,32,'',123.00,'2019-09-09','2019-09-09'),(247,32,'',123.00,'2019-09-09','2019-09-09'),(248,32,'',123.00,'2019-09-09','2019-09-09'),(249,32,'',123.00,'2019-09-09','2019-09-09'),(250,32,'',123.00,'2019-09-09','2019-09-09'),(251,32,'',123.00,'2019-09-09','2019-09-09'),(252,32,'',123.00,'2019-09-09','2019-09-09'),(253,32,'',123.00,'2019-09-09','2019-09-09'),(254,32,'',123.00,'2019-09-09','2019-09-09'),(255,32,'',123.00,'2019-09-09','2019-09-09'),(256,32,'',123.00,'2019-09-09','2019-09-09'),(257,32,'',123.00,'2019-09-09','2019-09-09'),(258,32,'',123.00,'2019-09-09','2019-09-09'),(259,32,'',123.00,'2019-09-09','2019-09-09'),(260,32,'',123.00,'2019-09-09','2019-09-09'),(261,32,'',123.00,'2019-09-09','2019-09-09'),(262,32,'',123.00,'2019-09-09','2019-09-09'),(263,32,'',123.00,'2019-09-09','2019-09-09'),(264,32,'',123.00,'2019-09-09','2019-09-09'),(265,32,'',123.00,'2019-09-09','2019-09-09'),(266,32,'',123.00,'2019-09-09','2019-09-09'),(267,32,'',123.00,'2019-09-09','2019-09-09'),(268,32,'',123.00,'2019-09-09','2019-09-09'),(269,32,'',123.00,'2019-09-09','2019-09-09'),(270,32,'',123.00,'2019-09-09','2019-09-09'),(271,32,'',123.00,'2019-09-09','2019-09-09'),(272,32,'',123.00,'2019-09-09','2019-09-09'),(273,32,'',123.00,'2019-09-09','2019-09-09'),(274,32,'',123.00,'2019-09-09','2019-09-09'),(275,32,'',123.00,'2019-09-09','2019-09-09'),(276,32,'',123.00,'2019-09-09','2019-09-09'),(277,32,'',123.00,'2019-09-09','2019-09-09'),(278,32,'',123.00,'2019-09-09','2019-09-09'),(279,32,'',123.00,'2019-09-09','2019-09-09'),(280,32,'',123.00,'2019-09-09','2019-09-09'),(281,32,'',123.00,'2019-09-09','2019-09-09'),(282,32,'',123.00,'2019-09-09','2019-09-09'),(283,32,'',123.00,'2019-09-09','2019-09-09');
262/*!40000 ALTER TABLE `inventories` ENABLE KEYS */;
263UNLOCK TABLES;
264
265--
266-- Table structure for table `login_attempts`
267--
268
269DROP TABLE IF EXISTS `login_attempts`;
270/*!40101 SET @saved_cs_client = @@character_set_client */;
271/*!40101 SET character_set_client = utf8 */;
272CREATE TABLE `login_attempts` (
273 `id` varchar(0) DEFAULT NULL,
274 `user_id` varchar(0) DEFAULT NULL,
275 `password` varchar(0) DEFAULT NULL,
276 `created_at` varchar(0) DEFAULT NULL,
277 `updated_at` varchar(0) DEFAULT NULL
278) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
279/*!40101 SET character_set_client = @saved_cs_client */;
280
281--
282-- Dumping data for table `login_attempts`
283--
284
285LOCK TABLES `login_attempts` WRITE;
286/*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
287/*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
288UNLOCK TABLES;
289
290--
291-- Table structure for table `notifications`
292--
293
294DROP TABLE IF EXISTS `notifications`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `notifications` (
298 `id` varchar(0) DEFAULT NULL,
299 `title` varchar(0) DEFAULT NULL,
300 `description` varchar(0) DEFAULT NULL,
301 `viewed` varchar(0) DEFAULT NULL,
302 `created_at` varchar(0) DEFAULT NULL,
303 `updated_at` varchar(0) DEFAULT NULL,
304 `points` varchar(0) DEFAULT NULL
305) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Dumping data for table `notifications`
310--
311
312LOCK TABLES `notifications` WRITE;
313/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
314/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
315UNLOCK TABLES;
316
317--
318-- Table structure for table `order_products`
319--
320
321DROP TABLE IF EXISTS `order_products`;
322/*!40101 SET @saved_cs_client = @@character_set_client */;
323/*!40101 SET character_set_client = utf8 */;
324CREATE TABLE `order_products` (
325 `id` tinyint(4) DEFAULT NULL,
326 `order_id` tinyint(4) DEFAULT NULL,
327 `product_id` tinyint(4) DEFAULT NULL,
328 `quantity` tinyint(4) DEFAULT NULL,
329 `created_at` varchar(10) DEFAULT NULL,
330 `updated_at` varchar(10) DEFAULT NULL
331) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
332/*!40101 SET character_set_client = @saved_cs_client */;
333
334--
335-- Dumping data for table `order_products`
336--
337
338LOCK TABLES `order_products` WRITE;
339/*!40000 ALTER TABLE `order_products` DISABLE KEYS */;
340INSERT INTO `order_products` VALUES (1,4,1,1,'2019-09-09','2019-09-09'),(2,5,2,1,'2019-09-09','2019-09-09');
341/*!40000 ALTER TABLE `order_products` ENABLE KEYS */;
342UNLOCK TABLES;
343
344--
345-- Table structure for table `orders`
346--
347
348DROP TABLE IF EXISTS `orders`;
349/*!40101 SET @saved_cs_client = @@character_set_client */;
350/*!40101 SET character_set_client = utf8 */;
351CREATE TABLE `orders` (
352 `id` tinyint(4) DEFAULT NULL,
353 `user_id` tinyint(4) DEFAULT NULL,
354 `fulfilled_at` varchar(10) DEFAULT NULL,
355 `created_at` varchar(10) DEFAULT NULL,
356 `updated_at` varchar(10) DEFAULT NULL,
357 `item_total` varchar(2) DEFAULT NULL,
358 `shipping` varchar(4) DEFAULT NULL,
359 `tax` varchar(3) DEFAULT NULL,
360 `locked` tinyint(4) DEFAULT NULL,
361 `credit_card_id` varchar(1) DEFAULT NULL,
362 `shipping_address_id` varchar(1) DEFAULT NULL,
363 `billing_address_id` varchar(1) DEFAULT NULL
364) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
365/*!40101 SET character_set_client = @saved_cs_client */;
366
367--
368-- Dumping data for table `orders`
369--
370
371LOCK TABLES `orders` WRITE;
372/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
373INSERT INTO `orders` VALUES (1,10,'','2019-09-09','2019-09-09','','','',0,'','',''),(2,10,'','2019-09-09','2019-09-09','','','',0,'','',''),(3,11,'','2019-09-09','2019-09-09','','','',0,'','',''),(4,10,'','2019-09-09','2019-09-09','','','',0,'','',''),(5,17,'2019-09-09','2019-09-09','2019-09-09','45','4.99','4.5',1,'5','3','3'),(6,17,'','2019-09-09','2019-09-09','','','',0,'','','');
374/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
375UNLOCK TABLES;
376
377--
378-- Table structure for table `products`
379--
380
381DROP TABLE IF EXISTS `products`;
382/*!40101 SET @saved_cs_client = @@character_set_client */;
383/*!40101 SET character_set_client = utf8 */;
384CREATE TABLE `products` (
385 `id` tinyint(4) DEFAULT NULL,
386 `title` varchar(78) DEFAULT NULL,
387 `description` text,
388 `created_at` varchar(10) DEFAULT NULL,
389 `updated_at` varchar(10) DEFAULT NULL,
390 `storefront_id` tinyint(4) DEFAULT NULL,
391 `views` smallint(6) DEFAULT NULL,
392 `hidden` tinyint(4) DEFAULT NULL
393) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
394/*!40101 SET character_set_client = @saved_cs_client */;
395
396--
397-- Dumping data for table `products`
398--
399
400LOCK TABLES `products` WRITE;
401/*!40000 ALTER TABLE `products` DISABLE KEYS */;
402INSERT INTO `products` VALUES (1,'My Apologies! - Classic Board Game','A board game based on the ancient Indian game of Pachisi. Stay ahead while keeping others from progressing. Smash other players\' pawns back to their home while issuing a triumphant \"My Apologies!\" For two to four players.','2019-09-09','2019-09-09',1,100,0),(2,'Corner the Market - Family Board Game','Move around the board while buying and trading properties, develop your properties with houses and hotels, and compete with others to see who can Corner the Market! For two to eight players.','2019-09-09','2019-09-09',1,102,0),(3,'Assorted Artisanal Dice, 30ct','Bring some color to your board game experience with our sampler of artisal dice! Dice come in a variety of colors, materials, and faces.','2019-09-09','2019-09-09',1,100,0),(4,'Not Your Average Teddy','This magical teddy is full of love and other mysteries','2019-09-09','2019-09-09',1,0,1),(5,'Amethyst and Moissanite Ring','Don\'t miss this opportunity to own this gorgeous gemstone ring crafted in silver with a large amethyst centerstone. The ring is accented with Moissanite, an alternative to Diamonds that is harder and more lustrous than cubic zirconia.','2019-09-09','2019-09-09',2,0,0),(6,'Opal Necklace','Made with a teal-blue, opal-like stone, this unique piece has the vibrant opalescence of real opal. Made to order; final product may vary.','2019-09-09','2019-09-09',2,0,0),(7,'Blue Danglies - Dangly Earrings','A fun, cool set of blue dangling earrings.','2019-09-09','2019-09-09',2,0,0),(8,'Basketweave Purse - Woven Underwater™ ','An interesting and unique handwoven purse.','2019-09-09','2019-09-09',2,0,0),(9,'Cool Blue Lennon Sunglasses','A pair of lovely sunglasses with circular lenses. Protects against 99% of UVA and UVB rays. Imagine all the heads you will turn. It\'s easy if you try. It isn\'t hard to do.','2019-09-09','2019-09-09',2,0,0),(10,'Hip Photographer Starterpack - Fashion Kit','Bored of the same old clothes and seeking a fresh new look? Look no further than our Fashion Kits! Everything you need to look like a hip photographer, all in one box!','2019-09-09','2019-09-09',2,0,0),(11,'Bold and Brash - Acrylic Abstract Art Canvas Print (18\" x 25\")','18\" x 25\" print on canvas. \r\n\r\nCERTIFICATE OF AUTHENTICITY:\r\nThe artist will include the encryption key with your order so that you may decrypt this secret phrase to verify your \'original\' work of art: \r\n AAAIHUtJCk8BSANPAk8VEAtJAQEADgxTFR0ZGkUXDAcLUB8MFk5HUxFwVkdB\r\nd1NUDxwGdxwTCgEDEDAN\r\n','2019-09-09','2019-09-09',3,0,0),(12,'More Like Belongs In The Trash - Acrylic Abstract Art Canvas Print (18\" x 25\")','18\" x 25\" print on canvas. \r\n\r\nCERTIFICATE OF AUTHENTICITY:\r\nThe artist will include the encryption key with your order so that you may decrypt this secret phrase to verify your \'original\' work of art: \r\n AAAIHUtJCk8BSANPAk8VEAtJAQEADgxTFR0ZGkUXDAcLUB8MFk5HUxFwVkdB\r\nd1NUDxwGdxwTCgEDEDAN\r\n','2019-09-09','2019-09-09',3,0,0),(13,'The Price of Hubris - Acrylic Abstract Art Canvas Print (18\" x 25\")','18\" x 25\" print on canvas. \r\n\r\nCERTIFICATE OF AUTHENTICITY:\r\nThe artist will include the encryption key with your order so that you may decrypt this secret phrase to verify your \'original\' work of art: \r\n AAAIHUtJCk8BSANPAk8VEAtJAQEADgxTFR0ZGkUXDAcLUB8MFk5HUxFwVkdB\r\nd1NUDxwGdxwTCgEDEDAN\r\n','2019-09-09','2019-09-09',3,0,0),(14,'Dignity - Acrylic Abstract Art Canvas Print (36\" x 48\")','36\" x 48\" print on canvas. \r\n\r\nCERTIFICATE OF AUTHENTICITY:\r\nThe artist will include the encryption key with your order so that you may decrypt this secret phrase to verify your \'original\' work of art: \r\n AAAIHUtJCk8BSANPAk8VEAtJAQEADgxTFR0ZGkUXDAcLUB8MFk5HUxFwVkdB\r\nd1NUDxwGdxwTCgEDEDAN\r\n','2019-09-09','2019-09-09',3,0,0),(15,'Vintage Glass Vase Shabby Chic Rustic 2 pcs.','Unique and trendy vase that looks like a 5-gallon jug for water coolers. Keywords: shabby chic rustic home decor vase vintage modern hip trendy glass hand-crafted artisan artisanal','2019-09-09','2019-09-09',3,0,0),(16,'Faux Wool CozyRug - Area Rug (5\' x 7\')','Make any living space extra cozy with this faux wool CozyRug, our line of area rugs that are made with synthetic and plant-based materials that doesn\'t harm animals. Keywords: home decor rugs area rugs floor rugs vegan','2019-09-09','2019-09-09',3,0,0),(17,'Floor Rug (9\' x 12\')','Our floor rugs are made of synthetic and plant-based materials. Our synthetic materials are manufactured with sustainability in mind, and we never use animal products in any of our products. Keywords: home decor rugs area rugs floor rugs vegan','2019-09-09','2019-09-09',3,0,0),(18,'Linen Canvas - True Art Canvas (20\" x 24\")','Hand-stretched linen canvas. Made by artists, for artists.','2019-09-09','2019-09-09',4,0,0),(19,'Studio Easel - Great Value!','A basic studio easel, perfect for beginners and professionals alike. Our manufacturing techniques keep prices low, but like artists such as you, we never compromise on quality! Great for art classes.','2019-09-09','2019-09-09',4,0,0),(20,'Acrylic Paint Set (24 pc.)','Artist Acrylic Paint tubes, set of 24. Good for beginner-to-intermediate painters, with a solid choice of primary and secondary colors, plus an additional set of tones for landscapes and portraits.','2019-09-09','2019-09-09',4,0,0),(21,'Blue Knot Got Me Down - Photo Print (18\" x 25\")','Taken by Captain Jack\'s own vessel by his fist mate after received his new camera','2019-09-09','2019-09-09',5,0,0),(22,'Set of Two (2) Vintage Buoys','Set of two vintage buoys. Perfect to hang in your nautical bathroom or boathouse! Recycled from use on Captain Jack\'s previous vessel.','2019-09-09','2019-09-09',5,0,0),(23,'Man Doing Flag Routine - Photo Print (18\" x 25\")','Man doing dance routine to a song by the Sema 4\'s','2019-09-09','2019-09-09',5,0,0),(24,'Nautical Flags in Order - Photo Print (27\" x 8\")','Graphic print fitting for a bathroom or an office. Nautical flags can mean so many things so the order is important to not crash any boats.','2019-09-09','2019-09-09',5,0,0),(25,'Oversize sweater. Merino wool. Cozy, warm, smooth.','Set the trend this season with our stylish and comfy chunky must-have sweater.\r\n Wrap yourself up in the finest merino wool and go paint the wintry days in the color of your mood... gray!','2019-09-09','2019-09-09',6,14,0),(26,'Ossio Small White Braid 10 Meters','Ossio vegan yarn. It\'s easy to use, holds its shape well, and can be cleaned in a washing machine.','2019-09-09','2019-09-09',6,3,0),(27,'Ossio\'s Grande Punto blanket. Chunky blanket. Merino wool.','Ossio Blanket is is a great way to keep warm together. This chunky knit is a perfect excuse to cuddle with someone.\r\n This product is made from fine merino wool. It’s hypoallergenic, safe for children and animals. ','2019-09-09','2019-09-09',6,0,0),(28,'asdf','','2019-09-09','2019-09-09',7,19,0),(29,'asdf','','2019-09-09','2019-09-09',7,1,0),(30,'sdfg','','2019-09-09','2019-09-09',7,0,0),(31,'sdfg','','2019-09-09','2019-09-09',7,0,0),(32,'asdfasdf','','2019-09-09','2019-09-09',7,0,0);
403/*!40000 ALTER TABLE `products` ENABLE KEYS */;
404UNLOCK TABLES;
405
406--
407-- Table structure for table `schema_migrations`
408--
409
410DROP TABLE IF EXISTS `schema_migrations`;
411/*!40101 SET @saved_cs_client = @@character_set_client */;
412/*!40101 SET character_set_client = utf8 */;
413CREATE TABLE `schema_migrations` (
414 `version` bigint(20) DEFAULT NULL
415) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
416/*!40101 SET character_set_client = @saved_cs_client */;
417
418--
419-- Dumping data for table `schema_migrations`
420--
421
422LOCK TABLES `schema_migrations` WRITE;
423/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
424INSERT INTO `schema_migrations` VALUES (20180913223144),(20180924224050),(20181019214053),(20181019214138),(20181019214758),(20181019214908),(20181019214935),(20181102223427),(20181108202206),(20181116181538),(20181128023024),(20181128201523),(20181201000103),(20181201004351),(20181201004458),(20181214035426),(20181217235208),(20181218020721),(20181221102355),(20181227121303),(20190102230526),(20190112014556),(20190118222414),(20190122235131),(20190207234354),(20190216015931),(20190221211745),(20190225234813);
425/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
426UNLOCK TABLES;
427
428--
429-- Table structure for table `sqlite_sequence`
430--
431
432DROP TABLE IF EXISTS `sqlite_sequence`;
433/*!40101 SET @saved_cs_client = @@character_set_client */;
434/*!40101 SET character_set_client = utf8 */;
435CREATE TABLE `sqlite_sequence` (
436 `name` varchar(26) DEFAULT NULL,
437 `seq` smallint(6) DEFAULT NULL
438) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
439/*!40101 SET character_set_client = @saved_cs_client */;
440
441--
442-- Dumping data for table `sqlite_sequence`
443--
444
445LOCK TABLES `sqlite_sequence` WRITE;
446/*!40000 ALTER TABLE `sqlite_sequence` DISABLE KEYS */;
447INSERT INTO `sqlite_sequence` VALUES ('categories',9),('users',17),('storefronts',7),('active_storage_blobs',32),('active_storage_attachments',32),('products',32),('inventories',283),('category_products',46),('orders',6),('order_products',2),('credit_cards',5),('addresses',3);
448/*!40000 ALTER TABLE `sqlite_sequence` ENABLE KEYS */;
449UNLOCK TABLES;
450
451--
452-- Table structure for table `storefronts`
453--
454
455DROP TABLE IF EXISTS `storefronts`;
456/*!40101 SET @saved_cs_client = @@character_set_client */;
457/*!40101 SET character_set_client = utf8 */;
458CREATE TABLE `storefronts` (
459 `id` tinyint(4) DEFAULT NULL,
460 `title` varchar(44) DEFAULT NULL,
461 `user_id` tinyint(4) DEFAULT NULL,
462 `created_at` varchar(10) DEFAULT NULL,
463 `updated_at` varchar(10) DEFAULT NULL
464) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
465/*!40101 SET character_set_client = @saved_cs_client */;
466
467--
468-- Dumping data for table `storefronts`
469--
470
471LOCK TABLES `storefronts` WRITE;
472/*!40000 ALTER TABLE `storefronts` DISABLE KEYS */;
473INSERT INTO `storefronts` VALUES (1,'Danny\'s Boardgame Emporium',10,'2019-09-09','2019-09-09'),(2,'Incredible Fashion and Jewelry',11,'2019-09-09','2019-09-09'),(3,'Postmodernistic-expialidocious Decor and Art',12,'2019-09-09','2019-09-09'),(4,'True Art Canvas and Supplies',13,'2019-09-09','2019-09-09'),(5,'Captain Jack\'s Nautical Emporium',14,'2019-09-09','2019-09-09'),(6,'Ossio',15,'2019-09-09','2019-09-09'),(7,'Dat Bois Store',17,'2019-09-09','2019-09-09');
474/*!40000 ALTER TABLE `storefronts` ENABLE KEYS */;
475UNLOCK TABLES;
476
477--
478-- Table structure for table `users`
479--
480
481DROP TABLE IF EXISTS `users`;
482/*!40101 SET @saved_cs_client = @@character_set_client */;
483/*!40101 SET character_set_client = utf8 */;
484CREATE TABLE `users` (
485 `id` tinyint(4) DEFAULT NULL,
486 `provider` varchar(5) DEFAULT NULL,
487 `uid` varchar(22) DEFAULT NULL,
488 `encrypted_password` varchar(32) DEFAULT NULL,
489 `locked_at` varchar(0) DEFAULT NULL,
490 `name` varchar(17) DEFAULT NULL,
491 `nickname` varchar(13) DEFAULT NULL,
492 `image` varchar(0) DEFAULT NULL,
493 `email` varchar(22) DEFAULT NULL,
494 `tokens` varchar(2) DEFAULT NULL,
495 `created_at` varchar(10) DEFAULT NULL,
496 `updated_at` varchar(10) DEFAULT NULL,
497 `admin` tinyint(4) DEFAULT NULL,
498 `balance` tinyint(4) DEFAULT NULL,
499 `password_reset_token` varchar(0) DEFAULT NULL,
500 `password_reset_sent_at` varchar(0) DEFAULT NULL,
501 `password_salt` varchar(0) DEFAULT NULL,
502 `website_url` varchar(0) DEFAULT NULL
503) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
504/*!40101 SET character_set_client = @saved_cs_client */;
505
506--
507-- Dumping data for table `users`
508--
509
510LOCK TABLES `users` WRITE;
511/*!40000 ALTER TABLE `users` DISABLE KEYS */;
512INSERT INTO `users` VALUES (9,'email','test@test.com','16d7a4fca7442dda3ad93c9a726597e4','','Testy McTesterson','TazerFace','','test@test.com','{}','2019-09-09','2019-09-09',0,0,'','','',''),(10,'email','danryan@forescient.com','2654ed3261e2e798bf12ec917353dfb1','','Dan Ryan','Danny','','danryan@forescient.com','{}','2019-09-09','2019-09-09',0,0,'','','',''),(11,'email','ednamode@forescient.co','4ca4abd39ee6c423044266f2ffeb8b6e','','Edna Mode','Edna Mode','','ednamode@forescient.co','{}','2019-09-09','2019-09-09',0,0,'','','',''),(12,'email','tmasardi@forescient.co','6dfe96c78a3332e523037591d4771b36','','Terri Masardi','Masardi','','tmasardi@forescient.co','{}','2019-09-09','2019-09-09',0,0,'','','',''),(13,'email','aaguilar@forescient.co','4831df3cf1c757bde95c0b9d49e3d1f2','','Alejandro Aguilar','AlejAgra','','aaguilar@forescient.co','{}','2019-09-09','2019-09-09',0,0,'','','',''),(14,'email','captainjack@forescient','77063bea8de38818fb5457940256b1da','','Captain Jack','Captain Jack','','captainjack@forescient','{}','2019-09-09','2019-09-09',0,0,'','','',''),(15,'email','ossio@forescient.com','2516e2afcc5ca60d9f02f13c347b6297','','Osica La Clara','Ossio','','ossio@forescient.com','{}','2019-09-09','2019-09-09',0,0,'','','',''),(16,'email','admin@forescient.com','16d7a4fca7442dda3ad93c9a726597e4','','all powerful','Administrator','','admin@forescient.com','{}','2019-09-09','2019-09-09',1,0,'','','',''),(17,'email','mhamerhead@forescient.','E5A36Bz07-243T5ccc3b0','','Marty','Hammerhead','','mhamerhead@forescient.','{}','2019-09-09','2019-09-09',0,0,'','','','');
513/*!40000 ALTER TABLE `users` ENABLE KEYS */;
514UNLOCK TABLES;
515/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
516
517/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
518/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
519/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
520/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
521/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
522/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
523/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
524
525-- Dump completed on 2020-03-06 12:00:42