DDL scripts as of 2022

lfgcampos · May 20, 2022, 1:57pm

The closest to what you are looking for is probably this

AxonIQ/initializr/blob/main/initializr-be/src/main/resources/configuration/axon-framework/flyway/create_axon_framework_related_tables_baseline.sql

-- this script is compatible with PostgreSQL only
-- to use in other databases please adapt the script

DROP TABLE IF EXISTS association_value_entry;
DROP TABLE IF EXISTS token_entry;
DROP TABLE IF EXISTS saga_entry;

CREATE TABLE IF NOT EXISTS association_value_entry
(
    id SERIAL,
    association_key VARCHAR(255) NOT NULL,
    association_value VARCHAR(255),
    saga_id VARCHAR(255) NOT NULL,
    saga_type VARCHAR(255),
    PRIMARY KEY (id)
    );

CREATE INDEX IF NOT EXISTS association_value_entry_saga_type_association_key_association_value_idx
    on association_value_entry (saga_type, association_key, association_value);

This file has been truncated. show original

Other than that, checking inside the AxonFramework code for entities and how they are generated is an option. Also exporting a DDL from a local/dev database is another option.

But no ‘official’ DDL out there AFAIK.

KR,