INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES ('SE Friendly URLs', 'Search Engine Friendly URLs', 'seFriendly', '0', '{"true":1,"false":0}', '0', 'site', '0', '', NULL);

ALTER TABLE `custom_links` ADD `showInNav` INT NOT NULL AFTER `custom_text_alt`;

ALTER TABLE `custom_links` ADD `navigationAnchor` VARCHAR(255) NOT NULL AFTER `showInNav`;

ALTER TABLE `custom_links` ADD INDEX (`showInNav`, `navigationAnchor`);

INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`) VALUES
('Sidebar - Custom URLs', 'Enable/Disable Custom URLs in Sidebar', 'template_sidebar_custom', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Custom URLs Title', '', 'template_sidebar_custom_title', 'Quick Links', '', 1, 'default_v2', 0, '');


INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`) VALUES
('Sidebar - Custom URLs', 'Enable/Disable Custom URLs in Sidebar', 'template_sidebar_custom', '1', '{"true":1,"false":0}', 1, 'default', 0, ''),
('Sidebar - Custom URLs Title', '', 'template_sidebar_custom_title', 'Quick Links', '', 1, 'default', 0, '');


INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('1', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('2', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('3', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('4', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('5', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('7', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('8', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('10', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('11', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('12', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('13', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');

UPDATE paysites SET preferred = 'iframe_embed_revshare' WHERE record_num = '3';