mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
12 lines
535 B
SQL
12 lines
535 B
SQL
-- Add is_test_data column to profiles table for test data cleanup
|
|
-- This enables Playwright tests to mark and clean up test records
|
|
|
|
ALTER TABLE public.profiles
|
|
ADD COLUMN IF NOT EXISTS is_test_data BOOLEAN DEFAULT false NOT NULL;
|
|
|
|
-- Add index for efficient test data cleanup queries
|
|
CREATE INDEX IF NOT EXISTS idx_profiles_is_test_data
|
|
ON public.profiles(is_test_data)
|
|
WHERE is_test_data = true;
|
|
|
|
COMMENT ON COLUMN public.profiles.is_test_data IS 'Flag indicating this is test data that should be cleaned up by automated tests'; |