-- Initialize Xpeditis database

-- Create extensions
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "pg_trgm"; -- For fuzzy search

-- Create schemas
CREATE SCHEMA IF NOT EXISTS public;

-- Grant permissions
GRANT ALL ON SCHEMA public TO xpeditis;

-- Initial comment
COMMENT ON DATABASE xpeditis_dev IS 'Xpeditis Maritime Freight Booking Platform - Development Database';