1CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;
  2
  3CREATE TABLE public.access_tokens (
  4    id integer NOT NULL,
  5    user_id integer,
  6    hash character varying(128),
  7    impersonated_user_id integer
  8);
  9
 10CREATE SEQUENCE public.access_tokens_id_seq
 11    AS integer
 12    START WITH 1
 13    INCREMENT BY 1
 14    NO MINVALUE
 15    NO MAXVALUE
 16    CACHE 1;
 17
 18ALTER SEQUENCE public.access_tokens_id_seq OWNED BY public.access_tokens.id;
 19
 20CREATE TABLE public.breakpoints (
 21    id integer NOT NULL,
 22    project_id integer NOT NULL,
 23    "position" integer NOT NULL,
 24    log_message text,
 25    worktree_id bigint NOT NULL,
 26    path text NOT NULL,
 27    kind character varying NOT NULL
 28);
 29
 30CREATE SEQUENCE public.breakpoints_id_seq
 31    AS integer
 32    START WITH 1
 33    INCREMENT BY 1
 34    NO MINVALUE
 35    NO MAXVALUE
 36    CACHE 1;
 37
 38ALTER SEQUENCE public.breakpoints_id_seq OWNED BY public.breakpoints.id;
 39
 40CREATE TABLE public.buffer_operations (
 41    buffer_id integer NOT NULL,
 42    epoch integer NOT NULL,
 43    replica_id integer NOT NULL,
 44    lamport_timestamp integer NOT NULL,
 45    value bytea NOT NULL
 46);
 47
 48CREATE TABLE public.buffer_snapshots (
 49    buffer_id integer NOT NULL,
 50    epoch integer NOT NULL,
 51    text text NOT NULL,
 52    operation_serialization_version integer NOT NULL
 53);
 54
 55CREATE TABLE public.buffers (
 56    id integer NOT NULL,
 57    channel_id integer NOT NULL,
 58    epoch integer DEFAULT 0 NOT NULL,
 59    latest_operation_epoch integer,
 60    latest_operation_lamport_timestamp integer,
 61    latest_operation_replica_id integer
 62);
 63
 64CREATE SEQUENCE public.buffers_id_seq
 65    AS integer
 66    START WITH 1
 67    INCREMENT BY 1
 68    NO MINVALUE
 69    NO MAXVALUE
 70    CACHE 1;
 71
 72ALTER SEQUENCE public.buffers_id_seq OWNED BY public.buffers.id;
 73
 74CREATE TABLE public.channel_buffer_collaborators (
 75    id integer NOT NULL,
 76    channel_id integer NOT NULL,
 77    connection_id integer NOT NULL,
 78    connection_server_id integer NOT NULL,
 79    connection_lost boolean DEFAULT false NOT NULL,
 80    user_id integer NOT NULL,
 81    replica_id integer NOT NULL
 82);
 83
 84CREATE SEQUENCE public.channel_buffer_collaborators_id_seq
 85    AS integer
 86    START WITH 1
 87    INCREMENT BY 1
 88    NO MINVALUE
 89    NO MAXVALUE
 90    CACHE 1;
 91
 92ALTER SEQUENCE public.channel_buffer_collaborators_id_seq OWNED BY public.channel_buffer_collaborators.id;
 93
 94CREATE TABLE public.channel_chat_participants (
 95    id integer NOT NULL,
 96    user_id integer NOT NULL,
 97    channel_id integer NOT NULL,
 98    connection_id integer NOT NULL,
 99    connection_server_id integer NOT NULL
100);
101
102CREATE SEQUENCE public.channel_chat_participants_id_seq
103    AS integer
104    START WITH 1
105    INCREMENT BY 1
106    NO MINVALUE
107    NO MAXVALUE
108    CACHE 1;
109
110ALTER SEQUENCE public.channel_chat_participants_id_seq OWNED BY public.channel_chat_participants.id;
111
112CREATE TABLE public.channel_members (
113    id integer NOT NULL,
114    channel_id integer NOT NULL,
115    user_id integer NOT NULL,
116    accepted boolean DEFAULT false NOT NULL,
117    updated_at timestamp without time zone DEFAULT now() NOT NULL,
118    role text NOT NULL
119);
120
121CREATE SEQUENCE public.channel_members_id_seq
122    AS integer
123    START WITH 1
124    INCREMENT BY 1
125    NO MINVALUE
126    NO MAXVALUE
127    CACHE 1;
128
129ALTER SEQUENCE public.channel_members_id_seq OWNED BY public.channel_members.id;
130
131CREATE TABLE public.channels (
132    id integer NOT NULL,
133    name character varying NOT NULL,
134    created_at timestamp without time zone DEFAULT now() NOT NULL,
135    visibility text DEFAULT 'members'::text NOT NULL,
136    parent_path text NOT NULL,
137    requires_zed_cla boolean DEFAULT false NOT NULL,
138    channel_order integer DEFAULT 1 NOT NULL
139);
140
141CREATE SEQUENCE public.channels_id_seq
142    AS integer
143    START WITH 1
144    INCREMENT BY 1
145    NO MINVALUE
146    NO MAXVALUE
147    CACHE 1;
148
149ALTER SEQUENCE public.channels_id_seq OWNED BY public.channels.id;
150
151CREATE TABLE public.contacts (
152    id integer NOT NULL,
153    user_id_a integer NOT NULL,
154    user_id_b integer NOT NULL,
155    a_to_b boolean NOT NULL,
156    should_notify boolean NOT NULL,
157    accepted boolean NOT NULL
158);
159
160CREATE SEQUENCE public.contacts_id_seq
161    AS integer
162    START WITH 1
163    INCREMENT BY 1
164    NO MINVALUE
165    NO MAXVALUE
166    CACHE 1;
167
168ALTER SEQUENCE public.contacts_id_seq OWNED BY public.contacts.id;
169
170CREATE TABLE public.contributors (
171    user_id integer NOT NULL,
172    signed_at timestamp without time zone DEFAULT now() NOT NULL
173);
174
175CREATE TABLE public.extension_versions (
176    extension_id integer NOT NULL,
177    version text NOT NULL,
178    published_at timestamp without time zone DEFAULT now() NOT NULL,
179    authors text NOT NULL,
180    repository text NOT NULL,
181    description text NOT NULL,
182    download_count bigint DEFAULT 0 NOT NULL,
183    schema_version integer DEFAULT 0 NOT NULL,
184    wasm_api_version text,
185    provides_themes boolean DEFAULT false NOT NULL,
186    provides_icon_themes boolean DEFAULT false NOT NULL,
187    provides_languages boolean DEFAULT false NOT NULL,
188    provides_grammars boolean DEFAULT false NOT NULL,
189    provides_language_servers boolean DEFAULT false NOT NULL,
190    provides_context_servers boolean DEFAULT false NOT NULL,
191    provides_slash_commands boolean DEFAULT false NOT NULL,
192    provides_indexed_docs_providers boolean DEFAULT false NOT NULL,
193    provides_snippets boolean DEFAULT false NOT NULL,
194    provides_debug_adapters boolean DEFAULT false NOT NULL,
195    provides_agent_servers boolean DEFAULT false NOT NULL
196);
197
198CREATE TABLE public.extensions (
199    id integer NOT NULL,
200    name text NOT NULL,
201    external_id text NOT NULL,
202    latest_version text NOT NULL,
203    total_download_count bigint DEFAULT 0 NOT NULL
204);
205
206CREATE SEQUENCE public.extensions_id_seq
207    AS integer
208    START WITH 1
209    INCREMENT BY 1
210    NO MINVALUE
211    NO MAXVALUE
212    CACHE 1;
213
214ALTER SEQUENCE public.extensions_id_seq OWNED BY public.extensions.id;
215
216CREATE TABLE public.feature_flags (
217    id integer NOT NULL,
218    flag character varying(255) NOT NULL,
219    enabled_for_all boolean DEFAULT false NOT NULL
220);
221
222CREATE SEQUENCE public.feature_flags_id_seq
223    AS integer
224    START WITH 1
225    INCREMENT BY 1
226    NO MINVALUE
227    NO MAXVALUE
228    CACHE 1;
229
230ALTER SEQUENCE public.feature_flags_id_seq OWNED BY public.feature_flags.id;
231
232CREATE TABLE public.followers (
233    id integer NOT NULL,
234    room_id integer NOT NULL,
235    project_id integer NOT NULL,
236    leader_connection_server_id integer NOT NULL,
237    leader_connection_id integer NOT NULL,
238    follower_connection_server_id integer NOT NULL,
239    follower_connection_id integer NOT NULL
240);
241
242CREATE SEQUENCE public.followers_id_seq
243    AS integer
244    START WITH 1
245    INCREMENT BY 1
246    NO MINVALUE
247    NO MAXVALUE
248    CACHE 1;
249
250ALTER SEQUENCE public.followers_id_seq OWNED BY public.followers.id;
251
252CREATE TABLE public.language_servers (
253    project_id integer NOT NULL,
254    id bigint NOT NULL,
255    name character varying NOT NULL,
256    capabilities text NOT NULL,
257    worktree_id bigint
258);
259
260CREATE TABLE public.notification_kinds (
261    id integer NOT NULL,
262    name character varying NOT NULL
263);
264
265CREATE SEQUENCE public.notification_kinds_id_seq
266    AS integer
267    START WITH 1
268    INCREMENT BY 1
269    NO MINVALUE
270    NO MAXVALUE
271    CACHE 1;
272
273ALTER SEQUENCE public.notification_kinds_id_seq OWNED BY public.notification_kinds.id;
274
275CREATE TABLE public.notifications (
276    id integer NOT NULL,
277    created_at timestamp without time zone DEFAULT now() NOT NULL,
278    recipient_id integer NOT NULL,
279    kind integer NOT NULL,
280    entity_id integer,
281    content text,
282    is_read boolean DEFAULT false NOT NULL,
283    response boolean
284);
285
286CREATE SEQUENCE public.notifications_id_seq
287    AS integer
288    START WITH 1
289    INCREMENT BY 1
290    NO MINVALUE
291    NO MAXVALUE
292    CACHE 1;
293
294ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;
295
296CREATE TABLE public.observed_buffer_edits (
297    user_id integer NOT NULL,
298    buffer_id integer NOT NULL,
299    epoch integer NOT NULL,
300    lamport_timestamp integer NOT NULL,
301    replica_id integer NOT NULL
302);
303
304CREATE TABLE public.project_collaborators (
305    id integer NOT NULL,
306    project_id integer NOT NULL,
307    connection_id integer NOT NULL,
308    user_id integer NOT NULL,
309    replica_id integer NOT NULL,
310    is_host boolean NOT NULL,
311    connection_server_id integer NOT NULL,
312    committer_name character varying,
313    committer_email character varying
314);
315
316CREATE SEQUENCE public.project_collaborators_id_seq
317    AS integer
318    START WITH 1
319    INCREMENT BY 1
320    NO MINVALUE
321    NO MAXVALUE
322    CACHE 1;
323
324ALTER SEQUENCE public.project_collaborators_id_seq OWNED BY public.project_collaborators.id;
325
326CREATE TABLE public.project_repositories (
327    project_id integer NOT NULL,
328    abs_path character varying,
329    id bigint NOT NULL,
330    legacy_worktree_id bigint,
331    entry_ids character varying,
332    branch character varying,
333    scan_id bigint NOT NULL,
334    is_deleted boolean NOT NULL,
335    current_merge_conflicts character varying,
336    branch_summary character varying,
337    head_commit_details character varying,
338    merge_message character varying,
339    remote_upstream_url character varying,
340    remote_origin_url character varying
341);
342
343CREATE TABLE public.project_repository_statuses (
344    project_id integer NOT NULL,
345    repository_id bigint NOT NULL,
346    repo_path character varying NOT NULL,
347    status bigint NOT NULL,
348    status_kind integer NOT NULL,
349    first_status integer,
350    second_status integer,
351    scan_id bigint NOT NULL,
352    is_deleted boolean NOT NULL
353);
354
355CREATE TABLE public.projects (
356    id integer NOT NULL,
357    host_user_id integer,
358    unregistered boolean DEFAULT false NOT NULL,
359    room_id integer,
360    host_connection_id integer,
361    host_connection_server_id integer,
362    windows_paths boolean DEFAULT false
363);
364
365CREATE SEQUENCE public.projects_id_seq
366    AS integer
367    START WITH 1
368    INCREMENT BY 1
369    NO MINVALUE
370    NO MAXVALUE
371    CACHE 1;
372
373ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;
374
375CREATE TABLE public.room_participants (
376    id integer NOT NULL,
377    room_id integer NOT NULL,
378    user_id integer NOT NULL,
379    answering_connection_id integer,
380    location_kind integer,
381    location_project_id integer,
382    initial_project_id integer,
383    calling_user_id integer NOT NULL,
384    calling_connection_id integer NOT NULL,
385    answering_connection_lost boolean DEFAULT false NOT NULL,
386    answering_connection_server_id integer,
387    calling_connection_server_id integer,
388    participant_index integer,
389    role text
390);
391
392CREATE SEQUENCE public.room_participants_id_seq
393    AS integer
394    START WITH 1
395    INCREMENT BY 1
396    NO MINVALUE
397    NO MAXVALUE
398    CACHE 1;
399
400ALTER SEQUENCE public.room_participants_id_seq OWNED BY public.room_participants.id;
401
402CREATE TABLE public.rooms (
403    id integer NOT NULL,
404    live_kit_room character varying NOT NULL,
405    channel_id integer
406);
407
408CREATE SEQUENCE public.rooms_id_seq
409    AS integer
410    START WITH 1
411    INCREMENT BY 1
412    NO MINVALUE
413    NO MAXVALUE
414    CACHE 1;
415
416ALTER SEQUENCE public.rooms_id_seq OWNED BY public.rooms.id;
417
418CREATE TABLE public.servers (
419    id integer NOT NULL,
420    environment character varying NOT NULL
421);
422
423CREATE SEQUENCE public.servers_id_seq
424    AS integer
425    START WITH 1
426    INCREMENT BY 1
427    NO MINVALUE
428    NO MAXVALUE
429    CACHE 1;
430
431ALTER SEQUENCE public.servers_id_seq OWNED BY public.servers.id;
432
433CREATE TABLE public.shared_threads (
434    id uuid NOT NULL,
435    user_id integer NOT NULL,
436    title text NOT NULL,
437    data bytea NOT NULL,
438    created_at timestamp without time zone DEFAULT now() NOT NULL,
439    updated_at timestamp without time zone DEFAULT now() NOT NULL
440);
441
442CREATE TABLE public.user_features (
443    user_id integer NOT NULL,
444    feature_id integer NOT NULL
445);
446
447CREATE TABLE public.users (
448    id integer NOT NULL,
449    github_login character varying,
450    admin boolean NOT NULL,
451    email_address character varying(255) DEFAULT NULL::character varying,
452    invite_code character varying(64),
453    invite_count integer DEFAULT 0 NOT NULL,
454    inviter_id integer,
455    connected_once boolean DEFAULT false NOT NULL,
456    created_at timestamp without time zone DEFAULT now() NOT NULL,
457    github_user_id integer NOT NULL,
458    metrics_id uuid DEFAULT gen_random_uuid() NOT NULL,
459    accepted_tos_at timestamp without time zone,
460    github_user_created_at timestamp without time zone,
461    custom_llm_monthly_allowance_in_cents integer,
462    name text
463);
464
465CREATE SEQUENCE public.users_id_seq
466    AS integer
467    START WITH 1
468    INCREMENT BY 1
469    NO MINVALUE
470    NO MAXVALUE
471    CACHE 1;
472
473ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
474
475CREATE TABLE public.worktree_diagnostic_summaries (
476    project_id integer NOT NULL,
477    worktree_id bigint NOT NULL,
478    path character varying NOT NULL,
479    language_server_id bigint NOT NULL,
480    error_count integer NOT NULL,
481    warning_count integer NOT NULL
482);
483
484CREATE TABLE public.worktree_entries (
485    project_id integer NOT NULL,
486    worktree_id bigint NOT NULL,
487    id bigint NOT NULL,
488    is_dir boolean NOT NULL,
489    path character varying NOT NULL,
490    inode bigint NOT NULL,
491    mtime_seconds bigint NOT NULL,
492    mtime_nanos integer NOT NULL,
493    is_symlink boolean DEFAULT false NOT NULL,
494    is_ignored boolean NOT NULL,
495    scan_id bigint,
496    is_deleted boolean,
497    git_status bigint,
498    is_external boolean DEFAULT false NOT NULL,
499    is_fifo boolean DEFAULT false NOT NULL,
500    canonical_path text,
501    is_hidden boolean DEFAULT false NOT NULL
502);
503
504CREATE TABLE public.worktree_settings_files (
505    project_id integer NOT NULL,
506    worktree_id bigint NOT NULL,
507    path character varying NOT NULL,
508    content text NOT NULL,
509    kind character varying
510);
511
512CREATE TABLE public.worktrees (
513    project_id integer NOT NULL,
514    id bigint NOT NULL,
515    root_name character varying NOT NULL,
516    abs_path character varying NOT NULL,
517    visible boolean NOT NULL,
518    scan_id bigint NOT NULL,
519    is_complete boolean DEFAULT false NOT NULL,
520    completed_scan_id bigint
521);
522
523ALTER TABLE ONLY public.access_tokens ALTER COLUMN id SET DEFAULT nextval('public.access_tokens_id_seq'::regclass);
524
525ALTER TABLE ONLY public.breakpoints ALTER COLUMN id SET DEFAULT nextval('public.breakpoints_id_seq'::regclass);
526
527ALTER TABLE ONLY public.buffers ALTER COLUMN id SET DEFAULT nextval('public.buffers_id_seq'::regclass);
528
529ALTER TABLE ONLY public.channel_buffer_collaborators ALTER COLUMN id SET DEFAULT nextval('public.channel_buffer_collaborators_id_seq'::regclass);
530
531ALTER TABLE ONLY public.channel_chat_participants ALTER COLUMN id SET DEFAULT nextval('public.channel_chat_participants_id_seq'::regclass);
532
533ALTER TABLE ONLY public.channel_members ALTER COLUMN id SET DEFAULT nextval('public.channel_members_id_seq'::regclass);
534
535ALTER TABLE ONLY public.channels ALTER COLUMN id SET DEFAULT nextval('public.channels_id_seq'::regclass);
536
537ALTER TABLE ONLY public.contacts ALTER COLUMN id SET DEFAULT nextval('public.contacts_id_seq'::regclass);
538
539ALTER TABLE ONLY public.extensions ALTER COLUMN id SET DEFAULT nextval('public.extensions_id_seq'::regclass);
540
541ALTER TABLE ONLY public.feature_flags ALTER COLUMN id SET DEFAULT nextval('public.feature_flags_id_seq'::regclass);
542
543ALTER TABLE ONLY public.followers ALTER COLUMN id SET DEFAULT nextval('public.followers_id_seq'::regclass);
544
545ALTER TABLE ONLY public.notification_kinds ALTER COLUMN id SET DEFAULT nextval('public.notification_kinds_id_seq'::regclass);
546
547ALTER TABLE ONLY public.notifications ALTER COLUMN id SET DEFAULT nextval('public.notifications_id_seq'::regclass);
548
549ALTER TABLE ONLY public.project_collaborators ALTER COLUMN id SET DEFAULT nextval('public.project_collaborators_id_seq'::regclass);
550
551ALTER TABLE ONLY public.projects ALTER COLUMN id SET DEFAULT nextval('public.projects_id_seq'::regclass);
552
553ALTER TABLE ONLY public.room_participants ALTER COLUMN id SET DEFAULT nextval('public.room_participants_id_seq'::regclass);
554
555ALTER TABLE ONLY public.rooms ALTER COLUMN id SET DEFAULT nextval('public.rooms_id_seq'::regclass);
556
557ALTER TABLE ONLY public.servers ALTER COLUMN id SET DEFAULT nextval('public.servers_id_seq'::regclass);
558
559ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
560
561ALTER TABLE ONLY public.access_tokens
562    ADD CONSTRAINT access_tokens_pkey PRIMARY KEY (id);
563
564ALTER TABLE ONLY public.breakpoints
565    ADD CONSTRAINT breakpoints_pkey PRIMARY KEY (id);
566
567ALTER TABLE ONLY public.buffer_operations
568    ADD CONSTRAINT buffer_operations_pkey PRIMARY KEY (buffer_id, epoch, lamport_timestamp, replica_id);
569
570ALTER TABLE ONLY public.buffer_snapshots
571    ADD CONSTRAINT buffer_snapshots_pkey PRIMARY KEY (buffer_id, epoch);
572
573ALTER TABLE ONLY public.buffers
574    ADD CONSTRAINT buffers_pkey PRIMARY KEY (id);
575
576ALTER TABLE ONLY public.channel_buffer_collaborators
577    ADD CONSTRAINT channel_buffer_collaborators_pkey PRIMARY KEY (id);
578
579ALTER TABLE ONLY public.channel_chat_participants
580    ADD CONSTRAINT channel_chat_participants_pkey PRIMARY KEY (id);
581
582ALTER TABLE ONLY public.channel_members
583    ADD CONSTRAINT channel_members_pkey PRIMARY KEY (id);
584
585ALTER TABLE ONLY public.channels
586    ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
587
588ALTER TABLE ONLY public.contacts
589    ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
590
591ALTER TABLE ONLY public.contributors
592    ADD CONSTRAINT contributors_pkey PRIMARY KEY (user_id);
593
594ALTER TABLE ONLY public.extension_versions
595    ADD CONSTRAINT extension_versions_pkey PRIMARY KEY (extension_id, version);
596
597ALTER TABLE ONLY public.extensions
598    ADD CONSTRAINT extensions_pkey PRIMARY KEY (id);
599
600ALTER TABLE ONLY public.feature_flags
601    ADD CONSTRAINT feature_flags_flag_key UNIQUE (flag);
602
603ALTER TABLE ONLY public.feature_flags
604    ADD CONSTRAINT feature_flags_pkey PRIMARY KEY (id);
605
606ALTER TABLE ONLY public.followers
607    ADD CONSTRAINT followers_pkey PRIMARY KEY (id);
608
609ALTER TABLE ONLY public.language_servers
610    ADD CONSTRAINT language_servers_pkey PRIMARY KEY (project_id, id);
611
612ALTER TABLE ONLY public.notification_kinds
613    ADD CONSTRAINT notification_kinds_pkey PRIMARY KEY (id);
614
615ALTER TABLE ONLY public.notifications
616    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);
617
618ALTER TABLE ONLY public.observed_buffer_edits
619    ADD CONSTRAINT observed_buffer_edits_pkey PRIMARY KEY (user_id, buffer_id);
620
621ALTER TABLE ONLY public.project_collaborators
622    ADD CONSTRAINT project_collaborators_pkey PRIMARY KEY (id);
623
624ALTER TABLE ONLY public.project_repositories
625    ADD CONSTRAINT project_repositories_pkey PRIMARY KEY (project_id, id);
626
627ALTER TABLE ONLY public.project_repository_statuses
628    ADD CONSTRAINT project_repository_statuses_pkey PRIMARY KEY (project_id, repository_id, repo_path);
629
630ALTER TABLE ONLY public.projects
631    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
632
633ALTER TABLE ONLY public.room_participants
634    ADD CONSTRAINT room_participants_pkey PRIMARY KEY (id);
635
636ALTER TABLE ONLY public.rooms
637    ADD CONSTRAINT rooms_pkey PRIMARY KEY (id);
638
639ALTER TABLE ONLY public.servers
640    ADD CONSTRAINT servers_pkey PRIMARY KEY (id);
641
642ALTER TABLE ONLY public.shared_threads
643    ADD CONSTRAINT shared_threads_pkey PRIMARY KEY (id);
644
645ALTER TABLE ONLY public.user_features
646    ADD CONSTRAINT user_features_pkey PRIMARY KEY (user_id, feature_id);
647
648ALTER TABLE ONLY public.users
649    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
650
651ALTER TABLE ONLY public.worktree_diagnostic_summaries
652    ADD CONSTRAINT worktree_diagnostic_summaries_pkey PRIMARY KEY (project_id, worktree_id, path);
653
654ALTER TABLE ONLY public.worktree_entries
655    ADD CONSTRAINT worktree_entries_pkey PRIMARY KEY (project_id, worktree_id, id);
656
657ALTER TABLE ONLY public.worktree_settings_files
658    ADD CONSTRAINT worktree_settings_files_pkey PRIMARY KEY (project_id, worktree_id, path);
659
660ALTER TABLE ONLY public.worktrees
661    ADD CONSTRAINT worktrees_pkey PRIMARY KEY (project_id, id);
662
663CREATE INDEX idx_shared_threads_user_id ON public.shared_threads USING btree (user_id);
664
665CREATE INDEX index_access_tokens_user_id ON public.access_tokens USING btree (user_id);
666
667CREATE INDEX index_breakpoints_on_project_id ON public.breakpoints USING btree (project_id);
668
669CREATE INDEX index_buffers_on_channel_id ON public.buffers USING btree (channel_id);
670
671CREATE INDEX index_channel_buffer_collaborators_on_channel_id ON public.channel_buffer_collaborators USING btree (channel_id);
672
673CREATE UNIQUE INDEX index_channel_buffer_collaborators_on_channel_id_and_replica_id ON public.channel_buffer_collaborators USING btree (channel_id, replica_id);
674
675CREATE UNIQUE INDEX index_channel_buffer_collaborators_on_channel_id_connection_id_ ON public.channel_buffer_collaborators USING btree (channel_id, connection_id, connection_server_id);
676
677CREATE INDEX index_channel_buffer_collaborators_on_connection_id ON public.channel_buffer_collaborators USING btree (connection_id);
678
679CREATE INDEX index_channel_buffer_collaborators_on_connection_server_id ON public.channel_buffer_collaborators USING btree (connection_server_id);
680
681CREATE INDEX index_channel_chat_participants_on_channel_id ON public.channel_chat_participants USING btree (channel_id);
682
683CREATE UNIQUE INDEX index_channel_members_on_channel_id_and_user_id ON public.channel_members USING btree (channel_id, user_id);
684
685CREATE INDEX index_channels_on_parent_path ON public.channels USING btree (parent_path text_pattern_ops);
686
687CREATE INDEX index_channels_on_parent_path_and_order ON public.channels USING btree (parent_path, channel_order);
688
689CREATE INDEX index_contacts_user_id_b ON public.contacts USING btree (user_id_b);
690
691CREATE UNIQUE INDEX index_contacts_user_ids ON public.contacts USING btree (user_id_a, user_id_b);
692
693CREATE UNIQUE INDEX index_extensions_external_id ON public.extensions USING btree (external_id);
694
695CREATE INDEX index_extensions_total_download_count ON public.extensions USING btree (total_download_count);
696
697CREATE UNIQUE INDEX index_feature_flags ON public.feature_flags USING btree (id);
698
699CREATE UNIQUE INDEX index_followers_on_project_id_and_leader_connection_server_id_a ON public.followers USING btree (project_id, leader_connection_server_id, leader_connection_id, follower_connection_server_id, follower_connection_id);
700
701CREATE INDEX index_followers_on_room_id ON public.followers USING btree (room_id);
702
703CREATE UNIQUE INDEX index_invite_code_users ON public.users USING btree (invite_code);
704
705CREATE INDEX index_language_servers_on_project_id ON public.language_servers USING btree (project_id);
706
707CREATE UNIQUE INDEX index_notification_kinds_on_name ON public.notification_kinds USING btree (name);
708
709CREATE INDEX index_notifications_on_recipient_id_is_read_kind_entity_id ON public.notifications USING btree (recipient_id, is_read, kind, entity_id);
710
711CREATE UNIQUE INDEX index_observed_buffer_user_and_buffer_id ON public.observed_buffer_edits USING btree (user_id, buffer_id);
712
713CREATE INDEX index_project_collaborators_on_connection_id ON public.project_collaborators USING btree (connection_id);
714
715CREATE INDEX index_project_collaborators_on_connection_server_id ON public.project_collaborators USING btree (connection_server_id);
716
717CREATE INDEX index_project_collaborators_on_project_id ON public.project_collaborators USING btree (project_id);
718
719CREATE UNIQUE INDEX index_project_collaborators_on_project_id_and_replica_id ON public.project_collaborators USING btree (project_id, replica_id);
720
721CREATE UNIQUE INDEX index_project_collaborators_on_project_id_connection_id_and_ser ON public.project_collaborators USING btree (project_id, connection_id, connection_server_id);
722
723CREATE INDEX index_project_repos_statuses_on_project_id ON public.project_repository_statuses USING btree (project_id);
724
725CREATE INDEX index_project_repos_statuses_on_project_id_and_repo_id ON public.project_repository_statuses USING btree (project_id, repository_id);
726
727CREATE INDEX index_project_repositories_on_project_id ON public.project_repositories USING btree (project_id);
728
729CREATE INDEX index_projects_on_host_connection_id_and_host_connection_server ON public.projects USING btree (host_connection_id, host_connection_server_id);
730
731CREATE INDEX index_projects_on_host_connection_server_id ON public.projects USING btree (host_connection_server_id);
732
733CREATE INDEX index_room_participants_on_answering_connection_id ON public.room_participants USING btree (answering_connection_id);
734
735CREATE UNIQUE INDEX index_room_participants_on_answering_connection_id_and_answerin ON public.room_participants USING btree (answering_connection_id, answering_connection_server_id);
736
737CREATE INDEX index_room_participants_on_answering_connection_server_id ON public.room_participants USING btree (answering_connection_server_id);
738
739CREATE INDEX index_room_participants_on_calling_connection_server_id ON public.room_participants USING btree (calling_connection_server_id);
740
741CREATE INDEX index_room_participants_on_room_id ON public.room_participants USING btree (room_id);
742
743CREATE UNIQUE INDEX index_room_participants_on_user_id ON public.room_participants USING btree (user_id);
744
745CREATE UNIQUE INDEX index_rooms_on_channel_id ON public.rooms USING btree (channel_id);
746
747CREATE INDEX index_settings_files_on_project_id ON public.worktree_settings_files USING btree (project_id);
748
749CREATE INDEX index_settings_files_on_project_id_and_wt_id ON public.worktree_settings_files USING btree (project_id, worktree_id);
750
751CREATE INDEX index_user_features_on_feature_id ON public.user_features USING btree (feature_id);
752
753CREATE INDEX index_user_features_on_user_id ON public.user_features USING btree (user_id);
754
755CREATE UNIQUE INDEX index_user_features_user_id_and_feature_id ON public.user_features USING btree (user_id, feature_id);
756
757CREATE UNIQUE INDEX index_users_github_login ON public.users USING btree (github_login);
758
759CREATE INDEX index_users_on_email_address ON public.users USING btree (email_address);
760
761CREATE INDEX index_worktree_diagnostic_summaries_on_project_id ON public.worktree_diagnostic_summaries USING btree (project_id);
762
763CREATE INDEX index_worktree_diagnostic_summaries_on_project_id_and_worktree_ ON public.worktree_diagnostic_summaries USING btree (project_id, worktree_id);
764
765CREATE INDEX index_worktree_entries_on_project_id ON public.worktree_entries USING btree (project_id);
766
767CREATE INDEX index_worktree_entries_on_project_id_and_worktree_id ON public.worktree_entries USING btree (project_id, worktree_id);
768
769CREATE INDEX index_worktrees_on_project_id ON public.worktrees USING btree (project_id);
770
771CREATE INDEX trigram_index_extensions_name ON public.extensions USING gin (name public.gin_trgm_ops);
772
773CREATE INDEX trigram_index_users_on_github_login ON public.users USING gin (github_login public.gin_trgm_ops);
774
775CREATE UNIQUE INDEX uix_channels_parent_path_name ON public.channels USING btree (parent_path, name) WHERE ((parent_path IS NOT NULL) AND (parent_path <> ''::text));
776
777CREATE UNIQUE INDEX uix_users_on_github_user_id ON public.users USING btree (github_user_id);
778
779ALTER TABLE ONLY public.access_tokens
780    ADD CONSTRAINT access_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
781
782ALTER TABLE ONLY public.breakpoints
783    ADD CONSTRAINT breakpoints_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
784
785ALTER TABLE ONLY public.buffer_operations
786    ADD CONSTRAINT buffer_operations_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
787
788ALTER TABLE ONLY public.buffer_snapshots
789    ADD CONSTRAINT buffer_snapshots_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
790
791ALTER TABLE ONLY public.buffers
792    ADD CONSTRAINT buffers_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
793
794ALTER TABLE ONLY public.channel_buffer_collaborators
795    ADD CONSTRAINT channel_buffer_collaborators_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
796
797ALTER TABLE ONLY public.channel_buffer_collaborators
798    ADD CONSTRAINT channel_buffer_collaborators_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
799
800ALTER TABLE ONLY public.channel_buffer_collaborators
801    ADD CONSTRAINT channel_buffer_collaborators_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
802
803ALTER TABLE ONLY public.channel_chat_participants
804    ADD CONSTRAINT channel_chat_participants_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
805
806ALTER TABLE ONLY public.channel_chat_participants
807    ADD CONSTRAINT channel_chat_participants_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
808
809ALTER TABLE ONLY public.channel_chat_participants
810    ADD CONSTRAINT channel_chat_participants_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
811
812ALTER TABLE ONLY public.channel_members
813    ADD CONSTRAINT channel_members_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
814
815ALTER TABLE ONLY public.channel_members
816    ADD CONSTRAINT channel_members_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
817
818ALTER TABLE ONLY public.contacts
819    ADD CONSTRAINT contacts_user_id_a_fkey FOREIGN KEY (user_id_a) REFERENCES public.users(id) ON DELETE CASCADE;
820
821ALTER TABLE ONLY public.contacts
822    ADD CONSTRAINT contacts_user_id_b_fkey FOREIGN KEY (user_id_b) REFERENCES public.users(id) ON DELETE CASCADE;
823
824ALTER TABLE ONLY public.contributors
825    ADD CONSTRAINT contributors_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
826
827ALTER TABLE ONLY public.extension_versions
828    ADD CONSTRAINT extension_versions_extension_id_fkey FOREIGN KEY (extension_id) REFERENCES public.extensions(id);
829
830ALTER TABLE ONLY public.project_repositories
831    ADD CONSTRAINT fk_project_repositories_project_id FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
832
833ALTER TABLE ONLY public.project_repository_statuses
834    ADD CONSTRAINT fk_project_repository_statuses_project_id FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
835
836ALTER TABLE ONLY public.followers
837    ADD CONSTRAINT followers_follower_connection_server_id_fkey FOREIGN KEY (follower_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
838
839ALTER TABLE ONLY public.followers
840    ADD CONSTRAINT followers_leader_connection_server_id_fkey FOREIGN KEY (leader_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
841
842ALTER TABLE ONLY public.followers
843    ADD CONSTRAINT followers_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
844
845ALTER TABLE ONLY public.followers
846    ADD CONSTRAINT followers_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id) ON DELETE CASCADE;
847
848ALTER TABLE ONLY public.language_servers
849    ADD CONSTRAINT language_servers_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
850
851ALTER TABLE ONLY public.notifications
852    ADD CONSTRAINT notifications_kind_fkey FOREIGN KEY (kind) REFERENCES public.notification_kinds(id);
853
854ALTER TABLE ONLY public.notifications
855    ADD CONSTRAINT notifications_recipient_id_fkey FOREIGN KEY (recipient_id) REFERENCES public.users(id) ON DELETE CASCADE;
856
857ALTER TABLE ONLY public.observed_buffer_edits
858    ADD CONSTRAINT observed_buffer_edits_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
859
860ALTER TABLE ONLY public.observed_buffer_edits
861    ADD CONSTRAINT observed_buffer_edits_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
862
863ALTER TABLE ONLY public.project_collaborators
864    ADD CONSTRAINT project_collaborators_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
865
866ALTER TABLE ONLY public.project_collaborators
867    ADD CONSTRAINT project_collaborators_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
868
869ALTER TABLE ONLY public.projects
870    ADD CONSTRAINT projects_host_connection_server_id_fkey FOREIGN KEY (host_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
871
872ALTER TABLE ONLY public.projects
873    ADD CONSTRAINT projects_host_user_id_fkey FOREIGN KEY (host_user_id) REFERENCES public.users(id);
874
875ALTER TABLE ONLY public.projects
876    ADD CONSTRAINT projects_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id) ON DELETE CASCADE;
877
878ALTER TABLE ONLY public.room_participants
879    ADD CONSTRAINT room_participants_answering_connection_server_id_fkey FOREIGN KEY (answering_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
880
881ALTER TABLE ONLY public.room_participants
882    ADD CONSTRAINT room_participants_calling_connection_server_id_fkey FOREIGN KEY (calling_connection_server_id) REFERENCES public.servers(id) ON DELETE SET NULL;
883
884ALTER TABLE ONLY public.room_participants
885    ADD CONSTRAINT room_participants_calling_user_id_fkey FOREIGN KEY (calling_user_id) REFERENCES public.users(id);
886
887ALTER TABLE ONLY public.room_participants
888    ADD CONSTRAINT room_participants_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id);
889
890ALTER TABLE ONLY public.room_participants
891    ADD CONSTRAINT room_participants_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
892
893ALTER TABLE ONLY public.rooms
894    ADD CONSTRAINT rooms_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
895
896ALTER TABLE ONLY public.shared_threads
897    ADD CONSTRAINT shared_threads_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
898
899ALTER TABLE ONLY public.user_features
900    ADD CONSTRAINT user_features_feature_id_fkey FOREIGN KEY (feature_id) REFERENCES public.feature_flags(id) ON DELETE CASCADE;
901
902ALTER TABLE ONLY public.user_features
903    ADD CONSTRAINT user_features_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
904
905ALTER TABLE ONLY public.users
906    ADD CONSTRAINT users_inviter_id_fkey FOREIGN KEY (inviter_id) REFERENCES public.users(id) ON DELETE SET NULL;
907
908ALTER TABLE ONLY public.worktree_diagnostic_summaries
909    ADD CONSTRAINT worktree_diagnostic_summaries_project_id_worktree_id_fkey FOREIGN KEY (project_id, worktree_id) REFERENCES public.worktrees(project_id, id) ON DELETE CASCADE;
910
911ALTER TABLE ONLY public.worktree_entries
912    ADD CONSTRAINT worktree_entries_project_id_worktree_id_fkey FOREIGN KEY (project_id, worktree_id) REFERENCES public.worktrees(project_id, id) ON DELETE CASCADE;
913
914ALTER TABLE ONLY public.worktree_settings_files
915    ADD CONSTRAINT worktree_settings_files_project_id_worktree_id_fkey FOREIGN KEY (project_id, worktree_id) REFERENCES public.worktrees(project_id, id) ON DELETE CASCADE;
916
917ALTER TABLE ONLY public.worktrees
918    ADD CONSTRAINT worktrees_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;