Sha256: 36300d377cfca9a35786021c9a4c265e1925d1e5a720ca15cf75e1799daeff6c

Contents?: true

Size: 881 Bytes

Versions: 14

Compression:

Stored size: 881 Bytes

Contents

CREATE TABLE public.streams
(
    id              bigserial         NOT NULL,
    context         character varying NOT NULL,
    stream_name     character varying NOT NULL,
    stream_id       character varying NOT NULL,
    stream_revision int DEFAULT -1    NOT NULL
);

CREATE TABLE public.events
(
    id              uuid                        NOT NULL DEFAULT public.gen_random_uuid(),
    stream_id       bigint                      NOT NULL,
    type            character varying           NOT NULL,
    global_position bigserial                   NOT NULL,
    stream_revision int                         NOT NULL,
    data            jsonb                       NOT NULL DEFAULT '{}'::jsonb,
    metadata        jsonb                       NOT NULL DEFAULT '{}'::jsonb,
    link_id         uuid,
    created_at      timestamp without time zone NOT NULL DEFAULT now()
);

Version data entries

14 entries across 14 versions & 1 rubygems

Version Path
pg_eventstore-0.6.0 db/initial/tables.sql
pg_eventstore-0.5.3 db/initial/tables.sql
pg_eventstore-0.5.2 db/initial/tables.sql
pg_eventstore-0.5.0 db/initial/tables.sql
pg_eventstore-0.4.0 db/initial/tables.sql
pg_eventstore-0.3.0 db/initial/tables.sql
pg_eventstore-0.2.6 db/initial/tables.sql
pg_eventstore-0.2.5 db/initial/tables.sql
pg_eventstore-0.2.4 db/initial/tables.sql
pg_eventstore-0.2.3 db/initial/tables.sql
pg_eventstore-0.2.2 db/initial/tables.sql
pg_eventstore-0.2.1 db/initial/tables.sql
pg_eventstore-0.2.0 db/initial/tables.sql
pg_eventstore-0.1.0 db/tables.sql