17 lines
502 B
SQL
17 lines
502 B
SQL
-- 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
|
|
|