MySQL Database (Revision 2) 9/7/11

/*MySQL DB
For custom cms's and/or database pooling applications
*/

CREATE TABLE IF NOT EXISTS `users (
`id` int(8) NOT NULL AUTO_INCREMENT //Creates an eight digit, auto-id number
`user` varchar(50) NOT NULL //Username, 50 max characters
`password` varchar(40) NOT NULL
`age` int(2) NOT NULL
`gender` char(6) NOT NULL
`rank` int(1) NOT NULL
)


/*
I need to add some other functions, like ranks etc. I also need to add MD5 hashing into the db
#Adil
Links
http://i.imgur.com/v7oai.jpg
*/
//updated