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

CREATE TABLE IF NOT EXISTS `phrasetype` (
  `fieldname` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `editrows` smallint(5) unsigned NOT NULL DEFAULT '0',
  `product` varchar(25) NOT NULL DEFAULT '',
  `special` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phrasetype`
--

INSERT INTO `phrasetype` (`fieldname`, `title`, `editrows`, `product`, `special`) VALUES
('global', 'GLOBAL', 3, '', 0),
('cpglobal', 'Control Panel Global', 3, '', 0),
('cppermission', 'Permissions', 3, '', 0),
('forum', 'Forum-Related', 3, '', 0),
('calendar', 'Calendar', 3, '', 0),
('attachment_image', 'Attachment / Image', 3, '', 0),
('style', 'Style Tools', 3, '', 0),
('logging', 'Logging Tools', 3, '', 0),
('cphome', 'Control Panel Home Pages', 3, '', 0),
('promotion', 'Promotion Tools', 3, '', 0),
('user', 'User Tools (global)', 3, '', 0),
('help_faq', 'FAQ  / Help Management', 3, '', 0),
('sql', 'SQL Tools', 3, '', 0),
('subscription', 'Subscription Tools', 3, '', 0),
('language', 'Language Tools', 3, '', 0),
('bbcode', 'BB Code Tools', 3, '', 0),
('stats', 'Statistics Tools', 3, '', 0),
('diagnostic', 'Diagnostic Tools', 3, '', 0),
('maintenance', 'Maintenance Tools', 3, '', 0),
('profilefield', 'Profile Field Tools', 3, '', 0),
('thread', 'Thread Tools', 3, '', 0),
('timezone', 'Timezones', 3, '', 0),
('banning', 'Banning Tools', 3, '', 0),
('reputation', 'Reputation', 3, '', 0),
('wol', 'Who''s Online', 3, '', 0),
('threadmanage', 'Thread Management', 3, '', 0),
('pm', 'Private Messaging', 3, '', 0),
('cpuser', 'Control Panel User Management', 3, '', 0),
('accessmask', 'Access Masks', 3, '', 0),
('cron', 'Scheduled Tasks', 3, '', 0),
('moderator', 'Moderators', 3, '', 0),
('cpoption', 'Control Panel Options', 3, '', 0),
('cprank', 'Control Panel User Ranks', 3, '', 0),
('cpusergroup', 'Control Panel User Groups', 3, '', 0),
('holiday', 'Holidays', 3, '', 0),
('posting', 'Posting', 3, '', 0),
('poll', 'Polls', 3, '', 0),
('fronthelp', 'Frontend FAQ/Help', 3, '', 0),
('register', 'Register', 3, '', 0),
('search', 'Searching', 3, '', 0),
('showthread', 'Show Thread', 3, '', 0),
('postbit', 'Postbit', 3, '', 0),
('forumdisplay', 'Forum Display', 3, '', 0),
('messaging', 'Messaging', 3, '', 0),
('plugins', 'Plugin System', 3, '', 0),
('cprofilefield', 'Custom Profile Fields', 3, '', 0),
('inlinemod', 'Inline Moderation', 3, '', 0),
('error', 'Front-End Error Messages', 8, '', 1),
('frontredirect', 'Front-End Redirect Messages', 8, '', 1),
('emailbody', 'Email Body Text', 10, '', 1),
('emailsubject', 'Email Subject Text', 3, '', 1),
('vbsettings', 'vBulletin Settings', 4, '', 1),
('cphelptext', 'Control Panel Help Text', 8, '', 1),
('faqtitle', 'FAQ Title', 3, '', 1),
('faqtext', 'FAQ Text', 10, '', 1),
('cpstopmsg', 'Control Panel Stop Message', 8, '', 1),
('advindex', 'vBadvanced Homepage', 3, '', 0),
('members_choice', 'Members Choice', 3, '', 0),
('adv_portal', 'vBadvanced CMPS', 3, '', 0),
('adv_portal_cp', 'vBadvanced CMPS CP', 3, '', 0),
('prefix', 'Thread Prefixes', 3, '', 0),
('local_links', 'local_links', 3, 'eirma_ldm', 0),
('reputationlevel', 'Reputation Levels', 3, '', 0),
('infraction', 'User Infractions', 3, '', 0),
('infractionlevel', 'User Infraction Levels', 3, '', 0),
('prefixadmin', 'Thread Prefixes (Admin)', 3, '', 0),
('socialgroups', 'Social Groups', 3, '', 0),
('notice', 'Notices', 3, '', 0),
('hvquestion', 'Human Verification Questions', 3, '', 1),
('album', 'Albums', 3, '', 0);