ngg sql dump

-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 20, 2011 at 02:35 PM
-- Server version: 5.0.92
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `fwright_nggserver`
--

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

--
-- Table structure for table `playerAccounts`
--

CREATE TABLE IF NOT EXISTS `playerAccounts` (
  `userID` int(32) NOT NULL auto_increment,
  `Username` varchar(24) collate utf8_unicode_ci NOT NULL,
  `Key` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Level` int(12) NOT NULL default '0',
  `AdminLevel` int(12) NOT NULL default '0',
  `Band` int(2) NOT NULL default '0',
  `PermBand` int(2) NOT NULL default '0',
  `Warnings` int(2) NOT NULL default '0',
  `Disabled` int(1) NOT NULL default '0',
  `DonateRank` int(2) NOT NULL default '0',
  `BanAppealer` int(2) NOT NULL default '0',
  `ShopTech` int(2) NOT NULL default '0',
  `Undercover` int(2) NOT NULL default '0',
  `VIPMod` int(2) NOT NULL default '0',
  `Radio` int(2) NOT NULL default '-1',
  `RadioFreq` int(12) NOT NULL default '0',
  `UpgradePoints` int(6) NOT NULL default '0',
  `Registered` int(4) NOT NULL default '1',
  `ConnectedTime` int(24) NOT NULL default '0',
  `Sex` int(4) NOT NULL default '1',
  `Age` int(3) NOT NULL default '16',
  `Origin` int(4) NOT NULL default '0',
  `Muted` int(2) NOT NULL default '0',
  `Respect` int(4) NOT NULL default '1',
  `Money` int(32) NOT NULL default '1',
  `Bank` int(32) NOT NULL default '1',
  `Crimes` int(4) NOT NULL default '0',
  `Accent` varchar(32) collate utf8_unicode_ci NOT NULL default 'American',
  `CHits` int(4) NOT NULL default '0',
  `FHits` int(4) NOT NULL default '0',
  `Arrested` int(4) NOT NULL default '0',
  `Phonebook` int(4) NOT NULL default '0',
  `LottoNr` int(4) NOT NULL,
  `Fishes` int(12) NOT NULL default '0',
  `BiggestFish` int(12) NOT NULL default '0',
  `Job` int(4) NOT NULL default '0',
  `Job2` int(4) NOT NULL default '0',
  `Paycheck` int(12) NOT NULL default '0',
  `HeadValue` int(32) NOT NULL default '0',
  `Jailed` int(2) NOT NULL default '0',
  `JailTime` int(12) NOT NULL default '0',
  `WRestricted` int(2) NOT NULL default '0',
  `Materials` int(12) NOT NULL default '0',
  `Packages` int(12) NOT NULL default '0',
  `Crates` int(12) NOT NULL default '0',
  `Pot` int(12) NOT NULL default '0',
  `Crack` int(12) NOT NULL default '0',
  `Leader` int(4) NOT NULL default '0',
  `Member` int(4) NOT NULL default '0',
  `Division` int(4) NOT NULL default '0',
  `FMember` int(4) NOT NULL default '255',
  `Rank` int(4) NOT NULL default '0',
  `DetSkill` int(4) NOT NULL default '0',
  `SexSkill` int(4) NOT NULL default '0',
  `BoxSkill` int(4) NOT NULL default '0',
  `LawSkill` int(4) NOT NULL default '0',
  `MechSkill` int(4) NOT NULL default '0',
  `JackSkill` int(4) NOT NULL default '0',
  `CarSkill` int(4) NOT NULL default '0',
  `NewsSkill` int(4) NOT NULL default '0',
  `DrugsSkill` int(4) NOT NULL default '0',
  `ArmsSkill` int(4) NOT NULL default '0',
  `SmugglerSkill` int(4) NOT NULL default '0',
  `FishSkill` int(4) NOT NULL default '0',
  `FightingStyle` int(4) NOT NULL default '0',
  `pHealth` varchar(64) collate utf8_unicode_ci NOT NULL default '100.0',
  `pArmor` varchar(64) collate utf8_unicode_ci NOT NULL default '0',
  `pSHealth` varchar(64) collate utf8_unicode_ci NOT NULL default '25.0',
  `Int` int(4) NOT NULL default '0',
  `Local` int(4) NOT NULL default '0',
  `VirtualWorld` int(16) NOT NULL default '0',
  `HouseInvite` int(3) NOT NULL default '-1',
  `Model` int(4) NOT NULL default '299',
  `Clothes` int(4) NOT NULL default '299',
  `PhoneNr` int(4) NOT NULL default '0',
  `Apartment` int(4) NOT NULL default '-1',
  `Apartment2` int(4) NOT NULL default '-1',
  `Renting` int(4) NOT NULL default '-1',
  `CarLic` int(4) NOT NULL default '1',
  `FlyLic` int(4) NOT NULL,
  `BoatLic` int(4) NOT NULL,
  `CheckCash` int(4) NOT NULL,
  `Checks` int(4) NOT NULL default '0',
  `GunLic` int(4) NOT NULL default '1',
  `Gun0` int(4) NOT NULL default '0',
  `Gun1` int(4) NOT NULL default '0',
  `Gun2` int(4) NOT NULL default '0',
  `Gun3` int(4) NOT NULL default '0',
  `Gun4` int(4) NOT NULL default '0',
  `Gun5` int(4) NOT NULL default '0',
  `Gun6` int(4) NOT NULL default '0',
  `Gun7` int(4) NOT NULL default '0',
  `Gun8` int(4) NOT NULL default '0',
  `Gun9` int(4) NOT NULL default '0',
  `Gun10` int(4) NOT NULL default '0',
  `Gun11` int(4) NOT NULL default '0',
  `CarTime` int(4) NOT NULL,
  `DrugsTime` int(4) NOT NULL,
  `LawyerTime` int(4) NOT NULL,
  `LawyerFreeTime` int(4) NOT NULL,
  `MechTime` int(4) NOT NULL,
  `SexTime` int(4) NOT NULL,
  `GarbageTime` int(4) NOT NULL,
  `PayDay` int(4) NOT NULL,
  `PayDayHad` int(4) NOT NULL,
  `CDPlayer` int(4) NOT NULL,
  `Dice` int(4) NOT NULL,
  `Spraycan` int(4) NOT NULL,
  `Rope` int(4) NOT NULL,
  `Cigars` int(4) NOT NULL,
  `Speedo` int(4) NOT NULL,
  `Sprunk` int(4) NOT NULL,
  `Bombs` int(4) NOT NULL,
  `Wins` int(4) NOT NULL,
  `Loses` int(4) NOT NULL,
  `Tutorial` int(4) NOT NULL,
  `NoobTut` int(4) NOT NULL,
  `OnDuty` int(4) NOT NULL,
  `Hospital` int(4) NOT NULL,
  `Adjustable` int(4) NOT NULL,
  `Married` int(4) NOT NULL,
  `MarriedTo` varchar(24) collate utf8_unicode_ci NOT NULL,
  `ContractBy` varchar(24) collate utf8_unicode_ci NOT NULL,
  `ContractDetail` varchar(64) collate utf8_unicode_ci NOT NULL,
  `IP` varchar(21) collate utf8_unicode_ci NOT NULL,
  `WantedLevel` int(4) NOT NULL,
  `Insurance` int(4) NOT NULL,
  `NewMuted` int(4) NOT NULL,
  `NewMutedTotal` int(11) NOT NULL,
  `AdMuted` int(11) NOT NULL,
  `AdMutedTotal` int(11) NOT NULL,
  `SPos_x` varchar(32) collate utf8_unicode_ci NOT NULL,
  `SPos_y` varchar(32) collate utf8_unicode_ci NOT NULL,
  `SPos_z` varchar(32) collate utf8_unicode_ci NOT NULL,
  `SPos_r` varchar(32) collate utf8_unicode_ci NOT NULL,
  `Helper` int(4) NOT NULL,
  `BasicWarnings` int(4) NOT NULL,
  `ReportMuted` int(4) NOT NULL,
  `ReportMutedTime` int(4) NOT NULL,
  `VIPMuted` int(4) NOT NULL,
  `VIPMutedTime` int(4) NOT NULL,
  `GiftTime` int(4) NOT NULL,
  `AdvisorDutyHours` int(4) NOT NULL,
  `AcceptedHelp` int(4) NOT NULL,
  `AcceptReport` int(4) NOT NULL,
  `TrashReport` int(4) NOT NULL,
  `FactionModerator` int(4) NOT NULL,
  `GangModerator` int(4) NOT NULL,
  `FactionBanned` int(4) NOT NULL,
  `CSFBanned` int(4) NOT NULL,
  `pv1PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv1PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv1PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv1PosAngle` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv1ModelId` int(4) NOT NULL,
  `pv1Lock` int(4) NOT NULL,
  `pv1Locked` int(4) NOT NULL,
  `pv1PaintJob` int(4) NOT NULL,
  `pv1Color1` int(4) NOT NULL,
  `pv1Color2` int(4) NOT NULL,
  `pv1Ticket` int(4) NOT NULL,
  `pv1Weapon0` int(4) NOT NULL,
  `pv1Weapon1` int(4) NOT NULL,
  `pv1Weapon2` int(4) NOT NULL,
  `pv1WepUpgrade` int(4) NOT NULL,
  `pv1Fuel` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv2PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv2PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv2PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv2PosAngle` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv2ModelId` int(4) NOT NULL,
  `pv2Lock` int(4) NOT NULL,
  `pv2Locked` int(4) NOT NULL,
  `pv2PaintJob` int(4) NOT NULL,
  `pv2Color1` int(4) NOT NULL,
  `pv2Color2` int(4) NOT NULL,
  `pv2Price` int(4) NOT NULL,
  `pv2Ticket` int(4) NOT NULL,
  `pv2Weapon0` int(4) NOT NULL,
  `pv2Weapon1` int(4) NOT NULL,
  `pv2Weapon2` int(4) NOT NULL,
  `pv2WepUpgrade` int(4) NOT NULL,
  `pv2Fuel` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv1Mod0` int(4) NOT NULL,
  `pv1Mod1` int(4) NOT NULL,
  `pv1Mod2` int(4) NOT NULL,
  `pv1Mod3` int(4) NOT NULL,
  `pv1Mod4` int(4) NOT NULL,
  `pv1Mod5` int(4) NOT NULL,
  `pv1Mod6` int(4) NOT NULL,
  `pv1Mod7` int(4) NOT NULL,
  `pv1Mod8` int(4) NOT NULL,
  `pv1Mod9` int(4) NOT NULL,
  `pv1Mod10` int(4) NOT NULL,
  `pv1Mod11` int(4) NOT NULL,
  `pv1Mod12` int(4) NOT NULL,
  `pv1Mod13` int(4) NOT NULL,
  `pv1Mod14` int(4) NOT NULL,
  `pv2Mod0` int(4) NOT NULL,
  `pv2Mod1` int(4) NOT NULL,
  `pv2Mod2` int(4) NOT NULL,
  `pv2Mod3` int(4) NOT NULL,
  `pv2Mod4` int(4) NOT NULL,
  `pv2Mod5` int(4) NOT NULL,
  `pv2Mod6` int(4) NOT NULL,
  `pv2Mod7` int(4) NOT NULL,
  `pv2Mod8` int(4) NOT NULL,
  `pv2Mod9` int(4) NOT NULL,
  `pv2Mod10` int(4) NOT NULL,
  `pv2Mod11` int(4) NOT NULL,
  `pv2Mod12` int(4) NOT NULL,
  `pv2Mod13` int(4) NOT NULL,
  `pv2Mod14` int(4) NOT NULL,
  `pv3PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv3PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv3PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv3PosAngle` int(4) NOT NULL,
  `pv3ModelId` int(4) NOT NULL,
  `pv3Lock` int(4) NOT NULL,
  `pv3Locked` int(4) NOT NULL,
  `pv3PaintJob` int(4) NOT NULL,
  `pv3Color1` int(4) NOT NULL,
  `pv3Color2` int(4) NOT NULL,
  `pv3Price` int(4) NOT NULL,
  `pv3Ticket` int(4) NOT NULL,
  `pv3Weapon0` int(4) NOT NULL,
  `pv3Weapon1` int(4) NOT NULL,
  `pv3Weapon2` int(4) NOT NULL,
  `pv3WepUpgrade` int(4) NOT NULL,
  `pv3Fuel` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv4PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv4PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv4PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv4PosAngle` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv4ModelId` int(4) NOT NULL,
  `pv4Lock` int(4) NOT NULL,
  `pv4Locked` int(4) NOT NULL,
  `pv4PaintJob` int(4) NOT NULL,
  `pv4Color1` int(4) NOT NULL,
  `pv4Color2` int(4) NOT NULL,
  `pv4Price` int(4) NOT NULL,
  `pv4Ticket` int(4) NOT NULL,
  `pv4Weapon0` int(4) NOT NULL,
  `pv4Weapon1` int(4) NOT NULL,
  `pv4Weapon2` int(4) NOT NULL,
  `pv4WepUpgrade` int(4) NOT NULL,
  `pv4Fuel` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv3Mod0` int(4) NOT NULL,
  `pv3Mod1` int(4) NOT NULL,
  `pv3Mod2` int(4) NOT NULL,
  `pv3Mod3` int(4) NOT NULL,
  `pv3Mod4` int(4) NOT NULL,
  `pv3Mod5` int(4) NOT NULL,
  `pv3Mod6` int(4) NOT NULL,
  `pv3Mod7` int(4) NOT NULL,
  `pv3Mod8` int(4) NOT NULL,
  `pv3Mod9` int(4) NOT NULL,
  `pv3Mod10` int(4) NOT NULL,
  `pv3Mod11` int(4) NOT NULL,
  `pv3Mod12` int(4) NOT NULL,
  `pv3Mod13` int(4) NOT NULL,
  `pv3Mod14` int(4) NOT NULL,
  `pv4Mod0` int(4) NOT NULL,
  `pv4Mod1` int(4) NOT NULL,
  `pv4Mod2` int(4) NOT NULL,
  `pv4Mod3` int(4) NOT NULL,
  `pv4Mod4` int(4) NOT NULL,
  `pv4Mod5` int(4) NOT NULL,
  `pv4Mod6` int(4) NOT NULL,
  `pv4Mod7` int(4) NOT NULL,
  `pv4Mod8` int(4) NOT NULL,
  `pv4Mod9` int(4) NOT NULL,
  `pv4Mod10` int(4) NOT NULL,
  `pv4Mod11` int(4) NOT NULL,
  `pv4Mod12` int(4) NOT NULL,
  `pv4Mod13` int(4) NOT NULL,
  `pv4Mod14` int(4) NOT NULL,
  `pv0Mod0` int(4) NOT NULL,
  `pv0Mod1` int(4) NOT NULL,
  `pv0Mod2` int(4) NOT NULL,
  `pv0Mod3` int(4) NOT NULL,
  `pv0Mod4` int(4) NOT NULL,
  `pv0Mod5` int(4) NOT NULL,
  `pv0Mod6` int(4) NOT NULL,
  `pv0Mod7` int(4) NOT NULL,
  `pv0Mod8` int(4) NOT NULL,
  `pv0Mod9` int(4) NOT NULL,
  `pv0Mod10` int(4) NOT NULL,
  `pv0Mod11` int(4) NOT NULL,
  `pv0Mod12` int(4) NOT NULL,
  `pv0Mod13` int(4) NOT NULL,
  `pv0Mod14` int(4) NOT NULL,
  `pv0PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv0PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv0PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv0PosAngle` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pv0ModelId` int(4) NOT NULL,
  `pv0Lock` int(4) NOT NULL,
  `pv0Locked` int(4) NOT NULL,
  `pv0PaintJob` int(4) NOT NULL,
  `pv0Color1` int(4) NOT NULL,
  `pv0Color2` int(4) NOT NULL,
  `pv0Price` int(4) NOT NULL,
  `pv0Ticket` int(4) NOT NULL,
  `pv0Weapon0` int(4) NOT NULL,
  `pv0Weapon1` int(4) NOT NULL,
  `pv0Weapon2` int(4) NOT NULL,
  `pv0WepUpgrade` int(4) NOT NULL,
  `pv0Fuel` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0ModelID` int(4) NOT NULL,
  `pt0Bone` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0RotX` int(32) NOT NULL,
  `pt0RotY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt0RotZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1ModelID` int(4) NOT NULL,
  `pt1Bone` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1RotX` int(32) NOT NULL,
  `pt1RotY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt1RotZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2ModelID` int(4) NOT NULL,
  `pt2Bone` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2RotX` int(32) NOT NULL,
  `pt2RotY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt2RotZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3ModelID` int(4) NOT NULL,
  `pt3Bone` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3RotX` int(32) NOT NULL,
  `pt3RotY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt3RotZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4ModelID` int(4) NOT NULL,
  `pt4Bone` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4PosX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4PosY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4PosZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4RotX` int(32) NOT NULL,
  `pt4RotY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pt4RotZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `VIPInviteDay` int(4) NOT NULL,
  `TempVIP` int(4) NOT NULL,
  `BuddyInvite` int(4) NOT NULL,
  `Tokens` int(4) NOT NULL,
  `PTokens` int(4) NOT NULL,
  `TriageTime` int(4) NOT NULL,
  `PrisonedBy` varchar(24) collate utf8_unicode_ci NOT NULL,
  `PrisonReason` varchar(64) collate utf8_unicode_ci NOT NULL,
  `Flag` varchar(128) collate utf8_unicode_ci NOT NULL,
  `TaxiLicense` int(4) NOT NULL,
  `TicketTime` int(4) NOT NULL,
  `Screwdriver` int(4) NOT NULL,
  `Smslog` int(4) NOT NULL,
  `Wristwatch` int(4) NOT NULL,
  `Surveillance` int(4) NOT NULL,
  `Tire` int(4) NOT NULL,
  `Firstaid` int(4) NOT NULL,
  `Rccam` int(4) NOT NULL,
  `Receiver` int(4) NOT NULL,
  `GPS` int(4) NOT NULL,
  `Sweep` int(4) NOT NULL,
  `SweepLeft` int(4) NOT NULL,
  `Bugged` int(4) NOT NULL,
  `BuggedSIU` int(4) NOT NULL,
  `Smslog0` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog1` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog2` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog3` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog4` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog5` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog6` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog7` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog8` varchar(128) collate utf8_unicode_ci NOT NULL,
  `Smslog9` varchar(128) collate utf8_unicode_ci NOT NULL,
  `KillLog0` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog1` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog2` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog3` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog4` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog5` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog6` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog7` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog8` varchar(24) collate utf8_unicode_ci NOT NULL,
  `KillLog9` varchar(24) collate utf8_unicode_ci NOT NULL,
  `pWExists` int(4) NOT NULL,
  `pWX` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pWY` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pWZ` varchar(32) collate utf8_unicode_ci NOT NULL,
  `pWVW` int(4) NOT NULL,
  `pWInt` int(4) NOT NULL,
  `pWValue` int(4) NOT NULL,
  `pWSeeds` int(4) NOT NULL,
  `Warrants` varchar(128) collate utf8_unicode_ci NOT NULL,
  `JudgeJailTime` int(4) NOT NULL,
  `JudgeJailType` int(4) NOT NULL,
  `BeingSentenced` int(4) NOT NULL,
  `DMIndicators` int(4) NOT NULL,
  `DMKills` int(4) NOT NULL,
  `DMReport0` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport1` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport2` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport3` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport4` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport5` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport6` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport7` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport8` varchar(128) collate utf8_unicode_ci NOT NULL,
  `DMReport9` varchar(128) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `playerAccounts`
--