CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 NOT NULL,
`password` varchar(32) CHARACTER SET utf8 NOT NULL,
`ip` varchar(16) CHARACTER SET utf8 NOT NULL,
`Adminn` int(11) NOT NULL DEFAULT '0',
`ippassword` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'qwerty',
`mail` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT 'None',
`level` int(11) NOT NULL DEFAULT '5',
`cash` int(11) NOT NULL DEFAULT '9999999',
`bank` int(11) NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`datareg` varchar(16) CHARACTER SET utf8 NOT NULL,
`leader` int(3) NOT NULL DEFAULT '0',
`member` int(3) NOT NULL DEFAULT '0',
`rank` int(3) NOT NULL DEFAULT '0',
`warn` int(11) NOT NULL DEFAULT '0',
`sex` int(11) NOT NULL DEFAULT '0',
`model` int(11) NOT NULL DEFAULT '0',
`loach` int(11) NOT NULL DEFAULT '0',
`lic` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '1, 0, 0, 0, 0',
`guns` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',
`ammos` varchar(80) CHARACTER SET utf8 NOT NULL DEFAULT '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',
`skills` int(11) NOT NULL DEFAULT '5000',
`mute` int(11) NOT NULL DEFAULT '0',
`pick` int(4) NOT NULL DEFAULT '0',
`checktime` int(6) NOT NULL DEFAULT '0',
`news` int(11) NOT NULL DEFAULT '0',
`phone` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '0, 0, 0',
`text` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0, 0, 0',
`morgan` int(11) NOT NULL DEFAULT '0',
`morgantime` int(11) NOT NULL DEFAULT '0',
`wanted` int(11) NOT NULL DEFAULT '0',
`wantedtime` int(11) NOT NULL DEFAULT '0',
`wantedwho` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'None',
`wantedreason` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'None',
`heal` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT '70.0',
`drugs` int(11) NOT NULL DEFAULT '0',
`mats` int(11) NOT NULL DEFAULT '0',
`crimes` int(11) NOT NULL DEFAULT '0',
`job` int(11) NOT NULL DEFAULT '0',
`married` int(11) NOT NULL DEFAULT '0',
`whomarried` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'None',
`referal` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'None',
`refmoney` int(11) NOT NULL DEFAULT '0',
`paycheck` int(11) NOT NULL DEFAULT '0',
`fishing` int(11) NOT NULL DEFAULT '0',
`lottery` int(11) NOT NULL DEFAULT '0',
`vip` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`fstyle` int(11) NOT NULL DEFAULT '0',
`credits` int(11) NOT NULL DEFAULT '0',
`totalcredits` int(11) NOT NULL DEFAULT '0',
`skin1` int(11) NOT NULL DEFAULT '0',
`skin2` int(11) NOT NULL DEFAULT '0',
`skin3` int(11) NOT NULL DEFAULT '0',
`spawnchange` int(11) NOT NULL DEFAULT '0',
`sdpistol` int(11) NOT NULL DEFAULT '100',
`deserteagle` int(11) NOT NULL DEFAULT '100',
`shotgun` int(11) NOT NULL DEFAULT '100',
`mp5` int(11) NOT NULL DEFAULT '100',
`ak47` int(11) NOT NULL DEFAULT '100',
`m4` int(11) NOT NULL DEFAULT '100',
`Rpr` int(11) NOT NULL DEFAULT '0',
`glasses` int(11) NOT NULL DEFAULT '0',
`satiety` int(11) NOT NULL DEFAULT '100',
`rprgive` int(11) NOT NULL DEFAULT '0',
`healths` float NOT NULL DEFAULT '100',
`sportexp` int(11) NOT NULL DEFAULT '0',
`online` int(11) NOT NULL DEFAULT '0',
`zakon` int(11) NOT NULL DEFAULT '0',
`bolezn` int(11) NOT NULL DEFAULT '0',
`ipcheck` int(11) NOT NULL DEFAULT '0',
`hospital` int(11) NOT NULL DEFAULT '0',
`watch` int(11) NOT NULL DEFAULT '0',
`ciggare` int(11) NOT NULL DEFAULT '0',
`sprunk` int(11) NOT NULL DEFAULT '1',
`mask` int(11) NOT NULL DEFAULT '0',
`phonebalance` int(11) NOT NULL DEFAULT '100',
`truckskill` int(11) NOT NULL DEFAULT '0',
`cModel` int(11) NOT NULL DEFAULT '0',
`cX` float NOT NULL DEFAULT '0',
`cY` float NOT NULL DEFAULT '0',
`cZ` float NOT NULL DEFAULT '0',
`cFa` float NOT NULL DEFAULT '0',
`cFuel` int(11) NOT NULL DEFAULT '0',
`cNumber` varchar(64) CHARACTER SET utf8 NOT NULL,
`cCarAr` int(11) NOT NULL DEFAULT '0',
`cClass` int(11) NOT NULL DEFAULT '4',
`cColor1` int(11) NOT NULL DEFAULT '0',
`cColor2` int(11) NOT NULL DEFAULT '0',
`cLock` int(11) NOT NULL DEFAULT '0',
`cCost` int(11) NOT NULL DEFAULT '0',
`cVehcom` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`cPaintjob` int(11) NOT NULL DEFAULT '0',
`spawn` int(11) NOT NULL DEFAULT '0',
`Vb` int(11) NOT NULL DEFAULT '1',
`workbook` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
`pVIPDate` int(11) NOT NULL DEFAULT '0',
`model2` int(11) NOT NULL,
`cX2` float NOT NULL,
`cY2` float NOT NULL,
`cZ2` float NOT NULL,
`cFa2` float NOT NULL,
`cFuel2` int(11) NOT NULL,
`cNumber2` varchar(64) CHARACTER SET utf8 NOT NULL,
`cCarAr2` int(11) NOT NULL,
`cClass2` int(11) NOT NULL,
`cColor2_1` int(11) NOT NULL,
`cColor2_2` int(11) NOT NULL,
`cLock2` int(11) NOT NULL,
`cCost2` int(11) NOT NULL,
`cVehcom2` varchar(64) COLLATE utf8_bin NOT NULL,
`cPaint2` int(11) NOT NULL,
`model3` int(11) NOT NULL,
`cX3` float NOT NULL,
`cY3` float NOT NULL,
`cZ3` float NOT NULL,
`cFa3` float NOT NULL,
`cFuel3` int(11) NOT NULL,
`cNumber3` varchar(64) CHARACTER SET utf8 NOT NULL,
`cCarAr3` int(11) NOT NULL,
`cClass3` int(11) NOT NULL,
`cColor3_1` int(11) NOT NULL,
`cColor3_2` int(11) NOT NULL,
`cLock3` int(11) NOT NULL,
`cCost3` int(11) NOT NULL,
`cVehCom3` varchar(64) COLLATE utf8_bin NOT NULL,
`cPaint3` int(11) NOT NULL,
`pCars` int(11) NOT NULL,
`admpass` int(11) NOT NULL DEFAULT '44335645',
`TimeSpec` int(11) NOT NULL,
`TimeRestart` int(11) NOT NULL,
`TimeDay` int(11) NOT NULL,
`KickCount` int(11) NOT NULL,
`BanCount` int(11) NOT NULL,
`WarnCount` int(11) NOT NULL,
`JailCount` int(11) NOT NULL,
`AnsCount` int(11) NOT NULL,
`lastvisit` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '-',
`sendfamily` int(11) NOT NULL DEFAULT '1',
`sendadmin` int(11) NOT NULL DEFAULT '1',
`showgzone` int(11) NOT NULL DEFAULT '1',
`showlogo` int(11) NOT NULL DEFAULT '1',
`showvk` int(11) NOT NULL DEFAULT '1',
`showdate` int(11) NOT NULL DEFAULT '1',
`showkeys` int(11) NOT NULL DEFAULT '1',
`showspeed` int(11) NOT NULL DEFAULT '1',
`showogran` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `pVIPDate` (`pVIPDate`),
KEY `pVIPDate_2` (`pVIPDate`),
KEY `pVIPDate_3` (`pVIPDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=55643 ;