What do you think of my 'author' table ?

[terryds]

What do you think of my author table ?

 

CREATE TABLE `authors` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `gender` enum('Male','Female') NOT NULL, `email` varchar(30) NOT NULL DEFAULT '', `country` varchar(30) NOT NULL DEFAULT '', `url` varchar(20) NOT NULL DEFAULT '', `birthday` varchar(10) NOT NULL DEFAULT '', `motto` varchar(60) NOT NULL DEFAULT '', `password` char(40) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `birthday_idx` (`birthday`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8

 

Is it right tuned ? I make it as my blog cms's author table...

[justsomeguy]

I don't store dates as varchar types, but it looks fine.