CREATE TABLE IF NOT EXISTS `members` ( `ID` mediumint(5) UNSIGNED NOT NULL AUTO_INCREMENT, `username` varchar(100) NOT NULL DEFAULT "", `user_password` char(40) NOT NULL DEFAULT "", PRIMARY KEY (`ID`, `username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;