1rhLi8Pf

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Mar 05, 2018 at 07:28 PM
7-- Server version: 5.7.19
8-- PHP Version: 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `health_event`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `student`
29--
30
31DROP TABLE IF EXISTS `student`;
32CREATE TABLE IF NOT EXISTS `student` (
33  `studentnummer` int(11) NOT NULL,
34  `naam` varchar(50) NOT NULL,
35  `klascode` varchar(8) NOT NULL,
36  `wachtwoord` text NOT NULL,
37  PRIMARY KEY (`studentnummer`),
38  KEY `studentnummer` (`studentnummer`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41-- --------------------------------------------------------
42
43--
44-- Table structure for table `studentworkshop`
45--
46
47DROP TABLE IF EXISTS `studentworkshop`;
48CREATE TABLE IF NOT EXISTS `studentworkshop` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `studentnummer` int(11) NOT NULL,
51  `workshopid` int(11) NOT NULL,
52  PRIMARY KEY (`id`),
53  KEY `workshopid` (`workshopid`),
54  KEY `studentnummer` (`studentnummer`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- --------------------------------------------------------
58
59--
60-- Table structure for table `workshop`
61--
62
63DROP TABLE IF EXISTS `workshop`;
64CREATE TABLE IF NOT EXISTS `workshop` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `naam` text NOT NULL,
67  `omschrijving` text NOT NULL,
68  `locatie` text NOT NULL,
69  `docent` varchar(50) NOT NULL,
70  `leider` varchar(50) NOT NULL,
71  `max` tinyint(40) NOT NULL,
72  `ronde` tinyint(2) NOT NULL,
73  PRIMARY KEY (`id`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75
76--
77-- Constraints for dumped tables
78--
79
80--
81-- Constraints for table `studentworkshop`
82--
83ALTER TABLE `studentworkshop`
84  ADD CONSTRAINT `studentworkshop_ibfk_1` FOREIGN KEY (`studentnummer`) REFERENCES `student` (`studentnummer`) ON DELETE NO ACTION ON UPDATE NO ACTION;
85
86--
87-- Constraints for table `workshop`
88--
89ALTER TABLE `workshop`
90  ADD CONSTRAINT `workshop_ibfk_1` FOREIGN KEY (`id`) REFERENCES `studentworkshop` (`workshopid`) ON DELETE NO ACTION ON UPDATE NO ACTION;
91COMMIT;
92
93/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
94/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
95/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;