Jump to content

What do you think of my 'author' table ?


terryds
 Share

Recommended Posts

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...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...