// @generated automatically by Diesel CLI.
pub mod sql_types {
- #[derive(diesel::sql_types::SqlType)]
- #[diesel(postgres_type(name = "listing_type_enum"))]
- pub struct ListingTypeEnum;
+ #[derive(diesel::sql_types::SqlType)]
+ #[diesel(postgres_type(name = "listing_type_enum"))]
+ pub struct ListingTypeEnum;
- #[derive(diesel::sql_types::SqlType)]
- #[diesel(postgres_type(name = "registration_mode_enum"))]
- pub struct RegistrationModeEnum;
+ #[derive(diesel::sql_types::SqlType)]
+ #[diesel(postgres_type(name = "registration_mode_enum"))]
+ pub struct RegistrationModeEnum;
- #[derive(diesel::sql_types::SqlType)]
- #[diesel(postgres_type(name = "sort_type_enum"))]
- pub struct SortTypeEnum;
-}
-
-diesel::table! {
- activity (id) {
- id -> Int4,
- data -> Jsonb,
- local -> Bool,
- published -> Timestamp,
- updated -> Nullable<Timestamp>,
- ap_id -> Text,
- sensitive -> Bool,
- }
+ #[derive(diesel::sql_types::SqlType)]
+ #[diesel(postgres_type(name = "sort_type_enum"))]
+ pub struct SortTypeEnum;
}
diesel::table! {
}
}
+diesel::table! {
+ captcha_answer (id) {
+ id -> Int4,
+ uuid -> Uuid,
+ answer -> Text,
+ published -> Timestamp,
+ }
+}
+
diesel::table! {
use diesel::sql_types::*;
use diesel_ltree::sql_types::Ltree;
published -> Timestamp,
updated -> Nullable<Timestamp>,
deleted -> Bool,
+ #[max_length = 255]
ap_id -> Varchar,
local -> Bool,
path -> Ltree,
downvotes -> Int8,
published -> Timestamp,
child_count -> Int4,
+ hot_rank -> Int4,
+ controversy_rank -> Float8,
}
}
diesel::table! {
community (id) {
id -> Int4,
+ #[max_length = 255]
name -> Varchar,
+ #[max_length = 255]
title -> Varchar,
description -> Nullable<Text>,
removed -> Bool,
updated -> Nullable<Timestamp>,
deleted -> Bool,
nsfw -> Bool,
+ #[max_length = 255]
actor_id -> Varchar,
local -> Bool,
private_key -> Nullable<Text>,
last_refreshed_at -> Timestamp,
icon -> Nullable<Text>,
banner -> Nullable<Text>,
+ #[max_length = 255]
followers_url -> Varchar,
+ #[max_length = 255]
inbox_url -> Varchar,
+ #[max_length = 255]
shared_inbox_url -> Nullable<Varchar>,
hidden -> Bool,
posting_restricted_to_mods -> Bool,
instance_id -> Int4,
+ #[max_length = 255]
moderators_url -> Nullable<Varchar>,
+ #[max_length = 255]
featured_url -> Nullable<Varchar>,
}
}
users_active_week -> Int8,
users_active_month -> Int8,
users_active_half_year -> Int8,
+ hot_rank -> Int4,
}
}
custom_emoji (id) {
id -> Int4,
local_site_id -> Int4,
+ #[max_length = 128]
shortcode -> Varchar,
image_url -> Text,
alt_text -> Text,
custom_emoji_keyword (id) {
id -> Int4,
custom_emoji_id -> Int4,
+ #[max_length = 128]
keyword -> Varchar,
}
}
diesel::table! {
instance (id) {
id -> Int4,
+ #[max_length = 255]
domain -> Varchar,
published -> Timestamp,
updated -> Nullable<Timestamp>,
+ #[max_length = 255]
software -> Nullable<Varchar>,
+ #[max_length = 255]
version -> Nullable<Varchar>,
}
}
diesel::table! {
language (id) {
id -> Int4,
+ #[max_length = 3]
code -> Varchar,
name -> Text,
}
site_id -> Int4,
site_setup -> Bool,
enable_downvotes -> Bool,
+ enable_federated_downvotes -> Bool,
enable_nsfw -> Bool,
community_creation_admin_only -> Bool,
require_email_verification -> Bool,
slur_filter_regex -> Nullable<Text>,
actor_name_max_length -> Int4,
federation_enabled -> Bool,
- federation_debug -> Bool,
- federation_worker_count -> Int4,
captcha_enabled -> Bool,
+ #[max_length = 255]
captcha_difficulty -> Varchar,
published -> Timestamp,
updated -> Nullable<Timestamp>,
password_encrypted -> Text,
email -> Nullable<Text>,
show_nsfw -> Bool,
- theme -> Varchar,
+ theme -> Text,
default_sort_type -> SortTypeEnum,
default_listing_type -> ListingTypeEnum,
+ #[max_length = 20]
interface_language -> Varchar,
show_avatars -> Bool,
send_notifications_to_email -> Bool,
accepted_application -> Bool,
totp_2fa_secret -> Nullable<Text>,
totp_2fa_url -> Nullable<Text>,
+ open_links_in_new_tab -> Bool,
+ blur_nsfw -> Bool,
+ auto_expand -> Bool,
+ infinite_scroll_enabled -> Bool,
}
}
diesel::table! {
password_reset_request (id) {
id -> Int4,
- token_encrypted -> Text,
+ token -> Text,
published -> Timestamp,
local_user_id -> Int4,
}
diesel::table! {
person (id) {
id -> Int4,
+ #[max_length = 255]
name -> Varchar,
+ #[max_length = 255]
display_name -> Nullable<Varchar>,
avatar -> Nullable<Text>,
banned -> Bool,
published -> Timestamp,
updated -> Nullable<Timestamp>,
+ #[max_length = 255]
actor_id -> Varchar,
bio -> Nullable<Text>,
local -> Bool,
last_refreshed_at -> Timestamp,
banner -> Nullable<Text>,
deleted -> Bool,
+ #[max_length = 255]
inbox_url -> Varchar,
+ #[max_length = 255]
shared_inbox_url -> Nullable<Varchar>,
matrix_user_id -> Nullable<Text>,
admin -> Bool,
diesel::table! {
post (id) {
id -> Int4,
+ #[max_length = 200]
name -> Varchar,
- url -> Nullable<Text>,
+ #[max_length = 512]
+ url -> Nullable<Varchar>,
body -> Nullable<Text>,
creator_id -> Int4,
community_id -> Int4,
embed_title -> Nullable<Text>,
embed_description -> Nullable<Text>,
thumbnail_url -> Nullable<Text>,
+ #[max_length = 255]
ap_id -> Varchar,
local -> Bool,
embed_video_url -> Nullable<Text>,
newest_comment_time -> Timestamp,
featured_community -> Bool,
featured_local -> Bool,
+ hot_rank -> Int4,
+ hot_rank_active -> Int4,
+ community_id -> Int4,
+ creator_id -> Int4,
+ controversy_rank -> Float8,
}
}
id -> Int4,
creator_id -> Int4,
post_id -> Int4,
+ #[max_length = 200]
original_post_name -> Varchar,
original_post_url -> Nullable<Text>,
original_post_body -> Nullable<Text>,
read -> Bool,
published -> Timestamp,
updated -> Nullable<Timestamp>,
+ #[max_length = 255]
ap_id -> Varchar,
local -> Bool,
}
}
}
+diesel::table! {
+ received_activity (id) {
+ id -> Int8,
+ ap_id -> Text,
+ published -> Timestamp,
+ }
+}
+
diesel::table! {
registration_application (id) {
id -> Int4,
}
}
+diesel::table! {
+ sent_activity (id) {
+ id -> Int8,
+ ap_id -> Text,
+ data -> Json,
+ sensitive -> Bool,
+ published -> Timestamp,
+ }
+}
+
diesel::table! {
site (id) {
id -> Int4,
+ #[max_length = 20]
name -> Varchar,
sidebar -> Nullable<Text>,
published -> Timestamp,
updated -> Nullable<Timestamp>,
icon -> Nullable<Text>,
banner -> Nullable<Text>,
+ #[max_length = 150]
description -> Nullable<Varchar>,
+ #[max_length = 255]
actor_id -> Varchar,
last_refreshed_at -> Timestamp,
+ #[max_length = 255]
inbox_url -> Varchar,
private_key -> Nullable<Text>,
public_key -> Text,
diesel::joinable!(post -> community (community_id));
diesel::joinable!(post -> language (language_id));
diesel::joinable!(post -> person (creator_id));
+diesel::joinable!(post_aggregates -> community (community_id));
+diesel::joinable!(post_aggregates -> person (creator_id));
diesel::joinable!(post_aggregates -> post (post_id));
diesel::joinable!(post_like -> person (person_id));
diesel::joinable!(post_like -> post (post_id));
diesel::joinable!(tagline -> local_site (local_site_id));
diesel::allow_tables_to_appear_in_same_query!(
- activity,
- admin_purge_comment,
- admin_purge_community,
- admin_purge_person,
- admin_purge_post,
- comment,
- comment_aggregates,
- comment_like,
- comment_reply,
- comment_report,
- comment_saved,
- community,
- community_aggregates,
- community_block,
- community_follower,
- community_language,
- community_moderator,
- community_person_ban,
- custom_emoji,
- custom_emoji_keyword,
- email_verification,
- federation_allowlist,
- federation_blocklist,
- instance,
- language,
- local_site,
- local_site_rate_limit,
- local_user,
- local_user_language,
- mod_add,
- mod_add_community,
- mod_ban,
- mod_ban_from_community,
- mod_feature_post,
- mod_hide_community,
- mod_lock_post,
- mod_remove_comment,
- mod_remove_community,
- mod_remove_post,
- mod_transfer_community,
- password_reset_request,
- person,
- person_aggregates,
- person_ban,
- person_block,
- person_follower,
- person_mention,
- person_post_aggregates,
- post,
- post_aggregates,
- post_like,
- post_read,
- post_report,
- post_saved,
- private_message,
- private_message_report,
- registration_application,
- secret,
- site,
- site_aggregates,
- site_language,
- tagline,
+ admin_purge_comment,
+ admin_purge_community,
+ admin_purge_person,
+ admin_purge_post,
+ captcha_answer,
+ comment,
+ comment_aggregates,
+ comment_like,
+ comment_reply,
+ comment_report,
+ comment_saved,
+ community,
+ community_aggregates,
+ community_block,
+ community_follower,
+ community_language,
+ community_moderator,
+ community_person_ban,
+ custom_emoji,
+ custom_emoji_keyword,
+ email_verification,
+ federation_allowlist,
+ federation_blocklist,
+ instance,
+ language,
+ local_site,
+ local_site_rate_limit,
+ local_user,
+ local_user_language,
+ mod_add,
+ mod_add_community,
+ mod_ban,
+ mod_ban_from_community,
+ mod_feature_post,
+ mod_hide_community,
+ mod_lock_post,
+ mod_remove_comment,
+ mod_remove_community,
+ mod_remove_post,
+ mod_transfer_community,
+ password_reset_request,
+ person,
+ person_aggregates,
+ person_ban,
+ person_block,
+ person_follower,
+ person_mention,
+ person_post_aggregates,
+ post,
+ post_aggregates,
+ post_like,
+ post_read,
+ post_report,
+ post_saved,
+ private_message,
+ private_message_report,
+ received_activity,
+ registration_application,
+ secret,
+ sent_activity,
+ site,
+ site_aggregates,
+ site_language,
+ tagline,
);
projects / lemmy.git / blobdiff