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

CREATE TABLE IF NOT EXISTS `formbits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) NOT NULL DEFAULT '0',
  `displayorder` int(10) NOT NULL DEFAULT '0',
  `type` int(3) NOT NULL DEFAULT '0',
  `question` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `options` longtext NOT NULL,
  `compulsory` int(1) NOT NULL DEFAULT '1',
  `rows` int(5) NOT NULL DEFAULT '3',
  `cols` int(5) NOT NULL DEFAULT '40',
  `maxlength` int(5) NOT NULL DEFAULT '255',
  `size` int(5) NOT NULL DEFAULT '40',
  `perrow` int(5) NOT NULL DEFAULT '1',
  `ereg` varchar(255) NOT NULL DEFAULT '',
  `custom` longtext NOT NULL,
  `spacer` varchar(7) NOT NULL DEFAULT '\',
  `guestonly` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `formbits`
--

INSERT INTO `formbits` (`id`, `fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `spacer`, `guestonly`) VALUES
(1, 1, 10, 1, 'Screen Name', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(2, 1, 20, 1, 'First Name', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(3, 1, 30, 1, 'Last Name', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(4, 1, 50, 3, 'Position for which you are applying', 'All positions are for a 1 year term, and position descriptions can be found here: <insert link>', 'Graphics Team\r\nMember Support Team\r\nModerator\r\nState Director\r\nTroop Support Team\r\nOther', 1, 0, 0, 0, 0, 1, '', '', '', 0),
(5, 1, 60, 6, 'Additional information regarding desired position', 'If you chose Moderator above, please list sections you would like to moderate.  If you chose Other above, please explain the position you wish to fill.', '', 0, 3, 40, 0, 0, 0, '', '', '', 0),
(6, 1, 70, 6, 'What previous experience will aid you in success here?', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(7, 1, 1, 7, 'Contact Information', '', '', 0, 3, 40, 255, 40, 1, '', '', '\', 0),
(8, 1, 40, 7, 'Position Application', '', '', 0, 3, 40, 255, 40, 1, '', '', '\', 0),
(9, 1, 31, 1, 'Email Address', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(10, 1, 32, 1, 'Phone Number', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(12, 1, 80, 6, 'Do you serve a Staff role on any other forums?', 'Please explain what role(s) you have held or currently hold on other clubs or forums, and how that will assist you here.', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(16, 1, 90, 6, 'How much time can you devote to your Staff role?', 'The amount of time needed for each role varies, but each does require time on the forums and/or face to face with members.  How much time are you able to devote to your Staff role and are there times of the day/week/month you aren''t available?', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(14, 1, 100, 6, 'Why do YOU want to be part of the BMC Staff?', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0),
(15, 1, 110, 6, 'What else should we know about you?', '', '', 1, 3, 40, 255, 40, 1, '', '', '\', 0);