Sha256: b33330edf36a70c5fe54b648d8d9e6598e03ad5073249cab4f09eff1440cb76d

Contents?: true

Size: 806 Bytes

Versions: 12

Compression:

Stored size: 806 Bytes

Contents

CREATE TABLE public.subscriptions_set_commands
(
    id                   bigserial                   NOT NULL,
    name                 character varying           NOT NULL,
    subscriptions_set_id uuid                        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

12 entries across 12 versions & 1 rubygems

Version Path
pg_eventstore-0.10.2 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-0.10.1 db/migrations/4_create_subscriptions_set_commands.sql
pg_eventstore-0.9.0 db/migrations/6_create_subscriptions_set_commands.sql
pg_eventstore-0.8.0 db/migrations/6_create_subscriptions_set_commands.sql
pg_eventstore-0.7.2 db/migrations/6_create_subscriptions_set_commands.sql
pg_eventstore-0.7.1 db/migrations/6_create_subscriptions_set_commands.sql
pg_eventstore-0.7.0 db/migrations/6_create_subscriptions_set_commands.sql
pg_eventstore-0.6.0 db/migrations/11_create_subscriptions_set_commands.sql
pg_eventstore-0.5.3 db/migrations/11_create_subscriptions_set_commands.sql
pg_eventstore-0.5.2 db/migrations/11_create_subscriptions_set_commands.sql
pg_eventstore-0.5.0 db/migrations/11_create_subscriptions_set_commands.sql
pg_eventstore-0.4.0 db/migrations/11_create_subscriptions_set_commands.sql