-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 17. Aug 2025 um 08:43
-- Server-Version: 8.0.42-33
-- PHP-Version: 7.2.34

START TRANSACTION;



--
-- Datenbank: `db_376260_24`
--

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

--
-- 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) 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
(368, 28, '2025-08-09', '20:00:00', '23:59:00', 'Nightlife', 'Mit Sandy durch die Nacht', 'vorlagen/nightlife.gif', 0, 0, '#ffffff', 0, 20),
(372, 21, '2025-08-16', '10:00:00', '12:00:00', 'GeburtstagsJump', 'Wer kann -kommt dran !', 'uploads/1754400784_oie_GdkTtl7TyZD6.gif', 0, 0, '#a7947a', 0, 20),
(380, 10, '2025-08-09', '10:00:00', '13:00:00', 'Morning show', 'Samstag musik bitte danke', 'uploads/1754722383_527814559_122150338820770722_4781782652165190479_n.jpg', 1, 0, '#ffffff', 0, 20),
(382, 9, '2025-08-10', '11:00:00', '13:00:00', 'Mal wieder ohne Sinn und Verstand', 'mal wieder alles Käse', 'uploads/1754770372_Käse.jpg', 0, 0, '#ffffff', 0, 20),
(383, 10, '2025-08-10', '09:10:00', '11:00:00', 'Spontan Musik', 'Spontan', NULL, 1, 0, '#ffffff', 0, 20),
(384, 10, '2025-08-11', '10:00:00', '12:00:00', 'Morning show', 'Eine kertze und der kaffe zu gedenken es fehlt nur noch Musik', 'uploads/1754871005_531223530_122157027074610526_281742533462364702_n.jpg', 1, 0, '#ffffff', 0, 20),
(385, 10, '2025-08-12', '10:00:00', '12:00:00', 'Morning show', 'Moin Moin bin noch da', 'uploads/1754984371_529155362_1322157085932860_9160670207706524742_n.jpg', 1, 0, '#ffffff', 0, 20),
(386, 10, '2025-08-14', '20:00:00', '22:00:00', 'Interpret wird gesucht', 'Wir suchen Interpreten 1 Münchner Freiheit song ohne dich schlaf ich nicht ein 2 Song Max Werner song Rain In May \r\nWiw immer in der w boy 1 bis 100 nur 1 zagl', 'uploads/1755024641_2 suche-imageonline.co-merged.jpeg', 1, 0, '#ffffff', 0, 20),
(387, 10, '2025-08-13', '10:00:00', '12:00:00', 'Morning show', 'Wenn die sonne lacht vor hitze mit musik ', 'uploads/1755071017_529861073_122151318434770722_4345873874628751344_n.jpg', 1, 0, '#ffffff', 0, 20),
(388, 10, '2025-08-13', '19:00:00', '22:00:00', 'Hosse Musik am Abend', 'Spontan musik ich schwitze genügend und trommel hier u daum abkühlung', 'uploads/1755103169_475114567_940079941562123_2185829564589591565_n.jpg', 1, 0, '#ffffff', 0, 20),
(389, 10, '2025-08-14', '10:00:00', '12:00:00', 'Morning show', 'Prost mit kaffe an alle ob der modi kaffe bekommt wollen es sehen ', 'uploads/1755156993_481054017_1190900122604500_3420710795290308419_n.jpg', 1, 0, '#ffffff', 0, 20),
(390, 10, '2025-08-15', '10:00:00', '12:00:00', 'Morning show', 'Dann wollen wir mal Musik am Moin Hossa Party', 'uploads/1755243877_474187961_9107639172605952_8786132549690004490_n.jpg', 1, 0, '#ffffff', 0, 20),
(391, 28, '2025-08-16', '20:00:00', '23:59:00', 'Nightlife mit Schlagercharts von Mittwoch', 'Heute in der Nightlife die Schlager Charts, da sie am Mittwoch ausgefallen sind...', NULL, 0, 0, '#ffffff', 0, 20);

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

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

