-- --------------------------------------------------------
-- Host: s021-mympserver.com
-- Server version: 5.5.16 - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL version: 7.0.0.4170
-- Date/time: 2012-09-15 00:55:57
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Dumping database structure for samp
DROP DATABASE IF EXISTS `samp6222_Pi314159`;
CREATE DATABASE IF NOT EXISTS `samp6222_Pi314159` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `samp6222_Pi314159`;
-- Dumping structure for table samp.accounts
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE IF NOT EXISTS `accounts` (
`Userid` int(11) NOT NULL AUTO_INCREMENT,
`Spielername` varchar(24) NOT NULL,
`Passwort` varchar(64) NOT NULL,
`IpAdresse` varchar(16) NOT NULL,
`Registriert` varchar(32) NOT NULL,
`Eingeloggt` varchar(32) DEFAULT NULL,
`Ausgeloggt` int(11) DEFAULT '0',
`Online` tinyint(1) DEFAULT NULL,
`Adminlevel` int(11) DEFAULT '0',
`Verwarnungen` int(11) DEFAULT '0',
`Premium` bigint(20) DEFAULT '0',
`Spielzeit` int(11) DEFAULT '0',
`Geschlecht` int(11) DEFAULT '0',
`Level` int(11) DEFAULT '1',
`Tutorial` int(11) DEFAULT '0',
`Aussehen` int(11) DEFAULT '-255',
`Geld` int(11) DEFAULT '0',
`Bmod` int(11) DEFAULT '0',
`Mats` int(11) DEFAULT '0',
`SaveDrogen` int(11) DEFAULT '0',
`SaveMats` int(11) DEFAULT '0',
`Drogen` int(11) DEFAULT '0',
`Alter` int(11) DEFAULT '0',
`Ticketsopen` int(11) DEFAULT '0',
`Bank` int(11) DEFAULT '0',
`Telefon` int(11) DEFAULT '0',
`Coints` int(11) DEFAULT '0',
`Telefonnummer` int(11) DEFAULT '-255',
`Telefonbuch` tinyint(1) DEFAULT '0',
`Klingelton` int(11) DEFAULT '-255',
`Personalausweis` tinyint(1) DEFAULT '0',
`PersonalausweisAntrag` int(11) DEFAULT '0',
`Arbeitslos` tinyint(1) DEFAULT '0',
`ArbeitslosAntrag` int(11) DEFAULT '0',
`Job` int(11) DEFAULT '0',
`Jobzeit` int(11) DEFAULT '0',
`Fahrlizenz` tinyint(1) DEFAULT '0',
`FahrlizenzSperre` int(11) DEFAULT '0',
`Fluglizenz` tinyint(1) DEFAULT '0',
`FluglizenzSperre` int(11) DEFAULT '0',
`Lastkraftwagenlizenz` tinyint(1) DEFAULT '0',
`LastkraftwagenlizenzSperre` int(11) DEFAULT '0',
`Motorradlizenz` tinyint(1) DEFAULT '0',
`MotorradlizenzSperre` int(11) DEFAULT '0',
`Schifffahrtslizenz` tinyint(1) DEFAULT '0',
`SchifffahrtslizenzSperre` int(11) DEFAULT '0',
`Waffenlizenz` tinyint(1) DEFAULT '0',
`WaffenlizenzSperre` int(11) DEFAULT '0',
`Gehalt` int(11) DEFAULT '0',
`Fraktion` int(11) DEFAULT '0',
`Fraktionssperre` int(11) DEFAULT '0',
`Boss` tinyint(1) DEFAULT '0',
`Rang` int(11) DEFAULT '0',
`Strafpunkte` int(11) DEFAULT '0',
`PaydayZeit` int(10) DEFAULT '0',
`Respektpunkte` int(11) DEFAULT '0',
`Fischskill` int(11) DEFAULT '0',
`Detektivskill` int(11) DEFAULT '0',
`Hurenskill` int(11) DEFAULT '0',
`Anwaltskill` int(11) DEFAULT '0',
`Mechanikerskill` int(11) DEFAULT '0',
`Newsskill` int(11) DEFAULT '0',
`Drogenskill` int(11) DEFAULT '0',
`Krankenhaus` int(11) DEFAULT '0',
`Friedhof` int(11) DEFAULT '0',
`TotX` float DEFAULT NULL,
`TotY` float DEFAULT NULL,
`TotZ` float DEFAULT NULL,
`Tode` int(11) DEFAULT '0',
`LogoutX` float DEFAULT NULL,
`LogoutY` float DEFAULT NULL,
`LogoutZ` float DEFAULT NULL,
`Fische` int(11) DEFAULT '0',
`Haus` int(11) DEFAULT '-255',
`Spawn` int(11) DEFAULT '0',
`Morde` int(11) DEFAULT '0',
`Kills` int(11) DEFAULT '0',
`Verbrechen` int(11) DEFAULT '0',
`Wantedlevel` int(11) DEFAULT '0',
`Knast` int(11) DEFAULT '0',
`KnastZeit` int(11) DEFAULT '0',
`Angellizenz` tinyint(1) DEFAULT '0',
`eMail` varchar(100) NOT NULL DEFAULT '0',
`eMailConfirmKey` varchar(10) NOT NULL DEFAULT '0',
`TeamspeakRegistered` int(1) NOT NULL DEFAULT '0',
`TeamspeakDBID` int(5) NOT NULL DEFAULT '0',
`TeamspeakUID` varchar(100) NOT NULL DEFAULT '0',
`TeamspeakSupporter` int(1) NOT NULL DEFAULT '0',
`TeamspeakChannelAdmin` int(5) NOT NULL DEFAULT '0',
`TeamspeakBanned` int(1) NOT NULL DEFAULT '0',
`ComplainModerator` int(1) NOT NULL DEFAULT '0',
`ForumRegistered` int(5) NOT NULL DEFAULT '0',
`ForumModerator` int(5) NOT NULL DEFAULT '0',
`ForumGroupLeader` int(4) NOT NULL DEFAULT '0',
`ForumDonator` int(1) NOT NULL DEFAULT '0',
`ControlPanelBanned` int(1) NOT NULL DEFAULT '0',
KEY `Userid` (`Userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Data exporting was unselected.
-- Dumping structure for table samp.bans
DROP TABLE IF EXISTS `bans`;
CREATE TABLE IF NOT EXISTS `bans` (
`Banid` int(11) NOT NULL AUTO_INCREMENT,
`Spielername` varchar(24) NOT NULL,
`IpAdresse` varchar(16) NOT NULL,
`Range-IpAdresse` varchar(16) NOT NULL,
`Zeit` bigint(20) DEFAULT '0',
`Datum` varchar(24) NOT NULL,
`Uhrzeit` varchar(12) NOT NULL,
`Grund` varchar(128) DEFAULT 'Kein Grund angegeben',
`Von` varchar(24) DEFAULT 'Server',
`CPSM` int(1) NOT NULL DEFAULT '0' COMMENT 'Verhindert den Zugriff auf das CP.',
KEY `Banid` (`Banid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Data exporting was unselected.
-- Dumping structure for table samp.playercars
DROP TABLE IF EXISTS `playercars`;
CREATE TABLE IF NOT EXISTS `playercars` (
`Carid` int(11) NOT NULL AUTO_INCREMENT,
`Spielername` varchar(24) NOT NULL,
`Code` int(11) NOT NULL,
`Kaufpreis` int(11) NOT NULL,
`Model` int(11) NOT NULL,
`Pos_X` float NOT NULL,
`Pos_Y` float NOT NULL,
`Pos_Z` float NOT NULL,
`Pos_A` float NOT NULL,
`Farbe_1` int(11) DEFAULT '-1',
`Farbe_2` int(11) DEFAULT '-1',
`Lackierung` int(11) DEFAULT '-255',
`LastHealth` float DEFAULT '1000',
`panelDamage` int(11) DEFAULT '0',
`doorDamage` int(11) DEFAULT '0',
`lightDamage` int(11) DEFAULT '0',
`tireDamage` int(11) DEFAULT '0',
`Comp00` int(11) DEFAULT '0',
`Comp01` int(11) DEFAULT '0',
`Comp02` int(11) DEFAULT '0',
`Comp03` int(11) DEFAULT '0',
`Comp04` int(11) DEFAULT '0',
`Comp05` int(11) DEFAULT '0',
`Comp06` int(11) DEFAULT '0',
`Comp07` int(11) DEFAULT '0',
`Comp08` int(11) DEFAULT '0',
`Comp09` int(11) DEFAULT '0',
`Comp10` int(11) DEFAULT '0',
`Comp11` int(11) DEFAULT '0',
`Comp12` int(11) DEFAULT '0',
`Comp13` int(11) DEFAULT '0',
`Benzin` int(11) DEFAULT '0',
`Abgeschleppt` tinyint(1) DEFAULT '0',
`Versicherung` int(11) DEFAULT '0',
`Panzerung` int(11) DEFAULT '1',
PRIMARY KEY (`Carid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Data exporting was unselected.
-- Dumping structure for table samp.transactions
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE IF NOT EXISTS `transactions` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Author` varchar(50) NOT NULL DEFAULT 'Unbekannt',
`Receiver` varchar(50) NOT NULL DEFAULT 'Unbekannt',
`Purpose` varchar(50) NOT NULL DEFAULT 'Kein Verwendungszweck',
`Amount` int(10) NOT NULL DEFAULT '0',
`Time` varchar(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;