-- Create test database for DBIS Core Lite
-- Run with: psql -U postgres -f scripts/create-test-db.sql

-- Drop database if it exists (use with caution)
-- DROP DATABASE IF EXISTS dbis_core_test;

-- Create test database
CREATE DATABASE dbis_core_test;

-- Connect to test database and create schema
\c dbis_core_test

-- The schema will be created by running migrations
-- After creating the database, run:
-- DATABASE_URL=postgresql://postgres:postgres@localhost:5432/dbis_core_test npm run migrate