init-db.sql

-- Initialize AuthServer database
-- This script runs when the PostgreSQL container starts for the first time

-- Create database if it doesn't exist (this is handled by POSTGRES_DB env var)
-- CREATE DATABASE IF NOT EXISTS "AuthServer";

-- Connect to the AuthServer database
\c "AuthServer";

-- Create extensions that might be useful
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "pgcrypto";

-- Grant permissions
GRANT ALL PRIVILEGES ON DATABASE "AuthServer" TO postgres;

-- Create indexes for better performance (will be created by EF migrations, but good to have)
-- These will be created automatically by Entity Framework migrations

-- Set timezone
SET timezone = 'UTC';

-- Log successful initialization
SELECT 'AuthServer database initialized successfully' AS status;