Hi
Actually there is just one change - replace TYPE with ENGINE. Like
CREATE TABLE admin ( id smallint(6) NOT NULL auto_increment, username varchar(50) NOT NULL default '', pass_word varchar(200) NOT NULL default '', registered varchar(50) NOT NULL default '', systemtime varchar(50) NOT NULL default '', PRIMARY KEY (id) ) ENGINE=MyISAM;
Best wishes, Roman