flai/init.sql at main · eloxt/flai · GitHub

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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
CREATE TABLE "public"."conversation" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" text COLLATE "pg_catalog"."default" NOT NULL,
  "title" text COLLATE "pg_catalog"."default" NOT NULL,
  "created_at" timestamp(6) NOT NULL,
  "updated_at" timestamp(6) NOT NULL,
  "deleted_at" timestamp(6),
  "icon" text COLLATE "pg_catalog"."default",
  "favourite" int2,
  CONSTRAINT "conversation_pkey" PRIMARY KEY ("id")
)
;

CREATE TABLE "public"."file" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" text COLLATE "pg_catalog"."default" NOT NULL,
  "hash" text COLLATE "pg_catalog"."default",
  "file_name" text COLLATE "pg_catalog"."default",
  "mime_type" text COLLATE "pg_catalog"."default",
  "size" int4,
  "path" text COLLATE "pg_catalog"."default",
  "created_at" timestamp(6) NOT NULL,
  "public_url" text COLLATE "pg_catalog"."default",
  CONSTRAINT "file_pkey" PRIMARY KEY ("id")
)
;

CREATE TABLE "public"."mcp" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" text COLLATE "pg_catalog"."default",
  "name" text COLLATE "pg_catalog"."default",
  "connection_type" text COLLATE "pg_catalog"."default",
  "endpoint" text COLLATE "pg_catalog"."default",
  "headers" jsonb,
  "tools" jsonb,
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "deleted_at" timestamp(6),
  "is_active" int2,
  CONSTRAINT "mcp_pkey" PRIMARY KEY ("id")
)
;

CREATE TABLE "public"."message" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "conversation_id" text COLLATE "pg_catalog"."default",
  "parent_id" text COLLATE "pg_catalog"."default" NOT NULL,
  "content" jsonb,
  "created_at" timestamp(6) NOT NULL,
  "deleted_at" timestamp(6),
  "role" text COLLATE "pg_catalog"."default",
  "meta_info" jsonb,
  "tsv_content" tsvector GENERATED ALWAYS AS (
jsonb_to_tsvector('zhcfg'::regconfig, content, '["string"]'::jsonb)
) STORED,
  CONSTRAINT "message_pkey" PRIMARY KEY ("id")
)
;

CREATE INDEX "idx_gin_zh_search" ON "public"."message" USING gin (
  "tsv_content" "pg_catalog"."tsvector_ops"
);

CREATE TABLE "public"."provider" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "name" text COLLATE "pg_catalog"."default" NOT NULL,
  "api_key" text COLLATE "pg_catalog"."default" NOT NULL,
  "provider_type" text COLLATE "pg_catalog"."default" NOT NULL,
  "base_url" text COLLATE "pg_catalog"."default",
  "model" jsonb,
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "deleted_at" timestamp(6),
  "logo" text COLLATE "pg_catalog"."default",
  "is_active" int2,
  CONSTRAINT "provider_pkey" PRIMARY KEY ("id")
)
;

CREATE TABLE "public"."share" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" text COLLATE "pg_catalog"."default" NOT NULL,
  "conversation" jsonb,
  "message" jsonb,
  "created_at" timestamp(6) NOT NULL,
  "deleted_at" timestamp(6),
  "expires_at" timestamp(6),
  CONSTRAINT "share_pkey" PRIMARY KEY ("id")
)
;

CREATE TABLE "public"."system_config" (
  "key" text COLLATE "pg_catalog"."default" NOT NULL,
  "value" jsonb,
  CONSTRAINT "system_config_pkey" PRIMARY KEY ("key")
)
;

CREATE TABLE "public"."user" (
  "id" text COLLATE "pg_catalog"."default" NOT NULL,
  "email" text COLLATE "pg_catalog"."default" NOT NULL,
  "username" text COLLATE "pg_catalog"."default" NOT NULL,
  "password" text COLLATE "pg_catalog"."default" NOT NULL,
  "role" text COLLATE "pg_catalog"."default" NOT NULL,
  "is_active" int2 NOT NULL,
  "created_at" timestamp(6) NOT NULL,
  "updated_at" timestamp(6) NOT NULL,
  "deleted_at" timestamp(6),
  "avatar" bytea,
  "preference" jsonb,
  CONSTRAINT "user_pkey" PRIMARY KEY ("id")
)
;