xefhNtL9

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Machine: 127.0.0.1
6-- Gegenereerd op: 28 jun 2016 om 00:52
7-- Serverversie: 5.6.21
8-- PHP-versie: 5.6.3
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: `flash`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabelstructuur voor tabel `card`
27--
28
29CREATE TABLE IF NOT EXISTS `card` (
30`id` int(10) unsigned NOT NULL,
31  `Category_id` int(10) unsigned NOT NULL,
32  `question` varchar(255) DEFAULT NULL,
33  `answer` varchar(255) DEFAULT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
35
36--
37-- Gegevens worden geëxporteerd voor tabel `card`
38--
39
40INSERT INTO `card` (`id`, `Category_id`, `question`, `answer`) VALUES
41(1, 1, 'hoofd', 'dfsdfsd'),
42(2, 2, 'ben jij jnoen', 'jaaaaaaaaaaaaaaaaaaa'),
43(3, 3, 'Wat is de nummer 1 van rs', 'zezima'),
44(4, 3, 'Wat is maximale level op runescape', '126'),
45(5, 3, 'What tool do you need to mine?', 'Pickaxe'),
46(6, 3, 'What is the worst kind of pickaxe', 'Bronze'),
47(7, 3, 'How many kind of non-member ores are there?', '7'),
48(8, 3, ' In Lumbridge, where can you find the bronze pickaxe?', '3rd floor of the castle'),
49(9, 4, 'Best player', 'YouGotStunned'),
50(10, 4, 'Best Champion', 'Urgod'),
51(11, 4, 'Best item', 'Mobility Boots'),
52(12, 4, 'Best Rune', 'Fury'),
53(13, 4, 'Best Wood', 'Denzema'),
54(14, 4, 'Best Garen', 'Def not Oli'),
55(15, 4, 'Best Pandit', 'Udyr'),
56(16, 4, 'Best Sabon', 'Amummu'),
57(17, 4, 'Best Johnny', 'Shane'),
58(18, 4, 'Best Streamer', 'Trick2G'),
59(19, 4, 'Worst Riven', 'Shah'),
60(20, 4, 'Best Demon', 'Aatrox'),
61(21, 4, 'Best Surprise', 'Fiddle'),
62(22, 4, 'Best spot', 'Jungle'),
63(23, 4, 'Season 1 Winner', 'Fnatic'),
64(24, 4, 'Season 2 Winner', 'TPA'),
65(25, 4, 'Season 3 Winner', 'SKT T1'),
66(26, 4, 'Season 4 Winner', 'SSW'),
67(27, 4, 'Season 5 Winner', 'SKT T1'),
68(28, 4, 'Season 6 Winner', 'Team Boelerix'),
69(29, 4, 'Best Car', 'Jhin'),
70(30, 4, 'Best Army', 'PurpleArmy'),
71(31, 4, 'Best Fish', 'Fizz'),
72(32, 4, 'Best Horsemeat', 'Hecarim'),
73(33, 3, 'Emily', 'Faked only once'),
74(34, 3, 'Deadman Winner S1', 'YaNeverLearn'),
75(35, 3, 'Deadman Winner S2', 'On Codeine'),
76(36, 3, 'wat leer je op rs', 'scammen, engels'),
77(37, 3, 'Best Switcher', 'Rohit'),
78(38, 3, 'Best looter', 'Ali'),
79(39, 3, 'Wat is H.A.M', 'human against monster'),
80(40, 3, 'Best Car', 'Toy Horse'),
81(41, 3, 'Best Quest', 'One Small Favor'),
82(42, 3, '07 of RS3', '07'),
83(43, 3, 'Johnny Bravo', 'Adam'),
84(44, 3, 'Johnny Saus', 'Jouhari'),
85(45, 3, 'Max Skill Level', '99'),
86(46, 3, 'waar begin je?', 'Tutorial island'),
87(47, 3, 'Beste armor', 'Nex'),
88(48, 3, 'Best 2h', 'AGS'),
89(49, 3, 'Rohits loot', 'Drag full helm'),
90(50, 3, 'Karans loot', '2 Black hides'),
91(51, 6, 'Wie is Johnny', 'Pramod'),
92(52, 6, 'Boeler2', 'Test');
93
94-- --------------------------------------------------------
95
96--
97-- Tabelstructuur voor tabel `category`
98--
99
100CREATE TABLE IF NOT EXISTS `category` (
101`id` int(10) unsigned NOT NULL,
102  `name` varchar(25) DEFAULT NULL
103) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
104
105--
106-- Gegevens worden geëxporteerd voor tabel `category`
107--
108
109INSERT INTO `category` (`id`, `name`) VALUES
110(3, 'Runescape '),
111(4, 'League of Legends'),
112(6, 'Test Vragen1');
113
114-- --------------------------------------------------------
115
116--
117-- Tabelstructuur voor tabel `player_has_card`
118--
119
120CREATE TABLE IF NOT EXISTS `player_has_card` (
121  `Card_id` int(10) unsigned NOT NULL,
122  `Userr_id` int(10) unsigned NOT NULL,
123  `isCorrect` tinyint(1) DEFAULT NULL
124) ENGINE=InnoDB DEFAULT CHARSET=latin1;
125
126--
127-- Gegevens worden geëxporteerd voor tabel `player_has_card`
128--
129
130INSERT INTO `player_has_card` (`Card_id`, `Userr_id`, `isCorrect`) VALUES
131(1, 3, 0),
132(2, 5, 1),
133(3, 6, 1),
134(4, 6, 1),
135(5, 7, 0),
136(6, 7, 0),
137(7, 7, 0),
138(8, 7, 0),
139(9, 7, 1),
140(10, 7, 1),
141(11, 7, 1),
142(12, 7, 1),
143(13, 7, 0),
144(14, 7, 0),
145(15, 7, 0),
146(16, 7, 0),
147(17, 7, 0),
148(18, 7, 0),
149(19, 7, 0),
150(20, 7, 0),
151(21, 7, 0),
152(22, 7, 0),
153(23, 7, 0),
154(24, 7, 0),
155(25, 7, 0),
156(26, 7, 0),
157(27, 7, 0),
158(28, 7, 0),
159(29, 7, 0),
160(30, 7, 0),
161(31, 7, 0),
162(32, 7, 0),
163(33, 7, 0),
164(34, 7, 0),
165(35, 7, 0),
166(36, 7, 0),
167(37, 7, 0),
168(38, 7, 0),
169(39, 7, 0),
170(40, 7, 0),
171(41, 7, 0),
172(42, 7, 0),
173(43, 7, 0),
174(44, 7, 0),
175(45, 7, 0),
176(46, 7, 0),
177(47, 7, 0),
178(48, 7, 0),
179(49, 7, 0),
180(50, 7, 0),
181(51, 7, 0),
182(52, 7, 1);
183
184-- --------------------------------------------------------
185
186--
187-- Tabelstructuur voor tabel `userr`
188--
189
190CREATE TABLE IF NOT EXISTS `userr` (
191`id` int(10) unsigned NOT NULL,
192  `name` varchar(30) DEFAULT NULL,
193  `email` varchar(30) DEFAULT NULL,
194  `pass` int(10) unsigned DEFAULT NULL,
195  `isAdmin` tinyint(1) DEFAULT NULL
196) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
197
198--
199-- Gegevens worden geëxporteerd voor tabel `userr`
200--
201
202INSERT INTO `userr` (`id`, `name`, `email`, `pass`, `isAdmin`) VALUES
203(1, 'ali_alashtari@hotmail.com', 'ali_alashtari@hotmail.com', 98, 1),
204(2, 'ahmadaltuma@yahoo.com', 'ahmadaltuma@yahoo.com', 98, 0),
205(3, 'test', 'armo@dsfs.nl', 98, 0),
206(4, '', '', 0, 0),
207(5, 'homo', 'bonesawpk69@gmail.com', 0, 1),
208(6, 'test', 'test@test.nl', 98, 0),
209(7, 'maichod', 'maichod@lol.nl', 0, 0);
210
211--
212-- Indexen voor geëxporteerde tabellen
213--
214
215--
216-- Indexen voor tabel `card`
217--
218ALTER TABLE `card`
219 ADD PRIMARY KEY (`id`), ADD KEY `Question_FKIndex1` (`Category_id`);
220
221--
222-- Indexen voor tabel `category`
223--
224ALTER TABLE `category`
225 ADD PRIMARY KEY (`id`);
226
227--
228-- Indexen voor tabel `player_has_card`
229--
230ALTER TABLE `player_has_card`
231 ADD PRIMARY KEY (`Card_id`), ADD KEY `Player_has_Card_FKIndex1` (`Card_id`), ADD KEY `Player_has_Card_FKIndex2` (`Userr_id`);
232
233--
234-- Indexen voor tabel `userr`
235--
236ALTER TABLE `userr`
237 ADD PRIMARY KEY (`id`);
238
239--
240-- AUTO_INCREMENT voor geëxporteerde tabellen
241--
242
243--
244-- AUTO_INCREMENT voor een tabel `card`
245--
246ALTER TABLE `card`
247MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
248--
249-- AUTO_INCREMENT voor een tabel `category`
250--
251ALTER TABLE `category`
252MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
253--
254-- AUTO_INCREMENT voor een tabel `userr`
255--
256ALTER TABLE `userr`
257MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
258/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
259/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
260/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;