path: root/db/migrate/0000_create_schema.rb

# frozen_string_literal: true

class CreateSchema < ActiveRecord::Migration[4.2]
  # rubocop:disable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
  def up
    create_table :account_deletions do |t|
      t.string   :diaspora_handle
      t.integer  :person_id
      t.datetime :completed_at
    end

    create_table :aspect_memberships do |t|
      t.integer  :aspect_id,  null: false
      t.integer  :contact_id, null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :aspect_memberships, %i[aspect_id contact_id], name: :index_aspect_memberships_on_aspect_id_and_contact_id, unique: true
    add_index :aspect_memberships, :aspect_id, name: :index_aspect_memberships_on_aspect_id
    add_index :aspect_memberships, :contact_id, name: :index_aspect_memberships_on_contact_id

    create_table :aspect_visibilities do |t|
      t.integer  :shareable_id,                    null: false
      t.integer  :aspect_id,                       null: false
      t.string   :shareable_type, default: "Post", null: false
    end

    add_index :aspect_visibilities, :aspect_id, name: :index_aspect_visibilities_on_aspect_id
    add_index :aspect_visibilities, %i[shareable_id shareable_type aspect_id], name: :shareable_and_aspect_id, length: {shareable_type: 189}
    add_index :aspect_visibilities, %i[shareable_id shareable_type], name: :index_aspect_visibilities_on_shareable_id_and_shareable_type, length: {shareable_type: 190}

    create_table :aspects do |t|
      t.string   :name,                             null: false
      t.integer  :user_id,                          null: false
      t.datetime :created_at,                       null: false
      t.datetime :updated_at,                       null: false
      t.boolean  :contacts_visible, default: true,  null: false
      t.integer  :order_id
      t.boolean  :chat_enabled,     default: false
    end

    add_index :aspects, %i[user_id contacts_visible], name: :index_aspects_on_user_id_and_contacts_visible
    add_index :aspects, :user_id, name: :index_aspects_on_user_id

    create_table :authorizations do |t|
      t.integer  :user_id
      t.integer  :o_auth_application_id
      t.string   :refresh_token
      t.string   :code
      t.string   :redirect_uri
      t.string   :nonce
      t.string   :scopes
      t.boolean  :code_used,             default: false
      t.datetime :created_at,                            null: false
      t.datetime :updated_at,                            null: false
    end

    add_index :authorizations, :user_id, name: :index_authorizations_on_user_id
    add_index :authorizations, :o_auth_application_id, name: :index_authorizations_on_o_auth_application_id

    create_table :blocks do |t|
      t.integer :user_id
      t.integer :person_id
    end

    create_table :chat_contacts do |t|
      t.integer :user_id,                  null: false
      ## JID <= 3071 bytes http://tools.ietf.org/html/rfc6122
      t.string  :jid,                      null: false
      t.string  :name,         limit: 255, null: true
      t.string  :ask,          limit: 128, null: true
      t.string  :subscription, limit: 128, null: false
    end

    add_index :chat_contacts, %i[user_id jid], name: :index_chat_contacts_on_user_id_and_jid, length: {jid: 190}, unique: true

    create_table :chat_fragments do |t|
      t.integer :user_id,               null: false
      t.string  :root,      limit: 256, null: false
      t.string  :namespace, limit: 256, null: false
      t.text    :xml,                   null: false
    end

    add_index :chat_fragments, :user_id, name: :index_chat_fragments_on_user_id, unique: true

    create_table :chat_offline_messages do |t|
      t.string   :from,       null: false
      t.string   :to,         null: false
      t.text     :message,    null: false
      t.datetime :created_at, null: false
    end

    create_table :comment_signatures, id: false do |t|
      t.integer :comment_id,         null: false
      t.text    :author_signature,   null: false
      t.integer :signature_order_id, null: false
      t.text    :additional_data
    end

    add_index :comment_signatures, :comment_id, name: :index_comment_signatures_on_comment_id, unique: true

    create_table :comments do |t|
      t.text     :text,                                               null: false
      t.integer  :commentable_id,                                     null: false
      t.integer  :author_id,                                          null: false
      t.string   :guid,                                               null: false
      t.datetime :created_at,                                         null: false
      t.datetime :updated_at,                                         null: false
      t.integer  :likes_count,                       default: 0,      null: false
      t.string   :commentable_type,       limit: 60, default: "Post", null: false
    end

    add_index :comments, :author_id, name: :index_comments_on_person_id
    add_index :comments, %i[commentable_id commentable_type], name: :index_comments_on_commentable_id_and_commentable_type
    add_index :comments, :guid, name: :index_comments_on_guid, length: {guid: 191}, unique: true

    create_table :contacts do |t|
      t.integer  :user_id,                    null: false
      t.integer  :person_id,                  null: false
      t.datetime :created_at,                 null: false
      t.datetime :updated_at,                 null: false
      t.boolean  :sharing,    default: false, null: false
      t.boolean  :receiving,  default: false, null: false
    end

    add_index :contacts, :person_id, name: :index_contacts_on_person_id
    add_index :contacts, %i[user_id person_id], name: :index_contacts_on_user_id_and_person_id, unique: true

    create_table :conversation_visibilities do |t|
      t.integer  :conversation_id,             null: false
      t.integer  :person_id,                   null: false
      t.integer  :unread,          default: 0, null: false
      t.datetime :created_at,                  null: false
      t.datetime :updated_at,                  null: false
    end

    add_index :conversation_visibilities, %i[conversation_id person_id], name: :index_conversation_visibilities_usefully, unique: true
    add_index :conversation_visibilities, :conversation_id, name: :index_conversation_visibilities_on_conversation_id
    add_index :conversation_visibilities, :person_id, name: :index_conversation_visibilities_on_person_id

    create_table :conversations do |t|
      t.string   :subject
      t.string   :guid,       null: false
      t.integer  :author_id,  null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :conversations, :guid, name: :index_conversations_on_guid, length: 191, unique: true
    add_index :conversations, :author_id, name: :conversations_author_id_fk

    create_table :invitation_codes do |t|
      t.string   :token
      t.integer  :user_id
      t.integer  :count
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :like_signatures, id: false do |t|
      t.integer :like_id,            null: false
      t.text    :author_signature,   null: false
      t.integer :signature_order_id, null: false
      t.text    :additional_data
    end

    add_index :like_signatures, :like_id, name: :index_like_signatures_on_like_id, unique: true

    create_table :likes do |t|
      t.boolean  :positive,                           default: true
      t.integer  :target_id
      t.integer  :author_id
      t.string   :guid
      t.datetime :created_at,                                        null: false
      t.datetime :updated_at,                                        null: false
      t.string   :target_type,             limit: 60,                null: false
    end

    add_index :likes, :author_id, name: :likes_author_id_fk
    add_index :likes, :guid, name: :index_likes_on_guid, length: {guid: 191}, unique: true
    add_index :likes, %i[target_id author_id target_type], name: :index_likes_on_target_id_and_author_id_and_target_type, unique: true
    add_index :likes, :target_id, name: :index_likes_on_post_id

    create_table :locations do |t|
      t.string   :address
      t.string   :lat
      t.string   :lng
      t.integer  :status_message_id
      t.datetime :created_at,        null: false
      t.datetime :updated_at,        null: false
    end

    create_table :mentions do |t|
      t.integer :post_id,   null: false
      t.integer :person_id, null: false
    end

    add_index :mentions, %i[person_id post_id], name: :index_mentions_on_person_id_and_post_id, unique: true
    add_index :mentions, :person_id, name: :index_mentions_on_person_id
    add_index :mentions, :post_id, name: :index_mentions_on_post_id

    create_table :messages do |t|
      t.integer  :conversation_id,         null: false
      t.integer  :author_id,               null: false
      t.string   :guid,                    null: false
      t.text     :text,                    null: false
      t.datetime :created_at,              null: false
      t.datetime :updated_at,              null: false
      t.text     :author_signature
    end

    add_index :messages, :guid, name: :index_messages_on_guid, length: 191, unique: true
    add_index :messages, :author_id, name: :index_messages_on_author_id
    add_index :messages, :conversation_id, name: :messages_conversation_id_fk

    create_table :notification_actors do |t|
      t.integer  :notification_id
      t.integer  :person_id
      t.datetime :created_at,      null: false
      t.datetime :updated_at,      null: false
    end

    add_index :notification_actors, %i[notification_id person_id], name: :index_notification_actors_on_notification_id_and_person_id, unique: true
    add_index :notification_actors, :notification_id, name: :index_notification_actors_on_notification_id
    add_index :notification_actors, :person_id, name: :index_notification_actors_on_person_id

    create_table :notifications do |t|
      t.string   :target_type
      t.integer  :target_id
      t.integer  :recipient_id,                null: false
      t.boolean  :unread,       default: true, null: false
      t.datetime :created_at,                  null: false
      t.datetime :updated_at,                  null: false
      t.string   :type
    end

    add_index :notifications, :recipient_id, name: :index_notifications_on_recipient_id
    add_index :notifications, :target_id, name: :index_notifications_on_target_id
    add_index :notifications, %i[target_type target_id], name: :index_notifications_on_target_type_and_target_id, length: {target_type: 190}

    create_table :o_auth_access_tokens do |t|
      t.integer  :authorization_id
      t.string   :token
      t.datetime :expires_at
      t.datetime :created_at,                                 null: false
      t.datetime :updated_at,                                 null: false
    end

    add_index :o_auth_access_tokens, :authorization_id, name: :index_o_auth_access_tokens_on_authorization_id
    add_index :o_auth_access_tokens, :token, name: :index_o_auth_access_tokens_on_token, length: {token: 191}, unique: true

    create_table :o_auth_applications do |t|
      t.integer  :user_id
      t.string   :client_id
      t.string   :client_secret
      t.string   :client_name
      t.text     :redirect_uris
      t.string   :response_types
      t.string   :grant_types
      t.string   :application_type,           default: "web"
      t.string   :contacts
      t.string   :logo_uri
      t.string   :client_uri
      t.string   :policy_uri
      t.string   :tos_uri
      t.string   :sector_identifier_uri
      t.string   :token_endpoint_auth_method
      t.text     :jwks
      t.string   :jwks_uri
      t.boolean  :ppid,                       default: false
      t.datetime :created_at,                                 null: false
      t.datetime :updated_at,                                 null: false
    end

    add_index :o_auth_applications, :user_id, name: :index_o_auth_applications_on_user_id
    add_index :o_auth_applications, :client_id, name: :index_o_auth_applications_on_client_id, length: {client_id: 191}, unique: true

    create_table :open_graph_caches do |t|
      t.string :title
      t.string :ob_type
      t.text   :image
      t.text   :url
      t.text   :description
    end

    create_table :o_embed_caches do |t|
      t.string :url,  limit: 1024, null: false
      t.text   :data,              null: false
    end

    add_index :o_embed_caches, :url, name: :index_o_embed_caches_on_url, length: {url: 191}

    create_table :participations do |t|
      t.string   :guid
      t.integer  :target_id
      t.string   :target_type,             limit: 60, null: false
      t.integer  :author_id
      t.datetime :created_at,                         null: false
      t.datetime :updated_at,                         null: false
      t.integer  :count,       default: 1,            null: false
    end

    add_index :participations, :guid, name: :index_participations_on_guid, length: {guid: 191}
    add_index :participations, :author_id, name: :index_participations_on_author_id
    add_index :participations, %i[target_id target_type author_id], name: :index_participations_on_target_id_and_target_type_and_author_id, unique: true

    create_table :people do |t|
      t.string   :guid,                                  null: false
      t.string   :diaspora_handle,                       null: false
      t.text     :serialized_public_key,                 null: false
      t.integer  :owner_id
      t.datetime :created_at,                            null: false
      t.datetime :updated_at,                            null: false
      t.boolean  :closed_account,        default: false
      t.integer  :fetch_status,          default: 0
      t.integer  :pod_id
    end

    add_index :people, :diaspora_handle, name: :index_people_on_diaspora_handle, unique: true, length: {diaspora_handle: 191}
    add_index :people, :guid, name: :index_people_on_guid, length: {guid: 191}, unique: true
    add_index :people, :owner_id, name: :index_people_on_owner_id, unique: true

    create_table :photos do |t|
      t.integer  :author_id,                           null: false
      t.boolean  :public,              default: false, null: false
      t.string   :guid,                                null: false
      t.boolean  :pending,             default: false, null: false
      t.text     :text
      t.text     :remote_photo_path
      t.string   :remote_photo_name
      t.string   :random_string
      t.string   :processed_image
      t.datetime :created_at
      t.datetime :updated_at
      t.string   :unprocessed_image
      t.string   :status_message_guid
      t.integer  :comments_count
      t.integer  :height
      t.integer  :width
    end

    add_index :photos, :guid, name: :index_photos_on_guid, length: 191, unique: true
    add_index :photos, :status_message_guid, name: :index_photos_on_status_message_guid, length: {status_message_guid: 191}

    create_table :pods do |t|
      t.string   :host
      t.boolean  :ssl
      t.datetime :created_at,                              null: false
      t.datetime :updated_at,                              null: false
      t.integer  :status,        default: 0
      t.datetime :checked_at,    default: Time.zone.at(0)
      t.datetime :offline_since, default: nil
      t.integer  :response_time, default: -1
      t.string   :software
      t.string   :error
      t.integer  :port
      t.boolean  :blocked,       default: false
    end

    add_index :pods, :status, name: :index_pods_on_status
    add_index :pods, :checked_at, name: :index_pods_on_checked_at
    add_index :pods, :offline_since, name: :index_pods_on_offline_since
    add_index :pods, %i[host port], name: :index_pods_on_host_and_port, length: {host: 190}, unique: true

    create_table :poll_answers do |t|
      t.string  :answer,                 null: false
      t.integer :poll_id,                null: false
      t.string  :guid
      t.integer :vote_count, default: 0
    end

    add_index :poll_answers, :guid, name: :index_poll_answers_on_guid, length: 191, unique: true
    add_index :poll_answers, :poll_id, name: :index_poll_answers_on_poll_id

    create_table :poll_participation_signatures, id: false do |t|
      t.integer :poll_participation_id, null: false
      t.text    :author_signature,       null: false
      t.integer :signature_order_id,     null: false
      t.text    :additional_data
    end

    add_index :poll_participation_signatures, :poll_participation_id, name: :index_poll_participation_signatures_on_poll_participation_id, unique: true

    create_table :poll_participations do |t|
      t.integer    :poll_answer_id,          null: false
      t.integer    :author_id,               null: false
      t.integer    :poll_id,                 null: false
      t.string     :guid
      t.timestamps
    end

    add_index :poll_participations, :guid, name: :index_poll_participations_on_guid, length: 191, unique: true
    add_index :poll_participations, :poll_id, name: :index_poll_participations_on_poll_id

    create_table :polls do |t|
      t.string     :question,          null: false
      t.integer    :status_message_id, null: false
      t.boolean    :status
      t.string     :guid
      t.timestamps
    end

    add_index :polls, :guid, name: :index_polls_on_guid, length: 191, unique: true
    add_index :polls, :status_message_id, name: :index_polls_on_status_message_id

    create_table :posts do |t|
      t.integer  :author_id,                                        null: false
      t.boolean  :public,                           default: false, null: false
      t.string   :guid,                                             null: false
      t.string   :type,                  limit: 40,                 null: false
      t.text     :text
      t.datetime :created_at,                                       null: false
      t.datetime :updated_at,                                       null: false
      t.string   :provider_display_name
      t.string   :root_guid
      t.integer  :likes_count,                      default: 0
      t.integer  :comments_count,                   default: 0
      t.integer  :o_embed_cache_id
      t.integer  :reshares_count,                   default: 0
      t.datetime :interacted_at
      t.string   :facebook_id
      t.string   :tweet_id
      t.integer  :open_graph_cache_id
      t.text     :tumblr_ids
    end

    add_index :posts, %i[id type], name: :index_posts_on_id_and_type
    add_index :posts, %i[author_id root_guid], name: :index_posts_on_author_id_and_root_guid, length: {root_guid: 190}, unique: true
    add_index :posts, :author_id, name: :index_posts_on_person_id
    add_index :posts, :guid, name: :index_posts_on_guid, length: {guid: 191}, unique: true
    add_index :posts, %i[id type created_at], name: :index_posts_on_id_and_type_and_created_at
    add_index :posts, :root_guid, name: :index_posts_on_root_guid, length: {root_guid: 191}
    add_index :posts, :tweet_id, name: :index_posts_on_tweet_id, length: {tweet_id: 191}

    create_table :ppid do |t|
      t.integer :o_auth_application_id
      t.integer :user_id
      t.string :guid,       limit: 32
      t.string :string,     limit: 32
      t.string :identifier
    end

    add_index :ppid, :o_auth_application_id, name: :index_ppid_on_o_auth_application_id
    add_index :ppid, :user_id, name: :index_ppid_on_user_id

    create_table :profiles do |t|
      t.string   :diaspora_handle
      t.string   :first_name,       limit: 127
      t.string   :last_name,        limit: 127
      t.string   :image_url
      t.string   :image_url_small
      t.string   :image_url_medium
      t.date     :birthday
      t.string   :gender
      t.text     :bio
      t.boolean  :searchable,                   default: true,  null: false
      t.integer  :person_id,                                    null: false
      t.datetime :created_at,                                   null: false
      t.datetime :updated_at,                                   null: false
      t.string   :location
      t.string   :full_name,        limit: 70
      t.boolean  :nsfw,                         default: false
      t.boolean  :public_details,               default: false
    end

    add_index :profiles, %i[full_name searchable], name: :index_profiles_on_full_name_and_searchable
    add_index :profiles, :full_name, name: :index_profiles_on_full_name
    add_index :profiles, :person_id, name: :index_profiles_on_person_id

    create_table :rails_admin_histories do |t|
      t.text     :message
      t.string   :username
      t.integer  :item
      t.string   :table
      t.integer  :month,      limit: 2
      t.integer  :year,       limit: 8
      t.datetime :created_at,           null: false
      t.datetime :updated_at,           null: false
    end

    add_index :rails_admin_histories, %i[item table month year], name: :index_rails_admin_histories, length: {table: 188}

    create_table :reports do |t|
      t.integer :item_id,                   null: false
      t.string  :item_type,                 null: false
      t.boolean :reviewed, default: false
      t.text    :text
      t.timestamps
      t.integer :user_id,                   null: false
    end

    add_index :reports, :item_id, name: :index_reports_on_item_id

    create_table :roles do |t|
      t.integer  :person_id
      t.string   :name
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :services do |t|
      t.string   :type,          limit: 127, null: false
      t.integer  :user_id,                   null: false
      t.string   :uid,           limit: 127
      t.string   :access_token
      t.string   :access_secret
      t.string   :nickname
      t.datetime :created_at,                null: false
      t.datetime :updated_at,                null: false
    end

    add_index :services, %i[type uid], name: :index_services_on_type_and_uid, length: {type: 64, uid: 127}
    add_index :services, :user_id, name: :index_services_on_user_id

    create_table :share_visibilities do |t|
      t.integer  :shareable_id,                               null: false
      t.boolean  :hidden,                    default: false,  null: false
      t.string   :shareable_type, limit: 60, default: "Post", null: false
      t.integer  :user_id,                                    null: false
    end

    add_index :share_visibilities, :user_id, name: :index_share_visibilities_on_user_id
    add_index :share_visibilities, %i[shareable_id shareable_type user_id], name: :shareable_and_user_id
    add_index :share_visibilities, %i[shareable_id shareable_type hidden user_id], name: :shareable_and_hidden_and_user_id
    add_index :share_visibilities, :shareable_id, name: :index_post_visibilities_on_post_id

    create_table :signature_orders do |t|
      t.string :order, null: false
    end

    add_index :signature_orders, :order, name: :index_signature_orders_on_order, length: 191, unique: true

    create_table :simple_captcha_data do |t|
      t.string     :key,   limit: 40
      t.string     :value, limit: 12
      t.timestamps
    end

    add_index :simple_captcha_data, :key, name: :idx_key

    create_table :tag_followings do |t|
      t.integer  :tag_id,     null: false
      t.integer  :user_id,    null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :tag_followings, %i[tag_id user_id], name: :index_tag_followings_on_tag_id_and_user_id, unique: true
    add_index :tag_followings, :tag_id, name: :index_tag_followings_on_tag_id
    add_index :tag_followings, :user_id, name: :index_tag_followings_on_user_id

    create_table :taggings do |t|
      t.integer  :tag_id
      t.integer  :taggable_id
      t.string   :taggable_type, limit: 127
      t.integer  :tagger_id
      t.string   :tagger_type,   limit: 127
      t.string   :context,       limit: 127
      t.datetime :created_at
    end

    add_index :taggings, :created_at, name: :index_taggings_on_created_at
    add_index :taggings, :tag_id, name: :index_taggings_on_tag_id
    add_index :taggings, %i[taggable_id taggable_type context], name: :index_taggings_on_taggable_id_and_taggable_type_and_context, length: {taggable_type: 95, context: 95}
    add_index :taggings, %i[taggable_id taggable_type tag_id], name: :index_taggings_uniquely, unique: true

    create_table :tags do |t|
      t.string  :name
      t.integer :taggings_count, default: 0
    end

    add_index :tags, :name, name: :index_tags_on_name, unique: true, length: {name: 191}

    create_table :user_preferences do |t|
      t.string   :email_type
      t.integer  :user_id
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :users do |t|
      t.string   :username,                                                       null: false
      t.text     :serialized_private_key
      t.boolean  :getting_started,                                default: true,  null: false
      t.boolean  :disable_mail,                                   default: false, null: false
      t.string   :language
      t.string   :email,                                          default: "",    null: false
      t.string   :encrypted_password,                             default: "",    null: false
      t.string   :reset_password_token
      t.datetime :remember_created_at
      t.integer  :sign_in_count,                                  default: 0
      t.datetime :current_sign_in_at
      t.datetime :last_sign_in_at
      t.string   :current_sign_in_ip
      t.string   :last_sign_in_ip
      t.datetime :created_at,                                                     null: false
      t.datetime :updated_at,                                                     null: false
      t.integer  :invited_by_id
      t.string   :authentication_token,               limit: 30
      t.string   :unconfirmed_email
      t.string   :confirm_email_token,                limit: 30
      t.datetime :locked_at
      t.boolean  :show_community_spotlight_in_stream,             default: true,  null: false
      t.boolean  :auto_follow_back,                               default: false
      t.integer  :auto_follow_back_aspect_id
      t.text     :hidden_shareables
      t.datetime :reset_password_sent_at
      t.datetime :last_seen
      t.datetime :remove_after
      t.string   :export
      t.datetime :exported_at
      t.boolean  :exporting,                                      default: false
      t.boolean  :strip_exif,                                     default: true
      t.string   :exported_photos_file
      t.datetime :exported_photos_at
      t.boolean  :exporting_photos,                               default: false
      t.string   :color_theme
    end

    add_index :users, :authentication_token, name: :index_users_on_authentication_token, unique: true
    add_index :users, :username, name: :index_users_on_username, length: {username: 191}, unique: true
    add_index :users, :email, name: :index_users_on_email, length: {email: 191}, unique: true

    add_foreign_key :aspect_memberships, :aspects, name: :aspect_memberships_aspect_id_fk, on_delete: :cascade
    add_foreign_key :aspect_memberships, :contacts, name: :aspect_memberships_contact_id_fk, on_delete: :cascade

    add_foreign_key :aspect_visibilities, :aspects, name: :aspect_visibilities_aspect_id_fk, on_delete: :cascade

    add_foreign_key :authorizations, :users
    add_foreign_key :authorizations, :o_auth_applications

    add_foreign_key :comment_signatures, :comments, name: :comment_signatures_comment_id_fk, on_delete: :cascade
    add_foreign_key :comment_signatures, :signature_orders, name: :comment_signatures_signature_orders_id_fk

    add_foreign_key :comments, :people, name: :comments_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :contacts, :people, name: :contacts_person_id_fk, on_delete: :cascade

    add_foreign_key :conversation_visibilities, :conversations, name: :conversation_visibilities_conversation_id_fk, on_delete: :cascade
    add_foreign_key :conversation_visibilities, :people, name: :conversation_visibilities_person_id_fk, on_delete: :cascade

    add_foreign_key :conversations, :people, name: :conversations_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :like_signatures, :likes, name: :like_signatures_like_id_fk, on_delete: :cascade
    add_foreign_key :like_signatures, :signature_orders, name: :like_signatures_signature_orders_id_fk

    add_foreign_key :likes, :people, name: :likes_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :messages, :conversations, name: :messages_conversation_id_fk, on_delete: :cascade
    add_foreign_key :messages, :people, name: :messages_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :notification_actors, :notifications, name: :notification_actors_notification_id_fk, on_delete: :cascade

    add_foreign_key :o_auth_access_tokens, :authorizations

    add_foreign_key :o_auth_applications, :users

    add_foreign_key :people, :pods, name: :people_pod_id_fk, on_delete: :cascade

    add_foreign_key :poll_participation_signatures, :poll_participations, name: :poll_participation_signatures_poll_participation_id_fk, on_delete: :cascade
    add_foreign_key :poll_participation_signatures, :signature_orders, name: :poll_participation_signatures_signature_orders_id_fk

    add_foreign_key :posts, :people, name: :posts_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :ppid, :o_auth_applications
    add_foreign_key :ppid, :users

    add_foreign_key :profiles, :people, name: :profiles_person_id_fk, on_delete: :cascade

    add_foreign_key :services, :users, name: :services_user_id_fk, on_delete: :cascade

    add_foreign_key :share_visibilities, :users, name: :share_visibilities_user_id_fk, on_delete: :cascade
  end
  # rubocop:enable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
end