go/coordinator/migrations/20231116210409.sql

-- Create "collection_metadata" table
CREATE TABLE "public"."collection_metadata" (
  "collection_id" text NOT NULL,
  "key" text NOT NULL,
  "str_value" text NULL,
  "int_value" bigint NULL,
  "float_value" numeric NULL,
  "ts" bigint NULL DEFAULT 0,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ("collection_id", "key")
);
-- Create "collections" table
CREATE TABLE "public"."collections" (
  "id" text NOT NULL,
  "name" text NULL,
  "topic" text NULL,
  "dimension" integer NULL,
  "database_id" text NULL,
  "ts" bigint NULL DEFAULT 0,
  "is_deleted" boolean NULL DEFAULT false,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ("id")
);
-- Create index "collections_name_key" to table: "collections"
CREATE UNIQUE INDEX "collections_name_key" ON "public"."collections" ("name");
-- Create "databases" table
CREATE TABLE "public"."databases" (
  "id" text NOT NULL,
  "name" character varying(128) NULL,
  "tenant_id" character varying(128) NULL,
  "ts" bigint NULL DEFAULT 0,
  "is_deleted" boolean NULL DEFAULT false,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ("id")
);
-- Create index "idx_tenantid_name" to table: "databases"
CREATE UNIQUE INDEX "idx_tenantid_name" ON "public"."databases" ("name", "tenant_id");
-- Create "segment_metadata" table
CREATE TABLE "public"."segment_metadata" (
  "segment_id" text NOT NULL,
  "key" text NOT NULL,
  "str_value" text NULL,
  "int_value" bigint NULL,
  "float_value" numeric NULL,
  "ts" bigint NULL DEFAULT 0,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ("segment_id", "key")
);
-- Create "segments" table
CREATE TABLE "public"."segments" (
  "id" text NOT NULL,
  "type" text NOT NULL,
  "scope" text NULL,
  "topic" text NULL,
  "ts" bigint NULL DEFAULT 0,
  "is_deleted" boolean NULL DEFAULT false,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "collection_id" text NULL,
  PRIMARY KEY ("id")
);
-- Create "tenants" table
CREATE TABLE "public"."tenants" (
  "id" text NOT NULL,
  "ts" bigint NULL DEFAULT 0,
  "is_deleted" boolean NULL DEFAULT false,
  "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ("id")
);