-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: cityschnegge.lima-db.de:3306
-- Erstellungszeit: 26. Apr 2025 um 07:55
-- Server-Version: 8.0.39-30
-- 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_35`
--

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

--
-- Tabellenstruktur für Tabelle `challenges`
--

CREATE TABLE `challenges` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `challenges`
--

INSERT INTO `challenges` (`id`, `name`) VALUES
(6, 'Baby / Kinderbilder (Ratet wer wer ist)'),
(7, 'Balkon / Garten'),
(8, 'Sing dein Song Mallorca Party (Karaoke-Challange auf Fun Hochladen))'),
(9, 'Zeig uns dein Zuhause'),
(10, 'Zeige uns die schönste Stelle deiner Stadt');

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

--
-- Tabellenstruktur für Tabelle `votes`
--

CREATE TABLE `votes` (
  `id` int NOT NULL,
  `song_id` int NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `vote_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `votes`
--

INSERT INTO `votes` (`id`, `song_id`, `ip_address`, `vote_time`) VALUES
(2, 6, '2a02:908:954:6740:5840:84bc:38bc:d2cf', '2025-04-21 12:10:44'),
(3, 6, '109.42.177.26', '2025-04-22 03:58:39'),
(4, 8, '2a02:908:950:1f80:29f7:b7e2:6487:9601', '2025-04-22 08:16:27'),
(5, 9, '2001:16b8:b8de:2900:ade0:b0ae:540d:a490', '2025-04-22 21:05:27'),
(6, 10, '2001:16b8:b8eb:c500:8063:f6f0:ea6:125a', '2025-04-23 08:09:36'),
(7, 6, '109.43.176.47', '2025-04-23 09:04:28'),
(8, 9, '2001:16b8:b8c1:d00:7481:a5dd:c509:994', '2025-04-24 10:17:05'),
(9, 6, '109.43.176.47', '2025-04-24 15:07:12'),
(10, 7, '2a02:908:950:1f80:29f7:b7e2:6487:9601', '2025-04-24 18:32:08'),
(11, 9, '2001:16b8:b8cc:8a00:d83d:7fb4:a491:b7b4', '2025-04-25 06:01:16'),
(12, 6, '2a02:908:954:6740:59c1:28c7:7c12:5c24', '2025-04-25 17:41:02'),
(13, 10, '2001:16b8:b8d9:7a00:f57d:c5e:dc97:4f3e', '2025-04-26 05:41:58');

--
-- Indizes der exportierten Tabellen
--

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

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

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

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

--
-- AUTO_INCREMENT für Tabelle `votes`
--
ALTER TABLE `votes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
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 */;
