mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
17 lines
812 B
SQL
17 lines
812 B
SQL
-- Phase 8: Remove Duplicate Indexes
|
|
-- All duplicate indexes verified as identical via pg_indexes
|
|
|
|
-- 1. content_submissions: Keep newer lock management index (idx_content_submissions_locks)
|
|
DROP INDEX IF EXISTS public.idx_submissions_assigned;
|
|
|
|
-- 2. parks: Keep original park_type index (idx_parks_park_type)
|
|
DROP INDEX IF EXISTS public.idx_parks_type;
|
|
|
|
-- 3. photo_submissions: Keep more descriptive name (idx_photo_submissions_submission_id)
|
|
DROP INDEX IF EXISTS public.idx_photo_submissions_submission;
|
|
|
|
-- 4. ride_model_technical_specifications: Keep full name (idx_ride_model_technical_specs_search)
|
|
DROP INDEX IF EXISTS public.idx_ride_model_tech_specs_search;
|
|
|
|
-- 5. ride_technical_specifications: Keep full name (idx_ride_technical_specs_search)
|
|
DROP INDEX IF EXISTS public.idx_ride_tech_specs_search; |