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     }
  99 }
 100
 101 diesel::table! {
 102     comment_like (id) {
 103         id -> Int4,
 104         person_id -> Int4,
 105         comment_id -> Int4,
 106         post_id -> Int4,
 107         score -> Int2,
 108         published -> Timestamp,
 109     }
 110 }
 111
 112 diesel::table! {
 113     comment_reply (id) {
 114         id -> Int4,
 115         recipient_id -> Int4,
 116         comment_id -> Int4,
 117         read -> Bool,
 118         published -> Timestamp,
 119     }
 120 }
 121
 122 diesel::table! {
 123     comment_report (id) {
 124         id -> Int4,
 125         creator_id -> Int4,
 126         comment_id -> Int4,
 127         original_comment_text -> Text,
 128         reason -> Text,
 129         resolved -> Bool,
 130         resolver_id -> Nullable<Int4>,
 131         published -> Timestamp,
 132         updated -> Nullable<Timestamp>,
 133     }
 134 }
 135
 136 diesel::table! {
 137     comment_saved (id) {
 138         id -> Int4,
 139         comment_id -> Int4,
 140         person_id -> Int4,
 141         published -> Timestamp,
 142     }
 143 }
 144
 145 diesel::table! {
 146     community (id) {
 147         id -> Int4,
 148         #[max_length = 255]
 149         name -> Varchar,
 150         #[max_length = 255]
 151         title -> Varchar,
 152         description -> Nullable<Text>,
 153         removed -> Bool,
 154         published -> Timestamp,
 155         updated -> Nullable<Timestamp>,
 156         deleted -> Bool,
 157         nsfw -> Bool,
 158         #[max_length = 255]
 159         actor_id -> Varchar,
 160         local -> Bool,
 161         private_key -> Nullable<Text>,
 162         public_key -> Text,
 163         last_refreshed_at -> Timestamp,
 164         icon -> Nullable<Text>,
 165         banner -> Nullable<Text>,
 166         #[max_length = 255]
 167         followers_url -> Varchar,
 168         #[max_length = 255]
 169         inbox_url -> Varchar,
 170         #[max_length = 255]
 171         shared_inbox_url -> Nullable<Varchar>,
 172         hidden -> Bool,
 173         posting_restricted_to_mods -> Bool,
 174         instance_id -> Int4,
 175         #[max_length = 255]
 176         moderators_url -> Nullable<Varchar>,
 177         #[max_length = 255]
 178         featured_url -> Nullable<Varchar>,
 179     }
 180 }
 181
 182 diesel::table! {
 183     community_aggregates (id) {
 184         id -> Int4,
 185         community_id -> Int4,
 186         subscribers -> Int8,
 187         posts -> Int8,
 188         comments -> Int8,
 189         published -> Timestamp,
 190         users_active_day -> Int8,
 191         users_active_week -> Int8,
 192         users_active_month -> Int8,
 193         users_active_half_year -> Int8,
 194     }
 195 }
 196
 197 diesel::table! {
 198     community_block (id) {
 199         id -> Int4,
 200         person_id -> Int4,
 201         community_id -> Int4,
 202         published -> Timestamp,
 203     }
 204 }
 205
 206 diesel::table! {
 207     community_follower (id) {
 208         id -> Int4,
 209         community_id -> Int4,
 210         person_id -> Int4,
 211         published -> Timestamp,
 212         pending -> Bool,
 213     }
 214 }
 215
 216 diesel::table! {
 217     community_language (id) {
 218         id -> Int4,
 219         community_id -> Int4,
 220         language_id -> Int4,
 221     }
 222 }
 223
 224 diesel::table! {
 225     community_moderator (id) {
 226         id -> Int4,
 227         community_id -> Int4,
 228         person_id -> Int4,
 229         published -> Timestamp,
 230     }
 231 }
 232
 233 diesel::table! {
 234     community_person_ban (id) {
 235         id -> Int4,
 236         community_id -> Int4,
 237         person_id -> Int4,
 238         published -> Timestamp,
 239         expires -> Nullable<Timestamp>,
 240     }
 241 }
 242
 243 diesel::table! {
 244     custom_emoji (id) {
 245         id -> Int4,
 246         local_site_id -> Int4,
 247         #[max_length = 128]
 248         shortcode -> Varchar,
 249         image_url -> Text,
 250         alt_text -> Text,
 251         category -> Text,
 252         published -> Timestamp,
 253         updated -> Nullable<Timestamp>,
 254     }
 255 }
 256
 257 diesel::table! {
 258     custom_emoji_keyword (id) {
 259         id -> Int4,
 260         custom_emoji_id -> Int4,
 261         #[max_length = 128]
 262         keyword -> Varchar,
 263     }
 264 }
 265
 266 diesel::table! {
 267     email_verification (id) {
 268         id -> Int4,
 269         local_user_id -> Int4,
 270         email -> Text,
 271         verification_token -> Text,
 272         published -> Timestamp,
 273     }
 274 }
 275
 276 diesel::table! {
 277     federation_allowlist (id) {
 278         id -> Int4,
 279         instance_id -> Int4,
 280         published -> Timestamp,
 281         updated -> Nullable<Timestamp>,
 282     }
 283 }
 284
 285 diesel::table! {
 286     federation_blocklist (id) {
 287         id -> Int4,
 288         instance_id -> Int4,
 289         published -> Timestamp,
 290         updated -> Nullable<Timestamp>,
 291     }
 292 }
 293
 294 diesel::table! {
 295     instance (id) {
 296         id -> Int4,
 297         #[max_length = 255]
 298         domain -> Varchar,
 299         published -> Timestamp,
 300         updated -> Nullable<Timestamp>,
 301         #[max_length = 255]
 302         software -> Nullable<Varchar>,
 303         #[max_length = 255]
 304         version -> Nullable<Varchar>,
 305     }
 306 }
 307
 308 diesel::table! {
 309     language (id) {
 310         id -> Int4,
 311         #[max_length = 3]
 312         code -> Varchar,
 313         name -> Text,
 314     }
 315 }
 316
 317 diesel::table! {
 318     use diesel::sql_types::{Bool, Int4, Nullable, Text, Timestamp, Varchar};
 319     use super::sql_types::ListingTypeEnum;
 320     use super::sql_types::RegistrationModeEnum;
 321
 322     local_site (id) {
 323         id -> Int4,
 324         site_id -> Int4,
 325         site_setup -> Bool,
 326         enable_downvotes -> Bool,
 327         enable_nsfw -> Bool,
 328         community_creation_admin_only -> Bool,
 329         require_email_verification -> Bool,
 330         application_question -> Nullable<Text>,
 331         private_instance -> Bool,
 332         default_theme -> Text,
 333         default_post_listing_type -> ListingTypeEnum,
 334         legal_information -> Nullable<Text>,
 335         hide_modlog_mod_names -> Bool,
 336         application_email_admins -> Bool,
 337         slur_filter_regex -> Nullable<Text>,
 338         actor_name_max_length -> Int4,
 339         federation_enabled -> Bool,
 340         federation_worker_count -> Int4,
 341         captcha_enabled -> Bool,
 342         #[max_length = 255]
 343         captcha_difficulty -> Varchar,
 344         published -> Timestamp,
 345         updated -> Nullable<Timestamp>,
 346         registration_mode -> RegistrationModeEnum,
 347         reports_email_admins -> Bool,
 348     }
 349 }
 350
 351 diesel::table! {
 352     local_site_rate_limit (id) {
 353         id -> Int4,
 354         local_site_id -> Int4,
 355         message -> Int4,
 356         message_per_second -> Int4,
 357         post -> Int4,
 358         post_per_second -> Int4,
 359         register -> Int4,
 360         register_per_second -> Int4,
 361         image -> Int4,
 362         image_per_second -> Int4,
 363         comment -> Int4,
 364         comment_per_second -> Int4,
 365         search -> Int4,
 366         search_per_second -> Int4,
 367         published -> Timestamp,
 368         updated -> Nullable<Timestamp>,
 369     }
 370 }
 371
 372 diesel::table! {
 373     use diesel::sql_types::{Bool, Int4, Nullable, Text, Timestamp, Varchar};
 374     use super::sql_types::SortTypeEnum;
 375     use super::sql_types::ListingTypeEnum;
 376
 377     local_user (id) {
 378         id -> Int4,
 379         person_id -> Int4,
 380         password_encrypted -> Text,
 381         email -> Nullable<Text>,
 382         show_nsfw -> Bool,
 383         #[max_length = 20]
 384         theme -> Varchar,
 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         url -> Nullable<Text>,
 638         body -> Nullable<Text>,
 639         creator_id -> Int4,
 640         community_id -> Int4,
 641         removed -> Bool,
 642         locked -> Bool,
 643         published -> Timestamp,
 644         updated -> Nullable<Timestamp>,
 645         deleted -> Bool,
 646         nsfw -> Bool,
 647         embed_title -> Nullable<Text>,
 648         embed_description -> Nullable<Text>,
 649         thumbnail_url -> Nullable<Text>,
 650         #[max_length = 255]
 651         ap_id -> Varchar,
 652         local -> Bool,
 653         embed_video_url -> Nullable<Text>,
 654         language_id -> Int4,
 655         featured_community -> Bool,
 656         featured_local -> Bool,
 657     }
 658 }
 659
 660 diesel::table! {
 661     post_aggregates (id) {
 662         id -> Int4,
 663         post_id -> Int4,
 664         comments -> Int8,
 665         score -> Int8,
 666         upvotes -> Int8,
 667         downvotes -> Int8,
 668         published -> Timestamp,
 669         newest_comment_time_necro -> Timestamp,
 670         newest_comment_time -> Timestamp,
 671         featured_community -> Bool,
 672         featured_local -> Bool,
 673     }
 674 }
 675
 676 diesel::table! {
 677     post_like (id) {
 678         id -> Int4,
 679         post_id -> Int4,
 680         person_id -> Int4,
 681         score -> Int2,
 682         published -> Timestamp,
 683     }
 684 }
 685
 686 diesel::table! {
 687     post_read (id) {
 688         id -> Int4,
 689         post_id -> Int4,
 690         person_id -> Int4,
 691         published -> Timestamp,
 692     }
 693 }
 694
 695 diesel::table! {
 696     post_report (id) {
 697         id -> Int4,
 698         creator_id -> Int4,
 699         post_id -> Int4,
 700         #[max_length = 200]
 701         original_post_name -> Varchar,
 702         original_post_url -> Nullable<Text>,
 703         original_post_body -> Nullable<Text>,
 704         reason -> Text,
 705         resolved -> Bool,
 706         resolver_id -> Nullable<Int4>,
 707         published -> Timestamp,
 708         updated -> Nullable<Timestamp>,
 709     }
 710 }
 711
 712 diesel::table! {
 713     post_saved (id) {
 714         id -> Int4,
 715         post_id -> Int4,
 716         person_id -> Int4,
 717         published -> Timestamp,
 718     }
 719 }
 720
 721 diesel::table! {
 722     private_message (id) {
 723         id -> Int4,
 724         creator_id -> Int4,
 725         recipient_id -> Int4,
 726         content -> Text,
 727         deleted -> Bool,
 728         read -> Bool,
 729         published -> Timestamp,
 730         updated -> Nullable<Timestamp>,
 731         #[max_length = 255]
 732         ap_id -> Varchar,
 733         local -> Bool,
 734     }
 735 }
 736
 737 diesel::table! {
 738     private_message_report (id) {
 739         id -> Int4,
 740         creator_id -> Int4,
 741         private_message_id -> Int4,
 742         original_pm_text -> Text,
 743         reason -> Text,
 744         resolved -> Bool,
 745         resolver_id -> Nullable<Int4>,
 746         published -> Timestamp,
 747         updated -> Nullable<Timestamp>,
 748     }
 749 }
 750
 751 diesel::table! {
 752     registration_application (id) {
 753         id -> Int4,
 754         local_user_id -> Int4,
 755         answer -> Text,
 756         admin_id -> Nullable<Int4>,
 757         deny_reason -> Nullable<Text>,
 758         published -> Timestamp,
 759     }
 760 }
 761
 762 diesel::table! {
 763     secret (id) {
 764         id -> Int4,
 765         jwt_secret -> Varchar,
 766     }
 767 }
 768
 769 diesel::table! {
 770     site (id) {
 771         id -> Int4,
 772         #[max_length = 20]
 773         name -> Varchar,
 774         sidebar -> Nullable<Text>,
 775         published -> Timestamp,
 776         updated -> Nullable<Timestamp>,
 777         icon -> Nullable<Text>,
 778         banner -> Nullable<Text>,
 779         #[max_length = 150]
 780         description -> Nullable<Varchar>,
 781         #[max_length = 255]
 782         actor_id -> Varchar,
 783         last_refreshed_at -> Timestamp,
 784         #[max_length = 255]
 785         inbox_url -> Varchar,
 786         private_key -> Nullable<Text>,
 787         public_key -> Text,
 788         instance_id -> Int4,
 789     }
 790 }
 791
 792 diesel::table! {
 793     site_aggregates (id) {
 794         id -> Int4,
 795         site_id -> Int4,
 796         users -> Int8,
 797         posts -> Int8,
 798         comments -> Int8,
 799         communities -> Int8,
 800         users_active_day -> Int8,
 801         users_active_week -> Int8,
 802         users_active_month -> Int8,
 803         users_active_half_year -> Int8,
 804     }
 805 }
 806
 807 diesel::table! {
 808     site_language (id) {
 809         id -> Int4,
 810         site_id -> Int4,
 811         language_id -> Int4,
 812     }
 813 }
 814
 815 diesel::table! {
 816     tagline (id) {
 817         id -> Int4,
 818         local_site_id -> Int4,
 819         content -> Text,
 820         published -> Timestamp,
 821         updated -> Nullable<Timestamp>,
 822     }
 823 }
 824
 825 diesel::joinable!(admin_purge_comment -> person (admin_person_id));
 826 diesel::joinable!(admin_purge_comment -> post (post_id));
 827 diesel::joinable!(admin_purge_community -> person (admin_person_id));
 828 diesel::joinable!(admin_purge_person -> person (admin_person_id));
 829 diesel::joinable!(admin_purge_post -> community (community_id));
 830 diesel::joinable!(admin_purge_post -> person (admin_person_id));
 831 diesel::joinable!(comment -> language (language_id));
 832 diesel::joinable!(comment -> person (creator_id));
 833 diesel::joinable!(comment -> post (post_id));
 834 diesel::joinable!(comment_aggregates -> comment (comment_id));
 835 diesel::joinable!(comment_like -> comment (comment_id));
 836 diesel::joinable!(comment_like -> person (person_id));
 837 diesel::joinable!(comment_like -> post (post_id));
 838 diesel::joinable!(comment_reply -> comment (comment_id));
 839 diesel::joinable!(comment_reply -> person (recipient_id));
 840 diesel::joinable!(comment_report -> comment (comment_id));
 841 diesel::joinable!(comment_saved -> comment (comment_id));
 842 diesel::joinable!(comment_saved -> person (person_id));
 843 diesel::joinable!(community -> instance (instance_id));
 844 diesel::joinable!(community_aggregates -> community (community_id));
 845 diesel::joinable!(community_block -> community (community_id));
 846 diesel::joinable!(community_block -> person (person_id));
 847 diesel::joinable!(community_follower -> community (community_id));
 848 diesel::joinable!(community_follower -> person (person_id));
 849 diesel::joinable!(community_language -> community (community_id));
 850 diesel::joinable!(community_language -> language (language_id));
 851 diesel::joinable!(community_moderator -> community (community_id));
 852 diesel::joinable!(community_moderator -> person (person_id));
 853 diesel::joinable!(community_person_ban -> community (community_id));
 854 diesel::joinable!(community_person_ban -> person (person_id));
 855 diesel::joinable!(custom_emoji -> local_site (local_site_id));
 856 diesel::joinable!(custom_emoji_keyword -> custom_emoji (custom_emoji_id));
 857 diesel::joinable!(email_verification -> local_user (local_user_id));
 858 diesel::joinable!(federation_allowlist -> instance (instance_id));
 859 diesel::joinable!(federation_blocklist -> instance (instance_id));
 860 diesel::joinable!(local_site -> site (site_id));
 861 diesel::joinable!(local_site_rate_limit -> local_site (local_site_id));
 862 diesel::joinable!(local_user -> person (person_id));
 863 diesel::joinable!(local_user_language -> language (language_id));
 864 diesel::joinable!(local_user_language -> local_user (local_user_id));
 865 diesel::joinable!(mod_add_community -> community (community_id));
 866 diesel::joinable!(mod_ban_from_community -> community (community_id));
 867 diesel::joinable!(mod_feature_post -> person (mod_person_id));
 868 diesel::joinable!(mod_feature_post -> post (post_id));
 869 diesel::joinable!(mod_hide_community -> community (community_id));
 870 diesel::joinable!(mod_hide_community -> person (mod_person_id));
 871 diesel::joinable!(mod_lock_post -> person (mod_person_id));
 872 diesel::joinable!(mod_lock_post -> post (post_id));
 873 diesel::joinable!(mod_remove_comment -> comment (comment_id));
 874 diesel::joinable!(mod_remove_comment -> person (mod_person_id));
 875 diesel::joinable!(mod_remove_community -> community (community_id));
 876 diesel::joinable!(mod_remove_community -> person (mod_person_id));
 877 diesel::joinable!(mod_remove_post -> person (mod_person_id));
 878 diesel::joinable!(mod_remove_post -> post (post_id));
 879 diesel::joinable!(mod_transfer_community -> community (community_id));
 880 diesel::joinable!(password_reset_request -> local_user (local_user_id));
 881 diesel::joinable!(person -> instance (instance_id));
 882 diesel::joinable!(person_aggregates -> person (person_id));
 883 diesel::joinable!(person_ban -> person (person_id));
 884 diesel::joinable!(person_mention -> comment (comment_id));
 885 diesel::joinable!(person_mention -> person (recipient_id));
 886 diesel::joinable!(person_post_aggregates -> person (person_id));
 887 diesel::joinable!(person_post_aggregates -> post (post_id));
 888 diesel::joinable!(post -> community (community_id));
 889 diesel::joinable!(post -> language (language_id));
 890 diesel::joinable!(post -> person (creator_id));
 891 diesel::joinable!(post_aggregates -> post (post_id));
 892 diesel::joinable!(post_like -> person (person_id));
 893 diesel::joinable!(post_like -> post (post_id));
 894 diesel::joinable!(post_read -> person (person_id));
 895 diesel::joinable!(post_read -> post (post_id));
 896 diesel::joinable!(post_report -> post (post_id));
 897 diesel::joinable!(post_saved -> person (person_id));
 898 diesel::joinable!(post_saved -> post (post_id));
 899 diesel::joinable!(private_message_report -> private_message (private_message_id));
 900 diesel::joinable!(registration_application -> local_user (local_user_id));
 901 diesel::joinable!(registration_application -> person (admin_id));
 902 diesel::joinable!(site -> instance (instance_id));
 903 diesel::joinable!(site_aggregates -> site (site_id));
 904 diesel::joinable!(site_language -> language (language_id));
 905 diesel::joinable!(site_language -> site (site_id));
 906 diesel::joinable!(tagline -> local_site (local_site_id));
 907
 908 diesel::allow_tables_to_appear_in_same_query!(
 909     activity,
 910     admin_purge_comment,
 911     admin_purge_community,
 912     admin_purge_person,
 913     admin_purge_post,
 914     comment,
 915     comment_aggregates,
 916     comment_like,
 917     comment_reply,
 918     comment_report,
 919     comment_saved,
 920     community,
 921     community_aggregates,
 922     community_block,
 923     community_follower,
 924     community_language,
 925     community_moderator,
 926     community_person_ban,
 927     custom_emoji,
 928     custom_emoji_keyword,
 929     email_verification,
 930     federation_allowlist,
 931     federation_blocklist,
 932     instance,
 933     language,
 934     local_site,
 935     local_site_rate_limit,
 936     local_user,
 937     local_user_language,
 938     mod_add,
 939     mod_add_community,
 940     mod_ban,
 941     mod_ban_from_community,
 942     mod_feature_post,
 943     mod_hide_community,
 944     mod_lock_post,
 945     mod_remove_comment,
 946     mod_remove_community,
 947     mod_remove_post,
 948     mod_transfer_community,
 949     password_reset_request,
 950     person,
 951     person_aggregates,
 952     person_ban,
 953     person_block,
 954     person_follower,
 955     person_mention,
 956     person_post_aggregates,
 957     post,
 958     post_aggregates,
 959     post_like,
 960     post_read,
 961     post_report,
 962     post_saved,
 963     private_message,
 964     private_message_report,
 965     registration_application,
 966     secret,
 967     site,
 968     site_aggregates,
 969     site_language,
 970     tagline,
 971 );