Description:
[web] added runstat columns to test_request git-svn-id: http://theory.cpe.ku.ac.th/grader/web/trunk@161 6386c4cd-e34a-4fa8-8920-d93eb39b512e
Commit status:
[Not Reviewed]
References:
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Add another comment

r81:bbc4d8cd0ec5 - - 2 files changed: 17 inserted, 1 deleted

@@ -0,0 +1,13
1 + class AddRunstatColumnsToTestRequest < ActiveRecord::Migration
2 + def self.up
3 + add_column :test_requests, :running_time, :time
4 + add_column :test_requests, :exit_status, :string
5 + add_column :test_requests, :memory_usage, :integer
6 + end
7 +
8 + def self.down
9 + remove_column :test_requests, :running_time
10 + remove_column :test_requests, :exit_status
11 + remove_column :test_requests, :memory_usage
12 + end
13 + end
@@ -1,36 +1,36
1 1 # This file is auto-generated from the current state of the database. Instead of editing this file,
2 2 # please use the migrations feature of ActiveRecord to incrementally modify your database, and
3 3 # then regenerate this schema definition.
4 4 #
5 5 # Note that this schema.rb definition is the authoritative source for your database schema. If you need
6 6 # to create the application database on another system, you should be using db:schema:load, not running
7 7 # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
8 8 # you'll amass, the slower it'll run and the greater likelihood for issues).
9 9 #
10 10 # It's strongly recommended to check this file into your version control system.
11 11
12 - ActiveRecord::Schema.define(:version => 22) do
12 + ActiveRecord::Schema.define(:version => 23) do
13 13
14 14 create_table "configurations", :force => true do |t|
15 15 t.string "key"
16 16 t.string "value_type"
17 17 t.string "value"
18 18 t.datetime "created_at"
19 19 t.datetime "updated_at"
20 20 end
21 21
22 22 create_table "grader_processes", :force => true do |t|
23 23 t.string "host", :limit => 20
24 24 t.integer "pid"
25 25 t.string "mode"
26 26 t.boolean "active"
27 27 t.datetime "created_at"
28 28 t.datetime "updated_at"
29 29 t.integer "task_id"
30 30 end
31 31
32 32 add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid"
33 33
34 34 create_table "languages", :force => true do |t|
35 35 t.string "name", :limit => 10
36 36 t.string "pretty_name"
@@ -98,40 +98,43
98 98 add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id"
99 99
100 100 create_table "tasks", :force => true do |t|
101 101 t.integer "submission_id"
102 102 t.datetime "created_at"
103 103 t.integer "status"
104 104 t.datetime "updated_at"
105 105 end
106 106
107 107 create_table "test_requests", :force => true do |t|
108 108 t.integer "user_id"
109 109 t.integer "problem_id"
110 110 t.integer "submission_id"
111 111 t.string "input_file_name"
112 112 t.string "output_file_name"
113 113 t.string "running_stat"
114 114 t.integer "status"
115 115 t.datetime "updated_at"
116 116 t.datetime "submitted_at"
117 117 t.datetime "compiled_at"
118 118 t.text "compiler_message"
119 119 t.datetime "graded_at"
120 120 t.string "grader_comment"
121 121 t.datetime "created_at"
122 + t.time "running_time"
123 + t.string "exit_status"
124 + t.integer "memory_usage"
122 125 end
123 126
124 127 add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"
125 128
126 129 create_table "users", :force => true do |t|
127 130 t.string "login", :limit => 10
128 131 t.string "full_name"
129 132 t.string "hashed_password"
130 133 t.string "salt", :limit => 5
131 134 t.string "alias"
132 135 t.string "email"
133 136 end
134 137
135 138 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
136 139
137 140 end
You need to be logged in to leave comments. Login now