ik heb een fout melding als ik mijn sql wil uploaden
PHP
Fout
SQL-query:
CREATE TABLE `users` (
`drankmax` int( 255 ) NOT NULL default '1',
`malibuupgr` int( 255 ) NOT NULL default '0',
`whiskyupgr` int( 255 ) NOT NULL default '0',
`berenburgupgr` int( 255 ) NOT NULL default '0',
`jeneverupgr` int( 255 ) NOT NULL default '0',
`feiglingupgr` int( 255 ) NOT NULL default '0',
`malibu` int( 255 ) NOT NULL default '0',
`whisky` int( 255 ) NOT NULL default '0',
`berenburg` int( 255 ) NOT NULL default '0',
`jenever` int( 255 ) NOT NULL default '0',
`feigling` int( 255 ) NOT NULL default '0',
`bier` int( 255 ) NOT NULL default '0',
`bierupgr` int( 255 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
FULLTEXT KEY `moordenaar` ( `moordenaar` )
) ENGINE = MYISAM AUTO_INCREMENT =117 DEFAULT CHARSET = latin1 COLLATE = latin1_german1_ci;
MySQL retourneerde:
#1072 - Key column 'id' doesn't exist in table
Toon Meer
alvast bedankt