diff --git a/db/migrate/003_create_submissions.rb b/db/migrate/003_create_submissions.rb new file mode 100644 --- /dev/null +++ b/db/migrate/003_create_submissions.rb @@ -0,0 +1,21 @@ +class CreateSubmissions < ActiveRecord::Migration + def self.up + create_table :submissions 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