-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: cityschnegge.lima-db.de:3306
-- Erstellungszeit: 16. Aug 2025 um 13:06
-- Server-Version: 8.0.42-33
-- PHP-Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Datenbank: `db_376260_42`
--

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

--
-- Tabellenstruktur für Tabelle `galleries`
--

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

--
-- Daten für Tabelle `galleries`
--

INSERT INTO `galleries` (`id`, `name`, `sort_order`, `created_at`) VALUES
(1, 'K.I. Songs', 1, '2025-08-09 17:26:32'),
(2, 'K.I. Schnegge', 2, '2025-08-09 17:26:32'),
(3, 'K.I.Maus', 0, '2025-08-11 09:12:03');

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

--
-- Tabellenstruktur für Tabelle `mp3_files`
--

CREATE TABLE `mp3_files` (
  `id` int NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `gallery` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `file_size` int NOT NULL,
  `duration` int DEFAULT NULL,
  `uploaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `mp3_files`
--

INSERT INTO `mp3_files` (`id`, `filename`, `original_filename`, `gallery`, `file_size`, `duration`, `uploaded_at`) VALUES
(1, '689790cd7d38a.mp3', 'K.I.Schnegge - Lüg Doch Mal Für Mich.mp3', 'K.I. Schnegge', 5763914, NULL, '2025-08-09 18:17:49'),
(2, '689793e3923e1.mp3', 'K.I.Schnegge - Bananenboot.mp3', 'K.I. Schnegge', 2903861, NULL, '2025-08-09 18:30:59'),
(3, '6897940755f3c.mp3', 'K.I.Schnegge - Im Naechstem Leben.mp3', 'K.I. Schnegge', 4389574, NULL, '2025-08-09 18:31:35'),
(4, '68979436a6491.mp3', 'K.I.Schnegge - Mann Von Frueher.mp3', 'K.I. Schnegge', 4369986, NULL, '2025-08-09 18:32:22'),
(5, '6897944834a6b.mp3', 'K.I.Schnegge - Nur Ein Kleiner Zeitvertreib.mp3', 'K.I. Schnegge', 4956954, NULL, '2025-08-09 18:32:40'),
(8, '6897982db8ec0.mp3', 'K.I.Schnegge - Wir Fahren Nach Amerika.mp3', 'K.I. Schnegge', 6382653, NULL, '2025-08-09 18:49:17'),
(10, '6899b4fe9a739.mp3', 'Liebe ein Leben lang (2).mp3', 'K.I.Maus', 3668129, NULL, '2025-08-11 09:16:46'),
(11, '6899b525dfeae.mp3', 'Unsere Welt, unser Leben(2).mp3', 'K.I.Maus', 4728122, NULL, '2025-08-11 09:17:25'),
(12, '689b595f7f0cd.mp3', 'Radio Tralla City.mp3', 'K.I.Maus', 3647874, NULL, '2025-08-12 15:10:23');

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

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `sort_index` (`sort_order`);

--
-- Indizes für die Tabelle `mp3_files`
--
ALTER TABLE `mp3_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gallery_index` (`gallery`),
  ADD KEY `upload_index` (`uploaded_at`);

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

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
