-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 09. Jun 2025 um 13:28
-- 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
(216, 5, '2025-06-01', '10:00:00', '11:30:00', 'Himmlische Lieder', 'Guten Morgen ', '', 0, 0, '#ffff00', 0, 20),
(217, 10, '2025-06-02', '10:00:00', '12:00:00', 'Morning show', 'Maus Buffe eröffnet mit Musik von Camoino', 'uploads/502431063_2197044890792557_6456843481471491394_n.jpg', 1, 0, '#ffffff', 0, 20),
(218, 10, '2025-06-02', '20:00:00', '22:00:00', 'Am Abend die schönste musik ', 'Ihr macht es gemüdlich so wie ich und Campino macht mit schweißgebadener musik', 'uploads/474388288_1169024931246077_4557274545341245155_n.jpg', 1, 0, '#ffffff', 0, 4),
(219, 28, '2025-06-03', '22:00:00', '23:59:00', 'Nightlife', 'Mit Sandy in die Nacht starten', '', 1, 0, '#ffffff', 1, 5),
(220, 28, '2025-06-04', '18:00:00', '20:00:00', 'Schlager Charts', 'Na haben wir eine Neue Platz 1 oder die alte?', '', 0, 0, '#ffffff', 0, 20),
(221, 28, '2025-06-04', '00:00:00', '02:00:00', 'Die Nachteulen-Party', 'Für Die Nachteulen eine Partyyy in der Nacht', '', 0, 0, '#ffffff', 0, 20),
(222, 10, '2025-06-04', '10:00:00', '13:00:00', 'Morning show', 'Lass den Kaffetanz oder getränke genissen mit Campino', 'uploads/475156469_486906047788561_6550864588026166047_n.jpg', 1, 0, '#ffffff', 0, 20),
(223, 10, '2025-06-04', '20:00:00', '22:00:00', 'Spontan Musik', 'Ihr wollt musik bekommt ihr', 'uploads/484121973_10224771659392023_6589593145577240238_n.jpg', 1, 0, '#ffffff', 0, 20),
(224, 10, '2025-06-06', '10:00:00', '13:00:00', 'Morning show  Mittagshow', 'Musik Musik', '', 1, 0, '#ffffff', 0, 20),
(225, 28, '2025-06-07', '20:00:00', '23:59:00', 'Nightlife', 'Mit Sandy in die Nacht starten', 'uploads/club3.jpg', 1, 0, '#ffffff', 1, 5),
(226, 10, '2025-06-07', '14:00:00', '16:00:00', 'Spontan Musik', 'Hauen wir Musik raus', '', 1, 0, '#ffffff', 0, 20),
(227, 28, '2025-06-08', '00:00:00', '02:00:00', 'Die-Nachteulen-Party', 'Party für alle Nachteulen', '', 0, 0, '#ffffff', 0, 20),
(228, 5, '2025-06-08', '08:50:00', '12:00:00', 'Guten Morgen, mit guter Musik ', 'Guten Morgen ', '', 0, 0, '#800000', 0, 20),
(229, 9, '2025-06-09', '11:00:00', '13:00:00', 'Der Trucker macht das schon', 'Pfingstmontag das ist fein, da haut der Trucker Musik rein', 'vorlagen/trucker1.gif', 1, 0, '#ffffff', 1, 10),
(230, 4, '2025-06-08', '18:00:00', '20:00:00', 'da bin ich wieder', 'spass mit frank und juli', '', 0, 0, '#ffffff', 0, 20),
(232, 1, '2025-06-09', '13:00:00', '15:00:00', 'wobotest', 'test', '', 1, 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
(17, 1, 'Ihr Lieben, wenn ihr eine Sendung eintragt und die Wunschbox aktiviert, seht ihr einen  neuen Button -Zeitlimit Option-. Hier könnt ihr die Wünsche der Hörer zeitlich begrenzen, jede IP kann dann nur noch alle 20 Minuten (oder die Zeit die ihr einstellt) einen Wunsch senden. Standart steht auf 20 Minuten. Diese Zeit könnt ihr ändern. Einfach haken setzen, Minuten auf 10 (z.B), Sendung eintragen Fertig. Ohne Zeit Option (Also kein Haken bei Zeit) läuft die Wunschbox wie bisher!..........................................................................Die RTC-Charts wurden wie folgt geändert,es gibt jetzt eine Vorschlagsphase wo die Songs eingetragen werden, diese dauert 14 Tage oder bis 30 Songs eingetragen sind. Erst dann beginnt die Abstimmungsphase damit jeder Songeintrag die gleiche Chance hat. Bei Fragen oder Anregungen, sucht euch ein anderes Radio lol', '2025-05-17 18:03:15');

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

--
-- 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
(644, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf', '2025-05-18 16:57:18', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(645, 'Svenni', 'Olaf der Flipper & Vincent Gross', 'Drinking Wine Feeling Fine', '2025-05-18 17:02:26', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(646, 'Svenni', 'Marco Schuitmaker', 'Engelbewaarder', '2025-05-18 17:30:14', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(647, 'Svenni', 'Shantallica', 'Wir sind Arminen', '2025-05-18 17:37:30', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(648, 'Svenni', 'Olaf Berger', 'Berlin, Berlin, wir fahren nach Berlin....', '2025-05-18 17:38:00', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(649, 'Svenni', 'Mätropolis, DJ Aaron', 'Rakete', '2025-05-18 17:45:47', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(650, 'Svenni', 'Stereoact & Redblack', 'Sarà Perché Ti Amo', '2025-05-18 17:47:26', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(651, 'biene', 'Roberto Blanco', 'der puppenspieler von mexico', '2025-05-18 17:58:37', '2a02:3100:43ca:4b00:43e:2bdd:4a69:49a8', NULL),
(652, 'biene', 'Costa Cordales', 'Weißer Anzug', '2025-05-18 17:59:38', '2a02:3100:43ca:4b00:43e:2bdd:4a69:49a8', NULL),
(653, 'Svenni', 'Die Drafgänger, Hannah', 'Hallo Kleine Maus', '2025-05-18 18:01:18', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(654, 'Svenni', 'DJ Ötzi', 'Gigolo', '2025-05-18 18:04:18', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(655, 'Svenni', 'Mickie Krause', 'Nachts im dichten Fichtendickicht.... Extra für Campino...', '2025-05-18 18:04:48', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(656, 'Svenni', 'Mountain Crew', 'Krake', '2025-05-18 18:18:43', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(657, 'biene', 'G;G; Anderson', 'sommernacht in rom', '2025-05-18 18:19:05', '2a02:3100:43ca:4b00:43e:2bdd:4a69:49a8', NULL),
(658, 'Svenni', 'Rolling Stones', 'Angry', '2025-05-18 18:20:30', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(659, 'biene', 'Flippers', 'Lotusblume', '2025-05-18 18:20:48', '2a02:3100:43ca:4b00:43e:2bdd:4a69:49a8', NULL),
(660, 'Svenni', 'Melissa Naschenweng', 'Difigiano', '2025-05-18 18:21:27', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(661, 'Svenni', 'Marc Pircher', 'Die wilde Hilde', '2025-05-18 18:25:52', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(662, 'Svenni', 'Schürzenjäger', 'Es brennt der Huat', '2025-05-18 18:27:58', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(663, 'Svenni', 'Die jungen Zillertaler', 'Tannenzapfenzupfen', '2025-05-18 18:45:45', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(664, 'Maus', 'andreas gabalier', 'i sing a lead für di', '2025-05-18 18:48:03', '2001:16b8:b8c4:9300:c80f:4850:9ecb:5191', NULL),
(665, 'Maus', 'max giesinger', 'wenn sie tanzt', '2025-05-18 18:57:54', '2001:16b8:b8c4:9300:c80f:4850:9ecb:5191', NULL),
(666, 'Svenni', 'Daniela Alfinito', 'Lass uns wieder einmal tanzen gehn', '2025-05-18 19:03:57', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(667, 'Svenni', 'Frank Lars', 'Dornröschen', '2025-05-18 19:04:40', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(668, 'Svenni', 'Anna-Maria Zimmermann', 'Was wird', '2025-05-18 19:07:44', '2a02:908:4b21:e1c0:2ca7:12c4:cc2f:92c6', NULL),
(669, 'Maus', 'jürgen drews', 'Irgendwie, irgendwo, irgendwann', '2025-05-18 19:13:57', '2001:16b8:b8c4:9300:c80f:4850:9ecb:5191', NULL),
(670, 'Maus', 'howard carpendale', 'du bist das letzte', '2025-05-18 19:16:16', '2001:16b8:b8c4:9300:c80f:4850:9ecb:5191', NULL),
(671, 'Maus', 'nino de angelo', 'wer bringt dich nachhause', '2025-05-19 08:23:46', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(672, 'Maus', 'michelle + matthias reim', 'nicht verdient', '2025-05-19 08:25:24', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(673, 'Maus', 'peter orloff', 'immer wenn ich josy seh', '2025-05-19 08:27:35', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(674, 'Maus', 'michael holm', 'mendocino', '2025-05-19 08:29:14', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(675, 'Maus', 'michael wendler', 'egal', '2025-05-19 08:33:35', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(676, 'Maus', 'jürgen drews', 'wenn die wunderkerzen brennen', '2025-05-19 08:42:26', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(677, 'Maus', 'wolfgang petry', 'sommer in der stadt', '2025-05-19 09:00:48', '2001:16b8:b8d1:d600:c9e2:1295:135d:c7f9', NULL),
(678, 'Maus', 'rolling stones', 'angie', '2025-05-21 08:58:49', '2001:16b8:b8eb:e200:6d08:1342:8a71:958f', NULL),
(679, 'Maus', 'beatles', 'yesterday', '2025-05-21 09:00:07', '2001:16b8:b8eb:e200:6d08:1342:8a71:958f', NULL),
(680, 'Maus', 'uriah heep', 'free me', '2025-05-21 09:02:00', '2001:16b8:b8eb:e200:6d08:1342:8a71:958f', NULL),
(681, 'Maus', 'genesis', 'the carpet crawlers', '2025-05-21 09:27:38', '2001:16b8:b8eb:e200:6d08:1342:8a71:958f', NULL),
(682, 'Svenni', 'Lionel Richie', 'All Night Long', '2025-05-21 18:03:41', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(683, 'Svenni', 'Scatman John', 'Scatman (ski-ba-bop-ba-dop-bop)', '2025-05-21 18:06:48', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(684, 'Svenni', 'Gigi DÁgostino', 'The Riddle', '2025-05-21 18:08:00', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(685, 'Svenni', 'Mark Forster', 'Chöre', '2025-05-21 18:10:03', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(686, 'Svenni', 'Mr. Hurley & Die Pulveraffen', 'Blau wie das Meer', '2025-05-21 18:21:41', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(687, 'Svenni', 'Versengold', 'Kobold im Kopf', '2025-05-21 18:24:57', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(688, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf', '2025-05-21 18:30:42', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(689, 'Svenni', 'Andreas Gabalier', 'Jukeboxblues', '2025-05-21 18:31:44', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(690, 'Svenni', 'Semino Rossi', 'Wir sind im Herzen jung', '2025-05-21 18:36:04', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(691, 'Svenni', 'Marco Schuitmaker', 'Engelbewaarder', '2025-05-21 18:39:02', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(692, 'Svenni', 'City', 'Am Fenster', '2025-05-21 18:39:14', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(693, 'Svenni', 'Jennifer Rush', 'The Power of Love', '2025-05-21 18:47:55', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(694, 'Svenni', 'Wolkenfrei', 'Wolke 7', '2025-05-21 18:49:27', '2a02:908:4b21:e1c0:90f9:c556:5526:d26', NULL),
(695, 'Pad', 'Hallo Campino wünsche dir eine SFS', '.', '2025-05-22 18:25:52', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(696, 'Pad', 'Semino Rossi', 'Vamos, Amore mio, Vamos', '2025-05-22 18:30:17', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(697, 'biene', 'Nic.P', 'Ireen', '2025-05-22 18:37:59', '2a02:3100:474f:3900:9ce2:930f:903f:eb03', NULL),
(698, 'biene', 'stereo act', 'Sempre sempre', '2025-05-22 18:38:52', '2a02:3100:474f:3900:9ce2:930f:903f:eb03', NULL),
(699, 'Pad', 'Santiano', 'Es gibt nur Wasser', '2025-05-22 18:58:27', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(700, 'Pad', 'Nockis', 'Seit 1870', '2025-05-22 19:12:33', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(701, 'Pad', 'MONO INC.', 'Lieb Mich', '2025-05-22 19:32:12', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(702, 'Pad', 'Claudia Jung', 'Komm und tanz ein letztes Mal mit mir', '2025-05-22 19:45:33', '2003:f5:f3c:166c:4d03:9d13:bad3:2018', NULL),
(703, 'Pad ... Guten Morgen Campino und eine SFS', 'Mark Medlock, Dieter Bohlen', 'You Can Get It', '2025-05-23 09:03:08', '2003:f5:f3c:16eb:c9d7:1396:c902:5334', NULL),
(704, 'Pad', 'Micha von der Rampe', 'Geil man, Wochenende', '2025-05-23 09:30:40', '2003:f5:f3c:16eb:c9d7:1396:c902:5334', NULL),
(705, 'trucker', 'otto lagerfett', 'Herr Pastor', '2025-05-24 19:53:02', '2a02:3100:3d30:b300:cfd:cad1:d5b8:627d', NULL),
(706, 'trucker', 'Lindsay', 'Deze nacht mag eeuwig duren', '2025-05-24 20:02:05', '2a02:3100:3d30:b300:cfd:cad1:d5b8:627d', NULL),
(707, 'trucker', 'Christoff', 'ik ben geboren om van jou te houden', '2025-05-24 20:16:13', '2a02:3100:3d30:b300:cfd:cad1:d5b8:627d', NULL),
(708, 'trucker', 'Jan smit', 'ik will slapen', '2025-05-24 20:27:26', '2a02:3100:3d30:b300:cfd:cad1:d5b8:627d', NULL),
(709, 'Maus', 'nino de angelo', 'zu spät', '2025-05-26 08:40:01', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(710, 'Maus', 'christin stark', 'dich zu lieben', '2025-05-26 08:41:15', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(711, 'Maus', 'jürgen drews', 'wenn die wunderkerzen brennen', '2025-05-26 08:42:12', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(712, 'Maus', 'kristin stark +matthias reim', 'ich nicht', '2025-05-26 08:54:29', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(713, 'Maus', 'eric philippi', 'schockverliebt', '2025-05-26 09:06:37', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(714, 'Maus', 'julian sommer', 'sos', '2025-05-26 18:45:43', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(715, 'Maus', 'max giesinger', 'wenn sie tanzt', '2025-05-26 18:46:26', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(716, 'Maus', 'buddy', 'ab in den süden', '2025-05-26 18:47:54', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(717, 'Maus', 'julian sommer', 'eine nacht in arenal', '2025-05-26 18:54:50', '2001:16b8:b8ee:4700:b14e:361a:bef8:4dd3', NULL),
(718, 'Maus', 'alexander eder', 'für diesen moment', '2025-05-27 08:18:35', '2001:16b8:b8fb:4300:bcaf:d100:e772:b645', NULL),
(719, 'Maus', 'eric philippi', 'wir bleiben noch', '2025-05-27 08:24:32', '2001:16b8:b8fb:4300:bcaf:d100:e772:b645', NULL),
(720, 'Maus', 'clubbb3', 'du schaffst das schon', '2025-05-27 08:27:43', '2001:16b8:b8fb:4300:bcaf:d100:e772:b645', NULL),
(721, 'Maus', 'mickie krause', 'mich hat ein engel geküsst', '2025-05-27 08:29:32', '2001:16b8:b8fb:4300:bcaf:d100:e772:b645', NULL),
(722, 'Maus', 'kerstin ott', 'rockstar       mit lieben gruss für unseren campi', '2025-05-27 09:34:19', '2001:16b8:b8fb:4300:bcaf:d100:e772:b645', NULL),
(723, 'Svenni', 'Susal, die Partyhexe', 'Ich fühl mich Disco', '2025-05-27 20:21:39', '2a02:908:4b21:e1c0:acc1:ab88:32f6:811d', NULL),
(724, 'Svenni', 'FiNCH', 'Schwalbe', '2025-05-27 20:52:14', '2a02:908:4b21:e1c0:acc1:ab88:32f6:811d', NULL),
(725, 'Maus', 'mickie krause', 'im dichten fichtendickicht', '2025-05-28 08:40:01', '2001:16b8:b8c9:200:5411:aaf3:960c:da8c', NULL),
(726, 'Maus', 'kerstin ott', 'irgendwann vielleicht', '2025-05-28 08:40:47', '2001:16b8:b8c9:200:5411:aaf3:960c:da8c', NULL),
(727, 'Maus', 'howard carpendale', 'du bist das letzte', '2025-05-28 08:41:41', '2001:16b8:b8c9:200:5411:aaf3:960c:da8c', NULL),
(728, 'Michi', 'Shantallica', 'Wir in Bilefeld', '2025-05-29 09:14:12', '2003:6:314d:d051:a5e5:2679:b90f:9ada', NULL),
(729, 'Michi', 'heintje', 'Mama', '2025-05-29 09:33:19', '2003:6:314d:d051:a5e5:2679:b90f:9ada', NULL),
(730, 'Svenni', 'RIAN', 'Hausparty', '2025-06-02 08:39:48', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(731, 'Svenni', 'Melissa Naschenweng', 'Oh la la', '2025-06-02 08:43:06', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(732, 'Svenni', 'Mountain Crew', 'Bella Ragazza', '2025-06-02 08:47:27', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(733, 'Svenni', 'Esterio Brothers & Stereoact', 'Mamma Maria', '2025-06-02 08:50:34', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(734, 'Svenni', 'FiNCH', 'Schwalbe', '2025-06-02 09:08:54', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(735, 'Svenni', 'Mickie Krause', 'Nachts im dichten Fichtendickicht', '2025-06-02 09:20:04', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(736, 'Svenni', 'Marco Schuitmaker', 'Engelbewaarder', '2025-06-02 09:25:05', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(737, 'Svenni', 'Semino Rossi', 'Was bitte was', '2025-06-02 09:25:21', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(738, 'Svenni', 'DJ Herzbeat & Sonia Liebing', 'Immer wieder wenn die Sonne scheint', '2025-06-02 09:38:54', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(739, 'Svenni', 'Claudia Jung', 'Als die Erde Feuer fing', '2025-06-02 09:43:02', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(740, 'Svenni', 'Die Paldauer', 'Ein Schritt vor - Kein Zurück', '2025-06-02 18:34:12', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(741, 'Svenni', 'Nockis', 'Navalava Tsu Tsu', '2025-06-02 18:50:34', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(742, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf', '2025-06-02 18:58:08', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(743, 'Pad', 'Semino Rossi', 'Wir sind im Herzen jung', '2025-06-02 19:00:13', '2003:f5:f3c:1670:3553:f831:c45f:261', NULL),
(744, 'Svenni', 'Chris Andrews & Tobee', 'Pretty Belinda Schlauuchboot', '2025-06-02 19:00:42', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(745, 'Svenni', 'Mätropolis, DJ Aaron', 'Rakete', '2025-06-02 19:11:58', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(746, 'Svenni', 'The Rebel Tell Band', 'Griechischer Wein', '2025-06-02 19:15:24', '2a02:908:4b21:e1c0:41d1:cfd8:7d16:f529', NULL),
(747, 'Sandy', 'Fantasy', 'Ich brauch mehr von dir', '2025-06-02 19:41:25', '2a02:8071:4489:1160:901b:797f:3263:24b9', NULL),
(748, 'Sandy', 'Dj Ötzi Balamy Brothers', 'I need more of you', '2025-06-02 19:41:47', '2a02:8071:4489:1160:901b:797f:3263:24b9', NULL),
(749, 'Svenni', 'RIAN', 'Hausparty', '2025-06-02 19:42:46', '2a02:908:4b21:e1c0:747c:b668:a83b:4b69', NULL),
(750, 'Svenni', 'Stereoact &  Al Bano', 'Felicitá', '2025-06-02 19:49:59', '2a02:908:4b21:e1c0:747c:b668:a83b:4b69', NULL),
(751, 'Svenni', 'RIAN', 'Hausparty', '2025-06-03 20:05:13', '95.223.106.201', NULL),
(752, 'Svenni', 'Matrosen in Lederhosen', 'Annemariechen', '2025-06-03 20:19:00', '95.223.106.201', NULL),
(753, 'Svenni', 'Feuerherz', 'In meinen Träumen ist die Hölle los ..... Für das Liebespaar hier im Chat....', '2025-06-03 20:36:44', '95.223.106.201', NULL),
(754, 'Maus', 'nino de angelo', 'zu spät', '2025-06-04 08:24:11', '2001:16b8:b8f3:7d00:ac3e:bfc9:b713:87f3', NULL),
(755, 'Maus', 'michelle', 'so oder so', '2025-06-04 08:26:06', '2001:16b8:b8f3:7d00:ac3e:bfc9:b713:87f3', NULL),
(756, 'Maus', 'sunrise', 'im weissen kleid durch die nacht', '2025-06-04 08:27:44', '2001:16b8:b8f3:7d00:ac3e:bfc9:b713:87f3', NULL),
(757, 'Maus', 'peter wackel', 'mallekur', '2025-06-04 08:28:40', '2001:16b8:b8f3:7d00:ac3e:bfc9:b713:87f3', NULL),
(758, 'Michi', 'Lornz Büffel', 'Midnight Lady', '2025-06-04 19:25:57', '2003:6:314d:d073:4428:fd2e:13e:d09d', NULL),
(759, 'Michi', 'Ärzte', 'Westerland', '2025-06-04 19:31:42', '2003:6:314d:d073:4428:fd2e:13e:d09d', NULL),
(760, 'Michi', 'Shantallica', 'Wir in Bilefeld', '2025-06-04 19:39:00', '2003:6:314d:d073:4428:fd2e:13e:d09d', NULL),
(761, 'Svenni', 'Mike & The Mechanics', 'Word of Mouth', '2025-06-04 19:40:05', '2a02:908:4b21:e1c0:4dca:d584:ebf:4743', NULL),
(762, 'Jürgen  Hallo Stefan', 'Jürgen  Drews', 'Ein Stern der deinen Namen Trägt', '2025-06-04 19:42:08', '2a02:3100:457a:e300:10ac:a318:ce83:59c', NULL),
(763, 'Svenni', 'RIAN', 'Hausparty', '2025-06-04 19:53:11', '2a02:908:4b21:e1c0:4dca:d584:ebf:4743', NULL),
(764, 'Maus', 'christin stark', 'barcelona', '2025-06-07 12:26:28', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(765, 'maus', 'frank lukas', 'komm zurück', '2025-06-07 12:27:56', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(766, 'Maus', 'die draufgänger', 'gianna', '2025-06-07 12:28:45', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(767, 'Maus', 'andrea berg', 'simsalabim', '2025-06-07 12:29:47', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(768, 'Maus', 'semino rossi-krause', 'was bitte was', '2025-06-07 12:30:50', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(769, 'Maus', 'roland kaiser', 'ich werde da sein', '2025-06-07 12:31:35', '2001:16b8:b8dc:ea00:c4ba:caeb:e642:33f', NULL),
(770, 'Svenni', 'Whigfield', 'Saturday Night', '2025-06-07 18:07:09', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(771, 'Svenni', 'Mickie Krause', 'Nachts im dichten Fichtendickicht', '2025-06-07 18:24:15', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(772, 'Svenni', 'Schürzenjäger', 'Die pinken Haar', '2025-06-07 18:48:10', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(773, 'Svenni', 'Frenzy', 'Lampen an', '2025-06-07 19:10:40', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(774, 'Svenni', 'Tobee', 'Margarethe (Sie war 44...)', '2025-06-07 19:18:45', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(775, 'Svenni', 'Nancy Franck & Lorenz Büffel', 'Ufo', '2025-06-07 19:24:55', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(776, 'Michi', 'Shantallica', 'Wir in Bielefeld', '2025-06-07 19:31:28', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(777, 'Michi', 'Helene Fischer', 'Achterbahn', '2025-06-07 19:39:10', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(778, 'Svenni', 'Lorenz Büffel', 'Pferdeschwanz', '2025-06-07 19:39:32', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(779, 'Svenni', 'Ben Zucker', 'Remmidemmi', '2025-06-07 19:50:22', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(780, 'Michi', 'engelberwarder', 'Marco', '2025-06-07 19:58:19', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(781, 'Michi', 'Toten Hosen', 'wannensee', '2025-06-07 20:09:12', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(782, 'Michi', 'Susal die Partyhexe', 'Hoch die Tassen Wochenende( für Svenni)', '2025-06-07 20:17:09', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(783, 'Michi', 'Lorenz Büffel', 'Beate die harte', '2025-06-07 20:27:10', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(784, 'Svenni', 'Mickie Krause & Tim Toupet', 'Dann leg ich Schlager auf...', '2025-06-07 20:30:33', '2a02:908:4b21:e1c0:a5c9:a107:d191:fe0b', NULL),
(785, 'Michi', 'Rudi carell', 'wann wird es wieder sommer', '2025-06-07 20:34:59', '2003:6:314d:d0a5:6cc9:9d0b:7d42:1d3', NULL),
(786, 'Mutchatcho', 'nix', 'da', '2025-06-09 08:19:54', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(787, 'Mutchatcho', 'jetzt', 'ha', '2025-06-09 08:28:01', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(788, 'Mutchatcho', 'du', 'ich', '2025-06-09 08:36:12', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(789, 'Mutchatcho', 'hu', 'na', '2025-06-09 08:43:07', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(790, 'Mutchatcho', 'jdbka', 'afaf', '2025-06-09 08:49:02', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(791, 'Mutchatcho', 'jgjh', 'khgkjgbjn', '2025-06-09 08:55:21', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(792, 'Michi', 'Lorenz Büffel', 'Pferdehaarfrisur', '2025-06-09 09:16:45', '2003:6:314d:d0ab:41a3:9e31:7c53:aac8', NULL),
(793, 'Michi', 'Lorenz Büffel', 'Pferdeschwnzfrisur', '2025-06-09 09:28:25', '2003:6:314d:d0ab:41a3:9e31:7c53:aac8', NULL),
(794, 'Michi', 'Lorenz Büffel', 'Pferderschwanzfrisur', '2025-06-09 09:32:04', '2003:6:314d:d0ab:41a3:9e31:7c53:aac8', NULL),
(795, 'Michi', 'engelberwarder', 'Marco', '2025-06-09 09:44:00', '2003:6:314d:d0ab:41a3:9e31:7c53:aac8', NULL),
(796, 'Pad', 'Dolly Parton, Kenny Rogers', 'Islands In the Stream', '2025-06-09 09:48:26', '2003:f5:f3c:1621:ac63:3db:7cc1:ac4', NULL),
(797, 'Pad', 'Nicki', 'Wegen Dir', '2025-06-09 10:27:34', '2003:f5:f3c:1621:ac63:3db:7cc1:ac4', NULL),
(798, 'Mutchatcho', 'ich', 'du', '2025-06-09 11:05:52', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(799, 'Mutchatcho', 'schnegge', 'fick mich', '2025-06-09 11:11:40', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(800, 'Mutchatcho', 'Blabla', 'dudidu', '2025-06-09 11:12:53', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(801, 'Schnegge', 'Schnegge', 'Lieb mich jetzt', '2025-06-09 11:24:47', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(802, 'Schnegge', 'Roy Black', 'Ganz in scheiss', '2025-06-09 11:25:55', '2a02:908:954:6740:1528:96ec:e707:f47a', NULL),
(803, 'Schnegge', 'Der Schwatte', 'ein bisschen spass', '2025-06-09 11:26:46', '2a02:908:954:6740:1528:96ec:e707:f47a', 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 `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=233;

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

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

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

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

