cafe-grader-web

Commit r862:0df5f90eea20 public

parent | child
Description:
utf8mb4
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

r862:0df5f90eea20 - - 1 file changed: 63 inserted, 63 deleted

Show file before | Show file after | Raw diff | Download diff | Ignore whitespace Increase context Show commentsHide comments
@@ -12,12 +12,12
12
12
13 ActiveRecord::Schema.define(version: 2022_02_04_080936) do
13 ActiveRecord::Schema.define(version: 2022_02_04_080936) do
14
14
15 - create_table "announcements", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
15 + create_table "announcements", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
16 t.string "author"
16 t.string "author"
17 t.text "body"
17 t.text "body"
18 t.boolean "published"
18 t.boolean "published"
19 - t.datetime "created_at", null: false
19 + t.datetime "created_at"
20 - t.datetime "updated_at", null: false
20 + t.datetime "updated_at"
21 t.boolean "frontpage", default: false
21 t.boolean "frontpage", default: false
22 t.boolean "contest_only", default: false
22 t.boolean "contest_only", default: false
23 t.string "title"
23 t.string "title"
@@ -25,112 +25,112
25 t.boolean "on_nav_bar", default: false
25 t.boolean "on_nav_bar", default: false
26 end
26 end
27
27
28 - create_table "contests", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
28 + create_table "contests", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
29 t.string "title"
29 t.string "title"
30 t.boolean "enabled"
30 t.boolean "enabled"
31 - t.datetime "created_at", null: false
31 + t.datetime "created_at"
32 - t.datetime "updated_at", null: false
32 + t.datetime "updated_at"
33 t.string "name"
33 t.string "name"
34 end
34 end
35
35
36 - create_table "contests_problems", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
36 + create_table "contests_problems", id: false, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
37 t.integer "contest_id"
37 t.integer "contest_id"
38 t.integer "problem_id"
38 t.integer "problem_id"
39 end
39 end
40
40
41 - create_table "contests_users", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
41 + create_table "contests_users", id: false, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
42 t.integer "contest_id"
42 t.integer "contest_id"
43 t.integer "user_id"
43 t.integer "user_id"
44 end
44 end
45
45
46 - create_table "countries", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
46 + create_table "countries", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
47 t.string "name"
47 t.string "name"
48 - t.datetime "created_at", null: false
48 + t.datetime "created_at"
49 - t.datetime "updated_at", null: false
49 + t.datetime "updated_at"
50 end
50 end
51
51
52 - create_table "descriptions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
52 + create_table "descriptions", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
53 t.text "body"
53 t.text "body"
54 t.boolean "markdowned"
54 t.boolean "markdowned"
55 - t.datetime "created_at", null: false
55 + t.datetime "created_at"
56 - t.datetime "updated_at", null: false
56 + t.datetime "updated_at"
57 end
57 end
58
58
59 - create_table "grader_configurations", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
59 + create_table "grader_configurations", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
60 t.string "key"
60 t.string "key"
61 t.string "value_type"
61 t.string "value_type"
62 t.string "value"
62 t.string "value"
63 - t.datetime "created_at", null: false
63 + t.datetime "created_at"
64 - t.datetime "updated_at", null: false
64 + t.datetime "updated_at"
65 t.text "description"
65 t.text "description"
66 end
66 end
67
67
68 - create_table "grader_processes", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
68 + create_table "grader_processes", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
69 t.string "host"
69 t.string "host"
70 t.integer "pid"
70 t.integer "pid"
71 t.string "mode"
71 t.string "mode"
72 t.boolean "active"
72 t.boolean "active"
73 - t.datetime "created_at", null: false
73 + t.datetime "created_at"
74 - t.datetime "updated_at", null: false
74 + t.datetime "updated_at"
75 t.integer "task_id"
75 t.integer "task_id"
76 t.string "task_type"
76 t.string "task_type"
77 t.boolean "terminated"
77 t.boolean "terminated"
78 - t.index ["host", "pid"], name: "index_grader_processes_on_ip_and_pid"
78 + t.index ["host", "pid"], name: "index_grader_processes_on_host_and_pid"
79 end
79 end
80
80
81 - create_table "groups", id: :integer, charset: "latin1", force: :cascade do |t|
81 + create_table "groups", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
82 t.string "name"
82 t.string "name"
83 t.string "description"
83 t.string "description"
84 t.boolean "enabled", default: true
84 t.boolean "enabled", default: true
85 end
85 end
86
86
87 - create_table "groups_problems", id: false, charset: "latin1", force: :cascade do |t|
87 + create_table "groups_problems", id: false, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
88 t.integer "problem_id", null: false
88 t.integer "problem_id", null: false
89 t.integer "group_id", null: false
89 t.integer "group_id", null: false
90 t.index ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id"
90 t.index ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id"
91 end
91 end
92
92
93 - create_table "groups_users", charset: "latin1", force: :cascade do |t|
93 + create_table "groups_users", charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
94 t.integer "group_id", null: false
94 t.integer "group_id", null: false
95 t.integer "user_id", null: false
95 t.integer "user_id", null: false
96 t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id"
96 t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id"
97 end
97 end
98
98
99 - create_table "heart_beats", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
99 + create_table "heart_beats", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
100 t.integer "user_id"
100 t.integer "user_id"
101 t.string "ip_address"
101 t.string "ip_address"
102 - t.datetime "created_at", null: false
102 + t.datetime "created_at"
103 - t.datetime "updated_at", null: false
103 + t.datetime "updated_at"
104 t.string "status"
104 t.string "status"
105 t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
105 t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
106 end
106 end
107
107
108 - create_table "languages", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
108 + create_table "languages", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
109 t.string "name", limit: 10
109 t.string "name", limit: 10
110 t.string "pretty_name"
110 t.string "pretty_name"
111 t.string "ext", limit: 10
111 t.string "ext", limit: 10
112 t.string "common_ext"
112 t.string "common_ext"
113 end
113 end
114
114
115 - create_table "logins", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
115 + create_table "logins", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
116 t.integer "user_id"
116 t.integer "user_id"
117 t.string "ip_address"
117 t.string "ip_address"
118 - t.datetime "created_at", null: false
118 + t.datetime "created_at"
119 - t.datetime "updated_at", null: false
119 + t.datetime "updated_at"
120 t.index ["user_id"], name: "index_logins_on_user_id"
120 t.index ["user_id"], name: "index_logins_on_user_id"
121 end
121 end
122
122
123 - create_table "messages", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
123 + create_table "messages", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
124 t.integer "sender_id"
124 t.integer "sender_id"
125 t.integer "receiver_id"
125 t.integer "receiver_id"
126 t.integer "replying_message_id"
126 t.integer "replying_message_id"
127 t.text "body"
127 t.text "body"
128 t.boolean "replied"
128 t.boolean "replied"
129 - t.datetime "created_at", null: false
129 + t.datetime "created_at"
130 - t.datetime "updated_at", null: false
130 + t.datetime "updated_at"
131 end
131 end
132
132
133 - create_table "problems", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
133 + create_table "problems", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
134 t.string "name", limit: 30
134 t.string "name", limit: 30
135 t.string "full_name"
135 t.string "full_name"
136 t.integer "full_score"
136 t.integer "full_score"
@@ -145,7 +145,7
145 t.integer "difficulty"
145 t.integer "difficulty"
146 end
146 end
147
147
148 - create_table "problems_tags", id: :integer, charset: "latin1", force: :cascade do |t|
148 + create_table "problems_tags", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
149 t.integer "problem_id"
149 t.integer "problem_id"
150 t.integer "tag_id"
150 t.integer "tag_id"
151 t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true
151 t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true
@@ -153,29 +153,29
153 t.index ["tag_id"], name: "index_problems_tags_on_tag_id"
153 t.index ["tag_id"], name: "index_problems_tags_on_tag_id"
154 end
154 end
155
155
156 - create_table "rights", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
156 + create_table "rights", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
157 t.string "name"
157 t.string "name"
158 t.string "controller"
158 t.string "controller"
159 t.string "action"
159 t.string "action"
160 end
160 end
161
161
162 - create_table "rights_roles", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
162 + create_table "rights_roles", id: false, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
163 t.integer "right_id"
163 t.integer "right_id"
164 t.integer "role_id"
164 t.integer "role_id"
165 t.index ["role_id"], name: "index_rights_roles_on_role_id"
165 t.index ["role_id"], name: "index_rights_roles_on_role_id"
166 end
166 end
167
167
168 - create_table "roles", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
168 + create_table "roles", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
169 t.string "name"
169 t.string "name"
170 end
170 end
171
171
172 - create_table "roles_users", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
172 + create_table "roles_users", id: false, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
173 t.integer "role_id"
173 t.integer "role_id"
174 t.integer "user_id"
174 t.integer "user_id"
175 t.index ["user_id"], name: "index_roles_users_on_user_id"
175 t.index ["user_id"], name: "index_roles_users_on_user_id"
176 end
176 end
177
177
178 - create_table "sessions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
178 + create_table "sessions", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
179 t.string "session_id"
179 t.string "session_id"
180 t.text "data"
180 t.text "data"
181 t.datetime "updated_at"
181 t.datetime "updated_at"
@@ -183,24 +183,24
183 t.index ["updated_at"], name: "index_sessions_on_updated_at"
183 t.index ["updated_at"], name: "index_sessions_on_updated_at"
184 end
184 end
185
185
186 - create_table "sites", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
186 + create_table "sites", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
187 t.string "name"
187 t.string "name"
188 t.boolean "started"
188 t.boolean "started"
189 t.datetime "start_time"
189 t.datetime "start_time"
190 - t.datetime "created_at", null: false
190 + t.datetime "created_at"
191 - t.datetime "updated_at", null: false
191 + t.datetime "updated_at"
192 t.integer "country_id"
192 t.integer "country_id"
193 t.string "password"
193 t.string "password"
194 end
194 end
195
195
196 - create_table "submission_view_logs", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
196 + create_table "submission_view_logs", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
197 t.integer "user_id"
197 t.integer "user_id"
198 t.integer "submission_id"
198 t.integer "submission_id"
199 - t.datetime "created_at", null: false
199 + t.datetime "created_at"
200 - t.datetime "updated_at", null: false
200 + t.datetime "updated_at"
201 end
201 end
202
202
203 - create_table "submissions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
203 + create_table "submissions", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
204 t.integer "user_id"
204 t.integer "user_id"
205 t.integer "problem_id"
205 t.integer "problem_id"
206 t.integer "language_id"
206 t.integer "language_id"
@@ -224,7 +224,7
224 t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id"
224 t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id"
225 end
225 end
226
226
227 - create_table "tags", id: :integer, charset: "latin1", force: :cascade do |t|
227 + create_table "tags", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
228 t.string "name", null: false
228 t.string "name", null: false
229 t.text "description"
229 t.text "description"
230 t.boolean "public"
230 t.boolean "public"
@@ -232,7 +232,7
232 t.datetime "updated_at", null: false
232 t.datetime "updated_at", null: false
233 end
233 end
234
234
235 - create_table "tasks", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
235 + create_table "tasks", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
236 t.integer "submission_id"
236 t.integer "submission_id"
237 t.datetime "created_at"
237 t.datetime "created_at"
238 t.integer "status"
238 t.integer "status"
@@ -241,15 +241,15
241 t.index ["submission_id"], name: "index_tasks_on_submission_id"
241 t.index ["submission_id"], name: "index_tasks_on_submission_id"
242 end
242 end
243
243
244 - create_table "test_pairs", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
244 + create_table "test_pairs", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
245 t.integer "problem_id"
245 t.integer "problem_id"
246 t.text "input", size: :medium
246 t.text "input", size: :medium
247 t.text "solution", size: :medium
247 t.text "solution", size: :medium
248 - t.datetime "created_at", null: false
248 + t.datetime "created_at"
249 - t.datetime "updated_at", null: false
249 + t.datetime "updated_at"
250 end
250 end
251
251
252 - create_table "test_requests", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
252 + create_table "test_requests", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
253 t.integer "user_id"
253 t.integer "user_id"
254 t.integer "problem_id"
254 t.integer "problem_id"
255 t.integer "submission_id"
255 t.integer "submission_id"
@@ -257,20 +257,20
257 t.string "output_file_name"
257 t.string "output_file_name"
258 t.string "running_stat"
258 t.string "running_stat"
259 t.integer "status"
259 t.integer "status"
260 - t.datetime "updated_at", null: false
261 t.datetime "submitted_at"
260 t.datetime "submitted_at"
262 t.datetime "compiled_at"
261 t.datetime "compiled_at"
263 t.text "compiler_message"
262 t.text "compiler_message"
264 t.datetime "graded_at"
263 t.datetime "graded_at"
265 t.string "grader_comment"
264 t.string "grader_comment"
266 - t.datetime "created_at", null: false
265 + t.datetime "created_at"
266 + t.datetime "updated_at"
267 t.float "running_time"
267 t.float "running_time"
268 t.string "exit_status"
268 t.string "exit_status"
269 t.integer "memory_usage"
269 t.integer "memory_usage"
270 t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id"
270 t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id"
271 end
271 end
272
272
273 - create_table "testcases", id: :integer, charset: "latin1", force: :cascade do |t|
273 + create_table "testcases", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
274 t.integer "problem_id"
274 t.integer "problem_id"
275 t.integer "num"
275 t.integer "num"
276 t.integer "group"
276 t.integer "group"
@@ -282,15 +282,15
282 t.index ["problem_id"], name: "index_testcases_on_problem_id"
282 t.index ["problem_id"], name: "index_testcases_on_problem_id"
283 end
283 end
284
284
285 - create_table "user_contest_stats", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
285 + create_table "user_contest_stats", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
286 t.integer "user_id"
286 t.integer "user_id"
287 - t.datetime "started_at"
287 + t.timestamp "started_at"
288 - t.datetime "created_at", null: false
288 + t.datetime "created_at"
289 - t.datetime "updated_at", null: false
289 + t.datetime "updated_at"
290 t.boolean "forced_logout"
290 t.boolean "forced_logout"
291 end
291 end
292
292
293 - create_table "users", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
293 + create_table "users", id: :integer, charset: "utf8mb4", collation: "utf8mb4_unicode_ci", force: :cascade do |t|
294 t.string "login", limit: 50
294 t.string "login", limit: 50
295 t.string "full_name"
295 t.string "full_name"
296 t.string "hashed_password"
296 t.string "hashed_password"
@@ -302,10 +302,10
302 t.boolean "activated", default: false
302 t.boolean "activated", default: false
303 t.datetime "created_at"
303 t.datetime "created_at"
304 t.datetime "updated_at"
304 t.datetime "updated_at"
305 + t.string "section"
305 t.boolean "enabled", default: true
306 t.boolean "enabled", default: true
306 t.string "remark"
307 t.string "remark"
307 t.string "last_ip"
308 t.string "last_ip"
308 - t.string "section"
309 t.integer "default_language"
309 t.integer "default_language"
310 t.index ["login"], name: "index_users_on_login", unique: true
310 t.index ["login"], name: "index_users_on_login", unique: true
311 end
311 end
You need to be logged in to leave comments. Login now