-- Initialize databases for Acudo development
-- This script runs when the PostgreSQL container is first created

-- Create test database for running tests
CREATE DATABASE acudo_test;

-- Grant permissions to postgres user (already has superuser, but being explicit)
GRANT ALL PRIVILEGES ON DATABASE acudo TO postgres;
GRANT ALL PRIVILEGES ON DATABASE acudo_test TO postgres;