-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:40 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `bmcforu_transfer`
--

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

--
-- Table structure for table `ranks`
--

CREATE TABLE IF NOT EXISTS `ranks` (
  `rankid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `minposts` int(10) unsigned NOT NULL DEFAULT '0',
  `ranklevel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `rankimg` mediumtext NOT NULL,
  `usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `stack` smallint(5) unsigned NOT NULL DEFAULT '0',
  `display` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rankid`),
  KEY `grouprank` (`usergroupid`,`minposts`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `ranks`
--

INSERT INTO `ranks` (`rankid`, `minposts`, `ranklevel`, `rankimg`, `usergroupid`, `type`, `stack`, `display`) VALUES
(8, 0, 1, 'images/usertitles/Platinum.png', 27, 0, 1, 0),
(9, 0, 1, 'images/usertitles/Silver.png', 9, 0, 1, 0),
(10, 0, 1, 'images/usertitles/Gold.png', 10, 0, 1, 0),
(11, 0, 1, 'images/usertitles/Angel.png', 66, 0, 1, 0),
(12, 0, 1, 'images/usertitles/MST.png', 60, 0, 1, 0),
(13, 0, 1, 'images/usertitles/Mod.png', 7, 0, 1, 0),
(14, 0, 1, 'images/usertitles/SuperMod.png', 71, 0, 1, 0),
(15, 0, 1, 'images/usertitles/TST.png', 63, 0, 1, 0),
(16, 0, 1, 'images/usertitles/TC.png', 68, 0, 1, 0),
(17, 0, 1, 'images/usertitles/SD.png', 69, 0, 1, 0),
(18, 0, 1, 'images/usertitles/Founder.png', 6, 0, 1, 0),
(21, 10, 1, 'images/usertitles/Admin.png', 70, 0, 1, 0),
(20, 10, 1, 'images/usertitles/GT.png', 59, 0, 1, 0);