[tboysamp]

Код:

CREATE TABLE IF NOT EXISTS `characters` (
`ID` int(6) NOT NULL,
  `A_ID` int(6) NOT NULL,
  `Name` varchar(34) NOT NULL,
  `RegisterIP` varchar(16) NOT NULL,
  `RegisterDate` int(12) NOT NULL,
  `LatestIP` varchar(16) NOT NULL,
  `Tutorial` int(2) NOT NULL,
  `Level` int(5) NOT NULL,
  `XP` int(6) NOT NULL,
  `Cash` int(11) NOT NULL,
  `Skin` int(3) NOT NULL,
  `PosX` float NOT NULL,
  `PosY` float NOT NULL,
  `PosZ` float NOT NULL,
  `VWorld` int(4) NOT NULL,
  `Interior` int(2) NOT NULL,
  `Age` int(3) NOT NULL,
  `Gender` int(2) NOT NULL,
  `Kicks` int(5) NOT NULL,
  `Muted` int(2) NOT NULL,
  `Faction` int(2) NOT NULL,
  `Rank` int(2) NOT NULL,
  `Job` int(2) NOT NULL,
  `Health` float NOT NULL,
  `Armour` float NOT NULL,
  `hEntered` int(5) NOT NULL,
  `bEntered` int(5) NOT NULL,
  `Vehicles` int(3) NOT NULL,
  `Bank` int(12) NOT NULL,
  `ExemptIP` int(11) NOT NULL,
  `TotalTimePlayed` int(12) NOT NULL,
  `OnlinePeriod` int(12) NOT NULL,
  `Payday` int(12) NOT NULL,
  `LastOnline` int(12) NOT NULL,
  `PhoneStatus` int(2) NOT NULL,
  `PhoneNumber` int(11) NOT NULL,
  `TruckingCompleted` int(6) NOT NULL,
  `TruckCoolDown` int(12) NOT NULL,
  `GDL` int(2) NOT NULL,
  `CDL` int(2) NOT NULL,
  `MDL` int(2) NOT NULL,
  `Fare` int(3) NOT NULL,
  `VehicleRadio` int(2) NOT NULL,
  `Cuffed` int(1) NOT NULL,
  `Spawn` int(1) NOT NULL,
  `Jail` int(4) NOT NULL,
  `Radio` int(2) NOT NULL,
  `RadioFreq` int(4) NOT NULL DEFAULT '27',
  `Weapons` varchar(104) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `Uniform` int(4) NOT NULL,
  `Screwdriver` int(2) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;