players.sql

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `players`
-- ----------------------------
CREATE TABLE `players` (
  `ID` int(12) NOT NULL AUTO_INCREMENT,
  `Username` varchar(24) NOT NULL,
  `Password` varchar(129) NOT NULL,
  `Level` int(6) NOT NULL DEFAULT '0',
  `AdminLevel` int(6) NOT NULL DEFAULT '0',
  `AdminName` varchar(24) NOT NULL DEFAULT 'Nobody',
  `BanAppealer` int(2) NOT NULL DEFAULT '0',
  `Donator` int(2) NOT NULL DEFAULT '0',
  `Tokens` int(129) NOT NULL DEFAULT '0',
  `Banned` int(2) NOT NULL DEFAULT '0',
  `Permabanned` int(2) NOT NULL DEFAULT '0',
  `Disabled` int(2) NOT NULL DEFAULT '0',
  `LastIP` varchar(20) NOT NULL DEFAULT '0.0.0.0',
  `Registered` int(2) NOT NULL DEFAULT '0',
  `Tutorial` int(2) NOT NULL DEFAULT '0',
  `Sex` int(2) NOT NULL DEFAULT '0',
  `Age` int(3) NOT NULL DEFAULT '16',
  `Skin` int(3) NOT NULL DEFAULT '299',
  `PosX` varchar(32) NOT NULL DEFAULT '0.000',
  `PosY` varchar(32) NOT NULL DEFAULT '0.000',
  `PosZ` varchar(32) NOT NULL DEFAULT '0.000',
  `PosR` varchar(32) NOT NULL DEFAULT '0.000',
  `ConnectTime` int(4) NOT NULL DEFAULT '0',
  `Respect` int(9) NOT NULL DEFAULT '0',
  `PhoneNumber` int(11) NOT NULL DEFAULT '0',
  `Warnings` int(1) NOT NULL DEFAULT '0',
  `Gang` int(2) NOT NULL DEFAULT '255',
  `Faction` int(2) NOT NULL DEFAULT '0',
  `Leader` int(2) NOT NULL DEFAULT '0',
  `Rank` int(1) NOT NULL DEFAULT '0',
  `GarageKey` int(100) NOT NULL DEFAULT '-1',
  `Job` int(2) NOT NULL DEFAULT '0',
  `Job2` int(2) NOT NULL DEFAULT '0',
  `UpgradePoints` int(9) NOT NULL DEFAULT '0',
  `SpawnArmor` varchar(32) NOT NULL DEFAULT '0.0',
  `Cash` int(11) NOT NULL DEFAULT '50',
  `Bank` int(11) NOT NULL DEFAULT '50',
  `Insurance` int(2) NOT NULL DEFAULT '0',
  `Crimes` int(9) NOT NULL DEFAULT '0',
  `Arrested` int(4) NOT NULL DEFAULT '0',
  `WantedLevel` int(1) NOT NULL DEFAULT '0',
  `Health` varchar(32) NOT NULL DEFAULT '75.0',
  `Armor` varchar(32) NOT NULL DEFAULT '0.0',
  `Pot` int(9) NOT NULL DEFAULT '0',
  `Crack` int(9) NOT NULL DEFAULT '0',
  `Radio` int(1) NOT NULL DEFAULT '0',
  `RadioFreq` int(11) NOT NULL DEFAULT '-1',
  `Phonebook` int(1) NOT NULL DEFAULT '0',
  `Dice` int(4) NOT NULL DEFAULT '0',
  `CDPlayer` int(4) NOT NULL DEFAULT '0',
  `Materials` int(4) NOT NULL DEFAULT '0',
  `Rope` int(4) NOT NULL DEFAULT '0',
  `Cigars` int(4) NOT NULL DEFAULT '0',
  `Sprunk` int(4) NOT NULL DEFAULT '0',
  `Spraycan` int(4) NOT NULL DEFAULT '0',
  `House` int(4) NOT NULL DEFAULT '0',
  `House2` int(4) NOT NULL DEFAULT '0',
  `Renting` int(4) NOT NULL DEFAULT '0',
  `Interior` int(11) NOT NULL DEFAULT '0',
  `VirtualWorld` int(11) NOT NULL DEFAULT '0',
  `Jailed` int(1) NOT NULL DEFAULT '0',
  `JailTime` int(11) NOT NULL DEFAULT '0',
  `Gun0` int(2) NOT NULL DEFAULT '0',
  `Gun1` int(2) NOT NULL DEFAULT '0',
  `Gun2` int(2) NOT NULL DEFAULT '0',
  `Gun3` int(2) NOT NULL DEFAULT '0',
  `Gun4` int(2) NOT NULL DEFAULT '0',
  `Gun5` int(2) NOT NULL DEFAULT '0',
  `Gun6` int(2) NOT NULL DEFAULT '0',
  `Gun7` int(2) NOT NULL DEFAULT '0',
  `Gun8` int(2) NOT NULL DEFAULT '0',
  `Gun9` int(2) NOT NULL DEFAULT '0',
  `Gun10` int(2) NOT NULL DEFAULT '0',
  `Gun11` int(2) NOT NULL DEFAULT '0',
  `Paycheck` int(11) NOT NULL DEFAULT '0',
  `PayReady` int(2) NOT NULL DEFAULT '0',
  `Hospital` int(2) NOT NULL DEFAULT '0',
  `DetSkill` int(5) NOT NULL DEFAULT '0',
  `FishSkill` int(12) NOT NULL DEFAULT '0',
  `LawSkill` int(5) NOT NULL DEFAULT '0',
  `SexSkill` int(5) NOT NULL DEFAULT '0',
  `DrugsSkill` int(5) NOT NULL DEFAULT '0',
  `SmugglerSkill` int(5) NOT NULL DEFAULT '0',
  `ArmsSkill` int(5) NOT NULL DEFAULT '0',
  `MechSkill` int(5) NOT NULL DEFAULT '0',
  `BoxSkill` int(5) NOT NULL DEFAULT '0',
  `TruckSkill` int(5) NOT NULL DEFAULT '0',
  `CarSkill` int(5) NOT NULL DEFAULT '0',
  `LawyerTime` int(4) NOT NULL DEFAULT '0',
  `LawyerFreeTime` int(4) NOT NULL DEFAULT '0',
  `DrugsTime` int(4) NOT NULL DEFAULT '0',
  `MechTime` int(4) NOT NULL DEFAULT '0',
  `SexTime` int(4) NOT NULL DEFAULT '0',
  `CarTime` int(4) NOT NULL DEFAULT '0',
  `Fishes` int(4) NOT NULL DEFAULT '0',
  `BiggestFish` int(4) NOT NULL DEFAULT '0',
  `pWEXists` int(2) NOT NULL DEFAULT '0',
  `pWX` varchar(32) NOT NULL DEFAULT '0.0',
  `pWY` varchar(32) NOT NULL DEFAULT '0.0',
  `pWZ` varchar(32) NOT NULL DEFAULT '0.0',
  `pWVW` int(9) NOT NULL DEFAULT '0',
  `pWInt` int(9) NOT NULL DEFAULT '0',
  `pWValue` int(9) NOT NULL DEFAULT '0',
  `pWSeeds` int(4) NOT NULL DEFAULT '0',
  `Wins` int(9) NOT NULL DEFAULT '0',
  `Loses` int(9) NOT NULL DEFAULT '0',
  `FightingStyle` int(4) NOT NULL DEFAULT '0',
  `Screwdriver` int(4) NOT NULL DEFAULT '0',
  `Smslog` int(2) NOT NULL DEFAULT '0',
  `Wristwatch` int(2) NOT NULL DEFAULT '0',
  `Tire` int(4) NOT NULL DEFAULT '0',
  `Firstaid` int(4) NOT NULL DEFAULT '0',
  `Rccam` int(4) NOT NULL DEFAULT '0',
  `Receiver` int(4) NOT NULL DEFAULT '0',
  `GPS` int(4) NOT NULL DEFAULT '0',
  `Sweep` int(4) NOT NULL DEFAULT '0',
  `SweepLeft` int(4) NOT NULL DEFAULT '0',
  `Bugged` int(4) NOT NULL DEFAULT '0',
  `OnDuty` int(2) NOT NULL DEFAULT '0',
  `CarLic` int(2) NOT NULL DEFAULT '0',
  `FlyLic` int(2) NOT NULL DEFAULT '0',
  `BoatLic` int(2) NOT NULL DEFAULT '0',
  `FishLic` int(2) NOT NULL DEFAULT '0',
  `GunLic` int(2) NOT NULL DEFAULT '0',
  `Division` int(4) NOT NULL DEFAULT '0',
  `TicketTime` int(4) NOT NULL DEFAULT '0',
  `HeadValue` int(11) NOT NULL DEFAULT '0',
  `ContractBy` varchar(24) NOT NULL,
  `ContractDetail` varchar(64) NOT NULL,
  `Bombs` int(4) NOT NULL DEFAULT '0',
  `CHits` int(11) NOT NULL DEFAULT '0',
  `FHits` int(11) NOT NULL DEFAULT '0',
  `PrisonedBy` varchar(24) NOT NULL DEFAULT 'Nobody',
  `PrisonReason` varchar(24) NOT NULL DEFAULT 'None',
  `AcceptReport` int(11) NOT NULL DEFAULT '0',
  `TrashReport` int(11) NOT NULL DEFAULT '0',
  `Accent` int(4) NOT NULL DEFAULT '0',
  `NewMuted` int(4) NOT NULL DEFAULT '0',
  `NewMutedTotal` int(4) NOT NULL DEFAULT '0',
  `AdMuted` int(4) NOT NULL DEFAULT '0',
  `AdMutedTotal` int(4) NOT NULL DEFAULT '0',
  `ReportMuted` int(2) NOT NULL DEFAULT '0',
  `ReportMutedTotal` int(4) NOT NULL DEFAULT '0',
  `ReportMutedTime` int(9) NOT NULL DEFAULT '0',
  `Speedo` int(2) NOT NULL DEFAULT '0',
  `GCMuted` int(4) NOT NULL DEFAULT '0',
  `GCMutedTime` int(9) NOT NULL DEFAULT '0',
  `CallsAccepted` int(11) NOT NULL DEFAULT '0',
  `PatientsDelivered` int(11) NOT NULL DEFAULT '0',
  `TriageTime` int(9) NOT NULL DEFAULT '9',
  `Married` int(2) NOT NULL DEFAULT '0',
  `MarriedTo` varchar(24) NOT NULL,
  `ReferredBy` varchar(24) NOT NULL,
  `RefTokens` int(9) NOT NULL DEFAULT '0',
  `RefTokensOffline` int(9) NOT NULL DEFAULT '0',
  `Helper` int(2) NOT NULL DEFAULT '0',
  `GangMod` int(2) NOT NULL DEFAULT '0',
  `LiveBanned` int(2) NOT NULL DEFAULT '0',
  `Flag` varchar(128) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of players
-- ----------------------------
INSERT INTO `players` VALUES ('1', 'Dean_Hurley', '344907E89B981CAF221D05F597EB57A6AF408F15F4DD7895BBD1B96A2938EC24A7DCF23ACB94ECE0B6D7B0640358BC56BDB448194B9305311AFF038A834A079F', '1337', '7', 'Und3rcore', '0', '0', '0', '0', '0', '0', '127.0.0.1', '1', '1', '1', '33', '46', '2532.163818', '-1540.501342', '24.036779', '56.854999', '1337', '0', '0', '0', '255', '10', '10', '7', '0', '0', '0', '0', '0.000000', '100', '100', '0', '0', '0', '0', '100.000000', '100.000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '183', '999', '-1', '0', '0', '0', '0', '0', '3', '24', '0', '0', '0', '0', '0', '0', '41', '0', '0', '889', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000', '0.000000', '0.000000', '0', '0', '-1', '0', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '0', '0', 'Nobody', 'Nobody', '0', '0', '0', 'Nobody', 'None', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Nobody', '0', '0', '0', '0', '0', '0', '');