 -- --------------------------------------------------------
 
 --
+-- Tabellenstruktur für Tabelle `Oauth`
+--
+
+CREATE TABLE `Oauth` (
+  `oauthId` int(11) NOT NULL,
+  `playerId` int(11) NOT NULL,
+  `type` varchar(50) COLLATE utf8_bin NOT NULL,
+  `firstLogin` int(11) NOT NULL,
+  `lastLogin` int(11) NOT NULL,
+  `oauthIdentifier` varchar(50) COLLATE utf8_bin NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- --------------------------------------------------------
+
+--
 -- Tabellenstruktur für Tabelle `Player`
 --
 
 CREATE TABLE `Player` (
   `playerId` int(11) NOT NULL,
-  `playerName` varchar(50) COLLATE utf8_bin NOT NULL,
-  `oauthId` varchar(50) COLLATE utf8_bin NOT NULL,
-  `firstLogin` int(11) NOT NULL,
-  `lastLogin` int(11) NOT NULL
+  `playerName` varchar(50) COLLATE utf8_bin NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
 
 -- --------------------------------------------------------

-- AUTO_INCREMENT für Tabelle `Validation`
--
ALTER TABLE `Validation`
  MODIFY `validationId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=283;
--
-- Constraints der exportierten Tabellen
--

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 15. Mai 2017 um 12:12
-- Server-Version: 5.7.17-0ubuntu0.16.04.2
-- PHP-Version: 7.0.15-0ubuntu0.16.04.4

