· 4 years ago · Jun 23, 2021, 09:02 AM
1-- MySQL Script generated by MySQL Workbench
2-- Wed Jun 23 16:34:02 2021
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 WorldOfTank
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `WorldOfTank` ;
14
15-- -----------------------------------------------------
16-- Schema WorldOfTank
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `WorldOfTank` DEFAULT CHARACTER SET utf8 ;
19USE `WorldOfTank` ;
20
21-- -----------------------------------------------------
22-- Table `WorldOfTank`.`table1`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `WorldOfTank`.`table1` (
25)
26ENGINE = InnoDB;
27
28
29-- -----------------------------------------------------
30-- Table `WorldOfTank`.`tank_armor_information`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `WorldOfTank`.`tank_armor_information` (
33 `id` INT NOT NULL AUTO_INCREMENT,
34 `body_front` INT NULL,
35 `body_side` INT NULL,
36 `body_rear` INT NULL,
37 `turret_front` INT NULL,
38 `turret_side` INT NULL,
39 `turret_rear` INT NULL,
40 PRIMARY KEY (`id`))
41ENGINE = InnoDB
42DEFAULT CHARACTER SET = utf8;
43
44
45-- -----------------------------------------------------
46-- Table `WorldOfTank`.`tank_weapon_information`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `WorldOfTank`.`tank_weapon_information` (
49 `id` INT NOT NULL AUTO_INCREMENT,
50 `main_gun` VARCHAR(45) NULL,
51 `multiple_turret` TINYINT NULL,
52 `coaxis_gun` VARCHAR(45) NULL,
53 `hull_attached_gun` VARCHAR(45) NULL,
54 PRIMARY KEY (`id`))
55ENGINE = InnoDB
56DEFAULT CHARACTER SET = utf8;
57
58
59-- -----------------------------------------------------
60-- Table `WorldOfTank`.`image`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `WorldOfTank`.`image` (
63 `id` INT NOT NULL AUTO_INCREMENT,
64 `image` VARCHAR(255) NULL,
65 `description` VARCHAR(255) NULL,
66 PRIMARY KEY (`id`))
67ENGINE = InnoDB
68DEFAULT CHARACTER SET = utf8;
69
70
71-- -----------------------------------------------------
72-- Table `WorldOfTank`.`tank_basic_information`
73-- -----------------------------------------------------
74CREATE TABLE IF NOT EXISTS `WorldOfTank`.`tank_basic_information` (
75 `id` INT NOT NULL AUTO_INCREMENT,
76 `name` VARCHAR(45) NOT NULL,
77 `nation` VARCHAR(45) NOT NULL,
78 `year` INT NULL,
79 `height` INT NULL,
80 `width` INT NULL,
81 `depth` INT NULL,
82 `produced_number` INT NULL,
83 `tank_armor_information_id` INT NOT NULL,
84 `tank_weapon_information_id` INT NOT NULL,
85 `image_id` INT NOT NULL,
86 PRIMARY KEY (`id`),
87 INDEX `fk_tank_basic_information_tank_armor_information_idx` (`tank_armor_information_id` ASC) VISIBLE,
88 INDEX `fk_tank_basic_information_tank_weapon_information1_idx` (`tank_weapon_information_id` ASC) VISIBLE,
89 INDEX `fk_tank_basic_information_image1_idx` (`image_id` ASC) VISIBLE,
90 CONSTRAINT `fk_tank_basic_information_tank_armor_information`
91 FOREIGN KEY (`tank_armor_information_id`)
92 REFERENCES `WorldOfTank`.`tank_armor_information` (`id`)
93 ON DELETE NO ACTION
94 ON UPDATE NO ACTION,
95 CONSTRAINT `fk_tank_basic_information_tank_weapon_information1`
96 FOREIGN KEY (`tank_weapon_information_id`)
97 REFERENCES `WorldOfTank`.`tank_weapon_information` (`id`)
98 ON DELETE NO ACTION
99 ON UPDATE NO ACTION,
100 CONSTRAINT `fk_tank_basic_information_image1`
101 FOREIGN KEY (`image_id`)
102 REFERENCES `WorldOfTank`.`image` (`id`)
103 ON DELETE NO ACTION
104 ON UPDATE NO ACTION)
105ENGINE = InnoDB
106DEFAULT CHARACTER SET = utf8;
107
108
109-- -----------------------------------------------------
110-- Table `WorldOfTank`.`tank_used_shell`
111-- -----------------------------------------------------
112CREATE TABLE IF NOT EXISTS `WorldOfTank`.`tank_used_shell` (
113 `id` INT NOT NULL AUTO_INCREMENT,
114 `shell_info` VARCHAR(45) NULL,
115 `tank_weapon_information_id` INT NOT NULL,
116 PRIMARY KEY (`id`),
117 INDEX `fk_tank_used_shell_tank_weapon_information1_idx` (`tank_weapon_information_id` ASC) VISIBLE,
118 CONSTRAINT `fk_tank_used_shell_tank_weapon_information1`
119 FOREIGN KEY (`tank_weapon_information_id`)
120 REFERENCES `WorldOfTank`.`tank_weapon_information` (`id`)
121 ON DELETE NO ACTION
122 ON UPDATE NO ACTION)
123ENGINE = InnoDB
124DEFAULT CHARACTER SET = utf8;
125
126
127SET SQL_MODE=@OLD_SQL_MODE;
128SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
129SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
130