PHPize Online / SQLize Online  /  SQLtest Online

-- phpMyAdmin SQL Dump -- version 4.9.5deb2 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Gegenereerd op: 03 mei 2024 om 21:07 -- Serverversie: 8.0.36-0ubuntu0.20.04.1 -- PHP-versie: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `entry_login` -- -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `buttons` -- CREATE TABLE `buttons` ( `button_id` int NOT NULL, `Service` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `button_href` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `button_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `buttons` -- INSERT INTO `buttons` (`button_id`, `Service`, `button_href`, `button_type`) VALUES (1, 'Plex', '<a href=\"http://plex.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#FF8C00\"><span>Plex</span><i></i></button></a>', 'media'), (2, 'Ombi', '<a href=\"https://ombi.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#00AAFF\"><span>Ombi</span><i></i></button></a>', 'media'), (3, 'Radarr', '<a href=\"http://radarr.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#F2FF00\"><span>Radarr</span><i></i></button></a>', 'media'), (4, 'Sickchill', '<a href=\"http://sickchill.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#0040FF\"><span>Sickchill</span><i></i></button></a>', 'media'), (5, 'Moviematch', '<a href=\"http://moviematch.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#FF3131\"><span>Moviematch</span><i></i></button></a>', 'media'), (6, 'Lidarr', '<a href=\"http://lidarr.familievermeylen.nl/\"><button class=\"button\" style=\"--clr:#FF1493\"><span>Lidarr</span><i></i></button></a>', 'media'), (7, 'Home Assistant', '<a href=\"https://ha-vermeylen.duckdns.org/\"><button class=\"button\" style=\"--clr:#7700FF\"><span>Home Assistant</span><i></i></button></a>', 'server'), (8, 'Download', '<a href=\"http://dl.familievermeylen.nl:8112/\"><button class=\"button\" style=\"--clr:#1F51FF\"><span>Download</span><i></i></button></a>', 'server'), (9, 'Proxmox', '<a href=\"http://pve.familievermeylen.nl\"><button class=\"button\" style=\"--clr:#FF44CC\"><span>Proxmox</span><i></i></button></a>', 'server'), (10, 'Pi-Hole Main', '<a href=\"http://192.168.0.22/admin/\"><button class=\"button\" style=\"--clr:#BC13FE\"><span>Pi-Hole Main</span><i></i></button></a>', 'server'), (11, 'Pi-Hole Slave', '<a href=\"http://192.168.0.102/admin/\"><button class=\"button\" style=\"--clr:#0FF0FC\"><span>Pi-Hole Slave</span><i></i></button></a>', 'server'), (12, 'Mealie', '<a href=\"https://mealie-vermeylen.duckdns.org/\"><button class=\"button\" style=\"--clr:#E7EE4F\"><span>Mealie</span><i></i></button></a>', 'server'), (13, 'Spoolman', '<a href=\"http://192.168.0.22:7912/\"><button class=\"button\" style=\"--clr:#8A2BE2\"><span>Spoolman</span><i></i></button></a>', 'printer'), (14, 'Klipper', '<a href=\"http://192.168.0.131/\"><button class=\"button\" style=\"--clr:#CCFF00\"><span>Klipper</span><i></i></button></a>', 'printer'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `buttons_allowed` -- CREATE TABLE `buttons_allowed` ( `buttons_allowed_id` int NOT NULL, `buttons_allowed_userid` int NOT NULL, `buttons_allowed_button_id` int NOT NULL, `buttons_allowed_activated` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `buttons_allowed` -- INSERT INTO `buttons_allowed` (`buttons_allowed_id`, `buttons_allowed_userid`, `buttons_allowed_button_id`, `buttons_allowed_activated`) VALUES (1, 32, 1, 1), (2, 32, 2, 1), (3, 32, 5, 1), (4, 32, 7, 0), (5, 32, 12, 0), (6, 33, 1, 0), (7, 33, 2, 0), (8, 33, 5, 0), (9, 33, 12, 0), (10, 34, 1, 0), (11, 34, 2, 0), (12, 34, 5, 0), (13, 34, 12, 0), (14, 35, 1, 0), (15, 35, 2, 0), (16, 35, 5, 0), (17, 35, 12, 0), (19, 28, 1, 0), (20, 28, 2, 1), (21, 28, 3, 1), (22, 28, 4, 1), (23, 28, 5, 1), (24, 28, 6, 1), (25, 28, 7, 0), (26, 28, 8, 1), (27, 28, 9, 1), (28, 28, 10, 0), (29, 28, 11, 0), (30, 28, 12, 1), (31, 28, 13, 1), (32, 28, 14, 1); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `buttons_connect` -- CREATE TABLE `buttons_connect` ( `buttons_connect_id` int NOT NULL, `buttons_connect_button_id` int NOT NULL, `button_connect_userid` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `buttons_connect` -- INSERT INTO `buttons_connect` (`buttons_connect_id`, `buttons_connect_button_id`, `button_connect_userid`) VALUES (1, 1, 28), (2, 2, 28), (3, 3, 28), (4, 4, 28), (5, 5, 28), (6, 6, 28), (7, 7, 28), (8, 8, 28), (9, 9, 28), (10, 10, 28), (11, 11, 28), (12, 12, 28), (13, 13, 28), (14, 14, 28), (15, 1, 32), (16, 2, 32), (17, 5, 32), (18, 12, 32), (19, 1, 33), (20, 2, 33), (21, 5, 33), (22, 12, 33), (23, 1, 34), (24, 2, 34), (25, 5, 34), (26, 1, 35), (27, 2, 35), (28, 5, 35); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `pwdreset` -- CREATE TABLE `pwdreset` ( `pwdResetId` int NOT NULL, `pwdResetEmail` text NOT NULL, `pwdResetSelector` text NOT NULL, `pwdResetToken` longtext NOT NULL, `pwdResetExpires` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `security_connect` -- CREATE TABLE `security_connect` ( `security_connect_id` int NOT NULL, `security_connect_userid` int NOT NULL, `security_connect_option` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `security_connect` -- INSERT INTO `security_connect` (`security_connect_id`, `security_connect_userid`, `security_connect_option`) VALUES (3, 28, 1), (5, 32, 2), (6, 33, 2), (9, 34, 2), (10, 35, 2); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `security_options` -- CREATE TABLE `security_options` ( `level_id` int NOT NULL, `level_option` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `security_options` -- INSERT INTO `security_options` (`level_id`, `level_option`) VALUES (1, 'admin'), (2, 'user'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `users` -- CREATE TABLE `users` ( `idUsers` int NOT NULL, `uidUsers` varchar(256) NOT NULL, `emailUsers` tinytext NOT NULL, `pwdUsers` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Gegevens worden geëxporteerd voor tabel `users` -- INSERT INTO `users` (`idUsers`, `uidUsers`, `emailUsers`, `pwdUsers`) VALUES (28, 'FGOD', 'willemvermeylen@ziggo.nl', '$2y$10$Tv0nmmJHJ5PqCD5GhgftJOt2nqW9M2mkgVxxJo7848bcI3MjBbIb6'), (32, 'Samantha', 'samantha.blankenstein@ziggo.nl', '$2y$10$Su0eAXoeKUwnVSLIr0wW5uKffGc4O6XLgzmz0TpOIffPxkSs1bXxW'), (33, 'Chantal', 'chantal.bl@hotmail.com', '$2y$10$WrAyVxe0DsOHb0Vb/OP3LORaVU3s5pmwOiJ82mEhW6kpTl0suzs5W'), (34, 'Robert', 'robertrilana@gmail.com', '$2y$10$QTdYavVULc6RG7qL86SwyOVIG1jKy0.vxFdAFE580FNoxo8rRIInC'), (35, 'Amr', 'wahby.ah@gmail.com', '$2y$10$TUlGzieokgxZyeCJSXhrr.0hrz83dyrE0CAW4.ALO9krTFb/ZFIU2'); -- -- Indexen voor geëxporteerde tabellen -- -- -- Indexen voor tabel `buttons` -- ALTER TABLE `buttons` ADD PRIMARY KEY (`button_id`); -- -- Indexen voor tabel `buttons_allowed` -- ALTER TABLE `buttons_allowed` ADD PRIMARY KEY (`buttons_allowed_id`); -- -- Indexen voor tabel `buttons_connect` -- ALTER TABLE `buttons_connect` ADD PRIMARY KEY (`buttons_connect_id`); -- -- Indexen voor tabel `pwdreset` -- ALTER TABLE `pwdreset` ADD PRIMARY KEY (`pwdResetId`); -- -- Indexen voor tabel `security_connect` -- ALTER TABLE `security_connect` ADD PRIMARY KEY (`security_connect_id`), ADD KEY `security_connect_userid` (`security_connect_userid`), ADD KEY `security_connect_option` (`security_connect_option`); -- -- Indexen voor tabel `security_options` -- ALTER TABLE `security_options` ADD PRIMARY KEY (`level_id`); -- -- Indexen voor tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`idUsers`), ADD KEY `idUsers` (`idUsers`), ADD KEY `idUsers_2` (`idUsers`), ADD KEY `uidUsers` (`uidUsers`(255)), ADD KEY `idUsers_3` (`idUsers`); -- -- AUTO_INCREMENT voor geëxporteerde tabellen -- -- -- AUTO_INCREMENT voor een tabel `buttons` -- ALTER TABLE `buttons` MODIFY `button_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT voor een tabel `buttons_allowed` -- ALTER TABLE `buttons_allowed` MODIFY `buttons_allowed_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT voor een tabel `buttons_connect` -- ALTER TABLE `buttons_connect` MODIFY `buttons_connect_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT voor een tabel `pwdreset` -- ALTER TABLE `pwdreset` MODIFY `pwdResetId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85; -- -- AUTO_INCREMENT voor een tabel `security_connect` -- ALTER TABLE `security_connect` MODIFY `security_connect_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT voor een tabel `security_options` -- ALTER TABLE `security_options` MODIFY `level_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT voor een tabel `users` -- ALTER TABLE `users` MODIFY `idUsers` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; 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 */;