-- Rregullon pershkrimin e badge-it Photo Contributor ne shqip dhe anglisht.
SET NAMES utf8mb4;
START TRANSACTION;

UPDATE `translates`
SET `value` = 'Ka shtuar foto ne vleresimet e publikuara.'
WHERE `key` = 'Has added photos to published reviews.' AND `lang` = 'sq';

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Has added photos to published reviews.', 'Ka shtuar foto ne vleresimet e publikuara.', 'dynamic', 'sq'
WHERE NOT EXISTS (
    SELECT 1 FROM `translates`
    WHERE `key` = 'Has added photos to published reviews.' AND `lang` = 'sq'
);

UPDATE `translates`
SET `value` = 'Has added photos to published reviews.'
WHERE `key` = 'Has added photos to published reviews.' AND `lang` = 'en';

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Has added photos to published reviews.', 'Has added photos to published reviews.', 'dynamic', 'en'
WHERE NOT EXISTS (
    SELECT 1 FROM `translates`
    WHERE `key` = 'Has added photos to published reviews.' AND `lang` = 'en'
);

COMMIT;