-- sql/00-init-extensions.sql
-- ============================================================================
-- DATABASE EXTENSIONS INITIALIZATION
-- ============================================================================
-- This script is automatically run by PostgreSQL on database creation
-- when placed in /docker-entrypoint-initdb.d/
--
-- It creates the required extensions before the schema is loaded.
-- ============================================================================

-- Enable UUID generation
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

-- Enable trigram fuzzy text search
CREATE EXTENSION IF NOT EXISTS pg_trgm;

-- Enable PostGIS for geographic queries (usually pre-installed in postgis image)
CREATE EXTENSION IF NOT EXISTS postgis;

-- Log completion
DO $$
BEGIN
  RAISE NOTICE '✅ All required PostgreSQL extensions have been created';
END $$;