-- MySQL dump 10.14  Distrib 5.5.65-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: konrad_627
-- ------------------------------------------------------
-- Server version	5.5.65-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `biller_log`
--

DROP TABLE IF EXISTS `biller_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `biller_log` (
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `biller` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `record_num` (`record_num`),
  KEY `date` (`date`,`biller`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `biller_log`
--

LOCK TABLES `biller_log` WRITE;
/*!40000 ALTER TABLE `biller_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `biller_log` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blocks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blocks` WRITE;
/*!40000 ALTER TABLE `blocks` DISABLE KEYS */;
/*!40000 ALTER TABLE `blocks` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blocks_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blocks_languages` WRITE;
/*!40000 ALTER TABLE `blocks_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `blocks_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `cache_data` longtext NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `configuration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=166 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `configuration` WRITE;
/*!40000 ALTER TABLE `configuration` DISABLE KEYS */;
INSERT INTO `configuration` 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 20 -b 1000k -bt 1000k -y -v 0 -bf 16 -threads 0','',1,'encoder',0,'',33),('FFMPEG Alternate Command Line','Command line used for encoding ffmpeg alternate videos','ffmpeg_mobile_command','-acodec aac -keyint_min 20 -r 20 -vcodec libx264 -crf 24 -b 300k -bt 300k -y -v 0 -bf 16 -threads 0','',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 Alternate','Encode separate alternate copies of videos','encodeMobile','0','{\"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),('Player Settings - Display Overlay Ad','Displays template_name/widgets/widget.inplayer_ad.php overtop of the player.','displayPlayerOverlay','1',' {\"true\":1,\"false\":0}',1,'player',0,'',111),('Scene Selection on Desktop','Display scene selection under player on desktop devices.','sceneSelectionDesktop','1','{\"true\":1,\"false\":0}',0,'player',0,'',112),('Scene Selection on Mobile','Display scene selection under player on mobile devices.','sceneSelectionMobile','1','{\"true\":1,\"false\":0}',0,'player',0,'',113),('CCBill Postback Enabled?','Enables CCBill Postback Script. For use with monthly membership sites only!','ccbillPostbackEnabled','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',114),('Epoch Postback Enabled?','Enables Epoch Postback Script. For use with monthly membership sites only!','epochPostbackEnabled','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',115),('Paysite Mode','Enables Paysite mode and determines what non-premium users see.','paysiteMode','0','{\"thumbnails\":2,\"trailers\":1,\"false\":0}',1,'payment_gateway',0,'',116),('Enable VOD Mode','Enables VOD Token System. Disable all biller postbacks when using this!','vodMode','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',117),('VOD Rental Duration','Duration of VOD Rentals in Seconds (1 Day = 86400 Seconds)','vodRentalLength','86400','',1,'payment_gateway',0,'',118),('VOD Rental Token Cost','Default Cost of VOD Rental in Tokens','vodRentalCost','1','',1,'payment_gateway',0,'',119),('Netbilling Postback Enabled?','Enables Netbilling Postback Script','netbillingPostbackEnabled','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',120),('Verotel Postback Enabled?','Enables Verotel Postback Script','verotelPostbackEnabled','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',121),('Portrait Mode Scaling','Toggles taller video player on Portrait mode videos','stretchPortrait','0','{\"true\":1,\"false\":0}',1,'player',0,'',122),('Homepage $ads Paysite','Paysite ID Number used for $ads array on non-video page','homepagePaysite','1','',1,'general',0,'',123),('Hash Expiration','Expiration time for hash in seconds (example: 1800)','hashTime','','',17,'player',0,'',124),('Hash Key','Key for HashFunction','hashKey','','',16,'player',0,'',125),('Hash URI','URI for HashFunction','hashURI','','',18,'player',0,'',126),('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,'',127),('Random Views','Enables random views when publishing','randomViewsEnabled','0','{\"true\":1,\"false\":0}',30,'general',0,'',128),('Random Views Range Min','Minimum range for random views','randomViewsMin','0','',31,'general',0,'',129),('Random Views Range Max','Maximum range for random views','randomViewsMax','10000','',31,'general',0,'',130),('Player Function','Function name of Player used on Video page','playerFunction','displayPlayerFluidplayer','',16,'player',0,'',131),('Delight URL','URL for Delight VR Javascript','delightJSURL','','',17,'player',0,'',132),('dl8-customization-primary-color','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-primary-color','','',17,'player',0,'',133),('dl8-customization-secondary-color','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-secondary-color','','',17,'player',0,'',134),('dl8-customization-brand-name','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-brand-name','','',17,'player',0,'',135),('dl8-customization-brand-logo','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-brand-logo','','',17,'player',0,'',136),('dl8-customization-brand-watermark-logo','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-brand-watermark-logo','','',17,'player',0,'',137),('dl8-customization-brand-url','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-brand-url','','',17,'player',0,'',138),('dl8-customization-no-brand-logo','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-no-brand-logo','','',17,'player',0,'',139),('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,'',140),('dl8-customization-no-content-badge','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-no-content-badge','','',17,'player',0,'',141),('dl8-customization-no-compass','Delight VR Customization - SEE https://delight-vr.com/documentation/customization/','dl8-customization-no-compass','','',17,'player',0,'',142),('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,'',143),('Delight-VR Audio Formats','Available formats for delight-vr video player audio (comma separated)','delightAudioFormats','normal,ambix','',17,'player',0,'',144),('Delight-VR CORS Fallback','CORS fallback URL for delight','cors-fallback-url','','',17,'player',0,'',145),('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,'',146),('Jpegoptim Path','Path to jpegoptim binary','jpegoptim_path','','',1,'paths',0,'',147),('Jpegoptim Command Line','Command line used with jpegoptim','jpegoptim_command','-m85 --strip-all','',1,'encoder',0,'',148),('MojoCloud Object Storage Host','MojoCloud Object Storage Host','ceph_host','','',10,'ceph',0,'',149),('MojoCloud Object Storage Key','MojoCloud Object Storage Key','ceph_key','','',9,'ceph',0,'',150),('MojoCloud Object Storage Secret Key','MojoCloud Object Storage Secret Key','ceph_secret','','',8,'ceph',0,'',151),('MojoCloud Object Storage Canonicle ID','MojoCloud Object Storage Canonicle ID','ceph_canonicle_id','','',7,'ceph',0,'',152),('MojoCloud Object Storage Canonicle Name','MojoCloud Object Storage Canonicle Name','ceph_canonicle_name','','',6,'ceph',0,'',153),('MojoCloud Bucket Name','MojoCloud Bucket Name','ceph_bucket','','',5,'ceph',0,'',154),('MojoCloud Storage Enabled','MojoCloud Storage Enabled','ceph_enabled','0','{\"true\":1,\"false\":0}',4,'ceph',0,'',155),('Delete Local Copies','Deletes local file after transfering to Cloud Storage','ceph_delete_local','0','{\"true\":1,\"false\":0}',4,'ceph',0,'',156),('CDN Invalidation Function','Name of CDN Invalidation Callback','cdn_invalidation_callback','','',10,'cdn',0,'',157),('Enable 18+ Warning','Enable 18+ Warning','ageWarning','0','{\"true\":1,\"false\":0}',99,'general',0,'',158),('Enable GDPR Warning','Enable GDPR Warning','gdprWarning','0','{\"true\":1,\"false\":0}',99,'general',0,'',159),('Fluidplayer VAST Preroll','Fluidplayer VAST Preroll URL','fluidplayer_vast_preroll','','',10,'player',0,'',160),('Fluidplayer VAST Midroll','Fluidplayer VAST Midroll URL','fluidplayer_vast_midroll','','',10,'player',0,'',161),('Fluidplayer VAST Midroll Timer','How long after video start midroll plays in seconds','fluidplayer_vast_midroll_timer','60','',10,'player',0,'',162),('Fluidplayer VAST Postroll','Fluidplayer VAST Postroll URL','fluidplayer_vast_postroll','','',10,'player',0,'',163),('Segpay Postback Enabled?','Enables Segpay Postback Script','segpayPostbackEnabled','0','{\"true\":1,\"false\":0}',1,'payment_gateway',0,'',164),('Redirect Signup','Redirects signup page to specified URL (IE To biller payment page)','redirectSignupURL','','',100,'payment_gateway',0,'',165);
/*!40000 ALTER TABLE `configuration` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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',
  `tokenCost` int(11) NOT NULL,
  `access_level` int(11) NOT NULL DEFAULT '0',
  `vr` int(11) NOT NULL DEFAULT '0',
  `vrData` text NOT NULL,
  `fps` int(11) NOT NULL,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content` WRITE;
/*!40000 ALTER TABLE `content` DISABLE KEYS */;
/*!40000 ALTER TABLE `content` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_crc32`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_crc32` (
  `checksum` varchar(255) NOT NULL,
  `content` int(11) NOT NULL,
  KEY `checksum` (`checksum`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_crc32` WRITE;
/*!40000 ALTER TABLE `content_crc32` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_crc32` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_deleted`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_deleted` (
  `content` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `data` mediumtext NOT NULL,
  UNIQUE KEY `content` (`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_deleted` WRITE;
/*!40000 ALTER TABLE `content_deleted` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_deleted` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_languages` WRITE;
/*!40000 ALTER TABLE `content_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_niches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_niches` (
  `content` int(11) NOT NULL DEFAULT '0',
  `niche` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `content` (`content`,`niche`),
  KEY `niche` (`niche`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_niches` WRITE;
/*!40000 ALTER TABLE `content_niches` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_niches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_pornstars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_pornstars` (
  `content` int(11) NOT NULL,
  `pornstar` int(11) NOT NULL,
  UNIQUE KEY `content` (`content`,`pornstar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_pornstars` WRITE;
/*!40000 ALTER TABLE `content_pornstars` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_pornstars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `content_purchased`
--

DROP TABLE IF EXISTS `content_purchased`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_purchased` (
  `user` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `expires` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `content` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `record_num` (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `content_purchased`
--

LOCK TABLES `content_purchased` WRITE;
/*!40000 ALTER TABLE `content_purchased` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_purchased` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_search`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_search` WRITE;
/*!40000 ALTER TABLE `content_search` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_search` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_views`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_views` (
  `views` int(11) NOT NULL,
  `content` int(11) NOT NULL,
  PRIMARY KEY (`content`),
  KEY `views` (`views`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_views` WRITE;
/*!40000 ALTER TABLE `content_views` DISABLE KEYS */;
/*!40000 ALTER TABLE `content_views` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=238 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` 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');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `csv_failures`
--

DROP TABLE IF EXISTS `csv_failures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `csv_failures` (
  `date` datetime NOT NULL,
  `csv_data` text NOT NULL,
  `failure` text NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`),
  UNIQUE KEY `record_num` (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `csv_failures`
--

LOCK TABLES `csv_failures` WRITE;
/*!40000 ALTER TABLE `csv_failures` DISABLE KEYS */;
/*!40000 ALTER TABLE `csv_failures` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `csv_import`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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` varchar(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,
  `jsondata` longtext NOT NULL,
  `vr` int(11) NOT NULL DEFAULT '0',
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `csv_import` WRITE;
/*!40000 ALTER TABLE `csv_import` DISABLE KEYS */;
/*!40000 ALTER TABLE `csv_import` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `csv_import_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `csv_import_list` WRITE;
/*!40000 ALTER TABLE `csv_import_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `csv_import_list` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `csv_import_photos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `csv_import_photos` WRITE;
/*!40000 ALTER TABLE `csv_import_photos` DISABLE KEYS */;
/*!40000 ALTER TABLE `csv_import_photos` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `dvd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `dvd` WRITE;
/*!40000 ALTER TABLE `dvd` DISABLE KEYS */;
/*!40000 ALTER TABLE `dvd` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `dvd_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `dvd_languages` WRITE;
/*!40000 ALTER TABLE `dvd_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `dvd_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` 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);
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `email_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `email_translations` WRITE;
/*!40000 ALTER TABLE `email_translations` DISABLE KEYS */;
INSERT INTO `email_translations` 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);
/*!40000 ALTER TABLE `email_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `favorites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `favorites` WRITE;
/*!40000 ALTER TABLE `favorites` DISABLE KEYS */;
/*!40000 ALTER TABLE `favorites` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `fields` WRITE;
/*!40000 ALTER TABLE `fields` DISABLE KEYS */;
INSERT INTO `fields` 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);
/*!40000 ALTER TABLE `fields` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `fields_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `fields_values` WRITE;
/*!40000 ALTER TABLE `fields_values` DISABLE KEYS */;
INSERT INTO `fields_values` 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);
/*!40000 ALTER TABLE `fields_values` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `friends`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `friends` WRITE;
/*!40000 ALTER TABLE `friends` DISABLE KEYS */;
/*!40000 ALTER TABLE `friends` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `images` WRITE;
/*!40000 ALTER TABLE `images` DISABLE KEYS */;
/*!40000 ALTER TABLE `images` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `keywords`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keywords` (
  `word` varchar(64) NOT NULL,
  `amount` int(11) NOT NULL,
  KEY `word` (`word`),
  KEY `amount` (`amount`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `keywords` WRITE;
/*!40000 ALTER TABLE `keywords` DISABLE KEYS */;
/*!40000 ALTER TABLE `keywords` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `link_shortener`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `link_shortener` WRITE;
/*!40000 ALTER TABLE `link_shortener` DISABLE KEYS */;
INSERT INTO `link_shortener` VALUES ('warcraft-trailer','http://mb6.mechbunny.com/video/watch-warcraft-trailer-for-the-epic-movie-online-10539.html',2);
/*!40000 ALTER TABLE `link_shortener` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `locales_source`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `locales_source` WRITE;
/*!40000 ALTER TABLE `locales_source` DISABLE KEYS */;
INSERT INTO `locales_source` VALUES (1,'Home',''),(2,'Login',''),(3,'Signup',''),(4,'Sign up',''),(5,'Change colors',''),(6,'Movies',''),(7,'Most Recent',''),(8,'Most Viewed',''),(9,'Top Rated',''),(10,'Most Discussed',''),(11,'Longest',''),(12,'VR',''),(13,'Albums',''),(14,'Categories',''),(15,'See All',''),(16,'Models',''),(17,'Community',''),(18,'Paysites',''),(19,'Tags',''),(20,'Search',''),(21,'All',''),(22,'Videos',''),(23,'Photos',''),(24,'Network',''),(25,'Upload',''),(26,'UPLOAD',''),(27,'ALL',''),(28,'HD',''),(29,'More',''),(30,'Hide',''),(31,'Being Watched Now',''),(32,'See more',''),(33,'Most Viewed Videos',''),(34,'- select -',''),(35,'Newest',''),(36,'Sorry, no results were found.',''),(37,'See all',''),(38,'New Releases',''),(39,'Account',''),(40,'Create free account',''),(41,'Contact',''),(42,'Other products',''),(43,'DMCA Notice',''),(44,'Terms of Use',''),(45,'18 U.S.C. 2257 Record-Keeping Requirements Compliance Statement','');
/*!40000 ALTER TABLE `locales_source` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `locales_target`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `locales_target` WRITE;
/*!40000 ALTER TABLE `locales_target` DISABLE KEYS */;
/*!40000 ALTER TABLE `locales_target` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `mail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `mail` WRITE;
/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `mb_api_endpoints`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `mb_api_endpoints` WRITE;
/*!40000 ALTER TABLE `mb_api_endpoints` DISABLE KEYS */;
INSERT INTO `mb_api_endpoints` VALUES ('test.tube.mechbunny.com','http://test.tube.mechbunny.com/api/','newest','',5,2);
/*!40000 ALTER TABLE `mb_api_endpoints` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `metatags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `metatags` WRITE;
/*!40000 ALTER TABLE `metatags` DISABLE KEYS */;
INSERT INTO `metatags` 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),('index','my-rentals','','EN','My Rentals','My Rentals - {{SITENAME}}','{{DESCRIPTION}}','{{KEYWORDS}}','',51),('Tags','','','EN','Tags','Tags - {{SITENAME}}','{{DESCRIPTION}}','{{KEYWORDS}}','',52),('buyTokens','','','EN','Buy Tokens','Buy Tokens - {{SITENAME}}','{{DESCRIPTION}}','{{KEYWORDS}}','',53),('rentVideo','','','EN','Confirm Purchase','Confirm Purchase - {{SITENAME}}','{{DESCRIPTION}}','{{KEYWORDS}}','',54),('index','vr','','EN','VR Videos','VR Videos - {{SITENAME}}','{{DESCRIPTION}}','{{KEYWORDS}}','',55);
/*!40000 ALTER TABLE `metatags` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `niches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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',
  `paysite` int(11) NOT NULL,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `niches` WRITE;
/*!40000 ALTER TABLE `niches` DISABLE KEYS */;
/*!40000 ALTER TABLE `niches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `niches_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `niches_languages` WRITE;
/*!40000 ALTER TABLE `niches_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `niches_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `paysites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `paysites` WRITE;
/*!40000 ALTER TABLE `paysites` DISABLE KEYS */;
INSERT INTO `paysites` VALUES ('Default','','',0,'','','','','','','','','','','','','','','',1,'',1);
/*!40000 ALTER TABLE `paysites` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `paysites_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `paysites_languages` WRITE;
/*!40000 ALTER TABLE `paysites_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `paysites_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pornstars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pornstars` WRITE;
/*!40000 ALTER TABLE `pornstars` DISABLE KEYS */;
/*!40000 ALTER TABLE `pornstars` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pornstars_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pornstars_languages` WRITE;
/*!40000 ALTER TABLE `pornstars_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `pornstars_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `ratings` WRITE;
/*!40000 ALTER TABLE `ratings` DISABLE KEYS */;
/*!40000 ALTER TABLE `ratings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` 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);
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `reported_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `reported_comments` WRITE;
/*!40000 ALTER TABLE `reported_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `reported_comments` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `reported_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `reported_content` WRITE;
/*!40000 ALTER TABLE `reported_content` DISABLE KEYS */;
/*!40000 ALTER TABLE `reported_content` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `rss_feed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rss_feed` (
  `name` varchar(255) NOT NULL,
  `feed` text NOT NULL,
  `top` text NOT NULL,
  `bottom` text NOT NULL,
  `channels` varchar(1024) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `rss_feed` WRITE;
/*!40000 ALTER TABLE `rss_feed` DISABLE KEYS */;
INSERT INTO `rss_feed` 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);
/*!40000 ALTER TABLE `rss_feed` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `scraper_import`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scraper_import` (
  `url` varchar(255) NOT NULL,
  `user` int(11) NOT NULL,
  `paysite` int(11) NOT NULL,
  `data` text NOT NULL,
  `approved` int(11) NOT NULL,
  `record_num` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`record_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `scraper_import` WRITE;
/*!40000 ALTER TABLE `scraper_import` DISABLE KEYS */;
/*!40000 ALTER TABLE `scraper_import` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `scraper_import_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `scraper_import_log` WRITE;
/*!40000 ALTER TABLE `scraper_import_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `scraper_import_log` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `servers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `servers` WRITE;
/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `static`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `static`
--

LOCK TABLES `static` WRITE;
/*!40000 ALTER TABLE `static` DISABLE KEYS */;
/*!40000 ALTER TABLE `static` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `static_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `static_languages`
--

LOCK TABLES `static_languages` WRITE;
/*!40000 ALTER TABLE `static_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `static_languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `scraper_running` int(11) NOT NULL,
  `scraper_done` int(11) NOT NULL,
  `scraper_total` int(11) NOT NULL,
  `scraper_pid` int(11) NOT NULL,
  `scraper_processing` varchar(1024) NOT NULL,
  `scraper_processing_output` varchar(1024) NOT NULL,
  `encoder_running` int(11) NOT NULL,
  `encoder_done` int(11) NOT NULL,
  `encoder_pid` 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (0,0,0,0,'','',0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_logins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_logins`
--

LOCK TABLES `user_logins` WRITE;
/*!40000 ALTER TABLE `user_logins` DISABLE KEYS */;
INSERT INTO `user_logins` VALUES ('2020-12-03 17:00:37','admin','185.56.210.218','Admin Login Successful',1);
/*!40000 ALTER TABLE `user_logins` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users_notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users_notifications` WRITE;
/*!40000 ALTER TABLE `users_notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_tokens`
--

DROP TABLE IF EXISTS `users_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_tokens` (
  `user` int(11) NOT NULL,
  `tokens` int(11) NOT NULL,
  UNIQUE KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_tokens`
--

LOCK TABLES `users_tokens` WRITE;
/*!40000 ALTER TABLE `users_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_tokens` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `watch_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `watch_log` WRITE;
/*!40000 ALTER TABLE `watch_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `watch_log` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `xml_feeds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `xml_feeds` WRITE;
/*!40000 ALTER TABLE `xml_feeds` DISABLE KEYS */;
/*!40000 ALTER TABLE `xml_feeds` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-12-03 17:13:28

INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES ('TubeCorporate Affiliate ID', 'Affiliate ID from Tube Corporate (from Dashboard)', 'tubecorporatePromo', '', '', '1', 'external', '0', '', NULL);

INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES ('TubeCorporate Embed Source ID', 'Embed Campaign Source ID (NOT the embed campaign ID!! You get this at bottom when creating embed campaign)', 'tubecorporateSource', '', '', '1', 'external', '0', '', NULL);

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