cafe-grader-web

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

Show More
Commit Description:
add 2nd level sort problem by name (not full name)...
Commit Description:
add 2nd level sort problem by name (not full name) show problem name before full_name in main/list
References:
r409:4e03b3c502cc java
File last commit:
r399:5ab0850fb639 algo
Show/Diff file:
Action:
db/schema.rb | 273 lines | 7.9 KiB | text/x-ruby | RubyLexer |
History | Source | Raw | Download
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 # encoding: UTF-8
# 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).
#
# It's strongly recommended to check this file into your version control system.
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 ActiveRecord::Schema.define(:version => 20121001033508) do
jittat
[web] added announcement...
 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
MERGED 308:HEAD from http://theory.cpe.ku.ac.th/grader/web/branches/ytopc08-2/, removed some registration info...
 r162 t.boolean "frontpage", :default => false
t.boolean "contest_only", :default => false
jittat
better announcement effects...
 r193 t.string "title"
Jittat Fakcharoenphol
styling announcements, added notes
 r306 t.string "notes"
jittat
[web] added announcement...
 r97 end
jittat
[web] added configurations...
 r76
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 create_table "codejom_statuses", :force => true do |t|
t.integer "user_id"
t.boolean "alive"
t.integer "num_problems_passed"
jittat
[web] added configurations...
 r76 t.datetime "created_at"
t.datetime "updated_at"
end
jittat
started grader_process...
 r29
Jittat Fakcharoenphol
added contest model
 r266 create_table "contests", :force => true do |t|
t.string "title"
t.boolean "enabled"
t.datetime "created_at"
t.datetime "updated_at"
Jittat Fakcharoenphol
manages problems in contests
 r279 t.string "name"
Jittat Fakcharoenphol
added contest model
 r266 end
Jittat Fakcharoenphol
created join tables for contests and users and problems
 r268 create_table "contests_problems", :id => false, :force => true do |t|
t.integer "contest_id"
t.integer "problem_id"
end
create_table "contests_users", :id => false, :force => true do |t|
t.integer "contest_id"
t.integer "user_id"
end
jittat
[web] import from site...
 r106 create_table "countries", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
jittat
[web] refactor problem description, some styling...
 r92 create_table "descriptions", :force => true do |t|
t.text "body"
t.boolean "markdowned"
t.datetime "created_at"
t.datetime "updated_at"
end
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 create_table "grader_configurations", :force => true do |t|
t.string "key"
t.string "value_type"
t.string "value"
t.datetime "created_at"
t.datetime "updated_at"
t.text "description"
end
jittat
started grader_process...
 r29 create_table "grader_processes", :force => true do |t|
jittat
renamed ip to host in GraderProcess...
 r34 t.string "host", :limit => 20
jittat
added contest.name to html title...
 r142 t.integer "pid"
jittat
started grader_process...
 r29 t.string "mode"
t.boolean "active"
t.datetime "created_at"
t.datetime "updated_at"
jittat
added contest.name to html title...
 r142 t.integer "task_id"
jittat
[web] updated grader monitoring...
 r105 t.string "task_type"
jittat
updated grader list page...
 r175 t.boolean "terminated"
jittat
started grader_process...
 r29 end
jittat
renamed ip to host in GraderProcess...
 r34 add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid"
jittat
added user settings...
 r13
create_table "languages", :force => true do |t|
t.string "name", :limit => 10
t.string "pretty_name"
t.string "ext", :limit => 10
jittat
added language identification using file extension...
 r166 t.string "common_ext"
jittat
added user settings...
 r13 end
jittat
[web] added message feature...
 r102 create_table "messages", :force => true do |t|
jittat
added contest.name to html title...
 r142 t.integer "sender_id"
t.integer "receiver_id"
t.integer "replying_message_id"
jittat
[web] added message feature...
 r102 t.text "body"
t.boolean "replied"
t.datetime "created_at"
t.datetime "updated_at"
end
jittat
added user settings...
 r13 create_table "problems", :force => true do |t|
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.string "name", :limit => 30
t.string "full_name"
t.integer "full_score"
t.date "date_added"
t.boolean "available"
t.string "url"
t.integer "description_id"
t.boolean "test_allowed"
t.boolean "output_only"
t.integer "level", :default => 0
t.datetime "updated_at"
t.string "description_filename"
jittat
added user settings...
 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
added contest.name to html title...
 r142 t.integer "right_id"
t.integer "role_id"
jittat
added user settings...
 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
added contest.name to html title...
 r142 t.integer "role_id"
t.integer "user_id"
jittat
added user settings...
 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
[web] added site and time out basic functionality...
 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
added contest.name to html title...
 r142 t.integer "country_id"
jittat
[web] import from site...
 r106 t.string "password"
