db.migration.V007__query_completion_event_table.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of benchto-service Show documentation

There is a newer version: 0.30

CREATE TABLE query_completion_event
(
  id             BIGSERIAL PRIMARY KEY NOT NULL,
  event          jsonb                 NOT NULL
);

ALTER TABLE executions ADD COLUMN query_completion_event_id BIGINT;
ALTER TABLE executions ADD FOREIGN KEY (query_completion_event_id) REFERENCES query_completion_event (id);