class CreateSubmissions < ActiveRecord::Migration[4.2]
  def self.up
    create_table :submissions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
      t.column :user_id, :integer
      t.column :problem_id, :integer
      t.column :language_id, :integer
      t.column :source, :text
      t.column :binary, :binary
      t.column :submitted_at, :datetime
      t.column :compiled_at, :datetime
      t.column :compiler_message, :text
      t.column :graded_at, :datetime
      t.column :points, :integer
      t.column :grader_comment, :text
    end
  end

  def self.down
    drop_table :submissions
  end
end