Datebank

-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 13. Jan 2014 um 23:20
-- Server Version: 5.5.34
-- PHP-Version: 5.4.22


SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;


--
-- Datenbank: `test`
--


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


--
-- Tabellenstruktur für Tabelle `profile`
--


CREATE TABLE IF NOT EXISTS `profile` (
  `Username` text NOT NULL,
  `Passwort` text NOT NULL,
  `Serial` text NOT NULL,
  `IP` varchar(100) NOT NULL,
  `Bankgeld` int(11) NOT NULL,
  `Geld` int(11) NOT NULL,
  `Spielzeit` int(11) NOT NULL,
  `Kills` int(11) NOT NULL,
  `Admin` int(11) NOT NULL,
  `Deaths` int(11) NOT NULL,
  `Punkte` int(11) NOT NULL,
  `Level` int(11) NOT NULL,
  `Skin` int(11) NOT NULL,
  `Geburtstag` int(11) NOT NULL,
  `Geburtsmonat` int(11) NOT NULL,
  `Geburtsjahr` int(11) NOT NULL,
  `Email` text NOT NULL,
  `DeathmatchTeam1` int(11) NOT NULL,
  `DeathmatchTeam2` int(11) NOT NULL,
  `Waffe` int(11) DEFAULT NULL,
  `Munition` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Daten für Tabelle `profile`
--


INSERT INTO `profile` (`Username`, `Passwort`, `Serial`, `IP`, `Bankgeld`, `Geld`, `Spielzeit`, `Kills`, `Admin`, `Deaths`, `Punkte`, `Level`, `Skin`, `Geburtstag`, `Geburtsmonat`, `Geburtsjahr`, `Email`, `DeathmatchTeam1`, `DeathmatchTeam2`, `Waffe`, `Munition`) VALUES
('[cL]JonKAS', 'D1187FE6D285ACD2C612DB933CFBFE92', 'EC3B2F0846145E15D4843F7CB7D488B4', '192.168.2.119', 0, 3500, 5, 0, 0, 0, 0, 0, 0, 22, 11, 1998, '[email protected]', 0, 0, NULL, NULL),
('JonKAS', 'D1187FE6D285ACD2C612DB933CFBFE92', 'EC3B2F0846145E15D4843F7CB7D488B4', '192.168.2.119', 0, 100000, 4, 0, 0, 0, 0, 0, 0, 22, 11, 1998, '[email protected]', 0, 0, NULL, NULL);


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