Contents

CREATE TABLE IF NOT EXISTS message_store.messages (
  id UUID NOT NULL DEFAULT gen_random_uuid(),
  stream_name text NOT NULL,
  type text NOT NULL,
  position bigint NOT NULL,
  global_position bigserial NOT NULL,
  data jsonb,
  metadata jsonb,
  time TIMESTAMP WITHOUT TIME ZONE DEFAULT (now() AT TIME ZONE 'utc') NOT NULL
);

ALTER TABLE message_store.messages ADD PRIMARY KEY (global_position) NOT DEFERRABLE INITIALLY IMMEDIATE;

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
message-db-2.1.3	database/tables/messages.sql
message-db-2.1.2	database/tables/messages.sql
message-db-2.1.1	database/tables/messages.sql
message-db-2.1.0	database/tables/messages.sql
message-db-2.0.2	database/tables/messages.sql
message-db-2.0.1	database/tables/messages.sql
message-db-2.0.0	database/tables/messages.sql
message-db-1.1.3	database/tables/messages.sql
message-db-1.1.2	database/tables/messages.sql