-- 006_seed_feedback_templates.sql
-- Manual one-shot: seed the four interview scorecard templates that the
-- evaluation form currently reads from frontend/src/data/seed.js evalTemplates.
--
-- Order: (1) alembic upgrade / autogenerate so app.feedback_templates exists,
-- (2) this file. Applied automatically at startup by alembic_setup.run_manual_sql()
-- once the schema is at head; recorded in manual_migrations. Safe to re-run by hand.

INSERT INTO app.feedback_templates (id, name, department, criteria, is_active, created_by, created_at, updated_at, is_deleted)
VALUES
    (gen_random_uuid(), 'Engineering — Technical', 'Engineering',
     '["Technical Skills","Problem Solving","System Design","Communication","Culture Fit"]'::json,
     true, NULL, NOW(), NOW(), false),
    (gen_random_uuid(), 'Product — PM Loop', 'Product',
     '["Product Sense","Analytical","Execution","Leadership","Communication"]'::json,
     true, NULL, NOW(), NOW(), false),
    (gen_random_uuid(), 'Design — Portfolio', 'Design',
     '["Craft","Process","Collaboration","Communication","Culture Fit"]'::json,
     true, NULL, NOW(), NOW(), false),
    (gen_random_uuid(), 'General — Behavioral', 'All',
     '["Communication","Technical","Problem Solving","Leadership","Culture Fit"]'::json,
     true, NULL, NOW(), NOW(), false)
ON CONFLICT (name) DO NOTHING;