ALTER TABLE `performers` ADD INDEX (`last_online`);

INSERT INTO `configuration` SET `field_name` = 'Cron Cleanup Days Old', `field_description` = 'When cronCleanup.php is run, it will delete models that have not been online in at least this many days.', `field` = 'cronCleanupDays', `value` = '90';

INSERT INTO `paysites` (`name`, `slug`, `functionName`, `apiData`, `apiDataFieldName`, `maxResults`, `parameters`, `parametersPlaceholder`, `wmReferral`, `preferred`, `preferredLink`, `logoImage`, `whitelist`, `whitelabel_domain`, `whitelabel_domain_placeholder`, `defaultModelText`, `last_log`, `settings_json`, `enabled`, `record_num`) VALUES ('SkyPrivate', 'skyprivate', 'skyprivateData', '', 'API URL', '1000', '', '', 'https://affiliates.whalehunter.cash/track/ODUwMS41Mi4xOC4xOC4wLjAuMC4wLjAuMC4wLjA', 'iframe_embed_revshare', 'chat_room_url', 'skyprivate.jpg', '', '', '', '', '', '', '1', '0');

ALTER TABLE `performers`  ADD FULLTEXT `gender` (`gender`, `tags`, `spoken_languages`, `race`, `hair`);

ALTER TABLE `performers` ADD FULLTEXT (`spoken_languages`);
ALTER TABLE `performers` ADD FULLTEXT (`tags`);
ALTER TABLE `performers` ADD FULLTEXT (`tags`);
ALTER TABLE `performers` ADD FULLTEXT (`hair`);
ALTER TABLE `performers` ADD FULLTEXT (`race`);
ALTER TABLE `performers` ADD FULLTEXT (`tags`,`persistentTags`);
ALTER TABLE `performers` ADD FULLTEXT (`tags`,`persistentTags`,`username`);

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


INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Header Button Background', '', 'headerButtonBackground', '#ff4157', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Header Text', '', 'headerButtonColor', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Main Background', '', 'mainBackground', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Header Background', '', 'headerBackground', '#1a1a1a', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Footer Background', '', 'footerBackground', '#1a1a1a', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Buttons Background', '', 'buttonsBackground', '#ff4157', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Buttons Text', '', 'buttonsColor', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Ethnicity Color', '', 'ethnicityColor', '#faf575', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Live Button Green', '', 'liveBtnGreen', '#028d08', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Live Button Text', '', 'liveBtnText', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Title Color', '', 'titleColor', '#191919', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Description Color', '', 'descriptionColor', '#454444', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Footer Link Color', '', 'footerLink', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Header Link Color', '', 'headerLink', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Search Header Background', '', 'searchHeaderBackground', '#ffffff', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Search Header Text', '', 'searchHeaderText', '#5d5b5b', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Input Background', '', 'inputBackground', '#434242', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Filter Title Background', '', 'filterTitleBackground', '#191919', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('About Text', '', 'aboutText', '#ff4157', '', '1', 'default_v3', '0', 'color', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Filters Background', '', 'filtersBackground', '#f3f1f1', '', '1', 'default_v3', '0', 'color', NULL);

UPDATE template_configuration SET settings = 'color' WHERE field LIKE '%color%' OR field LIKE '%foreground%' OR field LIKE '%background%'; 
UPDATE template_configuration SET settings = '' WHERE field = 'template_colors_enabled'; 
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Use Color Scheme', '', 'template_colors_enabled', '0', '', '1', 'default_v3', '0', '', NULL);

INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES
('Sidebar - Status', 'Enable/Disable Online Yes/No Filter in Sidebar', 'template_sidebar_status', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL ),
('Sidebar - Gender', 'Enable/Disable Gender Filter in Sidebar', 'template_sidebar_gender', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Sidebar - Age', 'Enable/Disable Age Filter in Sidebar', 'template_sidebar_age', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Sidebar - Tags', 'Enable/Disable Tag Filter in Sidebar', 'template_sidebar_tags', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Sidebar - Ethnicity', 'Enable/Disable Ethnicity Filter in Sidebar', 'template_sidebar_ethnicity', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Sidebar - Hair Color', 'Enable/Disable Hair Color Filter in Sidebar', 'template_sidebar_hair', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Adblock Check', 'Enable/Disable adblock check on webcam page', 'template_adblock_check', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Logo URL', 'Logo URL (use Logo Upload under Settings to Upload, or specify manually)', 'template_logo_url', '', '', 1, 'default_v3', 0, '', NULL),
('Homepage Top Text', '', 'template_homepage_top_text', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', '', 1, 'default_v3', 0, '', NULL),
('Sidebar - Custom URLs', 'Enable/Disable Custom URLs in Sidebar', 'template_sidebar_custom', '1', '{"true":1,"false":0}', 1, 'default_v3', 0, '', NULL),
('Sidebar - Custom URLs Title', '', 'template_sidebar_custom_title', 'Quick Links', '', 1, 'default_v3', 0, '', NULL);