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