diff --git a/db/schema.rb b/db/schema.rb
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 # It's strongly recommended that you check this file into your version control system.
 
 ActiveRecord::Schema[7.0].define(version: 2022_09_27_074644) do
-  create_table "active_storage_attachments", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+  create_table "active_storage_attachments", charset: "latin1", force: :cascade do |t|
     t.string "name", null: false
     t.string "record_type", null: false
     t.bigint "record_id", null: false
@@ -21,7 +21,7 @@
     t.index ["record_type", "record_id", "name", "blob_id"], name: "index_active_storage_attachments_uniqueness", unique: true
   end
 
-  create_table "active_storage_blobs", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+  create_table "active_storage_blobs", charset: "latin1", force: :cascade do |t|
     t.string "key", null: false
     t.string "filename", null: false
     t.string "content_type"
@@ -33,15 +33,15 @@
     t.index ["key"], name: "index_active_storage_blobs_on_key", unique: true
   end
 
-  create_table "active_storage_variant_records", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+  create_table "active_storage_variant_records", charset: "latin1", force: :cascade do |t|
     t.bigint "blob_id", null: false
     t.string "variation_digest", null: false
     t.index ["blob_id", "variation_digest"], name: "index_active_storage_variant_records_uniqueness", unique: true
   end
 
-  create_table "announcements", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "announcements", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "author"
-    t.text "body"
+    t.text "body", size: :medium
     t.boolean "published"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
@@ -52,7 +52,7 @@
     t.boolean "on_nav_bar", default: false
   end
 
-  create_table "contests", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "contests", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "title"
     t.boolean "enabled"
     t.datetime "created_at", precision: nil, null: false
@@ -60,39 +60,39 @@
     t.string "name"
   end
 
-  create_table "contests_problems", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "contests_problems", id: false, charset: "utf8", force: :cascade do |t|
     t.integer "contest_id"
     t.integer "problem_id"
   end
 
-  create_table "contests_users", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "contests_users", id: false, charset: "utf8", force: :cascade do |t|
     t.integer "contest_id"
     t.integer "user_id"
   end
 
-  create_table "countries", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "countries", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "name"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "descriptions", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
-    t.text "body"
+  create_table "descriptions", id: :integer, charset: "utf8", force: :cascade do |t|
+    t.text "body", size: :medium
     t.boolean "markdowned"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "grader_configurations", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "grader_configurations", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "key"
     t.string "value_type"
     t.string "value"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
-    t.text "description"
+    t.text "description", size: :medium
   end
 
-  create_table "grader_processes", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "grader_processes", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "host"
     t.integer "pid"
     t.string "mode"
@@ -123,7 +123,7 @@
     t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id"
   end
 
-  create_table "heart_beats", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "heart_beats", id: :integer, charset: "latin1", force: :cascade do |t|
     t.integer "user_id"
     t.string "ip_address"
     t.datetime "created_at", precision: nil, null: false
@@ -132,14 +132,14 @@
     t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
   end
 
-  create_table "languages", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "languages", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "name", limit: 10
     t.string "pretty_name"
     t.string "ext", limit: 10
     t.string "common_ext"
   end
 
-  create_table "logins", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "logins", id: :integer, charset: "latin1", force: :cascade do |t|
     t.integer "user_id"
     t.string "ip_address"
     t.datetime "created_at", precision: nil, null: false
@@ -147,18 +147,18 @@
     t.index ["user_id"], name: "index_logins_on_user_id"
   end
 
-  create_table "messages", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "messages", id: :integer, charset: "utf8", force: :cascade do |t|
     t.integer "sender_id"
     t.integer "receiver_id"
     t.integer "replying_message_id"
-    t.text "body"
+    t.text "body", size: :medium
     t.boolean "replied"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "problems", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
-    t.string "name", limit: 30
+  create_table "problems", id: :bigint, default: nil, charset: "utf8", force: :cascade do |t|
+    t.string "name", limit: 100
     t.string "full_name"
     t.integer "full_score"
     t.date "date_added"
@@ -174,45 +174,45 @@
     t.boolean "markdown"
   end
 
-  create_table "problems_tags", id: :integer, charset: "latin1", force: :cascade do |t|
-    t.integer "problem_id"
+  create_table "problems_tags", id: :bigint, default: nil, charset: "latin1", force: :cascade do |t|
+    t.bigint "problem_id"
     t.integer "tag_id"
     t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true
     t.index ["problem_id"], name: "index_problems_tags_on_problem_id"
     t.index ["tag_id"], name: "index_problems_tags_on_tag_id"
   end
 
-  create_table "rights", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "rights", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "name"
     t.string "controller"
     t.string "action"
   end
 
-  create_table "rights_roles", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "rights_roles", id: false, charset: "utf8", force: :cascade do |t|
     t.integer "right_id"
     t.integer "role_id"
     t.index ["role_id"], name: "index_rights_roles_on_role_id"
   end
 
