Contents

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

ALTER TABLE ONLY public.subscription_commands
    ADD CONSTRAINT subscription_commands_pkey PRIMARY KEY (id);

CREATE UNIQUE INDEX idx_subscription_commands_subscription_id_and_set_id_and_name ON public.subscription_commands USING btree (subscription_id, subscriptions_set_id, name);

ALTER TABLE ONLY public.subscription_commands
    ADD CONSTRAINT subscription_commands_subscription_fk FOREIGN KEY (subscription_id) REFERENCES public.subscriptions (id) ON DELETE CASCADE;

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

Version data entries

19 entries across 19 versions & 1 rubygems

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