-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 17. Mai 2025 um 15:39
-- Server-Version: 8.0.39-30
-- 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
(161, 28, '2025-05-10', '20:00:00', '23:59:00', 'Nightlife', 'Mit Sandy in die Nacht Starten.....', 'vorlagen/nightlife.gif', 0, 0, '#ffffff', 0, 20),
(163, 5, '2025-05-10', '09:20:00', '11:00:00', 'Guten Morgen mit Samira2222', 'Start in den Tag mit guter Musik ', 'vorlagen/morningshow.gif', 1, 0, '#ff0080', 0, 20),
(164, 10, '2025-05-10', '11:06:00', '13:00:00', 'Spontan Musik', 'Sportlich Spontahn', '', 1, 0, '#ffffff', 0, 20),
(165, 9, '2025-05-11', '11:00:00', '13:00:00', 'Bin auch mal wieder dran', 'Der trucker zu Muttertag, die Sache ist dann klar gemacht', 'vorlagen/trucker2.gif', 1, 0, '#ffffff', 0, 20),
(166, 28, '2025-05-11', '00:00:00', '01:00:00', 'Die-Nachteulen-Party', 'Mit Sandy durch die Nacht', 'vorlagen/nightlife.gif', 0, 0, '#ffffff', 0, 20),
(167, 25, '2025-05-11', '15:00:00', '18:00:00', 'Arena Live', 'Wegen Leitung Ohne Chat', '', 0, 0, '#ffffff', 0, 20),
(168, 2, '2025-05-12', '10:15:00', '12:00:00', 'Musik was sonst ...', 'Nix', 'vorlagen/morningshow.gif', 0, 0, '#ffffff', 0, 20),
(169, 10, '2025-05-13', '10:00:00', '13:00:00', 'Morning show', 'Ja jetzt wird es zeit 1 tag nix gemacht campino ran an die Tasten Musik bitte', 'uploads/417171704_787765226726769_7463199402513946267_n.jpg', 1, 0, '#ffffff', 0, 20),
(170, 28, '2025-05-13', '20:00:00', '23:59:00', 'Nightlife ', 'Mit Sandy in die Nacht starten ', 'vorlagen/nightlife.gif', 0, 0, '#ffffff', 0, 20),
(171, 2, '2025-05-14', '20:00:00', '22:00:00', 'Die RTC Charts', 'Die von Euch gewählten Songs', 'uploads/oie_JnB6g7p1CDxN.gif', 0, 0, '#dd0b35', 0, 20),
(172, 28, '2025-05-14', '18:00:00', '20:00:00', 'Die Schlager Charts der Woche', 'Haben wir eine Neue Platz 1 ? Lasst Euch Überraschen ', 'vorlagen/radiotime.gif', 0, 0, '#ffffff', 0, 20),
(173, 28, '2025-05-14', '00:00:00', '01:00:00', 'Die-Nachteulen-Party', 'Mit Sandy und den Nachteulen durch die Nacht', 'vorlagen/nightlife.gif', 0, 0, '#ffffff', 0, 20),
(174, 10, '2025-05-15', '10:00:00', '13:00:00', 'Morning show', '2 Teil von 1 ', 'uploads/475561661_1056070366561385_4497248542527340400_n.jpg', 1, 0, '#ffffff', 0, 20),
(175, 28, '2025-05-17', '20:00:00', '23:59:00', 'Nightlife', 'Mit Sandy in die Nacht starten', 'vorlagen/nightlife.gif', 1, 0, '#ffffff', 0, 20),
(176, 9, '2025-05-15', '17:30:00', '19:30:00', 'mal spontan', 'spontan und einfach so', 'vorlagen/trucker2.gif', 0, 0, '#ffffff', 0, 20),
(177, 5, '2025-05-17', '10:00:00', '12:00:00', 'Guten Morgen mit Samira2222', 'Spontan am Morgen ', 'vorlagen/morningshow.gif', 1, 0, '#8000ff', 0, 20),
(185, 9, '2025-05-18', '11:00:00', '13:00:00', 'mal so', 'einfach musik', 'vorlagen/trucker2.gif', 1, 0, '#ffffff', 1, 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;

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

--
-- 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
) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

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

