VHcqzefa

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`.`PC_Liste`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `Lab_Database`.`PC_Liste` (
12  `idPC_List` INT NOT NULL ,
13  `Name` VARCHAR(10) NOT NULL ,
14  `RAM` INT NOT NULL ,
15  `HD_Size` INT NOT NULL ,
16  PRIMARY KEY (`idPC_List`) )
17ENGINE = InnoDB;
18
19
20-- -----------------------------------------------------
21-- Table `Lab_Database`.`Switcher`
22-- -----------------------------------------------------
23CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Switcher` (
24  `idSwitcher` INT NOT NULL AUTO_INCREMENT ,
25  `Porter` INT NOT NULL ,
26  PRIMARY KEY (`idSwitcher`) )
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `Lab_Database`.`Koblinger`
32-- -----------------------------------------------------
33CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Koblinger` (
34  `Koblinger` INT NOT NULL AUTO_INCREMENT ,
35  `Navn` VARCHAR(45) NOT NULL COMMENT '	' ,
36  `Aktiv` TINYINT(1)  NOT NULL ,
37  `Portnummer` INT NULL ,
38  `TypeTilkobling` VARCHAR(10) NULL ,
39  `Switcher_idSwitcher` INT NOT NULL ,
40  PRIMARY KEY (`Koblinger`) ,
41  INDEX `fk_Koblinger_Switcher1` (`Switcher_idSwitcher` ASC) ,
42  CONSTRAINT `fk_Koblinger_Switcher1`
43    FOREIGN KEY (`Switcher_idSwitcher` )
44    REFERENCES `Lab_Database`.`Switcher` (`idSwitcher` )
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `Lab_Database`.`NIC`
52-- -----------------------------------------------------
53CREATE  TABLE IF NOT EXISTS `Lab_Database`.`NIC` (
54  `MAC` VARCHAR(22) NOT NULL ,
55  `IP` VARCHAR(15) NOT NULL ,
56  `Mask` VARCHAR(15) NOT NULL ,
57  `Hastighet` INT NOT NULL ,
58  `Kort_Type` VARCHAR(10) NOT NULL ,
59  `Koblinger_Koblinger` INT NOT NULL ,
60  PRIMARY KEY (`MAC`) ,
61  INDEX `fk_NIC_Koblinger1` (`Koblinger_Koblinger` ASC) ,
62  CONSTRAINT `fk_NIC_Koblinger1`
63    FOREIGN KEY (`Koblinger_Koblinger` )
64    REFERENCES `Lab_Database`.`Koblinger` (`Koblinger` )
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `Lab_Database`.`Server`
72-- -----------------------------------------------------
73CREATE  TABLE IF NOT EXISTS `Lab_Database`.`Server` (
74  `idServer` INT NOT NULL ,
75  `Maskin_Navn` VARCHAR(45) NULL ,
76  `RAM` INT NULL ,
77  `HD_Size` INT NULL ,
78  `Switcher_idSwitcher` INT NOT NULL ,
79  PRIMARY KEY (`idServer`) ,
80  INDEX `fk_Server_Switcher1` (`Switcher_idSwitcher` ASC) ,
81  CONSTRAINT `fk_Server_Switcher1`
82    FOREIGN KEY (`Switcher_idSwitcher` )
83    REFERENCES `Lab_Database`.`Switcher` (`idSwitcher` )
84    ON DELETE NO ACTION
85    ON UPDATE NO ACTION)
86ENGINE = InnoDB;
87
88
89-- -----------------------------------------------------
90-- Table `Lab_Database`.`NIC_has_PC_Liste`
91-- -----------------------------------------------------
92CREATE  TABLE IF NOT EXISTS `Lab_Database`.`NIC_has_PC_Liste` (
93  `NIC_MAC` VARCHAR(22) NOT NULL ,
94  `PC_Liste_idPC_List` INT NOT NULL ,
95  PRIMARY KEY (`NIC_MAC`, `PC_Liste_idPC_List`) ,
96  INDEX `fk_NIC_has_PC_Liste_PC_Liste1` (`PC_Liste_idPC_List` ASC) ,
97  INDEX `fk_NIC_has_PC_Liste_NIC1` (`NIC_MAC` ASC) ,
98  CONSTRAINT `fk_NIC_has_PC_Liste_NIC1`
99    FOREIGN KEY (`NIC_MAC` )
100    REFERENCES `Lab_Database`.`NIC` (`MAC` )
101    ON DELETE NO ACTION
102    ON UPDATE NO ACTION,
103  CONSTRAINT `fk_NIC_has_PC_Liste_PC_Liste1`
104    FOREIGN KEY (`PC_Liste_idPC_List` )
105    REFERENCES `Lab_Database`.`PC_Liste` (`idPC_List` )
106    ON DELETE NO ACTION
107    ON UPDATE NO ACTION)
108ENGINE = InnoDB;
109
110
111
112SET SQL_MODE=@OLD_SQL_MODE;
113SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
114SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;