cafe-grader-web

Commit r380:894c9826b6b5 public

parent | child
Description:
updated db/schema.rb to remove unused fields incorrected added from the code jom branch
Commit status:
[Not Reviewed]
References:
default
Diff options:
Raw Diff | Patch Diff | Download Diff | Ignore whitespace | Increase context
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Side by Side Unified
Expand All Files Collapse All Files Wide Mode Diff
Add another comment
Browse Files

r380:894c9826b6b5 - - 1 file changed: 35 inserted, 73 deleted

Show file before | Show file after | Raw diff | Download diff | Ignore whitespace Increase context Show commentsHide comments
@@ -17,27 +17,19
17 t.string "author"
17 t.string "author"
18 t.text "body"
18 t.text "body"
19 t.boolean "published"
19 t.boolean "published"
20 - t.datetime "created_at"
20 + t.datetime "created_at", :null => false
21 - t.datetime "updated_at"
21 + t.datetime "updated_at", :null => false
22 t.boolean "frontpage", :default => false
22 t.boolean "frontpage", :default => false
23 t.boolean "contest_only", :default => false
23 t.boolean "contest_only", :default => false
24 t.string "title"
24 t.string "title"
25 t.string "notes"
25 t.string "notes"
26 end
26 end
27
27
28 - create_table "codejom_statuses", :force => true do |t|
29 - t.integer "user_id"
30 - t.boolean "alive"
31 - t.integer "num_problems_passed"
32 - t.datetime "created_at"
33 - t.datetime "updated_at"
34 - end
35 -
36 create_table "contests", :force => true do |t|
28 create_table "contests", :force => true do |t|
37 t.string "title"
29 t.string "title"
38 t.boolean "enabled"
30 t.boolean "enabled"
39 - t.datetime "created_at"
31 + t.datetime "created_at", :null => false
40 - t.datetime "updated_at"
32 + t.datetime "updated_at", :null => false
41 t.string "name"
33 t.string "name"
42 end
34 end
43
35
@@ -53,23 +45,23
53
45
54 create_table "countries", :force => true do |t|
46 create_table "countries", :force => true do |t|
55 t.string "name"
47 t.string "name"
56 - t.datetime "created_at"
48 + t.datetime "created_at", :null => false
57 - t.datetime "updated_at"
49 + t.datetime "updated_at", :null => false
58 end
50 end
59
51
60 create_table "descriptions", :force => true do |t|
52 create_table "descriptions", :force => true do |t|
61 t.text "body"
53 t.text "body"
62 t.boolean "markdowned"
54 t.boolean "markdowned"
63 - t.datetime "created_at"
55 + t.datetime "created_at", :null => false
64 - t.datetime "updated_at"
56 + t.datetime "updated_at", :null => false
65 end
57 end
66
58
67 create_table "grader_configurations", :force => true do |t|
59 create_table "grader_configurations", :force => true do |t|
68 t.string "key"
60 t.string "key"
69 t.string "value_type"
61 t.string "value_type"
70 t.string "value"
62 t.string "value"
71 - t.datetime "created_at"
63 + t.datetime "created_at", :null => false
72 - t.datetime "updated_at"
64 + t.datetime "updated_at", :null => false
73 t.text "description"
65 t.text "description"
74 end
66 end
75
67
@@ -78,8 +70,8
78 t.integer "pid"
70 t.integer "pid"
79 t.string "mode"
71 t.string "mode"
80 t.boolean "active"
72 t.boolean "active"
81 - t.datetime "created_at"
73 + t.datetime "created_at", :null => false
82 - t.datetime "updated_at"
74 + t.datetime "updated_at", :null => false
83 t.integer "task_id"
75 t.integer "task_id"
84 t.string "task_type"
76 t.string "task_type"
85 t.boolean "terminated"
77 t.boolean "terminated"
@@ -100,23 +92,21
100 t.integer "replying_message_id"
92 t.integer "replying_message_id"
101 t.text "body"
93 t.text "body"
102 t.boolean "replied"
94 t.boolean "replied"
103 - t.datetime "created_at"
95 + t.datetime "created_at", :null => false
104 - t.datetime "updated_at"
96 + t.datetime "updated_at", :null => false
105 end
97 end
106
98
107 create_table "problems", :force => true do |t|
99 create_table "problems", :force => true do |t|
108 - t.string "name", :limit => 30
100 + t.string "name", :limit => 30
109 - t.string "full_name"
101 + t.string "full_name"
110 - t.integer "full_score"
102 + t.integer "full_score"
111 - t.date "date_added"
103 + t.date "date_added"
112 - t.boolean "available"
104 + t.boolean "available"
113 - t.string "url"
105 + t.string "url"
114 - t.integer "description_id"
106 + t.integer "description_id"
115 - t.boolean "test_allowed"
107 + t.boolean "test_allowed"
116 - t.boolean "output_only"
108 + t.boolean "output_only"
117 - t.integer "level", :default => 0
109 + t.string "description_filename"
118 - t.datetime "updated_at"
119 - t.string "description_filename"
120 end
110 end
121
111
122 create_table "rights", :force => true do |t|
112 create_table "rights", :force => true do |t|
@@ -156,21 +146,12
156 t.string "name"
146 t.string "name"
157 t.boolean "started"
147 t.boolean "started"
158 t.datetime "start_time"
148 t.datetime "start_time"
159 - t.datetime "created_at"
149 + t.datetime "created_at", :null => false
160 - t.datetime "updated_at"
150 + t.datetime "updated_at", :null => false
161 t.integer "country_id"
151 t.integer "country_id"
162 t.string "password"
152 t.string "password"
163 end
153 end
164
154
165 - create_table "submission_statuses", :force => true do |t|
166 - t.integer "user_id"
167 - t.integer "problem_id"
168 - t.boolean "passed"
169 - t.integer "submission_count"
170 - t.datetime "created_at"
171 - t.datetime "updated_at"
172 - end
173 -
174 create_table "submissions", :force => true do |t|
155 create_table "submissions", :force => true do |t|
175 t.integer "user_id"
156 t.integer "user_id"
176 t.integer "problem_id"
157 t.integer "problem_id"
@@ -197,24 +178,12
197 t.datetime "updated_at"
178 t.datetime "updated_at"
198 end
179 end
199
180
200 - create_table "test_pair_assignments", :force => true do |t|
201 - t.integer "user_id"
202 - t.integer "problem_id"
203 - t.integer "test_pair_id"
204 - t.integer "test_pair_number"
205 - t.integer "request_number"
206 - t.datetime "created_at"
207 - t.datetime "updated_at"
208 - t.boolean "submitted"
209 - end
210 -
211 create_table "test_pairs", :force => true do |t|
181 create_table "test_pairs", :force => true do |t|
212 t.integer "problem_id"
182 t.integer "problem_id"
213 t.text "input", :limit => 16777215
183 t.text "input", :limit => 16777215
214 t.text "solution", :limit => 16777215
184 t.text "solution", :limit => 16777215
215 - t.datetime "created_at"
185 + t.datetime "created_at", :null => false
216 - t.datetime "updated_at"
186 + t.datetime "updated_at", :null => false
217 - t.integer "number"
218 end
187 end
219
188
220 create_table "test_requests", :force => true do |t|
189 create_table "test_requests", :force => true do |t|
@@ -225,13 +194,13
225 t.string "output_file_name"
194 t.string "output_file_name"
226 t.string "running_stat"
195 t.string "running_stat"
227 t.integer "status"
196 t.integer "status"
228 - t.datetime "updated_at"
197 + t.datetime "updated_at", :null => false
229 t.datetime "submitted_at"
198 t.datetime "submitted_at"
230 t.datetime "compiled_at"
199 t.datetime "compiled_at"
231 t.text "compiler_message"
200 t.text "compiler_message"
232 t.datetime "graded_at"
201 t.datetime "graded_at"
233 t.string "grader_comment"
202 t.string "grader_comment"
234 - t.datetime "created_at"
203 + t.datetime "created_at", :null => false
235 t.float "running_time"
204 t.float "running_time"
236 t.string "exit_status"
205 t.string "exit_status"
237 t.integer "memory_usage"
206 t.integer "memory_usage"
@@ -242,30 +211,23
242 create_table "user_contest_stats", :force => true do |t|
211 create_table "user_contest_stats", :force => true do |t|
243 t.integer "user_id"
212 t.integer "user_id"
244 t.datetime "started_at"
213 t.datetime "started_at"
245 - t.datetime "created_at"
214 + t.datetime "created_at", :null => false
246 - t.datetime "updated_at"
215 + t.datetime "updated_at", :null => false
247 t.boolean "forced_logout"
216 t.boolean "forced_logout"
248 end
217 end
249
218
250 create_table "users", :force => true do |t|
219 create_table "users", :force => true do |t|
251 - t.string "login", :limit => 50
220 + t.string "login", :limit => 50
252 t.string "full_name"
221 t.string "full_name"
253 t.string "hashed_password"
222 t.string "hashed_password"
254 - t.string "salt", :limit => 5
223 + t.string "salt", :limit => 5
255 t.string "alias"
224 t.string "alias"
256 t.string "email"
225 t.string "email"
257 t.integer "site_id"
226 t.integer "site_id"
258 t.integer "country_id"
227 t.integer "country_id"
259 - t.boolean "activated", :default => false
228 + t.boolean "activated", :default => false
260 t.datetime "created_at"
229 t.datetime "created_at"
261 t.datetime "updated_at"
230 t.datetime "updated_at"
262 - t.string "member1_full_name"
263 - t.string "member2_full_name"
264 - t.string "member3_full_name"
265 - t.boolean "high_school"
266 - t.string "member1_school_name"
267 - t.string "member2_school_name"
268 - t.string "member3_school_name"
269 end
231 end
270
232
271 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
233 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
You need to be logged in to leave comments. Login now