jittat
[web] added site and time out basic functionality...
 r85 end
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 create_table "submission_statuses", :force => true do |t|
t.integer "user_id"
t.integer "problem_id"
t.boolean "passed"
t.integer "submission_count"
t.datetime "created_at"
t.datetime "updated_at"
end
jittat
added user settings...
 r13 create_table "submissions", :force => true do |t|
jittat
added contest.name to html title...
 r142 t.integer "user_id"
t.integer "problem_id"
t.integer "language_id"
jittat
added user settings...
 r13 t.text "source"
t.binary "binary"
t.datetime "submitted_at"
t.datetime "compiled_at"
t.text "compiler_message"
t.datetime "graded_at"
jittat
added contest.name to html title...
 r142 t.integer "points"
jittat
added user settings...
 r13 t.text "grader_comment"
jittat
added contest.name to html title...
 r142 t.integer "number"
jittat
[web] added support for output only problems...
 r99 t.string "source_filename"
jittat
added user settings...
 r13 end
jittat
added number (auto generated when submitting) to submissions...
 r35 add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true
jittat
added user settings...
 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
added contest.name to html title...
 r142 t.integer "submission_id"
jittat
added user settings...
 r13 t.datetime "created_at"
jittat
added contest.name to html title...
 r142 t.integer "status"
jittat
add some lock in task...
 r30 t.datetime "updated_at"
jittat
added user settings...
 r13 end
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 create_table "test_pair_assignments", :force => true do |t|
t.integer "user_id"
t.integer "problem_id"
t.integer "test_pair_id"
t.integer "test_pair_number"
t.integer "request_number"
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "submitted"
end
Jittat Fakcharoenphol
added test_pair model
 r209 create_table "test_pairs", :force => true do |t|
t.integer "problem_id"
Jittat Fakcharoenphol
added contest model
 r266 t.text "input", :limit => 16777215
t.text "solution", :limit => 16777215
Jittat Fakcharoenphol
added test_pair model
 r209 t.datetime "created_at"
t.datetime "updated_at"
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.integer "number"
Jittat Fakcharoenphol
added test_pair model
 r209 end
jittat
test interface upload...
 r36 create_table "test_requests", :force => true do |t|
jittat
added contest.name to html title...
 r142 t.integer "user_id"
t.integer "problem_id"
t.integer "submission_id"
jittat
test interface upload...
 r36 t.string "input_file_name"
t.string "output_file_name"
t.string "running_stat"
jittat
added contest.name to html title...
 r142 t.integer "status"
jittat
test interface upload...
 r36 t.datetime "updated_at"
t.datetime "submitted_at"
t.datetime "compiled_at"
jittat
[grader] +migration, change compiler message type in test_requests to text...
 r68 t.text "compiler_message"
jittat
test interface upload...
 r36 t.datetime "graded_at"
t.string "grader_comment"
t.datetime "created_at"
jittat
[web] changed column type for running_time in test_requests, display new stat info...
 r82 t.float "running_time"
jittat
[web] added runstat columns to test_request...
 r81 t.string "exit_status"
jittat
added contest.name to html title...
 r142 t.integer "memory_usage"
jittat
test interface upload...
 r36 end
add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"
Jittat Fakcharoenphol
added individual contest mode
 r217 create_table "user_contest_stats", :force => true do |t|
t.integer "user_id"
t.datetime "started_at"
t.datetime "created_at"
t.datetime "updated_at"
Jittat Fakcharoenphol
a cleaner, testable way to log out user after contest changed
 r295 t.boolean "forced_logout"
Jittat Fakcharoenphol
added individual contest mode
 r217 end
jittat
added user settings...
 r13 create_table "users", :force => true do |t|
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.string "login", :limit => 50
jittat
Merged online-registration branch changes r297:303 into the trunk...
 r158 t.string "full_name"
t.string "hashed_password"
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.string "salt", :limit => 5
jittat
Merged online-registration branch changes r297:303 into the trunk...
 r158 t.string "alias"
t.string "email"
t.integer "site_id"
t.integer "country_id"
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.boolean "activated", :default => false
jittat
Merged online-registration branch changes r297:303 into the trunk...
 r158 t.datetime "created_at"
t.datetime "updated_at"
Jittat Fakcharoenphol
renamed model Configuration to GraderConfiguration, renamed rhtml views to erb, fixed other small errors
 r320 t.string "member1_full_name"
t.string "member2_full_name"
t.string "member3_full_name"
t.boolean "high_school"
t.string "member1_school_name"
t.string "member2_school_name"
t.string "member3_school_name"
jittat
added user settings...
 r13 end
add_index "users", ["login"], :name => "index_users_on_login", :unique => true
end