cafe-grader-web

Commit r844:509b8db382d4 public

parent | child
Description:
merge
Commit status:
[Not Reviewed]
References:
algo
Diff options:
Raw Diff | Patch Diff | Download Diff | Show 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

r844:509b8db382d4 - - 1 file changed: 2 inserted, 1 deleted

Show file before | Show file after | Raw diff | Download diff | Show whitespace Increase context Show commentsHide comments
@@ -1,61 +1,61
1 1 # This file is auto-generated from the current state of the database. Instead
2 2 # of editing this file, please use the migrations feature of Active Record to
3 3 # incrementally modify your database, and then regenerate this schema definition.
4 4 #
5 5 # Note that this schema.rb definition is the authoritative source for your
6 6 # database schema. If you need to create the application database on another
7 7 # system, you should be using db:schema:load, not running all the migrations
8 8 # from scratch. The latter is a flawed and unsustainable approach (the more migrations
9 9 # you'll amass, the slower it'll run and the greater likelihood for issues).
10 10 #
11 11 # It's strongly recommended that you check this file into your version control system.
12 12
13 - ActiveRecord::Schema.define(version: 2021_01_30_121812) do
13 + ActiveRecord::Schema.define(version: 2021_08_09_105935) do
14 14
15 15 create_table "announcements", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
16 16 t.string "author"
17 17 t.text "body"
18 18 t.boolean "published"
19 19 t.datetime "created_at", null: false
20 20 t.datetime "updated_at", null: false
21 21 t.boolean "frontpage", default: false
22 22 t.boolean "contest_only", default: false
23 23 t.string "title"
24 24 t.string "notes"
25 25 t.boolean "on_nav_bar", default: false
26 26 end
27 27
28 28 create_table "contests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
29 29 t.string "title"
30 30 t.boolean "enabled"
31 31 t.datetime "created_at", null: false
32 32 t.datetime "updated_at", null: false
33 33 t.string "name"
34 34 end
35 35
36 36 create_table "contests_problems", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
37 37 t.integer "contest_id"
38 38 t.integer "problem_id"
39 39 end
40 40
41 41 create_table "contests_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
42 42 t.integer "contest_id"
43 43 t.integer "user_id"
44 44 end
45 45
46 46 create_table "countries", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
47 47 t.string "name"
48 48 t.datetime "created_at", null: false
49 49 t.datetime "updated_at", null: false
50 50 end
51 51
52 52 create_table "descriptions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
53 53 t.text "body"
54 54 t.boolean "markdowned"
55 55 t.datetime "created_at", null: false
56 56 t.datetime "updated_at", null: false
57 57 end
58 58
59 59 create_table "grader_configurations", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
60 60 t.string "key"
61 61 t.string "value_type"
@@ -190,96 +190,97
190 190 t.datetime "updated_at", null: false
191 191 t.integer "country_id"
192 192 t.string "password"
193 193 end
194 194
195 195 create_table "submission_view_logs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
196 196 t.integer "user_id"
197 197 t.integer "submission_id"
198 198 t.datetime "created_at", null: false
199 199 t.datetime "updated_at", null: false
200 200 end
201 201
202 202 create_table "submissions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
203 203 t.integer "user_id"
204 204 t.integer "problem_id"
205 205 t.integer "language_id"
206 206 t.text "source", limit: 16777215
207 207 t.binary "binary"
208 208 t.datetime "submitted_at"
209 209 t.datetime "compiled_at"
210 210 t.text "compiler_message"
211 211 t.datetime "graded_at"
212 212 t.integer "points"
213 213 t.text "grader_comment"
214 214 t.integer "number"
215 215 t.string "source_filename"
216 216 t.float "max_runtime"
217 217 t.integer "peak_memory"
218 218 t.integer "effective_code_length"
219 219 t.string "ip_address"
220 220 t.index ["submitted_at"], name: "index_submissions_on_submitted_at"
221 221 t.index ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true
222 222 t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id"
223 223 end
224 224
225 225 create_table "tags", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
226 226 t.string "name", null: false
227 227 t.text "description"
228 228 t.boolean "public"
229 229 t.datetime "created_at", null: false
230 230 t.datetime "updated_at", null: false
231 231 end
232 232
233 233 create_table "tasks", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
234 234 t.integer "submission_id"
235 235 t.datetime "created_at"
236 236 t.integer "status"
237 237 t.datetime "updated_at"
238 + t.index ["status"], name: "index_tasks_on_status"
238 239 t.index ["submission_id"], name: "index_tasks_on_submission_id"
239 240 end
240 241
241 242 create_table "test_pairs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
242 243 t.integer "problem_id"
243 244 t.text "input", limit: 16777215
244 245 t.text "solution", limit: 16777215
245 246 t.datetime "created_at", null: false
246 247 t.datetime "updated_at", null: false
247 248 end
248 249
249 250 create_table "test_requests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
250 251 t.integer "user_id"
251 252 t.integer "problem_id"
252 253 t.integer "submission_id"
253 254 t.string "input_file_name"
254 255 t.string "output_file_name"
255 256 t.string "running_stat"
256 257 t.integer "status"
257 258 t.datetime "updated_at", null: false
258 259 t.datetime "submitted_at"
259 260 t.datetime "compiled_at"
260 261 t.text "compiler_message"
261 262 t.datetime "graded_at"
262 263 t.string "grader_comment"
263 264 t.datetime "created_at", null: false
264 265 t.float "running_time"
265 266 t.string "exit_status"
266 267 t.integer "memory_usage"
267 268 t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id"
268 269 end
269 270
270 271 create_table "testcases", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
271 272 t.integer "problem_id"
272 273 t.integer "num"
273 274 t.integer "group"
274 275 t.integer "score"
275 276 t.text "input", limit: 4294967295
276 277 t.text "sol", limit: 4294967295
277 278 t.datetime "created_at"
278 279 t.datetime "updated_at"
279 280 t.index ["problem_id"], name: "index_testcases_on_problem_id"
280 281 end
281 282
282 283 create_table "user_contest_stats", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci", force: :cascade do |t|
283 284 t.integer "user_id"
284 285 t.datetime "started_at"
285 286 t.datetime "created_at", null: false
You need to be logged in to leave comments. Login now