Show More
Commit Description:
copy working trunk (r383, before major changes to combine judge and to support grader message queue) to trunk...
Commit Description:
copy working trunk (r383, before major changes to combine judge and to support grader message queue) to trunk
git-svn-id: http://theory.cpe.ku.ac.th/grader/web/trunk@396 6386c4cd-e34a-4fa8-8920-d93eb39b512e
References:
File last commit:
Show/Diff file:
Action:
Last Author
Show All-
jittat-
db/schema.rb
| 195 lines
| 5.8 KiB
| text/x-ruby
| RubyLexer
|
jittat
|
r13 | # This file is auto-generated from the current state of the database. Instead of editing this file, | ||
|
jittat
|
r141 | # please use the migrations feature of Active Record to incrementally modify your database, and | ||
|
jittat
|
r13 | # then regenerate this schema definition. | ||
| # | ||||
| # 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 | ||||
| # 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. | ||||
|
jittat
|
r188 | ActiveRecord::Schema.define(:version => 20090426131044) do | ||
|
jittat
|
r97 | |||
| create_table "announcements", :force => true do |t| | ||||
| t.string "author" | ||||
| t.text "body" | ||||
| t.boolean "published" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
|
jittat
|
r162 | t.boolean "frontpage", :default => false | ||
| t.boolean "contest_only", :default => false | ||||
|
jittat
|
r97 | end | ||
|
jittat
|
r76 | |||
| create_table "configurations", :force => true do |t| | ||||
| t.string "key" | ||||
| t.string "value_type" | ||||
| t.string "value" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
| end | ||||
|
jittat
|
r29 | |||
|
jittat
|
r106 | create_table "countries", :force => true do |t| | ||
| t.string "name" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
| end | ||||
|
jittat
|
r92 | create_table "descriptions", :force => true do |t| | ||
| t.text "body" | ||||
| t.boolean "markdowned" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
| end | ||||
|
jittat
|
r29 | create_table "grader_processes", :force => true do |t| | ||
|
jittat
|
r34 | t.string "host", :limit => 20 | ||
|
jittat
|
r142 | t.integer "pid" | ||
|
jittat
|
r29 | t.string "mode" | ||
| t.boolean "active" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
|
jittat
|
r142 | t.integer "task_id" | ||
|
jittat
|
r105 | t.string "task_type" | ||
|
jittat
|
r175 | t.boolean "terminated" | ||
|
jittat
|
r29 | end | ||
|
jittat
|
r34 | add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid" | ||
|
jittat
|
r13 | |||
| create_table "languages", :force => true do |t| | ||||
| t.string "name", :limit => 10 | ||||
| t.string "pretty_name" | ||||
| t.string "ext", :limit => 10 | ||||
|
jittat
|
r166 | t.string "common_ext" | ||
|
jittat
|
r13 | end | ||
|
jittat
|
r102 | create_table "messages", :force => true do |t| | ||
|
jittat
|
r142 | t.integer "sender_id" | ||
| t.integer "receiver_id" | ||||
| t.integer "replying_message_id" | ||||
|
jittat
|
r102 | t.text "body" | ||
| t.boolean "replied" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
| end | ||||
|
jittat
|
r13 | create_table "problems", :force => true do |t| | ||
|
jittat
|
r92 | t.string "name", :limit => 30 | ||
|
jittat
|
r13 | t.string "full_name" | ||
|
jittat
|
r142 | t.integer "full_score" | ||
|
jittat
|
r13 | t.date "date_added" | ||
| t.boolean "available" | ||||
|
jittat
|
r19 | t.string "url" | ||
|
jittat
|
r142 | t.integer "description_id" | ||
|
jittat
|
r94 | t.boolean "test_allowed" | ||
|
jittat
|
r99 | t.boolean "output_only" | ||
|
jittat
|
r13 | end | ||
| create_table "rights", :force => true do |t| | ||||
| t.string "name" | ||||
| t.string "controller" | ||||
| t.string "action" | ||||
| end | ||||
| create_table "rights_roles", :id => false, :force => true do |t| | ||||
|
jittat
|
r142 | t.integer "right_id" | ||
| t.integer "role_id" | ||||
|
jittat
|
r13 | end | ||
| add_index "rights_roles", ["role_id"], :name => "index_rights_roles_on_role_id" | ||||
| create_table "roles", :force => true do |t| | ||||
| t.string "name" | ||||
| end | ||||
| create_table "roles_users", :id => false, :force => true do |t| | ||||
|
jittat
|
r142 | t.integer "role_id" | ||
| t.integer "user_id" | ||||
|
jittat
|
r13 | end | ||
| add_index "roles_users", ["user_id"], :name => "index_roles_users_on_user_id" | ||||
| create_table "sessions", :force => true 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" | ||||
|
jittat
|
r85 | create_table "sites", :force => true do |t| | ||
| t.string "name" | ||||
| t.boolean "started" | ||||
| t.datetime "start_time" | ||||
| t.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
|
jittat
|
r142 | t.integer "country_id" | ||
|
jittat
|
r106 | t.string "password" | ||
|
jittat
|
r85 | end | ||
|
jittat
|
r13 | create_table "submissions", :force => true do |t| | ||
|
jittat
|
r142 | t.integer "user_id" | ||
| t.integer "problem_id" | ||||
| t.integer "language_id" | ||||
|
jittat
|
r13 | t.text "source" | ||
| t.binary "binary" | ||||
| t.datetime "submitted_at" | ||||
| t.datetime "compiled_at" | ||||
| t.text "compiler_message" | ||||
| t.datetime "graded_at" | ||||
|
jittat
|
r142 | t.integer "points" | ||
|
jittat
|
r13 | t.text "grader_comment" | ||
|
jittat
|
r142 | t.integer "number" | ||
|
jittat
|
r99 | t.string "source_filename" | ||
|
jittat
|
r13 | end | ||
|
jittat
|
r35 | add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true | ||
|
jittat
|
r13 | add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id" | ||
| create_table "tasks", :force => true do |t| | ||||
|
jittat
|
r142 | t.integer "submission_id" | ||
|
jittat
|
r13 | t.datetime "created_at" | ||
|
jittat
|
r142 | t.integer "status" | ||
|
jittat
|
r30 | t.datetime "updated_at" | ||
|
jittat
|
r13 | end | ||
|
jittat
|
r36 | create_table "test_requests", :force => true do |t| | ||
|
jittat
|
r142 | t.integer "user_id" | ||
| t.integer "problem_id" | ||||
| t.integer "submission_id" | ||||
|
jittat
|
r36 | t.string "input_file_name" | ||
| t.string "output_file_name" | ||||
| t.string "running_stat" | ||||
|
jittat
|
r142 | t.integer "status" | ||
|
jittat
|
r36 | t.datetime "updated_at" | ||
| t.datetime "submitted_at" | ||||
| t.datetime "compiled_at" | ||||
|
jittat
|
r68 | t.text "compiler_message" | ||
|
jittat
|
r36 | t.datetime "graded_at" | ||
| t.string "grader_comment" | ||||
| t.datetime "created_at" | ||||
|
jittat
|
r82 | t.float "running_time" | ||
|
jittat
|
r81 | t.string "exit_status" | ||
|
jittat
|
r142 | t.integer "memory_usage" | ||
|
jittat
|
r36 | end | ||
| add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id" | ||||
|
jittat
|
r13 | create_table "users", :force => true do |t| | ||
|
jittat
|
r162 | t.string "login", :limit => 50 | ||
|
jittat
|
r158 | t.string "full_name" | ||
| t.string "hashed_password" | ||||
| 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.datetime "created_at" | ||||
| t.datetime "updated_at" | ||||
|
jittat
|
r13 | end | ||
| add_index "users", ["login"], :name => "index_users_on_login", :unique => true | ||||
| end | ||||