]> Untitled Git - lemmy.git/blobdiff - crates/db_schema/src/schema.rs
feat: re-added captcha checks (#3249)
[lemmy.git] / crates / db_schema / src / schema.rs
index f2ccf5e2ac07ddfec913d4f3e6e6866480460ef3..f244ae664077b182775194a2297a34e3ff9e8414 100644 (file)
@@ -65,7 +65,15 @@ diesel::table! {
 }
 
 diesel::table! {
-    use diesel::sql_types::*;
+    captcha_answer (uuid) {
+        uuid -> Text,
+        answer -> Text,
+        expires -> Timestamp,
+    }
+}
+
+diesel::table! {
+    use diesel::sql_types::{Bool, Int4, Nullable, Text, Timestamp, Varchar};
     use diesel_ltree::sql_types::Ltree;
 
     comment (id) {
@@ -77,6 +85,7 @@ diesel::table! {
         published -> Timestamp,
         updated -> Nullable<Timestamp>,
         deleted -> Bool,
+        #[max_length = 255]
         ap_id -> Varchar,
         local -> Bool,
         path -> Ltree,
@@ -94,6 +103,7 @@ diesel::table! {
         downvotes -> Int8,
         published -> Timestamp,
         child_count -> Int4,
+        hot_rank -> Int4,
     }
 }
 
@@ -144,7 +154,9 @@ diesel::table! {
 diesel::table! {
     community (id) {
         id -> Int4,
+        #[max_length = 255]
         name -> Varchar,
+        #[max_length = 255]
         title -> Varchar,
         description -> Nullable<Text>,
         removed -> Bool,
@@ -152,6 +164,7 @@ diesel::table! {
         updated -> Nullable<Timestamp>,
         deleted -> Bool,
         nsfw -> Bool,
+        #[max_length = 255]
         actor_id -> Varchar,
         local -> Bool,
         private_key -> Nullable<Text>,
@@ -159,13 +172,18 @@ diesel::table! {
         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>,
     }
 }
@@ -182,6 +200,7 @@ diesel::table! {
         users_active_week -> Int8,
         users_active_month -> Int8,
         users_active_half_year -> Int8,
+        hot_rank -> Int4,
     }
 }
 
@@ -235,6 +254,7 @@ diesel::table! {
     custom_emoji (id) {
         id -> Int4,
         local_site_id -> Int4,
+        #[max_length = 128]
         shortcode -> Varchar,
         image_url -> Text,
         alt_text -> Text,
@@ -248,6 +268,7 @@ diesel::table! {
     custom_emoji_keyword (id) {
         id -> Int4,
         custom_emoji_id -> Int4,
+        #[max_length = 128]
         keyword -> Varchar,
     }
 }
@@ -283,10 +304,13 @@ diesel::table! {
 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>,
     }
 }
@@ -294,13 +318,14 @@ diesel::table! {
 diesel::table! {
     language (id) {
         id -> Int4,
+        #[max_length = 3]
         code -> Varchar,
         name -> Text,
     }
 }
 
 diesel::table! {
-    use diesel::sql_types::*;
+    use diesel::sql_types::{Bool, Int4, Nullable, Text, Timestamp, Varchar};
     use super::sql_types::ListingTypeEnum;
     use super::sql_types::RegistrationModeEnum;
 
@@ -322,9 +347,9 @@ diesel::table! {
         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>,
@@ -355,7 +380,7 @@ diesel::table! {
 }
 
 diesel::table! {
-    use diesel::sql_types::*;
+    use diesel::sql_types::{Bool, Int4, Nullable, Text, Timestamp, Varchar};
     use super::sql_types::SortTypeEnum;
     use super::sql_types::ListingTypeEnum;
 
@@ -365,9 +390,11 @@ diesel::table! {
         password_encrypted -> Text,
         email -> Nullable<Text>,
         show_nsfw -> Bool,
+        #[max_length = 20]
         theme -> Varchar,
         default_sort_type -> SortTypeEnum,
         default_listing_type -> ListingTypeEnum,
+        #[max_length = 20]
         interface_language -> Varchar,
         show_avatars -> Bool,
         send_notifications_to_email -> Bool,
@@ -525,12 +552,15 @@ diesel::table! {
 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,
@@ -539,7 +569,9 @@ diesel::table! {
         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,
@@ -610,8 +642,10 @@ diesel::table! {
 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,
@@ -624,6 +658,7 @@ diesel::table! {
         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>,
@@ -646,6 +681,8 @@ diesel::table! {
         newest_comment_time -> Timestamp,
         featured_community -> Bool,
         featured_local -> Bool,
+        hot_rank -> Int4,
+        hot_rank_active -> Int4,
     }
 }
 
@@ -673,6 +710,7 @@ diesel::table! {
         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>,
@@ -703,6 +741,7 @@ diesel::table! {
         read -> Bool,
         published -> Timestamp,
         updated -> Nullable<Timestamp>,
+        #[max_length = 255]
         ap_id -> Varchar,
         local -> Bool,
     }
@@ -743,15 +782,19 @@ diesel::table! {
 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,
@@ -881,6 +924,7 @@ diesel::allow_tables_to_appear_in_same_query!(
     admin_purge_community,
     admin_purge_person,
     admin_purge_post,
+    captcha_answer,
     comment,
     comment_aggregates,
     comment_like,