Hi, I have to do the following but I got a 'Missing value in the form'......I know it's related to the last line ENGINE=MyISAM DEFAULT CHARSET=latin1; but I couldn't remember how I have to change it....any help !!!!
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`usrnm` varchar(30) character set utf8 NOT NULL,
`password` varchar(32) character set utf8 default NULL,
`userid` varchar(32) character set utf8 default NULL,
`userlevel` tinyint(1) unsigned NOT NULL,
`email` varchar(50) character set utf8 default NULL,
`timestamp` int(11) unsigned NOT NULL,
`visible` enum('0','1') character set utf8 NOT NULL,
`gender` varchar(10) character set utf8 NOT NULL,
`avatar` varchar(255) character set utf8 NOT NULL,
`language` tinyint(2) unsigned NOT NULL,
`visits` smallint(4) unsigned NOT NULL,
`hd` tinyint(1) unsigned NOT NULL,
`hot_allowed` enum('0','1') character set utf8 NOT NULL default '0',
`uploader_registred` enum('0','1') character set utf8 NOT NULL default '0',
`music_video_registred` enum('0','1') character set utf8 NOT NULL default '0',
`wordpress_registred` enum('0','1') character set utf8 NOT NULL default '0',
PRIMARY KEY (`usrnm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;