diff --git a/db/schema.rb b/db/schema.rb --- a/db/schema.rb +++ b/db/schema.rb @@ -9,112 +9,112 @@ # from scratch. The latter is a flawed and unsustainable approach (the more migrations # you'll amass, the slower it'll run and the greater likelihood for issues). # -# It's strongly recommended to check this file into your version control system. +# It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(:version => 20161031063337) do +ActiveRecord::Schema.define(version: 20161031063337) do - create_table "announcements", :force => true do |t| + create_table "announcements", force: :cascade do |t| t.string "author" t.text "body" t.boolean "published" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.boolean "frontpage", :default => false - t.boolean "contest_only", :default => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + t.boolean "frontpage", default: false + t.boolean "contest_only", default: false t.string "title" t.string "notes" end - create_table "contests", :force => true do |t| + create_table "contests", force: :cascade do |t| t.string "title" t.boolean "enabled" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.string "name" end - create_table "contests_problems", :id => false, :force => true do |t| + create_table "contests_problems", id: false, force: :cascade do |t| t.integer "contest_id" t.integer "problem_id" end - create_table "contests_users", :id => false, :force => true do |t| + create_table "contests_users", id: false, force: :cascade do |t| t.integer "contest_id" t.integer "user_id" end - create_table "countries", :force => true do |t| + create_table "countries", force: :cascade do |t| t.string "name" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "descriptions", :force => true do |t| + create_table "descriptions", force: :cascade do |t| t.text "body" t.boolean "markdowned" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "grader_configurations", :force => true do |t| + create_table "grader_configurations", force: :cascade do |t| t.string "key" t.string "value_type" t.string "value" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.text "description" end - create_table "grader_processes", :force => true do |t| + create_table "grader_processes", force: :cascade do |t| t.string "host" t.integer "pid" t.string "mode" t.boolean "active" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "task_id" t.string "task_type" t.boolean "terminated" end - add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid" + add_index "grader_processes", ["host", "pid"], name: "index_grader_processes_on_ip_and_pid" - create_table "heart_beats", :force => true do |t| + create_table "heart_beats", force: :cascade do |t| t.integer "user_id" t.string "ip_address" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.string "status" end - add_index "heart_beats", ["updated_at"], :name => "index_heart_beats_on_updated_at" + add_index "heart_beats", ["updated_at"], name: "index_heart_beats_on_updated_at" - create_table "languages", :force => true do |t| - t.string "name", :limit => 10 + create_table "languages", force: :cascade do |t| + t.string "name", limit: 10 t.string "pretty_name" - t.string "ext", :limit => 10 + t.string "ext", limit: 10 t.string "common_ext" end - create_table "logins", :force => true do |t| + create_table "logins", force: :cascade do |t| t.integer "user_id" t.string "ip_address" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "messages", :force => true do |t| + create_table "messages", force: :cascade do |t| t.integer "sender_id" t.integer "receiver_id" t.integer "replying_message_id" t.text "body" t.boolean "replied" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "problems", :force => true do |t| - t.string "name", :limit => 30 + create_table "problems", force: :cascade do |t| + t.string "name", limit: 30 t.string "full_name" t.integer "full_score" t.date "date_added" @@ -126,57 +126,57 @@ t.string "description_filename" end - create_table "rights", :force => true do |t| + create_table "rights", force: :cascade do |t| t.string "name" t.string "controller" t.string "action" end - create_table "rights_roles", :id => false, :force => true do |t| + create_table "rights_roles", id: false, force: :cascade do |t| t.integer "right_id" t.integer "role_id" end - add_index "rights_roles", ["role_id"], :name => "index_rights_roles_on_role_id" + add_index "rights_roles", ["role_id"], name: "index_rights_roles_on_role_id" - create_table "roles", :force => true do |t| + create_table "roles", force: :cascade do |t| t.string "name" end - create_table "roles_users", :id => false, :force => true do |t| + create_table "roles_users", id: false, force: :cascade do |t| t.integer "role_id" t.integer "user_id" end - add_index "roles_users", ["user_id"], :name => "index_roles_users_on_user_id" + add_index "roles_users", ["user_id"], name: "index_roles_users_on_user_id" - create_table "sessions", :force => true do |t| + create_table "sessions", force: :cascade do |t| t.string "session_id" t.text "data" t.datetime "updated_at" end - add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" - add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" + add_index "sessions", ["session_id"], name: "index_sessions_on_session_id" + add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at" - create_table "sites", :force => true do |t| + create_table "sites", force: :cascade do |t| t.string "name" t.boolean "started" t.datetime "start_time" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "country_id" t.string "password" end - create_table "submission_view_logs", :force => true do |t| + create_table "submission_view_logs", force: :cascade do |t| t.integer "user_id" t.integer "submission_id" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "submissions", :force => true do |t| + create_table "submissions", force: :cascade do |t| t.integer "user_id" t.integer "problem_id" t.integer "language_id" @@ -196,25 +196,25 @@ t.string "ip_address" end - add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true - add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id" + add_index "submissions", ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true + add_index "submissions", ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id" - create_table "tasks", :force => true do |t| + create_table "tasks", force: :cascade do |t| t.integer "submission_id" t.datetime "created_at" t.integer "status" t.datetime "updated_at" end - create_table "test_pairs", :force => true do |t| + create_table "test_pairs", force: :cascade do |t| t.integer "problem_id" - t.text "input", :limit => 16777215 - t.text "solution", :limit => 16777215 - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.text "input", limit: 16777215 + t.text "solution", limit: 16777215 + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - create_table "test_requests", :force => true do |t| + create_table "test_requests", force: :cascade do |t| t.integer "user_id" t.integer "problem_id" t.integer "submission_id" @@ -222,59 +222,59 @@ t.string "output_file_name" t.string "running_stat" t.integer "status" - t.datetime "updated_at", :null => false + t.datetime "updated_at", null: false t.datetime "submitted_at" t.datetime "compiled_at" t.text "compiler_message" t.datetime "graded_at" t.string "grader_comment" - t.datetime "created_at", :null => false + t.datetime "created_at", null: false t.float "running_time" t.string "exit_status" t.integer "memory_usage" end - add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id" + add_index "test_requests", ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id" - create_table "testcases", :force => true do |t| + create_table "testcases", force: :cascade do |t| t.integer "problem_id" t.integer "num" t.integer "group" t.integer "score" t.text "input" t.text "sol" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - add_index "testcases", ["problem_id"], :name => "index_testcases_on_problem_id" + add_index "testcases", ["problem_id"], name: "index_testcases_on_problem_id" - create_table "user_contest_stats", :force => true do |t| + create_table "user_contest_stats", force: :cascade do |t| t.integer "user_id" t.datetime "started_at" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.boolean "forced_logout" end - create_table "users", :force => true do |t| - t.string "login", :limit => 50 + create_table "users", force: :cascade do |t| + t.string "login", limit: 50 t.string "full_name" t.string "hashed_password" - t.string "salt", :limit => 5 + t.string "salt", limit: 5 t.string "alias" t.string "email" t.integer "site_id" t.integer "country_id" - t.boolean "activated", :default => false + t.boolean "activated", default: false t.datetime "created_at" t.datetime "updated_at" - t.boolean "enabled", :default => true + t.boolean "enabled", default: true t.string "remark" t.string "last_ip" t.string "section" end - add_index "users", ["login"], :name => "index_users_on_login", :unique => true + add_index "users", ["login"], name: "index_users_on_login", unique: true end