23.10.2018, 13:10
Here's your vehicles table.
Looks like you were missing a primary key towards `id`.
Here's your houses table, same as vehicles table. You were missing Primary Key on `ID`.
Best of luck, if you want to learn how to use MySQL go here: https://www.w3schools.com/sql/default.asp
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`);
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`);