require "active_record"

I18n.enforce_available_locales = true

ActiveRecord::Base.establish_connection(
  adapter: "sqlite3",
  database: File.expand_path("test_app/db/db.sqlite", File.dirname(__FILE__)),
  verbosity: "quiet"
)

class TestMigration < ActiveRecord::Migration[5.0]
  def self.up
    create_table :posts, force: true do |t|
      t.integer :user_id
      t.column :title, :string
      t.column :image_id, :string
      t.column :document_id, :string
      t.column :document_filename, :string
      t.column :document_content_type, :string
      t.column :document_size, :integer
    end

    create_table :users, force: true

    create_table :documents, force: true do |t|
      t.belongs_to :post, null: false
      t.column :file_id, :string, null: false
      t.column :file_filename, :string
      t.column :file_content_type, :string
      t.column :file_size, :integer, null: false
    end
  end
end

TestMigration.up