Beste mensen,
Ik probeer een tabel aan te maken maar krijg een fout melding:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, `signup_date` DATETIME NOT NULL, `last_login` DATETIME NOT NULL, `acti' at line 1
Tabel is:
CREATE TABLE `users` (
`userid` int(25) NOT NULL auto_increment,
`first_name` varchar(25) NOT NULL default '',
`last_name` varchar(25) NOT NULL default '',
`email_address` varchar(25) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`decrypted_password` varchar(255) NOT NULL default '',
`info` text NOT NULL,
`user_level` enum('0','1','2','3') NOT NULL default '0',
`signup_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`activated` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
Wat is er fout dan?
groetjes Rieksie
680 views