USE samity360;
SET NAMES utf8mb4;
START TRANSACTION;

-- Member QR Card is a company-specific optional feature and is hidden by default.
INSERT INTO company_features(company_id,feature_key,is_enabled,enabled_by,enabled_at,notes)
SELECT c.id,'member_qr_card',0,
       (SELECT u.id FROM users u JOIN roles r ON r.id=u.role_id WHERE r.slug='developer' ORDER BY u.id LIMIT 1),
       NOW(),'Controls visibility and access to printable Member QR Cards.'
FROM companies c
WHERE c.deleted_at IS NULL
ON DUPLICATE KEY UPDATE feature_key=VALUES(feature_key);

-- Profile dropdown helper text.
INSERT INTO translations(language_code,translation_key,translation_value) VALUES
('en','profile.manage_account','Picture, details, language and password'),
('bn','profile.manage_account','ছবি, তথ্য, ভাষা ও পাসওয়ার্ড পরিচালনা করুন'),
('ar','profile.manage_account','إدارة الصورة والبيانات واللغة وكلمة المرور'),
('en','profile.end_session','End the current session'),
('bn','profile.end_session','বর্তমান সেশন শেষ করুন'),
('ar','profile.end_session','إنهاء الجلسة الحالية')
ON DUPLICATE KEY UPDATE translation_value=VALUES(translation_value);

COMMIT;