db.migration.V1__Initial.sql Maven / Gradle / Ivy

Go to download
CREATE TABLE cmd
(
    id              int IDENTITY PRIMARY KEY,
    aggregateId     nvarchar(255)  NOT NULL,
    nextExecution   datetime       NOT NULL,
    retries         INTEGER        NOT NULL,
    serializationId nvarchar(255)  NOT NULL,
    error           BIT            NOT NULL,
    errorId         nvarchar(255),
    data            nvarchar(max) NOT NULL
)

CREATE TABLE saga
(
    correlationId   nvarchar(255)  NOT NULL,
    serializationId nvarchar(255)  NOT NULL,
    data            nvarchar(max) NOT NULL,
    CONSTRAINT PK_saga PRIMARY KEY (correlationId, serializationId),
)

CREATE TABLE timeout
(
    sagaCorrelationId   nvarchar(255)  NOT NULL,
    sagaSerializationId nvarchar(255)  NOT NULL,
    timeoutId           nvarchar(255)  NOT NULL,
    timeout             datetime       NOT NULL,
    error               BIT            NOT NULL,
    errorId             nvarchar(255),
    CONSTRAINT PK_timeout PRIMARY KEY (sagaCorrelationId, sagaSerializationId, timeoutId),
)

CREATE TABLE hwm
(
    subscriber nvarchar(512) primary key,
    hwm INTEGER NOT NULL
)