class <%= migration_class_name %> < ActiveRecord::Migration[<%= ActiveRecord::Migration.current_version %>]
  def self.up
    create_table :motor_queries, force: true do |t|
      t.column :name, :string, null: false
      t.column :description, :string
      t.column :sql_body, :string, null: false
      t.column :preferences, :string, null: false, default: '{}'
      t.column :author_id, :integer
      t.column :author_type, :string
      t.column :deleted_at, :datetime

      t.timestamps

      t.index :updated_at
      t.index 'lower(name)',
              name: 'motor_queries_lower_name_unique_index',
              unique: true,
              where: 'deleted_at IS NULL'
    end

    create_table :motor_dashboards, force: true do |t|
      t.column :title, :string, null: false
      t.column :description, :string
      t.column :preferences, :string, null: false, default: '{}'
      t.column :author_id, :integer
      t.column :author_type, :string
      t.column :deleted_at, :datetime

      t.timestamps

      t.index :updated_at
      t.index 'lower(title)',
              name: 'motor_dashboards_lower_title_unique_index',
              unique: true,
              where: 'deleted_at IS NULL'
    end

    create_table :motor_forms, force: true do |t|
      t.column :name, :string, null: false
      t.column :description, :string
      t.column :api_path, :string, null: false
      t.column :http_method, :string, null: false
      t.column :preferences, :string, null: false, default: '{}'
      t.column :author_id, :integer
      t.column :author_type, :string
      t.column :deleted_at, :datetime

      t.timestamps

      t.index :updated_at
      t.index 'lower(name)',
              name: 'motor_forms_lower_name_unique_index',
              unique: true,
              where: 'deleted_at IS NULL'
    end

    create_table :motor_resources, force: true do |t|
      t.column :name, :string, null: false, index: { unique: true }
      t.column :preferences, :string, null: false, default: '{}'

      t.timestamps

      t.index :updated_at
    end

    create_table :motor_configs, force: true do |t|
      t.column :key, :string, null: false, index: { unique: true }
      t.column :value, :string, null: false, default: '{}'

      t.timestamps

      t.index :updated_at
    end

    create_table :motor_alerts, force: true do |t|
      t.references :query, null: false, foreign_key: { to_table: :motor_queries }, index: true
      t.column :name, :string, null: false
      t.column :description, :string
      t.column :to_emails, :string, null: false
      t.column :is_enabled, :boolean, null: false, default: true
      t.column :preferences, :string, null: false, default: '{}'
      t.column :author_id, :integer
      t.column :author_type, :string
      t.column :deleted_at, :datetime

      t.timestamps

      t.index :updated_at
      t.index 'lower(name)',
              name: 'motor_alerts_lower_name_unique_index',
              unique: true,
              where: 'deleted_at IS NULL'
    end

    create_table :motor_alert_locks, force: true do |t|
      t.references :alert, null: false, foreign_key: { to_table: :motor_alerts }
      t.column :lock_timestamp, :string, null: false

      t.timestamps

      t.index %i[alert_id lock_timestamp], unique: true
    end

    create_table :motor_tags, force: true do |t|
      t.column :name, :string, null: false

      t.timestamps

      t.index 'lower(name)',
              name: 'motor_tags_lower_name_unique_index',
              unique: true
    end

    create_table :motor_taggable_tags, force: true do |t|
      t.references :tag, null: false, foreign_key: { to_table: :motor_tags }, index: true
      t.column :taggable_id, :integer, null: false
      t.column :taggable_type, :string, null: false

      t.index %i[taggable_id taggable_type tag_id],
              name: 'motor_polymorphic_association_tag_index',
              unique: true
    end

    create_table :motor_audits, force: true do |t|
      t.column :auditable_id, :integer
      t.column :auditable_type, :string
      t.column :associated_id, :integer
      t.column :associated_type, :string
      t.column :user_id, :integer
      t.column :user_type, :string
      t.column :username, :string
      t.column :action, :string
      t.column :audited_changes, :text
      t.column :version, :integer, default: 0
      t.column :comment, :string
      t.column :remote_address, :string
      t.column :request_uuid, :string
      t.column :created_at, :datetime
    end

    add_index :motor_audits, %i[auditable_type auditable_id version], name: 'motor_auditable_index'
    add_index :motor_audits, %i[associated_type associated_id], name: 'motor_auditable_associated_index'
    add_index :motor_audits, %i[user_id user_type], name: 'motor_auditable_user_index'
    add_index :motor_audits, :request_uuid
    add_index :motor_audits, :created_at
  end

  def self.down
    drop_table :motor_audits
    drop_table :motor_alert_locks
    drop_table :motor_alerts
    drop_table :motor_taggable_tags
    drop_table :motor_tags
    drop_table :motor_resources
    drop_table :motor_configs
    drop_table :motor_queries
    drop_table :motor_dashboards
  end
end