-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2016 at 12:03 PM
-- Server version: 1.0.19
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mechbunny_mb6`
--

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

--
-- Table structure for table `blocks`
--

CREATE TABLE IF NOT EXISTS `blocks` (
  `title` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `visibility_mode` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 - Hidden on certain pages, 1 - Visible on certain pages',
  `visibility_paths` text NOT NULL COMMENT '''Paths (urls) with placeholder (*) to match visibility''',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `date_added` datetime NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `blocks`
--

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

--
-- Table structure for table `blocks_languages`
--

CREATE TABLE IF NOT EXISTS `blocks_languages` (
  `block_id` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `data` text NOT NULL,
  UNIQUE KEY `uidx_block_language` (`block_id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blocks_languages`
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(255) NOT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `cache_data` longtext NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache`

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `comment` mediumtext NOT NULL,
  `content` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL COMMENT '0 = media, 1 = pornstars, 2 = user profiles',
  `timestamp` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `content` (`content`),
  KEY `timestamp` (`timestamp`),
  KEY `type` (`type`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `comments`
--


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

--
-- Table structure for table `configuration`
--

CREATE TABLE IF NOT EXISTS `configuration` (
  `field_name` varchar(255) NOT NULL,
  `field_description` varchar(255) NOT NULL,
  `field` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `data` mediumtext NOT NULL,
  `weight` int(11) NOT NULL DEFAULT '1',
  `group` varchar(50) NOT NULL,
  `localized` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is language-sensitive?',
  `settings` text NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `field` (`field`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `configuration`
--

INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES
('Admin Email', 'Email address of site administrator', 'admin_email', 'webmaster@domain.com', '', 1, 'site', 0, '', 1),
('No-Reply Email', 'Reply-to email address of outgoing website transaction emails (forgot password, registration email, etc)', 'noreply_email', 'noreply@domain.com', '', 1, 'site', 0, '', 2),
('Admin IP Limitations', 'Enable/Disable admin area ip restrictions', 'admin_ip_limitation', '0', '{"true":1,"false":0}', 1, 'site', 0, '', 3),
('Allowed IPs', 'IPs allowed into admin area', 'admin_allowed_ips', '', 'array', 1, 'site', 0, '', 4),
('Site Name', 'Name of Website', 'sitename', 'Mechbunny Tube Script', '', 1, 'site', 1, '', 5),
('Template', 'Template directory inside /templates/', 'template_name', 'default_tube2018', '', 1, 'site', 0, '', 6),
('Delete Hotlinked Videos?', 'Delete backup copy of hotlinked video after processing thumbnails?', 'deleteHotlinkedVideos', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 7),
('FFMPEG Path', 'Path to FFMPEG binary', 'ffmpeg_path', '/usr/local/bin/ffmpeg', '', 1, 'paths', 0, '', 8),
('Yamdi Path', 'Path to Yamdi binary', 'yamdi_path', '/usr/bin/yamdi', '', 1, 'paths', 0, '', 9),
('WGET Path', 'Path to WGET binary', 'wget_path', '/usr/bin/wget', '', 1, 'paths', 0, '', 10),
('MP4Box Path', 'Path to MP4Box Binary', 'mp4box_path', '/usr/local/bin/MP4Box', '', 1, 'paths', 0, '', 11),
('PHP Path', 'Path to PHP binary', 'php_path', '/usr/local/bin/php', '', 1, 'paths', 0, '', 12),
('ImageMagick Convert Path', 'Path to ImageMagick''s Convert binary', 'convert_path', '/usr/local/bin/convert', '', 1, 'paths', 0, '', 13),
('ImageMagick Mogrify Path', 'Path to ImageMagick''s Mogrify binary', 'mogrify_path', '/usr/local/bin/mogrify', '', 1, 'paths', 0, '', 14),
('ImageMagick Video Thumbs', 'Process video thumbs through imagemagick after ffmpeg creates them', 'imagick_enabled', '1', '{"true":1,"false":0}', 1, 'thumbnailing', 0, '', 31),
('ImageMagick Video Thumb Command', 'Command line used for Above', 'imagick_command', '-modulate 110,102,100 -sharpen 1x1 -enhance', '', 1, 'thumbnailing', 0, '', 32),
('FFMPEG Command Line', 'Command line used for encoding ffmpeg videos', 'ffmpeg_command', '-acodec aac -keyint_min 20 -r 20 -vcodec libx264 -crf 22 -b 1000k -bt 1000k -y -v 0 -bf 16 -threads 0', '', 1, 'encoder', 0, '', 33),
('FFMPEG Mobile Command Line', 'Command line used for encoding ffmpeg mobile videos', 'ffmpeg_mobile_command', '-acodec aac -ab 128k -vcodec mpeg4 -b 800k -mbd 2 -cmp 2 -subcmp 2', '', 1, 'encoder', 0, '', 34),
('Video Thumb Width', '', 'thumbwidth', '278', '', 1, 'thumbnailing', 0, '{"type":"number","min":100,"max":1280,"suffix":"px"}', 35),
('Video Thumb Height', '', 'thumbheight', '170', '', 1, 'thumbnailing', 0, '{"type":"number","min":60,"max":720,"suffix":"px"}', 36),
('Image Thumb Width', '', 'picthumbwidth', '278', '', 1, 'thumbnailing', 0, '{"type":"number","min":100,"max":640,"suffix":"px"}', 37),
('Image Thumb Height', '', 'picthumbheight', '170', '', 1, 'thumbnailing', 0, '{"type":"number","min":60,"max":480,"suffix":"px"}', 38),
('cronPublish Amount', 'Number of videos cronPublish.php publishes each time it is ran', 'numCronPublish', '1', '', 1, 'general', 0, '{"type":"number","min":0,"max":9999,"suffix":"videos"}', 39),
('Results Per Page', 'Number of media displayed per page on index/search/etc pages', 'results_per_page', '20', '', 1, 'general', 0, '{"type":"number","min":6,"max":1000,"suffix":"items"}', 40),
('Minimum Votes', 'Minimum votes required for a video to appear under top rated', 'minimum_votes', '0', '', 1, 'general', 0, '{"type":"number","min":0,"max":1000,"suffix":"votes"}', 41),
('Allow Surfer Uploads', 'Toggle upload ability for non-partner user accounts', 'allowSurferUploads', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 42),
('Allow Uploads', 'Toggle uploads for all accounts including partners', 'allowUploads', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 43),
('Display Comments?', 'Toggle displaying comments on media pages', 'allowDisplayComments', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 44),
('Allow Commenting?', 'toggle adding comments on media pages', 'allowAddComments', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 45),
('Allow Favorites?', 'toggle user adding to favorites', 'allowAddFavorites', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 46),
('Media Page Cache Time', 'Cache time of data for Media Pages (in seconds)', 'video_cache_time', '1', '', 1, 'general', 0, '{"type":"number","min":0,"max":2592000,"suffix":"seconds"}', 47),
('Overall Cache Time', 'Cache time of data for General Data (in seconds)', 'overall_cache_time', '1', '', 1, 'general', 0, '{"type":"number","min":0,"max":2592000,"suffix":"seconds"}', 48),
('Require Email Confirmation', 'Require email confirmation on user account signup', 'require_account_confirmation', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 49),
('Enable Signup Captcha', 'Toggle captcha on user signup form', 'enable_signup_captcha', '1', '{"true":1,"false":0}', 1, 'general', 0, '', 50),
('Force Encode Videos', 'Run all videos through encoder, including MP4s', 'forceEncodeAll', '0', '{"true":1,"false":0}', 1, 'encoder', 0, '', 51),
('Encode Mobile', 'Encode separate mobile copies of videos', 'encodeMobile', '1', '{"true":1,"false":0}', 0, 'encoder', 0, '', 52),
('Enable Mobile Template', 'Enable separate mobile template (loads the one in /templates/mobile/ when mobile device detected', 'enableMobile', '0', '{"true":1,"false":0}', 1, 'general', 0, '', 53),
('Redirect Mobile Traffic', 'When filled in, this will redirect all mobile traffic to a completely separate URL. Leave blank to disable.', 'redirect_mobile', '', '', 1, 'general', 0, '', 54),
('Encode Trailers?', 'Toggle encoding of video trailers, and show video trailers to non-premium users', 'encodeTrailer', '0', '{"true":1,"false":0}', 0, 'encoder', 0, '', 55),
('Video Trailer Start Time', 'Starting point of video trailers, in seconds.', 'trailerFrom', '0', '', 1, 'encoder', 0, '{"type":"number","min":0,"suffix":"second"}', 56),
('Video Trailer Duration', 'length of trailer in seconds', 'trailerDuration', '60', '', 1, 'encoder', 0, '{"type":"number","min":10,"max":900,"suffix":"second"}', 57),
('Cache Type', 'Defines which caching system to use', 'cacheType', 'filesystem', '{"Memcached":"memcached","Filesystem":"filesystem"}', 1, 'site', 0, '', 58),
('Memcached Server Host', 'Hostname of Memcached Server (usually localhost)', 'memcachedServer', 'localhost', '', 1, 'site', 0, '', 59),
('Memcached Server Port', 'Port of Memcached Server (usually 11211)', 'memcachedPort', '11211', '', 1, 'site', 0, '', 60),
('Streaming Protocol', 'Streaming protocol used when displaying videos to users', 'player_streamer', 'lighttpd', '{"HTTP":"lighttpd","RTMP":"rtmp"}', 1, 'player', 0, '', 61),
('Player Settings - Autoplay', 'Toggle autoplay of video when user hits video page', 'player_autoplay', '1', '{"true":1,"false":0}', 1, 'player', 0, '', 62),
('Player Settings - Show Watermark', 'Toggle display of watermark on video player', 'player_show_watermark', '1', '{"true":1,"false":0}', 1, 'player', 0, '', 63),
('Player Settings - Watermark URL', 'URL to Watermark, relative to root of domain.', 'player_watermark_url', '/includes/player/logo.png', '', 1, 'player', 0, '', 64),
('Player Settings - Watermark Opacity', 'watermark opacity  (range of 0.0 to 1.0)', 'player_watermark_opacity', '0.8', '', 1, 'player', 0, '{"type":"number","min":0,"max":1,"step":0.1}', 65),
('Player Settings - Padding Top', 'Watermark top padding in pixels', 'player_watermark_padding_top', '20', '', 1, 'player', 0, '{"type":"number","min":0,"max":100,"suffix":"px"}', 66),
('Player Settings - Padding Right', 'Watermark right padding in pixels', 'player_watermark_padding_right', '20', '', 1, 'player', 0, '{"type":"number","min":0,"max":100,"suffix":"px"}', 67),
('Player Settings - Watermark Placement', 'Watermark Placement', 'player_watermark_placement', 'top-right', '', 1, 'player', 0, '', 68),
('Player Settings - Watermark URL Redirect', 'URL Location when watermark is clicked', 'player_watermark_redirect', 'https://www.mechbunny.com', '', 1, 'player', 0, '', 69),
('Youtube API Key', 'Please enter your youtube api key from google developer console here as per this video: https://www.youtube.com/watch?v=Im69kzhpR3I', 'youtubeApiKey', '', '', 1, 'general', 0, '', 70),
('HandBrakeCLI Path', 'Path to HandBrakeCLI Binary', 'handbrake_path', '/usr/bin/HandBrakeCLI', '', 1, 'paths', 0, '', 71),
('HandBrake Command Line', 'Command line used for encoding with HandBrake', 'handbrake_command', '-e x264 -q 18 -B 128', '', 1, 'encoder', 0, '', 72),
('Encoding Software', 'Which encoding software to use?', 'encoder_software', 'ffmpeg', '{"ffmpeg":"ffmpeg","handbrake":"handbrake"}', 1, 'encoder', 0, '', 73),
('HandBrake Mobile Command Line', 'Command line used for mobile encoding with HandBrake', 'handbrake_mobile_command', '-e x264 -q 18 -B 128', '', 1, 'encoder', 0, '', 74),
('Multiple Servers', 'Multiple Media Servers Manager', 'multiple_servers', '0', '{"true":1,"false":0}', 1, 'media_server', 0, '', 75),
('Send e-mails', '', 'send_emails', '1', '{"true":1,"false":0}', 1, 'email', 0, '', 76),
('Format e-mails as HTML', '', 'send_html_emails', '1', '{"true":1,"false":0}', 1, 'email', 0, '', 77),
('Use PHP Mailer', '', 'phpmailer_enabled', '1', '{"true":1,"false":0}', 1, 'email', 0, '', 78),
('Mailbox messages per page', '', 'mails_per_page', '25', '', 1, 'email', 0, '{"type":"number","min":10,"max":500,"suffix":"entries"}', 79),
('SMTP Host', '', 'smtp_host', '', '', 1, 'email', 0, '', 80),
('SMTP Authorization', '', 'smtp_auth', '0', '{"true":1,"false":0}', 1, 'email', 0, '', 81),
('SMTP Username', '', 'smtp_user', '', '', 1, 'email', 0, '', 82),
('SMTP Password', '', 'smtp_pass', '', '', 1, 'email', 0, '', 83),
('SMTP Port', '', 'smtp_port', '25', '', 1, 'email', 0, '{"type":"number","min":25,"max":65536}', 84),
('Debugging Mode', 'Whether to display debugging information such as query issues', 'development_mode', '0', '{"true":1,"false":0}', 1, 'site', 0, '', 85),
('Default Meta Title', '', 'default_meta_title', 'Free Tube - Mechbunny Tube Script', '', 1, 'meta', 1, '', 86),
('Default Meta Description', '', 'default_meta_description', 'Free Tube - Mechbunny Tube Script', '', 1, 'meta', 1, '', 87),
('Default Meta Keywords', '', 'default_meta_keywords', 'tube script, mechbunny tube script', '', 1, 'meta', 1, '', 88),
('Default Meta Robots', '', 'default_meta_robots', 'index,follow', '', 1, 'meta', 1, '', 89),
('Maximum avatar filesize (in kB)', '', 'max_avatar_size', '512', '', 1, 'general', 0, '{"type":"number","min":50,"max":8192,"suffix":"kB"}', 90),
('Min length of username', '', 'username_min_length', '3', '', 1, 'general', 0, '{"type":"number","min":3,"max":20,"suffix":"characters"}', 91),
('Max length of username', '', 'username_max_length', '20', '', 1, 'general', 0, '{"type":"number","min":10,"max":50,"suffix":"characters"}', 92),
('Min length of password', '', 'password_min_length', '5', '', 1, 'general', 0, '{"type":"number","min":5,"max":100,"suffix":"characters"}', 93),
('Max length of password', '', 'password_max_length', '50', '', 1, 'general', 0, '{"type":"number","min":20,"max":100,"suffix":"characters"}', 94),
('Enable Facebook Login', '', 'enable_facebook_login', '0', '{"true":1,"false":0}', 1, 'social', 0, '', 95),
('Facebook Application ID', '', 'facebook_appid', '', '', 1, 'social', 0, '', 96),
('Facebook Application Secret Key', '', 'facebook_appsecret', '', '', 1, 'social', 0, '', 97),
('Facebook Response URL', '', 'facebook_response_url', 'http://www.domain.com/includes/facebook/facebook_response.php', '', 1, 'social', 0, '', 98),
('Enable Twitter Login', '', 'enable_twitter_login', '0', '{"true":1,"false":0}', 1, 'social', 0, '', 99),
('Twitter Consumer Key', '', 'twitter_consumer_key', '', '', 1, 'social', 0, '', 100),
('Twitter Consumer Secret', '', 'twitter_consumer_secret', '', '', 1, 'social', 0, '', 101),
('Twitter Auth Key', '', 'twitter_auth_key', '', '', 1, 'social', 0, '', 102),
('Twitter Auth Secret', '', 'twitter_auth_secret', '', '', 1, 'social', 0, '', 103),
('Search results Cache Time', 'Cache time of data for Search Results (in seconds)', 'search_cache_time', '300', '', 1, 'general', 0, '{"type":"number","min":0,"max":2592000,"suffix":"seconds"}', 104),
('Most recent results Cache Time', 'Cache time of data for Most Recent page (in seconds)', 'most_recent_cache_time', '300', '', 1, 'general', 0, '{"type":"number","min":0,"max":2592000,"suffix":"seconds"}', 105),
('Debugging Mode Admin Only', 'When "Debugging Mode" is enabled, all debugging information will be visible only, when admin is also logged in', 'development_mode_admin_only', '0', '{"true":1,"false":0}', 1, 'site', 0, '', 106),
('Maintenance Mode', 'Enabling "Maintenance Mode" will disable site for viewers and only authenticated Admin will be able to view website', 'maintenance_mode', '0', '{"true":1,"false":0}', 1, 'site', 0, '', 107),
('Default Language (ISO)', '', 'default_language', 'EN', '', 1, 'site', 0, '', 108),
('Default Language Name', '', 'default_language_label', 'English', '', 1, 'site', 0, '', 109),
('Default Database Charset', '', 'db_charset', 'utf8', '', 1, 'site', 0, '', 110);

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

--
-- Table structure for table `content`
--

CREATE TABLE IF NOT EXISTS `content` (
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `alternate_files` mediumtext NOT NULL,
  `orig_filename` varchar(255) NOT NULL,
  `trailer_filename` varchar(255) NOT NULL,
  `server` int(11) NOT NULL DEFAULT '0',
  `thumbnail` varchar(255) NOT NULL,
  `embed` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  `paysite` int(11) NOT NULL DEFAULT '0',
  `keywords` varchar(255) NOT NULL,
  `pornstars` varchar(255) NOT NULL,
  `scheduled_date` date NOT NULL,
  `date_added` datetime NOT NULL,
  `encoded_date` datetime NOT NULL,
  `rating` int(5) NOT NULL DEFAULT '0',
  `length` int(11) NOT NULL DEFAULT '0',
  `submitter` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL,
  `approved` int(11) NOT NULL DEFAULT '0',
  `hotlinked` varchar(1024) NOT NULL,
  `plug_url` varchar(255) NOT NULL,
  `enabled` int(11) NOT NULL DEFAULT '0',
  `main_thumb` int(11) NOT NULL DEFAULT '3',
  `xml` varchar(32) NOT NULL,
  `photos` int(11) NOT NULL DEFAULT '0',
  `mobile` varchar(255) NOT NULL,
  `pornstartmp` varchar(255) NOT NULL,
  `movie_width` int(11) NOT NULL,
  `movie_height` int(11) NOT NULL,
  `filesize` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `source_thumb_url` varchar(255) NOT NULL,
  `related` varchar(1024) NOT NULL,
  `force_related` varchar(255) NOT NULL,
  `orig_csv_url` varchar(1024) NOT NULL,
  `premium` int(11) NOT NULL,
  `other_data` mediumtext NOT NULL,
  `filter` char(1) NOT NULL DEFAULT 'S',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `filename` (`filename`),
  KEY `scheduled_date` (`scheduled_date`),
  KEY `encoded_date` (`encoded_date`),
  KEY `photos` (`photos`),
  KEY `approved` (`approved`),
  KEY `length` (`length`),
  KEY `enabled` (`enabled`),
  KEY `rating` (`rating`),
  KEY `submitter` (`submitter`),
  KEY `paysite` (`paysite`),
  KEY `premium` (`premium`),
  KEY `filter` (`filter`),
  KEY `encoded_date_2` (`encoded_date`,`enabled`),
  FULLTEXT KEY `title` (`title`,`keywords`),
  FULLTEXT KEY `title_2` (`title`,`description`,`keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `content`
--


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

--
-- Table structure for table `content_crc32`
--

CREATE TABLE IF NOT EXISTS `content_crc32` (
  `checksum` varchar(255) NOT NULL,
  `content` int(11) NOT NULL,
  KEY `checksum` (`checksum`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_crc32`
--


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

--
-- Table structure for table `content_deleted`
--

CREATE TABLE IF NOT EXISTS `content_deleted` (
  `content` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `data` mediumtext NOT NULL,
  UNIQUE KEY `content` (`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_deleted`
--


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

--
-- Table structure for table `content_languages`
--

CREATE TABLE IF NOT EXISTS `content_languages` (
  `content` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  UNIQUE KEY `content` (`content`,`language`),
  FULLTEXT KEY `title` (`title`,`keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_languages`
--


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

--
-- Table structure for table `content_niches`
--

CREATE TABLE IF NOT EXISTS `content_niches` (
  `content` int(11) NOT NULL DEFAULT '0',
  `niche` int(11) NOT NULL DEFAULT '0',
  KEY `niche` (`niche`),
  UNIQUE KEY `content` (`content`,`niche`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_niches`
--


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

--
-- Table structure for table `content_pornstars`
--

CREATE TABLE IF NOT EXISTS `content_pornstars` (
  `content` int(11) NOT NULL,
  `pornstar` int(11) NOT NULL,
  UNIQUE KEY `content` (`content`,`pornstar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_pornstars`
--


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

--
-- Table structure for table `content_search`
--

CREATE TABLE IF NOT EXISTS `content_search` (
  `titles` text NOT NULL,
  `keywords` text NOT NULL,
  `descriptions` text NOT NULL,
  `content` int(11) NOT NULL,
  `photos` tinyint(1) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  FULLTEXT KEY `titles` (`titles`,`keywords`,`descriptions`),
  FULLTEXT KEY `titles_2` (`titles`,`keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `content_search`
--


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

--
-- Table structure for table `content_views`
--

CREATE TABLE IF NOT EXISTS `content_views` (
  `views` int(11) NOT NULL,
  `content` int(11) NOT NULL,
  PRIMARY KEY (`content`),
  KEY `views` (`views`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_views`
--


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

--
-- Table structure for table `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(2) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidx_code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `code`, `value`) VALUES
(1, 'AF', 'Afghanistan'),
(2, 'AL', 'Albania'),
(3, 'DZ', 'Algeria'),
(4, 'AS', 'American Samoa'),
(5, 'AD', 'Andorra'),
(6, 'AO', 'Angola'),
(7, 'AI', 'Anguilla'),
(8, 'AQ', 'Antarctica'),
(9, 'AG', 'Antigua and Barbuda'),
(10, 'AR', 'Argentina'),
(11, 'AM', 'Armenia'),
(12, 'AW', 'Aruba'),
(13, 'AU', 'Australia'),
(14, 'AT', 'Austria'),
(15, 'AZ', 'Azerbaijan'),
(16, 'BS', 'Bahamas'),
(17, 'BH', 'Bahrain'),
(18, 'BD', 'Bangladesh'),
(19, 'BB', 'Barbados'),
(20, 'BY', 'Belarus'),
(21, 'BE', 'Belgium'),
(22, 'BZ', 'Belize'),
(23, 'BJ', 'Benin'),
(24, 'BM', 'Bermuda'),
(25, 'BT', 'Bhutan'),
(26, 'BO', 'Bolivia'),
(27, 'BA', 'Bosnia and Herzegovina'),
(28, 'BW', 'Botswana'),
(29, 'BV', 'Bouvet Island'),
(30, 'BR', 'Brazil'),
(31, 'IO', 'British Indian Ocean territory'),
(32, 'BN', 'Brunei Darussalam'),
(33, 'BG', 'Bulgaria'),
(34, 'BF', 'Burkina Faso'),
(35, 'BI', 'Burundi'),
(36, 'KH', 'Cambodia'),
(37, 'CM', 'Cameroon'),
(38, 'CA', 'Canada'),
(39, 'CV', 'Cape Verde'),
(40, 'KY', 'Cayman Islands'),
(41, 'CF', 'Central African Republic'),
(42, 'TD', 'Chad'),
(43, 'CL', 'Chile'),
(44, 'CN', 'China'),
(45, 'CX', 'Christmas Island'),
(46, 'CC', 'Cocos (Keeling) Islands'),
(47, 'CO', 'Colombia'),
(48, 'KM', 'Comoros'),
(49, 'CG', 'Congo'),
(50, 'CK', 'Cook Islands'),
(51, 'CR', 'Costa Rica'),
(52, 'CI', 'Cote D''Ivoire'),
(53, 'HR', 'Croatia'),
(54, 'CU', 'Cuba'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'DK', 'Denmark'),
(58, 'DJ', 'Djibouti'),
(59, 'DM', 'Dominica'),
(60, 'DO', 'Dominican Republic'),
(61, 'TL', 'East Timor'),
(62, 'EC', 'Ecuador'),
(63, 'EG', 'Egypt'),
(64, 'SV', 'El Salvador'),
(65, 'GQ', 'Equatorial Guinea'),
(66, 'ER', 'Eritrea'),
(67, 'EE', 'Estonia'),
(68, 'ET', 'Ethiopia'),
(69, 'FK', 'Falkland Islands'),
(70, 'FO', 'Faroe Islands'),
(71, 'FJ', 'Fiji'),
(72, 'FI', 'Finland'),
(73, 'FR', 'France'),
(74, 'GF', 'French Guiana'),
(75, 'PF', 'French Polynesia'),
(76, 'TF', 'French Southern Territories'),
(77, 'GA', 'Gabon'),
(78, 'GM', 'Gambia'),
(79, 'GE', 'Georgia'),
(80, 'DE', 'Germany'),
(81, 'GH', 'Ghana'),
(82, 'GI', 'Gibraltar'),
(83, 'GR', 'Greece'),
(84, 'GL', 'Greenland'),
(85, 'GD', 'Grenada'),
(86, 'GP', 'Guadeloupe'),
(87, 'GU', 'Guam'),
(88, 'GT', 'Guatemala'),
(89, 'GN', 'Guinea'),
(90, 'GW', 'Guinea-Bissau'),
(91, 'GY', 'Guyana'),
(92, 'HT', 'Haiti'),
(93, 'HM', 'Heard Island and McDonald Islands'),
(94, 'HN', 'Honduras'),
(95, 'HK', 'Hong Kong'),
(96, 'HU', 'Hungary'),
(97, 'IS', 'Iceland'),
(98, 'IN', 'India'),
(99, 'ID', 'Indonesia'),
(100, 'IR', 'Iran'),
(101, 'IQ', 'Iraq'),
(102, 'IE', 'Ireland'),
(103, 'IL', 'Israel'),
(104, 'IT', 'Italy'),
(105, 'JM', 'Jamaica'),
(106, 'JP', 'Japan'),
(107, 'JO', 'Jordan'),
(108, 'KZ', 'Kazakhstan'),
(109, 'KE', 'Kenya'),
(110, 'KI', 'Kiribati'),
(111, 'KP', 'Korea (north)'),
(112, 'KR', 'Korea (south)'),
(113, 'KW', 'Kuwait'),
(114, 'KG', 'Kyrgyzstan'),
(115, 'LA', 'Lao People''s Democratic Republic'),
(116, 'LV', 'Latvia'),
(117, 'LB', 'Lebanon'),
(118, 'LS', 'Lesotho'),
(119, 'LR', 'Liberia'),
(120, 'LY', 'Libyan Arab Jamahiriya'),
(121, 'LI', 'Liechtenstein'),
(122, 'LT', 'Lithuania'),
(123, 'LU', 'Luxembourg'),
(124, 'MO', 'Macao'),
(125, 'MK', 'Macedonia'),
(126, 'MG', 'Madagascar'),
(127, 'MW', 'Malawi'),
(128, 'MY', 'Malaysia'),
(129, 'MV', 'Maldives'),
(130, 'ML', 'Mali'),
(131, 'MT', 'Malta'),
(132, 'MH', 'Marshall Islands'),
(133, 'MQ', 'Martinique'),
(134, 'MR', 'Mauritania'),
(135, 'MU', 'Mauritius'),
(136, 'YT', 'Mayotte'),
(137, 'MX', 'Mexico'),
(138, 'FM', 'Micronesia'),
(139, 'MD', 'Moldova'),
(140, 'MC', 'Monaco'),
(141, 'MN', 'Mongolia'),
(142, 'MS', 'Montserrat'),
(143, 'MA', 'Morocco'),
(144, 'MZ', 'Mozambique'),
(145, 'MM', 'Myanmar'),
(146, 'NA', 'Namibia'),
(147, 'NR', 'Nauru'),
(148, 'NP', 'Nepal'),
(149, 'NL', 'Netherlands'),
(150, 'AN', 'Netherlands Antilles'),
(151, 'NC', 'New Caledonia'),
(152, 'NZ', 'New Zealand'),
(153, 'NI', 'Nicaragua'),
(154, 'NE', 'Niger'),
(155, 'NG', 'Nigeria'),
(156, 'NU', 'Niue'),
(157, 'NF', 'Norfolk Island'),
(158, 'MP', 'Northern Mariana Islands'),
(159, 'NO', 'Norway'),
(160, 'OM', 'Oman'),
(161, 'PK', 'Pakistan'),
(162, 'PW', 'Palau'),
(163, 'PS', 'Palestinian Territories'),
(164, 'PA', 'Panama'),
(165, 'PG', 'Papua New Guinea'),
(166, 'PY', 'Paraguay'),
(167, 'PE', 'Peru'),
(168, 'PH', 'Philippines'),
(169, 'PN', 'Pitcairn'),
(170, 'PL', 'Poland'),
(171, 'PT', 'Portugal'),
(172, 'PR', 'Puerto Rico'),
(173, 'QA', 'Qatar'),
(174, 'RE', 'Reunion'),
(175, 'RO', 'Romania'),
(176, 'RU', 'Russian Federation'),
(177, 'RW', 'Rwanda'),
(178, 'SH', 'Saint Helena'),
(179, 'KN', 'Saint Kitts and Nevis'),
(180, 'LC', 'Saint Lucia'),
(181, 'PM', 'Saint Pierre and Miquelon'),
(182, 'VC', 'Saint Vincent and the Grenadines'),
(183, 'WS', 'Samoa'),
(184, 'SM', 'San Marino'),
(185, 'ST', 'Sao Tome and Principe'),
(186, 'SA', 'Saudi Arabia'),
(187, 'SN', 'Senegal'),
(188, 'RS', 'Serbia'),
(189, 'SC', 'Seychelles'),
(190, 'SL', 'Sierra Leone'),
(191, 'SG', 'Singapore'),
(192, 'SK', 'Slovakia'),
(193, 'SI', 'Slovenia'),
(194, 'SB', 'Solomon Islands'),
(195, 'SO', 'Somalia'),
(196, 'ZA', 'South Africa'),
(197, 'GS', 'South Georgia and the South Sandwich Islands'),
(198, 'ES', 'Spain'),
(199, 'LK', 'Sri Lanka'),
(200, 'SD', 'Sudan'),
(201, 'SR', 'Suriname'),
(202, 'SJ', 'Svalbard and Jan Mayen Islands'),
(203, 'SZ', 'Swaziland'),
(204, 'SE', 'Sweden'),
(205, 'CH', 'Switzerland'),
(206, 'SY', 'Syria'),
(207, 'TW', 'Taiwan'),
(208, 'TJ', 'Tajikistan'),
(209, 'TZ', 'Tanzania'),
(210, 'TH', 'Thailand'),
(211, 'TG', 'Togo'),
(212, 'TK', 'Tokelau'),
(213, 'TO', 'Tonga'),
(214, 'TT', 'Trinidad and Tobago'),
(215, 'TN', 'Tunisia'),
(216, 'TR', 'Turkey'),
(217, 'TM', 'Turkmenistan'),
(218, 'TC', 'Turks and Caicos Islands'),
(219, 'TV', 'Tuvalu'),
(220, 'UG', 'Uganda'),
(221, 'UA', 'Ukraine'),
(222, 'AE', 'United Arab Emirates'),
(223, 'GB', 'United Kingdom'),
(224, 'US', 'United States of America'),
(225, 'UY', 'Uruguay'),
(226, 'UZ', 'Uzbekistan'),
(227, 'VU', 'Vanuatu'),
(228, 'VE', 'Venezuela'),
(229, 'VN', 'Vietnam'),
(230, 'VG', 'Virgin Islands (British)'),
(231, 'VI', 'Virgin Islands (US)'),
(232, 'WF', 'Wallis and Futuna Islands'),
(233, 'EH', 'Western Sahara'),
(234, 'YE', 'Yemen'),
(235, 'ZR', 'Zaire'),
(236, 'ZM', 'Zambia'),
(237, 'ZW', 'Zimbabwe');

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

--
-- Table structure for table `csv_import`
--

CREATE TABLE IF NOT EXISTS `csv_import` (
  `title` varchar(255) NOT NULL,
  `flv` varchar(1024) NOT NULL,
  `local` varchar(255) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `desc` mediumtext NOT NULL,
  `embed` mediumtext NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `lengthsec` int(11) NOT NULL,
  `paysite` varchar(255) NOT NULL,
  `default_paysite` int(11) NOT NULL,
  `hotlink` int(11) NOT NULL,
  `submitter` int(11) NOT NULL,
  `pornstars` varchar(255) NOT NULL,
  `plugurl` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `csv_import`
--


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

--
-- Table structure for table `csv_import_list`
--

CREATE TABLE IF NOT EXISTS `csv_import_list` (
  `name` varchar(1024) NOT NULL,
  `data` mediumtext NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `csv_import_list`
--

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

--
-- Table structure for table `csv_import_photos`
--

CREATE TABLE IF NOT EXISTS `csv_import_photos` (
  `title` varchar(255) NOT NULL,
  `flv` varchar(1024) NOT NULL,
  `local` varchar(255) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `desc` mediumtext NOT NULL,
  `embed` mediumtext NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `lengthsec` int(11) NOT NULL,
  `paysite` varchar(255) NOT NULL,
  `default_paysite` int(11) NOT NULL,
  `hotlink` int(11) NOT NULL,
  `submitter` int(11) NOT NULL,
  `pornstars` varchar(255) NOT NULL,
  `plugurl` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `csv_import_photos`
--


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

--
-- Table structure for table `dvd`
--

CREATE TABLE IF NOT EXISTS `dvd` (
  `name` varchar(255) NOT NULL,
  `cover_image` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `release_date` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `dvd`
--


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

--
-- Table structure for table `dvd_languages`
--

CREATE TABLE IF NOT EXISTS `dvd_languages` (
  `dvd` int(11) NOT NULL,
  `language` int(11) NOT NULL,
  `data` mediumtext NOT NULL,
  UNIQUE KEY `dvd` (`dvd`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dvd_languages`
--


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

--
-- Table structure for table `email_templates`
--

CREATE TABLE IF NOT EXISTS `email_templates` (
  `name` varchar(64) NOT NULL,
  `description` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`name`, `description`, `record_num`) VALUES
('email-verification', 'E-mail verification message', 1),
('email-verified', 'E-mail confirmed message', 2),
('new-message', 'New inbox message', 3),
('friend-request', 'New friend request message', 4),
('friend-request-confirmation', 'Friend request confirmation message', 5),
('reset-password', 'Password change request message', 6),
('reset-password-confirmation', 'Password change confirmation message', 7),
('new-post', 'New post on the profile (wall)', 8),
('new-comment', 'New comment for the content', 9),
('email-welcome', 'Welcome message after succeeded signup', 10),
('report-video', 'Report Video', 11);

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

--
-- Table structure for table `email_translations`
--

CREATE TABLE IF NOT EXISTS `email_translations` (
  `template_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `language` varchar(2) NOT NULL DEFAULT 'en',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `language` (`language`,`template_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `email_translations`
--

INSERT INTO `email_translations` (`template_id`, `subject`, `body`, `language`, `record_num`) VALUES
(1, 'Verify your e-mail on %sitename', '<p>Hi&nbsp;<strong>%username</strong>,</p>\r\n\r\n<p>You must verify your account on %sitename before you can login! Please click the link below:<br />\r\n<a href="%basehttp/validate?id=%validationCode">%basehttp/validate?id=%validationCode</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 1),
(2, 'Your e-mail has been confirmed on %sitename', '<p>Hi&nbsp;<strong><em>%username</em></strong>,</p>\r\n<p>This is just a confirmation, that your e-mail has been confirmed.</p>\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n<p>Regards, %sitename Administrator</p>', 'en', 2),
(3, 'Someone sent you a message!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n<p>Someone has sent you a message on %sitename! To view the message, visit your inbox, please click the link below or paste it into your browser''s address bar.<br><a href="%basehttp/mailbox/">%basehttp/mailbox/</a></p>\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n<p>Regards, %sitename Administrator</p>', 'en', 3),
(4, 'You have new friend request on %sitename!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>You have new friend request on %sitename! To view your friends requests<br />\r\n<a href="%basehttp/my-friends">%basehttp/my-friends</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 4),
(5, 'Your friend request has been confirmed', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone has accepted your friend request on %sitename! Click the link below to view your friends list:&nbsp;<br />\r\n<a href="%basehttp/my-friends">%basehttp/my-friends</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 5),
(6, 'Please choose a new password', '<p>Hi&nbsp;<strong><em>%username</em></strong>,</p>\r\n\r\n<p>You have requested to reset the password for username: %username</p>\r\n\r\n<p>Please, click the following link to reset your password:</p>\r\n\r\n<p><a href="%password_link">%password_link</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards,&nbsp;</p>\r\n\r\n<p>%sitename Administrator</p>', 'en', 6),
(7, 'Your password has been changed', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone - presumably you - has requested a password reset on %sitename.</p>\r\n\r\n<p>Your new login information is as follows:</p>\r\n\r\n<p>Username: %username</p>\r\n\r\n<p>Password:&nbsp;%newpassword</p>\r\n\r\n<p>To login, please click the link below or paste it into your browser&#39;s address bar.<br />\r\n<a href="%basehttp/login">%basehttp/login</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards,</p>\r\n\r\n<p>%sitename Administrator</p>', 'en', 7),
(8, 'Someone added new comment on your wall', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone added new comment on your profile. <a href="%basehttp/my-profile">Click here to view your profile.</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 8),
(9, 'Someone added new comment to your content!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone added a comment to your content:&nbsp;<br />\r\n<a href="%link">%link</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 9),
(10, 'Welcome to %sitename', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Thank you for signing up to %sitename. To login to your profile, please click the link below:<br />\r\n<a href="%basehttp/login" target="" title="">%basehttp/login</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 10),
(11, 'Reported Video', '<p>Submitter: %name, %email</p>\r\n\r\n<p>Reason: %reason</p>\r\n\r\n<p>Video: ID&nbsp;%video_id (<a href="%video_link">%video_link</a>)</p>\r\n\r\n<p>Message:<br />\r\n%content</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 11);

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

--
-- Table structure for table `favorites`
--

CREATE TABLE IF NOT EXISTS `favorites` (
  `user` int(11) NOT NULL DEFAULT '0',
  `content` int(11) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `favorites`
--


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

--
-- Table structure for table `fields`
--

CREATE TABLE IF NOT EXISTS `fields` (
  `module` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `module` (`module`,`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`module`, `code`, `name`, `record_num`) VALUES
('content', 'spin_text_options', 'Spin Text options', 1),
('models', 'ethnicities', 'Models ethnicity options', 2),
('models', 'eye_colors', 'Models eye color options', 3),
('models', 'hair_colors', 'Models hair color options', 4);

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

--
-- Table structure for table `fields_values`
--

CREATE TABLE IF NOT EXISTS `fields_values` (
  `field_id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `weight` int(11) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `fields_values`
--

INSERT INTO `fields_values` (`field_id`, `key`, `value`, `weight`, `record_num`) VALUES
(1, '', 'boobs,tits,breasts,boobies,titties,melons', 0, 1),
(1, '', 'granny,grandma,grandmother,old lady', 1, 2),
(1, '', 'wife,wifey,fiance,ex-wife', 2, 3),
(1, '', 'asian,oriental,chinese', 3, 4),
(1, '', 'latina,hispanic', 4, 5),
(1, '', 'video,movie,sex tape,film,tape', 5, 6),
(1, '', 'blonde,blondie,blondy,yellow-haired', 6, 7),
(1, '', 'orgasm,climax,cumming', 7, 8),
(1, '', 'meaty,chunky,fat,thick,wide', 8, 9),
(1, '', 'young,fresh', 9, 10),
(1, '', 'rides,mounts,fucks', 10, 11),
(1, '', 'exgf,ex-gf', 11, 12),
(1, '', 'couple,lovers', 12, 13),
(1, '', 'asshole,butthole,anus', 13, 14),
(1, '', 'husband,hubby,fiance,man,boy', 14, 15),
(1, '', 'jizzed,cummed,spunked,creamed', 15, 16),
(1, '', 'cumming,climaxing', 16, 17),
(1, '', 'loves,likes,enjoys', 17, 18),
(1, '', 'loving,liking,enjoying', 18, 19),
(1, '', 'old,older,mature,cougar', 19, 20),
(1, '', 'gorgeous,beautiful,stunning,pretty,ravishing', 20, 21),
(1, '', 'sexy,lovely,attractive,fine,pretty,charming,cute,sweet,pretty', 21, 22),
(1, '', 'teen,teenie,young', 22, 23),
(1, '', 'ladyboy,lady boy,shemale,transsexual,transexual,ts,tgirl,t-girl,tranny', 23, 24),
(1, '', 'big,large,humongous,monstrous,enormous,massive,giant,huge,gigantic', 24, 25),
(1, '', 'banged,boned,plowed,pounded,slammed,poked,fucked,hammered,drilled,screwed,nailed,sexed', 25, 26),
(1, '', 'cum,jizz,sperm,spunk', 26, 27),
(1, '', 'ejaculates,jizzes,busts', 27, 28),
(1, '', 'ass,booty,butt,behind', 28, 29),
(1, '', 'blow,suck,lick', 29, 30),
(1, '', 'petite,thin,skinny', 30, 31),
(1, '', 'blows,sucks,licks,swallows', 31, 32),
(1, '', 'blowed,blown,sucked', 32, 33),
(1, '', 'blowing,sucking,swallowing', 33, 34),
(1, '', 'blowjob,bj,oral sex', 34, 35),
(1, '', 'ebony,black', 35, 36),
(1, '', 'pussy,cunt,vagina,snatch,twat', 36, 37),
(1, '', 'cock,dick,dong,schlong,meat,penis,rod', 37, 38),
(1, '', 'penises,cocks,dicks,dongs,schlongs,rods,penii', 38, 39),
(1, '', 'sleazy,wild,nasty,slutty,naughty,kinky,dirty', 39, 40),
(1, '', 'girls,chicks,ladies,whores,hoes,skanks,sluts,bitches', 40, 41),
(1, '', 'girl,chick,lady,whore,skank,slut,bitch', 41, 42),
(1, '', 'raw,unprotected,bareback,bare', 42, 43),
(1, '', 'yummy,delicious,tasty,lovely', 43, 44),
(1, '', 'bf,boyfriend,BF,boy,man', 44, 45),
(1, '', 'girlfriend,gf,GF,girl', 45, 46),
(1, '', 'woman,girl,chick,lady,broad', 46, 47),
(1, '', 'hottie,sweetie,sweety,cutie,beauty', 47, 48),
(1, '', 'studs,dudes,males,guys,men', 48, 49),
(1, '', 'stud,dude,guy,man,lover', 50, 50),
(2, '1', 'White', 0, 56),
(2, '2', 'Black', 1, 57),
(2, '3', 'Asian', 2, 58),
(2, '4', 'Latino', 3, 59),
(2, '5', 'East-Indian', 4, 60),
(2, '6', 'Native', 5, 61),
(2, '7', 'Islander', 6, 62),
(2, '8', 'Other', 7, 63),
(3, '1', 'Amber', 0, 64),
(3, '2', 'Black', 1, 65),
(3, '3', 'Blue', 2, 66),
(3, '4', 'Brown', 3, 67),
(3, '5', 'Grey', 4, 68),
(3, '6', 'Green', 5, 69),
(3, '7', 'Hazel', 6, 70),
(3, '8', 'Violet', 7, 71),
(4, '1', 'Blonde', 0, 72),
(4, '2', 'Red', 1, 73),
(4, '3', 'Brown', 2, 74),
(4, '4', 'Black', 3, 75),
(4, '5', 'Grey', 4, 76),
(4, '6', 'White', 5, 77),
(4, '7', 'Auburn', 6, 78);

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

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
  `user` int(11) NOT NULL,
  `friend` int(11) NOT NULL,
  `approved` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `friend_request_message` mediumtext NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `user` (`user`),
  KEY `friend` (`friend`),
  KEY `approved` (`approved`),
  KEY `date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `friends`
--


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

--
-- Table structure for table `images`
--

CREATE TABLE IF NOT EXISTS `images` (
  `title` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `gallery` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `gallery` (`gallery`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `images`
--


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

--
-- Table structure for table `keywords`
--

CREATE TABLE IF NOT EXISTS `keywords` (
  `word` varchar(64) NOT NULL,
  `amount` int(11) NOT NULL,
  KEY `word` (`word`),
  KEY `amount` (`amount`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `keywords`
--


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

--
-- Table structure for table `languages`
--

CREATE TABLE IF NOT EXISTS `languages` (
  `name` varchar(255) NOT NULL,
  `iso` char(2) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `iso` (`iso`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `languages`
--



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

--
-- Table structure for table `link_shortener`
--

CREATE TABLE IF NOT EXISTS `link_shortener` (
  `slug` varchar(255) NOT NULL,
  `target` varchar(1024) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `slug` (`slug`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `link_shortener`
--

INSERT INTO `link_shortener` (`slug`, `target`, `record_num`) VALUES
('warcraft-trailer', 'http://mb6.mechbunny.com/video/watch-warcraft-trailer-for-the-epic-movie-online-10539.html', 2);

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

--
-- Table structure for table `locales_source`
--

CREATE TABLE IF NOT EXISTS `locales_source` (
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT NULL,
  `source_js` varchar(255) NOT NULL COMMENT 'Path to JS file where this source string is located.',
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `locales_source`
--


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

--
-- Table structure for table `locales_target`
--

CREATE TABLE IF NOT EXISTS `locales_target` (
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) NOT NULL,
  `language` varchar(2) NOT NULL,
  `translated_text` text NOT NULL,
  `translated_text_contextual` text NOT NULL,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `source_id` (`source_id`,`language`),
  KEY `source_lang_idx` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `locales_target`
--


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

--
-- Table structure for table `mail`
--

CREATE TABLE IF NOT EXISTS `mail` (
  `from_user` int(11) NOT NULL,
  `to_user` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` mediumtext NOT NULL,
  `date_sent` datetime NOT NULL,
  `recipient_read` int(11) NOT NULL,
  `recipient_deleted` int(11) NOT NULL,
  `recipient_spam` int(1) NOT NULL,
  `sender_deleted` int(11) NOT NULL,
  `sender_ip` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `from_user` (`from_user`),
  KEY `to_user` (`to_user`),
  KEY `date_sent` (`date_sent`),
  KEY `recipient_read` (`recipient_read`),
  KEY `recipient_deleted` (`recipient_deleted`),
  KEY `recipient_spam` (`recipient_spam`),
  KEY `sender_deleted` (`sender_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `mail`
--


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

--
-- Table structure for table `mb_api_endpoints`
--

CREATE TABLE IF NOT EXISTS `mb_api_endpoints` (
  `name` varchar(255) NOT NULL,
  `endpoint` varchar(255) NOT NULL,
  `mode` varchar(255) NOT NULL,
  `query` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `mb_api_endpoints`
--

INSERT INTO `mb_api_endpoints` (`name`, `endpoint`, `mode`, `query`, `amount`, `record_num`) VALUES
('test.tube.mechbunny.com', 'http://test.tube.mechbunny.com/api/', 'newest', '', 5, 2);

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

--
-- Table structure for table `metatags`
--

CREATE TABLE IF NOT EXISTS `metatags` (
  `controller` varchar(255) NOT NULL,
  `mode` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `language` varchar(2) NOT NULL DEFAULT 'EN',
  `header_title` varchar(255) NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_description` text NOT NULL,
  `meta_keywords` text NOT NULL,
  `robots` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `uidx_metatag` (`controller`,`mode`,`path`,`language`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `metatags`
--

INSERT INTO `metatags` (`controller`, `mode`, `path`, `language`, `header_title`, `meta_title`, `meta_description`, `meta_keywords`, `robots`, `record_num`) VALUES
('index', 'random', '', 'EN', 'Random', 'Random - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 1),
('index', 'top-rated', '', 'EN', 'Top Rated', 'Top Rated - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 2),
('index', 'most-discussed', '', 'EN', 'Most Discussed', 'Most Discussed - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 3),
('index', 'photos', '', 'EN', 'Photo Galleries', 'Photo Galleries - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 4),
('index', 'favorites', '', 'EN', 'My Favorites', 'My Favorites - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 5),
('index', 'most-viewed', '', 'EN', 'Most Popular', 'Most Popular - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 6),
('index', 'longest', '', 'EN', 'Longest', 'Longest - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 7),
('index', 'search', '', 'EN', 'Search results for: {{SEARCH_STRING}}', 'Search: {{SEARCH_STRING}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 8),
('index', 'channel', '', 'EN', '{{CHANNEL_NAME}}', '{{CHANNEL_NAME}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 9),
('index', 'paysites', '', 'EN', '{{PAYSITE_NAME}}', '{{PAYSITE_NAME}} - Paysites - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 10),
('index', 'uploads-by-user', '', 'EN', 'Uploads by {{USER_NAME}}', 'Uploads by {{USER_NAME}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 11),
('index', 'members', '', 'EN', 'Community', 'Community - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 12),
('index', 'my-friends', '', 'EN', 'My Friends', 'My Friends - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 13),
('index', 'my-uploads', '', 'EN', 'My Uploads', 'My Uploads - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 14),
('index', 'most-recent', '', 'EN', 'Most Recent', 'Most Recent - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 15),
('index', 'pornstars', '', 'EN', 'Models', 'Models - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 16),
('index', 'default', '', 'EN', 'Free Tube', 'Free Tube - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 17),
('403', '', '', 'EN', 'Access Denied', 'Access Denied - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', 'noindex', 18),
('404', '', '', 'EN', 'Page Not Found', 'Page Not Found - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', 'noindex', 19),
('login', '', '', 'EN', 'Login', 'Login - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 20),
('signup', '', '', 'EN', 'Signup for FREE', 'Signup for FREE - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 21),
('upload', '', '', 'EN', 'Upload Video', 'Upload Video - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 22),
('upload', 'photo', '', 'EN', 'Upload Gallery', 'Upload Gallery- {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 23),
('contact', '', '', 'EN', 'Contact Us', 'Contact - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 24),
('rss', '', '', 'EN', 'RSS Feed', 'RSS Feed - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 25),
('forgot-pass', '', '', 'EN', 'Forgot Your Password?', 'Forgot Your Password - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 26),
('password', '', '', 'EN', 'Password Setup', 'Password Setup - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 27),
('validate', '', '', 'EN', 'Validate Account', 'Validate Account - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 28),
('my_profile', '', '', 'EN', 'My Profile', 'My Profile - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 29),
('edit_profile', '', '', 'EN', 'Edit My Profile', 'Edit My Profile - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 30),
('gallery', '', '', 'EN', '{{TITLE}}', '{{TITLE}} - Galleries - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 31),
('editContent', '', '', 'EN', 'Edit Content: {{TITLE}}', 'Edit Content: {{TITLE}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 32),
('channels', '', '', 'EN', 'Categories', 'Channels - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 33),
('paysites', '', '', 'EN', 'Paysites', 'Paysites - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 34),
('models', '', '', 'EN', 'Models', 'Models - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 35),
('model_bio', '', '', 'EN', '{{MODEL_NAME}}', '{{MODEL_NAME}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 36),
('mailbox', 'inbox', '', 'EN', 'My Inbox', 'My Inbox - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 37),
('mailbox', 'outbox', '', 'EN', 'My Outbox', 'My Outbox - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 38),
('mailbox', 'read', '', 'EN', 'Read Message', 'Read Message - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 39),
('mailbox', 'compose', '', 'EN', 'Compose Message', 'Compose Message - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 40),
('user_profile', '', '', 'EN', '{{USER_NAME}}''s profile', '{{USER_NAME}}''s profile - Users - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 41),
('members', '', '', 'EN', 'Members', 'Members - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 42),
('my_friends', '', '', 'EN', 'My Friends', 'My Friends - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 43),
('keywords', '', '', 'EN', '{{TITLE}}', '{{TITLE}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 44),
('displayStatic', '', '', 'EN', '{{TITLE}}', '{{TITLE}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 45),
('pornstars', '', '', 'EN', 'Models', 'Models - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 46),
('pornstar_bio', '', '', 'EN', '{{MODEL_NAME}}', '{{MODEL_NAME}} - Models - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 47),
('video', '', '', 'EN', '{{TITLE}}', '{{TITLE}} - Videos - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 48),
('index', 'videos', '', 'EN', 'Videos', 'Videos - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 49),
('embed', '', '', 'EN', '{{TITLE}}', '{{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 50);

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

--
-- Table structure for table `niches`
--

CREATE TABLE IF NOT EXISTS `niches` (
  `name` varchar(255) NOT NULL,
  `ad0` mediumtext NOT NULL,
  `ad1` mediumtext NOT NULL,
  `ad2` mediumtext NOT NULL,
  `ad3` mediumtext NOT NULL,
  `ad4` mediumtext NOT NULL,
  `ad5` mediumtext NOT NULL,
  `ad6` mediumtext NOT NULL,
  `ad7` mediumtext NOT NULL,
  `ad8` mediumtext NOT NULL,
  `ad9` mediumtext NOT NULL,
  `postroll` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `enabled` int(11) NOT NULL DEFAULT '1',
  `description` mediumtext NOT NULL,
  `metakw` varchar(255) NOT NULL,
  `metadesc` varchar(255) NOT NULL,
  `metaheader` varchar(255) NOT NULL,
  `metatitle` varchar(255) NOT NULL,
  `csv_match` varchar(255) NOT NULL,
  `flag_navigation` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether to show this channel in navigation dropdown/toolbar',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `name` (`name`),
  KEY `flag_navigation` (`flag_navigation`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `niches`
--


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

--
-- Table structure for table `niches_languages`
--

CREATE TABLE IF NOT EXISTS `niches_languages` (
  `niche` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `name` varchar(255) NOT NULL,
  `data` text NOT NULL,
  UNIQUE KEY `niche` (`niche`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `niches_languages`
--


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

--
-- Table structure for table `paysites`
--

CREATE TABLE IF NOT EXISTS `paysites` (
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) NOT NULL,
  `user` int(11) NOT NULL DEFAULT '0',
  `ad0` text NOT NULL,
  `ad1` text NOT NULL,
  `ad2` text NOT NULL,
  `ad3` text NOT NULL,
  `ad4` text NOT NULL,
  `ad5` text NOT NULL,
  `ad6` text NOT NULL,
  `ad7` text NOT NULL,
  `ad8` text NOT NULL,
  `ad9` text NOT NULL,
  `inline_xml_url` varchar(255) NOT NULL,
  `pre_xml_url` varchar(255) NOT NULL,
  `pause_xml_url` varchar(255) NOT NULL,
  `post_xml_url` varchar(255) NOT NULL,
  `postroll` varchar(255) NOT NULL,
  `enabled` int(11) NOT NULL DEFAULT '1',
  `belowplayertext` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `paysites`
--


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

--
-- Table structure for table `paysites_languages`
--

CREATE TABLE IF NOT EXISTS `paysites_languages` (
  `paysite` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `data` mediumtext NOT NULL,
  UNIQUE KEY `paysite` (`paysite`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paysites_languages`
--


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

--
-- Table structure for table `pornstars`
--

CREATE TABLE IF NOT EXISTS `pornstars` (
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `height` varchar(255) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `measurements` varchar(255) NOT NULL,
  `hair` varchar(255) NOT NULL,
  `eyes` varchar(255) NOT NULL,
  `ethnicity` varchar(255) NOT NULL,
  `official_site_name` varchar(255) NOT NULL,
  `official_site_url` varchar(255) NOT NULL,
  `biography` text NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `rating` tinyint(3) NOT NULL,
  `rank` int(11) NOT NULL,
  `views` int(11) NOT NULL,
  `custom` text NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `rank` (`rank`),
  KEY `rating` (`rating`),
  KEY `views` (`views`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `pornstars`
--


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

--
-- Table structure for table `pornstars_languages`
--

CREATE TABLE IF NOT EXISTS `pornstars_languages` (
  `pornstar` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `data` text NOT NULL,
  UNIQUE KEY `pornstar` (`pornstar`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pornstars_languages`
--


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

--
-- Table structure for table `ratings`
--

CREATE TABLE IF NOT EXISTS `ratings` (
  `content` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `total_votes` int(11) NOT NULL,
  `total_value` int(11) NOT NULL,
  `used_ips` longtext NOT NULL,
  UNIQUE KEY `content` (`content`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ratings`
--


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

--
-- Table structure for table `regions`
--

CREATE TABLE IF NOT EXISTS `regions` (
  `code` varchar(2) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `country` varchar(2) DEFAULT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `code` (`code`),
  KEY `country_idx` (`country`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`code`, `name`, `country`, `record_num`) VALUES
('AL', 'Alabama', 'US', 1),
('AK', 'Alaska', 'US', 2),
('AZ', 'Arizona', 'US', 3),
('AR', 'Arkansas', 'US', 4),
('CA', 'California', 'US', 5),
('CO', 'Colorado', 'US', 6),
('CT', 'Connecticut', 'US', 7),
('DE', 'Delaware', 'US', 8),
('DC', 'District of Columbia', 'US', 9),
('FL', 'Florida', 'US', 10),
('GA', 'Georgia', 'US', 11),
('HI', 'Hawaii', 'US', 12),
('ID', 'Idaho', 'US', 13),
('IL', 'Illinois', 'US', 14),
('IN', 'Indiana', 'US', 15),
('IA', 'Iowa', 'US', 16),
('KS', 'Kansas', 'US', 17),
('KY', 'Kentucky', 'US', 18),
('LA', 'Lousisiana', 'US', 19),
('ME', 'Maine', 'US', 20),
('MD', 'Maryland', 'US', 21),
('MA', 'Massachusetts', 'US', 22),
('MI', 'Michigan', 'US', 23),
('MN', 'Minnesota', 'US', 24),
('MS', 'Mississippi', 'US', 25),
('MO', 'Missouri', 'US', 26),
('MT', 'Montana', 'US', 27),
('NE', 'Nebraska', 'US', 28),
('NV', 'Nevada', 'US', 29),
('NH', 'New Hampshire', 'US', 30),
('NJ', 'New Jersey', 'US', 31),
('NM', 'New Mexico', 'US', 32),
('NY', 'New York', 'US', 33),
('NC', 'North Carolina', 'US', 34),
('ND', 'North Dakota', 'US', 35),
('OH', 'Ohio', 'US', 36),
('OK', 'Oklahoma', 'US', 37),
('OR', 'Oregon', 'US', 38),
('PA', 'Pennsylvania', 'US', 39),
('PR', 'Puerto Rico', 'US', 40),
('RI', 'Rhode Island', 'US', 41),
('SC', 'South Carolina', 'US', 42),
('SD', 'South Dakota', 'US', 43),
('TN', 'Tennesee', 'US', 44),
('TX', 'Texas', 'US', 45),
('UT', 'Utah', 'US', 46),
('VT', 'Vermont', 'US', 47),
('VA', 'Virginia', 'US', 48),
('WA', 'Washington', 'US', 49),
('WV', 'West Virginia', 'US', 50),
('WI', 'Wisconsin', 'US', 51),
('WY', 'Wyoming', 'US', 52),
('AB', 'Alberta', 'CA', 53),
('BC', 'British Columbia', 'CA', 54),
('MB', 'Manitoba', 'CA', 55),
('NB', 'New Brunswick', 'CA', 56),
('NL', 'Newfoundland', 'CA', 57),
('NS', 'Nova Scotia', 'CA', 58),
('NT', 'Northwest Territories', 'CA', 59),
('NU', 'Nunavut', 'CA', 60),
('ON', 'Ontario', 'CA', 61),
('PE', 'Prince Edward Island', 'CA', 62),
('QC', 'Quebec', 'CA', 63),
('SK', 'Saskatchewan', 'CA', 64),
('YT', 'Yukon Territory', 'CA', 65);

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

--
-- Table structure for table `reported_comments`
--

CREATE TABLE IF NOT EXISTS `reported_comments` (
  `comment` int(11) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `reported_comments`
--


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

--
-- Table structure for table `reported_content`
--

CREATE TABLE IF NOT EXISTS `reported_content` (
  `content` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(255) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `content` (`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `reported_content`
--


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

--
-- Table structure for table `rss_feed`
--

CREATE TABLE IF NOT EXISTS `rss_feed` (
  `name` varchar(255) NOT NULL,
  `feed` text NOT NULL,
  `top` text NOT NULL,
  `bottom` text NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `rss_feed`
--

INSERT INTO `rss_feed` (`name`, `feed`, `top`, `bottom`, `record_num`) VALUES
('Sample Feed', '<item>\r\n<title><![CDATA[ {title} ]]></title>\r\n<thumbnail_1><![CDATA[ {thumb_main} ]]></thumbnail_1>\r\n<url><![CDATA[ {url} ]]></url>\r\n<duration><![CDATA[ {lengthsec} ]]></duration>\r\n<description><![CDATA[ {description} ]]></description>\r\n<channels><![CDATA[ {categories} ]]></channels>\r\n<tags><![CDATA[ {keywords} ]]></tags>\r\n<pornstar><![CDATA[ {pornstars} ]]></pornstar>\r\n</item>', '<?xml version="1.0" encoding="UTF-8" ?>\r\n<rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:video=''http://purl.org/dc/elements/1.1/'' xmlns:atom="http://www.w3.org/2005/Atom">\r\n<channel>\r\n', '</channel>\r\n</rss>', 3);

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

--
-- Table structure for table `scraper_import`
--

CREATE TABLE IF NOT EXISTS `scraper_import` (
  `url` varchar(255) NOT NULL,
  `user` int(11) NOT NULL,
  `paysite` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `scraper_import`
--


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

--
-- Table structure for table `scraper_import_log`
--

CREATE TABLE IF NOT EXISTS `scraper_import_log` (
  `url` varchar(1024) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `url` (`url`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `scraper_import_log`
--


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

--
-- Table structure for table `servers`
--

CREATE TABLE IF NOT EXISTS `servers` (
  `name` varchar(255) NOT NULL,
  `nfs_path` varchar(255) NOT NULL,
  `url_path` varchar(1024) NOT NULL,
  `hash_function` varchar(255) NOT NULL,
  `hash_key` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `servers`
--


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

--
-- Table structure for table `static`
--

CREATE TABLE IF NOT EXISTS `static` (
  `filename` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `headertitle` varchar(255) NOT NULL,
  `metakw` varchar(255) NOT NULL,
  `metadesc` mediumtext NOT NULL,
  `body` mediumtext NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `filename` (`filename`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

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

--
-- Table structure for table `static_languages`
--

CREATE TABLE IF NOT EXISTS `static_languages` (
  `static` int(11) NOT NULL,
  `language` varchar(3) NOT NULL,
  `data` text NOT NULL,
  UNIQUE KEY `static` (`static`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `status`
--

CREATE TABLE IF NOT EXISTS `status` (
  `scraper_running` int(11) NOT NULL,
  `encoder_running` int(11) NOT NULL,
  `encoder_done` int(11) NOT NULL,
  `encoder_total` int(11) NOT NULL,
  `csv_import_running` int(11) NOT NULL,
  `csv_import_total` int(11) NOT NULL,
  `csv_photos_import_running` int(11) NOT NULL,
  `csv_photos_import_total` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `status` (`scraper_running`, `encoder_running`, `encoder_done`, `encoder_total`, `csv_import_running`, `csv_import_total`, `csv_photos_import_running`, `csv_photos_import_total`) VALUES
(0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `username` varchar(64) NOT NULL,
  `password` varchar(32) NOT NULL,
  `salt` varchar(255) NOT NULL,
  `forgot_pass_hash` varchar(64) NOT NULL,
  `email` varchar(64) NOT NULL,
  `is_admin` int(11) NOT NULL,
  `last_ip` varchar(255) NOT NULL,
  `user_level` int(11) NOT NULL DEFAULT '0',
  `avatar` varchar(255) NOT NULL,
  `location` varchar(50) NOT NULL,
  `age` int(11) NOT NULL DEFAULT '0',
  `gender` varchar(255) NOT NULL,
  `date_joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `description` mediumtext NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `im` varchar(255) NOT NULL,
  `im_type` varchar(255) NOT NULL,
  `program_name` varchar(255) NOT NULL,
  `program_url` varchar(255) NOT NULL,
  `freeform` varchar(255) NOT NULL,
  `enabled` int(11) NOT NULL DEFAULT '1',
  `country` varchar(255) NOT NULL,
  `lastlogin` varchar(255) NOT NULL,
  `validate` varchar(64) NOT NULL,
  `backlink` varchar(255) NOT NULL,
  `banner` varchar(255) NOT NULL,
  `premium` int(11) NOT NULL,
  `tokens` int(11) NOT NULL,
  `custom` mediumtext NOT NULL,
  `email_verified` int(1) NOT NULL DEFAULT '0',
  `registration_ip` varchar(50) NOT NULL,
  `facebook_id` bigint(11) NOT NULL,
  `twitter_id` bigint(11) NOT NULL,
  `session_reload` tinyint(1) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `username` (`username`),
  KEY `validate` (`validate`),
  KEY `enabled` (`enabled`),
  KEY `premium` (`premium`),
  KEY `email` (`email`),
  KEY `email_verified` (`email_verified`),
  KEY `country` (`country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `users`
--


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

--
-- Table structure for table `users_notifications`
--

CREATE TABLE IF NOT EXISTS `users_notifications` (
  `user_id` int(11) NOT NULL,
  `scope` set('email','site') NOT NULL DEFAULT 'email',
  `new_message` tinyint(1) NOT NULL DEFAULT '1',
  `new_post` tinyint(1) NOT NULL DEFAULT '1',
  `new_comment` tinyint(1) NOT NULL DEFAULT '1',
  `friend_request` tinyint(1) NOT NULL DEFAULT '1',
  UNIQUE KEY `user_id` (`user_id`,`scope`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_notifications`
--


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

--
-- Table structure for table `user_logins`
--

CREATE TABLE IF NOT EXISTS `user_logins` (
  `time` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  KEY `user` (`user`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;


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

--
-- Table structure for table `watch_log`
--

CREATE TABLE IF NOT EXISTS `watch_log` (
  `content` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `content` (`content`),
  KEY `content_2` (`content`,`user`,`time`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `watch_log`
--


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

--
-- Table structure for table `xml_feeds`
--

CREATE TABLE IF NOT EXISTS `xml_feeds` (
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `hotlink` int(11) NOT NULL,
  `paysite` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `xml_feeds`
--

INSERT INTO `xml_feeds` (`name`, `url`, `hotlink`, `paysite`, `record_num`) VALUES
('test', 'test"', 0, 10010, 1);


UPDATE metatags SET controller = 'forgot_pass' WHERE controller = 'forgot-pass';
CREATE TABLE `csv_failures` (`date` DATETIME NOT NULL ,`csv_data` TEXT NOT NULL ,`failure` TEXT NOT NULL ,`record_num` INT NOT NULL AUTO_INCREMENT ,PRIMARY KEY ( `record_num` ) ,UNIQUE (`record_num`)) ENGINE = InnoDB;
ALTER TABLE `csv_import` ADD `jsondata` LONGTEXT NOT NULL AFTER `plugurl`;

INSERT INTO `configuration` SET `field_name` = 'Player Settings - Display Overlay Ad', `field_description` = 'Displays template_name/widgets/widget.inplayer_ad.php overtop of the player.', `field` = 'displayPlayerOverlay', `value` = '1', `data` = ' {\"true\":1,\"false\":0}', `group` = 'player';

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Scene Selection on Desktop', 'Display scene selection under player on desktop devices.', 'sceneSelectionDesktop', '1', '{\"true\":1,\"false\":0}', '0', 'player', '0', '', NULL), ('Scene Selection on Mobile', 'Display scene selection under player on mobile devices.', 'sceneSelectionMobile', '1', '{\"true\":1,\"false\":0}', '0', 'player', '0', '', NULL);



CREATE TABLE `biller_log` (
`date` TIMESTAMP NOT NULL ,
`biller` VARCHAR( 255 ) NOT NULL ,
`ip` VARCHAR( 255 ) NOT NULL ,
`data` TEXT NOT NULL ,
`record_num` INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `record_num` ) ,
INDEX ( `date` , `biller` ) ,
UNIQUE (
`record_num`
)
) ENGINE = InnoDB;

ALTER TABLE `csv_import` CHANGE `lengthsec` `lengthsec` VARCHAR( 11 ) NOT NULL;

ALTER TABLE `content` ADD `tokenCost` INT NOT NULL AFTER `filter`;

CREATE TABLE `content_purchased` (
`user` INT NOT NULL ,
`date` INT NOT NULL ,
`expires` INT NOT NULL ,
`content` INT NOT NULL ,
`record_num` INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `record_num` ) ,
UNIQUE (
`record_num`
)
) ENGINE = InnoDB;

ALTER TABLE `content_purchased` CHANGE `date` `date` TIMESTAMP NOT NULL ,
CHANGE `expires` `expires` TIMESTAMP NOT NULL;

CREATE TABLE `users_tokens` (
`user` INT NOT NULL ,
`tokens` INT NOT NULL ,
UNIQUE (
`user`
)
) ENGINE = InnoDB;



INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)
VALUES (
'CCBill Postback Enabled?', 'Enables CCBill Postback Script. For use with monthly membership sites only!', 'ccbillPostbackEnabled', '0', '{"true":1,"false":0}', '1', 'payment_gateway', '0', '', NULL
);

INSERT INTO `configuration` ( `field_name` , `field_description` , `field` , `value` , `data` , `weight` , `group` , `localized` , `settings` , `record_num` )
VALUES (
'Epoch Postback Enabled?', 'Enables Epoch Postback Script. For use with monthly membership sites only!', 'epochPostbackEnabled', '0', '{"true":1,"false":0}', '1', 'payment_gateway', '0', '', NULL
);



INSERT INTO `configuration` ( `field_name` , `field_description` , `field` , `value` , `data` , `weight` , `group` , `localized` , `settings` , `record_num` )
VALUES (
'Paysite Mode', 'Enables Paysite mode and determines what non-premium users see.', 'paysiteMode', '0', '{"thumbnails":2,"trailers":1,"false":0}', '1', 'payment_gateway', '0', '', NULL
);



INSERT INTO `configuration` ( `field_name` , `field_description` , `field` , `value` , `data` , `weight` , `group` , `localized` , `settings` , `record_num` )
VALUES (
'Enable VOD Mode', 'Enables VOD Token System. Disable all biller postbacks when using this!', 'vodMode', '0', '{"true":1,"false":0}', '1', 'payment_gateway', '0', '', NULL
);

INSERT INTO `configuration` (
`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)
VALUES ('VOD Rental Duration', 'Duration of VOD Rentals in Seconds (1 Day = 86400 Seconds)', 'vodRentalLength', '86400', '', '1', 'payment_gateway', '0', '', NULL);

INSERT INTO `configuration` (
`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)
VALUES ('VOD Rental Token Cost', 'Default Cost of VOD Rental in Tokens', 'vodRentalCost', '1', '', '1', 'payment_gateway', '0', '', NULL);





 INSERT INTO `metatags` (
`controller` ,
`mode` ,
`path` ,
`language` ,
`header_title` ,
`meta_title` ,
`meta_description` ,
`meta_keywords` ,
`robots` ,
`record_num`
)
VALUES (
'index', 'my-rentals', '', 'EN', 'My Rentals', 'My Rentals - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', NULL
);



 INSERT INTO `metatags` (
`controller` ,
`mode` ,
`path` ,
`language` ,
`header_title` ,
`meta_title` ,
`meta_description` ,
`meta_keywords` ,
`robots` ,
`record_num`
)
VALUES (
'Tags', '', '', 'EN', 'Tags', 'Tags - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', NULL
);






 INSERT INTO `metatags` (
`controller` ,
`mode` ,
`path` ,
`language` ,
`header_title` ,
`meta_title` ,
`meta_description` ,
`meta_keywords` ,
`robots` ,
`record_num`
)
VALUES (
'buyTokens', '', '', 'EN', 'Buy Tokens', 'Buy Tokens - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', NULL
);






 INSERT INTO `metatags` (
`controller` ,
`mode` ,
`path` ,
`language` ,
`header_title` ,
`meta_title` ,
`meta_description` ,
`meta_keywords` ,
`robots` ,
`record_num`
)
VALUES (
'rentVideo', '', '', 'EN', 'Confirm Purchase', 'Confirm Purchase - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', NULL
);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Netbilling Postback Enabled?', 'Enables Netbilling Postback Script', 'netbillingPostbackEnabled', '0', '{"true":1,"false":0}', '1', 'payment_gateway', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Verotel Postback Enabled?', 'Enables Verotel Postback Script', 'verotelPostbackEnabled', '0', '{"true":1,"false":0}', '1', 'payment_gateway', '0', '', NULL);

INSERT INTO `configuration` ( `field_name` , `field_description` , `field` , `value` , `data` , `weight` , `group` , `localized` , `settings` , `record_num` ) VALUES ( 'Portrait Mode Scaling', 'Toggles taller video player on Portrait mode videos', 'stretchPortrait', '{"true":1,"false":0}', '0', '1', 'player', '0', '', NULL );

ALTER TABLE `content` ADD `access_level` INT NOT NULL DEFAULT '0' AFTER `tokenCost`;

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`) VALUES ('Homepage $ads Paysite', 'Paysite ID Number used for $ads array on non-video page', 'homepagePaysite', '1', '', '1', 'general', '0', '', NULL);

UPDATE `configuration` SET `value` = '0', `data` = '{"true":1,"false":0}' WHERE `configuration`.`field` = 'stretchPortrait';

ALTER TABLE `niches` ADD `paysite` INT( 0 ) NOT NULL AFTER `flag_navigation`;



INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`) VALUES
('Hash Expiration', 'Expiration time for hash in seconds (example: 1800)', 'hashTime', '', '', 17, 'player', 0, ''),
('Hash Key', 'Key for HashFunction', 'hashKey', '', '', 16, 'player', 0, ''),
('Hash URI', 'URI for HashFunction', 'hashURI', '', '', 18, 'player', 0, ''),
('Player Hash Function', 'Function name of hotlink protection hash. Built in: apacheSecureLink (mod_auth_token), nginxSecureLink (ngx_http_secure_link_module), reflectedSecureLink (reflected.net cdn)', 'hashFunction', '', '', 15, 'player', 0, '');



INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Random Views', 'Enables random views when publishing', 'randomViewsEnabled', '0', '{"true":1,"false":0}', '30','general', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Random Views Range Min', 'Minimum range for random views', 'randomViewsMin', '0', '', '31','general', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Random Views Range Max', 'Maximum range for random views', 'randomViewsMax', '10000', '', '31','general', '0', '', NULL);


ALTER TABLE `content` ADD `vr` INT NOT NULL DEFAULT '0' AFTER `access_level` ,
ADD `vrData` TEXT NOT NULL AFTER `vr` ,
ADD `fps` INT NOT NULL AFTER `vrData`;

ALTER TABLE `csv_import` ADD `vr` INT NOT NULL DEFAULT '0' AFTER `jsondata`;

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Player Function', 'Function name of Player used on Video page', 'playerFunction', 'displayPlayerFluidplayer', '', '16', 
'player', '0', '', NULL);


INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delight URL', 'URL for Delight VR Javascript', 'delightJSURL', '', '', '17', 'player', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-primary-color', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-primary-color', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-secondary-color', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-secondary-color', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-brand-name', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-brand-name', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-brand-logo', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-brand-logo', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-brand-watermark-logo', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-brand-watermark-logo', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-brand-url', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-brand-url', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-no-brand-logo', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-no-brand-logo', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-no-brand-watermark-logo', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-no-brand-watermark-logo', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-no-content-badge', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-no-content-badge', '', '', '17', 'player', '0', '', NULL);
INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('dl8-customization-no-compass', 'Delight VR Customization - SEE https://delight-vr.com/documentation/customization/', 'dl8-customization-no-compass', '', '', '17', 'player', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delight-VR Video Formats', 'Available formats for delight-vr video player (comma separated)', 'delightVideoFormats', 'STEREO_180_LR,STEREO_180_LR_SPHERICAL,STEREO_180_TB,STEREO_180_TB_SPHERICAL,STEREO_360_TB,STEREO_360_LR,MONO_360,MONO_FLAT,STEREO_FLAT_LR,STEREO_FLAT_LR_SQUARE,STEREO_FLAT_TB,STEREO_FLAT_TB_SQUARE', '', '17', 'player', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delight-VR Audio Formats', 'Available formats for delight-vr video player audio (comma separated)', 'delightAudioFormats', 'normal,ambix', '', '17', 'player', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delight-VR CORS Fallback', 'CORS fallback URL for delight', 'cors-fallback-url', '', '', '17', 'player', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delight-VR Image Formats', 'Available formats for delight-vr video player poster images (comma separated)', 'delightImageFormats', 'STEREO_180_LR,STEREO_180_LR_SPHERICAL,STEREO_180_TB,STEREO_180_TB_SPHERICAL,STEREO_360_TB,STEREO_360_LR,MONO_360,STEREO_CUBEMAP,CARDBOARD_PHOTO', '', '17', 'player', '0', '', NULL);


UPDATE `configuration` SET `field_name` = 'FFMPEG Alternate Command Line', `field_description` = 'Command line used for encoding ffmpeg alternate videos' WHERE `configuration`.`field` = 'ffmpeg_mobile_command';

UPDATE `configuration` SET `field_name` = 'Encode Alternate', `field_description` = 'Encode separate alternate copies of videos' WHERE `configuration`.`field` = 'encodeMobile';

INSERT INTO `metatags` (
`controller` ,
`mode` ,
`path` ,
`language` ,
`header_title` ,
`meta_title` ,
`meta_description` ,
`meta_keywords` ,
`robots` ,
`record_num`
)
VALUES (
'index', 'vr', '', 'EN', 'VR Videos', 'VR Videos - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', NULL
);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Jpegoptim Path', 'Path to jpegoptim binary', 'jpegoptim_path', '', '', '1', 'paths', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Jpegoptim Command Line', 'Command line used with jpegoptim', 'jpegoptim_command', '-m85 --strip-all', '', '1', 'encoder', '0', '', NULL);

ALTER TABLE `rss_feed` ADD `channels` VARCHAR( 1024 ) NOT NULL AFTER `bottom`;

INSERT INTO  `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('MojoCloud Object Storage Host',  'MojoCloud Object Storage Host',  'ceph_host',  '',  '',  '10',  'ceph',  '0',  '', NULL), ('MojoCloud Object Storage Key',  'MojoCloud Object Storage Key',  'ceph_key',  '',  '',  '9',  'ceph',  '0',  '', NULL), ('MojoCloud Object Storage Secret Key',  'MojoCloud Object Storage Secret Key',  'ceph_secret',  '',  '',  '8',  'ceph',  '0',  '', NULL), ('MojoCloud Object Storage Canonicle ID',  'MojoCloud Object Storage Canonicle ID',  'ceph_canonicle_id',  '',  '',  '7',  'ceph',  '0',  '', NULL), ('MojoCloud Object Storage Canonicle Name',  'MojoCloud Object Storage Canonicle Name',  'ceph_canonicle_name',  '',  '',  '6',  'ceph',  '0',  '', NULL);


INSERT INTO  `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('MojoCloud Bucket Name',  'MojoCloud Bucket Name',  'ceph_bucket',  '',  '',  '5',  'ceph',  '0',  '', NULL);


INSERT INTO  `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('MojoCloud Storage Enabled',  'MojoCloud Storage Enabled',  'ceph_enabled',  '0',  '{"true":1,"false":0}',  '4',  'ceph',  '0',  '', NULL);

INSERT INTO  `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('Delete Local Copies',  'Deletes local file after transfering to Cloud Storage',  'ceph_delete_local',  '0',  '{"true":1,"false":0}',  '4',  'ceph',  '0',  '', NULL);



INSERT INTO  `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`)VALUES ('CDN Invalidation Function',  'Name of CDN Invalidation Callback',  'cdn_invalidation_callback',  '',  '',  '10',  'cdn',  '0',  '', NULL);

ALTER TABLE `status` ADD `scraper_done` INT NOT NULL AFTER `scraper_running` , ADD `scraper_total` INT NOT NULL AFTER `scraper_done`;
ALTER TABLE `status` ADD `scraper_pid` INT NOT NULL AFTER `scraper_total`;
ALTER TABLE `status` ADD `scraper_processing` VARCHAR( 1024 ) NOT NULL AFTER `scraper_pid` , ADD `scraper_processing_output` VARCHAR( 1024 ) NOT NULL AFTER `scraper_processing`;
ALTER TABLE `scraper_import` ADD `approved` INT NOT NULL AFTER `paysite`;
ALTER TABLE `scraper_import` ADD `data` TEXT NOT NULL AFTER `paysite`;

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`) VALUES ('Enable 18+ Warning', 'Enable 18+ Warning', 'ageWarning', '0', '{"true":1,"false":0}', '99', 'general', '0', '', NULL);

INSERT INTO `configuration` (`field_name` ,`field_description` ,`field` ,`value` ,`data` ,`weight` ,`group` ,`localized` ,`settings` ,`record_num`) VALUES ('Enable GDPR Warning', 'Enable GDPR Warning', 'gdprWarning', '0', '{"true":1,"false":0}', '99', 'general', '0', '', NULL);

ALTER TABLE `status` ADD `encoder_pid` INT NOT NULL AFTER `encoder_done`;