· 9 years ago · Nov 14, 2016, 12:04 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Machine: 127.0.0.1
6-- Gegenereerd op: 14 nov 2016 om 12:59
7-- Serverversie: 5.6.17
8-- PHP-versie: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Databank: `elearning`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabelstructuur voor tabel `antwoorden`
27--
28
29CREATE TABLE IF NOT EXISTS `antwoorden` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `vraagId` int(11) NOT NULL,
32 `antwoord` varchar(20) NOT NULL,
33 `correct` varchar(10) NOT NULL,
34 `lesId` int(11) NOT NULL,
35 `lesowid` int(11) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;
38
39--
40-- Gegevens worden geëxporteerd voor tabel `antwoorden`
41--
42
43INSERT INTO `antwoorden` (`id`, `vraagId`, `antwoord`, `correct`, `lesId`, `lesowid`) VALUES
44(1, 1, '2000', 'true', 7, 14),
45(2, 1, '800', 'false', 7, 14),
46(3, 1, '600', 'false', 7, 14),
47(20, 2, '1200', 'false', 7, 14),
48(21, 2, '1000', 'true', 7, 14),
49(22, 2, '2000', 'false', 7, 14),
50(29, 3, '600', 'false', 7, 14),
51(30, 3, '800', 'false', 7, 14),
52(31, 3, '1200', 'true', 7, 14),
53(32, 4, '10000', 'false', 7, 14),
54(33, 4, '1400', 'true', 7, 14),
55(34, 4, '150', 'false', 7, 14),
56(35, 5, '2400', 'true', 7, 14),
57(36, 5, '5000', 'false', 7, 14),
58(37, 5, '1500', 'false', 7, 14),
59(44, 38, '144', 'true', 13, 0),
60(45, 38, '120', 'false', 13, 0),
61(46, 38, '200', 'false', 13, 0),
62(47, 39, '200', 'false', 13, 0),
63(48, 39, '225', 'true', 13, 0),
64(49, 39, '250', 'false', 13, 0),
65(50, 40, '276', 'false', 13, 0),
66(51, 40, '400', 'true', 13, 0),
67(52, 40, '362', 'false', 13, 0),
68(53, 41, '10cm', 'true', 13, 0),
69(54, 41, '25cm', 'false', 13, 0),
70(55, 41, '50cm', 'false', 13, 0),
71(56, 42, '90cm', 'true', 13, 0),
72(57, 42, '55cm', 'false', 13, 0),
73(58, 42, '75cm', 'false', 13, 0),
74(80, 43, '0', 'true', 8, 14),
75(81, 43, '400', 'false', 8, 14),
76(82, 43, '5', 'false', 8, 14),
77(83, 44, '200', 'false', 8, 14),
78(84, 44, '500', 'true', 8, 14),
79(85, 44, '300', 'false', 8, 14),
80(86, 45, '500', 'false', 8, 14),
81(87, 45, '2000', 'false', 8, 14),
82(88, 45, '1000', 'true', 8, 14),
83(89, 46, '50', 'false', 8, 14),
84(90, 46, '-50', 'true', 8, 14),
85(91, 46, '100', 'false', 8, 14),
86(92, 47, '-500', 'true', 8, 14),
87(93, 47, '-250', 'false', 8, 14),
88(94, 47, '-400', 'false', 8, 14);
89
90-- --------------------------------------------------------
91
92--
93-- Tabelstructuur voor tabel `lesonderwerp`
94--
95
96CREATE TABLE IF NOT EXISTS `lesonderwerp` (
97 `id` int(11) NOT NULL,
98 `omschrijving` varchar(30) NOT NULL,
99 `vakId` int(11) NOT NULL,
100 `toetsplanning` varchar(50) NOT NULL,
101 `patient` varchar(50) NOT NULL,
102 PRIMARY KEY (`id`)
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104
105--
106-- Gegevens worden geëxporteerd voor tabel `lesonderwerp`
107--
108
109INSERT INTO `lesonderwerp` (`id`, `omschrijving`, `vakId`, `toetsplanning`, `patient`) VALUES
110(14, 'Optellen en Aftrekken', 1, '7 november 2016', 'Jan'),
111(17, 'meten & meetkunde', 1, '30 oktober 2017', 'sjors');
112
113-- --------------------------------------------------------
114
115--
116-- Tabelstructuur voor tabel `lessen`
117--
118
119CREATE TABLE IF NOT EXISTS `lessen` (
120 `id` int(11) NOT NULL,
121 `lesnaam` varchar(50) NOT NULL,
122 `lesondwid` int(11) NOT NULL,
123 `lesuitleg` varchar(100) NOT NULL,
124 `lesplanning` varchar(50) NOT NULL,
125 `afgerond` varchar(5) NOT NULL,
126 `patient` varchar(50) NOT NULL,
127 PRIMARY KEY (`id`)
128) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129
130--
131-- Gegevens worden geëxporteerd voor tabel `lessen`
132--
133
134INSERT INTO `lessen` (`id`, `lesnaam`, `lesondwid`, `lesuitleg`, `lesplanning`, `afgerond`, `patient`) VALUES
135(7, 'Gehele Getallen', 14, 'Grote Getallen Optellen en aftrekken', '25 december 2016', '', 'henk'),
136(8, 'Negatieve Getallen', 14, 'Negatieve getallen optellen en aftrekken', '', '', ''),
137(13, 'vierkante meters', 17, 'Lengte x Breedte', '', '', '');
138
139-- --------------------------------------------------------
140
141--
142-- Tabelstructuur voor tabel `patiënten`
143--
144
145CREATE TABLE IF NOT EXISTS `patiënten` (
146 `patientid` int(11) NOT NULL AUTO_INCREMENT,
147 `rol id` int(11) NOT NULL,
148 `username` varchar(30) NOT NULL,
149 `password` varchar(30) NOT NULL,
150 PRIMARY KEY (`patientid`)
151) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
152
153--
154-- Gegevens worden geëxporteerd voor tabel `patiënten`
155--
156
157INSERT INTO `patiënten` (`patientid`, `rol id`, `username`, `password`) VALUES
158(1, 1, 'patient1', 'patient1'),
159(2, 1, 'jan', 'jan'),
160(3, 1, 'henk', 'henk');
161
162-- --------------------------------------------------------
163
164--
165-- Tabelstructuur voor tabel `rol`
166--
167
168CREATE TABLE IF NOT EXISTS `rol` (
169 `id` int(11) NOT NULL AUTO_INCREMENT,
170 `omschrijving` int(11) NOT NULL,
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
173
174-- --------------------------------------------------------
175
176--
177-- Tabelstructuur voor tabel `vak`
178--
179
180CREATE TABLE IF NOT EXISTS `vak` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `vaknaam` varchar(30) NOT NULL,
183 PRIMARY KEY (`id`)
184) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
185
186--
187-- Gegevens worden geëxporteerd voor tabel `vak`
188--
189
190INSERT INTO `vak` (`id`, `vaknaam`) VALUES
191(1, 'Rekenen'),
192(2, 'Geschiedenis');
193
194-- --------------------------------------------------------
195
196--
197-- Tabelstructuur voor tabel `vragen`
198--
199
200CREATE TABLE IF NOT EXISTS `vragen` (
201 `vraagid` int(11) NOT NULL AUTO_INCREMENT,
202 `vraag` varchar(30) NOT NULL,
203 `lesId` int(11) NOT NULL,
204 `lesondwid` int(11) NOT NULL,
205 PRIMARY KEY (`vraagid`)
206) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;
207
208--
209-- Gegevens worden geëxporteerd voor tabel `vragen`
210--
211
212INSERT INTO `vragen` (`vraagid`, `vraag`, `lesId`, `lesondwid`) VALUES
213(1, '1000 + 1000', 7, 14),
214(2, '500 + 500', 7, 14),
215(3, '600 + 600', 7, 14),
216(4, '700 + 700', 7, 14),
217(5, '900 + 1500', 7, 14),
218(38, '12dm * 12dm', 13, 17),
219(39, '15m * 15m', 13, 17),
220(40, '20mm * 20mm', 13, 17),
221(41, '1m - 90cm', 13, 17),
222(42, '1m - 10cm', 13, 17),
223(43, '-200 + 200', 8, 14),
224(44, '-500 + 1000', 8, 14),
225(45, '-1000 + 2000', 8, 14),
226(46, '150-200', 8, 14),
227(47, '50-550', 8, 14),
228(56, '', 7, 14);
229
230/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
231/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
232/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;