-- Remove file_snapshots table as we've moved to Git-based version control
-- This removes the legacy snapshot-based revert system

-- First, drop any policies that might reference the file_snapshots table
-- These were created in migration 006 and updated in migration 021
DROP POLICY IF EXISTS "Users can view snapshots for their operations" ON file_snapshots;
DROP POLICY IF EXISTS "Users can create snapshots for their operations" ON file_snapshots;

-- Drop the file_snapshots table if it exists (CASCADE will drop dependent objects)
DROP TABLE IF EXISTS file_snapshots CASCADE;

-- Add comment to document the change
COMMENT ON SCHEMA public IS 'File snapshots table removed - using Git for version control instead of database snapshots';