Error bij tabel toevoegen.

Hey,

Ik ben vrij nieuw op gebied van SQL. Ik was aan het proberen deze tabel toe te voegen:

CREATE TABLE IF NOT EXISTS `gebruikers` (
  `id` int(5) NOT NULL auto_increment,
  `naam` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
  `wachtwoord` varchar(40) character set latin1 collate latin1_general_ci NOT NULL,
  `email` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
  `ip` varchar(15) character set latin1 collate latin1_general_ci NOT NULL default '',
  `rang` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default 'member',
  `active` varchar(3) NOT NULL default yes',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;         

Maar toen kreeg ik een error:

MySQL said:

#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 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8

Iemand enig idee?

Alvast bedankt!