TpJnei97

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Erstellungszeit: 11. Jan 2017 um 20:22
7-- Server Version: 5.5.53-0+deb8u1
8-- PHP-Version: 5.6.29-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Datenbank: `PAIN`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `Geld`
27--
28
29CREATE TABLE IF NOT EXISTS `Geld` (
30`id` int(11) NOT NULL,
31  `datum` text NOT NULL,
32  `Betrag` text NOT NULL,
33  `Besitzer` text NOT NULL,
34  `bezeichnung` text NOT NULL,
35  `gangkonto` text NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Tabellenstruktur für Tabelle `Logs`
42--
43
44CREATE TABLE IF NOT EXISTS `Logs` (
45  `log_id` int(11) NOT NULL,
46  `date` int(11) NOT NULL,
47  `action` int(11) NOT NULL,
48  `trigerred_by` int(11) NOT NULL,
49  `ip` int(11) NOT NULL,
50  `hwuuid` int(11) NOT NULL,
51  `userid` int(11) NOT NULL,
52  `email` int(11) NOT NULL,
53  `error_returned` int(11) NOT NULL,
54  `place` int(11) NOT NULL,
55  `os` int(11) NOT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58-- --------------------------------------------------------
59
60--
61-- Tabellenstruktur für Tabelle `members`
62--
63
64CREATE TABLE IF NOT EXISTS `members` (
65`ID` int(11) NOT NULL,
66  `Vorname` text,
67  `ID_64` text,
68  `IG-NAME` text,
69  `ALTER` int(11) DEFAULT NULL,
70  `Created_at` text,
71  `updatet_at` text,
72  `Rang` int(11) DEFAULT NULL,
73  `column_9` int(11) DEFAULT NULL
74) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
75
76--
77-- Daten für Tabelle `members`
78--
79
80INSERT INTO `members` (`ID`, `Vorname`, `ID_64`, `IG-NAME`, `ALTER`, `Created_at`, `updatet_at`, `Rang`, `column_9`) VALUES
81(1, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
82(2, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
83(3, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
84(4, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
85(5, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
86(6, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
87(7, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
88(8, 'Max', '76561198149599309', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 12, NULL),
89(9, 'Theodor', '7656119814959923a', '[PAIN] Boge Dinero', 16, '05.01.2017', NULL, 10, NULL);
90
91-- --------------------------------------------------------
92
93--
94-- Tabellenstruktur für Tabelle `ranks`
95--
96
97CREATE TABLE IF NOT EXISTS `ranks` (
98  `id` int(11) NOT NULL DEFAULT '0',
99  `Name` text
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101
102--
103-- Daten für Tabelle `ranks`
104--
105
106INSERT INTO `ranks` (`id`, `Name`) VALUES
107(12, 'Mafia-Godfather');
108
109-- --------------------------------------------------------
110
111--
112-- Tabellenstruktur für Tabelle `users`
113--
114
115CREATE TABLE IF NOT EXISTS `users` (
116`id` int(10) unsigned NOT NULL,
117  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
118  `Username` text COLLATE utf8_unicode_ci NOT NULL,
119  `passwort` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
120  `Admin_LVL` int(11) NOT NULL,
121  `vorname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
122  `nachname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
123  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
124  `updated_at` timestamp NULL DEFAULT NULL
125) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
126
127--
128-- Daten für Tabelle `users`
129--
130
131
132
133--
134-- Indizes der exportierten Tabellen
135--
136
137--
138-- Indizes für die Tabelle `Geld`
139--
140ALTER TABLE `Geld`
141 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `id_2` (`id`);
142
143--
144-- Indizes für die Tabelle `members`
145--
146ALTER TABLE `members`
147 ADD PRIMARY KEY (`ID`);
148
149--
150-- Indizes für die Tabelle `ranks`
151--
152ALTER TABLE `ranks`
153 ADD PRIMARY KEY (`id`);
154
155--
156-- Indizes für die Tabelle `users`
157--
158ALTER TABLE `users`
159 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`);
160
161--
162-- AUTO_INCREMENT für exportierte Tabellen
163--
164
165--
166-- AUTO_INCREMENT für Tabelle `Geld`
167--
168ALTER TABLE `Geld`
169MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
170--
171-- AUTO_INCREMENT für Tabelle `members`
172--
173ALTER TABLE `members`
174MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
175--
176-- AUTO_INCREMENT für Tabelle `users`
177--
178ALTER TABLE `users`
179MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
180/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
181/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
182/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;