· 8 years ago · Dec 08, 2017, 06:36 PM
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 `Database om noe rart` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `Database om noe rart` ;
7
8-- -----------------------------------------------------
9-- Table `Database om noe rart`.`Nett_Tjenester`
10-- -----------------------------------------------------
11CREATE TABLE IF NOT EXISTS `Database om noe rart`.`Nett_Tjenester` (
12 `idTjenester` INT NOT NULL AUTO_INCREMENT ,
13 `Tjenestetype` VARCHAR(30) NOT NULL ,
14 `Kommentar` VARCHAR(45) NULL ,
15 PRIMARY KEY (`idTjenester`) )
16ENGINE = InnoDB;
17
18
19-- -----------------------------------------------------
20-- Table `Database om noe rart`.`PC`
21-- -----------------------------------------------------
22CREATE TABLE IF NOT EXISTS `Database om noe rart`.`PC` (
23 `idPC` INT NOT NULL AUTO_INCREMENT ,
24 `GW` VARCHAR(12) NOT NULL ,
25 `navn` VARCHAR(45) NOT NULL ,
26 `RAM` VARCHAR(45) NOT NULL ,
27 `HD SIze` VARCHAR(45) NOT NULL ,
28 `Nett_Tjenester_idTjenester` INT NOT NULL ,
29 `Adresse` VARCHAR(25) NOT NULL ,
30 PRIMARY KEY (`idPC`) ,
31 INDEX `fk_PC_Nett_Tjenester1` (`Nett_Tjenester_idTjenester` ASC) ,
32 CONSTRAINT `fk_PC_Nett_Tjenester1`
33 FOREIGN KEY (`Nett_Tjenester_idTjenester` )
34 REFERENCES `Database om noe rart`.`Nett_Tjenester` (`idTjenester` )
35 ON DELETE NO ACTION
36 ON UPDATE NO ACTION)
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table `Database om noe rart`.`Switch`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `Database om noe rart`.`Switch` (
44 `idSwitch` INT NOT NULL AUTO_INCREMENT ,
45 `Porter` VARCHAR(128) NOT NULL ,
46 `Navn` VARCHAR(45) NOT NULL ,
47 PRIMARY KEY (`idSwitch`) )
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `Database om noe rart`.`Koblingstyper`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `Database om noe rart`.`Koblingstyper` (
55 `idKoblingstyper` INT NOT NULL AUTO_INCREMENT ,
56 `Betengelse` VARCHAR(20) NULL ,
57 PRIMARY KEY (`idKoblingstyper`) )
58ENGINE = InnoDB;
59
60
61-- -----------------------------------------------------
62-- Table `Database om noe rart`.`Kobling`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `Database om noe rart`.`Kobling` (
65 `Kobling` INT NOT NULL AUTO_INCREMENT ,
66 `Navn` VARCHAR(45) NOT NULL ,
67 `Aktiv` TINYINT(1) NOT NULL ,
68 `PortNR` VARCHAR(45) NOT NULL ,
69 `Switch_idSwitch` INT NOT NULL ,
70 `Type` VARCHAR(3) NOT NULL ,
71 `Koblingstyper_idKoblingstyper` INT NOT NULL ,
72 PRIMARY KEY (`Kobling`) ,
73 INDEX `fk_Kobling_Switch1` (`Switch_idSwitch` ASC) ,
74 INDEX `fk_Kobling_Koblingstyper1` (`Koblingstyper_idKoblingstyper` ASC) ,
75 CONSTRAINT `fk_Kobling_Switch1`
76 FOREIGN KEY (`Switch_idSwitch` )
77 REFERENCES `Database om noe rart`.`Switch` (`idSwitch` )
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION,
80 CONSTRAINT `fk_Kobling_Koblingstyper1`
81 FOREIGN KEY (`Koblingstyper_idKoblingstyper` )
82 REFERENCES `Database om noe rart`.`Koblingstyper` (`idKoblingstyper` )
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `Database om noe rart`.`IP`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `Database om noe rart`.`IP` (
92 `idIP` INT NOT NULL AUTO_INCREMENT ,
93 `Adresse` VARCHAR(20) NOT NULL ,
94 `Mask` VARCHAR(15) NOT NULL ,
95 `DFGW` VARCHAR(15) NULL ,
96 `Kommentar` VARCHAR(45) NULL ,
97 PRIMARY KEY (`idIP`) )
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `Database om noe rart`.`NIC`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `Database om noe rart`.`NIC` (
105 `MAC` INT NOT NULL AUTO_INCREMENT ,
106 `Hastighet` VARCHAR(45) NOT NULL ,
107 `KortType` VARCHAR(45) NULL ,
108 `PortNR` VARCHAR(45) NULL ,
109 `Kobling_Kobling` INT NOT NULL ,
110 `IP_idIP` INT NOT NULL ,
111 PRIMARY KEY (`MAC`) ,
112 INDEX `fk_NIC_Kobling1` (`Kobling_Kobling` ASC) ,
113 INDEX `fk_NIC_IP1` (`IP_idIP` ASC) ,
114 CONSTRAINT `fk_NIC_Kobling1`
115 FOREIGN KEY (`Kobling_Kobling` )
116 REFERENCES `Database om noe rart`.`Kobling` (`Kobling` )
117 ON DELETE NO ACTION
118 ON UPDATE NO ACTION,
119 CONSTRAINT `fk_NIC_IP1`
120 FOREIGN KEY (`IP_idIP` )
121 REFERENCES `Database om noe rart`.`IP` (`idIP` )
122 ON DELETE NO ACTION
123 ON UPDATE NO ACTION)
124ENGINE = InnoDB;
125
126
127-- -----------------------------------------------------
128-- Table `Database om noe rart`.`PC_has_NIC`
129-- -----------------------------------------------------
130CREATE TABLE IF NOT EXISTS `Database om noe rart`.`PC_has_NIC` (
131 `PC_idPC` INT NOT NULL ,
132 `NIC_MAC` INT NOT NULL ,
133 PRIMARY KEY (`PC_idPC`, `NIC_MAC`) ,
134 INDEX `fk_PC_has_NIC_NIC1` (`NIC_MAC` ASC) ,
135 INDEX `fk_PC_has_NIC_PC1` (`PC_idPC` ASC) ,
136 CONSTRAINT `fk_PC_has_NIC_PC1`
137 FOREIGN KEY (`PC_idPC` )
138 REFERENCES `Database om noe rart`.`PC` (`idPC` )
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION,
141 CONSTRAINT `fk_PC_has_NIC_NIC1`
142 FOREIGN KEY (`NIC_MAC` )
143 REFERENCES `Database om noe rart`.`NIC` (`MAC` )
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB;
147
148
149-- -----------------------------------------------------
150-- Table `Database om noe rart`.`Tjenesteliste`
151-- -----------------------------------------------------
152CREATE TABLE IF NOT EXISTS `Database om noe rart`.`Tjenesteliste` (
153 `idTjenesteliste` INT NOT NULL AUTO_INCREMENT ,
154 `PC_idPC` INT NOT NULL ,
155 PRIMARY KEY (`idTjenesteliste`) ,
156 INDEX `fk_Tjenesteliste_PC1` (`PC_idPC` ASC) ,
157 CONSTRAINT `fk_Tjenesteliste_PC1`
158 FOREIGN KEY (`PC_idPC` )
159 REFERENCES `Database om noe rart`.`PC` (`idPC` )
160 ON DELETE NO ACTION
161 ON UPDATE NO ACTION)
162ENGINE = InnoDB;
163
164
165
166SET SQL_MODE=@OLD_SQL_MODE;
167SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
168SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;