Show More
Commit Description:
still upgrading
Commit Description:
still upgrading
References:
File last commit:
Show/Diff file:
Action:
db/schema.rb
| 307 lines
| 11.2 KiB
| text/x-ruby
| RubyLexer
|
Jittat Fakcharoenphol
|
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
|
r13 | # | ||
|
Jittat Fakcharoenphol
|
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
|
r13 | # you'll amass, the slower it'll run and the greater likelihood for issues). | ||
| # | ||||
| r621 | # It's strongly recommended that you check this file into your version control system. | |||
|
jittat
|
r13 | |||
| r712 | ActiveRecord::Schema.define(version: 20180612102327) do | |||
|
jittat
|
r97 | |||
| r744 | create_table "announcements", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "author" | ||||
| r720 | t.text "body", limit: 65535 | |||
|
jittat
|
r97 | t.boolean "published" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r720 | t.boolean "frontpage", default: false | |||
| t.boolean "contest_only", default: false | ||||
| r744 | t.string "title" | |||
| t.string "notes" | ||||
|
jittat
|
r97 | end | ||
|
jittat
|
r76 | |||
| r744 | create_table "contests", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "title" | ||||
|
Jittat Fakcharoenphol
|
r266 | t.boolean "enabled" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r744 | t.string "name" | |||
|
Jittat Fakcharoenphol
|
r266 | end | ||
| r744 | create_table "contests_problems", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "contest_id" | ||||
| t.integer "problem_id" | ||||
|
Jittat Fakcharoenphol
|
r268 | end | ||
| r744 | create_table "contests_users", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "contest_id" | ||||
| t.integer "user_id" | ||||
|
Jittat Fakcharoenphol
|
r268 | end | ||
| r744 | create_table "countries", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
|
jittat
|
r106 | end | ||
| r744 | create_table "descriptions", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| r720 | t.text "body", limit: 65535 | |||
|
jittat
|
r92 | t.boolean "markdowned" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
|
jittat
|
r92 | end | ||
| r744 | create_table "grader_configurations", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "key" | ||||
| t.string "value_type" | ||||
| t.string "value" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r720 | t.text "description", limit: 65535 | |||
|
Jittat Fakcharoenphol
|
r320 | end | ||
| r744 | create_table "grader_processes", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "host" | ||||
| t.integer "pid" | ||||
| t.string "mode" | ||||
|
jittat
|
r29 | t.boolean "active" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r744 | t.integer "task_id" | |||
| t.string "task_type" | ||||
|
jittat
|
r175 | t.boolean "terminated" | ||
| r744 | t.index ["host", "pid"], name: "index_grader_processes_on_host_and_pid", using: :btree | |||
|
jittat
|
r29 | end | ||
| r744 | create_table "groups", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name" | ||||
| t.string "description" | ||||
| r672 | end | |||
| r744 | create_table "groups_problems", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "problem_id", null: false | ||||
| t.integer "group_id", null: false | ||||
| t.index ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id", using: :btree | ||||
| r672 | end | |||
| r744 | create_table "groups_users", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "group_id", null: false | ||||
| t.integer "user_id", null: false | ||||
| t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id", using: :btree | ||||
| r672 | end | |||
| r744 | create_table "heart_beats", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
| t.string "ip_address" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r744 | t.string "status" | |||
| t.index ["updated_at"], name: "index_heart_beats_on_updated_at", using: :btree | ||||
| r540 | end | |||
| r744 | create_table "languages", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| r621 | t.string "name", limit: 10 | |||
| r744 | t.string "pretty_name" | |||
| r621 | t.string "ext", limit: 10 | |||
| r744 | t.string "common_ext" | |||
|
jittat
|
r13 | end | ||
| r744 | create_table "logins", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
| t.string "ip_address" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r410 | end | |||
| r744 | create_table "messages", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "sender_id" | ||||
| t.integer "receiver_id" | ||||
| t.integer "replying_message_id" | ||||
| r720 | t.text "body", limit: 65535 | |||
|
jittat
|
r102 | t.boolean "replied" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
|
jittat
|
r102 | end | ||
| r744 | create_table "problems", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| r640 | t.string "name", limit: 30 | |||
| r744 | t.string "full_name" | |||
| t.integer "full_score" | ||||
| r640 | t.date "date_added" | |||
| t.boolean "available" | ||||
| r744 | t.string "url" | |||
| t.integer "description_id" | ||||
| r640 | t.boolean "test_allowed" | |||
| t.boolean "output_only" | ||||
| r744 | t.string "description_filename" | |||
| r640 | t.boolean "view_testcase" | |||
| end | ||||
|
jittat
|
r13 | |||
| r744 | create_table "problems_tags", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "problem_id" | ||||
| t.integer "tag_id" | ||||
| t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true, using: :btree | ||||
| t.index ["problem_id"], name: "index_problems_tags_on_problem_id", using: :btree | ||||
| t.index ["tag_id"], name: "index_problems_tags_on_tag_id", using: :btree | ||||
| r681 | end | |||
| r744 | create_table "rights", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name" | ||||
| t.string "controller" | ||||
| t.string "action" | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "rights_roles", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "right_id" | ||||
| t.integer "role_id" | ||||
| t.index ["role_id"], name: "index_rights_roles_on_role_id", using: :btree | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "roles", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name" | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "roles_users", id: false, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "role_id" | ||||
| t.integer "user_id" | ||||
| t.index ["user_id"], name: "index_roles_users_on_user_id", using: :btree | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "sessions", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "session_id" | ||||
| r720 | t.text "data", limit: 65535 | |||
|
jittat
|
r13 | t.datetime "updated_at" | ||
| r744 | t.index ["session_id"], name: "index_sessions_on_session_id", using: :btree | |||
| t.index ["updated_at"], name: "index_sessions_on_updated_at", using: :btree | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "sites", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name" | ||||
|
jittat
|
r85 | t.boolean "started" | ||
| t.datetime "start_time" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r744 | t.integer "country_id" | |||
| t.string "password" | ||||
|
jittat
|
r85 | end | ||
| r744 | create_table "submission_view_logs", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
| t.integer "submission_id" | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r528 | end | |||
| r744 | create_table "submissions", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
| t.integer "problem_id" | ||||
| t.integer "language_id" | ||||
| r732 | t.text "source", limit: 16777215 | |||
| r640 | t.binary "binary", limit: 65535 | |||
|
jittat
|
r13 | t.datetime "submitted_at" | ||
| t.datetime "compiled_at" | ||||
| r720 | t.text "compiler_message", limit: 65535 | |||
|
jittat
|
r13 | t.datetime "graded_at" | ||
| r744 | t.integer "points" | |||
| r720 | t.text "grader_comment", limit: 65535 | |||
| r744 | t.integer "number" | |||
| t.string "source_filename" | ||||
| r640 | t.float "max_runtime", limit: 24 | |||
| r744 | t.integer "peak_memory" | |||
| t.integer "effective_code_length" | ||||
| t.string "ip_address" | ||||
| t.index ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true, using: :btree | ||||
| t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id", using: :btree | ||||
|
jittat
|
r13 | end | ||
| r744 | create_table "tags", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.string "name", null: false | ||||
| r681 | t.text "description", limit: 65535 | |||
| t.boolean "public" | ||||
| t.datetime "created_at", null: false | ||||
| t.datetime "updated_at", null: false | ||||
| end | ||||
| r744 | create_table "tasks", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "submission_id" | ||||
|
jittat
|
r13 | t.datetime "created_at" | ||
| r744 | t.integer "status" | |||
|
jittat
|
r30 | t.datetime "updated_at" | ||
| r744 | t.index ["submission_id"], name: "index_tasks_on_submission_id", using: :btree | |||
|
jittat
|
r13 | end | ||
| r744 | create_table "test_pairs", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "problem_id" | ||||
| r720 | t.text "input", limit: 16777215 | |||
| t.text "solution", limit: 16777215 | ||||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
Jittat Fakcharoenphol
|
r209 | end | ||
| r744 | create_table "test_requests", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
| t.integer "problem_id" | ||||
| t.integer "submission_id" | ||||
| t.string "input_file_name" | ||||
| t.string "output_file_name" | ||||
| t.string "running_stat" | ||||
| t.integer "status" | ||||
| r740 | t.datetime "updated_at" | |||
|
jittat
|
r36 | t.datetime "submitted_at" | ||
| t.datetime "compiled_at" | ||||
| r720 | t.text "compiler_message", limit: 65535 | |||
|
jittat
|
r36 | t.datetime "graded_at" | ||
| r744 | t.string "grader_comment" | |||
| r740 | t.datetime "created_at" | |||
| r640 | t.float "running_time", limit: 24 | |||
| r744 | t.string "exit_status" | |||
| t.integer "memory_usage" | ||||
| t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id", using: :btree | ||||
|
jittat
|
r36 | end | ||
| r744 | create_table "testcases", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "problem_id" | ||||
| t.integer "num" | ||||
| t.integer "group" | ||||
| t.integer "score" | ||||
| r631 | t.text "input", limit: 4294967295 | |||
| t.text "sol", limit: 4294967295 | ||||
| r720 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
| r744 | t.index ["problem_id"], name: "index_testcases_on_problem_id", using: :btree | |||
| r607 | end | |||
| r744 | create_table "user_contest_stats", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| t.integer "user_id" | ||||
|
Jittat Fakcharoenphol
|
r217 | t.datetime "started_at" | ||
| r740 | t.datetime "created_at" | |||
| t.datetime "updated_at" | ||||
|
Jittat Fakcharoenphol
|
r295 | t.boolean "forced_logout" | ||
|
Jittat Fakcharoenphol
|
r217 | end | ||
| r744 | create_table "users", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1" do |t| | |||
| r621 | t.string "login", limit: 50 | |||
| r744 | t.string "full_name" | |||
| t.string "hashed_password" | ||||
| r621 | t.string "salt", limit: 5 | |||
| r744 | t.string "alias" | |||
| t.string "email" | ||||
| t.integer "site_id" | ||||
| t.integer "country_id" | ||||
| t.boolean "activated", default: false | ||||
|
jittat
|
r158 | t.datetime "created_at" | ||
| t.datetime "updated_at" | ||||
| r744 | t.string "section" | |||
| t.boolean "enabled", default: true | ||||
| t.string "remark" | ||||
| t.string "last_ip" | ||||
| t.index ["login"], name: "index_users_on_login", unique: true, using: :btree | ||||
|
jittat
|
r13 | end | ||
| r681 | add_foreign_key "problems_tags", "problems" | |||
| add_foreign_key "problems_tags", "tags" | ||||
|
jittat
|
r13 | end | ||