Contents

CREATE TABLE public.subscription_commands
(
    id              bigserial                   NOT NULL,
    name            character varying           NOT NULL,
    subscription_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_name ON public.subscription_commands USING btree (subscription_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;

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
pg_eventstore-0.10.2	db/migrations/3_create_subscription_commands.sql
pg_eventstore-0.10.1	db/migrations/3_create_subscription_commands.sql
pg_eventstore-0.9.0	db/migrations/5_create_subscription_commands.sql
pg_eventstore-0.8.0	db/migrations/5_create_subscription_commands.sql
pg_eventstore-0.7.2	db/migrations/5_create_subscription_commands.sql
pg_eventstore-0.7.1	db/migrations/5_create_subscription_commands.sql
pg_eventstore-0.7.0	db/migrations/5_create_subscription_commands.sql
pg_eventstore-0.6.0	db/migrations/10_create_subscription_commands.sql
pg_eventstore-0.5.3	db/migrations/10_create_subscription_commands.sql
pg_eventstore-0.5.2	db/migrations/10_create_subscription_commands.sql
pg_eventstore-0.5.0	db/migrations/10_create_subscription_commands.sql
pg_eventstore-0.4.0	db/migrations/10_create_subscription_commands.sql