Witam, mam pytanie czemu w bazie danych w "1ustawienia" piszę "Brak zdefiniowanego indeksu!" o co chodzi, coś nie tak z tabelą "1ustawienia" jak to naprawić?
CREATE TABLE IF NOT EXISTS `1bizworker` ( `bizuid` int(11) NOT NULL, `workeruid` int(11) NOT NULL, `bizskin` int(11) NOT NULL, `bizrank` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin2; CREATE TABLE IF NOT EXISTS `1fracworker` ( `fracuid` int(11) NOT NULL, `workeruid` int(11) NOT NULL, `fracskin` int(11) NOT NULL, `fracrank` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin2; CREATE TABLE IF NOT EXISTS `1orders` ( `orUID` int(11) NOT NULL, `orType` int(11) NOT NULL, `orItemType` int(11) NOT NULL, `orValue1` int(11) NOT NULL, `orValue2` int(11) NOT NULL, `orPrice` int(11) NOT NULL, `orWeight` int(11) NOT NULL, `orOwnerType` int(11) NOT NULL, `orOwner` int(11) NOT NULL, `orStatus` int(11) NOT NULL, `orNumber` int(11) NOT NULL, `orName` varchar(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `1ustawienia` ( `Spawn1[0]` float NOT NULL, `Spawn1[1]` float NOT NULL, `Spawn1[2]` float NOT NULL, `Spawn2[0]` float NOT NULL, `Spawn2[1]` float NOT NULL, `Spawn2[2]` float NOT NULL, `Spawn3[0]` float NOT NULL, `Spawn3[1]` float NOT NULL, `Spawn3[2]` float NOT NULL, `Spawn_VW` int(11) NOT NULL, `Spawn_INT` int(11) NOT NULL, `AJ_X` float NOT NULL, `AJ_Y` float NOT NULL, `AJ_Z` float NOT NULL, `AJ_INT` int(11) NOT NULL, `gas1[0]` float NOT NULL, `gas1[1]` float NOT NULL, `gas1[2]` float NOT NULL, `gas2[0]` float NOT NULL, `gas2[1]` float NOT NULL, `gas2[2]` float NOT NULL, `gas3[0]` float NOT NULL, `gas3[1]` float NOT NULL, `gas3[2]` float NOT NULL, `FUEL_PRICE` float NOT NULL DEFAULT '1.5', `GAS_PRICE` float NOT NULL DEFAULT '1', `kamera[0]` float NOT NULL, `kamera[1]` float NOT NULL, `kamera[2]` float NOT NULL, `camera2[0]` float NOT NULL, `camera2[1]` float NOT NULL, `camera2[2]` float NOT NULL, `energia_price` float NOT NULL DEFAULT '2', `carspawn[0]` float NOT NULL, `carspawn[1]` float NOT NULL, `carspawn[2]` float NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin2; CREATE TABLE IF NOT EXISTS `1vcard` ( `number` int(11) NOT NULL, `Nick` varchar(32) NOT NULL, `numberex` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `1warn` ( `Type` varchar(32) NOT NULL, `Dostal` int(11) NOT NULL, `dostal_uid` int(11) NOT NULL, `Nadal` int(11) NOT NULL, `Powod` varchar(32) NOT NULL, `Rok` int(11) NOT NULL, `Miesiac` int(11) NOT NULL, `Dzien` int(11) NOT NULL, `Godzina` int(11) NOT NULL, `Minuta` int(11) NOT NULL, `Sekunda` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin2; CREATE TABLE IF NOT EXISTS `2wyplaty` ( `fob_uid` int(14) NOT NULL, `rank` int(14) NOT NULL, `cash` int(44) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
Ta ma 2 pola, id oraz data. Musisz pododawać to:
CREATE TABLE example ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, DATA VARCHAR(100) );
do wszystkich swoich tabel. Oczywiście nazwa pola nie musi być id, może być np id_nazwa_tabeli albo jeszcze inaczej.
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,