summaryrefslogtreecommitdiffstats
path: root/server/lemmy_db/src/schema.rs
diff options
context:
space:
mode:
Diffstat (limited to 'server/lemmy_db/src/schema.rs')
-rw-r--r--server/lemmy_db/src/schema.rs541
1 files changed, 541 insertions, 0 deletions
diff --git a/server/lemmy_db/src/schema.rs b/server/lemmy_db/src/schema.rs
new file mode 100644
index 00000000..18a522df
--- /dev/null
+++ b/server/lemmy_db/src/schema.rs
@@ -0,0 +1,541 @@
+table! {
+ activity (id) {
+ id -> Int4,
+ user_id -> Int4,
+ data -> Jsonb,
+ local -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ }
+}
+
+table! {
+ category (id) {
+ id -> Int4,
+ name -> Varchar,
+ }
+}
+
+table! {
+ comment (id) {
+ id -> Int4,
+ creator_id -> Int4,
+ post_id -> Int4,
+ parent_id -> Nullable<Int4>,
+ content -> Text,
+ removed -> Bool,
+ read -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ deleted -> Bool,
+ ap_id -> Varchar,
+ local -> Bool,
+ }
+}
+
+table! {
+ comment_aggregates_fast (id) {
+ id -> Int4,
+ creator_id -> Nullable<Int4>,
+ post_id -> Nullable<Int4>,
+ parent_id -> Nullable<Int4>,
+ content -> Nullable<Text>,
+ removed -> Nullable<Bool>,
+ read -> Nullable<Bool>,
+ published -> Nullable<Timestamp>,
+ updated -> Nullable<Timestamp>,
+ deleted -> Nullable<Bool>,
+ ap_id -> Nullable<Varchar>,
+ local -> Nullable<Bool>,
+ community_id -> Nullable<Int4>,
+ community_actor_id -> Nullable<Varchar>,
+ community_local -> Nullable<Bool>,
+ community_name -> Nullable<Varchar>,
+ banned -> Nullable<Bool>,
+ banned_from_community -> Nullable<Bool>,
+ creator_actor_id -> Nullable<Varchar>,
+ creator_local -> Nullable<Bool>,
+ creator_name -> Nullable<Varchar>,
+ creator_published -> Nullable<Timestamp>,
+ creator_avatar -> Nullable<Text>,
+ score -> Nullable<Int8>,
+ upvotes -> Nullable<Int8>,
+ downvotes -> Nullable<Int8>,
+ hot_rank -> Nullable<Int4>,
+ }
+}
+
+table! {
+ comment_like (id) {
+ id -> Int4,
+ user_id -> Int4,
+ comment_id -> Int4,
+ post_id -> Int4,
+ score -> Int2,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ comment_saved (id) {
+ id -> Int4,
+ comment_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ community (id) {
+ id -> Int4,
+ name -> Varchar,
+ title -> Varchar,
+ description -> Nullable<Text>,
+ category_id -> Int4,
+ creator_id -> Int4,
+ removed -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ deleted -> Bool,
+ nsfw -> Bool,
+ actor_id -> Varchar,
+ local -> Bool,
+ private_key -> Nullable<Text>,
+ public_key -> Nullable<Text>,
+ last_refreshed_at -> Timestamp,
+ }
+}
+
+table! {
+ community_aggregates_fast (id) {
+ id -> Int4,
+ name -> Nullable<Varchar>,
+ title -> Nullable<Varchar>,
+ description -> Nullable<Text>,
+ category_id -> Nullable<Int4>,
+ creator_id -> Nullable<Int4>,
+ removed -> Nullable<Bool>,
+ published -> Nullable<Timestamp>,
+ updated -> Nullable<Timestamp>,
+ deleted -> Nullable<Bool>,
+ nsfw -> Nullable<Bool>,
+ actor_id -> Nullable<Varchar>,
+ local -> Nullable<Bool>,
+ last_refreshed_at -> Nullable<Timestamp>,
+ creator_actor_id -> Nullable<Varchar>,
+ creator_local -> Nullable<Bool>,
+ creator_name -> Nullable<Varchar>,
+ creator_avatar -> Nullable<Text>,
+ category_name -> Nullable<Varchar>,
+ number_of_subscribers -> Nullable<Int8>,
+ number_of_posts -> Nullable<Int8>,
+ number_of_comments -> Nullable<Int8>,
+ hot_rank -> Nullable<Int4>,
+ }
+}
+
+table! {
+ community_follower (id) {
+ id -> Int4,
+ community_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ community_moderator (id) {
+ id -> Int4,
+ community_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ community_user_ban (id) {
+ id -> Int4,
+ community_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ mod_add (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ other_user_id -> Int4,
+ removed -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_add_community (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ other_user_id -> Int4,
+ community_id -> Int4,
+ removed -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_ban (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ other_user_id -> Int4,
+ reason -> Nullable<Text>,
+ banned -> Nullable<Bool>,
+ expires -> Nullable<Timestamp>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_ban_from_community (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ other_user_id -> Int4,
+ community_id -> Int4,
+ reason -> Nullable<Text>,
+ banned -> Nullable<Bool>,
+ expires -> Nullable<Timestamp>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_lock_post (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ post_id -> Int4,
+ locked -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_remove_comment (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ comment_id -> Int4,
+ reason -> Nullable<Text>,
+ removed -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_remove_community (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ community_id -> Int4,
+ reason -> Nullable<Text>,
+ removed -> Nullable<Bool>,
+ expires -> Nullable<Timestamp>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_remove_post (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ post_id -> Int4,
+ reason -> Nullable<Text>,
+ removed -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ mod_sticky_post (id) {
+ id -> Int4,
+ mod_user_id -> Int4,
+ post_id -> Int4,
+ stickied -> Nullable<Bool>,
+ when_ -> Timestamp,
+ }
+}
+
+table! {
+ password_reset_request (id) {
+ id -> Int4,
+ user_id -> Int4,
+ token_encrypted -> Text,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ post (id) {
+ id -> Int4,
+ name -> Varchar,
+ url -> Nullable<Text>,
+ body -> Nullable<Text>,
+ creator_id -> Int4,
+ community_id -> Int4,
+ removed -> Bool,
+ locked -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ deleted -> Bool,
+ nsfw -> Bool,
+ stickied -> Bool,
+ embed_title -> Nullable<Text>,
+ embed_description -> Nullable<Text>,
+ embed_html -> Nullable<Text>,
+ thumbnail_url -> Nullable<Text>,
+ ap_id -> Varchar,
+ local -> Bool,
+ }
+}
+
+table! {
+ post_aggregates_fast (id) {
+ id -> Int4,
+ name -> Nullable<Varchar>,
+ url -> Nullable<Text>,
+ body -> Nullable<Text>,
+ creator_id -> Nullable<Int4>,
+ community_id -> Nullable<Int4>,
+ removed -> Nullable<Bool>,
+ locked -> Nullable<Bool>,
+ published -> Nullable<Timestamp>,
+ updated -> Nullable<Timestamp>,
+ deleted -> Nullable<Bool>,
+ nsfw -> Nullable<Bool>,
+ stickied -> Nullable<Bool>,
+ embed_title -> Nullable<Text>,
+ embed_description -> Nullable<Text>,
+ embed_html -> Nullable<Text>,
+ thumbnail_url -> Nullable<Text>,
+ ap_id -> Nullable<Varchar>,
+ local -> Nullable<Bool>,
+ creator_actor_id -> Nullable<Varchar>,
+ creator_local -> Nullable<Bool>,
+ creator_name -> Nullable<Varchar>,
+ creator_published -> Nullable<Timestamp>,
+ creator_avatar -> Nullable<Text>,
+ banned -> Nullable<Bool>,
+ banned_from_community -> Nullable<Bool>,
+ community_actor_id -> Nullable<Varchar>,
+ community_local -> Nullable<Bool>,
+ community_name -> Nullable<Varchar>,
+ community_removed -> Nullable<Bool>,
+ community_deleted -> Nullable<Bool>,
+ community_nsfw -> Nullable<Bool>,
+ number_of_comments -> Nullable<Int8>,
+ score -> Nullable<Int8>,
+ upvotes -> Nullable<Int8>,
+ downvotes -> Nullable<Int8>,
+ hot_rank -> Nullable<Int4>,
+ newest_activity_time -> Nullable<Timestamp>,
+ }
+}
+
+table! {
+ post_like (id) {
+ id -> Int4,
+ post_id -> Int4,
+ user_id -> Int4,
+ score -> Int2,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ post_read (id) {
+ id -> Int4,
+ post_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ post_saved (id) {
+ id -> Int4,
+ post_id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ private_message (id) {
+ id -> Int4,
+ creator_id -> Int4,
+ recipient_id -> Int4,
+ content -> Text,
+ deleted -> Bool,
+ read -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ ap_id -> Varchar,
+ local -> Bool,
+ }
+}
+
+table! {
+ site (id) {
+ id -> Int4,
+ name -> Varchar,
+ description -> Nullable<Text>,
+ creator_id -> Int4,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ enable_downvotes -> Bool,
+ open_registration -> Bool,
+ enable_nsfw -> Bool,
+ }
+}
+
+table! {
+ user_ (id) {
+ id -> Int4,
+ name -> Varchar,
+ preferred_username -> Nullable<Varchar>,
+ password_encrypted -> Text,
+ email -> Nullable<Text>,
+ avatar -> Nullable<Text>,
+ admin -> Bool,
+ banned -> Bool,
+ published -> Timestamp,
+ updated -> Nullable<Timestamp>,
+ show_nsfw -> Bool,
+ theme -> Varchar,
+ default_sort_type -> Int2,
+ default_listing_type -> Int2,
+ lang -> Varchar,
+ show_avatars -> Bool,
+ send_notifications_to_email -> Bool,
+ matrix_user_id -> Nullable<Text>,
+ actor_id -> Varchar,
+ bio -> Nullable<Text>,
+ local -> Bool,
+ private_key -> Nullable<Text>,
+ public_key -> Nullable<Text>,
+ last_refreshed_at -> Timestamp,
+ }
+}
+
+table! {
+ user_ban (id) {
+ id -> Int4,
+ user_id -> Int4,
+ published -> Timestamp,
+ }
+}
+
+table! {
+ user_fast (id) {
+ id -> Int4,
+ actor_id -> Nullable<Varchar>,
+ name -> Nullable<Varchar>,
+ avatar -> Nullable<Text>,
+ email -> Nullable<Text>,
+ matrix_user_id -> Nullable<Text>,
+ bio -> Nullable<Text>,
+ local -> Nullable<Bool>,
+ admin -> Nullable<Bool>,
+ banned -> Nullable<Bool>,
+ show_avatars -> Nullable<Bool>,
+ send_notifications_to_email -> Nullable<Bool>,
+ published -> Nullable<Timestamp>,
+ number_of_posts -> Nullable<Int8>,
+ post_score -> Nullable<Int8>,
+ number_of_comments -> Nullable<Int8>,
+ comment_score -> Nullable<Int8>,
+ }
+}
+
+table! {
+ user_mention (id) {
+ id -> Int4,
+ recipient_id -> Int4,
+ comment_id -> Int4,
+ read -> Bool,
+ published -> Timestamp,
+ }
+}
+
+joinable!(activity -> user_ (user_id));
+joinable!(comment -> post (post_id));
+joinable!(comment -> user_ (creator_id));
+joinable!(comment_like -> comment (comment_id));
+joinable!(comment_like -> post (post_id));
+joinable!(comment_like -> user_ (user_id));
+joinable!(comment_saved -> comment (comment_id));
+joinable!(comment_saved -> user_ (user_id));
+joinable!(community -> category (category_id));
+joinable!(community -> user_ (creator_id));
+joinable!(community_follower -> community (community_id));
+joinable!(community_follower -> user_ (user_id));
+joinable!(community_moderator -> community (community_id));
+joinable!(community_moderator -> user_ (user_id));
+joinable!(community_user_ban -> community (community_id));
+joinable!(community_user_ban -> user_ (user_id));
+joinable!(mod_add_community -> community (community_id));
+joinable!(mod_ban_from_community -> community (community_id));
+joinable!(mod_lock_post -> post (post_id));
+joinable!(mod_lock_post -> user_ (mod_user_id));
+joinable!(mod_remove_comment -> comment (comment_id));
+joinable!(mod_remove_comment -> user_ (mod_user_id));
+joinable!(mod_remove_community -> community (community_id));
+joinable!(mod_remove_community -> user_ (mod_user_id));
+joinable!(mod_remove_post -> post (post_id));
+joinable!(mod_remove_post -> user_ (mod_user_id));
+joinable!(mod_sticky_post -> post (post_id));
+joinable!(mod_sticky_post -> user_ (mod_user_id));
+joinable!(password_reset_request -> user_ (user_id));
+joinable!(post -> community (community_id));
+joinable!(post -> user_ (creator_id));
+joinable!(post_like -> post (post_id));
+joinable!(post_like -> user_ (user_id));
+joinable!(post_read -> post (post_id));
+joinable!(post_read -> user_ (user_id));
+joinable!(post_saved -> post (post_id));
+joinable!(post_saved -> user_ (user_id));
+joinable!(site -> user_ (creator_id));
+joinable!(user_ban -> user_ (user_id));
+joinable!(user_mention -> comment (comment_id));
+joinable!(user_mention -> user_ (recipient_id));
+
+allow_tables_to_appear_in_same_query!(
+ activity,
+ category,
+ comment,
+ comment_aggregates_fast,
+ comment_like,
+ comment_saved,
+ community,
+ community_aggregates_fast,
+ community_follower,
+ community_moderator,
+ community_user_ban,
+ mod_add,
+ mod_add_community,
+ mod_ban,
+ mod_ban_from_community,
+ mod_lock_post,
+ mod_remove_comment,
+ mod_remove_community,
+ mod_remove_post,
+ mod_sticky_post,
+ password_reset_request,
+ post,
+ post_aggregates_fast,
+ post_like,
+ post_read,
+ post_saved,
+ private_message,
+ site,
+ user_,
+ user_ban,
+ user_fast,
+ user_mention,
+);
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-27 17:14:04 +0000