← all fixtures

ruby-mastodon-mastodon-add-one-call

Ruby View before/after files on GitHub Upstream commit mastodon-mastodon.git@48fe679 db/schema.rb
Code view:

A painting is a person's account of this edit as text, recorded independently of the node mapping - a rendering often has several equally defensible answers where the mapping has one. Deletions and insertions carry no position on the opposite side in a painting, so that panel draws no caret for them.

Before

…lines 1–723 unchanged (723 lines)
724 t.integer "file_storage_schema_version"
725 t.string "thumbnail_file_name"
726 t.string "thumbnail_content_type"
727 t.integer "thumbnail_file_size"
728 t.datetime "thumbnail_updated_at", precision: nil
729 t.string "thumbnail_remote_url"
730 t.index ["account_id", "status_id"], name: "index_media_attachments_on_account_id_and_status_id", order: { status_id: :desc }
731 t.index ["scheduled_status_id"], name: "index_media_attachments_on_scheduled_status_id", where: "(scheduled_status_id IS NOT NULL)"
732 t.index ["shortcode"], name: "index_media_attachments_on_shortcode", unique: true, opclass: :text_pattern_ops, where: "(shortcode IS NOT NULL)"
733 t.index ["status_id"], name: "index_media_attachments_on_status_id"
734 end
735
736 create_table "mentions", force: :cascade do |t|
…lines 737–1629 unchanged (893 lines)

After

…lines 1–723 unchanged (723 lines)
724 t.integer "file_storage_schema_version"
725 t.string "thumbnail_file_name"
726 t.string "thumbnail_content_type"
727 t.integer "thumbnail_file_size"
728 t.datetime "thumbnail_updated_at", precision: nil
729 t.string "thumbnail_remote_url"
730 t.integer "thumbnail_storage_schema_version"
731 t.index ["account_id", "status_id"], name: "index_media_attachments_on_account_id_and_status_id", order: { status_id: :desc }
732 t.index ["scheduled_status_id"], name: "index_media_attachments_on_scheduled_status_id", where: "(scheduled_status_id IS NOT NULL)"
733 t.index ["shortcode"], name: "index_media_attachments_on_shortcode", unique: true, opclass: :text_pattern_ops, where: "(shortcode IS NOT NULL)"
734 t.index ["status_id"], name: "index_media_attachments_on_status_id"
735 end
736
…lines 737–1630 unchanged (894 lines)

Before

