PNyHYMvM

1CREATE DATABASE  IF NOT EXISTS `dotnet-shop` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
2USE `dotnet-shop`;
3-- MySQL dump 10.17  Distrib 10.3.22-MariaDB, for debian-linux-gnu (x86_64)
4--
5-- Host: 127.0.0.1    Database: dotnet-shop
6-- ------------------------------------------------------
7-- Server version	10.3.22-MariaDB-1ubuntu1
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `category`
22--
23
24DROP TABLE IF EXISTS `category`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `category` (
28  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29  `title` varchar(20) NOT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE KEY `title_UNIQUE` (`title`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Table structure for table `category_product`
37--
38
39DROP TABLE IF EXISTS `category_product`;
40/*!40101 SET @saved_cs_client     = @@character_set_client */;
41/*!40101 SET character_set_client = utf8 */;
42CREATE TABLE `category_product` (
43  `product_id` int(10) unsigned NOT NULL,
44  `category_id` int(10) unsigned NOT NULL,
45  PRIMARY KEY (`product_id`,`category_id`),
46  KEY `fk_category_product_category_id` (`category_id`),
47  CONSTRAINT `fk_category_product_category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
48  CONSTRAINT `fk_category_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
50/*!40101 SET character_set_client = @saved_cs_client */;
51
52--
53-- Table structure for table `customer`
54--
55
56DROP TABLE IF EXISTS `customer`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `customer` (
60  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
61  `first_name` varchar(50) NOT NULL,
62  `last_name` varchar(50) NOT NULL,
63  PRIMARY KEY (`id`)
64) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Table structure for table `order`
69--
70
71DROP TABLE IF EXISTS `order`;
72/*!40101 SET @saved_cs_client     = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `order` (
75  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
76  `customer_id` int(10) unsigned NOT NULL,
77  PRIMARY KEY (`id`),
78  KEY `fk_order_customer_id` (`customer_id`),
79  CONSTRAINT `fk_order_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
80) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Table structure for table `order_product`
85--
86
87DROP TABLE IF EXISTS `order_product`;
88/*!40101 SET @saved_cs_client     = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `order_product` (
91  `order_id` int(10) unsigned NOT NULL,
92  `product_id` int(10) unsigned NOT NULL,
93  `amount` int(10) unsigned NOT NULL,
94  PRIMARY KEY (`order_id`,`product_id`),
95  KEY `fk_order_product_product_id` (`product_id`),
96  CONSTRAINT `fk_order_product_order_id` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
97  CONSTRAINT `fk_order_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
98) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Table structure for table `product`
103--
104
105DROP TABLE IF EXISTS `product`;
106/*!40101 SET @saved_cs_client     = @@character_set_client */;
107/*!40101 SET character_set_client = utf8 */;
108CREATE TABLE `product` (
109  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
110  `vendor_id` int(10) unsigned NOT NULL,
111  `title` varchar(50) NOT NULL,
112  `price` decimal(10,2) unsigned NOT NULL,
113  PRIMARY KEY (`id`),
114  UNIQUE KEY `vendor_product_title_UNIQUE` (`vendor_id`,`title`),
115  CONSTRAINT `fk_product_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `vendor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
116) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Table structure for table `vendor`
121--
122
123DROP TABLE IF EXISTS `vendor`;
124/*!40101 SET @saved_cs_client     = @@character_set_client */;
125/*!40101 SET character_set_client = utf8 */;
126CREATE TABLE `vendor` (
127  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
128  `name` varchar(50) NOT NULL,
129  PRIMARY KEY (`id`),
130  UNIQUE KEY `name_UNIQUE` (`name`)
131) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping events for database 'dotnet-shop'
136--
137
138--
139-- Dumping routines for database 'dotnet-shop'
140--
141/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
142
143/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
144/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
145/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
146/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
147/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
148/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
149/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
150
151-- Dump completed on 2020-06-08 19:50:35