SJjCb1Ty

1CREATE DATABASE  IF NOT EXISTS `student_01` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `student_01`;
3-- MySQL dump 10.13  Distrib 5.7.16, for Win64 (x86_64)
4--
5-- Host: localhost    Database: student_01
6-- ------------------------------------------------------
7-- Server version	5.7.16-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `fylke`
22--
23
24DROP TABLE IF EXISTS `fylke`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `fylke` (
28  `FylkeID` int(11) NOT NULL AUTO_INCREMENT,
29  `Fylkenavn` varchar(45) DEFAULT NULL,
30  PRIMARY KEY (`FylkeID`)
31) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `fylke`
36--
37
38LOCK TABLES `fylke` WRITE;
39/*!40000 ALTER TABLE `fylke` DISABLE KEYS */;
40INSERT INTO `fylke` VALUES (1,'Hedmark'),(2,'Oppland'),(3,'Oslo'),(4,'Akershus');
41/*!40000 ALTER TABLE `fylke` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `poststed`
46--
47
48DROP TABLE IF EXISTS `poststed`;
49/*!40101 SET @saved_cs_client     = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `poststed` (
52  `Postnummer` int(11) NOT NULL,
53  `Poststed` varchar(45) DEFAULT NULL,
54  PRIMARY KEY (`Postnummer`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Dumping data for table `poststed`
60--
61
62LOCK TABLES `poststed` WRITE;
63/*!40000 ALTER TABLE `poststed` DISABLE KEYS */;
64INSERT INTO `poststed` VALUES (1234,'Memetown'),(2224,'Austmarka'),(2821,'Gjøvik'),(2830,'Raufoss');
65/*!40000 ALTER TABLE `poststed` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `student`
70--
71
72DROP TABLE IF EXISTS `student`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `student` (
76  `studentID` int(11) NOT NULL AUTO_INCREMENT,
77  `Etternavn` varchar(45) NOT NULL,
78  `Fornavn` varchar(45) NOT NULL,
79  `Adresse` varchar(45) NOT NULL,
80  `Telefon` varchar(45) DEFAULT NULL,
81  `Postnummer` int(11) NOT NULL,
82  `Kjønn` varchar(45) DEFAULT NULL,
83  `Alder` int(11) DEFAULT NULL,
84  `FylkeID` int(11) NOT NULL,
85  PRIMARY KEY (`studentID`,`Postnummer`,`FylkeID`),
86  KEY `fk_Student_Poststed_idx` (`Postnummer`),
87  KEY `fk_Student_Fylke1_idx` (`FylkeID`),
88  CONSTRAINT `fk_Student_Fylke1` FOREIGN KEY (`FylkeID`) REFERENCES `fylke` (`FylkeID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
89  CONSTRAINT `fk_Student_Poststed` FOREIGN KEY (`Postnummer`) REFERENCES `poststed` (`Postnummer`) ON DELETE NO ACTION ON UPDATE NO ACTION
90) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `student`
95--
96
97LOCK TABLES `student` WRITE;
98/*!40000 ALTER TABLE `student` DISABLE KEYS */;
99INSERT INTO `student` VALUES (1,'Skaarseth','Kristoffer','Meme','12345678',1234,NULL,44,1),(2,'Petter','Degerdal','Mæm','87654321',2224,NULL,32,3),(3,'Meme','Guy','møm','12343213',2821,NULL,67,2),(5,'Jalla','Boris','pakka','12312322',1234,NULL,15,4);
100/*!40000 ALTER TABLE `student` ENABLE KEYS */;
101UNLOCK TABLES;
102/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
103
104/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
105/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
106/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
110/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
111
112-- Dump completed on 2016-11-25 12:21:34