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         #[max_length = 20]
 385         theme -> Varchar,
 386         default_sort_type -> SortTypeEnum,
 387         default_listing_type -> ListingTypeEnum,
 388         #[max_length = 20]
 389         interface_language -> Varchar,
 390         show_avatars -> Bool,
 391         send_notifications_to_email -> Bool,
 392         validator_time -> Timestamp,
 393         show_scores -> Bool,
 394         show_bot_accounts -> Bool,
 395         show_read_posts -> Bool,
 396         show_new_post_notifs -> Bool,
 397         email_verified -> Bool,
 398         accepted_application -> Bool,
 399         totp_2fa_secret -> Nullable<Text>,
 400         totp_2fa_url -> Nullable<Text>,
 401     }
 402 }
 403
 404 diesel::table! {
 405     local_user_language (id) {
 406         id -> Int4,
 407         local_user_id -> Int4,
 408         language_id -> Int4,
 409     }
 410 }
 411
 412 diesel::table! {
 413     mod_add (id) {
 414         id -> Int4,
 415         mod_person_id -> Int4,
 416         other_person_id -> Int4,
 417         removed -> Bool,
 418         when_ -> Timestamp,
 419     }
 420 }
 421
 422 diesel::table! {
 423     mod_add_community (id) {
 424         id -> Int4,
 425         mod_person_id -> Int4,
 426         other_person_id -> Int4,
 427         community_id -> Int4,
 428         removed -> Bool,
 429         when_ -> Timestamp,
 430     }
 431 }
 432
 433 diesel::table! {
 434     mod_ban (id) {
 435         id -> Int4,
 436         mod_person_id -> Int4,
 437         other_person_id -> Int4,
 438         reason -> Nullable<Text>,
 439         banned -> Bool,
 440         expires -> Nullable<Timestamp>,
 441         when_ -> Timestamp,
 442     }
 443 }
 444
 445 diesel::table! {
 446     mod_ban_from_community (id) {
 447         id -> Int4,
 448         mod_person_id -> Int4,
 449         other_person_id -> Int4,
 450         community_id -> Int4,
 451         reason -> Nullable<Text>,
 452         banned -> Bool,
 453         expires -> Nullable<Timestamp>,
 454         when_ -> Timestamp,
 455     }
 456 }
 457
 458 diesel::table! {
 459     mod_feature_post (id) {
 460         id -> Int4,
 461         mod_person_id -> Int4,
 462         post_id -> Int4,
 463         featured -> Bool,
 464         when_ -> Timestamp,
 465         is_featured_community -> Bool,
 466     }
 467 }
 468
 469 diesel::table! {
 470     mod_hide_community (id) {
 471         id -> Int4,
 472         community_id -> Int4,
 473         mod_person_id -> Int4,
 474         when_ -> Timestamp,
 475         reason -> Nullable<Text>,
 476         hidden -> Bool,
 477     }
 478 }
 479
 480 diesel::table! {
 481     mod_lock_post (id) {
 482         id -> Int4,
 483         mod_person_id -> Int4,
 484         post_id -> Int4,
 485         locked -> Bool,
 486         when_ -> Timestamp,
 487     }
 488 }
 489
 490 diesel::table! {
 491     mod_remove_comment (id) {
 492         id -> Int4,
 493         mod_person_id -> Int4,
 494         comment_id -> Int4,
 495         reason -> Nullable<Text>,
 496         removed -> Bool,
 497         when_ -> Timestamp,
 498     }
 499 }
 500
 501 diesel::table! {
 502     mod_remove_community (id) {
 503         id -> Int4,
 504         mod_person_id -> Int4,
 505         community_id -> Int4,
 506         reason -> Nullable<Text>,
 507         removed -> Bool,
 508         expires -> Nullable<Timestamp>,
 509         when_ -> Timestamp,
 510     }
 511 }
 512
 513 diesel::table! {
 514     mod_remove_post (id) {
 515         id -> Int4,
 516         mod_person_id -> Int4,
 517         post_id -> Int4,
 518         reason -> Nullable<Text>,
 519         removed -> Bool,
 520         when_ -> Timestamp,
 521     }
 522 }
 523
 524 diesel::table! {
 525     mod_transfer_community (id) {
 526         id -> Int4,
 527         mod_person_id -> Int4,
 528         other_person_id -> Int4,
 529         community_id -> Int4,
 530         when_ -> Timestamp,
 531     }
 532 }
 533
 534 diesel::table! {
 535     password_reset_request (id) {
 536         id -> Int4,
 537         token_encrypted -> Text,
 538         published -> Timestamp,
 539         local_user_id -> Int4,
 540     }
 541 }
 542
 543 diesel::table! {
 544     person (id) {
 545         id -> Int4,
 546         #[max_length = 255]
 547         name -> Varchar,
 548         #[max_length = 255]
 549         display_name -> Nullable<Varchar>,
 550         avatar -> Nullable<Text>,
 551         banned -> Bool,
 552         published -> Timestamp,
 553         updated -> Nullable<Timestamp>,
 554         #[max_length = 255]
 555         actor_id -> Varchar,
 556         bio -> Nullable<Text>,
 557         local -> Bool,
 558         private_key -> Nullable<Text>,
 559         public_key -> Text,
 560         last_refreshed_at -> Timestamp,
 561         banner -> Nullable<Text>,
 562         deleted -> Bool,
 563         #[max_length = 255]
 564         inbox_url -> Varchar,
 565         #[max_length = 255]
 566         shared_inbox_url -> Nullable<Varchar>,
 567         matrix_user_id -> Nullable<Text>,
 568         admin -> Bool,
 569         bot_account -> Bool,
 570         ban_expires -> Nullable<Timestamp>,
 571         instance_id -> Int4,
 572     }
 573 }
 574
 575 diesel::table! {
 576     person_aggregates (id) {
 577         id -> Int4,
 578         person_id -> Int4,
 579         post_count -> Int8,
 580         post_score -> Int8,
 581         comment_count -> Int8,
 582         comment_score -> Int8,
 583     }
 584 }
 585
 586 diesel::table! {
 587     person_ban (id) {
 588         id -> Int4,
 589         person_id -> Int4,
 590         published -> Timestamp,
 591     }
 592 }
 593
 594 diesel::table! {
 595     person_block (id) {
 596         id -> Int4,
 597         person_id -> Int4,
 598         target_id -> Int4,
 599         published -> Timestamp,
 600     }
 601 }
 602
 603 diesel::table! {
 604     person_follower (id) {
 605         id -> Int4,
 606         person_id -> Int4,
 607         follower_id -> Int4,
 608         published -> Timestamp,
 609         pending -> Bool,
 610     }
 611 }
 612
 613 diesel::table! {
 614     person_mention (id) {
 615         id -> Int4,
 616         recipient_id -> Int4,
 617         comment_id -> Int4,
 618         read -> Bool,
 619         published -> Timestamp,
 620     }
 621 }
 622
 623 diesel::table! {
 624     person_post_aggregates (id) {
 625         id -> Int4,
 626         person_id -> Int4,
 627         post_id -> Int4,
 628         read_comments -> Int8,
 629         published -> Timestamp,
 630     }
 631 }
 632
 633 diesel::table! {
 634     post (id) {
 635         id -> Int4,
 636         #[max_length = 200]
 637         name -> Varchar,
 638         #[max_length = 512]
 639         url -> Nullable<Varchar>,
 640         body -> Nullable<Text>,
 641         creator_id -> Int4,
 642         community_id -> Int4,
 643         removed -> Bool,
 644         locked -> Bool,
 645         published -> Timestamp,
 646         updated -> Nullable<Timestamp>,
 647         deleted -> Bool,
 648         nsfw -> Bool,
 649         embed_title -> Nullable<Text>,
 650         embed_description -> Nullable<Text>,
 651         thumbnail_url -> Nullable<Text>,
 652         #[max_length = 255]
 653         ap_id -> Varchar,
 654         local -> Bool,
 655         embed_video_url -> Nullable<Text>,
 656         language_id -> Int4,
 657         featured_community -> Bool,
 658         featured_local -> Bool,
 659     }
 660 }
 661
 662 diesel::table! {
 663     post_aggregates (id) {
 664         id -> Int4,
 665         post_id -> Int4,
 666         comments -> Int8,
 667         score -> Int8,
 668         upvotes -> Int8,
 669         downvotes -> Int8,
 670         published -> Timestamp,
 671         newest_comment_time_necro -> Timestamp,
 672         newest_comment_time -> Timestamp,
 673         featured_community -> Bool,
 674         featured_local -> Bool,
 675         hot_rank -> Int4,
 676         hot_rank_active -> Int4,
 677     }
 678 }
 679
 680 diesel::table! {
 681     post_like (id) {
 682         id -> Int4,
 683         post_id -> Int4,
 684         person_id -> Int4,
 685         score -> Int2,
 686         published -> Timestamp,
 687     }
 688 }
 689
 690 diesel::table! {
 691     post_read (id) {
 692         id -> Int4,
 693         post_id -> Int4,
 694         person_id -> Int4,
 695         published -> Timestamp,
 696     }
 697 }
 698
 699 diesel::table! {
 700     post_report (id) {
 701         id -> Int4,
 702         creator_id -> Int4,
 703         post_id -> Int4,
 704         #[max_length = 200]
 705         original_post_name -> Varchar,
 706         original_post_url -> Nullable<Text>,
 707         original_post_body -> Nullable<Text>,
 708         reason -> Text,
 709         resolved -> Bool,
 710         resolver_id -> Nullable<Int4>,
 711         published -> Timestamp,
 712         updated -> Nullable<Timestamp>,
 713     }
 714 }
 715
 716 diesel::table! {
 717     post_saved (id) {
 718         id -> Int4,
 719         post_id -> Int4,
 720         person_id -> Int4,
 721         published -> Timestamp,
 722     }
 723 }
 724
 725 diesel::table! {
 726     private_message (id) {
 727         id -> Int4,
 728         creator_id -> Int4,
 729         recipient_id -> Int4,
 730         content -> Text,
 731         deleted -> Bool,
 732         read -> Bool,
 733         published -> Timestamp,
 734         updated -> Nullable<Timestamp>,
 735         #[max_length = 255]
 736         ap_id -> Varchar,
 737         local -> Bool,
 738     }
 739 }
 740
 741 diesel::table! {
 742     private_message_report (id) {
 743         id -> Int4,
 744         creator_id -> Int4,
 745         private_message_id -> Int4,
 746         original_pm_text -> Text,
 747         reason -> Text,
 748         resolved -> Bool,
 749         resolver_id -> Nullable<Int4>,
 750         published -> Timestamp,
 751         updated -> Nullable<Timestamp>,
 752     }
 753 }
 754
 755 diesel::table! {
 756     registration_application (id) {
 757         id -> Int4,
 758         local_user_id -> Int4,
 759         answer -> Text,
 760         admin_id -> Nullable<Int4>,
 761         deny_reason -> Nullable<Text>,
 762         published -> Timestamp,
 763     }
 764 }
 765
 766 diesel::table! {
 767     secret (id) {
 768         id -> Int4,
 769         jwt_secret -> Varchar,
 770     }
 771 }
 772
 773 diesel::table! {
 774     site (id) {
 775         id -> Int4,
 776         #[max_length = 20]
 777         name -> Varchar,
 778         sidebar -> Nullable<Text>,
 779         published -> Timestamp,
 780         updated -> Nullable<Timestamp>,
 781         icon -> Nullable<Text>,
 782         banner -> Nullable<Text>,
 783         #[max_length = 150]
 784         description -> Nullable<Varchar>,
 785         #[max_length = 255]
 786         actor_id -> Varchar,
 787         last_refreshed_at -> Timestamp,
 788         #[max_length = 255]
 789         inbox_url -> Varchar,
 790         private_key -> Nullable<Text>,
 791         public_key -> Text,
 792         instance_id -> Int4,
 793     }
 794 }
 795
 796 diesel::table! {
 797     site_aggregates (id) {
 798         id -> Int4,
 799         site_id -> Int4,
 800         users -> Int8,
 801         posts -> Int8,
 802         comments -> Int8,
 803         communities -> Int8,
 804         users_active_day -> Int8,
 805         users_active_week -> Int8,
 806         users_active_month -> Int8,
 807         users_active_half_year -> Int8,
 808     }
 809 }
 810
 811 diesel::table! {
 812     site_language (id) {
 813         id -> Int4,
 814         site_id -> Int4,
 815         language_id -> Int4,
 816     }
 817 }
 818
 819 diesel::table! {
 820     tagline (id) {
 821         id -> Int4,
 822         local_site_id -> Int4,
 823         content -> Text,
 824         published -> Timestamp,
 825         updated -> Nullable<Timestamp>,
 826     }
 827 }
 828
 829 diesel::joinable!(admin_purge_comment -> person (admin_person_id));
 830 diesel::joinable!(admin_purge_comment -> post (post_id));
 831 diesel::joinable!(admin_purge_community -> person (admin_person_id));
 832 diesel::joinable!(admin_purge_person -> person (admin_person_id));
 833 diesel::joinable!(admin_purge_post -> community (community_id));
 834 diesel::joinable!(admin_purge_post -> person (admin_person_id));
 835 diesel::joinable!(comment -> language (language_id));
 836 diesel::joinable!(comment -> person (creator_id));
 837 diesel::joinable!(comment -> post (post_id));
 838 diesel::joinable!(comment_aggregates -> comment (comment_id));
 839 diesel::joinable!(comment_like -> comment (comment_id));
 840 diesel::joinable!(comment_like -> person (person_id));
 841 diesel::joinable!(comment_like -> post (post_id));
 842 diesel::joinable!(comment_reply -> comment (comment_id));
 843 diesel::joinable!(comment_reply -> person (recipient_id));
 844 diesel::joinable!(comment_report -> comment (comment_id));
 845 diesel::joinable!(comment_saved -> comment (comment_id));
 846 diesel::joinable!(comment_saved -> person (person_id));
 847 diesel::joinable!(community -> instance (instance_id));
 848 diesel::joinable!(community_aggregates -> community (community_id));
 849 diesel::joinable!(community_block -> community (community_id));
 850 diesel::joinable!(community_block -> person (person_id));
 851 diesel::joinable!(community_follower -> community (community_id));
 852 diesel::joinable!(community_follower -> person (person_id));
 853 diesel::joinable!(community_language -> community (community_id));
 854 diesel::joinable!(community_language -> language (language_id));
 855 diesel::joinable!(community_moderator -> community (community_id));
 856 diesel::joinable!(community_moderator -> person (person_id));
 857 diesel::joinable!(community_person_ban -> community (community_id));
 858 diesel::joinable!(community_person_ban -> person (person_id));
 859 diesel::joinable!(custom_emoji -> local_site (local_site_id));
 860 diesel::joinable!(custom_emoji_keyword -> custom_emoji (custom_emoji_id));
 861 diesel::joinable!(email_verification -> local_user (local_user_id));
 862 diesel::joinable!(federation_allowlist -> instance (instance_id));
 863 diesel::joinable!(federation_blocklist -> instance (instance_id));
 864 diesel::joinable!(local_site -> site (site_id));
 865 diesel::joinable!(local_site_rate_limit -> local_site (local_site_id));
 866 diesel::joinable!(local_user -> person (person_id));
 867 diesel::joinable!(local_user_language -> language (language_id));
 868 diesel::joinable!(local_user_language -> local_user (local_user_id));
 869 diesel::joinable!(mod_add_community -> community (community_id));
 870 diesel::joinable!(mod_ban_from_community -> community (community_id));
 871 diesel::joinable!(mod_feature_post -> person (mod_person_id));
 872 diesel::joinable!(mod_feature_post -> post (post_id));
 873 diesel::joinable!(mod_hide_community -> community (community_id));
 874 diesel::joinable!(mod_hide_community -> person (mod_person_id));
 875 diesel::joinable!(mod_lock_post -> person (mod_person_id));
 876 diesel::joinable!(mod_lock_post -> post (post_id));
 877 diesel::joinable!(mod_remove_comment -> comment (comment_id));
 878 diesel::joinable!(mod_remove_comment -> person (mod_person_id));
 879 diesel::joinable!(mod_remove_community -> community (community_id));
 880 diesel::joinable!(mod_remove_community -> person (mod_person_id));
 881 diesel::joinable!(mod_remove_post -> person (mod_person_id));
 882 diesel::joinable!(mod_remove_post -> post (post_id));
 883 diesel::joinable!(mod_transfer_community -> community (community_id));
 884 diesel::joinable!(password_reset_request -> local_user (local_user_id));
 885 diesel::joinable!(person -> instance (instance_id));
 886 diesel::joinable!(person_aggregates -> person (person_id));
 887 diesel::joinable!(person_ban -> person (person_id));
 888 diesel::joinable!(person_mention -> comment (comment_id));
 889 diesel::joinable!(person_mention -> person (recipient_id));
 890 diesel::joinable!(person_post_aggregates -> person (person_id));
 891 diesel::joinable!(person_post_aggregates -> post (post_id));
 892 diesel::joinable!(post -> community (community_id));
 893 diesel::joinable!(post -> language (language_id));
 894 diesel::joinable!(post -> person (creator_id));
 895 diesel::joinable!(post_aggregates -> post (post_id));
 896 diesel::joinable!(post_like -> person (person_id));
 897 diesel::joinable!(post_like -> post (post_id));
 898 diesel::joinable!(post_read -> person (person_id));
 899 diesel::joinable!(post_read -> post (post_id));
 900 diesel::joinable!(post_report -> post (post_id));
 901 diesel::joinable!(post_saved -> person (person_id));
 902 diesel::joinable!(post_saved -> post (post_id));
 903 diesel::joinable!(private_message_report -> private_message (private_message_id));
 904 diesel::joinable!(registration_application -> local_user (local_user_id));
 905 diesel::joinable!(registration_application -> person (admin_id));
 906 diesel::joinable!(site -> instance (instance_id));
 907 diesel::joinable!(site_aggregates -> site (site_id));
 908 diesel::joinable!(site_language -> language (language_id));
 909 diesel::joinable!(site_language -> site (site_id));
 910 diesel::joinable!(tagline -> local_site (local_site_id));
 911
 912 diesel::allow_tables_to_appear_in_same_query!(
 913     activity,
 914     admin_purge_comment,
 915     admin_purge_community,
 916     admin_purge_person,
 917     admin_purge_post,
 918     comment,
 919     comment_aggregates,
 920     comment_like,
 921     comment_reply,
 922     comment_report,
 923     comment_saved,
 924     community,
 925     community_aggregates,
 926     community_block,
 927     community_follower,
 928     community_language,
 929     community_moderator,
 930     community_person_ban,
 931     custom_emoji,
 932     custom_emoji_keyword,
 933     email_verification,
 934     federation_allowlist,
 935     federation_blocklist,
 936     instance,
 937     language,
 938     local_site,
 939     local_site_rate_limit,
 940     local_user,
 941     local_user_language,
 942     mod_add,
 943     mod_add_community,
 944     mod_ban,
 945     mod_ban_from_community,
 946     mod_feature_post,
 947     mod_hide_community,
 948     mod_lock_post,
 949     mod_remove_comment,
 950     mod_remove_community,
 951     mod_remove_post,
 952     mod_transfer_community,
 953     password_reset_request,
 954     person,
 955     person_aggregates,
 956     person_ban,
 957     person_block,
 958     person_follower,
 959     person_mention,
 960     person_post_aggregates,
 961     post,
 962     post_aggregates,
 963     post_like,
 964     post_read,
 965     post_report,
 966     post_saved,
 967     private_message,
 968     private_message_report,
 969     registration_application,
 970     secret,
 971     site,
 972     site_aggregates,
 973     site_language,
 974     tagline,
 975 );