--
-- Table structure for table `gang_members`
--

CREATE TABLE IF NOT EXISTS `gang_members` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `steamid` bigint(20) NOT NULL,
  `rank_id` int(11) NOT NULL,
  `gang_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `gang_members`
--

INSERT INTO `gang_members` (`id`, `steamid`, `rank_id`, `gang_id`) VALUES
(1, 76561198038010093, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `gang_ranks`
--

CREATE TABLE IF NOT EXISTS `gang_ranks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `priority` int(11) NOT NULL COMMENT 'Only ranks with more priority can act upon this rank',
  `priority_kick` int(11) NOT NULL COMMENT 'The amount and below of priority ranks they can kick',
  `priority_promote` int(11) NOT NULL COMMENT 'The amount and below of priority ranks they can promote to',
  `priority_invite` int(11) NOT NULL COMMENT 'above 0 means they can invite',
  `priority_editGang` int(11) NOT NULL COMMENT 'above 0 means they can edit the gang',
  `priority_editRanks` int(11) NOT NULL COMMENT 'The amount and below of priority ranks they can edit',
  `rank_name` varchar(255) NOT NULL COMMENT 'The name of the rank',
  `rank_initials` varchar(255) NOT NULL COMMENT 'The shortened version of the rank. E.G. [COL]',
  `gang_id` int(11) NOT NULL COMMENT 'The id of the gang this rank belongs to',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `gang_ranks`
--

INSERT INTO `gang_ranks` (`id`, `priority`, `priority_kick`, `priority_promote`, `priority_invite`, `priority_editGang`, `priority_editRanks`, `rank_name`, `rank_initials`, `gang_id`) VALUES
(1, 999, 999, 999, 999, 999, 999, 'Owner', '[V]', 1);