Sha256: 92df3fb4ddd0053e5fab171dc3f20e2094f052388112ae2462573b17278a7298

Contents?: true

Size: 806 Bytes

Versions: 21

Compression:

Stored size: 806 Bytes

Contents

CREATE TABLE public.subscriptions_set_commands
(
    id                   bigserial                   NOT NULL,
    name                 character varying           NOT NULL,
    subscriptions_set_id bigint                      NOT NULL,
    created_at           timestamp without time zone NOT NULL DEFAULT now()
);

ALTER TABLE ONLY public.subscriptions_set_commands
    ADD CONSTRAINT subscriptions_set_commands_pkey PRIMARY KEY (id);

CREATE UNIQUE INDEX idx_subscr_set_commands_subscriptions_set_id_and_name ON public.subscriptions_set_commands USING btree (subscriptions_set_id, name);

ALTER TABLE ONLY public.subscriptions_set_commands
    ADD CONSTRAINT subscriptions_set_commands_subscriptions_set_fk FOREIGN KEY (subscriptions_set_id) REFERENCES public.subscriptions_set (id) ON DELETE CASCADE;

Version data entries

21 entries across 21 versions & 1 rubygems

Version Path
pg_eventstore-1.9.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.8.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.7.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.6.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.5.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.4.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.3.4 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.3.3 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.3.2 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.3.1 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.3.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.2.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.5 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.4 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.3 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.2 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.1 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.1.0 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.0.4 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-1.0.0.rc2 db/migrations/4_create_subscriptions_set_commands.sql