CREATE TABLE `moderator_notes` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `note` text 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
(21, 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 `moderator_stats`
--

CREATE TABLE `moderator_stats` (
  `id` int NOT NULL,
  `moderator_id` int NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `anzahl_sendungen` int DEFAULT '0',
  `gesamt_sendezeit` time DEFAULT '00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `moderator_stats`
--

INSERT INTO `moderator_stats` (`id`, `moderator_id`, `username`, `anzahl_sendungen`, `gesamt_sendezeit`) VALUES
(1, 3, 'TrallaKitty', 0, NULL),
(2, 4, 'Dartbaer', 0, NULL),
(3, 5, 'Samira2222', 0, NULL),
(4, 8, 'Die Aybis', 0, NULL),
(5, 9, 'Trucker', 1, '02:00:00'),
(6, 10, 'Campino', 9, '19:50:00'),
(7, 11, 'Blacky', 0, NULL),
(8, 12, 'Flash', 0, NULL),
(9, 13, 'Aybi', 0, NULL),
(10, 14, 'Aybiman', 0, NULL),
(11, 16, 'DuoKaarst', 0, NULL),
(12, 17, 'Exotic', 0, NULL),
(13, 18, 'Das Chaotische Duo', 0, NULL),
(14, 21, 'GeburtstagsJumper', 1, '02:00:00'),
(15, 22, 'StreamJumper', 0, NULL),
(16, 23, 'CityDuo', 0, NULL),
(17, 24, 'Wutti', 0, NULL),
(18, 25, 'Florian', 0, NULL),
(19, 26, 'Mr.Wellington', 0, NULL),
(20, 27, 'Mrs.Wellington', 0, NULL),
(21, 28, 'Sandy', 2, '07:58:00'),
(22, 32, 'BlackTiger', 0, NULL),
(23, 33, 'Duo SandTiger', 0, NULL),
(24, 35, 'Maus62', 0, NULL);

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

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

CREATE TABLE `settings` (
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `value` text 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 `wishes`
--

CREATE TABLE `wishes` (
  `id` int NOT NULL,
  `visitor_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `music_wish` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  `greeting` text COLLATE utf8mb4_general_ci,
  `greetings` text 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) COLLATE utf8mb4_general_ci NOT NULL,
  `greeting` text 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
(1492, 'Svenni', 'Vincent Gross', 'Camping', '2025-08-07 10:11:11', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1493, 'Svenni', 'Mickie Krause', 'Nachts im dichten Fichtendickicht', '2025-08-07 10:11:51', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1494, 'Samira2222', 'Vincent Gross', 'Über uns die Sonne', '2025-08-07 10:15:05', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1495, 'Samira2222', 'Ultimate Kaos', 'Casanova', '2025-08-07 10:16:04', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1496, 'Samira2222', 'Adel Tawil', 'Ist da jemand', '2025-08-07 10:16:44', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1497, 'Maus', 'rossi und krause', 'was bitte was', '2025-08-07 10:26:39', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1498, 'Maus', 'lorenz büffel oli p', 'maja', '2025-08-07 10:27:41', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1499, 'Samira2222', 'Andreas Zaron', 'Wie ein Komet', '2025-08-07 10:29:49', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1500, 'Maus', 'krause büffel  + kings of günter +immer hansi', 'Baila Baila', '2025-08-07 10:31:16', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1501, 'Samira2222', 'Beatrice Egli', 'Au Revoir', '2025-08-07 10:32:32', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1502, 'Maus', 'satire  sound of music', 'Rente war gestern', '2025-08-07 10:35:25', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1503, 'Maus', 'vincent gross + olaf der flipper', 'drinking wine feeling fine', '2025-08-07 10:38:06', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1504, 'Samira2222', 'Helene Fischer und Silbereisen', 'Schau mal herein', '2025-08-07 11:04:36', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1505, 'Svenni', '', '1', '2025-08-07 18:01:26', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1506, 'Maus', '7', '7', '2025-08-07 18:09:23', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1507, 'Maus', '30', '30', '2025-08-07 18:10:03', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1508, 'Schnegge', '--', '17', '2025-08-07 18:15:58', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1509, 'Schnegge', '--', '84', '2025-08-07 18:16:10', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1510, 'Schnegge', '--', '63', '2025-08-07 18:18:56', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1511, 'Svenni', '15', '', '2025-08-07 18:19:30', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1512, 'Schnegge', '--', '28', '2025-08-07 18:20:54', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1513, 'Circa', '--', '8', '2025-08-07 18:21:56', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1514, 'Schnegge', '--', '34', '2025-08-07 18:34:46', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1515, 'Svenni', '10', '', '2025-08-07 18:36:42', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1516, 'Biene', '---', '3', '2025-08-07 18:43:03', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1517, 'Maus', '29', '29', '2025-08-07 18:44:41', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1518, 'Svenni', '33', '', '2025-08-07 18:52:26', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1519, 'Schnegge', '--', '26', '2025-08-07 18:53:35', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1520, 'Schnegge', '--', '72', '2025-08-07 19:03:16', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1521, 'Svenni', '50', '', '2025-08-07 19:03:41', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1522, 'Maus', '32', '32', '2025-08-07 19:07:35', '2001:16b8:b8d6:df00:44ca:52aa:6d08:2df1', NULL),
(1523, 'Schnegge', '--', '19', '2025-08-07 19:10:02', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1524, 'Schnegge', '--', '20', '2025-08-07 19:10:18', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1525, 'Schnegge', '--', '21', '2025-08-07 19:11:09', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1526, 'Svenni', '16', '', '2025-08-07 19:14:03', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1527, 'Svenni', '51', '', '2025-08-07 19:24:19', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1528, 'Schnegge', '--', '93', '2025-08-07 19:24:23', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1529, 'Svenni', '75', '', '2025-08-07 19:24:44', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1530, 'Schnegge', '99', '99', '2025-08-07 19:25:26', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1531, 'Svenni', '39', '', '2025-08-07 19:35:37', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1532, 'Svenni', '41', '', '2025-08-07 19:36:21', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1533, 'Schnegge', '--', '43', '2025-08-07 19:37:23', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1534, 'Schnegge', '44', '44', '2025-08-07 19:37:37', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1535, 'Schnegge', '37', '37', '2025-08-07 19:38:30', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1536, 'Schnegge', '54', '54', '2025-08-07 19:44:44', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1537, 'Svenni', '54', '', '2025-08-07 19:44:52', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1538, 'Schnegge', '64', '64', '2025-08-07 19:44:54', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1539, 'Schnegge', '74', '74', '2025-08-07 19:45:28', '2a02:908:950:1f80:183e:6734:75d3:156d', NULL),
(1540, 'Svenni', 'Vincent Varus', 'Coffee', '2025-08-08 08:04:02', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1541, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf', '2025-08-08 08:04:28', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1542, 'Samira2222', 'Ella Endlich', 'Hand in Hand', '2025-08-08 08:07:45', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1543, 'Samira2222', 'Daniela alfinito', 'ich geb alles', '2025-08-08 08:08:41', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1544, 'Samira2222', 'Nino de angelo', 'Nicht eine Träne', '2025-08-08 08:09:50', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1545, 'Svenni', 'Roy Bianco & Die Abbrunzati Boys', 'Bella Napoli', '2025-08-08 08:10:46', '2a02:908:4b21:e1c0:2826:cca3:91f0:348b', NULL),
(1546, 'Exotic', 'Gefangenchor', 'Nabucco', '2025-08-08 08:17:44', '2001:9e8:f991:dd00:d4a8:587f:a11c:8814', NULL),
(1547, 'Samira2222', 'Andrea Berg', 'viel zu schön um wahr zu sein', '2025-08-08 08:21:01', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1548, 'Samira2222', 'Sigrid und Marina', 'ich hab schon lange nicht mehr danke gesagt', '2025-08-08 08:30:18', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1549, 'Samira2222', 'Matrosen in Lederhosen', 'Quellkartoffel und dupp dupp', '2025-08-08 08:31:48', '2a02:a442:cc0e:0:fe6c:67cb:1e87:90d4', NULL),
(1550, 'Exotic', 'Unheilig', 'So wie du warst', '2025-08-08 08:49:09', '2001:9e8:f991:dd00:d4a8:587f:a11c:8814', NULL),
(1551, 'Samira2222', 'Kenny loggins', 'danger zone', '2025-08-09 08:43:56', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1552, 'Samira2222', 'Lionel richie', 'stuck on you', '2025-08-09 08:45:19', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1553, 'Samira2222', 'Berlin', 'Take my Breath away', '2025-08-09 08:46:16', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1554, 'Samira2222', 'Peabo Bryson', 'If ever your in my arms again', '2025-08-09 08:48:40', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1555, 'Samira2222', 'Scorpions', 'Still loving you', '2025-08-09 08:55:36', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1556, 'Samira2222', 'Howard Carpendale', 'Deine spuren im sand', '2025-08-09 09:00:56', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1557, 'Samira2222', 'Roy Black', 'Sand in deinen Augen', '2025-08-09 09:02:39', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1558, 'Samira2222', 'Kaoma', 'lambada', '2025-08-09 09:53:00', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1559, 'Samira2222', 'Kate Yanai', 'Summer dreaming', '2025-08-09 09:54:01', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1560, 'Samira2222', 'nathalie cardone', 'Hasta siempre', '2025-08-09 10:02:40', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1561, 'Samira2222', 'Marco schuitmaker', 'engelbewaarder', '2025-08-09 10:48:52', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1562, 'Samira2222', 'Nino de angelo', 'wer bringt dich nach hause', '2025-08-10 07:56:46', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1563, 'Samira2222', 'Helene Fischer und Silbereisen', 'Schau mal herein', '2025-08-10 07:58:38', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1564, 'Samira2222', 'Eric Philippi', 'Schockverliebt', '2025-08-10 08:00:51', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1565, 'Samira2222', 'Matthias Reim und Marie Reim', 'Hallo ich möchte gern wissen wie es dir geht....', '2025-08-10 08:02:35', '2a02:a442:cc0e:0:71b1:d747:f26:5c0f', NULL),
(1566, 'Samira2222', 'Conny Froboess', 'zwei kleine italiener', '2025-08-10 08:33:34', '80.60.205.146', NULL),
(1567, 'Svenni', 'UFO', 'Doctor Doctor', '2025-08-11 09:28:19', '2a02:908:4b21:e1c0:acb0:2513:7456:5114', NULL),
(1568, 'Svenni', 'Vincent Gross', 'Aperol Spritz', '2025-08-11 09:47:53', '2a02:908:4b21:e1c0:acb0:2513:7456:5114', NULL),
(1569, 'Schnegge', 'Ibo', 'Nimm den ersten flieger her', '2025-08-12 08:06:54', '2a02:908:950:1f80:d199:47bf:8e78:76eb', NULL),
(1570, 'Svenni', 'Mickie Krause', 'Gartenhütte', '2025-08-12 08:08:58', '95.223.106.123', NULL),
(1571, 'Svenni', 'Vincent Gross', 'Camping', '2025-08-12 08:09:19', '95.223.106.123', NULL),
(1572, 'Svenni', 'Beatrice Egli', 'Du, Du, Du', '2025-08-12 08:12:58', '95.223.106.123', NULL),
(1573, 'Svenni', 'Melissa Naschenweng', 'Braungebrannte Haut', '2025-08-12 08:14:24', '95.223.106.123', NULL),
(1574, 'Svenni', 'Lorenz Büffel, Oli P.', 'Maja', '2025-08-12 08:16:09', '95.223.106.123', NULL),
(1575, 'Svenni', 'Mätropolis, DJ Aaron', 'Rakete', '2025-08-12 08:17:00', '95.223.106.123', NULL),
(1576, 'Schnegge', 'Marco Schuitmaker', 'Engelbewaarder (original)', '2025-08-12 08:17:51', '2a02:908:950:1f80:d199:47bf:8e78:76eb', NULL),
(1577, 'Svenni', 'Stereoact & Redblack', 'Sará Perché Ti Amo', '2025-08-12 08:22:07', '95.223.106.123', NULL),
(1578, 'Svenni', 'Andreas Gabalier', 'Jukeboxblues', '2025-08-12 08:29:53', '95.223.106.123', NULL),
(1579, 'Svenni', 'Matthias Reim', 'Echte Helden', '2025-08-12 08:30:53', '95.223.106.123', NULL),
(1580, 'Svenni', 'Nik P.', 'Das Meer, der Wind und du', '2025-08-12 08:32:00', '95.223.106.123', NULL),
(1581, 'Schnegge', 'Eric Philippi', 'Schockverliebt', '2025-08-12 08:43:14', '2a02:908:950:1f80:d199:47bf:8e78:76eb', NULL),
(1582, 'Schnegge', 'michelle-matthias reim', 'du idiot', '2025-08-12 08:57:03', '2a02:908:950:1f80:d199:47bf:8e78:76eb', NULL),
(1583, 'Svenni', 'Semino Rossi', 'Ja, ja, ja, ja', '2025-08-12 09:10:05', '95.223.106.123', NULL),
(1584, 'Svenni', 'Frank Lars', 'Dornröschen', '2025-08-12 09:15:35', '95.223.106.123', NULL),
(1585, 'Svenni', 'Die Paldauer', 'Bis ans Ende der Welt', '2025-08-12 09:29:13', '95.223.106.123', NULL),
(1586, 'Svenni', 'Nockis', 'Seit 1870', '2025-08-12 09:31:55', '95.223.106.123', NULL),
(1587, 'Svenni', 'DJ Mox & Susal, die Partyhexe', 'Im Winter Schneemann', '2025-08-12 09:35:07', '95.223.106.123', NULL),
(1588, 'Svenni', '2Raumwohnung', '36 Grad', '2025-08-14 08:14:14', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1589, 'Svenni', 'Axel Fischer', 'Norderney', '2025-08-14 08:25:47', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1590, 'Svenni', 'Vincent Gross & Olaf der Flipper', 'Drinking Wine Feeling Fine', '2025-08-14 08:28:56', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1591, 'Svenni', 'Oli P.', 'Hey Freiheit (Aloha Heja He)', '2025-08-14 08:40:37', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1592, 'Svenni', 'Ben Zucker', 'Guten Morgen Welt', '2025-08-14 08:41:47', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1593, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf', '2025-08-14 08:42:41', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1594, 'Svenni', 'Bürger Lars Dietrich', 'Sexy Eis', '2025-08-14 08:45:51', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1595, 'Svenni', 'Lollies', 'Arsch im Sand', '2025-08-14 09:13:58', '2a02:908:4b21:e1c0:d98a:e657:3d04:8382', NULL),
(1596, 'Schnegge', 'Gombay Dance Band', 'Sun Of Jamaica', '2025-08-14 09:17:23', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1597, 'Schnegge', 'Snäp', 'Sommer, Sonne, Sand Und Meer', '2025-08-14 09:19:45', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1598, 'Schnegge', '----', '72', '2025-08-14 18:00:37', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1599, 'Schnegge', '--', '63', '2025-08-14 18:02:06', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1600, 'Schnegge', '----', '51', '2025-08-14 18:02:30', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1601, 'Schnegge', '--', '23', '2025-08-14 18:02:52', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1602, 'Schnegge', '--', '82', '2025-08-14 18:03:55', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1603, 'Schnegge', '--', '36', '2025-08-14 18:20:49', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1604, 'Schnegge', '--', '12', '2025-08-14 18:32:10', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1605, 'Schnegge', '--', '46', '2025-08-14 18:32:39', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1606, 'Schnegge', '--', '14', '2025-08-14 18:38:01', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1607, 'Schnegge', '--', '42', '2025-08-14 18:40:03', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1608, 'Schnegge', '--', '34', '2025-08-14 18:42:23', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1609, 'Schnegge', '--', '27', '2025-08-14 18:47:05', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1610, 'Schnegge', '--', '53', '2025-08-14 18:49:53', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1611, 'Maus', '38', '38', '2025-08-14 18:50:14', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1612, 'Maus', '64', '64', '2025-08-14 18:50:43', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1613, 'Maus', '85', '85', '2025-08-14 18:51:21', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1614, 'Maus', '26', '26', '2025-08-14 18:51:45', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1615, 'Maus', '90', '90', '2025-08-14 18:52:13', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1616, 'Schnegge', '--', '84', '2025-08-14 18:52:22', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1617, 'Maus', '35', '35', '2025-08-14 18:54:02', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1618, 'Maus', '37', '37', '2025-08-14 18:55:22', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1619, 'Maus', '99', '99', '2025-08-14 18:56:22', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1620, 'Maus', '39', '39', '2025-08-14 18:59:15', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1621, 'Maus', '33', '33', '2025-08-14 18:59:30', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1622, 'Maus', '52', '52', '2025-08-14 18:59:53', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1623, 'Schnegge', '--', '54', '2025-08-14 19:00:24', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1624, 'Maus', '43', '43', '2025-08-14 19:00:35', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1625, 'Maus', '50', '50', '2025-08-14 19:01:52', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1626, 'Schnegge', '40', '40', '2025-08-14 19:02:23', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1627, 'Schnegge', '30', '30', '2025-08-14 19:02:34', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1628, 'Maus', '40', '40', '2025-08-14 19:02:38', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1629, 'Maus', '60', '60', '2025-08-14 19:02:54', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1630, 'Maus', '70', '70', '2025-08-14 19:03:07', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1631, 'Schnegge', '70', '70', '2025-08-14 19:03:17', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1632, 'Schnegge', '--', '100', '2025-08-14 19:03:26', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1633, 'Maus', '20', '20', '2025-08-14 19:03:31', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1634, 'Maus', '10', '10', '2025-08-14 19:03:45', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1635, 'Schnegge', '--', '65', '2025-08-14 19:12:55', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1636, 'Maus', '41', '41', '2025-08-14 19:13:11', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1637, 'Schnegge', '--', '56', '2025-08-14 19:13:13', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1638, 'Schnegge', '--', '97', '2025-08-14 19:13:34', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1639, 'Maus', '32', '32', '2025-08-14 19:13:38', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1640, 'Schnegge', '--', '57', '2025-08-14 19:13:53', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1641, 'Maus', '31', '31', '2025-08-14 19:13:54', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1642, 'Schnegge', '--', '73', '2025-08-14 19:14:20', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1643, 'Maus', '29', '29', '2025-08-14 19:15:06', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1644, 'Schnegge', '--', '74', '2025-08-14 19:15:49', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1645, 'Schnegge', '--', '76', '2025-08-14 19:16:12', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1646, 'Schnegge', '--', '87', '2025-08-14 19:18:38', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1647, 'Maus', '75', '75', '2025-08-14 19:19:19', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1648, 'Schnegge', '--', '86', '2025-08-14 19:19:49', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1649, 'Schnegge', '--', '91', '2025-08-14 19:20:16', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1650, 'Maus', '98', '98', '2025-08-14 19:20:28', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1651, 'Schnegge', '--', '44', '2025-08-14 19:21:12', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1652, 'Schnegge', '--', '47', '2025-08-14 19:21:32', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1653, 'Maus', '61', '61', '2025-08-14 19:22:39', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1654, 'Schnegge', '--', '83', '2025-08-14 19:23:00', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1655, 'Schnegge', '--', '49', '2025-08-14 19:23:25', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1656, 'Maus', '59', '59', '2025-08-14 19:23:41', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1657, 'Maus', '55', '55', '2025-08-14 19:24:21', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1658, 'Maus', '61', '61', '2025-08-14 19:25:18', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1659, 'Schnegge', '--', '17', '2025-08-14 19:25:47', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1660, 'Maus', '48', '48', '2025-08-14 19:26:08', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1661, 'Schnegge', '--', '55', '2025-08-14 19:26:18', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1662, 'Maus', '59', '59', '2025-08-14 19:26:34', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1663, 'Schnegge', '--', '77', '2025-08-14 19:26:38', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1664, 'Schnegge', '--', '88', '2025-08-14 19:26:57', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1665, 'Schnegge', '--', '22', '2025-08-14 19:27:11', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1666, 'Schnegge', '--', '11', '2025-08-14 19:27:19', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1667, 'Maus', '92', '92', '2025-08-14 19:27:34', '2001:16b8:b8c3:4300:ddb6:5504:fb9b:f58b', NULL),
(1668, 'Schnegge', '--', '1', '2025-08-14 19:28:46', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1669, 'Schnegge', '--', '3', '2025-08-14 19:28:56', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1670, 'Schnegge', '--', '4', '2025-08-14 19:29:03', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1671, 'Schnegge', '--', '5', '2025-08-14 19:29:09', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1672, 'Schnegge', '--', '6', '2025-08-14 19:29:16', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1673, 'Schnegge', '--', '7', '2025-08-14 19:29:22', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1674, 'Schnegge', '--', '8', '2025-08-14 19:29:29', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1675, 'Schnegge', '--', '9', '2025-08-14 19:29:37', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1676, 'Schnegge', '--', '2', '2025-08-14 19:29:42', '2a02:908:950:1f80:7d12:4c33:c469:4912', NULL),
(1677, 'Svenni', 'Mickie Krause', 'Nachts im dichten Fichtendickicht', '2025-08-15 08:13:16', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1678, 'Svenni', 'Melissa Naschenweng', 'Kompliment', '2025-08-15 08:14:04', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1679, 'Maus', 'Marco schuitmaker', 'engelbewaarder & schutzengel', '2025-08-15 08:18:15', '2001:16b8:b8d3:6a00:cc87:1b56:c441:6195', NULL),
(1680, 'Maus', 'büffel und oli p', 'maja', '2025-08-15 08:18:48', '2001:16b8:b8d3:6a00:cc87:1b56:c441:6195', NULL),
(1681, 'Svenni', 'Vincent Gross', 'Camping', '2025-08-15 08:23:20', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1682, 'Svenni', 'Wincent Weiss, Johannes Oerding', 'Die Guten Zeiten', '2025-08-15 08:33:18', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1683, 'Svenni', 'Avicii', 'Wake Me Up', '2025-08-15 08:36:52', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1684, 'Svenni', 'Tones and I', 'Dance Monkey', '2025-08-15 08:40:48', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1685, 'Svenni', 'Seeed', 'Ding', '2025-08-15 09:06:20', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1686, 'Svenni', 'Wir sind Helden', 'Nur ein Wort', '2025-08-15 09:08:14', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1687, 'Svenni', 'Jan Delay', 'Oh Jonny', '2025-08-15 09:11:54', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1688, 'Svenni', 'Wir sind Helden', 'Aurélie', '2025-08-15 09:16:22', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', NULL),
(1689, 'Svenni', 'Casper', 'Eines Tages (Arminia Bielefeld Track)', '2025-08-15 09:20:30', '2a02:908:4b21:e1c0:70e9:cefe:ac71:a8b8', 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);

--
-- 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 `moderator_notes`
--
ALTER TABLE `moderator_notes`
  ADD PRIMARY KEY (`id`);

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

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

--
-- 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`);

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

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

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

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

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

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

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

--
-- 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;
COMMIT;

