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.followers (
217    id integer NOT NULL,
218    room_id integer NOT NULL,
219    project_id integer NOT NULL,
220    leader_connection_server_id integer NOT NULL,
221    leader_connection_id integer NOT NULL,
222    follower_connection_server_id integer NOT NULL,
223    follower_connection_id integer NOT NULL
224);
225
226CREATE SEQUENCE public.followers_id_seq
227    AS integer
228    START WITH 1
229    INCREMENT BY 1
230    NO MINVALUE
231    NO MAXVALUE
232    CACHE 1;
233
234ALTER SEQUENCE public.followers_id_seq OWNED BY public.followers.id;
235
236CREATE TABLE public.language_servers (
237    project_id integer NOT NULL,
238    id bigint NOT NULL,
239    name character varying NOT NULL,
240    capabilities text NOT NULL,
241    worktree_id bigint
242);
243
244CREATE TABLE public.notification_kinds (
245    id integer NOT NULL,
246    name character varying NOT NULL
247);
248
249CREATE SEQUENCE public.notification_kinds_id_seq
250    AS integer
251    START WITH 1
252    INCREMENT BY 1
253    NO MINVALUE
254    NO MAXVALUE
255    CACHE 1;
256
257ALTER SEQUENCE public.notification_kinds_id_seq OWNED BY public.notification_kinds.id;
258
259CREATE TABLE public.notifications (
260    id integer NOT NULL,
261    created_at timestamp without time zone DEFAULT now() NOT NULL,
262    recipient_id integer NOT NULL,
263    kind integer NOT NULL,
264    entity_id integer,
265    content text,
266    is_read boolean DEFAULT false NOT NULL,
267    response boolean
268);
269
270CREATE SEQUENCE public.notifications_id_seq
271    AS integer
272    START WITH 1
273    INCREMENT BY 1
274    NO MINVALUE
275    NO MAXVALUE
276    CACHE 1;
277
278ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;
279
280CREATE TABLE public.observed_buffer_edits (
281    user_id integer NOT NULL,
282    buffer_id integer NOT NULL,
283    epoch integer NOT NULL,
284    lamport_timestamp integer NOT NULL,
285    replica_id integer NOT NULL
286);
287
288CREATE TABLE public.project_collaborators (
289    id integer NOT NULL,
290    project_id integer NOT NULL,
291    connection_id integer NOT NULL,
292    user_id integer NOT NULL,
293    replica_id integer NOT NULL,
294    is_host boolean NOT NULL,
295    connection_server_id integer NOT NULL,
296    committer_name character varying,
297    committer_email character varying
298);
299
300CREATE SEQUENCE public.project_collaborators_id_seq
301    AS integer
302    START WITH 1
303    INCREMENT BY 1
304    NO MINVALUE
305    NO MAXVALUE
306    CACHE 1;
307
308ALTER SEQUENCE public.project_collaborators_id_seq OWNED BY public.project_collaborators.id;
309
310CREATE TABLE public.project_repositories (
311    project_id integer NOT NULL,
312    abs_path character varying,
313    id bigint NOT NULL,
314    legacy_worktree_id bigint,
315    entry_ids character varying,
316    branch character varying,
317    scan_id bigint NOT NULL,
318    is_deleted boolean NOT NULL,
319    current_merge_conflicts character varying,
320    branch_summary character varying,
321    head_commit_details character varying,
322    merge_message character varying,
323    remote_upstream_url character varying,
324    remote_origin_url character varying
325);
326
327CREATE TABLE public.project_repository_statuses (
328    project_id integer NOT NULL,
329    repository_id bigint NOT NULL,
330    repo_path character varying NOT NULL,
331    status bigint NOT NULL,
332    status_kind integer NOT NULL,
333    first_status integer,
334    second_status integer,
335    scan_id bigint NOT NULL,
336    is_deleted boolean NOT NULL
337);
338
339CREATE TABLE public.projects (
340    id integer NOT NULL,
341    host_user_id integer,
342    unregistered boolean DEFAULT false NOT NULL,
343    room_id integer,
344    host_connection_id integer,
345    host_connection_server_id integer,
346    windows_paths boolean DEFAULT false
347);
348
349CREATE SEQUENCE public.projects_id_seq
350    AS integer
351    START WITH 1
352    INCREMENT BY 1
353    NO MINVALUE
354    NO MAXVALUE
355    CACHE 1;
356
357ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;
358
359CREATE TABLE public.room_participants (
360    id integer NOT NULL,
361    room_id integer NOT NULL,
362    user_id integer NOT NULL,
363    answering_connection_id integer,
364    location_kind integer,
365    location_project_id integer,
366    initial_project_id integer,
367    calling_user_id integer NOT NULL,
368    calling_connection_id integer NOT NULL,
369    answering_connection_lost boolean DEFAULT false NOT NULL,
370    answering_connection_server_id integer,
371    calling_connection_server_id integer,
372    participant_index integer,
373    role text
374);
375
376CREATE SEQUENCE public.room_participants_id_seq
377    AS integer
378    START WITH 1
379    INCREMENT BY 1
380    NO MINVALUE
381    NO MAXVALUE
382    CACHE 1;
383
384ALTER SEQUENCE public.room_participants_id_seq OWNED BY public.room_participants.id;
385
386CREATE TABLE public.rooms (
387    id integer NOT NULL,
388    live_kit_room character varying NOT NULL,
389    channel_id integer
390);
391
392CREATE SEQUENCE public.rooms_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.rooms_id_seq OWNED BY public.rooms.id;
401
402CREATE TABLE public.servers (
403    id integer NOT NULL,
404    environment character varying NOT NULL
405);
406
407CREATE SEQUENCE public.servers_id_seq
408    AS integer
409    START WITH 1
410    INCREMENT BY 1
411    NO MINVALUE
412    NO MAXVALUE
413    CACHE 1;
414
415ALTER SEQUENCE public.servers_id_seq OWNED BY public.servers.id;
416
417CREATE TABLE public.shared_threads (
418    id uuid NOT NULL,
419    user_id integer NOT NULL,
420    title text NOT NULL,
421    data bytea NOT NULL,
422    created_at timestamp without time zone DEFAULT now() NOT NULL,
423    updated_at timestamp without time zone DEFAULT now() NOT NULL
424);
425
426CREATE TABLE public.users (
427    id integer NOT NULL,
428    github_login character varying,
429    admin boolean NOT NULL,
430    email_address character varying(255) DEFAULT NULL::character varying,
431    connected_once boolean DEFAULT false NOT NULL,
432    created_at timestamp without time zone DEFAULT now() NOT NULL,
433    github_user_id integer NOT NULL,
434    metrics_id uuid DEFAULT gen_random_uuid() NOT NULL,
435    accepted_tos_at timestamp without time zone,
436    github_user_created_at timestamp without time zone,
437    custom_llm_monthly_allowance_in_cents integer,
438    name text
439);
440
441CREATE SEQUENCE public.users_id_seq
442    AS integer
443    START WITH 1
444    INCREMENT BY 1
445    NO MINVALUE
446    NO MAXVALUE
447    CACHE 1;
448
449ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
450
451CREATE TABLE public.worktree_diagnostic_summaries (
452    project_id integer NOT NULL,
453    worktree_id bigint NOT NULL,
454    path character varying NOT NULL,
455    language_server_id bigint NOT NULL,
456    error_count integer NOT NULL,
457    warning_count integer NOT NULL
458);
459
460CREATE TABLE public.worktree_entries (
461    project_id integer NOT NULL,
462    worktree_id bigint NOT NULL,
463    id bigint NOT NULL,
464    is_dir boolean NOT NULL,
465    path character varying NOT NULL,
466    inode bigint NOT NULL,
467    mtime_seconds bigint NOT NULL,
468    mtime_nanos integer NOT NULL,
469    is_symlink boolean DEFAULT false NOT NULL,
470    is_ignored boolean NOT NULL,
471    scan_id bigint,
472    is_deleted boolean,
473    git_status bigint,
474    is_external boolean DEFAULT false NOT NULL,
475    is_fifo boolean DEFAULT false NOT NULL,
476    canonical_path text,
477    is_hidden boolean DEFAULT false NOT NULL
478);
479
480CREATE TABLE public.worktree_settings_files (
481    project_id integer NOT NULL,
482    worktree_id bigint NOT NULL,
483    path character varying NOT NULL,
484    content text NOT NULL,
485    kind character varying,
486    outside_worktree boolean DEFAULT false NOT NULL
487);
488
489CREATE TABLE public.worktrees (
490    project_id integer NOT NULL,
491    id bigint NOT NULL,
492    root_name character varying NOT NULL,
493    abs_path character varying NOT NULL,
494    visible boolean NOT NULL,
495    scan_id bigint NOT NULL,
496    is_complete boolean DEFAULT false NOT NULL,
497    completed_scan_id bigint
498);
499
500ALTER TABLE ONLY public.access_tokens ALTER COLUMN id SET DEFAULT nextval('public.access_tokens_id_seq'::regclass);
501
502ALTER TABLE ONLY public.breakpoints ALTER COLUMN id SET DEFAULT nextval('public.breakpoints_id_seq'::regclass);
503
504ALTER TABLE ONLY public.buffers ALTER COLUMN id SET DEFAULT nextval('public.buffers_id_seq'::regclass);
505
506ALTER TABLE ONLY public.channel_buffer_collaborators ALTER COLUMN id SET DEFAULT nextval('public.channel_buffer_collaborators_id_seq'::regclass);
507
508ALTER TABLE ONLY public.channel_chat_participants ALTER COLUMN id SET DEFAULT nextval('public.channel_chat_participants_id_seq'::regclass);
509
510ALTER TABLE ONLY public.channel_members ALTER COLUMN id SET DEFAULT nextval('public.channel_members_id_seq'::regclass);
511
512ALTER TABLE ONLY public.channels ALTER COLUMN id SET DEFAULT nextval('public.channels_id_seq'::regclass);
513
514ALTER TABLE ONLY public.contacts ALTER COLUMN id SET DEFAULT nextval('public.contacts_id_seq'::regclass);
515
516ALTER TABLE ONLY public.extensions ALTER COLUMN id SET DEFAULT nextval('public.extensions_id_seq'::regclass);
517
518ALTER TABLE ONLY public.followers ALTER COLUMN id SET DEFAULT nextval('public.followers_id_seq'::regclass);
519
520ALTER TABLE ONLY public.notification_kinds ALTER COLUMN id SET DEFAULT nextval('public.notification_kinds_id_seq'::regclass);
521
522ALTER TABLE ONLY public.notifications ALTER COLUMN id SET DEFAULT nextval('public.notifications_id_seq'::regclass);
523
524ALTER TABLE ONLY public.project_collaborators ALTER COLUMN id SET DEFAULT nextval('public.project_collaborators_id_seq'::regclass);
525
526ALTER TABLE ONLY public.projects ALTER COLUMN id SET DEFAULT nextval('public.projects_id_seq'::regclass);
527
528ALTER TABLE ONLY public.room_participants ALTER COLUMN id SET DEFAULT nextval('public.room_participants_id_seq'::regclass);
529
530ALTER TABLE ONLY public.rooms ALTER COLUMN id SET DEFAULT nextval('public.rooms_id_seq'::regclass);
531
532ALTER TABLE ONLY public.servers ALTER COLUMN id SET DEFAULT nextval('public.servers_id_seq'::regclass);
533
534ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
535
536ALTER TABLE ONLY public.access_tokens
537    ADD CONSTRAINT access_tokens_pkey PRIMARY KEY (id);
538
539ALTER TABLE ONLY public.breakpoints
540    ADD CONSTRAINT breakpoints_pkey PRIMARY KEY (id);
541
542ALTER TABLE ONLY public.buffer_operations
543    ADD CONSTRAINT buffer_operations_pkey PRIMARY KEY (buffer_id, epoch, lamport_timestamp, replica_id);
544
545ALTER TABLE ONLY public.buffer_snapshots
546    ADD CONSTRAINT buffer_snapshots_pkey PRIMARY KEY (buffer_id, epoch);
547
548ALTER TABLE ONLY public.buffers
549    ADD CONSTRAINT buffers_pkey PRIMARY KEY (id);
550
551ALTER TABLE ONLY public.channel_buffer_collaborators
552    ADD CONSTRAINT channel_buffer_collaborators_pkey PRIMARY KEY (id);
553
554ALTER TABLE ONLY public.channel_chat_participants
555    ADD CONSTRAINT channel_chat_participants_pkey PRIMARY KEY (id);
556
557ALTER TABLE ONLY public.channel_members
558    ADD CONSTRAINT channel_members_pkey PRIMARY KEY (id);
559
560ALTER TABLE ONLY public.channels
561    ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
562
563ALTER TABLE ONLY public.contacts
564    ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
565
566ALTER TABLE ONLY public.contributors
567    ADD CONSTRAINT contributors_pkey PRIMARY KEY (user_id);
568
569ALTER TABLE ONLY public.extension_versions
570    ADD CONSTRAINT extension_versions_pkey PRIMARY KEY (extension_id, version);
571
572ALTER TABLE ONLY public.extensions
573    ADD CONSTRAINT extensions_pkey PRIMARY KEY (id);
574
575ALTER TABLE ONLY public.followers
576    ADD CONSTRAINT followers_pkey PRIMARY KEY (id);
577
578ALTER TABLE ONLY public.language_servers
579    ADD CONSTRAINT language_servers_pkey PRIMARY KEY (project_id, id);
580
581ALTER TABLE ONLY public.notification_kinds
582    ADD CONSTRAINT notification_kinds_pkey PRIMARY KEY (id);
583
584ALTER TABLE ONLY public.notifications
585    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);
586
587ALTER TABLE ONLY public.observed_buffer_edits
588    ADD CONSTRAINT observed_buffer_edits_pkey PRIMARY KEY (user_id, buffer_id);
589
590ALTER TABLE ONLY public.project_collaborators
591    ADD CONSTRAINT project_collaborators_pkey PRIMARY KEY (id);
592
593ALTER TABLE ONLY public.project_repositories
594    ADD CONSTRAINT project_repositories_pkey PRIMARY KEY (project_id, id);
595
596ALTER TABLE ONLY public.project_repository_statuses
597    ADD CONSTRAINT project_repository_statuses_pkey PRIMARY KEY (project_id, repository_id, repo_path);
598
599ALTER TABLE ONLY public.projects
600    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
601
602ALTER TABLE ONLY public.room_participants
603    ADD CONSTRAINT room_participants_pkey PRIMARY KEY (id);
604
605ALTER TABLE ONLY public.rooms
606    ADD CONSTRAINT rooms_pkey PRIMARY KEY (id);
607
608ALTER TABLE ONLY public.servers
609    ADD CONSTRAINT servers_pkey PRIMARY KEY (id);
610
611ALTER TABLE ONLY public.shared_threads
612    ADD CONSTRAINT shared_threads_pkey PRIMARY KEY (id);
613
614ALTER TABLE ONLY public.users
615    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
616
617ALTER TABLE ONLY public.worktree_diagnostic_summaries
618    ADD CONSTRAINT worktree_diagnostic_summaries_pkey PRIMARY KEY (project_id, worktree_id, path);
619
620ALTER TABLE ONLY public.worktree_entries
621    ADD CONSTRAINT worktree_entries_pkey PRIMARY KEY (project_id, worktree_id, id);
622
623ALTER TABLE ONLY public.worktree_settings_files
624    ADD CONSTRAINT worktree_settings_files_pkey PRIMARY KEY (project_id, worktree_id, path);
625
626ALTER TABLE ONLY public.worktrees
627    ADD CONSTRAINT worktrees_pkey PRIMARY KEY (project_id, id);
628
629CREATE INDEX idx_shared_threads_user_id ON public.shared_threads USING btree (user_id);
630
631CREATE INDEX index_access_tokens_user_id ON public.access_tokens USING btree (user_id);
632
633CREATE INDEX index_breakpoints_on_project_id ON public.breakpoints USING btree (project_id);
634
635CREATE INDEX index_buffers_on_channel_id ON public.buffers USING btree (channel_id);
636
637CREATE INDEX index_channel_buffer_collaborators_on_channel_id ON public.channel_buffer_collaborators USING btree (channel_id);
638
639CREATE UNIQUE INDEX index_channel_buffer_collaborators_on_channel_id_and_replica_id ON public.channel_buffer_collaborators USING btree (channel_id, replica_id);
640
641CREATE 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);
642
643CREATE INDEX index_channel_buffer_collaborators_on_connection_id ON public.channel_buffer_collaborators USING btree (connection_id);
644
645CREATE INDEX index_channel_buffer_collaborators_on_connection_server_id ON public.channel_buffer_collaborators USING btree (connection_server_id);
646
647CREATE INDEX index_channel_chat_participants_on_channel_id ON public.channel_chat_participants USING btree (channel_id);
648
649CREATE UNIQUE INDEX index_channel_members_on_channel_id_and_user_id ON public.channel_members USING btree (channel_id, user_id);
650
651CREATE INDEX index_channels_on_parent_path ON public.channels USING btree (parent_path text_pattern_ops);
652
653CREATE INDEX index_channels_on_parent_path_and_order ON public.channels USING btree (parent_path, channel_order);
654
655CREATE INDEX index_contacts_user_id_b ON public.contacts USING btree (user_id_b);
656
657CREATE UNIQUE INDEX index_contacts_user_ids ON public.contacts USING btree (user_id_a, user_id_b);
658
659CREATE UNIQUE INDEX index_extensions_external_id ON public.extensions USING btree (external_id);
660
661CREATE INDEX index_extensions_total_download_count ON public.extensions USING btree (total_download_count);
662
663CREATE 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);
664
665CREATE INDEX index_followers_on_room_id ON public.followers USING btree (room_id);
666
667CREATE INDEX index_language_servers_on_project_id ON public.language_servers USING btree (project_id);
668
669CREATE UNIQUE INDEX index_notification_kinds_on_name ON public.notification_kinds USING btree (name);
670
671CREATE INDEX index_notifications_on_recipient_id_is_read_kind_entity_id ON public.notifications USING btree (recipient_id, is_read, kind, entity_id);
672
673CREATE UNIQUE INDEX index_observed_buffer_user_and_buffer_id ON public.observed_buffer_edits USING btree (user_id, buffer_id);
674
675CREATE INDEX index_project_collaborators_on_connection_id ON public.project_collaborators USING btree (connection_id);
676
677CREATE INDEX index_project_collaborators_on_connection_server_id ON public.project_collaborators USING btree (connection_server_id);
678
679CREATE INDEX index_project_collaborators_on_project_id ON public.project_collaborators USING btree (project_id);
680
681CREATE UNIQUE INDEX index_project_collaborators_on_project_id_and_replica_id ON public.project_collaborators USING btree (project_id, replica_id);
682
683CREATE 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);
684
685CREATE INDEX index_project_repos_statuses_on_project_id ON public.project_repository_statuses USING btree (project_id);
686
687CREATE INDEX index_project_repos_statuses_on_project_id_and_repo_id ON public.project_repository_statuses USING btree (project_id, repository_id);
688
689CREATE INDEX index_project_repositories_on_project_id ON public.project_repositories USING btree (project_id);
690
691CREATE INDEX index_projects_on_host_connection_id_and_host_connection_server ON public.projects USING btree (host_connection_id, host_connection_server_id);
692
693CREATE INDEX index_projects_on_host_connection_server_id ON public.projects USING btree (host_connection_server_id);
694
695CREATE INDEX index_room_participants_on_answering_connection_id ON public.room_participants USING btree (answering_connection_id);
696
697CREATE UNIQUE INDEX index_room_participants_on_answering_connection_id_and_answerin ON public.room_participants USING btree (answering_connection_id, answering_connection_server_id);
698
699CREATE INDEX index_room_participants_on_answering_connection_server_id ON public.room_participants USING btree (answering_connection_server_id);
700
701CREATE INDEX index_room_participants_on_calling_connection_server_id ON public.room_participants USING btree (calling_connection_server_id);
702
703CREATE INDEX index_room_participants_on_room_id ON public.room_participants USING btree (room_id);
704
705CREATE UNIQUE INDEX index_room_participants_on_user_id ON public.room_participants USING btree (user_id);
706
707CREATE UNIQUE INDEX index_rooms_on_channel_id ON public.rooms USING btree (channel_id);
708
709CREATE INDEX index_settings_files_on_project_id ON public.worktree_settings_files USING btree (project_id);
710
711CREATE INDEX index_settings_files_on_project_id_and_wt_id ON public.worktree_settings_files USING btree (project_id, worktree_id);
712
713CREATE UNIQUE INDEX index_users_github_login ON public.users USING btree (github_login);
714
715CREATE INDEX index_users_on_email_address ON public.users USING btree (email_address);
716
717CREATE INDEX index_worktree_diagnostic_summaries_on_project_id ON public.worktree_diagnostic_summaries USING btree (project_id);
718
719CREATE INDEX index_worktree_diagnostic_summaries_on_project_id_and_worktree_ ON public.worktree_diagnostic_summaries USING btree (project_id, worktree_id);
720
721CREATE INDEX index_worktree_entries_on_project_id ON public.worktree_entries USING btree (project_id);
722
723CREATE INDEX index_worktree_entries_on_project_id_and_worktree_id ON public.worktree_entries USING btree (project_id, worktree_id);
724
725CREATE INDEX index_worktrees_on_project_id ON public.worktrees USING btree (project_id);
726
727CREATE INDEX trigram_index_extensions_name ON public.extensions USING gin (name public.gin_trgm_ops);
728
729CREATE INDEX trigram_index_users_on_github_login ON public.users USING gin (github_login public.gin_trgm_ops);
730
731CREATE 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));
732
733CREATE UNIQUE INDEX uix_users_on_github_user_id ON public.users USING btree (github_user_id);
734
735ALTER TABLE ONLY public.access_tokens
736    ADD CONSTRAINT access_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
737
738ALTER TABLE ONLY public.breakpoints
739    ADD CONSTRAINT breakpoints_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
740
741ALTER TABLE ONLY public.buffer_operations
742    ADD CONSTRAINT buffer_operations_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
743
744ALTER TABLE ONLY public.buffer_snapshots
745    ADD CONSTRAINT buffer_snapshots_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
746
747ALTER TABLE ONLY public.buffers
748    ADD CONSTRAINT buffers_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
749
750ALTER TABLE ONLY public.channel_buffer_collaborators
751    ADD CONSTRAINT channel_buffer_collaborators_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
752
753ALTER TABLE ONLY public.channel_buffer_collaborators
754    ADD CONSTRAINT channel_buffer_collaborators_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
755
756ALTER TABLE ONLY public.channel_buffer_collaborators
757    ADD CONSTRAINT channel_buffer_collaborators_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
758
759ALTER TABLE ONLY public.channel_chat_participants
760    ADD CONSTRAINT channel_chat_participants_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
761
762ALTER TABLE ONLY public.channel_chat_participants
763    ADD CONSTRAINT channel_chat_participants_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
764
765ALTER TABLE ONLY public.channel_chat_participants
766    ADD CONSTRAINT channel_chat_participants_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
767
768ALTER TABLE ONLY public.channel_members
769    ADD CONSTRAINT channel_members_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
770
771ALTER TABLE ONLY public.channel_members
772    ADD CONSTRAINT channel_members_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
773
774ALTER TABLE ONLY public.contacts
775    ADD CONSTRAINT contacts_user_id_a_fkey FOREIGN KEY (user_id_a) REFERENCES public.users(id) ON DELETE CASCADE;
776
777ALTER TABLE ONLY public.contacts
778    ADD CONSTRAINT contacts_user_id_b_fkey FOREIGN KEY (user_id_b) REFERENCES public.users(id) ON DELETE CASCADE;
779
780ALTER TABLE ONLY public.contributors
781    ADD CONSTRAINT contributors_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
782
783ALTER TABLE ONLY public.extension_versions
784    ADD CONSTRAINT extension_versions_extension_id_fkey FOREIGN KEY (extension_id) REFERENCES public.extensions(id);
785
786ALTER TABLE ONLY public.project_repositories
787    ADD CONSTRAINT fk_project_repositories_project_id FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
788
789ALTER TABLE ONLY public.project_repository_statuses
790    ADD CONSTRAINT fk_project_repository_statuses_project_id FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
791
792ALTER TABLE ONLY public.followers
793    ADD CONSTRAINT followers_follower_connection_server_id_fkey FOREIGN KEY (follower_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
794
795ALTER TABLE ONLY public.followers
796    ADD CONSTRAINT followers_leader_connection_server_id_fkey FOREIGN KEY (leader_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
797
798ALTER TABLE ONLY public.followers
799    ADD CONSTRAINT followers_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
800
801ALTER TABLE ONLY public.followers
802    ADD CONSTRAINT followers_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id) ON DELETE CASCADE;
803
804ALTER TABLE ONLY public.language_servers
805    ADD CONSTRAINT language_servers_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
806
807ALTER TABLE ONLY public.notifications
808    ADD CONSTRAINT notifications_kind_fkey FOREIGN KEY (kind) REFERENCES public.notification_kinds(id);
809
810ALTER TABLE ONLY public.notifications
811    ADD CONSTRAINT notifications_recipient_id_fkey FOREIGN KEY (recipient_id) REFERENCES public.users(id) ON DELETE CASCADE;
812
813ALTER TABLE ONLY public.observed_buffer_edits
814    ADD CONSTRAINT observed_buffer_edits_buffer_id_fkey FOREIGN KEY (buffer_id) REFERENCES public.buffers(id) ON DELETE CASCADE;
815
816ALTER TABLE ONLY public.observed_buffer_edits
817    ADD CONSTRAINT observed_buffer_edits_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
818
819ALTER TABLE ONLY public.project_collaborators
820    ADD CONSTRAINT project_collaborators_connection_server_id_fkey FOREIGN KEY (connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
821
822ALTER TABLE ONLY public.project_collaborators
823    ADD CONSTRAINT project_collaborators_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
824
825ALTER TABLE ONLY public.projects
826    ADD CONSTRAINT projects_host_connection_server_id_fkey FOREIGN KEY (host_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
827
828ALTER TABLE ONLY public.projects
829    ADD CONSTRAINT projects_host_user_id_fkey FOREIGN KEY (host_user_id) REFERENCES public.users(id);
830
831ALTER TABLE ONLY public.projects
832    ADD CONSTRAINT projects_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id) ON DELETE CASCADE;
833
834ALTER TABLE ONLY public.room_participants
835    ADD CONSTRAINT room_participants_answering_connection_server_id_fkey FOREIGN KEY (answering_connection_server_id) REFERENCES public.servers(id) ON DELETE CASCADE;
836
837ALTER TABLE ONLY public.room_participants
838    ADD CONSTRAINT room_participants_calling_connection_server_id_fkey FOREIGN KEY (calling_connection_server_id) REFERENCES public.servers(id) ON DELETE SET NULL;
839
840ALTER TABLE ONLY public.room_participants
841    ADD CONSTRAINT room_participants_calling_user_id_fkey FOREIGN KEY (calling_user_id) REFERENCES public.users(id);
842
843ALTER TABLE ONLY public.room_participants
844    ADD CONSTRAINT room_participants_room_id_fkey FOREIGN KEY (room_id) REFERENCES public.rooms(id);
845
846ALTER TABLE ONLY public.room_participants
847    ADD CONSTRAINT room_participants_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
848
849ALTER TABLE ONLY public.rooms
850    ADD CONSTRAINT rooms_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
851
852ALTER TABLE ONLY public.shared_threads
853    ADD CONSTRAINT shared_threads_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
854
855ALTER TABLE ONLY public.worktree_diagnostic_summaries
856    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;
857
858ALTER TABLE ONLY public.worktree_entries
859    ADD CONSTRAINT worktree_entries_project_id_worktree_id_fkey FOREIGN KEY (project_id, worktree_id) REFERENCES public.worktrees(project_id, id) ON DELETE CASCADE;
860
861ALTER TABLE ONLY public.worktree_settings_files
862    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;
863
864ALTER TABLE ONLY public.worktrees
865    ADD CONSTRAINT worktrees_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;