-- Migration: 091_personal_equipment_configurable_zustand
-- Makes the zustand field on persoenliche_ausruestung admin-configurable
-- by removing the hard-coded CHECK constraint and seeding default options
-- into app_settings.

-- 1. Drop the hard-coded CHECK constraint
ALTER TABLE persoenliche_ausruestung DROP CONSTRAINT IF EXISTS persoenliche_ausruestung_zustand_check;

-- 2. Seed default zustand options into app_settings
INSERT INTO app_settings (key, value)
VALUES (
  'personal_equipment_zustand_options',
  '[{"key":"gut","label":"Gut","color":"success"},{"key":"beschaedigt","label":"Beschädigt","color":"warning"},{"key":"abgaengig","label":"Abgängig","color":"error"},{"key":"verloren","label":"Verloren","color":"default"}]'
)
ON CONFLICT (key) DO NOTHING;
