
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_o_facebook_api_key");
UPDATE `multi_lang` SET `content` = 'Facebook API ID' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_o_linkedin_api_key");
UPDATE `multi_lang` SET `content` = 'LinkedIn Client ID' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_o_linkedin_api_secret");
UPDATE `multi_lang` SET `content` = 'LinkedIn Client Secret' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;