
START TRANSACTION;

INSERT INTO `options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_featured_jobs', 1, '3', NULL, 'int', 6, 1, NULL);

INSERT INTO `fields` VALUES (NULL, 'lblMakeFeatured', 'backend', 'Label / Make featured', 'script', '2015-08-13 06:39:21');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Make featured', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblFeaturedTip', 'backend', 'Label / Make featured tip', 'script', '2015-08-13 06:41:06');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Featured jobs go at the top of all listed jobs and are marked as such. There is also a separate Featured Jobs listing formed by the jobs marked as "featured" that can be integrated on website page, other than the main jobs listing. See Install menu for Featured Jobs integration code.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblInstallFeatured', 'backend', 'Label / Featured jobs', 'script', '2015-08-13 07:02:10');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Featured jobs', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblInstallPhp3Title', 'backend', 'Label / Install featured jobs', 'script', '2015-08-13 07:03:34');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Follow these steps to insert the Featured Jobs listing on your .php web page using PHP include code:', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblInstallFeat_1', 'backend', 'Label / Install featured step 1', 'script', '2015-08-13 07:05:04');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Step 1. Copy and paste the code below at the very top of your .php page. It should be line 1 of your .php web page.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblInstallFeat_2', 'backend', 'Label / Install featured step 2', 'script', '2015-08-13 07:05:34');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Step 2. Copy and paste the code below into your html code, where featured jobs will be displayed.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblInstallFeat_3', 'backend', 'Label / Install featured step 3', 'script', '2015-08-13 07:06:03');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Step 3. Copy and paste the code below at the very bottom of your .php web page after all the other code.', 'script');

COMMIT;