cafe-grader-web

Location: cafe-grader-web/db/schema.rb - annotation

Show More
Commit Description:
move datatable to yarn
Commit Description:
move datatable to yarn
References:
r789:8cd7e8db7e38 default
File last commit:
r788:3241620ac7e7 default
Show/Diff file:
Action:
db/schema.rb | 321 lines | 11.3 KiB | text/x-ruby | RubyLexer |
History | Source | Raw | Download
admin
submission stat
 r788 # encoding: UTF-8
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 # This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
jittat
added user settings...
 r13 #
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 # Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
jittat
added user settings...
 r13 # you'll amass, the slower it'll run and the greater likelihood for issues).
#
admin
fix compiler message...
 r621 # It's strongly recommended that you check this file into your version control system.
jittat
added user settings...
 r13
admin
submission stat
 r788 ActiveRecord::Schema.define(version: 20180612102327) do
jittat
[web] added announcement...
 r97
admin
submission stat
 r788 create_table "announcements", force: :cascade do |t|
t.string "author", limit: 255
t.text "body", limit: 65535
t.boolean "published"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.boolean "frontpage", default: false
t.boolean "contest_only", default: false
t.string "title", limit: 255
t.string "notes", limit: 255
jittat
[web] added announcement...
 r97 end
jittat
[web] added configurations...
 r76
admin
submission stat
 r788 create_table "contests", force: :cascade do |t|
t.string "title", limit: 255
t.boolean "enabled"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.string "name", limit: 255
Jittat Fakcharoenphol
added contest model
 r266 end
admin
submission stat
 r788 create_table "contests_problems", id: false, force: :cascade do |t|
t.integer "contest_id", limit: 4
t.integer "problem_id", limit: 4
Jittat Fakcharoenphol
created join tables for contests and users and problems
 r268 end
admin
submission stat
 r788 create_table "contests_users", id: false, force: :cascade do |t|
t.integer "contest_id", limit: 4
t.integer "user_id", limit: 4
Jittat Fakcharoenphol
created join tables for contests and users and problems
 r268 end
admin
submission stat
 r788 create_table "countries", force: :cascade do |t|
t.string "name", limit: 255
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
jittat
[web] import from site...
 r106 end
admin
submission stat
 r788 create_table "descriptions", force: :cascade do |t|
t.text "body", limit: 65535
t.boolean "markdowned"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
jittat
[web] refactor problem description, some styling...
 r92 end
admin
submission stat
 r788 create_table "grader_configurations", force: :cascade do |t|
t.string "key", limit: 255
t.string "value_type", limit: 255
t.string "value", limit: 255
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.text "description", limit: 65535
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 end
admin
submission stat
 r788 create_table "grader_processes", force: :cascade do |t|
t.string "host", limit: 255
t.integer "pid", limit: 4
t.string "mode", limit: 255
t.boolean "active"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.integer "task_id", limit: 4
t.string "task_type", limit: 255
t.boolean "terminated"
jittat
started grader_process...
 r29 end
admin
submission stat
 r788 add_index "grader_processes", ["host", "pid"], name: "index_grader_processes_on_host_and_pid", using: :btree
create_table "groups", force: :cascade do |t|
t.string "name", limit: 255
t.string "description", limit: 255
admin
add problem group
 r672 end
admin
submission stat
 r788 create_table "groups_problems", id: false, force: :cascade do |t|
t.integer "problem_id", limit: 4, null: false
t.integer "group_id", limit: 4, null: false
admin
add problem group
 r672 end
admin
submission stat
 r788 add_index "groups_problems", ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id", using: :btree
create_table "groups_users", id: false, force: :cascade do |t|
t.integer "group_id", limit: 4, null: false
t.integer "user_id", limit: 4, null: false
admin
add problem group
 r672 end
admin
submission stat
 r788 add_index "groups_users", ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id", using: :btree
create_table "heart_beats", force: :cascade do |t|
t.integer "user_id", limit: 4
t.string "ip_address", limit: 255
admin
fix whitelisting bugs...
 r784 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.string "status", limit: 255
admin
add heart_beat...
 r540 end
admin
submission stat
 r788 add_index "heart_beats", ["updated_at"], name: "index_heart_beats_on_updated_at", using: :btree
