MYSQL Help
#7

Here's your vehicles table.
Looks like you were missing a primary key towards `id`.

Code:
CREATE TABLE `vehicles` (
  `id` int(128) NOT NULL,
  `model` int(128) DEFAULT NULL,
  `X` varchar(128) DEFAULT NULL,
  `Y` varchar(128) DEFAULT NULL,
  `Z` varchar(128) DEFAULT NULL,
  `A` varchar(128) DEFAULT NULL,
  `col1` int(128) DEFAULT NULL,
  `col2` int(128) DEFAULT NULL,
  `owned` int(10) DEFAULT NULL,
  `owner` varchar(128) DEFAULT NULL,
  `mod1` int(128) NOT NULL DEFAULT '-1',
  `mod2` int(128) NOT NULL DEFAULT '-1',
  `mod3` int(128) NOT NULL DEFAULT '-1',
  `mod4` int(128) NOT NULL DEFAULT '-1',
  `mod5` int(128) NOT NULL DEFAULT '-1',
  `mod6` int(128) NOT NULL DEFAULT '-1',
  `mod7` int(128) NOT NULL DEFAULT '-1',
  `mod8` int(128) NOT NULL DEFAULT '-1',
  `mod9` int(128) NOT NULL DEFAULT '-1',
  `mod10` int(128) NOT NULL DEFAULT '-1',
  `mod11` int(128) NOT NULL DEFAULT '-1',
  `mod12` int(128) NOT NULL DEFAULT '-1',
  `mod13` int(128) NOT NULL DEFAULT '-1',
  `mod14` int(128) NOT NULL DEFAULT '-1',
  `mod15` int(128) NOT NULL DEFAULT '-1',
  `mod16` int(128) NOT NULL DEFAULT '-1',
  `mod17` int(128) NOT NULL DEFAULT '-1',
  `paintjob` int(10) DEFAULT NULL,
  `slot` int(10) NOT NULL DEFAULT '0',
  `security` int(128) DEFAULT NULL,
  `price` int(128) DEFAULT NULL,
  `sprice` int(128) DEFAULT NULL,
  `buyable` int(10) DEFAULT NULL,
  `vName` varchar(128) DEFAULT NULL,
  `Engine` int(10) NOT NULL DEFAULT '1',
  `Engines` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`);
Here's your houses table, same as vehicles table. You were missing Primary Key on `ID`.

Code:
CREATE TABLE `houses` (
  `ID` int(128) NOT NULL,
  `HX` varchar(128) DEFAULT NULL,
  `HY` varchar(128) DEFAULT NULL,
  `HZ` varchar(128) DEFAULT NULL,
  `IX` varchar(128) NOT NULL DEFAULT '0',
  `IY` varchar(128) NOT NULL DEFAULT '0',
  `IZ` varchar(128) NOT NULL DEFAULT '0',
  `Price` int(128) DEFAULT NULL,
  `SPrice` int(128) DEFAULT NULL,
  `Interior` int(10) DEFAULT NULL,
  `World` int(128) DEFAULT NULL,
  `Locked` int(10) DEFAULT NULL,
  `Owned` int(128) DEFAULT NULL,
  `Owner` varchar(128) DEFAULT NULL,
  `Make` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `houses`
  ADD PRIMARY KEY (`ID`);
Best of luck, if you want to learn how to use MySQL go here: https://www.w3schools.com/sql/default.asp
Reply


Messages In This Thread
MYSQL Help - by RayanIbrahim - 06.10.2018, 05:53
Re: MYSQL Help - by Sithis - 09.10.2018, 14:58
Re: MYSQL Help - by Calisthenics - 09.10.2018, 15:27
Re: MYSQL Help - by ovelino - 13.10.2018, 11:15
Re: MYSQL Help - by ropapefeti - 23.10.2018, 08:13
Re: MYSQL Help - by GTLS - 23.10.2018, 10:21
Re: MYSQL Help - by Nito - 23.10.2018, 13:10

Forum Jump:


Users browsing this thread: 1 Guest(s)