]> Untitled Git - lemmy.git/blob - crates/db_schema/src/schema.rs
42946d69911a1a7553488e41706d678cfdc679c9
[lemmy.git] / crates / db_schema / src / schema.rs
1 // @generated automatically by Diesel CLI.
2
3 pub mod sql_types {
4     #[derive(diesel::sql_types::SqlType)]
5     #[diesel(postgres_type(name = "listing_type_enum"))]
6     pub struct ListingTypeEnum;
7
8     #[derive(diesel::sql_types::SqlType)]
9     #[diesel(postgres_type(name = "registration_mode_enum"))]
10     pub struct RegistrationModeEnum;
11
12     #[derive(diesel::sql_types::SqlType)]
13     #[diesel(postgres_type(name = "sort_type_enum"))]
14     pub struct SortTypeEnum;
15 }
16
17 diesel::table! {
18     activity (id) {
19         id -> Int4,
20         data -> Jsonb,
21         local -> Bool,
22         published -> Timestamp,
23         updated -> Nullable<Timestamp>,
24         ap_id -> Text,
25         sensitive -> Bool,
26     }
27 }
28
29 diesel::table! {
30     admin_purge_comment (id) {
31         id -> Int4,
32         admin_person_id -> Int4,
33         post_id -> Int4,
34         reason -> Nullable<Text>,
35         when_ -> Timestamp,
36     }
37 }
38
39 diesel::table! {
40     admin_purge_community (id) {
41         id -> Int4,
42         admin_person_id -> Int4,
43         reason -> Nullable<Text>,
44         when_ -> Timestamp,
45     }
46 }
47
48 diesel::table! {
49     admin_purge_person (id) {
50         id -> Int4,
51         admin_person_id -> Int4,
52         reason -> Nullable<Text>,
53         when_ -> Timestamp,
54     }
55 }
56
57 diesel::table! {
58     admin_purge_post (id) {
59         id -> Int4,
60         admin_person_id -> Int4,
61         community_id -> Int4,
62         reason -> Nullable<Text>,
63         when_ -> Timestamp,
64     }
65 }
66
67 diesel::table! {
68     captcha_answer (id) {
69         id -> Int4,
70         uuid -> Uuid,
71         answer -> Text,
72         published -> Timestamp,
73     }
74 }
75
76 diesel::table! {
77     use diesel::sql_types::*;
78     use diesel_ltree::sql_types::Ltree;
79
80     comment (id) {
81         id -> Int4,
82         creator_id -> Int4,
83         post_id -> Int4,
84         content -> Text,
85         removed -> Bool,
86         published -> Timestamp,
87         updated -> Nullable<Timestamp>,
88         deleted -> Bool,
89         #[max_length = 255]
90         ap_id -> Varchar,
91         local -> Bool,
92         path -> Ltree,
93         distinguished -> Bool,
94         language_id -> Int4,
95     }
96 }
97
98 diesel::table! {
99     comment_aggregates (id) {
100         id -> Int4,
101         comment_id -> Int4,
102         score -> Int8,
103         upvotes -> Int8,
104         downvotes -> Int8,
105         published -> Timestamp,
106         child_count -> Int4,
107         hot_rank -> Int4,
108     }
109 }
110
111 diesel::table! {
112     comment_like (id) {
113         id -> Int4,
114         person_id -> Int4,
115         comment_id -> Int4,
116         post_id -> Int4,
117         score -> Int2,
118         published -> Timestamp,
119     }
120 }
121
122 diesel::table! {
123     comment_reply (id) {
124         id -> Int4,
125         recipient_id -> Int4,
126         comment_id -> Int4,
127         read -> Bool,
128         published -> Timestamp,
129     }
130 }
131
132 diesel::table! {
133     comment_report (id) {
134         id -> Int4,
135         creator_id -> Int4,
136         comment_id -> Int4,
137         original_comment_text -> Text,
138         reason -> Text,
139         resolved -> Bool,
140         resolver_id -> Nullable<Int4>,
141         published -> Timestamp,
142         updated -> Nullable<Timestamp>,
143     }
144 }
145
146 diesel::table! {
147     comment_saved (id) {
148         id -> Int4,
149         comment_id -> Int4,
150         person_id -> Int4,
151         published -> Timestamp,
152     }
153 }
154
155 diesel::table! {
156     community (id) {
157         id -> Int4,
158         #[max_length = 255]
159         name -> Varchar,
160         #[max_length = 255]
161         title -> Varchar,
162         description -> Nullable<Text>,
163         removed -> Bool,
164         published -> Timestamp,
165         updated -> Nullable<Timestamp>,
166         deleted -> Bool,
167         nsfw -> Bool,
168         #[max_length = 255]
169         actor_id -> Varchar,
170         local -> Bool,
171         private_key -> Nullable<Text>,
172         public_key -> Text,
173         last_refreshed_at -> Timestamp,
174         icon -> Nullable<Text>,
175         banner -> Nullable<Text>,
176         #[max_length = 255]
177         followers_url -> Varchar,
178         #[max_length = 255]
179         inbox_url -> Varchar,
180         #[max_length = 255]
181         shared_inbox_url -> Nullable<Varchar>,
182         hidden -> Bool,
183         posting_restricted_to_mods -> Bool,
184         instance_id -> Int4,
185         #[max_length = 255]
186         moderators_url -> Nullable<Varchar>,
187         #[max_length = 255]
188         featured_url -> Nullable<Varchar>,
189     }
190 }
191
192 diesel::table! {
193     community_aggregates (id) {
194         id -> Int4,
195         community_id -> Int4,
196         subscribers -> Int8,
197         posts -> Int8,
198         comments -> Int8,
199         published -> Timestamp,
200         users_active_day -> Int8,
201         users_active_week -> Int8,
202         users_active_month -> Int8,
203         users_active_half_year -> Int8,
204         hot_rank -> Int4,
205     }
206 }
207
208 diesel::table! {
209     community_block (id) {
210         id -> Int4,
211         person_id -> Int4,
212         community_id -> Int4,
213         published -> Timestamp,
214     }
215 }
216
217 diesel::table! {
218     community_follower (id) {
219         id -> Int4,
220         community_id -> Int4,
221         person_id -> Int4,
222         published -> Timestamp,
223         pending -> Bool,
224     }
225 }
226
227 diesel::table! {
228     community_language (id) {
229         id -> Int4,
230         community_id -> Int4,
231         language_id -> Int4,
232     }
233 }
234
235 diesel::table! {
236     community_moderator (id) {
237         id -> Int4,
238         community_id -> Int4,
239         person_id -> Int4,
240         published -> Timestamp,
241     }
242 }
243
244 diesel::table! {
245     community_person_ban (id) {
246         id -> Int4,
247         community_id -> Int4,
248         person_id -> Int4,
249         published -> Timestamp,
250         expires -> Nullable<Timestamp>,
251     }
252 }
253
254 diesel::table! {
255     custom_emoji (id) {
256         id -> Int4,
257         local_site_id -> Int4,
258         #[max_length = 128]
259         shortcode -> Varchar,
260         image_url -> Text,
261         alt_text -> Text,
262         category -> Text,
263         published -> Timestamp,
264         updated -> Nullable<Timestamp>,
265     }
266 }
267
268 diesel::table! {
269     custom_emoji_keyword (id) {
270         id -> Int4,
271         custom_emoji_id -> Int4,
272         #[max_length = 128]
273         keyword -> Varchar,
274     }
275 }
276
277 diesel::table! {
278     email_verification (id) {
279         id -> Int4,
280         local_user_id -> Int4,
281         email -> Text,
282         verification_token -> Text,
283         published -> Timestamp,
284     }
285 }
286
287 diesel::table! {
288     federation_allowlist (id) {
289         id -> Int4,
290         instance_id -> Int4,
291         published -> Timestamp,
292         updated -> Nullable<Timestamp>,
293     }
294 }
295
296 diesel::table! {
297     federation_blocklist (id) {
298         id -> Int4,
299         instance_id -> Int4,
300         published -> Timestamp,
301         updated -> Nullable<Timestamp>,
302     }
303 }
304
305 diesel::table! {
306     instance (id) {
307         id -> Int4,
308         #[max_length = 255]
309         domain -> Varchar,
310         published -> Timestamp,
311         updated -> Nullable<Timestamp>,
312         #[max_length = 255]
313         software -> Nullable<Varchar>,
314         #[max_length = 255]
315         version -> Nullable<Varchar>,
316     }
317 }
318
319 diesel::table! {
320     language (id) {
321         id -> Int4,
322         #[max_length = 3]
323         code -> Varchar,
324         name -> Text,
325     }
326 }
327
328 diesel::table! {
329     use diesel::sql_types::*;
330     use super::sql_types::ListingTypeEnum;
331     use super::sql_types::RegistrationModeEnum;
332
333     local_site (id) {
334         id -> Int4,
335         site_id -> Int4,
336         site_setup -> Bool,
337         enable_downvotes -> Bool,
338         enable_nsfw -> Bool,
339         community_creation_admin_only -> Bool,
340         require_email_verification -> Bool,
341         application_question -> Nullable<Text>,
342         private_instance -> Bool,
343         default_theme -> Text,
344         default_post_listing_type -> ListingTypeEnum,
345         legal_information -> Nullable<Text>,
346         hide_modlog_mod_names -> Bool,
347         application_email_admins -> Bool,
348         slur_filter_regex -> Nullable<Text>,
349         actor_name_max_length -> Int4,
350         federation_enabled -> Bool,
351         captcha_enabled -> Bool,
352         #[max_length = 255]
353         captcha_difficulty -> Varchar,
354         published -> Timestamp,
355         updated -> Nullable<Timestamp>,
356         registration_mode -> RegistrationModeEnum,
357         reports_email_admins -> Bool,
358     }
359 }
360
361 diesel::table! {
362     local_site_rate_limit (id) {
363         id -> Int4,
364         local_site_id -> Int4,
365         message -> Int4,
366         message_per_second -> Int4,
367         post -> Int4,
368         post_per_second -> Int4,
369         register -> Int4,
370         register_per_second -> Int4,
371         image -> Int4,
372         image_per_second -> Int4,
373         comment -> Int4,
374         comment_per_second -> Int4,
375         search -> Int4,
376         search_per_second -> Int4,
377         published -> Timestamp,
378         updated -> Nullable<Timestamp>,
379     }
380 }
381
382 diesel::table! {
383     use diesel::sql_types::*;
384     use super::sql_types::SortTypeEnum;
385     use super::sql_types::ListingTypeEnum;
386
387     local_user (id) {
388         id -> Int4,
389         person_id -> Int4,
390         password_encrypted -> Text,
391         email -> Nullable<Text>,
392         show_nsfw -> Bool,
393         theme -> Text,
394         default_sort_type -> SortTypeEnum,
395         default_listing_type -> ListingTypeEnum,
396         #[max_length = 20]
397         interface_language -> Varchar,
398         show_avatars -> Bool,
399         send_notifications_to_email -> Bool,
400         validator_time -> Timestamp,
401         show_scores -> Bool,
402         show_bot_accounts -> Bool,
403         show_read_posts -> Bool,
404         show_new_post_notifs -> Bool,
405         email_verified -> Bool,
406         accepted_application -> Bool,
407         totp_2fa_secret -> Nullable<Text>,
408         totp_2fa_url -> Nullable<Text>,
409     }
410 }
411
412 diesel::table! {
413     local_user_language (id) {
414         id -> Int4,
415         local_user_id -> Int4,
416         language_id -> Int4,
417     }
418 }
419
420 diesel::table! {
421     mod_add (id) {
422         id -> Int4,
423         mod_person_id -> Int4,
424         other_person_id -> Int4,
425         removed -> Bool,
426         when_ -> Timestamp,
427     }
428 }
429
430 diesel::table! {
431     mod_add_community (id) {
432         id -> Int4,
433         mod_person_id -> Int4,
434         other_person_id -> Int4,
435         community_id -> Int4,
436         removed -> Bool,
437         when_ -> Timestamp,
438     }
439 }
440
441 diesel::table! {
442     mod_ban (id) {
443         id -> Int4,
444         mod_person_id -> Int4,
445         other_person_id -> Int4,
446         reason -> Nullable<Text>,
447         banned -> Bool,
448         expires -> Nullable<Timestamp>,
449         when_ -> Timestamp,
450     }
451 }
452
453 diesel::table! {
454     mod_ban_from_community (id) {
455         id -> Int4,
456         mod_person_id -> Int4,
457         other_person_id -> Int4,
458         community_id -> Int4,
459         reason -> Nullable<Text>,
460         banned -> Bool,
461         expires -> Nullable<Timestamp>,
462         when_ -> Timestamp,
463     }
464 }
465
466 diesel::table! {
467     mod_feature_post (id) {
468         id -> Int4,
469         mod_person_id -> Int4,
470         post_id -> Int4,
471         featured -> Bool,
472         when_ -> Timestamp,
473         is_featured_community -> Bool,
474     }
475 }
476
477 diesel::table! {
478     mod_hide_community (id) {
479         id -> Int4,
480         community_id -> Int4,
481         mod_person_id -> Int4,
482         when_ -> Timestamp,
483         reason -> Nullable<Text>,
484         hidden -> Bool,
485     }
486 }
487
488 diesel::table! {
489     mod_lock_post (id) {
490         id -> Int4,
491         mod_person_id -> Int4,
492         post_id -> Int4,
493         locked -> Bool,
494         when_ -> Timestamp,
495     }
496 }
497
498 diesel::table! {
499     mod_remove_comment (id) {
500         id -> Int4,
501         mod_person_id -> Int4,
502         comment_id -> Int4,
503         reason -> Nullable<Text>,
504         removed -> Bool,
505         when_ -> Timestamp,
506     }
507 }
508
509 diesel::table! {
510     mod_remove_community (id) {
511         id -> Int4,
512         mod_person_id -> Int4,
513         community_id -> Int4,
514         reason -> Nullable<Text>,
515         removed -> Bool,
516         expires -> Nullable<Timestamp>,
517         when_ -> Timestamp,
518     }
519 }
520
521 diesel::table! {
522     mod_remove_post (id) {
523         id -> Int4,
524         mod_person_id -> Int4,
525         post_id -> Int4,
526         reason -> Nullable<Text>,
527         removed -> Bool,
528         when_ -> Timestamp,
529     }
530 }
531
532 diesel::table! {
533     mod_transfer_community (id) {
534         id -> Int4,
535         mod_person_id -> Int4,
536         other_person_id -> Int4,
537         community_id -> Int4,
538         when_ -> Timestamp,
539     }
540 }
541
542 diesel::table! {
543     password_reset_request (id) {
544         id -> Int4,
545         token_encrypted -> Text,
546         published -> Timestamp,
547         local_user_id -> Int4,
548     }
549 }
550
551 diesel::table! {
552     person (id) {
553         id -> Int4,
554         #[max_length = 255]
555         name -> Varchar,
556         #[max_length = 255]
557         display_name -> Nullable<Varchar>,
558         avatar -> Nullable<Text>,
559         banned -> Bool,
560         published -> Timestamp,
561         updated -> Nullable<Timestamp>,
562         #[max_length = 255]
563         actor_id -> Varchar,
564         bio -> Nullable<Text>,
565         local -> Bool,
566         private_key -> Nullable<Text>,
567         public_key -> Text,
568         last_refreshed_at -> Timestamp,
569         banner -> Nullable<Text>,
570         deleted -> Bool,
571         #[max_length = 255]
572         inbox_url -> Varchar,
573         #[max_length = 255]
574         shared_inbox_url -> Nullable<Varchar>,
575         matrix_user_id -> Nullable<Text>,
576         admin -> Bool,
577         bot_account -> Bool,
578         ban_expires -> Nullable<Timestamp>,
579         instance_id -> Int4,
580     }
581 }
582
583 diesel::table! {
584     person_aggregates (id) {
585         id -> Int4,
586         person_id -> Int4,
587         post_count -> Int8,
588         post_score -> Int8,
589         comment_count -> Int8,
590         comment_score -> Int8,
591     }
592 }
593
594 diesel::table! {
595     person_ban (id) {
596         id -> Int4,
597         person_id -> Int4,
598         published -> Timestamp,
599     }
600 }
601
602 diesel::table! {
603     person_block (id) {
604         id -> Int4,
605         person_id -> Int4,
606         target_id -> Int4,
607         published -> Timestamp,
608     }
609 }
610
611 diesel::table! {
612     person_follower (id) {
613         id -> Int4,
614         person_id -> Int4,
615         follower_id -> Int4,
616         published -> Timestamp,
617         pending -> Bool,
618     }
619 }
620
621 diesel::table! {
622     person_mention (id) {
623         id -> Int4,
624         recipient_id -> Int4,
625         comment_id -> Int4,
626         read -> Bool,
627         published -> Timestamp,
628     }
629 }
630
631 diesel::table! {
632     person_post_aggregates (id) {
633         id -> Int4,
634         person_id -> Int4,
635         post_id -> Int4,
636         read_comments -> Int8,
637         published -> Timestamp,
638     }
639 }
640
641 diesel::table! {
642     post (id) {
643         id -> Int4,
644         #[max_length = 200]
645         name -> Varchar,
646         #[max_length = 512]
647         url -> Nullable<Varchar>,
648         body -> Nullable<Text>,
649         creator_id -> Int4,
650         community_id -> Int4,
651         removed -> Bool,
652         locked -> Bool,
653         published -> Timestamp,
654         updated -> Nullable<Timestamp>,
655         deleted -> Bool,
656         nsfw -> Bool,
657         embed_title -> Nullable<Text>,
658         embed_description -> Nullable<Text>,
659         thumbnail_url -> Nullable<Text>,
660         #[max_length = 255]
661         ap_id -> Varchar,
662         local -> Bool,
663         embed_video_url -> Nullable<Text>,
664         language_id -> Int4,
665         featured_community -> Bool,
666         featured_local -> Bool,
667     }
668 }
669
670 diesel::table! {
671     post_aggregates (id) {
672         id -> Int4,
673         post_id -> Int4,
674         comments -> Int8,
675         score -> Int8,
676         upvotes -> Int8,
677         downvotes -> Int8,
678         published -> Timestamp,
679         newest_comment_time_necro -> Timestamp,
680         newest_comment_time -> Timestamp,
681         featured_community -> Bool,
682         featured_local -> Bool,
683         hot_rank -> Int4,
684         hot_rank_active -> Int4,
685     }
686 }
687
688 diesel::table! {
689     post_like (id) {
690         id -> Int4,
691         post_id -> Int4,
692         person_id -> Int4,
693         score -> Int2,
694         published -> Timestamp,
695     }
696 }
697
698 diesel::table! {
699     post_read (id) {
700         id -> Int4,
701         post_id -> Int4,
702         person_id -> Int4,
703         published -> Timestamp,
704     }
705 }
706
707 diesel::table! {
708     post_report (id) {
709         id -> Int4,
710         creator_id -> Int4,
711         post_id -> Int4,
712         #[max_length = 200]
713         original_post_name -> Varchar,
714         original_post_url -> Nullable<Text>,
715         original_post_body -> Nullable<Text>,
716         reason -> Text,
717         resolved -> Bool,
718         resolver_id -> Nullable<Int4>,
719         published -> Timestamp,
720         updated -> Nullable<Timestamp>,
721     }
722 }
723
724 diesel::table! {
725     post_saved (id) {
726         id -> Int4,
727         post_id -> Int4,
728         person_id -> Int4,
729         published -> Timestamp,
730     }
731 }
732
733 diesel::table! {
734     private_message (id) {
735         id -> Int4,
736         creator_id -> Int4,
737         recipient_id -> Int4,
738         content -> Text,
739         deleted -> Bool,
740         read -> Bool,
741         published -> Timestamp,
742         updated -> Nullable<Timestamp>,
743         #[max_length = 255]
744         ap_id -> Varchar,
745         local -> Bool,
746     }
747 }
748
749 diesel::table! {
750     private_message_report (id) {
751         id -> Int4,
752         creator_id -> Int4,
753         private_message_id -> Int4,
754         original_pm_text -> Text,
755         reason -> Text,
756         resolved -> Bool,
757         resolver_id -> Nullable<Int4>,
758         published -> Timestamp,
759         updated -> Nullable<Timestamp>,
760     }
761 }
762
763 diesel::table! {
764     registration_application (id) {
765         id -> Int4,
766         local_user_id -> Int4,
767         answer -> Text,
768         admin_id -> Nullable<Int4>,
769         deny_reason -> Nullable<Text>,
770         published -> Timestamp,
771     }
772 }
773
774 diesel::table! {
775     secret (id) {
776         id -> Int4,
777         jwt_secret -> Varchar,
778     }
779 }
780
781 diesel::table! {
782     site (id) {
783         id -> Int4,
784         #[max_length = 20]
785         name -> Varchar,
786         sidebar -> Nullable<Text>,
787         published -> Timestamp,
788         updated -> Nullable<Timestamp>,
789         icon -> Nullable<Text>,
790         banner -> Nullable<Text>,
791         #[max_length = 150]
792         description -> Nullable<Varchar>,
793         #[max_length = 255]
794         actor_id -> Varchar,
795         last_refreshed_at -> Timestamp,
796         #[max_length = 255]
797         inbox_url -> Varchar,
798         private_key -> Nullable<Text>,
799         public_key -> Text,
800         instance_id -> Int4,
801     }
802 }
803
804 diesel::table! {
805     site_aggregates (id) {
806         id -> Int4,
807         site_id -> Int4,
808         users -> Int8,
809         posts -> Int8,
810         comments -> Int8,
811         communities -> Int8,
812         users_active_day -> Int8,
813         users_active_week -> Int8,
814         users_active_month -> Int8,
815         users_active_half_year -> Int8,
816     }
817 }
818
819 diesel::table! {
820     site_language (id) {
821         id -> Int4,
822         site_id -> Int4,
823         language_id -> Int4,
824     }
825 }
826
827 diesel::table! {
828     tagline (id) {
829         id -> Int4,
830         local_site_id -> Int4,
831         content -> Text,
832         published -> Timestamp,
833         updated -> Nullable<Timestamp>,
834     }
835 }
836
837 diesel::joinable!(admin_purge_comment -> person (admin_person_id));
838 diesel::joinable!(admin_purge_comment -> post (post_id));
839 diesel::joinable!(admin_purge_community -> person (admin_person_id));
840 diesel::joinable!(admin_purge_person -> person (admin_person_id));
841 diesel::joinable!(admin_purge_post -> community (community_id));
842 diesel::joinable!(admin_purge_post -> person (admin_person_id));
843 diesel::joinable!(comment -> language (language_id));
844 diesel::joinable!(comment -> person (creator_id));
845 diesel::joinable!(comment -> post (post_id));
846 diesel::joinable!(comment_aggregates -> comment (comment_id));
847 diesel::joinable!(comment_like -> comment (comment_id));
848 diesel::joinable!(comment_like -> person (person_id));
849 diesel::joinable!(comment_like -> post (post_id));
850 diesel::joinable!(comment_reply -> comment (comment_id));
851 diesel::joinable!(comment_reply -> person (recipient_id));
852 diesel::joinable!(comment_report -> comment (comment_id));
853 diesel::joinable!(comment_saved -> comment (comment_id));
854 diesel::joinable!(comment_saved -> person (person_id));
855 diesel::joinable!(community -> instance (instance_id));
856 diesel::joinable!(community_aggregates -> community (community_id));
857 diesel::joinable!(community_block -> community (community_id));
858 diesel::joinable!(community_block -> person (person_id));
859 diesel::joinable!(community_follower -> community (community_id));
860 diesel::joinable!(community_follower -> person (person_id));
861 diesel::joinable!(community_language -> community (community_id));
862 diesel::joinable!(community_language -> language (language_id));
863 diesel::joinable!(community_moderator -> community (community_id));
864 diesel::joinable!(community_moderator -> person (person_id));
865 diesel::joinable!(community_person_ban -> community (community_id));
866 diesel::joinable!(community_person_ban -> person (person_id));
867 diesel::joinable!(custom_emoji -> local_site (local_site_id));
868 diesel::joinable!(custom_emoji_keyword -> custom_emoji (custom_emoji_id));
869 diesel::joinable!(email_verification -> local_user (local_user_id));
870 diesel::joinable!(federation_allowlist -> instance (instance_id));
871 diesel::joinable!(federation_blocklist -> instance (instance_id));
872 diesel::joinable!(local_site -> site (site_id));
873 diesel::joinable!(local_site_rate_limit -> local_site (local_site_id));
874 diesel::joinable!(local_user -> person (person_id));
875 diesel::joinable!(local_user_language -> language (language_id));
876 diesel::joinable!(local_user_language -> local_user (local_user_id));
877 diesel::joinable!(mod_add_community -> community (community_id));
878 diesel::joinable!(mod_ban_from_community -> community (community_id));
879 diesel::joinable!(mod_feature_post -> person (mod_person_id));
880 diesel::joinable!(mod_feature_post -> post (post_id));
881 diesel::joinable!(mod_hide_community -> community (community_id));
882 diesel::joinable!(mod_hide_community -> person (mod_person_id));
883 diesel::joinable!(mod_lock_post -> person (mod_person_id));
884 diesel::joinable!(mod_lock_post -> post (post_id));
885 diesel::joinable!(mod_remove_comment -> comment (comment_id));
886 diesel::joinable!(mod_remove_comment -> person (mod_person_id));
887 diesel::joinable!(mod_remove_community -> community (community_id));
888 diesel::joinable!(mod_remove_community -> person (mod_person_id));
889 diesel::joinable!(mod_remove_post -> person (mod_person_id));
890 diesel::joinable!(mod_remove_post -> post (post_id));
891 diesel::joinable!(mod_transfer_community -> community (community_id));
892 diesel::joinable!(password_reset_request -> local_user (local_user_id));
893 diesel::joinable!(person -> instance (instance_id));
894 diesel::joinable!(person_aggregates -> person (person_id));
895 diesel::joinable!(person_ban -> person (person_id));
896 diesel::joinable!(person_mention -> comment (comment_id));
897 diesel::joinable!(person_mention -> person (recipient_id));
898 diesel::joinable!(person_post_aggregates -> person (person_id));
899 diesel::joinable!(person_post_aggregates -> post (post_id));
900 diesel::joinable!(post -> community (community_id));
901 diesel::joinable!(post -> language (language_id));
902 diesel::joinable!(post -> person (creator_id));
903 diesel::joinable!(post_aggregates -> post (post_id));
904 diesel::joinable!(post_like -> person (person_id));
905 diesel::joinable!(post_like -> post (post_id));
906 diesel::joinable!(post_read -> person (person_id));
907 diesel::joinable!(post_read -> post (post_id));
908 diesel::joinable!(post_report -> post (post_id));
909 diesel::joinable!(post_saved -> person (person_id));
910 diesel::joinable!(post_saved -> post (post_id));
911 diesel::joinable!(private_message_report -> private_message (private_message_id));
912 diesel::joinable!(registration_application -> local_user (local_user_id));
913 diesel::joinable!(registration_application -> person (admin_id));
914 diesel::joinable!(site -> instance (instance_id));
915 diesel::joinable!(site_aggregates -> site (site_id));
916 diesel::joinable!(site_language -> language (language_id));
917 diesel::joinable!(site_language -> site (site_id));
918 diesel::joinable!(tagline -> local_site (local_site_id));
919
920 diesel::allow_tables_to_appear_in_same_query!(
921     activity,
922     admin_purge_comment,
923     admin_purge_community,
924     admin_purge_person,
925     admin_purge_post,
926     captcha_answer,
927     comment,
928     comment_aggregates,
929     comment_like,
930     comment_reply,
931     comment_report,
932     comment_saved,
933     community,
934     community_aggregates,
935     community_block,
936     community_follower,
937     community_language,
938     community_moderator,
939     community_person_ban,
940     custom_emoji,
941     custom_emoji_keyword,
942     email_verification,
943     federation_allowlist,
944     federation_blocklist,
945     instance,
946     language,
947     local_site,
948     local_site_rate_limit,
949     local_user,
950     local_user_language,
951     mod_add,
952     mod_add_community,
953     mod_ban,
954     mod_ban_from_community,
955     mod_feature_post,
956     mod_hide_community,
957     mod_lock_post,
958     mod_remove_comment,
959     mod_remove_community,
960     mod_remove_post,
961     mod_transfer_community,
962     password_reset_request,
963     person,
964     person_aggregates,
965     person_ban,
966     person_block,
967     person_follower,
968     person_mention,
969     person_post_aggregates,
970     post,
971     post_aggregates,
972     post_like,
973     post_read,
974     post_report,
975     post_saved,
976     private_message,
977     private_message_report,
978     registration_application,
979     secret,
980     site,
981     site_aggregates,
982     site_language,
983     tagline,
984 );