-- TechnicalProtocols — تفريغ ثم إدخال البروتوكولات الجديدة
-- EN: https://ghe.contracts.2uz.net/seeds/protocols/
-- AR: https://ghe.contracts.2uz.net/seeds/protocols_ar/
--
-- إن لم يكن عمود ProtocolNameAr موجوداً، نفّذ أولاً:
-- ALTER TABLE `TechnicalProtocols`
--   ADD COLUMN `ProtocolNameAr` VARCHAR(255) NOT NULL DEFAULT '' AFTER `ProtocolName`;

DELETE FROM `TechnicalProtocols`;

INSERT INTO `TechnicalProtocols`
  (`ProtocolName`, `ProtocolNameAr`, `ProtocolSource`, `CreatedDate`, `ProtocolUrl`, `ProtocolUrlAr`, `OfficialProtocolUrl`, `SortOrder`, `IsActive`)
VALUES
  (
    'Green House Bed Bug Management Guidelines',
    'إرشادات البيت الأخضر لإدارة بق الفراش',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/cdc_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/cdc_ar.pdf',
    '',
    1,
    1
  ),
  (
    'Customer Preparation Guide for Bed Bug Treatment',
    'دليل تحضير العميل لمعالجة بق الفراش',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/customer_prep_bed_bug_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/customer_prep_bed_bug_ar.pdf',
    '',
    2,
    1
  ),
  (
    'Pest Control File',
    'ملف إدارة الآفات',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/pest_control_file_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/pest_control_file_ar.pdf',
    '',
    3,
    1
  ),
  (
    'Technical protocol for the protection of facilities',
    'البروتوكول الفني لحماية المنشآت',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/facility_protection_protocol_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/facility_protection_protocol_ar.pdf',
    '',
    4,
    1
  ),
  (
    'Record corrective actions and verification for the Environmental Monitoring Program (EMP)',
    'سجل الإجراءات التصحيحية والتحقق لبرنامج المراقبة البيئية (EMP)',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/emp_corrective_actions_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/emp_corrective_actions_ar.pdf',
    '',
    5,
    1
  ),
  (
    'Integrated Rodent Management Protocol',
    'بروتوكول الإدارة المتكاملة للقوارض',
    'Green House',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/rodent_control_protocol_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/rodent_control_protocol_ar.pdf',
    '',
    6,
    1
  ),
  (
    'International Code of Conduct on Pesticide Management',
    'مدونة السلوك الدولية بشأن إدارة المبيدات',
    'WHO / FAO',
    '2014-01-01',
    'https://ghe.contracts.2uz.net/seeds/protocols/who_fao_pesticide_code_of_conduct_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/who_fao_pesticide_code_of_conduct_ar.pdf',
    'https://www.fao.org/pest-and-pesticide-management/pesticide-risk-reduction/code-conduct/en/',
    7,
    1
  ),
  (
    'Chemical Safety in the Workplace',
    'السلامة الكيميائية في بيئة العمل',
    'WHO',
    '2026-07-13',
    'https://ghe.contracts.2uz.net/seeds/protocols/who_chemical_safety_occupational_en.pdf',
    'https://ghe.contracts.2uz.net/seeds/protocols_ar/who_chemical_safety_occupational_ar.pdf',
    '',
    8,
    1
  );
