Wat is hier mis mee?

beste mensen,

ik ben nog niet zo lang bezig met databases.
weet iemand wat ik hier fout heb gedaan?

CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(18) collate latin1_general_ci NOT NULL default '',
`date` decimal(25,0) NOT NULL default '0',
`color` varchar(7) collate latin1_general_ci NOT NULL default '#000000',
PRIMARY KEY (`id`),
KEY `name` (`name`,`date`),
KEY `color` (`color`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=403 ;

CREATE TABLE `msgs` (
`id` int(11) NOT NULL auto_increment,
`who` varchar(18) collate latin1_general_ci NOT NULL default '',
`color` varchar(7) collate latin1_general_ci NOT NULL default '#000000',
`msg` varchar(255) collate latin1_general_ci NOT NULL default '',
`type` enum('msg','info','logoff','logon') collate latin1_general_ci NOT NULL default 'msg',
`date` decimal(25,0) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `who` (`who`,`color`,`msg`,`type`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2967 ;

thnx