Sha256: 7512810189a0ab0f9f1306318d0e35d478b53f7423afb4bab2ee50326c715312

Contents?: true

Size: 708 Bytes

Versions: 5

Compression:

Stored size: 708 Bytes

Contents

-- ----------------------------
--  Table structure for messages
-- ----------------------------
CREATE TABLE IF NOT EXISTS "public"."messages" (
  "id" UUID NOT NULL DEFAULT gen_random_uuid(),
  "stream_name" text NOT NULL COLLATE "default",
  "type" text NOT NULL COLLATE "default",
  "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
)
WITH (OIDS=FALSE);

-- ----------------------------
--  Primary key structure for table messages
-- ----------------------------
ALTER TABLE "public"."messages" ADD PRIMARY KEY ("global_position") NOT DEFERRABLE INITIALLY IMMEDIATE;

Version data entries

5 entries across 5 versions & 1 rubygems

Version Path
evt-message_store-postgres-database-1.1.0.2 database/table/messages.sql
evt-message_store-postgres-database-1.1.0.1 database/table/messages.sql
evt-message_store-postgres-database-1.1.0.0 database/table/messages.sql
evt-message_store-postgres-database-1.0.0.0 database/table/messages.sql
evt-message_store-postgres-database-0.11.0.0 database/table/messages.sql