· 9 years ago · Jan 16, 2017, 11:48 AM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema dota_db
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema dota_db
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `dota_db` DEFAULT CHARACTER SET utf8 ;
15USE `dota_db` ;
16
17-- -----------------------------------------------------
18-- Table `dota_db`.`Items`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `dota_db`.`Items` (
21 `idItems` INT NOT NULL AUTO_INCREMENT,
22 `Item_Description` VARCHAR(255) NULL,
23 `Item_Name` VARCHAR(45) NULL,
24 `Item_Price` INT NULL,
25 `Item_ManaCost` INT NULL,
26 `Item_UniqueModi` TINYINT(1) NULL,
27 `SecretShop` TINYINT(1) NULL,
28 `SideShop` TINYINT(1) NULL,
29 `Item_Ability1` INT NULL,
30 `Item_Ability2` INT NULL,
31 `Item_Ability3` INT NULL,
32 `Item_Ability4` INT NULL,
33 `Item_Icon` VARCHAR(255) NULL,
34 `ItemStat_Strength` INT NULL,
35 `ItemStat_Agility` INT NULL,
36 `ItemStat_Intelligence` INT NULL,
37 `ItemStat_Movementspeed` INT NULL,
38 `ItemStat_AttackSpeed` INT NULL,
39 `ItemStat_AttackRange` INT NULL,
40 `ItemStat_CastRange` INT NULL,
41 `Item_Craft` TINYINT(1) NULL,
42 `ItemStat_Health` INT NULL,
43 `ItemStat_Health_regen` INT NULL,
44 `ItemStat_Mana` INT NULL,
45 `ItemStat_Mana_regen_fixed` DECIMAL(3,1) NULL,
46 `ItemStat_Mana_regen_percent` INT NULL,
47 PRIMARY KEY (`idItems`))
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `dota_db`.`Heroes`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `dota_db`.`Heroes` (
55 `idHeroes` INT UNSIGNED NOT NULL AUTO_INCREMENT,
56 `HeroName` VARCHAR(45) NULL,
57 `HeroIcon` VARCHAR(255) NULL,
58 `HeroPrimaryStat` INT NULL,
59 `HeroStat_Strength` INT NULL,
60 `HeroStat_Agility` INT NULL,
61 `HeroStat_Intelligence` INT NULL,
62 `HeroStat_Strength_gain` INT NULL,
63 `HeroStat_Agility_gain` INT NULL,
64 `HeroStat_Intelligence_gain` INT NULL,
65 `HeroStat_MovementSpeed` INT NULL,
66 `Hero_Ability1` INT NULL,
67 `Hero_Ability2` INT NULL,
68 `Hero_Ability3` INT NULL,
69 `Hero_Ability4` INT NULL,
70 `Hero_Ability5` INT NULL,
71 `Hero_Ability6` INT NULL,
72 `HeroStat_Base-Attack` INT NULL,
73 `HeroStat_AttackSpeed` INT NULL,
74 PRIMARY KEY (`idHeroes`))
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `dota_db`.`Abilities`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `dota_db`.`Abilities` (
82 `idAbilities` INT NOT NULL AUTO_INCREMENT,
83 `Ability_Name` VARCHAR(45) NULL,
84 `Ability_Mana_Cost` INT NULL,
85 `Ability_Cooldown` INT NULL,
86 `Ability_Slow` DECIMAL(4,2) NULL,
87 `Ability_Stun` DECIMAL(4,2) NULL,
88 `Ability_Root` DECIMAL(4,2) NULL,
89 `Ability_Sleep` DECIMAL(4,2) NULL,
90 `Ability_Bash` DECIMAL(4,2) NULL,
91 `Ability_Active` TINYINT(1) NULL,
92 `Abilitiescol` VARCHAR(45) NULL,
93 PRIMARY KEY (`idAbilities`))
94ENGINE = InnoDB;
95
96
97-- -----------------------------------------------------
98-- Table `dota_db`.`Heroes_has_Abilities`
99-- -----------------------------------------------------
100CREATE TABLE IF NOT EXISTS `dota_db`.`Heroes_has_Abilities` (
101 `Heroes_idHeroes` INT UNSIGNED NOT NULL,
102 `Abilities_idAbilities` INT NOT NULL,
103 PRIMARY KEY (`Heroes_idHeroes`, `Abilities_idAbilities`),
104 INDEX `fk_Heroes_has_Abilities_Abilities1_idx` (`Abilities_idAbilities` ASC),
105 INDEX `fk_Heroes_has_Abilities_Heroes_idx` (`Heroes_idHeroes` ASC),
106 CONSTRAINT `fk_Heroes_has_Abilities_Heroes`
107 FOREIGN KEY (`Heroes_idHeroes`)
108 REFERENCES `dota_db`.`Heroes` (`idHeroes`)
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION,
111 CONSTRAINT `fk_Heroes_has_Abilities_Abilities1`
112 FOREIGN KEY (`Abilities_idAbilities`)
113 REFERENCES `dota_db`.`Abilities` (`idAbilities`)
114 ON DELETE NO ACTION
115 ON UPDATE NO ACTION)
116ENGINE = InnoDB;
117
118
119-- -----------------------------------------------------
120-- Table `dota_db`.`Heroes_has_Items`
121-- -----------------------------------------------------
122CREATE TABLE IF NOT EXISTS `dota_db`.`Heroes_has_Items` (
123 `Heroes_idHeroes` INT UNSIGNED NOT NULL,
124 `Items_idItems` INT NOT NULL,
125 PRIMARY KEY (`Heroes_idHeroes`, `Items_idItems`),
126 INDEX `fk_Heroes_has_Items_Items1_idx` (`Items_idItems` ASC),
127 INDEX `fk_Heroes_has_Items_Heroes1_idx` (`Heroes_idHeroes` ASC),
128 CONSTRAINT `fk_Heroes_has_Items_Heroes1`
129 FOREIGN KEY (`Heroes_idHeroes`)
130 REFERENCES `dota_db`.`Heroes` (`idHeroes`)
131 ON DELETE NO ACTION
132 ON UPDATE NO ACTION,
133 CONSTRAINT `fk_Heroes_has_Items_Items1`
134 FOREIGN KEY (`Items_idItems`)
135 REFERENCES `dota_db`.`Items` (`idItems`)
136 ON DELETE NO ACTION
137 ON UPDATE NO ACTION)
138ENGINE = InnoDB;
139
140
141-- -----------------------------------------------------
142-- Table `dota_db`.`Items_has_Abilities`
143-- -----------------------------------------------------
144CREATE TABLE IF NOT EXISTS `dota_db`.`Items_has_Abilities` (
145 `Items_idItems` INT NOT NULL,
146 `Abilities_idAbilities` INT NOT NULL,
147 PRIMARY KEY (`Items_idItems`, `Abilities_idAbilities`),
148 INDEX `fk_Items_has_Abilities_Abilities1_idx` (`Abilities_idAbilities` ASC),
149 INDEX `fk_Items_has_Abilities_Items1_idx` (`Items_idItems` ASC),
150 CONSTRAINT `fk_Items_has_Abilities_Items1`
151 FOREIGN KEY (`Items_idItems`)
152 REFERENCES `dota_db`.`Items` (`idItems`)
153 ON DELETE NO ACTION
154 ON UPDATE NO ACTION,
155 CONSTRAINT `fk_Items_has_Abilities_Abilities1`
156 FOREIGN KEY (`Abilities_idAbilities`)
157 REFERENCES `dota_db`.`Abilities` (`idAbilities`)
158 ON DELETE NO ACTION
159 ON UPDATE NO ACTION)
160ENGINE = InnoDB;
161
162
163SET SQL_MODE=@OLD_SQL_MODE;
164SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
165SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;