06.06.2012, 09:14
(
Последний раз редактировалось CoaPsyFactor; 06.06.2012 в 19:02.
)
It is AI, and key primary, that's the reason I'm asking here
I found some strange error, as you can see in structure default AUTO_INCREMENT is 34, and when I buy car id start from 1 :/
here is vID not Primary but I changed it in pma
![Cheesy](images/smilies/biggrin.png)
Код:
CREATE TABLE IF NOT EXISTS `cocars` ( `vID` int(12) NOT NULL AUTO_INCREMENT, `vModel` smallint(4) NOT NULL, `vType` smallint(3) NOT NULL DEFAULT '0', `vUsage` smallint(3) NOT NULL DEFAULT '0', `vUsedFor` smallint(3) NOT NULL DEFAULT '0', `vLocX` float NOT NULL DEFAULT '0', `vLocY` float NOT NULL DEFAULT '0', `vLocZ` float NOT NULL DEFAULT '0', `vAngle` float NOT NULL DEFAULT '0', `vColor1` smallint(3) NOT NULL DEFAULT '0', `vColor2` smallint(3) NOT NULL DEFAULT '0', `vRespawnDelay` int(12) NOT NULL DEFAULT '0', `vFaction` smallint(3) NOT NULL DEFAULT '0', `vJob` smallint(3) NOT NULL DEFAULT '0', `vLocked` tinyint(1) NOT NULL DEFAULT '0', `vInt` smallint(3) NOT NULL DEFAULT '0', `vViwo` smallint(3) NOT NULL DEFAULT '0', `vOwner` varchar(24) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one', `vSpawned` tinyint(1) NOT NULL DEFAULT '0', `vehHealth` float NOT NULL DEFAULT '0', `vPanels` int(12) NOT NULL DEFAULT '0', `vDoors` int(12) NOT NULL DEFAULT '0', `vehLights` int(12) NOT NULL DEFAULT '0', `vTires` int(12) NOT NULL DEFAULT '0', `vLock` tinyint(1) NOT NULL DEFAULT '0', `vAlarm` tinyint(1) NOT NULL DEFAULT '0', `vImobilizator` tinyint(1) NOT NULL DEFAULT '0', `vFuel` smallint(3) NOT NULL DEFAULT '0', `vSecurity` tinyint(1) NOT NULL DEFAULT '0', `vTuned` tinyint(1) NOT NULL DEFAULT '0', `vNeon` int(5) NOT NULL DEFAULT '0', `vNumberPlate` int(8) NOT NULL DEFAULT '0', `vPaintJob` tinyint(1) NOT NULL DEFAULT '0', `vSpoiler` smallint(5) NOT NULL DEFAULT '0', `vHood` smallint(5) NOT NULL DEFAULT '0', `vRoof` smallint(5) NOT NULL DEFAULT '0', `vSkirt` smallint(5) NOT NULL DEFAULT '0', `vLamps` smallint(5) NOT NULL DEFAULT '0', `vNitro` smallint(5) NOT NULL DEFAULT '0', `vExhaust` smallint(5) NOT NULL DEFAULT '0', `vWheels` smallint(5) NOT NULL DEFAULT '0', `vStereo` smallint(5) NOT NULL DEFAULT '0', `vHydraulics` smallint(5) NOT NULL DEFAULT '0', `vFrontBumper` smallint(5) NOT NULL DEFAULT '0', `vRearBumper` smallint(5) NOT NULL DEFAULT '0', `vVentRight` smallint(5) NOT NULL DEFAULT '0', `vVentLeft` smallint(5) NOT NULL DEFAULT '0', `vTimesDestroy` smallint(2) NOT NULL DEFAULT '0', `vGPS` tinyint(1) NOT NULL DEFAULT '0', `vMelee` smallint(2) NOT NULL DEFAULT '0', `vWeap1` smallint(2) NOT NULL DEFAULT '0', `vWeap2` smallint(2) NOT NULL DEFAULT '0', `vAmmo1` smallint(5) NOT NULL DEFAULT '0', `vAmmo2` smallint(5) NOT NULL DEFAULT '0', `vDrug1` smallint(5) NOT NULL DEFAULT '0', `vDrug2` smallint(5) NOT NULL DEFAULT '0', `vDrug3` smallint(5) NOT NULL DEFAULT '0', `vDrug4` smallint(5) NOT NULL DEFAULT '0', `vDrug5` smallint(5) NOT NULL DEFAULT '0', `vDrugCode1` mediumint(6) NOT NULL DEFAULT '0', `vDrugCode2` mediumint(6) NOT NULL DEFAULT '0', `vDrugCode3` mediumint(6) NOT NULL DEFAULT '0', `vDrugCode4` mediumint(6) NOT NULL DEFAULT '0', `vDrugCode5` mediumint(6) NOT NULL DEFAULT '0', `vTokiVoki` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`vID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
here is vID not Primary but I changed it in pma