--
-- Table structure for table `airport`
--

DROP TABLE IF EXISTS `airport`;
CREATE TABLE `airport` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `travel_prices` varchar(100) NOT NULL default '100-100-100-100-100-100',
  `profit` varchar(100) NOT NULL default '0-0-0-0-0-0',
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;



DROP TABLE IF EXISTS `attempts`;
CREATE TABLE `attempts` (
  `id` int(11) NOT NULL auto_increment,
  `username` char(40) NOT NULL default '',
  `target` char(40) NOT NULL default '',
  `outcome` enum('Dead','Survived') NOT NULL default 'Dead',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2586 DEFAULT CHARSET=latin1;


--
-- Table structure for table `auctions`
--

DROP TABLE IF EXISTS `auctions`;
CREATE TABLE `auctions` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `min_starting` int(11) NOT NULL default '0',
  `current_bid` int(11) NOT NULL default '0',
  `winning` varchar(40) NOT NULL default '',
  `winning_bid` int(11) NOT NULL default '0',
  `item_type` varchar(100) NOT NULL default '',
  `time` varchar(100) NOT NULL default '',
  `item_id` varchar(100) NOT NULL default '',
  `an` enum('0','1') NOT NULL default '0',
  `pvt` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1735 DEFAULT CHARSET=latin1;


--
-- Table structure for table `ban`
--

DROP TABLE IF EXISTS `ban`;
CREATE TABLE `ban` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `by` varchar(40) NOT NULL default '',
  `type` enum('0','1') NOT NULL default '0',
  `reason` text NOT NULL,
  `length` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=214 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bank`
--

DROP TABLE IF EXISTS `bank`;
CREATE TABLE `bank` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `send_intrest` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bank2`
--

DROP TABLE IF EXISTS `bank2`;
CREATE TABLE `bank2` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `send_intrest` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bar`
--

DROP TABLE IF EXISTS `bar`;
CREATE TABLE `bar` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bf`
--

DROP TABLE IF EXISTS `bf`;
CREATE TABLE `bf` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `stock` int(100) NOT NULL default '0',
  `producing` enum('Yes','No') NOT NULL default 'Yes',
  `price` int(100) NOT NULL default '100',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bidders`
--

DROP TABLE IF EXISTS `bidders`;
CREATE TABLE `bidders` (
  `id` int(11) NOT NULL auto_increment,
  `bidder` char(40) NOT NULL default '',
  `amount` int(11) NOT NULL default '0',
  `auction_id` int(11) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `an` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=947 DEFAULT CHARSET=latin1;


--
-- Table structure for table `bj`
--

DROP TABLE IF EXISTS `bj`;
CREATE TABLE `bj` (
  `id` int(11) NOT NULL auto_increment,
  `bjowner` varchar(40) NOT NULL default '',
  `bjearnings` varchar(100) NOT NULL default '',
  `bjmaxbet` int(11) NOT NULL default '0',
  `bjminbet` int(11) NOT NULL default '0',
  `bjminoffer` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Table structure for table `buisnesses`
--

DROP TABLE IF EXISTS `buisnesses`;
CREATE TABLE `buisnesses` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `size` varchar(40) NOT NULL default '',
  `profit` varchar(100) NOT NULL default '',
  `slogan` varchar(100) NOT NULL default '',
  `logo` varchar(100) NOT NULL default '',
  `color1` varchar(100) NOT NULL default '',
  `color2` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


--
-- Table structure for table `car_sell`
--

DROP TABLE IF EXISTS `car_sell`;
CREATE TABLE `car_sell` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `car_id` int(50) NOT NULL default '0',
  `price` int(50) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `car_type` char(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=930 DEFAULT CHARSET=latin1;


--
-- Table structure for table `carraces`
--

DROP TABLE IF EXISTS `carraces`;
CREATE TABLE `carraces` (
  `id` int(11) NOT NULL auto_increment,
  `person1` varchar(40) NOT NULL default '',
  `car1` int(11) NOT NULL default '0',
  `person2` int(11) NOT NULL default '0',
  `car2` varchar(40) NOT NULL default '',
  `person3` int(11) NOT NULL default '0',
  `car3` varchar(100) NOT NULL default '',
  `person4` varchar(100) NOT NULL default '',
  `car4` varchar(100) NOT NULL default '',
  `entryfee` int(11) NOT NULL default '0',
  `pot` int(11) NOT NULL default '0',
  `location` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=569 DEFAULT CHARSET=latin1;

--
-- Table structure for table `casinos`
--

DROP TABLE IF EXISTS `casinos`;
CREATE TABLE `casinos` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `casino` enum('Slots','Roulette','RPS','Race','Keno','bj','Dice') NOT NULL default 'Slots',
  `profit` varchar(100) NOT NULL default '',
  `max` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  PRIMARY KEY  (`id`),
  KEY `location` (`location`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;



--
-- Table structure for table `crews`
--

DROP TABLE IF EXISTS `crews`;
CREATE TABLE `crews` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `name` varchar(60) NOT NULL default '',
  `quote` text NOT NULL,
  `music` tinytext NOT NULL,
  `picture` tinytext NOT NULL,
  `recruiting` enum('1','2') NOT NULL default '1',
  `rhm` varchar(40) NOT NULL default '0',
  `successor` varchar(40) NOT NULL default '',
  `bank` int(50) NOT NULL default '0',
  `income` varchar(100) NOT NULL default '0-0-0',
  `payout` varchar(100) NOT NULL default '',
  `bullets` int(11) NOT NULL default '0',
  `cm1` varchar(40) NOT NULL default '',
  `cm2` varchar(40) NOT NULL default '',
  `cm3` varchar(40) NOT NULL default '',
  `cm4` varchar(40) NOT NULL default '',
  `cm5` varchar(40) NOT NULL default '',
  `cm6` varchar(40) NOT NULL default '',
  `cm7` varchar(40) NOT NULL default '',
  `cm8` varchar(40) NOT NULL default '',
  `points` int(40) NOT NULL default '0',
  `hit1` varchar(40) NOT NULL default '',
  `hit2` varchar(40) NOT NULL default '',
  `hit3` varchar(40) NOT NULL default '',
  `hit4` varchar(40) NOT NULL default '',
  `hit5` varchar(40) NOT NULL default '',
  `rec1` varchar(40) NOT NULL default '',
  `rec2` varchar(40) NOT NULL default '',
  `tres1` varchar(40) NOT NULL default '',
  `tres2` varchar(40) NOT NULL default '',
  `tres3` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `cm1` (`cm1`,`cm2`,`cm3`,`cm4`,`cm5`,`cm6`,`cm7`,`cm8`),
  FULLTEXT KEY `hit1` (`hit1`,`hit2`,`hit3`,`hit4`,`hit5`,`rec1`,`rec2`,`tres1`,`tres2`,`tres3`)
) ENGINE=MyISAM AUTO_INCREMENT=158 DEFAULT CHARSET=latin1;


--
-- Table structure for table `dead`
--

DROP TABLE IF EXISTS `dead`;
CREATE TABLE `dead` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `rank` varchar(40) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Table structure for table `dealership`
--

DROP TABLE IF EXISTS `dealership`;
CREATE TABLE `dealership` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;


--
-- Table structure for table `donaters`
--

DROP TABLE IF EXISTS `donaters`;
CREATE TABLE `donaters` (
  `donater_id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `donater_pass` varchar(40) NOT NULL default '',
  `amount` int(50) NOT NULL default '0',
  `package` enum('None','1','2','3','4') NOT NULL default 'None',
  `on` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`donater_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


--
-- Table structure for table `enemies`
--

DROP TABLE IF EXISTS `enemies`;
CREATE TABLE `enemies` (
  `id` int(11) NOT NULL auto_increment,
  `username` char(40) NOT NULL default '',
  `person` char(40) NOT NULL default '',
  `type` enum('enemie','Blocked') NOT NULL default 'enemie',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=329 DEFAULT CHARSET=latin1;


--
-- Table structure for table `fens`
--

DROP TABLE IF EXISTS `fens`;
CREATE TABLE `fens` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(60) NOT NULL default '',
  `activated` enum('0','1') NOT NULL default '0',
  `money` varchar(100) NOT NULL default '100',
  `online` varchar(100) NOT NULL default '',
  `crimechance` varchar(100) NOT NULL default '0-0-0-0-0-0-0',
  `lastcrime` varchar(100) NOT NULL default '',
  `rankpoints` varchar(100) NOT NULL default '0',
  `userlevel` enum('0','1','2') NOT NULL default '0',
  `lasttop` varchar(100) NOT NULL default '',
  `status` enum('Alive','Dead','Banned') NOT NULL default 'Alive',
  `regged` datetime NOT NULL default '0000-00-00 00:00:00',
  `rank` enum('Tramp','Paper Kid','Thief','Robber','Gangster','Associate','Piciotto','Made Man','Capo','Consigliere','Underboss','Druglord','Godfather','Head Mod','God','TestRanks') NOT NULL default 'Tramp',
  `layout` varchar(100) NOT NULL default '17',
  `email` varchar(100) NOT NULL default '',
  `quote` text NOT NULL,
  `image` varchar(100) NOT NULL default 'images/default.jpg',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `bullets` int(11) NOT NULL default '0',
  `gtachance` varchar(100) NOT NULL default '0-0-0',
  `lastgta` varchar(100) NOT NULL default '',
  `lasttravel` varchar(100) NOT NULL default '',
  `bank` int(40) NOT NULL default '0',
  `banktime` varchar(100) NOT NULL default '',
  `last_race` varchar(100) NOT NULL default '',
  `street` enum('0','1') NOT NULL default '0',
  `music` mediumtext NOT NULL,
  `crew` varchar(60) NOT NULL default '0',
  `get_away_time` varchar(100) NOT NULL default '',
  `get_away` enum('0','1') NOT NULL default '0',
  `health` int(3) NOT NULL default '100',
  `energy` int(3) NOT NULL default '100',
  `last_ext` varchar(100) NOT NULL default '',
  `lasttran` varchar(100) NOT NULL default '',
  `drugprices` varchar(100) NOT NULL default '0-0-0-0-0',
  `drugs` varchar(100) NOT NULL default '0-0-0-0-0',
  `l_ip` varchar(15) NOT NULL default '127.0.0.1',
  `r_ip` varchar(15) NOT NULL default '',
  `crew_invite` int(11) NOT NULL default '0',
  `referral` int(11) NOT NULL default '0',
  `weapon` enum('None','Sig Sauer P229','Jackhammer automatic shotgun','Heckler und Koch MP-5k','FN SCAR','Browning M2HB') NOT NULL default 'None',
  `mission` int(11) NOT NULL default '1',
  `points` int(11) NOT NULL default '0',
  `lpv` varchar(32) NOT NULL default '',
  `page` varchar(10) NOT NULL default '',
  `editor` enum('0','1') NOT NULL default '0',
  `helper` enum('0','1') NOT NULL default '0',
  `food_chance` varchar(100) NOT NULL default '0-0-0',
  `last_food` varchar(100) NOT NULL default '',
  `last_order` varchar(100) NOT NULL default '',
  `freinds` varchar(40) NOT NULL default 'None',
  `protection` enum('None','Doberman','Body Guard','Armoured Car','House','Safehouse') NOT NULL default 'None',
  `plane` enum('None','Fokker','Boeing 777','LV-AZF','PR-GOC','F-HSUN') NOT NULL default 'None',
  `married` varchar(100) NOT NULL default '0',
  `oc` enum('0','1') NOT NULL default '0',
  `last_oc` varchar(100) NOT NULL default '',
  `atm` enum('False','True') NOT NULL default 'False',
  `last_bank` varchar(100) NOT NULL default '',
  `last_attempted` varchar(100) NOT NULL default '',
  `last_kill` varchar(100) NOT NULL default '',
  `ver_code` varchar(20) NOT NULL default '456',
  `last_script_check` varchar(100) NOT NULL default '',
  `global` enum('0','1') NOT NULL default '0',
  `poll` varchar(100) NOT NULL default '',
  `clicks` int(11) NOT NULL default '0',
  `click_rate` varchar(100) NOT NULL default '',
  `tut` enum('0','1') NOT NULL default '0',
  `drugs_from` varchar(40) NOT NULL default '',
  `total_drugs_mission` int(11) NOT NULL default '0',
  `city` enum('Cambridgeshire','Hull','Leeds','Leicester','Liverpool','London','Chiba','Fujiyoshida','Kawasaki','Sapporo','Yokohama','Nagoya','New York','Arizona','Texas','Utah','Vermont','Washington DC','Alberton','Benoni','Cape Town','Carltonville','East London','Johannesburg','Acapulco','Aguascalientes','Lake Chapala','San Carlos','Monterrey','Tuxtla') NOT NULL default 'Cambridgeshire',
  `notes` text NOT NULL,
  `last_chase` varchar(100) NOT NULL default '',
  `choice` varchar(40) NOT NULL default '0',
  `bar` enum('1','2') NOT NULL default '1',
  `backfire` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=100847 DEFAULT CHARSET=latin1;

--
-- Table structure for table `friends`
--

DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `id` int(11) NOT NULL auto_increment,
  `username` char(40) NOT NULL default '',
  `person` char(40) NOT NULL default '',
  `type` enum('Friend','Blocked') NOT NULL default 'Friend',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1427 DEFAULT CHARSET=latin1;


--
-- Table structure for table `garage`
--

DROP TABLE IF EXISTS `garage`;
CREATE TABLE `garage` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `car` varchar(100) NOT NULL default '',
  `damage` varchar(100) NOT NULL default '',
  `origion` varchar(100) NOT NULL default '',
  `location` varchar(100) NOT NULL default '',
  `upgrades` varchar(100) NOT NULL default '0-0-0-0-0-0-0-0',
  `status` enum('0','1','2','3','4') NOT NULL default '0',
  `worth` int(32) NOT NULL default '0',
  `shiptime` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11286 DEFAULT CHARSET=latin1;


--
-- Table structure for table `get_away`
--

DROP TABLE IF EXISTS `get_away`;
CREATE TABLE `get_away` (
  `id` int(11) NOT NULL auto_increment,
  `leader` char(40) NOT NULL default '',
  `person` char(40) NOT NULL default '',
  `weapon` enum('None','Sig Sauer P229','Jackhammer automatic shotgun','Heckler und Koch MP-5k','Browning M2HB') NOT NULL default 'None',
  `car` int(50) NOT NULL default '0',
  `share` enum('1','2') NOT NULL default '1',
  `person_ready` char(40) NOT NULL default '',
  `invite_get` char(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=168 DEFAULT CHARSET=latin1;

--
-- Table structure for table `hitlist`
--

DROP TABLE IF EXISTS `hitlist`;
CREATE TABLE `hitlist` (
  `id` int(32) NOT NULL auto_increment,
  `paid` varchar(32) NOT NULL default '',
  `target` varchar(32) NOT NULL default '',
  `reason` varchar(120) NOT NULL default '',
  `amount` int(32) NOT NULL default '0',
  `anonymous` enum('1','2') NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1765 DEFAULT CHARSET=latin1;


--
-- Table structure for table `inbox`
--

DROP TABLE IF EXISTS `inbox`;
CREATE TABLE `inbox` (
  `id` int(11) NOT NULL auto_increment,
  `to` varchar(40) NOT NULL default '',
  `from` varchar(40) NOT NULL default '',
  `message` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `read` enum('0','1') NOT NULL default '0',
  `saved` int(2) NOT NULL default '0',
  `event_id` int(11) NOT NULL default '0',
  `witness` enum('0','1') NOT NULL default '0',
  `witness_per` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25519 DEFAULT CHARSET=latin1;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `item` varchar(100) NOT NULL default '',
  `value` int(11) NOT NULL default '0',
  `owner` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17913 DEFAULT CHARSET=latin1;

--
-- Table structure for table `jail`
--

DROP TABLE IF EXISTS `jail`;
CREATE TABLE `jail` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `time_left` varchar(100) NOT NULL default '',
  `reason` varchar(100) NOT NULL default '',
  `bust_able` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=75796 DEFAULT CHARSET=latin1;


--
-- Table structure for table `kill_chart`
--

DROP TABLE IF EXISTS `kill_chart`;
CREATE TABLE `kill_chart` (
  `id` int(11) NOT NULL auto_increment,
  `target` varchar(128) NOT NULL default '',
  `username` varchar(128) NOT NULL default '',
  `bullets` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=latin1;


--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs` (
  `id` int(10) NOT NULL auto_increment,
  `who` varchar(40) NOT NULL default '',
  `action` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;


--
-- Table structure for table `lotto`
--

DROP TABLE IF EXISTS `lotto`;
CREATE TABLE `lotto` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `lotto_info`
--

DROP TABLE IF EXISTS `lotto_info`;
CREATE TABLE `lotto_info` (
  `id` int(11) NOT NULL auto_increment,
  `price` int(11) NOT NULL default '0',
  `time_to` int(100) NOT NULL default '0',
  `jackpot` int(100) NOT NULL default '0',
  `lotto_num` int(50) NOT NULL default '0',
  `winning_ticket` int(50) NOT NULL default '0',
  `winner` char(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


--
-- Table structure for table `married`
--

DROP TABLE IF EXISTS `married`;
CREATE TABLE `married` (
  `id` int(32) NOT NULL auto_increment,
  `starter` varchar(100) NOT NULL default '',
  `other` varchar(100) NOT NULL default '',
  `done` enum('0','1') NOT NULL default '0',
  `ring` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;


--
-- Table structure for table `matches`
--

DROP TABLE IF EXISTS `matches`;
CREATE TABLE `matches` (
  `id` int(11) NOT NULL auto_increment,
  `username` char(40) NOT NULL default '',
  `bet` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1813 DEFAULT CHARSET=latin1;


--
-- Table structure for table `oc`
--

DROP TABLE IF EXISTS `oc`;
CREATE TABLE `oc` (
  `id` int(11) NOT NULL auto_increment,
  `leader` varchar(40) NOT NULL default '',
  `we` varchar(40) NOT NULL default '',
  `ee` varchar(40) NOT NULL default '',
  `driver` varchar(40) NOT NULL default '',
  `weapons` varchar(100) NOT NULL default '0-0-0-0-0',
  `explosives` varchar(100) NOT NULL default '0-0-0-0-0',
  `car` int(11) NOT NULL default '0',
  `we_inv` varchar(40) NOT NULL default '0',
  `ee_inv` varchar(40) NOT NULL default '0',
  `driver_inv` varchar(40) NOT NULL default '0',
  `share` enum('1','2') NOT NULL default '1',
  `we_ready` varchar(10) NOT NULL default '',
  `ee_ready` varchar(10) NOT NULL default '',
  `driver_ready` varchar(10) NOT NULL default '',
  `location` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1101 DEFAULT CHARSET=latin1;


--
-- Table structure for table `offers`
--

DROP TABLE IF EXISTS `offers`;
CREATE TABLE `offers` (
  `id` int(11) NOT NULL default '0',
  `username` varchar(40) NOT NULL default '',
  `owner` varchar(40) NOT NULL default '',
  `offer` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `casino` enum('Blackjack') NOT NULL default 'Blackjack',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `paper`
--

DROP TABLE IF EXISTS `paper`;
CREATE TABLE `paper` (
  `id` int(11) NOT NULL auto_increment,
  `edition` int(11) NOT NULL default '0',
  `news` text NOT NULL,
  `title` varchar(100) NOT NULL default '',
  `by` varchar(40) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `align` enum('Left','Right') NOT NULL default 'Left',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;


--
-- Table structure for table `points`
--

DROP TABLE IF EXISTS `points`;
CREATE TABLE `points` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `send_intrest` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;


--
-- Table structure for table `points2`
--

DROP TABLE IF EXISTS `points2`;
CREATE TABLE `points2` (
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;


--
-- Table structure for table `pointstransfers`
--

DROP TABLE IF EXISTS `pointstransfers`;
CREATE TABLE `pointstransfers` (
  `id` int(11) NOT NULL auto_increment,
  `to` char(40) NOT NULL default '',
  `from` char(40) NOT NULL default '',
  `amount` int(100) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=656 DEFAULT CHARSET=latin1;




--
-- Table structure for table `polls`
--

DROP TABLE IF EXISTS `polls`;
CREATE TABLE `polls` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `op1` varchar(40) NOT NULL default '',
  `op2` varchar(40) NOT NULL default '',
  `op3` varchar(40) NOT NULL default '',
  `op4` varchar(40) NOT NULL default '',
  `op5` varchar(40) NOT NULL default '',
  `v1` int(6) NOT NULL default '0',
  `v2` int(6) NOT NULL default '0',
  `v3` int(6) NOT NULL default '0',
  `v4` int(6) NOT NULL default '0',
  `v5` int(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `pts`
--

DROP TABLE IF EXISTS `pts`;
CREATE TABLE `pts` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `send_intrest` int(11) NOT NULL default '0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


--
-- Table structure for table `replys`
--

DROP TABLE IF EXISTS `replys`;
CREATE TABLE `replys` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `text` text NOT NULL,
  `forum` enum('main','crew','ooc','classifieds','main1','cw92','cw93','cw94','cw95','c1','c1','c3','c4','c5','c6','c7','c8','c9','c10','c11','c12','c13','c14','c15','c16','c17','c18','c19','c20','c21') NOT NULL default 'main',
  `idto` varchar(100) NOT NULL default '',
  `made` datetime NOT NULL default '0000-00-00 00:00:00',
  `crew` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=890 DEFAULT CHARSET=latin1;

--
-- Table structure for table `rest`
--

DROP TABLE IF EXISTS `rest`;
CREATE TABLE `rest` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(40) NOT NULL default '',
  `prices` varchar(100) NOT NULL default '0-0-0-0-0-0-0-0-0',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;


--
-- Table structure for table `safe`
--

DROP TABLE IF EXISTS `safe`;
CREATE TABLE `safe` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `time` varchar(100) NOT NULL default '',
  `location` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=218 DEFAULT CHARSET=latin1;

--
-- Table structure for table `search`
--

DROP TABLE IF EXISTS `search`;
CREATE TABLE `search` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `target` varchar(40) NOT NULL default '',
  `time` varchar(100) NOT NULL default '',
  `status` enum('0','1','2') NOT NULL default '0',
  `location` varchar(100) NOT NULL default '',
  `expired` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2320 DEFAULT CHARSET=latin1;


--
-- Table structure for table `shop`
--

DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
  `id` int(11) NOT NULL auto_increment,
  `owner` char(40) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `profit` int(40) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;


--
-- Table structure for table `site_stats`
--

DROP TABLE IF EXISTS `site_stats`;
CREATE TABLE `site_stats` (
  `id` int(11) NOT NULL auto_increment,
  `online` int(11) NOT NULL default '0',
  `CS` enum('0','1') NOT NULL default '0',
  `soffer` enum('0','1') NOT NULL default '0',
  `bullets` varchar(100) NOT NULL default '',
  `terr` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


--
-- Table structure for table `street`
--

DROP TABLE IF EXISTS `street`;
CREATE TABLE `street` (
  `id` int(11) NOT NULL auto_increment,
  `leader` varchar(40) NOT NULL default '',
  `leader_car` varchar(40) NOT NULL default '',
  `prize` enum('Car','Money') NOT NULL default 'Car',
  `prize_win` int(11) NOT NULL default '0',
  `op_car` int(11) NOT NULL default '0',
  `op_ready` varchar(10) NOT NULL default '',
  `op_username` varchar(40) NOT NULL default '',
  `op_invite` varchar(40) NOT NULL default '',
  `location` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=631 DEFAULT CHARSET=latin1;


--
-- Table structure for table `swiss`
--

DROP TABLE IF EXISTS `swiss`;
CREATE TABLE `swiss` (
  `id` int(32) NOT NULL auto_increment,
  `account` int(32) NOT NULL default '0',
  `pin` int(32) NOT NULL default '0',
  `money` int(32) NOT NULL default '0',
  `username` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=760 DEFAULT CHARSET=latin1;

--
-- Table structure for table `ticket`
--

DROP TABLE IF EXISTS `ticket`;
CREATE TABLE `ticket` (
  `id` int(32) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `answer` varchar(250) NOT NULL default '',
  `open` int(32) NOT NULL default '0',
  `started` varchar(100) NOT NULL default '',
  `bug` enum('0','1') NOT NULL default '0',
  `on` datetime NOT NULL default '0000-00-00 00:00:00',
  `answered_by` varchar(40) NOT NULL default '0',
  `status` enum('Pending','Fixed') NOT NULL default 'Pending',
  `cat` enum('Crimes','Casinos','Money','Street Races','OC','Getaway','Other') NOT NULL default 'Crimes',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=479 DEFAULT CHARSET=latin1;

--
-- Table structure for table `topics`
--

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `topictext` text NOT NULL,
  `forum` enum('main','crew','ooc','classifieds','main1','cw92','cw93','cw94','cw95','c1','c1','c3','c4','c5','c6','c7','c8','c9','c10','c11','c12','c13','c14','c15','c16','c17','c18','c19','c20','c21') NOT NULL default 'main',
  `locked` enum('0','1') NOT NULL default '0',
  `sticky` enum('0','1') NOT NULL default '0',
  `lastreply` varchar(100) NOT NULL default '',
  `made` datetime NOT NULL default '0000-00-00 00:00:00',
  `crew` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3499 DEFAULT CHARSET=latin1;

--
-- Table structure for table `transfers`
--

DROP TABLE IF EXISTS `transfers`;
CREATE TABLE `transfers` (
  `id` int(11) NOT NULL auto_increment,
  `to` char(40) NOT NULL default '',
  `from` char(40) NOT NULL default '',
  `amount` int(100) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=latin1;


--
-- Table structure for table `turf`
--

DROP TABLE IF EXISTS `turf`;
CREATE TABLE `turf` (
  `id` int(11) NOT NULL auto_increment,
  `location` char(40) NOT NULL default '',
  `owner` char(60) NOT NULL default '',
  `profit` int(11) NOT NULL default '0',
  `damage` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=latin1;


--
-- Table structure for table `updates`
--

DROP TABLE IF EXISTS `updates`;
CREATE TABLE `updates` (
  `id` int(32) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `update` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;


--
-- Table structure for table `user_info`
--

DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `crimes` int(100) NOT NULL default '0',
  `gtas` int(100) NOT NULL default '0',
  `busts` int(100) NOT NULL default '0',
  `get_aways` int(11) NOT NULL default '0',
  `food_crimes` int(40) NOT NULL default '0',
  `ocs` int(11) NOT NULL default '0',
  `kill_skill` decimal(4,2) NOT NULL default '0.00',
  `wl` varchar(40) NOT NULL default '0:0',
  `exp` int(3) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `last_train` varchar(100) NOT NULL default '',
  `jewl` varchar(40) NOT NULL default '',
  `foot` varchar(40) NOT NULL default '',
  `jail_able` enum('0','1') NOT NULL default '0',
  `last_bribe` varchar(100) NOT NULL default '',
  `jail_untill` varchar(100) NOT NULL default '',
  `lang` enum('English','Dutch') NOT NULL default 'English',
  `respect` int(11) NOT NULL default '0',
  `respect_rec` varchar(11) NOT NULL default '0',
  `last_respect` varchar(100) NOT NULL default '',
  `mem_gym` enum('0','1') NOT NULL default '0',
  `dealing` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=287 DEFAULT CHARSET=latin1;


--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(60) NOT NULL default '',
  `activated` enum('0','1') NOT NULL default '0',
  `money` varchar(100) NOT NULL default '100',
  `online` varchar(100) NOT NULL default '',
  `crimechance` varchar(100) NOT NULL default '0-0-0-0-0-0-0',
  `lastcrime` varchar(100) NOT NULL default '',
  `rankpoints` varchar(100) NOT NULL default '0',
  `userlevel` enum('0','1','2') NOT NULL default '0',
  `lasttop` varchar(100) NOT NULL default '',
  `status` enum('Alive','Dead','Banned') NOT NULL default 'Alive',
  `regged` datetime NOT NULL default '0000-00-00 00:00:00',
  `rank` enum('Tramp','Thief','Hooligan','Criminal','Gangster','Boss','Supreme Boss','Don','Legendary Don','Moderator','Head Moderator','Admin') NOT NULL default 'Tramp',
  `layout` varchar(100) NOT NULL default '17',
  `email` varchar(100) NOT NULL default '',
  `quote` text NOT NULL,
  `image` varchar(100) NOT NULL default 'images/default.jpg',
  `forumpic` varchar(100) NOT NULL default '',
  `forumquote` varchar(100) NOT NULL default '',
  `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
  `bullets` int(11) NOT NULL default '0',
  `gtachance` varchar(100) NOT NULL default '0-0-0',
  `lastgta` varchar(100) NOT NULL default '',
  `lasttravel` varchar(100) NOT NULL default '',
  `bank` int(40) NOT NULL default '0',
  `banktime` varchar(100) NOT NULL default '',
  `last_race` varchar(100) NOT NULL default '',
  `street` enum('0','1') NOT NULL default '0',
  `music` mediumtext NOT NULL,
  `crew` varchar(60) NOT NULL default '0',
  `crewappl` int(11) NOT NULL default '0',
  `get_away_time` varchar(100) NOT NULL default '',
  `get_away` enum('0','1') NOT NULL default '0',
  `health` int(3) NOT NULL default '100',
  `energy` int(3) NOT NULL default '100',
  `last_ext` varchar(100) NOT NULL default '',
  `lasttran` varchar(100) NOT NULL default '',
  `drugprices` varchar(100) NOT NULL default '0-0-0-0-0',
  `drugs` varchar(100) NOT NULL default '0-0-0-0-0',
  `l_ip` varchar(15) NOT NULL default '127.0.0.1',
  `r_ip` varchar(15) NOT NULL default '',
  `crew_invite` int(11) NOT NULL default '0',
  `referral` int(11) NOT NULL default '0',
  `weapon` enum('None','Walmart Pistol','Semi Automatic','Sawn Off Shotgun','Sniper Rifle','Sub Machine Gun','LMG') NOT NULL default 'None',
  `mission` int(11) NOT NULL default '1',
  `points` int(11) NOT NULL default '0',
  `lpv` varchar(32) NOT NULL default '',
  `page` varchar(10) NOT NULL default '',
  `editor` enum('0','1') NOT NULL default '0',
  `helper` enum('0','1') NOT NULL default '0',
  `food_chance` varchar(100) NOT NULL default '0-0-0',
  `last_food` varchar(100) NOT NULL default '',
  `last_order` varchar(100) NOT NULL default '',
  `freinds` varchar(40) NOT NULL default 'None',
  `protection` enum('None','Pit Bull Terrier','Body Guard','Armoured Car','House','Safehouse','Armoured Safe House') NOT NULL default 'None',
  `plane` enum('None','Fokker','Boeing 777','LV-AZF','PR-GOC','F-HSUN') NOT NULL default 'None',
  `married` varchar(100) NOT NULL default '0',
  `oc` enum('0','1') NOT NULL default '0',
  `last_oc` varchar(100) NOT NULL default '',
  `atm` enum('False','True') NOT NULL default 'False',
  `last_bank` varchar(100) NOT NULL default '',
  `last_attempted` varchar(100) NOT NULL default '',
  `last_kill` varchar(100) NOT NULL default '',
  `ver_code` varchar(20) NOT NULL default '456',
  `last_script_check` varchar(100) NOT NULL default '',
  `global` enum('0','1') NOT NULL default '0',
  `poll` varchar(100) NOT NULL default '',
  `clicks` int(11) NOT NULL default '0',
  `click_rate` varchar(100) NOT NULL default '',
  `tut` enum('0','1') NOT NULL default '0',
  `drugs_from` varchar(40) NOT NULL default '',
  `total_drugs_mission` int(11) NOT NULL default '0',
  `city` enum('Cambridgeshire','Hull','Leeds','Leicester','Liverpool','London','Chiba','Fujiyoshida','Kawasaki','Sapporo','Yokohama','Nagoya','New York','Arizona','Texas','Utah','Vermont','Washington DC','Alberton','Benoni','Cape Town','Carltonville','East London','Johannesburg','Acapulco','Aguascalientes','Lake Chapala','San Carlos','Monterrey','Tuxtla') NOT NULL default 'Cambridgeshire',
  `notes` text NOT NULL,
  `last_chase` varchar(100) NOT NULL default '',
  `choice` varchar(40) NOT NULL default '0',
  `bar` enum('1','2') NOT NULL default '1',
  `backfire` enum('On','Off') NOT NULL default 'Off',
  `stock` varchar(200) NOT NULL default '0',
  `donate` enum('1','2') NOT NULL default '1',
  `bj` varchar(100) NOT NULL default '',
  `poker` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_idx` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=latin1;


<!-- www.000webhost.com Analytics Code -->
<script type="text/javascript" src="http://analytics.hosting24.com/count.php"></script>
<noscript><a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/count.php" alt="web hosting" /></a></noscript>
<!-- End Of Code -->