Btq7NPeY

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 `Lab_Database` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `Lab_Database` ;
7
8-- -----------------------------------------------------
9-- Table `Lab_Database`.`Config_Type`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Config_Type` (
12  `idConfig_Type` TINYINT NOT NULL ,
13  `Description` VARCHAR(45) NOT NULL ,
14  PRIMARY KEY (`idConfig_Type`) )
15ENGINE = InnoDB;
16
17
18-- -----------------------------------------------------
19-- Table `Lab_Database`.`PC_Liste`
20-- -----------------------------------------------------
21CREATE  TABLE IF NOT EXISTS `Lab_Database`.`PC_Liste` (
22  `idPC_List` INT NOT NULL ,
23  `Name` VARCHAR(10) NOT NULL ,
24  `RAM` INT NOT NULL ,
25  `HD_Size` INT NOT NULL ,
26  `Config_Type_idConfig_Type` TINYINT NOT NULL ,
27  PRIMARY KEY (`idPC_List`) ,
28  INDEX `fk_PC_Liste_Config_Type1` (`Config_Type_idConfig_Type` ASC) ,
29  CONSTRAINT `fk_PC_Liste_Config_Type1`
30    FOREIGN KEY (`Config_Type_idConfig_Type` )
31    REFERENCES `Lab_Database`.`Config_Type` (`idConfig_Type` )
32    ON DELETE NO ACTION
33    ON UPDATE NO ACTION)
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `Lab_Database`.`NIC`
39-- -----------------------------------------------------
40CREATE  TABLE IF NOT EXISTS `Lab_Database`.`NIC` (
41  `MAC` VARCHAR(22) NOT NULL ,
42  `IP` VARCHAR(15) NOT NULL ,
43  `Mask` VARCHAR(15) NOT NULL ,
44  `PC_Liste_idPC_List` INT NOT NULL ,
45  PRIMARY KEY (`MAC`) ,
46  INDEX `fk_NIC_PC_Liste` (`PC_Liste_idPC_List` ASC) ,
47  CONSTRAINT `fk_NIC_PC_Liste`
48    FOREIGN KEY (`PC_Liste_idPC_List` )
49    REFERENCES `Lab_Database`.`PC_Liste` (`idPC_List` )
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION)
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `Lab_Database`.`Switcher`
57-- -----------------------------------------------------
58CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Switcher` (
59  `idSwitcher` INT NOT NULL AUTO_INCREMENT ,
60  `Porter` INT NOT NULL ,
61  PRIMARY KEY (`idSwitcher`) )
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `Lab_Database`.`Server`
67-- -----------------------------------------------------
68CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Server` (
69  `idServer` INT NOT NULL ,
70  `Maskin_Navn` VARCHAR(45) NULL ,
71  `RAM` INT NULL ,
72  `HD_Size` INT NULL ,
73  PRIMARY KEY (`idServer`) )
74ENGINE = InnoDB;
75
76
77
78SET SQL_MODE=@OLD_SQL_MODE;
79SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
80SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;