· 5 years ago · May 31, 2020, 07:34 AM
1-- MySQL dump 10.13 Distrib 5.6.38, for Win64 (x86_64)
2--
3-- Host: localhost Database: eshop
4-- ------------------------------------------------------
5-- Server version 5.6.38
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-- Current Database: `eshop`
20--
21DROP DATABASE IF EXISTS eshop;
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `eshop` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `eshop`;
25
26--
27-- Table structure for table `books`
28--
29
30DROP TABLE IF EXISTS `books`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `books` (
34 `idbook` int(11) NOT NULL AUTO_INCREMENT,
35 `title` varchar(100) NOT NULL DEFAULT '',
36 `price` decimal(6,2) NOT NULL DEFAULT '0.00',
37 `author` varchar(45) NOT NULL,
38 `pubyear` varchar(45) NOT NULL,
39 PRIMARY KEY (`idbook`)
40) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `books`
45--
46
47LOCK TABLES `books` WRITE;
48/*!40000 ALTER TABLE `books` DISABLE KEYS */;
49-- INSERT INTO `books` VALUES (5,'dssdfsdf',345.00,'',''),(6,'hgjghj ghj ghj g',4545.00,'',''),(7,'sdffgh jjkfgjfg jh',23.00,'',''),(8,'qqqqqqq',9999.99,'',''),(9,'qwerty',9999.99,'',''),(10,'zzz',555.00,'','');
50/*!40000 ALTER TABLE `books` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `feedback`
55--
56
57DROP TABLE IF EXISTS `feedback`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `feedback` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `typeQuestion` smallint(6) NOT NULL,
63 `message` varchar(400) NOT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `feedback`
70--
71
72LOCK TABLES `feedback` WRITE;
73/*!40000 ALTER TABLE `feedback` DISABLE KEYS */;
74INSERT INTO `feedback` VALUES (4,1,'dgdfgdfg '),(5,1,'Ехал Грека через реку'),(6,1,'Видит Грека рак'),(7,1,'вап впва павп');
75/*!40000 ALTER TABLE `feedback` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `orders`
80--
81
82DROP TABLE IF EXISTS `orders`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `orders` (
86 `idorders` int(11) NOT NULL AUTO_INCREMENT,
87 `fio` varchar(45) DEFAULT NULL,
88 `phone` varchar(45) NOT NULL,
89 `email` varchar(45) NOT NULL,
90 `address` varchar(100) DEFAULT NULL,
91 `dt` datetime NOT NULL,
92 PRIMARY KEY (`idorders`)
93) ENGINE=InnoDB DEFAULT CHARSET=utf8;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Dumping data for table `orders`
98--
99
100LOCK TABLES `orders` WRITE;
101/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
102/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `orders_has_books`
107--
108
109DROP TABLE IF EXISTS `orders_has_books`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `orders_has_books` (
113 `orders_idorders` int(11) NOT NULL,
114 `books_idbook` int(11) NOT NULL,
115 `qty` tinyint(4) NOT NULL DEFAULT '1',
116 PRIMARY KEY (`orders_idorders`,`books_idbook`),
117 KEY `fk_orders_has_books_books1_idx` (`books_idbook`),
118 KEY `fk_orders_has_books_orders_idx` (`orders_idorders`),
119 CONSTRAINT `fk_orders_has_books_books1` FOREIGN KEY (`books_idbook`) REFERENCES `books` (`idbook`) ON DELETE NO ACTION ON UPDATE NO ACTION,
120 CONSTRAINT `fk_orders_has_books_orders` FOREIGN KEY (`orders_idorders`) REFERENCES `orders` (`idorders`) ON DELETE NO ACTION ON UPDATE NO ACTION
121) ENGINE=InnoDB DEFAULT CHARSET=utf8;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `orders_has_books`
126--
127
128LOCK TABLES `orders_has_books` WRITE;
129/*!40000 ALTER TABLE `orders_has_books` DISABLE KEYS */;
130/*!40000 ALTER TABLE `orders_has_books` ENABLE KEYS */;
131UNLOCK TABLES;
132/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
133
134/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
135/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
136/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
137/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
138/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
139/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
140/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
141
142-- Dump completed on 2020-05-31 10:28:47