
START TRANSACTION;

ALTER TABLE `listings`  ADD COLUMN `is_featured` enum('T','F') DEFAULT 'F' AFTER `for`;

INSERT INTO `fields` VALUES (NULL, 'lblWebsiteFeaturedTip', 'backend', 'Label / Make featured tip', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '1', 'title', 'Featured yachts go at the top of all listed yachts and are marked as such. There is also a separate Featured Yachts listing formed by the yachts marked as "featured" that will be shown in the home page.', 'script');
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '2', 'title', 'Featured yachts go at the top of all listed yachts and are marked as such. There is also a separate Featured Yachts listing formed by the yachts marked as "featured" that will be shown in the home page.', 'script');
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '3', 'title', 'Featured yachts go at the top of all listed yachts and are marked as such. There is also a separate Featured Yachts listing formed by the yachts marked as "featured" that will be shown in the home page.', 'script');

COMMIT;