create_table "languages", force: :cascade do |t|
t.string "name", limit: 10
t.string "pretty_name", limit: 255
t.string "ext", limit: 10
t.string "common_ext", limit: 255
jittat
added user settings...
 r13 end
admin
submission stat
 r788 create_table "logins", force: :cascade do |t|
t.integer "user_id", limit: 4
t.string "ip_address", limit: 255
admin
fix whitelisting bugs...
 r784 t.datetime "created_at"
t.datetime "updated_at"
admin
- more test on user admin and authorization...
 r754 end
admin
submission stat
 r788 create_table "messages", force: :cascade do |t|
t.integer "sender_id", limit: 4
t.integer "receiver_id", limit: 4
t.integer "replying_message_id", limit: 4
t.text "body", limit: 65535
t.boolean "replied"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
add login stat
 r410 end
admin
submission stat
 r788 create_table "problems", force: :cascade do |t|
t.string "name", limit: 30
t.string "full_name", limit: 255
t.integer "full_score", limit: 4
t.date "date_added"
admin
update schema
 r640 t.boolean "available"
admin
submission stat
 r788 t.string "url", limit: 255
t.integer "description_id", limit: 4
admin
update schema
 r640 t.boolean "test_allowed"
t.boolean "output_only"
admin
submission stat
 r788 t.string "description_filename", limit: 255
admin
update schema
 r640 t.boolean "view_testcase"
end
jittat
added user settings...
 r13
admin
submission stat
 r788 create_table "problems_tags", force: :cascade do |t|
t.integer "problem_id", limit: 4
t.integer "tag_id", limit: 4
admin
tag
 r681 end
admin
submission stat
 r788 add_index "problems_tags", ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true, using: :btree
add_index "problems_tags", ["problem_id"], name: "index_problems_tags_on_problem_id", using: :btree
add_index "problems_tags", ["tag_id"], name: "index_problems_tags_on_tag_id", using: :btree
create_table "rights", force: :cascade do |t|
t.string "name", limit: 255
t.string "controller", limit: 255
t.string "action", limit: 255
jittat
added user settings...
 r13 end
admin
submission stat
 r788 create_table "rights_roles", id: false, force: :cascade do |t|
t.integer "right_id", limit: 4
t.integer "role_id", limit: 4
jittat
added user settings...
 r13 end
admin
submission stat
 r788 add_index "rights_roles", ["role_id"], name: "index_rights_roles_on_role_id", using: :btree
create_table "roles", force: :cascade do |t|
t.string "name", limit: 255
jittat
added user settings...
 r13 end
admin
submission stat
 r788 create_table "roles_users", id: false, force: :cascade do |t|
t.integer "role_id", limit: 4
t.integer "user_id", limit: 4
jittat
added user settings...
 r13 end
admin
submission stat
 r788 add_index "roles_users", ["user_id"], name: "index_roles_users_on_user_id", using: :btree
create_table "sessions", force: :cascade do |t|
t.string "session_id", limit: 255
t.text "data", limit: 65535
jittat
added user settings...
 r13 t.datetime "updated_at"
end
admin
submission stat
 r788 add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree
add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree
create_table "sites", force: :cascade do |t|
t.string "name", limit: 255
t.boolean "started"
jittat
[web] added site and time out basic functionality...
 r85 t.datetime "start_time"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.integer "country_id", limit: 4
t.string "password", limit: 255
admin
- more test on user admin and authorization...
 r754 end
admin
submission stat
 r788 create_table "submission_view_logs", force: :cascade do |t|
t.integer "user_id", limit: 4
t.integer "submission_id", limit: 4
admin
fix whitelisting bugs...
 r784 t.datetime "created_at"
t.datetime "updated_at"
jittat
[web] added site and time out basic functionality...
 r85 end
admin
submission stat
 r788 create_table "submissions", force: :cascade do |t|
t.integer "user_id", limit: 4
t.integer "problem_id", limit: 4
t.integer "language_id", limit: 4
t.text "source", limit: 16777215
t.binary "binary", limit: 65535
admin
- more test on user admin and authorization...
 r754 t.datetime "submitted_at"
t.datetime "compiled_at"
admin
submission stat
 r788 t.text "compiler_message", limit: 65535
admin
- more test on user admin and authorization...
 r754 t.datetime "graded_at"
