-- Seed file for site certifications
-- This file creates sample certifications for clinical trial sites for development and testing

INSERT INTO site_certifications (
    uuid,
    site_uuid,
    certification_name,
    issued_date,
    expiry_date,
    created_at,
    updated_at
) VALUES 
-- University Medical Center Amsterdam - Cardiology Certifications
('cc0e8400-e29b-41d4-a716-446655440001', '880e8400-e29b-41d4-a716-446655440001', 'Good Clinical Practice (GCP) Certification', '2024-01-15', '2027-01-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440002', '880e8400-e29b-41d4-a716-446655440001', 'ISO 14155:2020 Clinical Investigation Certification', '2024-03-10', '2027-03-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440003', '880e8400-e29b-41d4-a716-446655440001', 'GDPR Compliance Certification', '2024-05-01', '2026-05-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440004', '880e8400-e29b-41d4-a716-446655440001', 'Joint Commission Hospital Accreditation', '2023-08-15', '2026-08-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440005', '880e8400-e29b-41d4-a716-446655440001', 'Medical Device Clinical Investigation Certification', '2024-02-20', '2027-02-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Charité - Universitätsmedizin Berlin Certifications
('cc0e8400-e29b-41d4-a716-446655440006', '880e8400-e29b-41d4-a716-446655440002', 'Good Clinical Practice (GCP) Certification', '2024-01-10', '2027-01-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440007', '880e8400-e29b-41d4-a716-446655440002', 'ICH-GCP E6(R2) Implementation Certification', '2024-04-15', '2027-04-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440008', '880e8400-e29b-41d4-a716-446655440002', 'GDPR Compliance Certification', '2024-06-01', '2026-06-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440009', '880e8400-e29b-41d4-a716-446655440002', 'German Federal Institute Quality Certification', '2023-09-30', '2026-09-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440010', '880e8400-e29b-41d4-a716-446655440002', 'Clinical Research Organization Accreditation', '2024-03-05', '2027-03-05', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Assistance Publique - Hôpitaux de Paris Certifications
('cc0e8400-e29b-41d4-a716-446655440011', '880e8400-e29b-41d4-a716-446655440003', 'Good Clinical Practice (GCP) Certification', '2024-02-01', '2027-02-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440012', '880e8400-e29b-41d4-a716-446655440003', 'ANSM Clinical Trial Authorization', '2024-01-20', '2027-01-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440013', '880e8400-e29b-41d4-a716-446655440003', 'GDPR Compliance Certification', '2024-05-15', '2026-05-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440014', '880e8400-e29b-41d4-a716-446655440003', 'French Hospital Accreditation (HAS)', '2023-10-10', '2026-10-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440015', '880e8400-e29b-41d4-a716-446655440003', 'Pharmacovigilance System Certification', '2024-04-01', '2027-04-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Charité Cancer Center Berlin Certifications
('cc0e8400-e29b-41d4-a716-446655440016', '880e8400-e29b-41d4-a716-446655440004', 'Good Clinical Practice (GCP) Certification', '2024-01-25', '2027-01-25', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440017', '880e8400-e29b-41d4-a716-446655440004', 'Oncology Clinical Trial Specialization', '2024-02-10', '2027-02-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440018', '880e8400-e29b-41d4-a716-446655440004', 'GDPR Compliance Certification', '2024-06-15', '2026-06-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440019', '880e8400-e29b-41d4-a716-446655440004', 'Cancer Center Accreditation', '2023-07-20', '2026-07-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440020', '880e8400-e29b-41d4-a716-446655440004', 'Precision Medicine Laboratory Certification', '2024-03-15', '2027-03-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Netherlands Cancer Institute Certifications
('cc0e8400-e29b-41d4-a716-446655440021', '880e8400-e29b-41d4-a716-446655440005', 'Good Clinical Practice (GCP) Certification', '2024-02-05', '2027-02-05', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440022', '880e8400-e29b-41d4-a716-446655440005', 'OECI Cancer Center Accreditation', '2023-11-01', '2026-11-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440023', '880e8400-e29b-41d4-a716-446655440005', 'GDPR Compliance Certification', '2024-05-20', '2026-05-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440024', '880e8400-e29b-41d4-a716-446655440005', 'ISO 15189 Medical Laboratory Accreditation', '2024-01-30', '2027-01-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440025', '880e8400-e29b-41d4-a716-446655440005', 'Biobanking Quality Certification', '2024-04-10', '2027-04-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Institut Gustave Roussy Certifications
('cc0e8400-e29b-41d4-a716-446655440026', '880e8400-e29b-41d4-a716-446655440006', 'Good Clinical Practice (GCP) Certification', '2024-01-30', '2027-01-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440027', '880e8400-e29b-41d4-a716-446655440006', 'ANSM Clinical Trial Authorization', '2024-02-15', '2027-02-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440028', '880e8400-e29b-41d4-a716-446655440006', 'GDPR Compliance Certification', '2024-06-01', '2026-06-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440029', '880e8400-e29b-41d4-a716-446655440006', 'French National Cancer Institute Accreditation', '2023-12-15', '2026-12-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440030', '880e8400-e29b-41d4-a716-446655440006', 'Early Phase Clinical Trials Certification', '2024-03-20', '2027-03-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Salpêtrière Hospital - Neurology Department Certifications
('cc0e8400-e29b-41d4-a716-446655440031', '880e8400-e29b-41d4-a716-446655440007', 'Good Clinical Practice (GCP) Certification', '2024-02-10', '2027-02-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440032', '880e8400-e29b-41d4-a716-446655440007', 'Neurology Clinical Trial Specialization', '2024-01-15', '2027-01-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440033', '880e8400-e29b-41d4-a716-446655440007', 'GDPR Compliance Certification', '2024-05-30', '2026-05-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440034', '880e8400-e29b-41d4-a716-446655440007', 'French Hospital Accreditation (HAS)', '2023-08-25', '2026-08-25', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440035', '880e8400-e29b-41d4-a716-446655440007', 'Movement Disorders Clinical Assessment Certification', '2024-04-05', '2027-04-05', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- VU Medical Center - Neurology Certifications
('cc0e8400-e29b-41d4-a716-446655440036', '880e8400-e29b-41d4-a716-446655440008', 'Good Clinical Practice (GCP) Certification', '2024-02-15', '2027-02-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440037', '880e8400-e29b-41d4-a716-446655440008', 'ISO 14155:2020 Clinical Investigation Certification', '2024-03-01', '2027-03-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440038', '880e8400-e29b-41d4-a716-446655440008', 'GDPR Compliance Certification', '2024-06-10', '2026-06-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440039', '880e8400-e29b-41d4-a716-446655440008', 'Dutch Healthcare Quality Institute Accreditation', '2023-09-15', '2026-09-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440040', '880e8400-e29b-41d4-a716-446655440008', 'Neurological Assessment Battery Certification', '2024-01-20', '2027-01-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Diabeter - Center for Pediatric and Adolescent Diabetes Care Certifications (Planning phase)
('cc0e8400-e29b-41d4-a716-446655440041', '880e8400-e29b-41d4-a716-446655440009', 'Good Clinical Practice (GCP) Certification', '2024-12-01', '2027-12-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440042', '880e8400-e29b-41d4-a716-446655440009', 'Pediatric Clinical Trial Specialization', '2024-11-15', '2027-11-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440043', '880e8400-e29b-41d4-a716-446655440009', 'GDPR Compliance Certification', '2024-12-20', '2026-12-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440044', '880e8400-e29b-41d4-a716-446655440009', 'Dutch Pediatric Healthcare Accreditation', '2024-10-30', '2027-10-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440045', '880e8400-e29b-41d4-a716-446655440009', 'Medical Device Clinical Investigation Certification', '2025-01-10', '2028-01-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Berlin Institute for Respiratory Medicine Certifications (Completed trial)
('cc0e8400-e29b-41d4-a716-446655440046', '880e8400-e29b-41d4-a716-446655440010', 'Good Clinical Practice (GCP) Certification', '2023-01-15', '2026-01-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440047', '880e8400-e29b-41d4-a716-446655440010', 'Pulmonary Function Testing Certification', '2023-02-01', '2026-02-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440048', '880e8400-e29b-41d4-a716-446655440010', 'GDPR Compliance Certification', '2023-05-01', '2025-05-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440049', '880e8400-e29b-41d4-a716-446655440010', 'German Federal Institute Quality Certification', '2023-03-20', '2026-03-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440050', '880e8400-e29b-41d4-a716-446655440010', 'COPD Clinical Trial Specialization', '2023-04-10', '2026-04-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Additional specialized certifications for high-performing sites
('cc0e8400-e29b-41d4-a716-446655440051', '880e8400-e29b-41d4-a716-446655440001', 'Clinical Data Management Certification', '2024-07-15', '2027-07-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440052', '880e8400-e29b-41d4-a716-446655440002', 'Risk-Based Monitoring Certification', '2024-08-01', '2027-08-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440053', '880e8400-e29b-41d4-a716-446655440003', 'Electronic Source Documentation Certification', '2024-06-20', '2027-06-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440054', '880e8400-e29b-41d4-a716-446655440004', 'Biomarker Analysis Laboratory Certification', '2024-05-05', '2027-05-05', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440055', '880e8400-e29b-41d4-a716-446655440005', 'Digital Health Technology Certification', '2024-09-10', '2027-09-10', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Emergency and safety certifications
('cc0e8400-e29b-41d4-a716-446655440056', '880e8400-e29b-41d4-a716-446655440001', 'Emergency Response Protocol Certification', '2024-03-25', '2026-03-25', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440057', '880e8400-e29b-41d4-a716-446655440002', 'Adverse Event Reporting System Certification', '2024-04-30', '2026-04-30', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440058', '880e8400-e29b-41d4-a716-446655440003', 'Patient Safety Management Certification', '2024-02-28', '2026-02-28', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440059', '880e8400-e29b-41d4-a716-446655440007', 'Clinical Trial Insurance Certification', '2024-01-05', '2026-01-05', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('cc0e8400-e29b-41d4-a716-446655440060', '880e8400-e29b-41d4-a716-446655440008', 'Data Security and Privacy Certification', '2024-07-01', '2026-07-01', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)

ON CONFLICT (uuid) DO NOTHING;
