-- Migration: Remove tier system completely
-- Date: 2024-08-30
-- Description: Drop tier column and enum as the tier system is no longer needed

-- Drop the tier column from memories table
ALTER TABLE memories DROP COLUMN IF EXISTS tier;

-- Drop the index on tier column
DROP INDEX IF EXISTS idx_memories_tier;

-- Drop the memory_tier enum type
DROP TYPE IF EXISTS memory_tier;

-- Update any views or functions that might reference tier
-- (none currently exist, but good practice to check)