io.descoped.rawdata.provider.postgres.init.init-topic-stream.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of rawdata-client-provider-postgres Show documentation

Rawdata Client Provider PostgreSQL Database

The newest version!

DROP TABLE IF EXISTS "TOPIC_content";
DROP TABLE IF EXISTS "TOPIC_positions";

CREATE TABLE "TOPIC_positions"
(
    ulid            uuid                     NOT NULL,
    ordering_group  varchar                      NULL,
    sequence_number bigint                   NOT NULL,
    position        varchar                  NOT NULL,
    ts              timestamp with time zone NOT NULL,
    PRIMARY KEY (ulid)
);

CREATE TABLE "TOPIC_content"
(
    ulid uuid    NOT NULL,
    name varchar NOT NULL,
    data bytea   NOT NULL,
    PRIMARY KEY (ulid, name)
);