mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
20 lines
479 B
SQL
20 lines
479 B
SQL
-- Drop existing constraint
|
|
ALTER TABLE public.content_submissions
|
|
DROP CONSTRAINT IF EXISTS content_submissions_submission_type_check;
|
|
|
|
-- Add updated constraint including ride_model
|
|
ALTER TABLE public.content_submissions
|
|
ADD CONSTRAINT content_submissions_submission_type_check
|
|
CHECK (submission_type IN (
|
|
'park',
|
|
'ride',
|
|
'review',
|
|
'photo',
|
|
'manufacturer',
|
|
'operator',
|
|
'designer',
|
|
'property_owner',
|
|
'photo_edit',
|
|
'photo_delete',
|
|
'ride_model'
|
|
)); |