MskRH18P

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
3  `username` varchar(32) NOT NULL,
4  `password` varchar(32) NOT NULL,
5  `display` varchar(150) NOT NULL,
6  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
9
10INSERT INTO `users` (`id`, `username`, `password`, `display`, `date`) VALUES
11(1, 'admin', MD5('password'), 'Administrator', '2011-05-03 12:00:38');