admin
submission stat
 r788 t.integer "points", limit: 4
t.text "grader_comment", limit: 65535
t.integer "number", limit: 4
t.string "source_filename", limit: 255
t.float "max_runtime", limit: 24
t.integer "peak_memory", limit: 4
t.integer "effective_code_length", limit: 4
t.string "ip_address", limit: 255
admin
- more test on user admin and authorization...
 r754 end
admin
submission stat
 r788 add_index "submissions", ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true, using: :btree
add_index "submissions", ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id", using: :btree
create_table "tags", force: :cascade do |t|
t.string "name", limit: 255, null: false
t.text "description", limit: 65535
t.boolean "public"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
admin
- more test on user admin and authorization...
 r754 end
admin
submission stat
 r788 create_table "tasks", force: :cascade do |t|
t.integer "submission_id", limit: 4
admin
- more test on user admin and authorization...
 r754 t.datetime "created_at"
admin
submission stat
 r788 t.integer "status", limit: 4
admin
- more test on user admin and authorization...
 r754 t.datetime "updated_at"
end
admin
submission stat
 r788 add_index "tasks", ["submission_id"], name: "index_tasks_on_submission_id", using: :btree
create_table "test_pairs", force: :cascade do |t|
t.integer "problem_id", limit: 4
t.text "input", limit: 16777215
t.text "solution", limit: 16777215
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
NOT WORKING...
 r528 end
admin
submission stat
 r788 create_table "test_requests", force: :cascade do |t|
t.integer "user_id", limit: 4
t.integer "problem_id", limit: 4
t.integer "submission_id", limit: 4
t.string "input_file_name", limit: 255
t.string "output_file_name", limit: 255
t.string "running_stat", limit: 255
t.integer "status", limit: 4
admin
- more test on user admin and authorization...
 r754 t.datetime "updated_at"
jittat
added user settings...
 r13 t.datetime "submitted_at"
t.datetime "compiled_at"
admin
submission stat
 r788 t.text "compiler_message", limit: 65535
jittat
added user settings...
 r13 t.datetime "graded_at"
admin
submission stat
 r788 t.string "grader_comment", limit: 255
admin
- more test on user admin and authorization...
 r754 t.datetime "created_at"
admin
submission stat
 r788 t.float "running_time", limit: 24
t.string "exit_status", limit: 255
t.integer "memory_usage", limit: 4
jittat
added user settings...
 r13 end
admin
submission stat
 r788 add_index "test_requests", ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id", using: :btree
create_table "testcases", force: :cascade do |t|
t.integer "problem_id", limit: 4
t.integer "num", limit: 4
t.integer "group", limit: 4
t.integer "score", limit: 4
t.text "input", limit: 4294967295
t.text "sol", limit: 4294967295
admin
- more test on user admin and authorization...
 r754 t.datetime "created_at"
t.datetime "updated_at"
admin
tag
 r681 end
admin
submission stat
 r788 add_index "testcases", ["problem_id"], name: "index_testcases_on_problem_id", using: :btree
create_table "user_contest_stats", force: :cascade do |t|
t.integer "user_id", limit: 4
admin
- more test on user admin and authorization...
 r754 t.datetime "started_at"
admin
add rvm version & gemset file,...
 r740 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.boolean "forced_logout"
Jittat Fakcharoenphol
added test_pair model
 r209 end
admin
submission stat
 r788 create_table "users", force: :cascade do |t|
t.string "login", limit: 50
t.string "full_name", limit: 255
t.string "hashed_password", limit: 255
t.string "salt", limit: 5
t.string "alias", limit: 255
t.string "email", limit: 255
t.integer "site_id", limit: 4
t.integer "country_id", limit: 4
t.boolean "activated", default: false
admin
put to master
 r720 t.datetime "created_at"
t.datetime "updated_at"
admin
submission stat
 r788 t.string "section", limit: 255
t.boolean "enabled", default: true
t.string "remark", limit: 255
t.string "last_ip", limit: 255
jittat
added user settings...
 r13 end
admin
submission stat
 r788 add_index "users", ["login"], name: "index_users_on_login", unique: true, using: :btree
admin
tag
 r681 add_foreign_key "problems_tags", "problems"
add_foreign_key "problems_tags", "tags"
jittat
added user settings...
 r13 end