· 9 years ago · Jan 05, 2017, 03:16 PM
1-- MySQL Script generated by MySQL Workbench
2-- 01/05/17 14:07:39
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='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `harrylee` DEFAULT CHARACTER SET utf8 ;
18USE `harrylee` ;
19
20-- -----------------------------------------------------
21-- Table `harrylee`.`AllItems`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `harrylee`.`AllItems` (
24 `idAllItems` INT NOT NULL,
25 `AllItemsAirWeaponsManufacturer` VARCHAR(45) NULL,
26 `AllItemsAirWeaponsType` VARCHAR(45) NULL,
27 `AllItemsAirWeaponsDesc` LONGTEXT NULL,
28 `AllItemsAirDateInputted` DATE NULL,
29 `AllItemsAirWeaponsOwner` VARCHAR(45) NULL,
30 `AllItemsCraftPeriod` DATE NULL,
31 `AllItemsCraftMapScale` INT NULL,
32 `AllItemsCraftAircraftType` VARCHAR(45) NULL,
33 `AllItemsCraftAircraftSerial` INT NULL,
34 `AllItemsUniformsStockNumber` INT NULL,
35 `Air_idAir` INT NOT NULL,
36 `Air_Air_idAir` INT NOT NULL,
37 PRIMARY KEY (`idAllItems`))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `harrylee`.`Air`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `harrylee`.`Air` (
45 `idAir` INT NOT NULL,
46 `AirGunnersNumber` INT NULL,
47 `AirWeaponsManufacturer` VARCHAR(45) NULL,
48 `AirWeaponsType` VARCHAR(45) NULL,
49 `AirWeaponsDesc` LONGTEXT NOT NULL,
50 `AirDateInputted` DATE NULL,
51 `AirWeaponsOwner` VARCHAR(45) NULL,
52 `AirPhoto` VARCHAR(45) NULL,
53 `Air_idAir` INT NOT NULL,
54 `AllItems_idAllItems` INT NOT NULL,
55 `AllItems_idAllItems1` INT NOT NULL,
56 PRIMARY KEY (`idAir`, `Air_idAir`),
57 INDEX `fk_Air_AllItems_idx` (`AllItems_idAllItems1` ASC),
58 CONSTRAINT `fk_Air_AllItems`
59 FOREIGN KEY (`AllItems_idAllItems1`)
60 REFERENCES `harrylee`.`AllItems` (`idAllItems`)
61 ON DELETE NO ACTION
62 ON UPDATE NO ACTION)
63ENGINE = InnoDB;
64
65
66-- -----------------------------------------------------
67-- Table `harrylee`.`Craft`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `harrylee`.`Craft` (
70 `idCraft` INT NOT NULL,
71 `CraftPeriod` DATE NULL,
72 `CraftMapsScale` INT NULL,
73 `CraftArtist` VARCHAR(45) NULL,
74 `CraftAircraftType` VARCHAR(45) NULL,
75 `CraftAircraftSerial` INT NULL,
76 `CraftAirSquadron` VARCHAR(45) NULL,
77 `AllItems_idAllItems` INT NOT NULL,
78 PRIMARY KEY (`idCraft`),
79 INDEX `fk_Craft_AllItems1_idx` (`AllItems_idAllItems` ASC),
80 CONSTRAINT `fk_Craft_AllItems1`
81 FOREIGN KEY (`AllItems_idAllItems`)
82 REFERENCES `harrylee`.`AllItems` (`idAllItems`)
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `harrylee`.`Uniforms`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `harrylee`.`Uniforms` (
92 `idUniforms` INT NOT NULL,
93 `UniformsStockNumber` INT NULL,
94 `UniformsDateIntoFreezer` DATE NULL,
95 `UniformsDateOutOfFreezer` DATE NULL,
96 `AllItems_idAllItems` INT NOT NULL,
97 PRIMARY KEY (`idUniforms`),
98 INDEX `fk_Uniforms_AllItems1_idx` (`AllItems_idAllItems` ASC),
99 CONSTRAINT `fk_Uniforms_AllItems1`
100 FOREIGN KEY (`AllItems_idAllItems`)
101 REFERENCES `harrylee`.`AllItems` (`idAllItems`)
102 ON DELETE NO ACTION
103 ON UPDATE NO ACTION)
104ENGINE = InnoDB;
105
106
107-- -----------------------------------------------------
108-- Table `harrylee`.`Receipts`
109-- -----------------------------------------------------
110CREATE TABLE IF NOT EXISTS `harrylee`.`Receipts` (
111 `idReceipts` INT NOT NULL,
112 `ReceiptsDate` DATE NULL,
113 `ReceiptsDonor` VARCHAR(45) NULL,
114 `ReceiptsItems` VARCHAR(45) NULL,
115 `ReceiptsNotes` LONGTEXT NULL,
116 `AllItems_idAllItems` INT NOT NULL,
117 PRIMARY KEY (`idReceipts`),
118 INDEX `fk_Receipts_AllItems1_idx` (`AllItems_idAllItems` ASC),
119 CONSTRAINT `fk_Receipts_AllItems1`
120 FOREIGN KEY (`AllItems_idAllItems`)
121 REFERENCES `harrylee`.`AllItems` (`idAllItems`)
122 ON DELETE NO ACTION
123 ON UPDATE NO ACTION)
124ENGINE = InnoDB;
125
126
127SET SQL_MODE=@OLD_SQL_MODE;
128SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
129SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;