SQL code is scary
Don’t mess around with it!
CREATE TABLE `wp_creativeawesome_users` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_login` varchar(60) NOT NULL DEFAULT '',
`user_pass` varchar(64) NOT NULL DEFAULT '',
`user_nicename` varchar(50) NOT NULL DEFAULT '',
`user_email` varchar(100) NOT NULL DEFAULT '',
`user_url` varchar(100) NOT NULL DEFAULT '',
`user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL DEFAULT '',
`user_status` int(11) NOT NULL DEFAULT '0',
`display_name` varchar(250) NOT NULL DEFAULT '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `wp_creativeawesome_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url
`user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
(1, 'brad', '$P$B7K3fZtrgrVvnyfr.hVnIStIMpF9py0', 'brad', '[email protected]', '', '2012-09-08 01:42:14', '', 0,
'brad');
Friday, January 18, 13