SQL Problems

[-Adam]

Well, Im trying to import a database that my mate gave me for my game.

I keep getting this error though.

Error

SQL query:
-- -------------------------------------------------------- -- -- Table structure for table `players` -- CREATE TABLE IF NOT EXISTS `players` ( `id` int(255) NOT NULL auto_increment, `playername` varchar(20) NOT NULL default '', `password` varchar(20) NOT NULL default '', `email` varchar(255) NOT NULL default '', `ip` varchar(15) NOT NULL default '0.0.0.0', `status` enum('Alive','Dead','Banned') NOT NULL default 'Alive', `registered` datetime NOT NULL default '0000-00-00 00:00:00', `active` int(255) NOT NULL default '0', `money` bigint(255) NOT NULL default '0', `bullets` bigint(255) NOT NULL default '0', `rank` enum('Bot','Tramp','Civilian','Paper Kid','Thief','Package Boy','Thug','Gangster','Associate','Body Guard','Enforcer','Piciotto','Hit Man','Mobster','Wise Guy','Made Man','Capo','Consigliere','Local Boss','Boss','Godfather','Don','Ny Mobster','Editor','Help Desk','Designer','Moderator','Administrator') NOT NULL default 'Tramp', `r[...]
MySQL said:
#1064 - 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 '`Fugitive` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=My' at line 63







This is the players bit. (Its got loads of players already in which ill delete)

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
`id` int(255) NOT NULL auto_increment,
`playername` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`ip` varchar(15) NOT NULL default '0.0.0.0',
`status` enum('Alive','Dead','Banned') NOT NULL default 'Alive',
`registered` datetime NOT NULL default '0000-00-00 00:00:00',
`active` int(255) NOT NULL default '0',
`money` bigint(255) NOT NULL default '0',
`bullets` bigint(255) NOT NULL default '0',
`rank` enum('Bot','Tramp','Civilian','Paper Kid','Thief','Package Boy','Thug','Gangster','Associate','Body Guard','Enforcer','Piciotto','Hit Man','Mobster','Wise Guy','Made Man','Capo','Consigliere','Local Boss','Boss','Godfather','Don','Ny Mobster','Editor','Help Desk','Designer','Moderator','Administrator') NOT NULL default 'Tramp',
`rankpos` int(255) NOT NULL default '1',
`rankpoints` int(255) NOT NULL default '0',
`bank` bigint(255) NOT NULL default '0',
`banktime` varchar(255) NOT NULL default '',
`crimechance` varchar(255) NOT NULL default '0-0-0-0-0',
`crimetime` varchar(255) NOT NULL default '',
`crimessucc` int(11) NOT NULL default '0',
`crimesfail` int(11) NOT NULL default '0',
`gtachance` varchar(255) NOT NULL default '0-0-0-0-0',
`gtatime` varchar(255) NOT NULL default '',
`gtassucc` int(11) NOT NULL default '0',
`gtasfail` int(11) NOT NULL default '0',
`btachance` varchar(255) NOT NULL default '0-0-0-0-0',
`btatime` varchar(255) NOT NULL default '',
`btassucc` int(11) NOT NULL default '0',
`btasfail` int(11) NOT NULL default '0',
`last_ext` varchar(255) NOT NULL default '',
`ext_win` int(255) NOT NULL default '0',
`ext_fail` int(255) NOT NULL default '0',
`location` enum('New Zealand','Australia','USA','England','South Africa','Cuba') NOT NULL default 'USA',
`gender` enum('Un-known','Male','Female','Pay-As-You-Go!') NOT NULL default 'Un-known',
`forumposts` int(11) NOT NULL default '0',
`image` tinytext NOT NULL,
`quote` text NOT NULL,
`safety` varchar(255) NOT NULL default '',
`family` varchar(40) NOT NULL default 'None',
`busts` int(11) NOT NULL default '0',
`fail_busts` int(255) NOT NULL default '0',
`jailed_time` varchar(255) NOT NULL default '0',
`flytime` varchar(255) NOT NULL default '',
`plane` enum('None','F4F Wildcat','F7F Tigercat','F-18C Hornet','F-14 Tomcat','Harrier') NOT NULL default 'None',
`health` tinyint(3) NOT NULL default '100',
`bartime` varchar(255) NOT NULL default '',
`bulletwait` varchar(255) NOT NULL default '',
`drugs` varchar(255) NOT NULL default '0-0-0-0',
`staff` enum('0','1') NOT NULL default '0',
`scripttime` varchar(255) NOT NULL default '',
`mission` varchar(255) NOT NULL default '1',
`missionextra` varchar(255) NOT NULL default '0',
`weapon` int(255) NOT NULL default '0',
`protection` int(255) NOT NULL default '0',
`kills` int(255) NOT NULL default '0',
`last_shot` varchar(255) NOT NULL default '',
`backfire` int(255) NOT NULL default '0',
`points` int(255) NOT NULL default '0',
`oc` enum('0','1') NOT NULL default '0',
`oc_time` varchar(255) NOT NULL default '',
`oc_succ` int(255) NOT NULL default '0',
`oc_fail` int(255) NOT NULL default '0',
`vote_time` varchar(255) NOT NULL default ''
`Fugitive` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `players`
--

*Removed*

Edited by Jamesy (Forum Moderator): Please do not post private information thanks

[Tomm]

Remove the SQL dump, it shows plaintext passwords.

[-Adam]

Not that anybody will be able to use them, plus they could be important.