DataOps-platform/deploy/docker/postgres/init/000-init.sql

-- DataOps local test bootstrap. Executed only for a fresh Docker volume.
SELECT 'CREATE DATABASE n8n'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'n8n')\gexec

SELECT 'CREATE DATABASE kestra'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'kestra')\gexec

DO $$
BEGIN
    CREATE ROLE lightrag LOGIN PASSWORD 'lightrag-test-password';
EXCEPTION
    WHEN duplicate_object THEN NULL;
END $$;

SELECT 'CREATE DATABASE dataops_lightrag OWNER lightrag'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'dataops_lightrag')\gexec

\connect dataops
CREATE EXTENSION IF NOT EXISTS vector;
\ir /dataops-schema/create_data_orders_table.sql
\ir /dataops-schema/add_data_source_to_data_orders.sql
\ir /dataops-schema/create_data_products_table.sql
\ir /dataops-schema/create_metadata_review_records_table.sql
\ir /dataops-schema/create_metadata_version_history_table.sql
\ir /dataops-schema/create_task_list_table.sql