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