-- Dumping structure for table GTAWRP.gangs
CREATE TABLE IF NOT EXISTS `gangs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `inventory` longtext DEFAULT NULL,
  `leadership_rank` int(11) NOT NULL DEFAULT 3,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

-- Dumping data for table GTAWRP.gangs: 9 rows
/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
REPLACE INTO `gangs` (`id`, `name`, `label`, `inventory`, `leadership_rank`) VALUES
	(8, 'southsidehoovers', 'South Side Hoovers', '{"cash":0,"dcash":10400000,"items":{"coke_pack":180,"cannabis":2600,"gold":0,"opium_pooch":0,"ecstacy_pooch":0,"acid_pooch":0,"weed":0,"diamond":0,"xanax_pooch":0,"meth_pack":0,"jewels":0,"rolex":0,"weed_pooch":0,"meth":0,"opium_pack":180,"dmt_pooch":0,"heroin_pooch":0,"meth_pooch":0,"coke_pooch":0,"perc_pooch":0,"coke":0}}', 3),
	(9, 'shottaz', 'Shottaz', '{"dcash":0,"items":{"xanax_pooch":0,"gold":0,"rolex":0,"meth":0,"dmt_pooch":0,"weed":0,"opium_pooch":0,"coke":0,"ecstacy_pooch":0,"diamond":0,"acid_pooch":0,"coke_pack":0,"meth_pooch":0,"heroin_pooch":0,"coke_pooch":0,"opium_pack":0,"cannabis":0,"weed_pooch":0,"jewels":0,"meth_pack":0,"perc_pooch":0},"cash":0}', 3),
	(1, 'rollin60scrip', 'Rollin 60s crip', '{"dcash":0,"items":{"xanax_pooch":0,"gold":0,"rolex":0,"meth":0,"dmt_pooch":0,"weed":0,"opium_pooch":0,"coke":0,"ecstacy_pooch":0,"diamond":0,"acid_pooch":0,"coke_pack":0,"meth_pooch":0,"heroin_pooch":0,"coke_pooch":0,"opium_pack":0,"cannabis":0,"weed_pooch":0,"jewels":0,"meth_pack":0,"perc_pooch":0},"cash":0}', 4),
	(17, 'ttg', 'TTG', '{"dcash":33509000,"items":{"cannabis":5800,"heroin_pooch":60,"coke_pack":380,"meth_pack":520,"weed_pooch":200,"meth_pooch":1260,"opium_pack":500,"weed":0,"opium_pooch":480,"coke_pooch":1180},"cash":43400000}', 1),
	(18, '999', '999', '{"cash":0,"dcash":30400000,"items":{"coke_pack":540,"cannabis":4400,"gold":0,"opium_pooch":0,"ecstacy_pooch":0,"acid_pooch":0,"weed":0,"diamond":0,"xanax_pooch":0,"meth_pack":420,"jewels":0,"rolex":0,"weed_pooch":20,"meth":0,"opium_pack":520,"dmt_pooch":0,"heroin_pooch":0,"meth_pooch":0,"coke_pooch":0,"perc_pooch":0,"coke":0}}', 4),
	(14, 'wndr', 'WNDR', '{"cash":180000000,"dcash":61900000,"items":{"coke_pack":1440,"cannabis":8000,"gold":0,"opium_pooch":0,"ecstacy_pooch":0,"acid_pooch":0,"weed":0,"diamond":0,"xanax_pooch":0,"meth_pack":660,"jewels":0,"rolex":0,"weed_pooch":0,"meth":0,"opium_pack":1320,"dmt_pooch":0,"heroin_pooch":0,"coke":0,"meth_pooch":0,"perc_pooch":0,"coke_pooch":0}}', 4),
	(13, 'mafia', 'Mafia', '{"dcash":7100020,"cash":0,"items":{"meth_pooch":420,"acid_pooch":40,"jewels":13,"meth_pack":160,"meth":0,"weed_pooch":140,"opium_pack":320,"coke_pack":360,"cannabis":1200,"opium_pooch":0,"coke_pooch":0}}', 4),
	(16, 'rvb', 'Red Valley Boys', '{"cash":0,"dcash":900000,"items":{"opium_pooch":0,"meth":0,"diamond":0,"perc_pooch":0,"coke_pack":80,"gold":0,"dmt_pooch":0,"acid_pooch":0,"meth_pack":80,"cannabis":800,"heroin_pooch":0,"jewels":0,"xanax_pooch":0,"opium_pack":160,"weed_pooch":0,"meth_pooch":0,"rolex":0,"ecstacy_pooch":0,"coke_pooch":0,"coke":0,"weed":0}}', 2),
	(19, 'demons', 'Demons', '{"cash":100000000,"dcash":800000,"items":{"coke_pack":140,"cannabis":0,"gold":0,"opium_pooch":0,"meth_pooch":0,"acid_pooch":0,"ecstacy_pooch":0,"weed":0,"diamond":0,"xanax_pooch":0,"meth_pack":100,"jewels":0,"weed_pooch":0,"opium_pack":40,"meth":0,"rolex":0,"dmt_pooch":0,"coke":200,"coke_pooch":0,"armour":2,"perc_pooch":0,"heroin_pooch":0}}', 3);
/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;

-- Dumping structure for table GTAWRP.gang_ranks
CREATE TABLE IF NOT EXISTS `gang_ranks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `gang_name` varchar(255) DEFAULT NULL,
  `ranking` int(11) DEFAULT NULL,
  `vehicles` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;

