0bmf6De0

1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 27. Aug 2018 um 15:11
7-- Server-Version: 10.1.34-MariaDB
8-- PHP-Version: 7.0.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Datenbank: `sp_benutzer`
23--
24DROP DATABASE IF EXISTS `sp_benutzer`;
25CREATE DATABASE IF NOT EXISTS `sp_benutzer` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
26USE `sp_benutzer`;
27
28-- --------------------------------------------------------
29
30--
31-- Tabellenstruktur für Tabelle `tblbenutzer`
32--
33
34DROP TABLE IF EXISTS `tblbenutzer`;
35CREATE TABLE `tblbenutzer` (
36  `user_id` int(11) NOT NULL,
37  `username` varchar(30) COLLATE utf8_bin NOT NULL,
38  `password` varchar(200) COLLATE utf8_bin NOT NULL,
39  `role` int(11) NOT NULL,
40  `vorname` varchar(30) COLLATE utf8_bin NOT NULL,
41  `nachname` varchar(30) COLLATE utf8_bin NOT NULL,
42  `email` varchar(50) COLLATE utf8_bin NOT NULL,
43  `last_login` datetime DEFAULT NULL
44) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
45
46--
47-- Daten für Tabelle `tblbenutzer`
48--
49
50INSERT INTO `tblbenutzer` (`user_id`, `username`, `password`, `role`, `vorname`, `nachname`, `email`, `last_login`) VALUES
51(1, 'marvmarv', 'abc123', 1, 'Marvin', 'Lentes', 'marvin.lentes@gmail.com', NULL),
52(3, 'chris', 'abc123', 2, 'Christian', 'Laprell', 'christian.laprell@smail.th-koeln.de', NULL),
53(4, 'max', '123', 2, 'Max', 'Musterman', '', NULL),
54(6, 'testus', '202cb962ac59075b964b07152d234b', 2, '', '', 'spast@testus.de', NULL),
55(7, 'testus2', '202cb962ac59075b964b07152d234b', 2, 'Andy', 'Kap', 'spast@testus.de', NULL),
56(8, 'testt', '202cb962ac59075b964b07152d234b', 2, '', '', 'spast@testus.de', NULL),
57(9, 'test23', '202cb962ac59075b964b07152d234b70', 2, '', '', 'spast@testus.de', NULL),
58(10, 'testuss', '202cb962ac59075b964b07152d234b70', 2, '', '', 'spast@testus.de', NULL),
59(11, 'fsdfsd', '7aa6b6e69f16a93101bc51832f331b1f', 2, '', '', 'fdsfsdfd@xd.de', NULL);
60
61--
62-- Indizes der exportierten Tabellen
63--
64
65--
66-- Indizes für die Tabelle `tblbenutzer`
67--
68ALTER TABLE `tblbenutzer`
69  ADD PRIMARY KEY (`user_id`),
70  ADD UNIQUE KEY `username` (`username`);
71
72--
73-- AUTO_INCREMENT für exportierte Tabellen
74--
75
76--
77-- AUTO_INCREMENT für Tabelle `tblbenutzer`
78--
79ALTER TABLE `tblbenutzer`
80  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
81COMMIT;
82
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;