000-init.sql 556 B

123456789101112
  1. -- DataOps local test bootstrap. Executed only for a fresh Docker volume.
  2. SELECT 'CREATE DATABASE n8n'
  3. WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'n8n')\gexec
  4. \connect dataops
  5. CREATE EXTENSION IF NOT EXISTS vector;
  6. \ir /dataops-schema/create_data_orders_table.sql
  7. \ir /dataops-schema/add_data_source_to_data_orders.sql
  8. \ir /dataops-schema/create_data_products_table.sql
  9. \ir /dataops-schema/create_metadata_review_records_table.sql
  10. \ir /dataops-schema/create_metadata_version_history_table.sql
  11. \ir /dataops-schema/create_task_list_table.sql