C9k7bWQT

1— MySQL Script generated by MySQL Workbench
2— Ср 03 мар 2021 17:57:54
3— Model: New Model Version: 1.0
4— MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10— —---------------------------------------------------
11— Schema mydb
12— —---------------------------------------------------
13
14— —---------------------------------------------------
15— Schema mydb
16— —---------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20— —---------------------------------------------------
21— Table `mydb`.`users`
22— —---------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`users` (
24`id` INT NOT NULL AUTO_INCREMENT,
25`fio` VARCHAR(255) NOT NULL,
26`login` VARCHAR(255) NULL,
27`password` VARCHAR(255) NULL,
28`e_mail` VARCHAR(255) NULL,
29`type` VARCHAR(45) NULL,
30PRIMARY KEY (`id`, `fio`),
31UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
32UNIQUE INDEX `login_UNIQUE` (`login` ASC) VISIBLE)
33ENGINE = InnoDB;
34
35— —---------------------------------------------------
36— Table `mydb`.`settings`
37— —---------------------------------------------------
38CREATE TABLE IF NOT EXISTS `mydb`.`settings` (
39`id` INT NOT NULL,
40`host` VARCHAR(45) NULL,
41`db` VARCHAR(45) NULL,
42`user` VARCHAR(45) NULL,
43PRIMARY KEY (`id`))
44ENGINE = InnoDB;
45
46— —---------------------------------------------------
47— Table `mydb`.`Shops`
48— —---------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`Shops` (
50`id` INT NOT NULL AUTO_INCREMENT,
51`name` VARCHAR(255) NULL,
52`adress` VARCHAR(255) NULL,
53`tel` VARCHAR(100) NULL,
54`site` VARCHAR(100) NULL,
55`email` VARCHAR(100) NULL,
56PRIMARY KEY (`id`),
57UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE)
58ENGINE = InnoDB;
59
60— —---------------------------------------------------
61— Table `mydb`.`product_type`
62— —---------------------------------------------------
63CREATE TABLE IF NOT EXISTS `mydb`.`product_type` (
64`id` INT NOT NULL,
65`name` VARCHAR(255) NULL,
66PRIMARY KEY (`id`))
67ENGINE = InnoDB;
68
69— —---------------------------------------------------
70— Table `mydb`.`Products`
71— —---------------------------------------------------
72CREATE TABLE IF NOT EXISTS `mydb`.`Products` (
73`id` INT NOT NULL,
74`shop_id` INT NOT NULL,
75`type_id` INT NOT NULL,
76`brand` VARCHAR(255) NULL,
77`model` VARCHAR(255) NULL,
78`data` TINYTEXT NULL,
79`img` VARCHAR(255) NULL,
80`price` VARCHAR(45) NULL,
81`warranty` VARCHAR(45) NULL,
82PRIMARY KEY (`id`, `shop_id`, `type_id`),
83INDEX `shop_to_products_idx` (`shop_id` ASC) VISIBLE,
84CONSTRAINT `shop_to_products`
85FOREIGN KEY (`shop_id`)
86REFERENCES `mydb`.`Shops` (`id`)
87ON DELETE NO ACTION
88ON UPDATE NO ACTION,
89CONSTRAINT `product_to_type`
90FOREIGN KEY (`type_id`)
91REFERENCES `mydb`.`product_type` (`id`)
92ON DELETE NO ACTION
93ON UPDATE NO ACTION)
94ENGINE = InnoDB;
95
96— —---------------------------------------------------
97— Table `mydb`.`Orders`
98— —---------------------------------------------------
99CREATE TABLE IF NOT EXISTS `mydb`.`Orders` (
100`id` INT NOT NULL AUTO_INCREMENT,
101`shop_id` INT NOT NULL,
102`product_id` INT NOT NULL,
103`fio` INT NOT NULL,
104`date` DATE NULL,
105`quantity` TINYINT NULL,
106`tel` VARCHAR(255) NULL,
107`confirm` TINYINT(1) NULL,
108PRIMARY KEY (`id`, `shop_id`, `product_id`, `fio`),
109UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
110INDEX `orders_to_shops_idx` (`shop_id` ASC) VISIBLE,
111INDEX `orders_to_products_idx` (`product_id` ASC) VISIBLE,
112INDEX `orders_to_users_idx` (`fio` ASC) VISIBLE,
113CONSTRAINT `orders_to_shops`
114FOREIGN KEY (`shop_id`)
115REFERENCES `mydb`.`Shops` (`id`)
116ON DELETE NO ACTION
117ON UPDATE NO ACTION,
118CONSTRAINT `orders_to_products`
119FOREIGN KEY (`product_id`)
120REFERENCES `mydb`.`Products` (`id`)
121ON DELETE NO ACTION
122ON UPDATE NO ACTION,
123CONSTRAINT `orders_to_users`
124 
125FOREIGN KEY (`fio`)
126REFERENCES `mydb`.`users` (`id`)
127ON DELETE NO ACTION
128ON UPDATE NO ACTION)
129ENGINE = InnoDB;
130
131— —---------------------------------------------------
132— Table `mydb`.`Deliveries`
133— —---------------------------------------------------
134CREATE TABLE IF NOT EXISTS `mydb`.`Deliveries` (
135`order_id` INT NOT NULL AUTO_INCREMENT,
136`fio` INT NOT NULL,
137`adress` VARCHAR(45) NULL,
138`date` DATE NULL,
139`confirm` TINYINT(1) NULL,
140PRIMARY KEY (`order_id`, `fio`),
141UNIQUE INDEX `order_id_UNIQUE` (`order_id` ASC) VISIBLE,
142INDEX `deliveries_to_orders_idx` (`fio` ASC) VISIBLE,
143CONSTRAINT `deliveries_to_orders`
144FOREIGN KEY (`order_id`)
145REFERENCES `mydb`.`Orders` (`id`)
146ON DELETE NO ACTION
147ON UPDATE NO ACTION,
148CONSTRAINT `deliveries_to_orders`
149FOREIGN KEY (`fio`)
150REFERENCES `mydb`.`Orders` (`fio`)
151ON DELETE NO ACTION
152ON UPDATE NO ACTION)
153ENGINE = InnoDB;
154
155SET SQL_MODE=@OLD_SQL_MODE;
156SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
157SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
158No file chosen
159Ещё
160