6Xgk5mQj

1-- MySQL dump 10.16  Distrib 10.1.25-MariaDB, for Win32 (AMD64)
2--
3-- Host: localhost    Database: flowershop
4-- ------------------------------------------------------
5-- Server version	10.1.25-MariaDB
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 `flowershop_categories`
20--
21
22DROP TABLE IF EXISTS `flowershop_categories`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `flowershop_categories` (
26  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
27  `title` varchar(45) DEFAULT NULL,
28  `description` text,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `flowershop_categories`
35--
36
37LOCK TABLES `flowershop_categories` WRITE;
38/*!40000 ALTER TABLE `flowershop_categories` DISABLE KEYS */;
39INSERT INTO `flowershop_categories` VALUES (1,'Buckets',NULL),(2,'Green',NULL);
40/*!40000 ALTER TABLE `flowershop_categories` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `flowershop_flower_types`
45--
46
47DROP TABLE IF EXISTS `flowershop_flower_types`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `flowershop_flower_types` (
51  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
52  `title` varchar(45) DEFAULT NULL,
53  `description` text,
54  PRIMARY KEY (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Dumping data for table `flowershop_flower_types`
60--
61
62LOCK TABLES `flowershop_flower_types` WRITE;
63/*!40000 ALTER TABLE `flowershop_flower_types` DISABLE KEYS */;
64INSERT INTO `flowershop_flower_types` VALUES (1,'Roses',NULL),(2,'Tulips',NULL),(3,'Wild',NULL);
65/*!40000 ALTER TABLE `flowershop_flower_types` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `flowershop_products`
70--
71
72DROP TABLE IF EXISTS `flowershop_products`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `flowershop_products` (
76  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
77  `cat_id` tinyint(3) unsigned DEFAULT NULL,
78  `title` varchar(100) DEFAULT NULL,
79  `description` text,
80  `price` decimal(10,0) unsigned DEFAULT NULL,
81  `img` varchar(100) DEFAULT NULL,
82  PRIMARY KEY (`id`)
83) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `flowershop_products`
88--
89
90LOCK TABLES `flowershop_products` WRITE;
91/*!40000 ALTER TABLE `flowershop_products` DISABLE KEYS */;
92INSERT INTO `flowershop_products` VALUES (1,2,'crab','Supe<?php echo \"Hello\"?>',9999999999,'1.jpg'),(2,0,'Tulips bouquet','Super Bucket descriptio',460,'http://www.obradoval.ru/resources/fotogr/2012_01/fde198eca29b244_main_foto460.jpg'),(3,2,'100 tulips','Super Bucket descripti',1000,'http://picdom.ru/i/400/6/d/e3c0de0f5.jpg'),(4,0,'50 roses','Super Bucket descriptio',1500,'4.jpg'),(5,0,'Carnations bouquet','Super Bucket descriptio',1500,'5.jpg'),(6,0,'Super Bucket','Super Bucket descriptio',1500,'6.jpg'),(7,0,'Super Bucket','Super Bucket descriptio',1500,'7.jpg'),(8,0,'Super Bucket','Super Bucket description\'',1500,'10.jpg');
93/*!40000 ALTER TABLE `flowershop_products` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `flowershop_products_types`
98--
99
100DROP TABLE IF EXISTS `flowershop_products_types`;
101/*!40101 SET @saved_cs_client     = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `flowershop_products_types` (
104  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
105  `product_id` tinyint(3) unsigned DEFAULT NULL,
106  `type_id` tinyint(3) unsigned DEFAULT NULL,
107  PRIMARY KEY (`id`),
108  UNIQUE KEY `i__type_product` (`product_id`,`type_id`)
109) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `flowershop_products_types`
114--
115
116LOCK TABLES `flowershop_products_types` WRITE;
117/*!40000 ALTER TABLE `flowershop_products_types` DISABLE KEYS */;
118INSERT INTO `flowershop_products_types` VALUES (1,1,1),(2,2,2),(3,3,1),(4,4,1);
119/*!40000 ALTER TABLE `flowershop_products_types` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `users`
124--
125
126DROP TABLE IF EXISTS `users`;
127/*!40101 SET @saved_cs_client     = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `users` (
130  `id` smallint(5) unsigned NOT NULL,
131  `email` varchar(100) DEFAULT NULL,
132  `password` char(32) DEFAULT NULL,
133  `role_id` tinyint(1) unsigned DEFAULT NULL,
134  `is_active` tinyint(1) DEFAULT NULL,
135  `date_reg` timestamp NULL DEFAULT NULL,
136  `last_login` timestamp NULL DEFAULT NULL,
137  PRIMARY KEY (`id`)
138) ENGINE=InnoDB DEFAULT CHARSET=utf8;
139/*!40101 SET character_set_client = @saved_cs_client */;
140
141--
142-- Dumping data for table `users`
143--
144
145LOCK TABLES `users` WRITE;
146/*!40000 ALTER TABLE `users` DISABLE KEYS */;
147INSERT INTO `users` VALUES (1,'admin@admin.com','e10adc3949ba59abbe56e057f20f883e',1,1,'2018-11-07 22:00:00','2018-11-07 22:00:00');
148/*!40000 ALTER TABLE `users` ENABLE KEYS */;
149UNLOCK TABLES;
150/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
151
152/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
153/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
154/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
155/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
156/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
157/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
158/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
159
160-- Dump completed on 2018-11-07 19:51:36