🐚 WEB SHELL ACTIVATED

📁 File Browser

Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads

📄 Viewing: ../../../../584683.klas4s23.mid-ica.nl/public_html/../public_html/js/../3D Design/../elearning.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 17, 2025 at 08:08 AM
-- Server version: 8.3.0
-- PHP Version: 8.2.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `elearning`
--

-- --------------------------------------------------------

--
-- Table structure for table `list`
--

DROP TABLE IF EXISTS `list`;
CREATE TABLE IF NOT EXISTS `list` (
  `list_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `visibility` tinyint NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  PRIMARY KEY (`list_id`),
  UNIQUE KEY `list_id_UNIQUE` (`list_id`),
  KEY `list_user_id_user_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `list`
--

INSERT INTO `list` (`list_id`, `title`, `visibility`, `user_id`) VALUES
(1, 'Dieren', 1, 19),
(2, 'Kleuren', 1, 19),
(3, 'Technology', 0, 25),
(4, 'Planeten', 1, 19),
(13, 'Organen', 1, 26),
(18, 'Random', 1, 25),
(19, 'EDIT ME', 0, 19),
(20, 'Verbs', 0, 26),
(28, 'My list', 1, 34),
(29, 'New list', 1, 34),
(30, 'Directions', 1, 34),
(31, 'Wind', 1, 34),
(32, 'Extra list', 0, 25),
(33, 'Werkwoorden', 1, 35),
(34, 'Theater', 1, 35),
(35, 'Dier geluiden', 1, 19),
(36, 'Lijst vier', 0, 19),
(37, 'Getallen', 1, 19),
(38, 'Lijst vijf', 0, 19),
(39, 'Lijst zes', 0, 19),
(40, 'Lijst zeven', 0, 19),
(41, 'Lijst acht', 0, 19),
(46, 'peterslijst', 1, 25),
(48, 'Nieuw lijst', 1, 36);

-- --------------------------------------------------------

--
-- Table structure for table `list_word`
--

DROP TABLE IF EXISTS `list_word`;
CREATE TABLE IF NOT EXISTS `list_word` (
  `word_id` int NOT NULL AUTO_INCREMENT,
  `english_word` varchar(64) NOT NULL,
  `dutch_word` varchar(64) NOT NULL,
  `list_id` int NOT NULL,
  PRIMARY KEY (`word_id`),
  UNIQUE KEY `word_id_UNIQUE` (`word_id`),
  KEY `list_word_list_id_list_idx` (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `list_word`
--

INSERT INTO `list_word` (`word_id`, `english_word`, `dutch_word`, `list_id`) VALUES
(1, 'elephant', 'olifant', 1),
(2, 'cat', 'kat', 1),
(3, 'slug', 'naaktslak', 1),
(4, 'tiger', 'tijger', 1),
(5, 'red', 'rood', 2),
(6, 'orange', 'oranje', 2),
(7, 'yellow', 'geel', 2),
(8, 'green', 'groen', 2),
(9, 'blue', 'blauw', 2),
(10, 'purple', 'paars', 2),
(11, 'pink', 'roze', 2),
(12, 'Mercury', 'Mercurius', 4),
(13, 'Venus', 'Venus', 4),
(14, 'Earth', 'Aarde', 4),
(15, 'Mars', 'Mars', 4),
(16, 'Jupiter', 'Jupiter', 4),
(17, 'Saturn', 'Saturnus', 4),
(18, 'Uranus', 'Uranus', 4),
(19, 'Neptune', 'Neptunus', 4),
(22, 'Watch', 'Horloge', 3),
(23, 'Telephone', 'Telefoon', 3),
(28, 'Television', 'Televisie', 3),
(29, 'Remote control', 'Afstandsbediening', 3),
(30, 'Headphones', 'Koptelefoon', 3),
(31, 'Microphone', 'Microfoon', 3),
(33, 'Liver', 'Lever', 13),
(34, 'Brain', 'Hersenen', 13),
(35, 'Stomach', 'Maag', 13),
(36, 'Bladder', 'Blaas', 13),
(37, 'Glasses', 'Bril', 18),
(38, 'Bracelet', 'Armband', 18),
(39, 'Sweater', 'Trui', 18),
(40, 'Clothinghanger', 'Kledinghanger', 18),
(41, 'Lipbalm', 'Lippenbalsem', 18),
(42, 'Socks', 'Sokken', 18),
(43, 'Plushie', 'Knuffel', 18),
(44, 'Tree', 'Boom', 18),
(45, 'Door', 'Deur', 18),
(46, 'Roof', 'Dak', 18),
(47, 'Blanket', 'Deken', 18),
(48, 'Flower', 'Bloem', 18),
(49, 'EDIT ME.', 'PAS MIJ AAN.', 19),
(50, 'Walking', 'Lopen', 20),
(80, 'Word', 'Woor', 28),
(81, 'list', 'Lijst', 28),
(82, 'brand new', 'gloednieuw', 29),
(83, 'new', 'nieuw', 29),
(84, 'Down', 'Naar beneden', 30),
(85, 'Up', 'Naar boven', 30),
(86, 'Right', 'Rechts', 30),
(87, 'Left', 'Links', 30),
(88, 'West', 'West', 31),
(89, 'South', 'Zuid', 31),
(90, 'East', 'Oost', 31),
(91, 'North', 'Noord', 31),
(93, 'extra', 'extra', 32),
(94, 'Moving', 'Bewegen', 33),
(95, 'Sitting', 'Zitten', 33),
(96, 'Typing', 'Typen', 33),
(97, 'Waving', 'Zwaaien', 33),
(98, 'Walking', 'Lopen', 33),
(99, 'Acting', 'Acteren', 34),
(100, 'Singing', 'Zingen', 34),
(101, 'Speaking', 'Spreken', 34),
(102, 'Dancing', 'Dansen', 34),
(103, 'Lights', 'Lichten', 34),
(104, 'Dog bark', 'Hond woef', 35),
(105, 'Cat meow', 'Kat miauw', 35),
(106, 'Duck quack', 'Eend kwak', 35),
(107, 'Four', 'Vier', 36),
(108, 'Ten', 'Tien', 37),
(109, 'Nine', 'Negen', 37),
(110, 'Eight', 'Acht', 37),
(111, 'Seven', 'Zeven', 37),
(112, 'Six', 'Zes', 37),
(113, 'Five', 'Vijf', 37),
(114, 'Four', 'Vier', 37),
(115, 'Three', 'Drie', 37),
(116, 'Two', 'Twee', 37),
(117, 'One', 'Één', 37),
(118, 'list', 'lijst', 38),
(119, 'list', 'lijst', 39),
(120, 'list', 'lijst', 40),
(121, 'fesefs', 'HIOFENSOLKfefbjkeho', 41),
(122, 'me', 'edit me', 19),
(124, 'edit', 'edit ', 19),
(127, 'list', 'lijst', 19),
(134, 'j', 'i', 46),
(137, 'h', 'g', 46),
(138, 'muahha', 'MAHUAHA', 46),
(143, 'List', 'Lijst', 48),
(144, 'wrong', 'FOUT', 48);

-- --------------------------------------------------------

--
-- Table structure for table `score`
--

DROP TABLE IF EXISTS `score`;
CREATE TABLE IF NOT EXISTS `score` (
  `score_id` int NOT NULL AUTO_INCREMENT,
  `version` tinyint NOT NULL,
  `last_played` date NOT NULL,
  `score` varchar(45) NOT NULL,
  `user_id` int NOT NULL,
  `list_id` int NOT NULL,
  `result` text NOT NULL,
  PRIMARY KEY (`score_id`),
  UNIQUE KEY `score_id_UNIQUE` (`score_id`),
  KEY `score_user_id_user_user_id_idx` (`user_id`),
  KEY `score_list_id_list_list_id_idx` (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `score`
--

INSERT INTO `score` (`score_id`, `version`, `last_played`, `score`, `user_id`, `list_id`, `result`) VALUES
(16, 0, '2025-04-13', '3/4', 32, 1, '[{"isCorrect":true,"expectedAnswer":"elephant","actualAnswer":"Elephant"},{"isCorrect":true,"expectedAnswer":"cat","actualAnswer":"Cat"},{"isCorrect":false,"expectedAnswer":"slug","actualAnswer":"ur mother"},{"isCorrect":true,"expectedAnswer":"tiger","actualAnswer":"tiger"}]'),
(21, 1, '2025-04-13', '3/4', 25, 13, '[{"isCorrect":true,"expectedAnswer":"Lever","actualAnswer":"Lever"},{"isCorrect":false,"expectedAnswer":"Hersenen","actualAnswer":"Brein"},{"isCorrect":true,"expectedAnswer":"Maag","actualAnswer":"Maag"},{"isCorrect":true,"expectedAnswer":"Blaas","actualAnswer":"Blaas"}]'),
(22, 0, '2025-04-13', '2/4', 25, 1, '[{"isCorrect":true,"expectedAnswer":"elephant","actualAnswer":"Elephant"},{"isCorrect":true,"expectedAnswer":"cat","actualAnswer":"Cat"},{"isCorrect":false,"expectedAnswer":"slug","actualAnswer":"dwa"},{"isCorrect":false,"expectedAnswer":"tiger","actualAnswer":"dwa"}]'),
(25, 1, '2025-04-13', '3/4', 33, 1, '[{"isCorrect":true,"expectedAnswer":"olifant","actualAnswer":"Olifant"},{"isCorrect":false,"expectedAnswer":"kat","actualAnswer":"Kar"},{"isCorrect":true,"expectedAnswer":"naaktslak","actualAnswer":"Naaktslak"},{"isCorrect":true,"expectedAnswer":"tijger","actualAnswer":"Tijger"}]'),
(26, 1, '2025-04-13', '8/12', 34, 18, '[{"isCorrect":true,"expectedAnswer":"Bril","actualAnswer":"Bril"},{"isCorrect":true,"expectedAnswer":"Armband","actualAnswer":"Armband"},{"isCorrect":true,"expectedAnswer":"Trui","actualAnswer":"Trui"},{"isCorrect":false,"expectedAnswer":"Kledinghanger","actualAnswer":"Kledinghang"},{"isCorrect":false,"expectedAnswer":"Lippenbalsem","actualAnswer":"Chapstick"},{"isCorrect":true,"expectedAnswer":"Sokken","actualAnswer":"Sokken"},{"isCorrect":false,"expectedAnswer":"Knuffel","actualAnswer":"PLush"},{"isCorrect":true,"expectedAnswer":"Boom","actualAnswer":"Boom"},{"isCorrect":true,"expectedAnswer":"Deur","actualAnswer":"Deur"},{"isCorrect":false,"expectedAnswer":"Dak","actualAnswer":"Geen idee"},{"isCorrect":true,"expectedAnswer":"Deken","actualAnswer":"Deken"},{"isCorrect":true,"expectedAnswer":"Bloem","actualAnswer":"Bloem"}]'),
(27, 0, '2025-04-14', '1/4', 25, 30, '[{"isCorrect":true,"expectedAnswer":"Up","actualAnswer":"Up"},{"isCorrect":false,"expectedAnswer":"Right","actualAnswer":"Rig"},{"isCorrect":false,"expectedAnswer":"Left","actualAnswer":"dw"}]'),
(33, 0, '2025-04-15', '0/6', 25, 3, '[{"isCorrect":false,"expectedAnswer":"Watch","actualAnswer":""},{"isCorrect":false,"expectedAnswer":"Telephone","actualAnswer":""},{"isCorrect":false,"expectedAnswer":"Television","actualAnswer":""},{"isCorrect":false,"expectedAnswer":"Remote control","actualAnswer":""},{"isCorrect":false,"expectedAnswer":"Headphones","actualAnswer":""},{"isCorrect":false,"expectedAnswer":"Microphone","actualAnswer":""}]'),
(35, 1, '2025-04-15', '7/7', 36, 2, '[{"isCorrect":true,"expectedAnswer":"rood","actualAnswer":"rood"},{"isCorrect":true,"expectedAnswer":"oranje","actualAnswer":"oranje"},{"isCorrect":true,"expectedAnswer":"geel","actualAnswer":"geel"},{"isCorrect":true,"expectedAnswer":"groen","actualAnswer":"groen"},{"isCorrect":true,"expectedAnswer":"blauw","actualAnswer":"blauw"},{"isCorrect":true,"expectedAnswer":"paars","actualAnswer":"paars"},{"isCorrect":true,"expectedAnswer":"roze","actualAnswer":"roze"}]'),
(36, 0, '2025-04-15', '4/4', 36, 1, '[{"isCorrect":true,"expectedAnswer":"elephant","actualAnswer":"Elephant"},{"isCorrect":true,"expectedAnswer":"cat","actualAnswer":"cat"},{"isCorrect":true,"expectedAnswer":"slug","actualAnswer":"slug"},{"isCorrect":true,"expectedAnswer":"tiger","actualAnswer":"tiger"}]'),
(38, 0, '2025-04-15', '1/2', 36, 48, '[{"isCorrect":true,"expectedAnswer":"List","actualAnswer":"List"},{"isCorrect":false,"expectedAnswer":"wrong","actualAnswer":"Wdjeafm;wa"}]');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_id_UNIQUE` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `username`, `email`, `password`) VALUES
(1, 'test', 'test@test.nl', 'testing'),
(19, 'TESTING', 'test@test.nl', '$2y$12$6052l9sAh8D.WC6Q8cN0nemMKfy3uWYe3FfbrNsHBMc3SawaxrGki'),
(23, 'NOOSE', 'test@test.nl', 'TEST'),
(25, 'NOOSE 2.0', 'test@test.com', '$2y$12$tid6LDOtlXDvAymTEz06IuYxqFaRCu9crrJtTtRV3EiHdz5ceyrV6'),
(26, 'Phil Bozeman', 'var(--white)chapel@business.com', '$2y$12$uPDRfd2CqlSCSSJ6FJcncu7RgKwxC2rA0aICo/ScANVObu2m9pwHK'),
(27, 'Nick Matthews', 'getscared@business.com', '$2y$12$3m9yu4nqVNkySLnkuy0DKOMi4uK61woh9kyeTxZD3viYuYFzsEr/G'),
(29, 'Edited!', 'test@test.nl', '$2y$12$z1VofITK/vHPvj46X6/43.D/vFSsnKBX5NpYZze2XhEad.VhCcRpO'),
(30, 'editMyInfo', 'pls@cherryontop.com', '$2y$12$cfdibDm9bRao4wpnvX2whu5H7adXn3hpDzJRjGoEBDwSu2HgermsK'),
(31, 'Edited', 'edited@test.nl', '$2y$12$OxHhZlh9o0ZuDP/I8wHYk.ZdCijCctWC8stIBnNIFVl0gwZUDGeRq'),
(32, 'chunta', 'punkyspunk15@gmail.com', '$2y$12$D82QhjkV0z4HGYAw4rC6E.5Q9O2bZAWfX4PdVujLn1juEGj/QMcBq'),
(33, 'NewAstronaut', 'test@test.nl', '$2y$12$hjIzHXppqaF8ZXNOIys9pOPkdItWRu1.jciEDmRJH1Z51MwPmf6wS'),
(34, 'NewAstronaut101', 'test@test.nl', '$2y$12$0n07CYu2QEN62h97CQZqMO3yQAY0Sl.WoRhPBsNOZmikpRBRsTiWC'),
(35, 'Matt stone', 'southpark@business.com', '$2y$12$AoBsUc5qfxxfYiw56SpQuuNgeET6Sxbrk8Ee8bsNGTzmUcgmPSxl2'),
(36, 'Rick', 'rick@edu.rocmn.nl', '$2y$12$KlXUUEsgmthr3nI1IPXpJOBxJEWeyJgdOe1psM5eppzmjOoMrjg8i');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `list`
--
ALTER TABLE `list`
  ADD CONSTRAINT `list_user_id_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`);

--
-- Constraints for table `list_word`
--
ALTER TABLE `list_word`
  ADD CONSTRAINT `list_word_list_id_list` FOREIGN KEY (`list_id`) REFERENCES `list` (`list_id`);

--
-- Constraints for table `score`
--
ALTER TABLE `score`
  ADD CONSTRAINT `score_list_id_list_list_id` FOREIGN KEY (`list_id`) REFERENCES `list` (`list_id`),
  ADD CONSTRAINT `score_user_id_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

🎯 Available Actions