users.sql database table not importing
I'm having problems importing the users.sql database table using mysql query browser and PHPMYADMIN. I ran the sql script from terminal with the following results. This may not mean much but I'm looking for a way to troubleshoot the problem.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'databases' at line 3
mysql> 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`)