-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Erstellungszeit: 09. Mrz 2023 um 03:54 -- Server-Version: 10.5.18-MariaDB-0+deb11u1 -- PHP-Version: 7.4.33 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 */; -- -- Datenbank: `janh_db2` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `admin_ticket` -- CREATE TABLE `admin_ticket` ( `id` int(255) NOT NULL, `reply` text NOT NULL, `toticket` int(255) NOT NULL, `ticket_answer` int(255) NOT NULL, `byuser` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `email_server` -- CREATE TABLE `email_server` ( `id` int(11) NOT NULL, `host` varchar(255) NOT NULL, `account` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `secure` varchar(255) NOT NULL, `port` int(255) NOT NULL, `type` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `musicbot` -- CREATE TABLE `musicbot` ( `id` int(255) NOT NULL, `name` varchar(255) NOT NULL, `ts3ip` varchar(255) NOT NULL, `ts3port` varchar(255) NOT NULL, `ts3password` varchar(255) NOT NULL, `user` varchar(255) NOT NULL, `node` int(255) NOT NULL, `botid` int(255) NOT NULL, `template_id` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `news` -- CREATE TABLE `news` ( `id` int(255) NOT NULL, `author` varchar(255) NOT NULL, `date` varchar(255) NOT NULL, `title` varchar(500) NOT NULL, `text` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `nodes` -- CREATE TABLE `nodes` ( `id` int(255) NOT NULL, `name` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `port` int(255) NOT NULL, `uid` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `status` set('active','locked','','') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `password_reset` -- CREATE TABLE `password_reset` ( `id` int(255) NOT NULL, `username` varchar(255) NOT NULL, `token` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `quicklinks` -- CREATE TABLE `quicklinks` ( `id` int(255) NOT NULL, `name` varchar(255) NOT NULL, `url` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `support` -- CREATE TABLE `support` ( `id` int(255) NOT NULL, `title` varchar(255) NOT NULL, `text` text NOT NULL, `byuser` varchar(255) NOT NULL, `status` set('open','wait','closed','') NOT NULL, `toticketuser` varchar(255) NOT NULL, `ticket_answer` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `ticket-system` -- CREATE TABLE `ticket-system` ( `id` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `tickets` -- CREATE TABLE `tickets` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `msg` text NOT NULL, `user` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT current_timestamp(), `status` enum('open','closed','resolved') NOT NULL DEFAULT 'open' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `tickets_comments` -- CREATE TABLE `tickets_comments` ( `id` int(11) NOT NULL, `ticket_id` int(11) NOT NULL, `msg` text NOT NULL, `user` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `users` -- CREATE TABLE `users` ( `id` int(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `session_token` varchar(255) NOT NULL, `session_expire` int(255) NOT NULL, `max_bots` int(255) NOT NULL, `email` varchar(255) NOT NULL, `verify_token` varchar(300) NOT NULL, `status` set('active','blocked') NOT NULL, `role` set('admin','moderator','user') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Indizes der exportierten Tabellen -- -- -- Indizes für die Tabelle `admin_ticket` -- ALTER TABLE `admin_ticket` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `email_server` -- ALTER TABLE `email_server` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `musicbot` -- ALTER TABLE `musicbot` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `nodes` -- ALTER TABLE `nodes` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `password_reset` -- ALTER TABLE `password_reset` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `quicklinks` -- ALTER TABLE `quicklinks` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `support` -- ALTER TABLE `support` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `ticket-system` -- ALTER TABLE `ticket-system` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `tickets` -- ALTER TABLE `tickets` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `tickets_comments` -- ALTER TABLE `tickets_comments` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT für exportierte Tabellen -- -- -- AUTO_INCREMENT für Tabelle `admin_ticket` -- ALTER TABLE `admin_ticket` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45346; -- -- AUTO_INCREMENT für Tabelle `email_server` -- ALTER TABLE `email_server` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=767; -- -- AUTO_INCREMENT für Tabelle `musicbot` -- ALTER TABLE `musicbot` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=996591; -- -- AUTO_INCREMENT für Tabelle `news` -- ALTER TABLE `news` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39916; -- -- AUTO_INCREMENT für Tabelle `nodes` -- ALTER TABLE `nodes` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=913893; -- -- AUTO_INCREMENT für Tabelle `password_reset` -- ALTER TABLE `password_reset` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78398676; -- -- AUTO_INCREMENT für Tabelle `quicklinks` -- ALTER TABLE `quicklinks` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18588; -- -- AUTO_INCREMENT für Tabelle `support` -- ALTER TABLE `support` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=954253; -- -- AUTO_INCREMENT für Tabelle `ticket-system` -- ALTER TABLE `ticket-system` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT für Tabelle `tickets` -- ALTER TABLE `tickets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT für Tabelle `tickets_comments` -- ALTER TABLE `tickets_comments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=357; -- -- AUTO_INCREMENT für Tabelle `users` -- ALTER TABLE `users` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=940789; 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 */;