I do get the same error when I run the query you provided, however I just downloaded the solution pack from our website and ran the query from there and there were no errors. It does look like your query is slightly different from the one I just ran. Try downloading the solution pack again to see if that will get you the correct files.
Here is the query from the solution pack I just downloaded:
CREATE TABLE `users` (
`UserID` int(11) NOT NULL auto_increment,
`UserEmail` varchar(500) default NULL,
`UserPassword` varchar(500) default NULL,
`UserFirstName` varchar(50) default NULL,
`UserLastName` varchar(50) default NULL,
`UserCity` varchar(90) default NULL,
`UserState` varchar(20) default NULL,
`UserZip` varchar(12) default NULL,
`UserEmailVerified` tinyint(1) default '0',
`UserRegistrationDate` timestamp NULL default CURRENT_TIMESTAMP,
`UserVerificationCode` varchar(20) default NULL,
`UserIP` varchar(50) default NULL,
`UserPhone` varchar(20) default NULL,
`UserFax` varchar(20) default NULL,
`UserCountry` varchar(20) default NULL,
`UserAddress` varchar(100) default NULL,
`UserAddress2` varchar(50) default NULL,
PRIMARY KEY (`UserID`)
)
Looks like this is the line that changed:
`UserRegistrationDate` timestamp NULL default ‘CURRENT_TIMESTAMP’,