-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 15. Dez 2025 um 01:22
-- Server-Version: 8.0.42-33
-- PHP-Version: 7.2.34

START TRANSACTION;



--
-- Datenbank: `db_376260_43`
--

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

--
-- Tabellenstruktur für Tabelle `broadcasts`
--

CREATE TABLE `broadcasts` (
  `id` int NOT NULL,
  `moderator_id` int DEFAULT NULL,
  `broadcast_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Unbekannte Sendung',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `wunschbox_enabled` tinyint(1) DEFAULT '0',
  `wunschbox` tinyint(1) NOT NULL DEFAULT '0',
  `description_color` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '#ffffff',
  `time_limit_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `time_limit_minutes` int NOT NULL DEFAULT '20'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `broadcasts`
--

INSERT INTO `broadcasts` (`id`, `moderator_id`, `broadcast_date`, `start_time`, `end_time`, `title`, `description`, `image_path`, `wunschbox_enabled`, `wunschbox`, `description_color`, `time_limit_enabled`, `time_limit_minutes`) VALUES
(2, 9, '2025-12-14', '00:00:00', '02:00:00', 'Die Nachteulen Party', 'Party für alle Nachteulen ', NULL, 0, 0, '#ffffff', 0, 20),
(4, 36, '2025-12-14', '10:00:00', '13:00:00', 'Die Morning Show', 'Musik am Dritten Advent', 'vorlagen/morgen1.gif', 1, 0, '#ffffff', 0, 20),
(5, 36, '2025-12-14', '18:00:00', '20:00:00', 'Musik am Abend', 'Besinliche Weihnachtsmusik', NULL, 1, 0, '#ffffff', 0, 20);

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

--
-- Tabellenstruktur für Tabelle `broadcasts_archive`
--

CREATE TABLE `broadcasts_archive` (
  `id` int NOT NULL,
  `moderator_id` int NOT NULL,
  `broadcast_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Daten für Tabelle `broadcasts_archive`
--

INSERT INTO `broadcasts_archive` (`id`, `moderator_id`, `broadcast_date`, `start_time`, `end_time`, `title`, `created_at`) VALUES
(1, 12, '2025-12-14', '18:00:00', '20:00:00', 'Am Abend die schönste Musik', '2025-12-14 07:41:24'),
(2, 9, '2025-12-14', '00:00:00', '02:00:00', 'Die Nachteulen Party', '2025-12-14 07:41:24'),
(4, 36, '2025-12-14', '10:00:00', '12:00:00', 'Die Morning Show', '2025-12-14 09:55:36'),
(655, 0, '2025-12-14', '09:04:06', '09:04:06', 'Statistik wurde komplett geleert - 34 Einträge gelöscht', '2025-12-14 08:04:06');

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

--
-- Tabellenstruktur für Tabelle `moderator_categories`
--

CREATE TABLE `moderator_categories` (
  `id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `sort_order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `moderator_categories`
--

INSERT INTO `moderator_categories` (`id`, `name`, `sort_order`, `created_at`) VALUES
(1, 'Rathaus', 1, '2025-12-13 11:47:34'),
(2, 'Trallajaner', 2, '2025-12-13 11:47:34'),
(3, 'Ehren-Hörer', 4, '2025-12-13 11:47:34'),
(4, 'Unvergessen', 5, '2025-12-13 11:50:58'),
(5, 'Duo Moderatoren', 3, '2025-12-14 05:59:04');

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

--
-- Tabellenstruktur für Tabelle `moderator_notes`
--

CREATE TABLE `moderator_notes` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `moderator_notes`
--

INSERT INTO `moderator_notes` (`id`, `user_id`, `note`, `created_at`) VALUES
(1, 1, 'Ihr könnt jetzt während der Sendung die Wunschbox ausschalten. Bitte nach der Sendung die Wunschbox wieder starten wenn ihr sie gestoppt habt!!! ACHTUNG wenn ihr eine Sendung eintragt und diese um 0:00 endet, tragt sendungs ende 23:59 ein...das wichtig sonst wird sie nicht angezeigt!!!      Ihr Lieben, ihr könnt jetzt das Blasenspiel selber starten und Stoppen. Den Highscore könnt ihr nach jedem spiel wieder löschen wenn ihr wollt. Viel spass.', '2025-07-26 12:22:59');

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

--
-- Tabellenstruktur für Tabelle `settings`
--

CREATE TABLE `settings` (
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `settings`
--

INSERT INTO `settings` (`name`, `value`) VALUES
('wunschbox_disabled', '0');

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

--
-- Tabellenstruktur für Tabelle `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role` enum('admin','moderator') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `public_description` text COLLATE utf8mb4_general_ci,
  `private_notes` text COLLATE utf8mb4_general_ci,
  `profil_link` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `category_id` int DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`, `image_path`, `public_description`, `private_notes`, `profil_link`, `category_id`) VALUES
(2, 'Mutchatcho', '$2y$10$sw6q0sGhJZcbUJGzlrrbWuwu7xeJFWBlty6lJAdw7QPG2fhliefBG', 'admin', 'rahmen/1765628848_chris.gif', 'Der Bürgermeister\r\n', 'Sendeplan\r\nMutchatcho\r\nPW: Lefty2025\r\n--------------------------------\r\nAdmin bereich\r\nhttps://radioadmin.laut.fm/client/21844/\r\nBenutzer : mutchatcho65@gmail.com\r\nPW : SminiSmonty2710+\r\n----------------------------------\r\nRadiochat\r\nTrallajaner   Pw:sminismonty\r\n---------------------------------\r\nElement \r\nmutchatcho:matrix.org  \r\nPw schnegge0815\r\n----------------------------\r\nProfil\r\nMutchatcho  Pw: Schnegge0815\r\n-----------------------------\r\nThemensendung\r\nSchnegge  Pw:Heiligenhafen2025', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=1', 1),
(4, 'Samira2222', 'Holland', 'moderator', 'rahmen/2222.gif', '', 'Samira2222\r\nPW: Holland', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=5', 2),
(7, 'Schnegge', '$2y$10$9RcEJ1VU9q9k53ffiLg1BOaoeTfX/Z8nxiDsP4Ic7C9iAmbCb8Bue', 'admin', 'rahmen/1765631000_schnegge.gif', 'Rechte Hand vom Bürgermeister', 'Sendeplan\r\nSchnegge\r\nPW: Monty\r\n----------------\r\nShoutbox\r\nSchnegge   Pw: Schnegge2701+\r\n--------------------------\r\n2ter Account\r\n#Schnegge PW: Wuppertal2710+\r\n---------------------------\r\nAdmin shoutbox\r\nName : Citytalk\r\nUsername : Mutchatcho\r\nPW: Mutchatcho1608+\r\n--------------------------\r\nProfil\r\nSchnegge  Pw: Wuppertal2710', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=3', 1),
(8, 'Trucker', '$2y$10$UdTZ48Zw08z8tVGgKBMGROsYaJui.th6eTC3909LLTs/4Dsx7a03u', 'moderator', 'rahmen/1765633891_peter.gif', 'Alt aber bezahlt, daher Eigentum von RTC', 'Sendeplan\r\nTrucker  Pw MAN18502\r\n---------------------\r\nShoutbox\r\ntrucker710   Pw scaniafan\r\n-------------------------\r\nProfil\r\nTrucker   Pw:Scania', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=21', 2),
(9, 'Sandy', '$2y$10$9iU1vxfohL68c5lT9jekXu0zHwZPt5BCqN2Z6bgxDV2p.fvGVcPk.', 'moderator', 'rahmen/1765634084_sand.gif', 'Sandy aus Pforzheim', 'Sandy\r\nPw: Telefon2025', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=6', 2),
(10, 'City-Duo', '$2y$10$FQYQo9AYNY7YBmdHoI8EF.anDHCXZv62FQL8vuz4tqaRDWdVwKume', 'moderator', 'rahmen/1765634190_2doof.gif', 'Das Bild sagt alles', 'CityDuo\r\nPW: Ficken', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=7', 5),
(11, 'Maus62', '$2y$10$LuKXLU7qFijRFFBf.mxNI.jlx5qBKklGvGOjO2ibPQoTl.dOI/3My', 'moderator', 'rahmen/1765634276_maus62.png', 'Diese Maus fängt man mit Musik', '', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=8', 3),
(13, 'Blacky', '$2y$10$A9zoWAHr0uHg2Ykmd99wgu1jIu9SmBTxdLIXeBPBhgi1fAjsaaAdi', 'moderator', 'rahmen/1765634570_blacky.gif', 'Der Singende Modi', 'Sendeplan\r\nBlacky  Pw: Vogelhaus\r\n----------------------\r\nProfil\r\nBlacky   Pw:Affenhaus', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=13', 2),
(14, 'Wutti', '$2y$10$kYjI64A2ccbo5hlJx4wAXOWrosY4RhKRrL4mX65FUKMMWi4/8qfhG', 'moderator', 'rahmen/1765634668_wutti.png', 'Der aus`m Pott', 'Wutti\r\nPw; Duisburg', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=19', 2),
(15, 'Die Aybis', '$2y$10$TcycYHvANsTnWjZXdHn80Ojlvrl.DTBItoIDhL39ifOFUuvXcI1kC', 'moderator', 'rahmen/1765634771_aybis.gif', 'Ik glob mir streift n Bus', 'Die Aybis\r\nPW: Berlin', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=23', 5),
(16, 'Aybiman', '$2y$10$kK74XlAKWe4O5JDlWcgqd.Rqd/Wp443DOApS0K5YZkNUvOYmYoITO', 'moderator', 'rahmen/1765634880_ronny.gif', 'Der Gartenprofi', 'Profil\r\nAybiman  Pw: Berlin2\r\n---------------------\r\nSendplan\r\nDie Aybis\r\nPW: Berlin', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=25', 2),
(17, 'Aybi', '$2y$10$oYeW61uLXI7phClzdnWjx.40v7606LZI9mwamEcUuB4jGdgyXM33e', 'moderator', 'rahmen/1765634959_car.gif', 'Die Frau vom Gartenprofi', 'Profil\r\nAybi   Pw: Berlin1\r\n-------------------------\r\nSendplan\r\nDie Aybis\r\nPW: Berlin', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=25', 2),
(18, 'Flash', '$2y$10$cZ.ZjqYupE.0MOqOZAJFROOAdVA6KwDwl/MnqLy5A5rC1RF6PvTT2', 'moderator', 'rahmen/1765635046_dennis.gif', 'Gebt ihm kein Schlitten', 'Sendeplan\r\nFlash  Pw: Baum\r\n----------------------\r\nProfil\r\nFlash  Pw: Baum', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=24', 2),
(19, 'Svenni', '$2y$10$j5fRPNcrehms4ClmD0r/c.hWqKR6SO90XKDOBtV7VSxwxcQ2qT.0a', 'moderator', 'rahmen/1765635255_sven.png', 'Die Wunschbox zittert vor ihm', '', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=27', 3),
(20, 'Madita', '$2y$10$Uzu4LNL/lwg6fxSL32wDUu.LLnjUiSgKOo1jKpm3EilkmC2D6CRbC', 'moderator', 'rahmen/1765635480_Madita.png', 'Beschreibung folgt', 'Sendeplan:\r\nMadita\r\nPW: GastMadita2025', 'https://radiotrallacity.de/nixprofil.html', 2),
(21, 'CircaJAbisNein', '$2y$10$1eacUUXpi1rFx3XQ6FsIvO/x2InyAw9bfJehXZtaxRiHFdBdd0fYu', 'moderator', 'rahmen/1765635799_circa.gif', 'In Greifswald hat man viel Durst', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(22, 'DartBaer', '$2y$10$23ZeLsOHoFyKgacI2m2QBuvdN0t.31eID3KjOOYeYOecgtcN2dtEy', 'moderator', 'rahmen/1765635895_dart.gif', 'Zielsicher', 'Dartbär\r\nPW: dart\r\nPw :pfeil', 'https://radiotrallacity.de/nixprofil.html', 2),
(23, 'Extic', '$2y$10$JK6TnoL2IV0mnmFz6OO0ounGfyUaU.Eu156g3BonpHwK2OTRO8jc6', 'moderator', 'rahmen/1765636135_exo.gif', 'Technik trifft Know How', 'Exotic\r\nPw: 220666xx', 'https://radiotrallacity.de/nixprofil.html', 2),
(24, 'Stream-Jumper', '$2y$10$tf9pJyC3LA83mrqmCT1y7umz297daqvwiYc4NGTUOIdAytgsVs5b2', 'moderator', 'rahmen/1765637600_jump.gif', 'Hüpf Hüpf', 'StreamJumper\r\nPw:Huepf', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=11', 5),
(25, 'Das Chaotische Duo', '$2y$10$Ow9Vs/sIzwXbJk6naysTZuE6CWskH6tl9iQET.xeWy5LYD8byyiXu', 'moderator', 'rahmen/1765636438_cduo.gif', 'Gesucht - Gefunden', 'Das Chaotische Duo\r\nPw: 220666xx', 'https://radiotrallacity.de/nixprofil.html', 5),
(26, 'Florian', '$2y$10$Yjvtf.2w8Jm.WwEcjXstveZlHc2O013uS7QeVn.p.BKHXlK7gJaQK', 'moderator', 'rahmen/1765636604_florian.gif', 'Fussball, Fussball, Fussball und Bundesliga', 'Florian\r\nPw: SCPaderborn', 'https://radiotrallacity.de/nixprofil.htm', 2),
(27, 'Pad', '$2y$10$UBibkKAP2/l9oh2zf4AE3.1/zK9YjzLwHOjzYdczNRz4GzP150ZKW', 'moderator', 'rahmen/1765636720_pad.gif', 'Wir freuen uns immer wenn er da ist', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(28, 'Michi', '$2y$10$61aAVC9MYm8P2bmUibLvP.9X/VGAhPuVKQVZ67IRvIFm95et3bHva', 'moderator', 'rahmen/1765636870_michi.gif', 'Aus Bielefeld', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(29, 'Geister-Hörer', '$2y$10$CMg0YWkXy4vgPa7rvRNyVu3WYcvJI4c.x6Z7L2My3MFKn8aAvvwKG', 'moderator', 'rahmen/1765636989_gost.gif', 'Sie lauschen aber man sieht sie nie', '', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=10', 3),
(30, 'Frosch', '$2y$10$R2c4fDG9uY05E4ZO/Kuo3ueyER0NrDCuz.z8tF3jyiqMjbizK0m9u', 'moderator', 'rahmen/1765637071_frosch.png', 'Wohnt in einem Tümpel hinter der Grenze', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(31, 'Daydream', '$2y$10$QRLQXHd0JggTyEmPIViyCu9E5.io83atVFG9ZPVSPGB6XhwFYcimu', 'moderator', 'rahmen/1765637170_daydream.png', 'Fing als Türsteherin an und Arbeitete sich bis zum WC hoch', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(32, 'Zaubermaus', '$2y$10$D/uPq5hWIqss7njY13H7IO9vGdMNxG0oj5gdu1UmcLfdfzlj9cpMO', 'moderator', 'rahmen/1765637233_zm.gif', 'Aus Kassel', '', 'https://radiotrallacity.de/nixprofil.html', 3),
(33, 'King Elvis', '$2y$10$RjzmFJrdeuIffQ9CFYejeuCY/1k5eRcvj4IyAdXNEqH/vOvEbk.ea', 'moderator', 'rahmen/1765637322_uwe.gif', 'Du bist immer bei uns', '', 'https://radiotrallacity.de/uwe.html', 4),
(34, 'TrallaKitty', '$2y$10$DWY9U9IRNPUwfbY146ks1.PnDZWdW6C5HQ00YKhEqjN/.ZFLg65D.', 'moderator', 'rahmen/1765637420_dancecat1.gif', 'Unser Auto-Dj', 'Sendeplan\r\nTrallaKitty\r\nPW: Musik    ????\r\n------------------------------', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=4', 2),
(35, 'Geburtstags-Jumper', '$2y$10$VQ086IFrW9Ia4dglJpFwfuaSKt6/ADlQFoJkBzUS9KXNxddBil9IK', 'moderator', 'rahmen/1765637581_gebjump.gif', 'Der Name sagt es schon', 'Geburtstags-Jumper\r\nPw: Happyday', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=11', 5),
(36, 'Campino', '$2y$10$zWK9ii9gztHFaUWZwynzzOSS98ump4x2g2GjeBKdL2vU0TPML2vqy', 'moderator', 'rahmen/1765702958_campi.gif', 'Der Morning Star', 'Sendeplan\r\nCampino   Pw: Affenhaus \r\n------------------------------\r\nProfil\r\nCampino  Pw: Vogelhaus', 'https://radiotrallacity.de/profile/profil-user_profile.php?user_id=12', 2),
(38, 'Teefax', '$2y$10$wot3e2Jr.U4GsrSdF4K.auDINtVTWTy6kdgsp1dfD5s.8reBjkP1y', 'moderator', 'rahmen/1765707131_teefax.gif', '', '', 'https://radiotrallacity.de/nixprofil.html', 3);

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

--
-- Tabellenstruktur für Tabelle `wishes`
--

CREATE TABLE `wishes` (
  `id` int NOT NULL,
  `visitor_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `music_wish` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  `greeting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `greetings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `wishes_archive`
--

CREATE TABLE `wishes_archive` (
  `id` int NOT NULL,
  `visitor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `artist` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `greeting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `wishes_archive`
--

INSERT INTO `wishes_archive` (`id`, `visitor_name`, `artist`, `title`, `created_at`, `ip_address`, `greeting`) VALUES
(1, 'ich', 'du', 'kein', '2025-12-14 07:34:32', '2a02:908:956:7be0:544f:9994:77eb:277d', NULL),
(2, 'Mutchatcho', 'Peter Maffay', 'Alter Mann', '2025-12-14 10:07:54', '2a02:908:956:7be0:544f:9994:77eb:277d', NULL),
(3, 'Mutchatcho', 'test', 'test', '2025-12-14 10:09:05', '2a02:908:956:7be0:544f:9994:77eb:277d', NULL),
(4, 'Svenni', 'Olaf Henning', 'Was macht der Weihnachtsmann im Sommer', '2025-12-14 10:14:21', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(5, 'Svenni', 'Udo Mc Muff & Kreisligalegende feat. Ikke Hüftgold', 'Eine Muh, eine Mäh', '2025-12-14 10:25:46', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(6, 'Svenni', 'Mickie Krause & Cindy aus Mahrzahn', 'Una Paloma Blanca', '2025-12-14 10:34:30', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(7, 'Schnegge', 'Wham', 'Last christmas', '2025-12-14 10:43:53', '2a02:908:956:7be0:917a:edbe:a75b:a663', NULL),
(8, 'Svenni', 'Costa Cordlis', 'Steig in das Boot heute nacht, Anna Lena', '2025-12-14 10:47:34', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(9, 'Michi', 'Shantallica', 'Wir in Bielefeld', '2025-12-14 10:56:07', '2003:6:3184:ddd4:50cf:4213:ea88:60fe', NULL),
(10, 'Samira', 'Wolfgang Petry', 'Wir sind das Ruhrgebiet', '2025-12-14 11:10:52', '2a02:a46a:7bb7:0:7195:59dc:c003:30a9', NULL),
(11, 'Svenni', 'Safri Duo', 'Played-a-live', '2025-12-14 11:21:53', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(12, 'Svenni', 'DJ Ötzi', 'My Bonnie is over the Ocean', '2025-12-14 11:35:51', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(13, 'Svenni', 'Alan Jackson', 'Chattahoochee', '2025-12-14 11:37:31', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(14, 'Svenni', 'Udo Jürgens', 'Merry Christmas allerseits', '2025-12-14 18:06:15', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(15, 'Svenni', 'Die Toten Hosen', 'The Little Drummer Boy', '2025-12-14 18:08:26', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(16, 'Svenni', 'Puhdys', 'Dezembernächte', '2025-12-14 18:13:24', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(17, 'Svenni', 'Otto Waalkes', 'Single Bells - Fröhliche Weihnachten!', '2025-12-14 18:24:47', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(18, 'Svenni', 'Elvis Presley', 'Silent Night (Official Audio)', '2025-12-14 18:37:22', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL),
(19, 'Svenni', 'Cher', 'DJ Play a Christmas Song', '2025-12-14 18:38:49', '2a02:908:4b21:e1c0:d512:e21e:159d:104c', NULL);

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

--
-- Tabellenstruktur für Tabelle `wunschbox_config`
--

CREATE TABLE `wunschbox_config` (
  `id` int NOT NULL,
  `time_limit_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `time_limit_minutes` int NOT NULL DEFAULT '20'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `wunschbox_config`
--

INSERT INTO `wunschbox_config` (`id`, `time_limit_enabled`, `time_limit_minutes`) VALUES
(1, 0, 20);

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

--
-- Tabellenstruktur für Tabelle `yearly_stats`
--

CREATE TABLE `yearly_stats` (
  `id` int NOT NULL,
  `moderator_id` int NOT NULL,
  `username` varchar(100) NOT NULL,
  `anzahl_sendungen` int DEFAULT '0',
  `gesamt_sendezeit` time DEFAULT '00:00:00',
  `stat_year` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Daten für Tabelle `yearly_stats`
--

INSERT INTO `yearly_stats` (`id`, `moderator_id`, `username`, `anzahl_sendungen`, `gesamt_sendezeit`, `stat_year`) VALUES
(159, 2, 'Mutchatcho', 0, '00:00:00', 2025),
(160, 4, 'Samira2222', 0, '00:00:00', 2025),
(161, 7, 'Schnegge', 0, '00:00:00', 2025),
(162, 8, 'Trucker', 0, '00:00:00', 2025),
(163, 9, 'Sandy', 1, '02:00:00', 2025),
(164, 10, 'City-Duo', 0, '00:00:00', 2025),
(165, 11, 'Maus62', 0, '00:00:00', 2025),
(166, 13, 'Blacky', 0, '00:00:00', 2025),
(167, 14, 'Wutti', 0, '00:00:00', 2025),
(168, 15, 'Die Aybis', 0, '00:00:00', 2025),
(169, 16, 'Aybiman', 0, '00:00:00', 2025),
(170, 17, 'Aybi', 0, '00:00:00', 2025),
(171, 18, 'Flash', 0, '00:00:00', 2025),
(172, 19, 'Svenni', 0, '00:00:00', 2025),
(173, 20, 'Madita', 0, '00:00:00', 2025),
(174, 21, 'CircaJAbisNein', 0, '00:00:00', 2025),
(175, 22, 'DartBaer', 0, '00:00:00', 2025),
(176, 23, 'Extic', 0, '00:00:00', 2025),
(177, 24, 'Stream-Jumper', 0, '00:00:00', 2025),
(178, 25, 'Das Chaotische Duo', 0, '00:00:00', 2025),
(179, 26, 'Florian', 0, '00:00:00', 2025),
(180, 27, 'Pad', 0, '00:00:00', 2025),
(181, 28, 'Michi', 0, '00:00:00', 2025),
(182, 29, 'Geister-Hörer', 0, '00:00:00', 2025),
(183, 30, 'Frosch', 0, '00:00:00', 2025),
(184, 31, 'Daydream', 0, '00:00:00', 2025),
(185, 32, 'Zaubermaus', 0, '00:00:00', 2025),
(186, 33, 'King Elvis', 0, '00:00:00', 2025),
(187, 34, 'TrallaKitty', 0, '00:00:00', 2025),
(188, 35, 'Geburtstags-Jumper', 0, '00:00:00', 2025),
(189, 36, 'Campino', 1, '02:00:00', 2025),
(190, 38, 'Teefax', 0, '00:00:00', 2025);

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `broadcasts`
--
ALTER TABLE `broadcasts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `moderator_id` (`moderator_id`);

--
-- Indizes für die Tabelle `broadcasts_archive`
--
ALTER TABLE `broadcasts_archive`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indizes für die Tabelle `moderator_categories`
--
ALTER TABLE `moderator_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `moderator_notes`
--
ALTER TABLE `moderator_notes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`name`);

--
-- Indizes für die Tabelle `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD KEY `category_id` (`category_id`);

--
-- Indizes für die Tabelle `wishes`
--
ALTER TABLE `wishes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `wishes_archive`
--
ALTER TABLE `wishes_archive`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `wunschbox_config`
--
ALTER TABLE `wunschbox_config`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `yearly_stats`
--
ALTER TABLE `yearly_stats`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_stat` (`moderator_id`,`stat_year`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `broadcasts`
--
ALTER TABLE `broadcasts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT für Tabelle `broadcasts_archive`
--
ALTER TABLE `broadcasts_archive`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=656;

--
-- AUTO_INCREMENT für Tabelle `moderator_categories`
--
ALTER TABLE `moderator_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT für Tabelle `moderator_notes`
--
ALTER TABLE `moderator_notes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT für Tabelle `wishes`
--
ALTER TABLE `wishes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT für Tabelle `wishes_archive`
--
ALTER TABLE `wishes_archive`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT für Tabelle `wunschbox_config`
--
ALTER TABLE `wunschbox_config`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `yearly_stats`
--
ALTER TABLE `yearly_stats`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=222;

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `broadcasts`
--
ALTER TABLE `broadcasts`
  ADD CONSTRAINT `broadcasts_ibfk_1` FOREIGN KEY (`moderator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `moderator_categories` (`id`) ON DELETE SET NULL;
COMMIT;

