Hy9TNKsk

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 `Postliste` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `Postliste` ;
7
8-- -----------------------------------------------------
9-- Table `Postliste`.`Postliste`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `Postliste`.`Postliste` ;
12
13CREATE  TABLE IF NOT EXISTS `Postliste`.`Postliste` (
14  `Postnummer` VARCHAR(4) NOT NULL ,
15  `Poststed` VARCHAR(32) NOT NULL ,
16  `Kommunekode` VARCHAR(4) NOT NULL ,
17  `Kommuneanvn` VARCHAR(30) NOT NULL ,
18  `Kategori` CHAR NOT NULL ,
19  PRIMARY KEY (`Postnummer`) )
20ENGINE = InnoDB;
21
22
23-- -----------------------------------------------------
24-- Table `Postliste`.`Land`
25-- -----------------------------------------------------
26DROP TABLE IF EXISTS `Postliste`.`Land` ;
27
28CREATE  TABLE IF NOT EXISTS `Postliste`.`Land` (
29  `idLand` INT NOT NULL ,
30  `Land` VARCHAR(45) NOT NULL ,
31  PRIMARY KEY (`idLand`) )
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `Postliste`.`Personer`
37-- -----------------------------------------------------
38DROP TABLE IF EXISTS `Postliste`.`Personer` ;
39
40CREATE  TABLE IF NOT EXISTS `Postliste`.`Personer` (
41  `Kundenr` INT NOT NULL AUTO_INCREMENT ,
42  `Fornavn` VARCHAR(20) NOT NULL ,
43  `Etternavn` VARCHAR(20) NOT NULL ,
44  `Gateadresse` VARCHAR(45) NOT NULL ,
45  `Telefonnummer` VARCHAR(20) NULL ,
46  `Mobil` VARCHAR(20) NULL ,
47  `Epostadresse` VARCHAR(45) NULL ,
48  `kj` TINYINT(1)  NOT NULL ,
49  `Postliste_Postnummer` VARCHAR(4) NOT NULL ,
50  `Land_idLand` INT NOT NULL ,
51  PRIMARY KEY (`Kundenr`) ,
52  INDEX `fk_Personer_Postliste` (`Postliste_Postnummer` ASC) ,
53  INDEX `fk_Personer_Land1` (`Land_idLand` ASC) ,
54  CONSTRAINT `fk_Personer_Postliste`
55    FOREIGN KEY (`Postliste_Postnummer` )
56    REFERENCES `Postliste`.`Postliste` (`Postnummer` )
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION,
59  CONSTRAINT `fk_Personer_Land1`
60    FOREIGN KEY (`Land_idLand` )
61    REFERENCES `Postliste`.`Land` (`idLand` )
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `Postliste`.`PC`
69-- -----------------------------------------------------
70DROP TABLE IF EXISTS `Postliste`.`PC` ;
71
72CREATE  TABLE IF NOT EXISTS `Postliste`.`PC` (
73  `idPC` INT NOT NULL AUTO_INCREMENT ,
74  `Navn` VARCHAR(20) NOT NULL ,
75  PRIMARY KEY (`idPC`) )
76ENGINE = InnoDB;
77
78
79-- -----------------------------------------------------
80-- Table `Postliste`.`Mapper`
81-- -----------------------------------------------------
82DROP TABLE IF EXISTS `Postliste`.`Mapper` ;
83
84CREATE  TABLE IF NOT EXISTS `Postliste`.`Mapper` (
85  `idMapper` INT NOT NULL AUTO_INCREMENT ,
86  `Navn` VARCHAR(45) NOT NULL ,
87  `HD_PATH` VARCHAR(45) NOT NULL ,
88  `Size` INT NOT NULL ,
89  `PC_idPC` INT NOT NULL ,
90  `url` VARCHAR(25) NULL ,
91  PRIMARY KEY (`idMapper`) ,
92  INDEX `fk_Mapper_PC1` (`PC_idPC` ASC) ,
93  CONSTRAINT `fk_Mapper_PC1`
94    FOREIGN KEY (`PC_idPC` )
95    REFERENCES `Postliste`.`PC` (`idPC` )
96    ON DELETE NO ACTION
97    ON UPDATE NO ACTION)
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `Postliste`.`Personer_has_Mapper`
103-- -----------------------------------------------------
104DROP TABLE IF EXISTS `Postliste`.`Personer_has_Mapper` ;
105
106CREATE  TABLE IF NOT EXISTS `Postliste`.`Personer_has_Mapper` (
107  `Personer_Kundenr` INT NOT NULL ,
108  `Mapper_idMapper` INT NOT NULL ,
109  PRIMARY KEY (`Personer_Kundenr`, `Mapper_idMapper`) ,
110  INDEX `fk_Personer_has_Mapper_Mapper1` (`Mapper_idMapper` ASC) ,
111  INDEX `fk_Personer_has_Mapper_Personer1` (`Personer_Kundenr` ASC) ,
112  CONSTRAINT `fk_Personer_has_Mapper_Personer1`
113    FOREIGN KEY (`Personer_Kundenr` )
114    REFERENCES `Postliste`.`Personer` (`Kundenr` )
115    ON DELETE NO ACTION
116    ON UPDATE NO ACTION,
117  CONSTRAINT `fk_Personer_has_Mapper_Mapper1`
118    FOREIGN KEY (`Mapper_idMapper` )
119    REFERENCES `Postliste`.`Mapper` (`idMapper` )
120    ON DELETE NO ACTION
121    ON UPDATE NO ACTION)
122ENGINE = InnoDB;
123
124
125
126SET SQL_MODE=@OLD_SQL_MODE;
127SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
128SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;