-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: entwickler1234.lima-db.de:3306
-- Generation Time: Aug 05, 2026 at 04:59 PM
-- Server version: 8.0.42-33
-- PHP Version: 8.4.23

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

--
-- Database: `db_387952_22`
--

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

--
-- Table structure for table `personen`
--

CREATE TABLE `personen` (
  `id` int UNSIGNED NOT NULL,
  `vorname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nachname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefon` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `geburtsdatum` date DEFAULT NULL,
  `strasse` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plz` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ort` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `land` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'Österreich',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personen`
--

INSERT INTO `personen` (`id`, `vorname`, `nachname`, `email`, `telefon`, `geburtsdatum`, `strasse`, `plz`, `ort`, `land`, `created_at`) VALUES
(1, 'Anna', 'Müller', 'anna.mueller@example.com', '+43 664 1234567', '1990-04-12', 'Hauptstraße 12', '8010', 'Graz', 'Österreich', '2026-08-04 15:57:17'),
(2, 'Markus', 'Schneider', 'markus.schneider@example.com', '+43 676 9876543', '1985-09-03', 'Bergweg 5', '4020', 'Linz', 'Österreich', '2026-08-04 15:57:17'),
(3, 'Julia', 'Huber', 'julia.huber@example.com', '+43 650 1122334', '1992-01-22', 'Waldgasse 7', '5020', 'Salzburg', 'Österreich', '2026-08-04 15:57:17'),
(4, 'Thomas', 'Leitner', 'thomas.leitner@example.com', '+43 699 4433221', '1988-07-19', 'Sonnenweg 3', '3100', 'St. Pölten', 'Österreich', '2026-08-04 15:57:17'),
(5, 'Sabine', 'Koller', 'sabine.koller@example.com', '+43 664 5566778', '1995-11-30', 'Ringstraße 22', '1010', 'Wien', 'Österreich', '2026-08-04 15:57:17'),
(6, 'Peter', 'Gruber', 'peter.gruber@example.com', '+43 676 9988776', '1979-03-14', 'Am Platz 9', '7000', 'Eisenstadt', 'Österreich', '2026-08-04 15:57:17'),
(7, 'Lena', 'Fischer', 'lena.fischer@example.com', '+43 650 3344556', '1998-06-08', 'Kirchweg 4', '4600', 'Wels', 'Österreich', '2026-08-04 15:57:17'),
(8, 'David', 'Hofer', 'david.hofer@example.com', '+43 699 7788990', '1983-12-25', 'Talstraße 11', '6800', 'Feldkirch', 'Österreich', '2026-08-04 15:57:17'),
(9, 'Maria', 'Berger', 'maria.berger@example.com', '+43 664 2211334', '1991-02-17', 'Parkallee 6', '9020', 'Klagenfurt', 'Österreich', '2026-08-04 15:57:17'),
(10, 'Johannes', 'Wagner', 'johannes.wagner@example.com', '+43 676 6655443', '1987-05-05', 'Rosenweg 8', '8700', 'Leoben', 'Österreich', '2026-08-04 15:57:17');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `personen`
--
ALTER TABLE `personen`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `personen`
--
ALTER TABLE `personen`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
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 */;
