MYSQL
#2

Your query is incorrect.


It should be something like:

Код:
CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL, 
  `model` int(11) NOT NULL,
  `X` float NOT NULL DEFAULT '0.0',
  `Y` float NOT NULL DEFAULT '0.0',
  `Z` float NOT NULL DEFAULT '0.0',
  `A` float NOT NULL DEFAULT '0.0',
  `col1` int(5) NOT NULL DEFAULT '0',
  `col2` int(5) NOT NULL DEFAULT '0',
  `owned` int(11) NOT NULL,
  `owner` varchar(32) NOT NULL,
  `mod1` int(9) NOT NULL DEFAULT '0',
  `mod2` int(9) NOT NULL DEFAULT '0',
  `mod3` int(9) NOT NULL DEFAULT '0',
  `mod4` int(9) NOT NULL DEFAULT '0',
  `mod5` int(9) NOT NULL DEFAULT '0',
  `mod6` int(9) NOT NULL DEFAULT '0',
  `mod7` int(9) NOT NULL DEFAULT '0',
  `mod8` int(9) NOT NULL DEFAULT '0',
  `mod9` int(9) NOT NULL DEFAULT '0',
  `mod10` int(9) NOT NULL DEFAULT '0',
  `mod11` int(9) NOT NULL DEFAULT '0',
  `mod12` int(9) NOT NULL DEFAULT '0',
  `mod13` int(9) NOT NULL DEFAULT '0',
  `mod14` int(9) NOT NULL DEFAULT '0',
  `mod15` int(9) NOT NULL DEFAULT '0',
  `mod16` int(9) NOT NULL DEFAULT '0',
  `mod17` int(9) NOT NULL DEFAULT '0',
  `paintjob` int(9) NOT NULL DEFAULT '-1',
  `slot` tinyint(2) NOT NULL DEFAULT '0', 
  `security` int(9) NOT NULL,
  `price` int(9) NOT NULL,
  `sprice` int(9) NOT NULL,
  `buyable` tinyint(2) NOT NULL
  `vName` varchar(100) NOT NULL,
  `Engine` tinyint(2) NOT NULL DEFAULT '1',
  `Engines` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT = 1;
Reply


Messages In This Thread
MYSQL - by RayanIbrahim - 06.10.2018, 12:31
Re: MYSQL - by Dennis12 - 06.10.2018, 12:51
Re: MYSQL - by v1k1nG - 06.10.2018, 12:59
Re: MYSQL - by RayanIbrahim - 06.10.2018, 18:36
Re: MYSQL - by Calisthenics - 06.10.2018, 18:54
Re: MYSQL - by Dennis12 - 06.10.2018, 20:40
Re: MYSQL - by RayanIbrahim - 07.10.2018, 04:51
Re: MYSQL - by Calisthenics - 07.10.2018, 07:06
Re: MYSQL - by RayanIbrahim - 10.10.2018, 11:16

Forum Jump:


Users browsing this thread: 1 Guest(s)