program
comment "# This file is auto-generated from the current state of the "...
comment "# of editing this file, please use the migrations feature of"...
comment "# incrementally modify your database, and then regenerate th"...
comment "#"
comment "# This file is the source Rails uses to define your schema w"...
comment "# db:schema:load`. When creating a new database, `bin/rails "...
comment "# be faster and is potentially less error prone than running"...
comment "# migrations from scratch. Old migrations may fail to apply "...
comment "# migrations use external dependencies or application code."
comment "#"
comment "# It's strongly recommended that you check this file into yo"...
call
element_reference
scope_resolution
constant "ActiveRecord"
:: "::"
constant "Schema"
[ "["
float "8.0"
] "]"
. "."
identifier "define"
argument_list
( "("
pair
hash_key_symbol "version"
: ":"
integer "2025_11_19_093332"
) ")"
do_block
do "do"
comment "# These are extensions that must be enabled in order to supp"...
body_statement
call
identifier "enable_extension"
argument_list
string
" "\""
string_content "pg_catalog.plpgsql"
" "\""
call (+146 nodes collapsed)
call (+202 nodes collapsed)
call (+94 nodes collapsed)
call (+118 nodes collapsed)
call (+166 nodes collapsed)
call (+142 nodes collapsed)
call (+152 nodes collapsed)
call (+138 nodes collapsed)
call (+164 nodes collapsed)
call (+210 nodes collapsed)
call (+252 nodes collapsed)
call (+102 nodes collapsed)
call (+196 nodes collapsed)
call (+897 nodes collapsed)
call (+89 nodes collapsed)
call (+185 nodes collapsed)
call (+138 nodes collapsed)
call (+201 nodes collapsed)
call (+202 nodes collapsed)
call (+92 nodes collapsed)
call (+246 nodes collapsed)
call (+150 nodes collapsed)
call (+147 nodes collapsed)
call (+138 nodes collapsed)
call (+91 nodes collapsed)
call (+269 nodes collapsed)
call (+123 nodes collapsed)
call (+251 nodes collapsed)
call (+199 nodes collapsed)
call (+78 nodes collapsed)
call (+158 nodes collapsed)
call (+94 nodes collapsed)
call (+236 nodes collapsed)
call (+122 nodes collapsed)
call (+126 nodes collapsed)
call (+175 nodes collapsed)
call (+106 nodes collapsed)
call (+195 nodes collapsed)
call (+134 nodes collapsed)
call (+143 nodes collapsed)
call (+110 nodes collapsed)
call (+116 nodes collapsed)
call (+228 nodes collapsed)
call (+160 nodes collapsed)
call (+163 nodes collapsed)
call (+181 nodes collapsed)
call (+126 nodes collapsed)
call (+87 nodes collapsed)
call (+179 nodes collapsed)
call (+204 nodes collapsed)
call (+143 nodes collapsed)
call (+161 nodes collapsed)
call (+105 nodes collapsed)
call (+211 nodes collapsed)
call (+162 nodes collapsed)
call (+177 nodes collapsed)
call (+153 nodes collapsed)
call (+123 nodes collapsed)
call (+163 nodes collapsed)
call
identifier "create_table"
argument_list (+29 nodes collapsed)
do_block
do "do"
block_parameters
| "|"
identifier "t"
| "|"
body_statement
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "status_id"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "file_file_name"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "file_content_type"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "file_file_size"
" "\""
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "file_updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
call (+21 nodes collapsed)
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "created_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "shortcode"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "type"
" "\""
, ","
pair
hash_key_symbol "default"
: ":"
integer "0"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "json"
argument_list
string
" "\""
string_content "file_meta"
" "\""
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "account_id"
" "\""
call
identifier "t"
. "."
identifier "text"
argument_list
string
" "\""
string_content "description"
" "\""
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "scheduled_status_id"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "blurhash"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "processing"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "file_storage_schema_version"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_file_name"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_content_type"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "thumbnail_file_size"
" "\""
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "thumbnail_updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_remote_url"
" "\""
call (+36 nodes collapsed)
call (+28 nodes collapsed)
call (+38 nodes collapsed)
call
identifier "t"
. "."
identifier "index"
argument_list
array
[ "["
string
" "\""
string_content "status_id"
" "\""
] "]"
, ","
pair
hash_key_symbol "name"
: ":"
string
" "\""
string_content "index_media_attachments_on_status_id"
" "\""
end "end"
call (+157 nodes collapsed)
call (+172 nodes collapsed)
call (+116 nodes collapsed)
call (+182 nodes collapsed)
call (+193 nodes collapsed)
call (+321 nodes collapsed)
call (+197 nodes collapsed)
call (+229 nodes collapsed)
call (+270 nodes collapsed)
call (+96 nodes collapsed)
call (+156 nodes collapsed)
call (+295 nodes collapsed)
call (+175 nodes collapsed)
call (+125 nodes collapsed)
call (+509 nodes collapsed)
call (+73 nodes collapsed)
call (+330 nodes collapsed)
call (+120 nodes collapsed)
call (+109 nodes collapsed)
call (+142 nodes collapsed)
call (+324 nodes collapsed)
call (+148 nodes collapsed)
call (+136 nodes collapsed)
call (+98 nodes collapsed)
call (+201 nodes collapsed)
call (+98 nodes collapsed)
call (+221 nodes collapsed)
call (+166 nodes collapsed)
call (+146 nodes collapsed)
call (+213 nodes collapsed)
call (+138 nodes collapsed)
call (+193 nodes collapsed)
call (+159 nodes collapsed)
call (+697 nodes collapsed)
call (+84 nodes collapsed)
call (+126 nodes collapsed)
call (+142 nodes collapsed)
call (+208 nodes collapsed)
call (+150 nodes collapsed)
call (+137 nodes collapsed)
call (+106 nodes collapsed)
call (+103 nodes collapsed)
call (+147 nodes collapsed)
call (+156 nodes collapsed)
call (+680 nodes collapsed)
call (+206 nodes collapsed)
call (+108 nodes collapsed)
call (+185 nodes collapsed)
call (+162 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_aliases"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_conversations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_conversations"
" "\""
, ","
string
" "\""
string_content "conversations"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_deletion_requests"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_migrations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_moderation_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_pins"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_relationship_severance_events"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_relationship_severance_events"
" "\""
, ","
string
" "\""
string_content "relationship_severance_events"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_stats"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_statuses_cleanup_policies"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_warnings"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_warnings"
" "\""
, ","
string
" "\""
string_content "reports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "admin_action_logs"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_mutes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_mutes"
" "\""
, ","
string
" "\""
string_content "announcements"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "announcements"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "custom_emojis"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "appeals"
" "\""
, ","
string
" "\""
string_content "account_warnings"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "appeals"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "backups"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bookmarks"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bookmarks"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bulk_import_rows"
" "\""
, ","
string
" "\""
string_content "bulk_imports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bulk_imports"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collection_items"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collection_items"
" "\""
, ","
string
" "\""
string_content "collections"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collections"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collections"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "conversation_mutes"
" "\""
, ","
string
" "\""
string_content "conversations"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_keywords"
" "\""
, ","
string
" "\""
string_content "custom_filters"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_statuses"
" "\""
, ","
string
" "\""
string_content "custom_filters"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_statuses"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filters"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_backfill_requests"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_debug_callbacks"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_follow_recommendations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "column"
: ":"
string
" "\""
string_content "recommended_account_id"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_follow_recommendations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "column"
: ":"
string
" "\""
string_content "requesting_account_id"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_subscriptions"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "featured_tags"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "featured_tags"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "follow_recommendation_mutes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "follow_recommendation_suppressions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "generated_annual_reports"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "instance_moderation_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "invites"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "follow_requests"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "follows"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "lists"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "lists"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "login_activities"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "markers"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "media_attachments"
" "\""
, ","
string
" "\""
string_content "scheduled_statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "media_attachments"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "mentions"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_permissions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_policies"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_requests"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "poll_votes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "poll_votes"
" "\""
, ","
string
" "\""
string_content "polls"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "polls"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "polls"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "preview_card_trends"
" "\""
, ","
string
" "\""
string_content "preview_cards"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "quotes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "quotes"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "report_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "report_notes"
" "\""
, ","
string
" "\""
string_content "reports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "rule_translations"
" "\""
, ","
string
" "\""
string_content "rules"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "scheduled_statuses"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "severed_relationships"
" "\""
, ","
string
" "\""
string_content "relationship_severance_events"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_edits"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_edits"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_pins"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_stats"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_trends"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_trends"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "statuses_tags"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_follows"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_follows"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_trends"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tombstones"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "user_invite_requests"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "users"
" "\""
, ","
string
" "\""
string_content "invites"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "web_push_subscriptions"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "webauthn_credentials"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "create_view"
argument_list
string
" "\""
string_content "account_summaries"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT accounts.id AS account_id,\n mode() WITHIN"...
heredoc_end "SQL"
call (+33 nodes collapsed)
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "global_follow_recommendations"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT account_id,\n sum(rank) AS rank,\n arr"...
heredoc_end "SQL"
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "instances"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n WITH domain_counts(domain, accounts_count) AS (\n "...
heredoc_end "SQL"
call
identifier "add_index"
argument_list
string
" "\""
string_content "instances"
" "\""
, ","
string
" "\""
string_content "reverse(('.'::text || (domain)::text)), domain"
" "\""
, ","
pair
hash_key_symbol "name"
: ":"
string
" "\""
string_content "index_instances_on_reverse_domain"
" "\""
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "user_ips"
" "\""
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT user_id,\n ip,\n max(used_at) AS used_"...
heredoc_end "SQL"
end "end"

After

program
comment "# This file is auto-generated from the current state of the "...
comment "# of editing this file, please use the migrations feature of"...
comment "# incrementally modify your database, and then regenerate th"...
comment "#"
comment "# This file is the source Rails uses to define your schema w"...
comment "# db:schema:load`. When creating a new database, `bin/rails "...
comment "# be faster and is potentially less error prone than running"...
comment "# migrations from scratch. Old migrations may fail to apply "...
comment "# migrations use external dependencies or application code."
comment "#"
comment "# It's strongly recommended that you check this file into yo"...
call
element_reference
scope_resolution
constant "ActiveRecord"
:: "::"
constant "Schema"
[ "["
float "8.0"
] "]"
. "."
identifier "define"
argument_list
( "("
pair
hash_key_symbol "version"
: ":"
integer "2025_11_19_093332"
) ")"
do_block
do "do"
comment "# These are extensions that must be enabled in order to supp"...
body_statement
call
identifier "enable_extension"
argument_list
string
" "\""
string_content "pg_catalog.plpgsql"
" "\""
call (+146 nodes collapsed)
call (+202 nodes collapsed)
call (+94 nodes collapsed)
call (+118 nodes collapsed)
call (+166 nodes collapsed)
call (+142 nodes collapsed)
call (+152 nodes collapsed)
call (+138 nodes collapsed)
call (+164 nodes collapsed)
call (+210 nodes collapsed)
call (+252 nodes collapsed)
call (+102 nodes collapsed)
call (+196 nodes collapsed)
call (+897 nodes collapsed)
call (+89 nodes collapsed)
call (+185 nodes collapsed)
call (+138 nodes collapsed)
call (+201 nodes collapsed)
call (+202 nodes collapsed)
call (+92 nodes collapsed)
call (+246 nodes collapsed)
call (+150 nodes collapsed)
call (+147 nodes collapsed)
call (+138 nodes collapsed)
call (+91 nodes collapsed)
call (+269 nodes collapsed)
call (+123 nodes collapsed)
call (+251 nodes collapsed)
call (+199 nodes collapsed)
call (+78 nodes collapsed)
call (+158 nodes collapsed)
call (+94 nodes collapsed)
call (+236 nodes collapsed)
call (+122 nodes collapsed)
call (+126 nodes collapsed)
call (+175 nodes collapsed)
call (+106 nodes collapsed)
call (+195 nodes collapsed)
call (+134 nodes collapsed)
call (+143 nodes collapsed)
call (+110 nodes collapsed)
call (+116 nodes collapsed)
call (+228 nodes collapsed)
call (+160 nodes collapsed)
call (+163 nodes collapsed)
call (+181 nodes collapsed)
call (+126 nodes collapsed)
call (+87 nodes collapsed)
call (+179 nodes collapsed)
call (+204 nodes collapsed)
call (+143 nodes collapsed)
call (+161 nodes collapsed)
call (+105 nodes collapsed)
call (+211 nodes collapsed)
call (+162 nodes collapsed)
call (+177 nodes collapsed)
call (+153 nodes collapsed)
call (+123 nodes collapsed)
call (+163 nodes collapsed)
call
identifier "create_table"
argument_list (+29 nodes collapsed)
do_block
do "do"
block_parameters
| "|"
identifier "t"
| "|"
body_statement
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "status_id"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "file_file_name"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "file_content_type"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "file_file_size"
" "\""
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "file_updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
call (+21 nodes collapsed)
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "created_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "shortcode"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "type"
" "\""
, ","
pair
hash_key_symbol "default"
: ":"
integer "0"
, ","
pair
hash_key_symbol "null"
: ":"
false "false"
call
identifier "t"
. "."
identifier "json"
argument_list
string
" "\""
string_content "file_meta"
" "\""
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "account_id"
" "\""
call
identifier "t"
. "."
identifier "text"
argument_list
string
" "\""
string_content "description"
" "\""
call
identifier "t"
. "."
identifier "bigint"
argument_list
string
" "\""
string_content "scheduled_status_id"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "blurhash"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "processing"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "file_storage_schema_version"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_file_name"
" "\""
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_content_type"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "thumbnail_file_size"
" "\""
call
identifier "t"
. "."
identifier "datetime"
argument_list
string
" "\""
string_content "thumbnail_updated_at"
" "\""
, ","
pair
hash_key_symbol "precision"
: ":"
nil
nil "nil"
call
identifier "t"
. "."
identifier "string"
argument_list
string
" "\""
string_content "thumbnail_remote_url"
" "\""
call
identifier "t"
. "."
identifier "integer"
argument_list
string
" "\""
string_content "thumbnail_storage_schema_version"
" "\""
call (+36 nodes collapsed)
call (+28 nodes collapsed)
call (+38 nodes collapsed)
call
identifier "t"
. "."
identifier "index"
argument_list
array
[ "["
string
" "\""
string_content "status_id"
" "\""
] "]"
, ","
pair
hash_key_symbol "name"
: ":"
string
" "\""
string_content "index_media_attachments_on_status_id"
" "\""
end "end"
call (+157 nodes collapsed)
call (+172 nodes collapsed)
call (+116 nodes collapsed)
call (+182 nodes collapsed)
call (+193 nodes collapsed)
call (+321 nodes collapsed)
call (+197 nodes collapsed)
call (+229 nodes collapsed)
call (+270 nodes collapsed)
call (+96 nodes collapsed)
call (+156 nodes collapsed)
call (+295 nodes collapsed)
call (+175 nodes collapsed)
call (+125 nodes collapsed)
call (+509 nodes collapsed)
call (+73 nodes collapsed)
call (+330 nodes collapsed)
call (+120 nodes collapsed)
call (+109 nodes collapsed)
call (+142 nodes collapsed)
call (+324 nodes collapsed)
call (+148 nodes collapsed)
call (+136 nodes collapsed)
call (+98 nodes collapsed)
call (+201 nodes collapsed)
call (+98 nodes collapsed)
call (+221 nodes collapsed)
call (+166 nodes collapsed)
call (+146 nodes collapsed)
call (+213 nodes collapsed)
call (+138 nodes collapsed)
call (+193 nodes collapsed)
call (+159 nodes collapsed)
call (+697 nodes collapsed)
call (+84 nodes collapsed)
call (+126 nodes collapsed)
call (+142 nodes collapsed)
call (+208 nodes collapsed)
call (+150 nodes collapsed)
call (+137 nodes collapsed)
call (+106 nodes collapsed)
call (+103 nodes collapsed)
call (+147 nodes collapsed)
call (+156 nodes collapsed)
call (+680 nodes collapsed)
call (+206 nodes collapsed)
call (+108 nodes collapsed)
call (+185 nodes collapsed)
call (+162 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_aliases"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_conversations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_conversations"
" "\""
, ","
string
" "\""
string_content "conversations"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_deletion_requests"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_migrations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_moderation_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_pins"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_relationship_severance_events"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_relationship_severance_events"
" "\""
, ","
string
" "\""
string_content "relationship_severance_events"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_stats"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_statuses_cleanup_policies"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_warnings"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "account_warnings"
" "\""
, ","
string
" "\""
string_content "reports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "admin_action_logs"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_mutes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_mutes"
" "\""
, ","
string
" "\""
string_content "announcements"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "announcements"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "announcement_reactions"
" "\""
, ","
string
" "\""
string_content "custom_emojis"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "appeals"
" "\""
, ","
string
" "\""
string_content "account_warnings"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "appeals"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "backups"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bookmarks"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bookmarks"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bulk_import_rows"
" "\""
, ","
string
" "\""
string_content "bulk_imports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "bulk_imports"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collection_items"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collection_items"
" "\""
, ","
string
" "\""
string_content "collections"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collections"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "collections"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "conversation_mutes"
" "\""
, ","
string
" "\""
string_content "conversations"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_keywords"
" "\""
, ","
string
" "\""
string_content "custom_filters"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_statuses"
" "\""
, ","
string
" "\""
string_content "custom_filters"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filter_statuses"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "custom_filters"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_backfill_requests"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_debug_callbacks"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_follow_recommendations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "column"
: ":"
string
" "\""
string_content "recommended_account_id"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_follow_recommendations"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "column"
: ":"
string
" "\""
string_content "requesting_account_id"
" "\""
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "fasp_subscriptions"
" "\""
, ","
string
" "\""
string_content "fasp_providers"
" "\""
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "featured_tags"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "featured_tags"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "follow_recommendation_mutes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "follow_recommendation_suppressions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "generated_annual_reports"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "instance_moderation_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "invites"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "follow_requests"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "follows"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "list_accounts"
" "\""
, ","
string
" "\""
string_content "lists"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "lists"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "login_activities"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "markers"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "media_attachments"
" "\""
, ","
string
" "\""
string_content "scheduled_statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "media_attachments"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "mentions"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_permissions"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_policies"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "notification_requests"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call (+33 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "poll_votes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "poll_votes"
" "\""
, ","
string
" "\""
string_content "polls"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "polls"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "polls"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "preview_card_trends"
" "\""
, ","
string
" "\""
string_content "preview_cards"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "quotes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "quotes"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "report_notes"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "report_notes"
" "\""
, ","
string
" "\""
string_content "reports"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "rule_translations"
" "\""
, ","
string
" "\""
string_content "rules"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "scheduled_statuses"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "severed_relationships"
" "\""
, ","
string
" "\""
string_content "relationship_severance_events"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_edits"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_edits"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_pins"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_stats"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_trends"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "status_trends"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+33 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "statuses_tags"
" "\""
, ","
string
" "\""
string_content "statuses"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_follows"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_follows"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tag_trends"
" "\""
, ","
string
" "\""
string_content "tags"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "tombstones"
" "\""
, ","
string
" "\""
string_content "accounts"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "user_invite_requests"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "users"
" "\""
, ","
string
" "\""
string_content "invites"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":nullify"
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "web_push_subscriptions"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call (+25 nodes collapsed)
call
identifier "add_foreign_key"
argument_list
string
" "\""
string_content "webauthn_credentials"
" "\""
, ","
string
" "\""
string_content "users"
" "\""
, ","
pair
hash_key_symbol "on_delete"
: ":"
simple_symbol ":cascade"
call
identifier "create_view"
argument_list
string
" "\""
string_content "account_summaries"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT accounts.id AS account_id,\n mode() WITHIN"...
heredoc_end "SQL"
call (+33 nodes collapsed)
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "global_follow_recommendations"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT account_id,\n sum(rank) AS rank,\n arr"...
heredoc_end "SQL"
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "instances"
" "\""
, ","
pair
hash_key_symbol "materialized"
: ":"
true "true"
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n WITH domain_counts(domain, accounts_count) AS (\n "...
heredoc_end "SQL"
call
identifier "add_index"
argument_list
string
" "\""
string_content "instances"
" "\""
, ","
string
" "\""
string_content "reverse(('.'::text || (domain)::text)), domain"
" "\""
, ","
pair
hash_key_symbol "name"
: ":"
string
" "\""
string_content "index_instances_on_reverse_domain"
" "\""
call (+28 nodes collapsed)
call
identifier "create_view"
argument_list
string
" "\""
string_content "user_ips"
" "\""
, ","
pair
hash_key_symbol "sql_definition"
: ":"
heredoc_beginning "<<-SQL"
heredoc_body
heredoc_content "\n SELECT user_id,\n ip,\n max(used_at) AS used_"...
heredoc_end "SQL"
end "end"