-  create_table "roles", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "roles", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "name"
   end
 
-  create_table "roles_users", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "roles_users", id: false, charset: "utf8", force: :cascade do |t|
     t.integer "role_id"
     t.integer "user_id"
     t.index ["user_id"], name: "index_roles_users_on_user_id"
   end
 
-  create_table "sessions", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "sessions", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "session_id"
-    t.text "data"
+    t.text "data", size: :medium
     t.datetime "updated_at", precision: nil
     t.index ["session_id"], name: "index_sessions_on_session_id"
     t.index ["updated_at"], name: "index_sessions_on_updated_at"
   end
 
-  create_table "sites", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "sites", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "name"
     t.boolean "started"
     t.datetime "start_time", precision: nil
@@ -222,14 +222,23 @@
     t.string "password"
   end
 
-  create_table "submission_view_logs", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "solutions", charset: "latin1", force: :cascade do |t|
+    t.string "solution"
+    t.bigint "problem_id"
+    t.bigint "submission_id"
+    t.integer "type"
+    t.index ["problem_id"], name: "index_solutions_on_problem_id"
+    t.index ["submission_id"], name: "index_solutions_on_submission_id"
+  end
+
+  create_table "submission_view_logs", id: :integer, charset: "latin1", force: :cascade do |t|
     t.integer "user_id"
     t.integer "submission_id"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "submissions", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "submissions", id: :bigint, default: nil, charset: "utf8", force: :cascade do |t|
     t.integer "user_id"
     t.integer "problem_id"
     t.integer "language_id"
@@ -237,10 +246,10 @@
     t.binary "binary"
     t.datetime "submitted_at", precision: nil
     t.datetime "compiled_at", precision: nil
-    t.text "compiler_message"
+    t.text "compiler_message", size: :medium
     t.datetime "graded_at", precision: nil
     t.integer "points"
-    t.text "grader_comment"
+    t.text "grader_comment", size: :medium
     t.integer "number"
     t.string "source_filename"
     t.float "max_runtime"
@@ -261,7 +270,7 @@
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "tasks", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "tasks", id: :integer, charset: "utf8", force: :cascade do |t|
     t.integer "submission_id"
     t.datetime "created_at", precision: nil
     t.integer "status"
@@ -270,15 +279,15 @@
     t.index ["submission_id"], name: "index_tasks_on_submission_id"
   end
 
-  create_table "test_pairs", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "test_pairs", id: :integer, charset: "utf8", force: :cascade do |t|
     t.integer "problem_id"
-    t.text "input", size: :medium
-    t.text "solution", size: :medium
+    t.text "input", size: :long
+    t.text "solution", size: :long
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
   end
 
-  create_table "test_requests", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "test_requests", id: :integer, charset: "utf8", force: :cascade do |t|
     t.integer "user_id"
     t.integer "problem_id"
     t.integer "submission_id"
@@ -289,7 +298,7 @@
     t.datetime "updated_at", precision: nil, null: false
     t.datetime "submitted_at", precision: nil
     t.datetime "compiled_at", precision: nil
-    t.text "compiler_message"
+    t.text "compiler_message", size: :medium
     t.datetime "graded_at", precision: nil
     t.string "grader_comment"
     t.datetime "created_at", precision: nil, null: false
@@ -306,12 +315,12 @@
     t.integer "score"
     t.text "input", size: :long
     t.text "sol", size: :long
-    t.datetime "created_at", precision: nil
-    t.datetime "updated_at", precision: nil
+    t.datetime "created_at", precision: nil, null: false
+    t.datetime "updated_at", precision: nil, null: false
     t.index ["problem_id"], name: "index_testcases_on_problem_id"
   end
 
-  create_table "user_contest_stats", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "user_contest_stats", id: :integer, charset: "utf8", force: :cascade do |t|
     t.integer "user_id"
     t.datetime "started_at", precision: nil
     t.datetime "created_at", precision: nil, null: false
@@ -319,7 +328,7 @@
     t.boolean "forced_logout"
   end
 
-  create_table "users", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+  create_table "users", id: :integer, charset: "utf8", force: :cascade do |t|
     t.string "login", limit: 50
     t.string "full_name"
     t.string "hashed_password"
@@ -331,10 +340,10 @@
     t.boolean "activated", default: false
     t.datetime "created_at", precision: nil
     t.datetime "updated_at", precision: nil
+    t.string "section"
     t.boolean "enabled", default: true
     t.string "remark"
     t.string "last_ip"
-    t.string "section"
     t.integer "default_language"
     t.index ["login"], name: "index_users_on_login", unique: true
   end
@@ -343,4 +352,6 @@
   add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id"
   add_foreign_key "problems_tags", "problems"
   add_foreign_key "problems_tags", "tags"
+  add_foreign_key "solutions", "problems"
+  add_foreign_key "solutions", "submissions"
 end