Код:
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 ;