-- Dumping data for table GTAWRP.gang_ranks: 53 rows
/*!40000 ALTER TABLE `gang_ranks` DISABLE KEYS */;
REPLACE INTO `gang_ranks` (`id`, `name`, `label`, `gang_name`, `ranking`, `vehicles`) VALUES
	(12, 'captain', 'Top Shooter', 'rollin60scrip', 2, NULL),
	(11, 'member', 'Shooter', 'rollin60scrip', 1, NULL),
	(10, 'recruit', 'Prospect', 'rollin60scrip', 0, NULL),
	(81, 'first', 'Demons', '999', 0, NULL),
	(79, 'sixth', 'Leader', '999', 5, NULL),
	(78, 'fifth', 'DrugLord', '999', 4, NULL),
	(77, 'forth', 'Shot Caller', '999', 3, NULL),
	(13, 'coleader', 'OG', 'rollin60scrip', 3, NULL),
	(14, 'secondleader', 'Shot Callers', 'rollin60scrip', 4, NULL),
	(15, 'leader', 'Boss', 'rollin60scrip', 5, NULL),
	(49, 'og', 'OG', 'mafia', 3, NULL),
	(48, 'shooter', 'TopShooter', 'mafia', 2, NULL),
	(47, 'member', 'Member', 'mafia', 1, NULL),
	(46, 'recruit', 'Recruit', 'mafia', 0, NULL),
	(21, 'recruit', 'recruit', 'otf', 0, NULL),
	(22, 'member', 'member', 'southsidehoovers', 1, NULL),
	(23, 'captain', 'Top Shooter', 'southsidehoovers', 2, NULL),
	(24, 'coleader', 'CoLeader', 'southsidehoovers', 3, NULL),
	(25, 'member', 'Member', 'demons', 2, NULL),
	(26, 'shooter', 'Shooter', 'demons', 3, NULL),
	(27, 'top shooter', 'Top Shooter', 'demons', 4, NULL),
	(28, 'og', 'OG', 'ttg', 2, NULL),
	(30, 'leader', 'Leader', 'demons', 5, NULL),
	(76, 'third', 'Thug', '999', 2, NULL),
	(75, 'second', 'Hood Rat', '999', 1, NULL),
	(74, 'member', 'Member', '999', 0, NULL),
	(73, 'member', 'Member', 'ttg', 1, NULL),
	(72, 'leader', 'Founder', 'ttg', 3, NULL),
	(50, 'coleader', 'CoLeader', 'mafia', 4, NULL),
	(52, 'leader', 'Leader', 'mafia', 5, NULL),
	(53, 'bigotf', 'Big OTF', 'southsidehoovers', 4, NULL),
	(54, 'recruit', 'Recruit', 'wndr', 0, NULL),
	(55, 'member', 'Member', 'wndr', 1, NULL),
	(56, 'shooter', 'Shooter', 'wndr', 2, NULL),
	(57, 'tops', 'TopShooter', 'wndr', 3, NULL),
	(58, 'coleader', 'CoLeader', 'wndr', 4, NULL),
	(59, 'leader', 'Founder', 'wndr', 5, NULL),
	(60, 'young', 'Youngins', 'rvb', 0, NULL),
	(61, 'goon', 'Goons', 'rvb', 1, NULL),
	(62, 'og', 'OG', 'rvb', 2, NULL),
	(63, 'shooter', 'Shooter', 'rvb', 8, NULL),
	(64, 'topshooter', 'TopShooter', 'rvb', 4, NULL),
	(65, 'shotcaller', 'ShotCaller', 'rvb', 5, NULL),
	(66, 'coowner', 'Co-Owner', 'rvb', 6, NULL),
	(67, 'dog', 'TopDog', 'rvb', 7, NULL),
	(68, 'recruit', 'Recruit', 'boyz', 0, NULL),
	(69, 'shooter', 'Shooter', 'boyz', 1, NULL),
	(70, 'co', 'CoOwner', 'boyz', 2, NULL),
	(71, 'owner', 'Founder', 'rvb', 9, NULL),
	(82, 'second', 'Top Demons', 'dt', 1, NULL),
	(83, 'third', 'OG Demons', 'dt', 2, NULL),
	(84, 'forth', 'Devil', 'dt', 3, NULL),
	(85, 'trial', 'Trial', 'demons', 1, NULL);
/*!40000 ALTER TABLE `gang_ranks` ENABLE KEYS */;