17 lines
466 B
SQL
17 lines
466 B
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'
|
|
)); |