cosmo_backend/scripts/update_category_constraint.sql

-- Update check constraint for static_data table to include 'interstellar'
-- Run this manually via: python backend/scripts/run_sql.py backend/scripts/update_category_constraint.sql

ALTER TABLE static_data DROP CONSTRAINT IF EXISTS chk_category;

ALTER TABLE static_data
ADD CONSTRAINT chk_category
CHECK (category IN (
    'constellation', 
    'galaxy', 
    'star', 
    'nebula', 
    'cluster', 
    'asteroid_belt', 
    'kuiper_belt', 
    'interstellar'
));