-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 01:30 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 `avatar`
--

CREATE TABLE IF NOT EXISTS `avatar` (
  `avatarid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `minimumposts` int(10) unsigned NOT NULL DEFAULT '0',
  `avatarpath` varchar(100) NOT NULL DEFAULT '',
  `imagecategoryid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayorder` smallint(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`avatarid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `avatar`
--

INSERT INTO `avatar` (`avatarid`, `title`, `minimumposts`, `avatarpath`, `imagecategoryid`, `displayorder`) VALUES
(23, 'BMC Performance', 0, 'images/avatars/BMCP_1_avatar.png', 3, 2),
(24, 'Ford Oval', 0, 'images/avatars/ford_1_avatar.png', 3, 5),
(25, 'Ford Racing', 0, 'images/avatars/FR_1_avatar.png', 3, 5),
(26, 'Swoosh', 0, 'images/avatars/Swoosh_1_avatar.png', 3, 2),
(27, 'BMC Button', 0, 'images/avatars/BMC_Button_1_avatar.png', 3, 1),
(28, 'TERMN8R Tribute Ribbon', 0, 'images/avatars/mikeribbon_1_avatar.png', 3, 3),
(31, 'Tri-bar Pony', 0, 'images/avatars/tribar_1_avatar.png', 3, 5),
(30, 'Troop Support Team', 0, 'images/avatars/TST_1_avatar.png', 3, 1),
(32, 'CCASR Logo', 0, 'images/avatars/ccasr-logo_400w.png', 3, 1),
(22, 'Brand Logo', 0, 'images/avatars/brand_1_avatar.png', 3, 1);