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     admin_purge_comment (id) {
  19         id -> Int4,
  20         admin_person_id -> Int4,
  21         post_id -> Int4,
  22         reason -> Nullable<Text>,
  23         when_ -> Timestamp,
  24     }
  25 }
  26
  27 diesel::table! {
  28     admin_purge_community (id) {
  29         id -> Int4,
  30         admin_person_id -> Int4,
  31         reason -> Nullable<Text>,
  32         when_ -> Timestamp,
  33     }
  34 }
  35
  36 diesel::table! {
  37     admin_purge_person (id) {
  38         id -> Int4,
  39         admin_person_id -> Int4,
  40         reason -> Nullable<Text>,
  41         when_ -> Timestamp,
  42     }
  43 }
  44
  45 diesel::table! {
  46     admin_purge_post (id) {
  47         id -> Int4,
  48         admin_person_id -> Int4,
  49         community_id -> Int4,
  50         reason -> Nullable<Text>,
  51         when_ -> Timestamp,
  52     }
  53 }
  54
  55 diesel::table! {
  56     captcha_answer (id) {
  57         id -> Int4,
  58         uuid -> Uuid,
  59         answer -> Text,
  60         published -> Timestamp,
  61     }
  62 }
  63
  64 diesel::table! {
  65     use diesel::sql_types::*;
  66     use diesel_ltree::sql_types::Ltree;
  67
  68     comment (id) {
  69         id -> Int4,
  70         creator_id -> Int4,
  71         post_id -> Int4,
  72         content -> Text,
  73         removed -> Bool,
  74         published -> Timestamp,
  75         updated -> Nullable<Timestamp>,
  76         deleted -> Bool,
  77         #[max_length = 255]
  78         ap_id -> Varchar,
  79         local -> Bool,
  80         path -> Ltree,
  81         distinguished -> Bool,
  82         language_id -> Int4,
  83     }
  84 }
  85
  86 diesel::table! {
  87     comment_aggregates (id) {
  88         id -> Int4,
  89         comment_id -> Int4,
  90         score -> Int8,
  91         upvotes -> Int8,
  92         downvotes -> Int8,
  93         published -> Timestamp,
  94         child_count -> Int4,
  95         hot_rank -> Int4,
  96     }
  97 }
  98
  99 diesel::table! {
 100     comment_like (id) {
 101         id -> Int4,
 102         person_id -> Int4,
 103         comment_id -> Int4,
 104         post_id -> Int4,
 105         score -> Int2,
 106         published -> Timestamp,
 107     }
 108 }
 109
 110 diesel::table! {
 111     comment_reply (id) {
 112         id -> Int4,
 113         recipient_id -> Int4,
 114         comment_id -> Int4,
 115         read -> Bool,
 116         published -> Timestamp,
 117     }
 118 }
 119
 120 diesel::table! {
 121     comment_report (id) {
 122         id -> Int4,
 123         creator_id -> Int4,
 124         comment_id -> Int4,
 125         original_comment_text -> Text,
 126         reason -> Text,
 127         resolved -> Bool,
 128         resolver_id -> Nullable<Int4>,
 129         published -> Timestamp,
 130         updated -> Nullable<Timestamp>,
 131     }
 132 }
 133
 134 diesel::table! {
 135     comment_saved (id) {
 136         id -> Int4,
 137         comment_id -> Int4,
 138         person_id -> Int4,
 139         published -> Timestamp,
 140     }
 141 }
 142
 143 diesel::table! {
 144     community (id) {
 145         id -> Int4,
 146         #[max_length = 255]
 147         name -> Varchar,
 148         #[max_length = 255]
 149         title -> Varchar,
 150         description -> Nullable<Text>,
 151         removed -> Bool,
 152         published -> Timestamp,
 153         updated -> Nullable<Timestamp>,
 154         deleted -> Bool,
 155         nsfw -> Bool,
 156         #[max_length = 255]
 157         actor_id -> Varchar,
 158         local -> Bool,
 159         private_key -> Nullable<Text>,
 160         public_key -> Text,
 161         last_refreshed_at -> Timestamp,
 162         icon -> Nullable<Text>,
 163         banner -> Nullable<Text>,
 164         #[max_length = 255]
 165         followers_url -> Varchar,
 166         #[max_length = 255]
 167         inbox_url -> Varchar,
 168         #[max_length = 255]
 169         shared_inbox_url -> Nullable<Varchar>,
 170         hidden -> Bool,
 171         posting_restricted_to_mods -> Bool,
 172         instance_id -> Int4,
 173         #[max_length = 255]
 174         moderators_url -> Nullable<Varchar>,
 175         #[max_length = 255]
 176         featured_url -> Nullable<Varchar>,
 177     }
 178 }
 179
 180 diesel::table! {
 181     community_aggregates (id) {
 182         id -> Int4,
 183         community_id -> Int4,
 184         subscribers -> Int8,
 185         posts -> Int8,
 186         comments -> Int8,
 187         published -> Timestamp,
 188         users_active_day -> Int8,
 189         users_active_week -> Int8,
 190         users_active_month -> Int8,
 191         users_active_half_year -> Int8,
 192         hot_rank -> Int4,
 193     }
 194 }
 195
 196 diesel::table! {
 197     community_block (id) {
 198         id -> Int4,
 199         person_id -> Int4,
 200         community_id -> Int4,
 201         published -> Timestamp,
 202     }
 203 }
 204
 205 diesel::table! {
 206     community_follower (id) {
 207         id -> Int4,
 208         community_id -> Int4,
 209         person_id -> Int4,
 210         published -> Timestamp,
 211         pending -> Bool,
 212     }
 213 }
 214
 215 diesel::table! {
 216     community_language (id) {
 217         id -> Int4,
 218         community_id -> Int4,
 219         language_id -> Int4,
 220     }
 221 }
 222
 223 diesel::table! {
 224     community_moderator (id) {
 225         id -> Int4,
 226         community_id -> Int4,
 227         person_id -> Int4,
 228         published -> Timestamp,
 229     }
 230 }
 231
 232 diesel::table! {
 233     community_person_ban (id) {
 234         id -> Int4,
 235         community_id -> Int4,
 236         person_id -> Int4,
 237         published -> Timestamp,
 238         expires -> Nullable<Timestamp>,
 239     }
 240 }
 241
 242 diesel::table! {
 243     custom_emoji (id) {
 244         id -> Int4,
 245         local_site_id -> Int4,
 246         #[max_length = 128]
 247         shortcode -> Varchar,
 248         image_url -> Text,
 249         alt_text -> Text,
 250         category -> Text,
 251         published -> Timestamp,
 252         updated -> Nullable<Timestamp>,
 253     }
 254 }
 255
 256 diesel::table! {
 257     custom_emoji_keyword (id) {
 258         id -> Int4,
 259         custom_emoji_id -> Int4,
 260         #[max_length = 128]
 261         keyword -> Varchar,
 262     }
 263 }
 264
 265 diesel::table! {
 266     email_verification (id) {
 267         id -> Int4,
 268         local_user_id -> Int4,
 269         email -> Text,
 270         verification_token -> Text,
 271         published -> Timestamp,
 272     }
 273 }
 274
 275 diesel::table! {
 276     federation_allowlist (id) {
 277         id -> Int4,
 278         instance_id -> Int4,
 279         published -> Timestamp,
 280         updated -> Nullable<Timestamp>,
 281     }
 282 }
 283
 284 diesel::table! {
 285     federation_blocklist (id) {
 286         id -> Int4,
 287         instance_id -> Int4,
 288         published -> Timestamp,
 289         updated -> Nullable<Timestamp>,
 290     }
 291 }
 292
 293 diesel::table! {
 294     instance (id) {
 295         id -> Int4,
 296         #[max_length = 255]
 297         domain -> Varchar,
 298         published -> Timestamp,
 299         updated -> Nullable<Timestamp>,
 300         #[max_length = 255]
 301         software -> Nullable<Varchar>,
 302         #[max_length = 255]
 303         version -> Nullable<Varchar>,
 304     }
 305 }
 306
 307 diesel::table! {
 308     language (id) {
 309         id -> Int4,
 310         #[max_length = 3]
 311         code -> Varchar,
 312         name -> Text,
 313     }
 314 }
 315
 316 diesel::table! {
 317     use diesel::sql_types::*;
 318     use super::sql_types::ListingTypeEnum;
 319     use super::sql_types::RegistrationModeEnum;
 320
 321     local_site (id) {
 322         id -> Int4,
 323         site_id -> Int4,
 324         site_setup -> Bool,
 325         enable_downvotes -> Bool,
 326         enable_nsfw -> Bool,
 327         community_creation_admin_only -> Bool,
 328         require_email_verification -> Bool,
 329         application_question -> Nullable<Text>,
 330         private_instance -> Bool,
 331         default_theme -> Text,
 332         default_post_listing_type -> ListingTypeEnum,
 333         legal_information -> Nullable<Text>,
 334         hide_modlog_mod_names -> Bool,
 335         application_email_admins -> Bool,
 336         slur_filter_regex -> Nullable<Text>,
 337         actor_name_max_length -> Int4,
 338         federation_enabled -> Bool,
 339         captcha_enabled -> Bool,
 340         #[max_length = 255]
 341         captcha_difficulty -> Varchar,
 342         published -> Timestamp,
 343         updated -> Nullable<Timestamp>,
 344         registration_mode -> RegistrationModeEnum,
 345         reports_email_admins -> Bool,
 346     }
 347 }
 348
 349 diesel::table! {
 350     local_site_rate_limit (id) {
 351         id -> Int4,
 352         local_site_id -> Int4,
 353         message -> Int4,
 354         message_per_second -> Int4,
 355         post -> Int4,
 356         post_per_second -> Int4,
 357         register -> Int4,
 358         register_per_second -> Int4,
 359         image -> Int4,
 360         image_per_second -> Int4,
 361         comment -> Int4,
 362         comment_per_second -> Int4,
 363         search -> Int4,
 364         search_per_second -> Int4,
 365         published -> Timestamp,
 366         updated -> Nullable<Timestamp>,
 367     }
 368 }
 369
 370 diesel::table! {
 371     use diesel::sql_types::*;
 372     use super::sql_types::SortTypeEnum;
 373     use super::sql_types::ListingTypeEnum;
 374
 375     local_user (id) {
 376         id -> Int4,
 377         person_id -> Int4,
 378         password_encrypted -> Text,
 379         email -> Nullable<Text>,
 380         show_nsfw -> Bool,
 381         theme -> Text,
 382         default_sort_type -> SortTypeEnum,
 383         default_listing_type -> ListingTypeEnum,
 384         #[max_length = 20]
 385         interface_language -> Varchar,
 386         show_avatars -> Bool,
 387         send_notifications_to_email -> Bool,
 388         validator_time -> Timestamp,
 389         show_scores -> Bool,
 390         show_bot_accounts -> Bool,
 391         show_read_posts -> Bool,
 392         show_new_post_notifs -> Bool,
 393         email_verified -> Bool,
 394         accepted_application -> Bool,
 395         totp_2fa_secret -> Nullable<Text>,
 396         totp_2fa_url -> Nullable<Text>,
 397         open_links_in_new_tab -> Bool,
 398         blur_nsfw -> Bool,
 399         auto_expand -> Bool,
 400         infinite_scroll_enabled -> Bool,
 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         community_id -> Int4,
 678         creator_id -> Int4,
 679     }
 680 }
 681
 682 diesel::table! {
 683     post_like (id) {
 684         id -> Int4,
 685         post_id -> Int4,
 686         person_id -> Int4,
 687         score -> Int2,
 688         published -> Timestamp,
 689     }
 690 }
 691
 692 diesel::table! {
 693     post_read (id) {
 694         id -> Int4,
 695         post_id -> Int4,
 696         person_id -> Int4,
 697         published -> Timestamp,
 698     }
 699 }
 700
 701 diesel::table! {
 702     post_report (id) {
 703         id -> Int4,
 704         creator_id -> Int4,
 705         post_id -> Int4,
 706         #[max_length = 200]
 707         original_post_name -> Varchar,
 708         original_post_url -> Nullable<Text>,
 709         original_post_body -> Nullable<Text>,
 710         reason -> Text,
 711         resolved -> Bool,
 712         resolver_id -> Nullable<Int4>,
 713         published -> Timestamp,
 714         updated -> Nullable<Timestamp>,
 715     }
 716 }
 717
 718 diesel::table! {
 719     post_saved (id) {
 720         id -> Int4,
 721         post_id -> Int4,
 722         person_id -> Int4,
 723         published -> Timestamp,
 724     }
 725 }
 726
 727 diesel::table! {
 728     private_message (id) {
 729         id -> Int4,
 730         creator_id -> Int4,
 731         recipient_id -> Int4,
 732         content -> Text,
 733         deleted -> Bool,
 734         read -> Bool,
 735         published -> Timestamp,
 736         updated -> Nullable<Timestamp>,
 737         #[max_length = 255]
 738         ap_id -> Varchar,
 739         local -> Bool,
 740     }
 741 }
 742
 743 diesel::table! {
 744     private_message_report (id) {
 745         id -> Int4,
 746         creator_id -> Int4,
 747         private_message_id -> Int4,
 748         original_pm_text -> Text,
 749         reason -> Text,
 750         resolved -> Bool,
 751         resolver_id -> Nullable<Int4>,
 752         published -> Timestamp,
 753         updated -> Nullable<Timestamp>,
 754     }
 755 }
 756
 757 diesel::table! {
 758     received_activity (id) {
 759         id -> Int8,
 760         ap_id -> Text,
 761         published -> Timestamp,
 762     }
 763 }
 764
 765 diesel::table! {
 766     registration_application (id) {
 767         id -> Int4,
 768         local_user_id -> Int4,
 769         answer -> Text,
 770         admin_id -> Nullable<Int4>,
 771         deny_reason -> Nullable<Text>,
 772         published -> Timestamp,
 773     }
 774 }
 775
 776 diesel::table! {
 777     secret (id) {
 778         id -> Int4,
 779         jwt_secret -> Varchar,
 780     }
 781 }
 782
 783 diesel::table! {
 784     sent_activity (id) {
 785         id -> Int8,
 786         ap_id -> Text,
 787         data -> Json,
 788         sensitive -> Bool,
 789         published -> Timestamp,
 790     }
 791 }
 792
 793 diesel::table! {
 794     site (id) {
 795         id -> Int4,
 796         #[max_length = 20]
 797         name -> Varchar,
 798         sidebar -> Nullable<Text>,
 799         published -> Timestamp,
 800         updated -> Nullable<Timestamp>,
 801         icon -> Nullable<Text>,
 802         banner -> Nullable<Text>,
 803         #[max_length = 150]
 804         description -> Nullable<Varchar>,
 805         #[max_length = 255]
 806         actor_id -> Varchar,
 807         last_refreshed_at -> Timestamp,
 808         #[max_length = 255]
 809         inbox_url -> Varchar,
 810         private_key -> Nullable<Text>,
 811         public_key -> Text,
 812         instance_id -> Int4,
 813     }
 814 }
 815
 816 diesel::table! {
 817     site_aggregates (id) {
 818         id -> Int4,
 819         site_id -> Int4,
 820         users -> Int8,
 821         posts -> Int8,
 822         comments -> Int8,
 823         communities -> Int8,
 824         users_active_day -> Int8,
 825         users_active_week -> Int8,
 826         users_active_month -> Int8,
 827         users_active_half_year -> Int8,
 828     }
 829 }
 830
 831 diesel::table! {
 832     site_language (id) {
 833         id -> Int4,
 834         site_id -> Int4,
 835         language_id -> Int4,
 836     }
 837 }
 838
 839 diesel::table! {
 840     tagline (id) {
 841         id -> Int4,
 842         local_site_id -> Int4,
 843         content -> Text,
 844         published -> Timestamp,
 845         updated -> Nullable<Timestamp>,
 846     }
 847 }
 848
 849 diesel::joinable!(admin_purge_comment -> person (admin_person_id));
 850 diesel::joinable!(admin_purge_comment -> post (post_id));
 851 diesel::joinable!(admin_purge_community -> person (admin_person_id));
 852 diesel::joinable!(admin_purge_person -> person (admin_person_id));
 853 diesel::joinable!(admin_purge_post -> community (community_id));
 854 diesel::joinable!(admin_purge_post -> person (admin_person_id));
 855 diesel::joinable!(comment -> language (language_id));
 856 diesel::joinable!(comment -> person (creator_id));
 857 diesel::joinable!(comment -> post (post_id));
 858 diesel::joinable!(comment_aggregates -> comment (comment_id));
 859 diesel::joinable!(comment_like -> comment (comment_id));
 860 diesel::joinable!(comment_like -> person (person_id));
 861 diesel::joinable!(comment_like -> post (post_id));
 862 diesel::joinable!(comment_reply -> comment (comment_id));
 863 diesel::joinable!(comment_reply -> person (recipient_id));
 864 diesel::joinable!(comment_report -> comment (comment_id));
 865 diesel::joinable!(comment_saved -> comment (comment_id));
 866 diesel::joinable!(comment_saved -> person (person_id));
 867 diesel::joinable!(community -> instance (instance_id));
 868 diesel::joinable!(community_aggregates -> community (community_id));
 869 diesel::joinable!(community_block -> community (community_id));
 870 diesel::joinable!(community_block -> person (person_id));
 871 diesel::joinable!(community_follower -> community (community_id));
 872 diesel::joinable!(community_follower -> person (person_id));
 873 diesel::joinable!(community_language -> community (community_id));
 874 diesel::joinable!(community_language -> language (language_id));
 875 diesel::joinable!(community_moderator -> community (community_id));
 876 diesel::joinable!(community_moderator -> person (person_id));
 877 diesel::joinable!(community_person_ban -> community (community_id));
 878 diesel::joinable!(community_person_ban -> person (person_id));
 879 diesel::joinable!(custom_emoji -> local_site (local_site_id));
 880 diesel::joinable!(custom_emoji_keyword -> custom_emoji (custom_emoji_id));
 881 diesel::joinable!(email_verification -> local_user (local_user_id));
 882 diesel::joinable!(federation_allowlist -> instance (instance_id));
 883 diesel::joinable!(federation_blocklist -> instance (instance_id));
 884 diesel::joinable!(local_site -> site (site_id));
 885 diesel::joinable!(local_site_rate_limit -> local_site (local_site_id));
 886 diesel::joinable!(local_user -> person (person_id));
 887 diesel::joinable!(local_user_language -> language (language_id));
 888 diesel::joinable!(local_user_language -> local_user (local_user_id));
 889 diesel::joinable!(mod_add_community -> community (community_id));
 890 diesel::joinable!(mod_ban_from_community -> community (community_id));
 891 diesel::joinable!(mod_feature_post -> person (mod_person_id));
 892 diesel::joinable!(mod_feature_post -> post (post_id));
 893 diesel::joinable!(mod_hide_community -> community (community_id));
 894 diesel::joinable!(mod_hide_community -> person (mod_person_id));
 895 diesel::joinable!(mod_lock_post -> person (mod_person_id));
 896 diesel::joinable!(mod_lock_post -> post (post_id));
 897 diesel::joinable!(mod_remove_comment -> comment (comment_id));
 898 diesel::joinable!(mod_remove_comment -> person (mod_person_id));
 899 diesel::joinable!(mod_remove_community -> community (community_id));
 900 diesel::joinable!(mod_remove_community -> person (mod_person_id));
 901 diesel::joinable!(mod_remove_post -> person (mod_person_id));
 902 diesel::joinable!(mod_remove_post -> post (post_id));
 903 diesel::joinable!(mod_transfer_community -> community (community_id));
 904 diesel::joinable!(password_reset_request -> local_user (local_user_id));
 905 diesel::joinable!(person -> instance (instance_id));
 906 diesel::joinable!(person_aggregates -> person (person_id));
 907 diesel::joinable!(person_ban -> person (person_id));
 908 diesel::joinable!(person_mention -> comment (comment_id));
 909 diesel::joinable!(person_mention -> person (recipient_id));
 910 diesel::joinable!(person_post_aggregates -> person (person_id));
 911 diesel::joinable!(person_post_aggregates -> post (post_id));
 912 diesel::joinable!(post -> community (community_id));
 913 diesel::joinable!(post -> language (language_id));
 914 diesel::joinable!(post -> person (creator_id));
 915 diesel::joinable!(post_aggregates -> community (community_id));
 916 diesel::joinable!(post_aggregates -> person (creator_id));
 917 diesel::joinable!(post_aggregates -> post (post_id));
 918 diesel::joinable!(post_like -> person (person_id));
 919 diesel::joinable!(post_like -> post (post_id));
 920 diesel::joinable!(post_read -> person (person_id));
 921 diesel::joinable!(post_read -> post (post_id));
 922 diesel::joinable!(post_report -> post (post_id));
 923 diesel::joinable!(post_saved -> person (person_id));
 924 diesel::joinable!(post_saved -> post (post_id));
 925 diesel::joinable!(private_message_report -> private_message (private_message_id));
 926 diesel::joinable!(registration_application -> local_user (local_user_id));
 927 diesel::joinable!(registration_application -> person (admin_id));
 928 diesel::joinable!(site -> instance (instance_id));
 929 diesel::joinable!(site_aggregates -> site (site_id));
 930 diesel::joinable!(site_language -> language (language_id));
 931 diesel::joinable!(site_language -> site (site_id));
 932 diesel::joinable!(tagline -> local_site (local_site_id));
 933
 934 diesel::allow_tables_to_appear_in_same_query!(
 935     admin_purge_comment,
 936     admin_purge_community,
 937     admin_purge_person,
 938     admin_purge_post,
 939     captcha_answer,
 940     comment,
 941     comment_aggregates,
 942     comment_like,
 943     comment_reply,
 944     comment_report,
 945     comment_saved,
 946     community,
 947     community_aggregates,
 948     community_block,
 949     community_follower,
 950     community_language,
 951     community_moderator,
 952     community_person_ban,
 953     custom_emoji,
 954     custom_emoji_keyword,
 955     email_verification,
 956     federation_allowlist,
 957     federation_blocklist,
 958     instance,
 959     language,
 960     local_site,
 961     local_site_rate_limit,
 962     local_user,
 963     local_user_language,
 964     mod_add,
 965     mod_add_community,
 966     mod_ban,
 967     mod_ban_from_community,
 968     mod_feature_post,
 969     mod_hide_community,
 970     mod_lock_post,
 971     mod_remove_comment,
 972     mod_remove_community,
 973     mod_remove_post,
 974     mod_transfer_community,
 975     password_reset_request,
 976     person,
 977     person_aggregates,
 978     person_ban,
 979     person_block,
 980     person_follower,
 981     person_mention,
 982     person_post_aggregates,
 983     post,
 984     post_aggregates,
 985     post_like,
 986     post_read,
 987     post_report,
 988     post_saved,
 989     private_message,
 990     private_message_report,
 991     received_activity,
 992     registration_application,
 993     secret,
 994     sent_activity,
 995     site,
 996     site_aggregates,
 997     site_language,
 998     tagline,
 999 );