Spaces:
Sleeping
Sleeping
File size: 2,597 Bytes
287a0bc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
-- 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")
);
|