# frozen_string_literal: true
# rubocop:disable Metrics/ClassLength
# rubocop:disable Metrics/MethodLength
class CreateThredded < ActiveRecord::Migration
  def change
    unless table_exists?(:friendly_id_slugs)
      # The user might have installed FriendlyId separately already.
      create_table :friendly_id_slugs do |t|
        t.string :slug, limit: 191, null: false
        t.integer :sluggable_id, null: false
        t.string :sluggable_type, limit: 50
        t.string :scope, limit: 191
        t.datetime :created_at, null: false
        t.index [:slug, :sluggable_type, :scope],
                name: :index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope,
                unique: true
        t.index [:slug, :sluggable_type], name: :index_friendly_id_slugs_on_slug_and_sluggable_type
        t.index [:sluggable_id], name: :index_friendly_id_slugs_on_sluggable_id
        t.index [:sluggable_type], name: :index_friendly_id_slugs_on_sluggable_type
      end
    end

    create_table :thredded_categories do |t|
      t.references :messageboard, null: false
      t.string :name, limit: 191, null: false
      t.string :description, limit: 255
      t.timestamps null: false
      t.string :slug, limit: 191, null: false
      t.index [:messageboard_id, :slug], name: :index_thredded_categories_on_messageboard_id_and_slug, unique: true
      t.index [:messageboard_id], name: :index_thredded_categories_on_messageboard_id
    end
    DbTextSearch::CaseInsensitive.add_index connection, :thredded_categories, :name, name: :thredded_categories_name_ci

    create_table :thredded_messageboards do |t|
      t.string :name, limit: 191, null: false
      t.string :slug, limit: 191
      t.text :description
      t.integer :topics_count, default: 0
      t.integer :posts_count, default: 0
      t.integer :position, null: false
      t.references :last_topic
      t.references :messageboard_group
      t.timestamps null: false
      t.index [:messageboard_group_id], name: :index_thredded_messageboards_on_messageboard_group_id
      t.index [:slug], name: :index_thredded_messageboards_on_slug
    end

    create_table :thredded_post_notifications do |t|
      t.string :email, limit: 191, null: false
      t.references :post, null: false
      t.timestamps null: false
      t.string :post_type, limit: 191
      t.index [:post_id, :post_type], name: :index_thredded_post_notifications_on_post
    end

    create_table :thredded_posts do |t|
      t.integer :user_id, limit: 4
      t.text :content, limit: 65_535
      t.string :ip, limit: 255
      t.string :source, limit: 255, default: 'web'
      t.references :postable, null: false
      t.references :messageboard, null: false
      t.integer :moderation_state, null: false
      t.timestamps null: false
      t.index [:moderation_state, :updated_at],
              order: { updated_at: :asc },
              name:  :index_thredded_posts_for_display
      t.index [:messageboard_id], name: :index_thredded_posts_on_messageboard_id
      t.index [:postable_id], name: :index_thredded_posts_on_postable_id
      t.index [:postable_id], name: :index_thredded_posts_on_postable_id_and_postable_type
      t.index [:user_id], name: :index_thredded_posts_on_user_id
    end
    DbTextSearch::FullText.add_index connection, :thredded_posts, :content, name: :thredded_posts_content_fts

    create_table :thredded_private_posts do |t|
      t.references :user
      t.text :content, limit: 65_535
      t.references :postable, null: false
      t.string :ip, limit: 255
      t.timestamps null: false
    end

    create_table :thredded_private_topics do |t|
      t.references :user
      t.references :last_user
      t.string :title, limit: 255, null: false
      t.string :slug, limit: 191, null: false
      t.integer :posts_count, default: 0
      t.string :hash_id, limit: 191, null: false
      t.datetime :last_post_at
      t.timestamps null: false
      t.index [:hash_id], name: :index_thredded_private_topics_on_hash_id
      t.index [:slug], name: :index_thredded_private_topics_on_slug
    end

    create_table :thredded_private_users do |t|
      t.references :private_topic, limit: 4
      t.references :user, limit: 4
      t.timestamps null: false
      t.index [:private_topic_id], name: :index_thredded_private_users_on_private_topic_id
      t.index [:user_id], name: :index_thredded_private_users_on_user_id
    end

    create_table :thredded_topic_categories do |t|
      t.references :topic, null: false
      t.references :category, null: false
      t.index [:category_id], name: :index_thredded_topic_categories_on_category_id
      t.index [:topic_id], name: :index_thredded_topic_categories_on_topic_id
    end

    create_table :thredded_topics do |t|
      t.references :user
      t.references :last_user
      t.string :title, limit: 255, null: false
      t.string :slug, limit: 191, null: false
      t.references :messageboard, null: false
      t.integer :posts_count, default: 0, null: false
      t.boolean :sticky, default: false, null: false
      t.boolean :locked, default: false, null: false
      t.string :hash_id, limit: 191, null: false
      t.string :type, limit: 191
      t.integer :moderation_state, null: false
      t.datetime :last_post_at
      t.timestamps null: false
      t.index %i(moderation_state sticky updated_at),
              order: { sticky: :desc, updated_at: :desc },
              name:  :index_thredded_topics_for_display
      t.index [:hash_id], name: :index_thredded_topics_on_hash_id
      t.index [:messageboard_id, :slug], name: :index_thredded_topics_on_messageboard_id_and_slug, unique: true
      t.index [:messageboard_id], name: :index_thredded_topics_on_messageboard_id
      t.index [:user_id], name: :index_thredded_topics_on_user_id
    end
    DbTextSearch::FullText.add_index connection, :thredded_topics, :title, name: :thredded_topics_title_fts

    create_table :thredded_user_details do |t|
      t.references :user, null: false
      t.datetime :latest_activity_at
      t.integer :posts_count, default: 0
      t.integer :topics_count, default: 0
      t.datetime :last_seen_at
      t.integer :moderation_state, null: false, default: 0 # pending_moderation
      t.timestamp :moderation_state_changed_at
      t.timestamps null: false
      t.index %i(moderation_state moderation_state_changed_at),
              order: { moderation_state_changed_at: :desc },
              name: :index_thredded_user_details_for_moderations
      t.index %i(latest_activity_at), name: :index_thredded_user_details_on_latest_activity_at
      t.index %i(user_id), name: :index_thredded_user_details_on_user_id
    end

    create_table :thredded_messageboard_users do |t|
      t.references :thredded_user_detail, foreign_key: true, null: false
      t.references :thredded_messageboard, foreign_key: true, null: false
      t.datetime :last_seen_at, null: false
      t.index [:thredded_messageboard_id, :thredded_user_detail_id],
              name: :index_thredded_messageboard_users_primary
      t.index [:thredded_messageboard_id, :last_seen_at],
              name: :index_thredded_messageboard_users_for_recently_active
    end

    create_table :thredded_user_preferences do |t|
      t.references :user, null: false
      t.boolean :follow_topics_on_mention, default: true, null: false
      t.timestamps null: false
      t.index [:user_id], name: :index_thredded_user_preferences_on_user_id
    end

    create_table :thredded_user_messageboard_preferences do |t|
      t.references :user, null: false
      t.references :messageboard, null: false
      t.boolean :follow_topics_on_mention, default: true, null: false
      t.timestamps null: false
      t.index [:user_id, :messageboard_id],
              name: :thredded_user_messageboard_preferences_user_id_messageboard_id,
              unique: true
    end

    %i(topic private_topic).each do |topics_table|
      table_name = :"thredded_user_#{topics_table}_read_states"
      create_table table_name do |t|
        t.references :user, null: false
        t.integer :postable_id, null: false
        t.integer :page, default: 1, null: false
        t.timestamp :read_at, null: false
        t.index [:user_id, :postable_id], name: :"#{table_name}_user_postable", unique: true
      end
    end

    create_table :thredded_messageboard_groups do |t|
      t.string :name
      t.integer :position, null: false
      t.timestamps null: false
    end

    create_table :thredded_user_topic_follows do |t|
      t.references :user, null: false
      t.integer :topic_id, null: false
      t.datetime :created_at, null: false
      t.integer :reason, limit: 1
      t.index [:user_id, :topic_id], name: :thredded_user_topic_follows_user_topic, unique: true
    end

    create_table :thredded_post_moderation_records do |t|
      t.references :post
      t.references :messageboard
      t.text :post_content, limit: 65_535
      t.references :post_user
      t.text :post_user_name
      t.references :moderator
      t.integer :moderation_state, null: false
      t.integer :previous_moderation_state, null: false
      t.timestamp :created_at, null: false
      t.index [:messageboard_id, :created_at],
              order: { created_at: :desc },
              name:  :index_thredded_moderation_records_for_display
    end

    create_table :thredded_notifications_for_private_topics do |t|
      t.integer :user_id, null: false
      t.string :notifier_key, null: false, limit: 90
      t.boolean :enabled, default: true, null: false
      t.index [:user_id, :notifier_key],
              name: 'thredded_notifications_for_private_topics_unique', unique: true
    end
    create_table :thredded_notifications_for_followed_topics do |t|
      t.integer :user_id, null: false
      t.string :notifier_key, null: false, limit: 90
      t.boolean :enabled, default: true, null: false
      t.index [:user_id, :notifier_key],
              name: 'thredded_notifications_for_followed_topics_unique', unique: true
    end
    create_table :thredded_messageboard_notifications_for_followed_topics do |t|
      t.integer :user_id, null: false
      t.integer :messageboard_id, null: false
      t.string :notifier_key, null: false, limit: 90
      t.boolean :enabled, default: true, null: false
      t.index [:user_id, :messageboard_id, :notifier_key],
              name: 'thredded_messageboard_notifications_for_followed_topics_unique', unique: true
    end
  end
end
# rubocop:enable Metrics/MethodLength
# rubocop:enable Metrics/ClassLength