nJeBxJdd

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `dDB-34` DEFAULT CHARACTER SET utf8 ;
6USE `dDB-34` ;
7
8-- -----------------------------------------------------
9-- Table `dDB-34`.`Species`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `dDB-34`.`Species` (
12  `id` INT NOT NULL ,
13  `name` VARCHAR(45) NULL ,
14  PRIMARY KEY (`id`) )
15ENGINE = InnoDB;
16
17
18-- -----------------------------------------------------
19-- Table `dDB-34`.`Attributes`
20-- -----------------------------------------------------
21CREATE  TABLE IF NOT EXISTS `dDB-34`.`Attributes` (
22  `id` INT NOT NULL ,
23  `attribute` VARCHAR(45) NULL ,
24  PRIMARY KEY (`id`) )
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `dDB-34`.`Storage`
30-- -----------------------------------------------------
31CREATE  TABLE IF NOT EXISTS `dDB-34`.`Storage` (
32  `id` INT NOT NULL ,
33  `amount` FLOAT NULL ,
34  `price` FLOAT NULL ,
35  PRIMARY KEY (`id`) )
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `dDB-34`.`Animals`
41-- -----------------------------------------------------
42CREATE  TABLE IF NOT EXISTS `dDB-34`.`Animals` (
43  `id` INT NOT NULL ,
44  `amount` INT NULL ,
45  `weight` FLOAT NULL ,
46  `dailyFeeding` FLOAT NULL ,
47  `Species_id` INT NOT NULL ,
48  PRIMARY KEY (`id`, `Species_id`) ,
49  INDEX `fk_Animals_Species` (`Species_id` ASC) ,
50  CONSTRAINT `fk_Animals_Species`
51    FOREIGN KEY (`Species_id` )
52    REFERENCES `dDB-34`.`Species` (`id` )
53    ON DELETE NO ACTION
54    ON UPDATE NO ACTION)
55ENGINE = InnoDB;
56
57
58-- -----------------------------------------------------
59-- Table `dDB-34`.`Species_has_Attributes`
60-- -----------------------------------------------------
61CREATE  TABLE IF NOT EXISTS `dDB-34`.`Species_has_Attributes` (
62  `Species_id` INT NOT NULL ,
63  `Attributes_id` INT NOT NULL ,
64  PRIMARY KEY (`Species_id`, `Attributes_id`) ,
65  INDEX `fk_Species_has_Attributes_Attributes1` (`Attributes_id` ASC) ,
66  INDEX `fk_Species_has_Attributes_Species1` (`Species_id` ASC) ,
67  CONSTRAINT `fk_Species_has_Attributes_Species1`
68    FOREIGN KEY (`Species_id` )
69    REFERENCES `dDB-34`.`Species` (`id` )
70    ON DELETE NO ACTION
71    ON UPDATE NO ACTION,
72  CONSTRAINT `fk_Species_has_Attributes_Attributes1`
73    FOREIGN KEY (`Attributes_id` )
74    REFERENCES `dDB-34`.`Attributes` (`id` )
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION)
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `dDB-34`.`Types`
82-- -----------------------------------------------------
83CREATE  TABLE IF NOT EXISTS `dDB-34`.`Types` (
84  `id` INT NOT NULL ,
85  `name` VARCHAR(45) NULL ,
86  PRIMARY KEY (`id`) )
87ENGINE = InnoDB;
88
89
90-- -----------------------------------------------------
91-- Table `dDB-34`.`Species_has_Types`
92-- -----------------------------------------------------
93CREATE  TABLE IF NOT EXISTS `dDB-34`.`Species_has_Types` (
94  `Species_id` INT NOT NULL ,
95  `Types_id` INT NOT NULL ,
96  PRIMARY KEY (`Species_id`, `Types_id`) ,
97  INDEX `fk_Species_has_Types_Types1` (`Types_id` ASC) ,
98  INDEX `fk_Species_has_Types_Species1` (`Species_id` ASC) ,
99  CONSTRAINT `fk_Species_has_Types_Species1`
100    FOREIGN KEY (`Species_id` )
101    REFERENCES `dDB-34`.`Species` (`id` )
102    ON DELETE NO ACTION
103    ON UPDATE NO ACTION,
104  CONSTRAINT `fk_Species_has_Types_Types1`
105    FOREIGN KEY (`Types_id` )
106    REFERENCES `dDB-34`.`Types` (`id` )
107    ON DELETE NO ACTION
108    ON UPDATE NO ACTION)
109ENGINE = InnoDB;
110
111
112-- -----------------------------------------------------
113-- Table `dDB-34`.`Food_types`
114-- -----------------------------------------------------
115CREATE  TABLE IF NOT EXISTS `dDB-34`.`Food_types` (
116  `id` INT NOT NULL ,
117  `name` VARCHAR(45) NULL ,
118  `Storage_id` INT NOT NULL ,
119  `Species_id` INT NOT NULL ,
120  PRIMARY KEY (`id`, `Storage_id`, `Species_id`) ,
121  INDEX `fk_FoodTypes_Storage1` (`Storage_id` ASC) ,
122  INDEX `fk_Food_types_Species1` (`Species_id` ASC) ,
123  CONSTRAINT `fk_FoodTypes_Storage1`
124    FOREIGN KEY (`Storage_id` )
125    REFERENCES `dDB-34`.`Storage` (`id` )
126    ON DELETE NO ACTION
127    ON UPDATE NO ACTION,
128  CONSTRAINT `fk_Food_types_Species1`
129    FOREIGN KEY (`Species_id` )
130    REFERENCES `dDB-34`.`Species` (`id` )
131    ON DELETE NO ACTION
132    ON UPDATE NO ACTION)
133ENGINE = InnoDB;
134
135
136
137SET SQL_MODE=@OLD_SQL_MODE;
138SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
139SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;