cafe-grader-web Files · db/schema.rb

cafe-grader-web

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

Commit Description:

update NOTES...

Commit Description:

update NOTES git-svn-id: http://theory.cpe.ku.ac.th/grader/web/trunk@120 6386c4cd-e34a-4fa8-8920-d93eb39b512e

References:

r55:3e9e12386752 default

File last commit:

r36:a3144ce1a174 default

Show/Diff file:

Action:

            
                    db/schema.rb
                
             | 129 lines
             | 4.0 KiB
             | text/x-ruby 
             | RubyLexer
             | 
      
            History
        
           Show Full History
         |
          Source
         | Raw
         |
              
              Download
              
     jittat
  
added user settings...

              r13
            
      # This file is auto-generated from the current state of the database. Instead of editing this file, 

      # please use the migrations feature of ActiveRecord to incrementally modify your database, and

      # 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
  
test interface upload...

              r36
            
      ActiveRecord::Schema.define(:version => 19) do

     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
  
started grader_process...

              r29
            
          t.integer  "pid"

          t.string   "mode"

          t.boolean  "active"

          t.datetime "created_at"

          t.datetime "updated_at"

     jittat
  
add grader list...

              r32
            
          t.integer  "task_id"

     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

        end

        create_table "problems", :force => true do |t|

          t.string  "name",       :limit => 30

          t.string  "full_name"

          t.integer "full_score"

          t.date    "date_added"

          t.boolean "available"

     jittat
  
+task description...

              r19
            
          t.string  "url"

     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|

          t.integer "right_id"

          t.integer "role_id"

        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|

          t.integer "role_id"

          t.integer "user_id"

        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"

        create_table "submissions", :force => true do |t|

          t.integer  "user_id"

          t.integer  "problem_id"

          t.integer  "language_id"

          t.text     "source"

          t.binary   "binary"

          t.datetime "submitted_at"

          t.datetime "compiled_at"

          t.text     "compiler_message"

          t.datetime "graded_at"

          t.integer  "points"

          t.text     "grader_comment"

     jittat
  
added number (auto generated when submitting) to submissions...

              r35
            
          t.integer  "number"

     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|

          t.integer  "submission_id"

          t.datetime "created_at"

     jittat
  
add some lock in task...

              r30
            
          t.integer  "status"

          t.datetime "updated_at"

     jittat
  
added user settings...

              r13
            
        end

     jittat
  
test interface upload...

              r36
            
        create_table "test_requests", :force => true 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"

          t.datetime "updated_at"

          t.datetime "submitted_at"

          t.datetime "compiled_at"

          t.string   "compiler_message"

          t.datetime "graded_at"

          t.string   "grader_comment"

          t.datetime "created_at"

        end

        add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"

     jittat
  
added user settings...

              r13
            
        create_table "users", :force => true do |t|

          t.string "login",           :limit => 10

          t.string "full_name"

          t.string "hashed_password"

          t.string "salt",            :limit => 5

          t.string "alias"

     jittat
  
add_email_to_user, fix empty problem for_in_place_editing...

              r18
            
          t.string "email"

     jittat
  
added user settings...

              r13
            
        end

        add_index "users", ["login"], :name => "index_users_on_login", :unique => true

      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository permissions settings

Sign in to your account

Last Author

jittat added user settings...	r13	# This file is auto-generated from the current state of the database. Instead of editing this file,
		# please use the migrations feature of ActiveRecord to incrementally modify your database, and
		# 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 test interface upload...	r36	ActiveRecord::Schema.define(:version => 19) do
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 started grader_process...	r29	t.integer "pid"
		t.string "mode"
		t.boolean "active"
		t.datetime "created_at"
		t.datetime "updated_at"
jittat add grader list...	r32	t.integer "task_id"
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
		end

		create_table "problems", :force => true do \|t\|
		t.string "name", :limit => 30
		t.string "full_name"
		t.integer "full_score"
		t.date "date_added"
		t.boolean "available"
jittat +task description...	r19	t.string "url"
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\|
		t.integer "right_id"
		t.integer "role_id"
		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\|
		t.integer "role_id"
		t.integer "user_id"
		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"

		create_table "submissions", :force => true do \|t\|
		t.integer "user_id"
		t.integer "problem_id"
		t.integer "language_id"
		t.text "source"
		t.binary "binary"
		t.datetime "submitted_at"
		t.datetime "compiled_at"
		t.text "compiler_message"
		t.datetime "graded_at"
		t.integer "points"
		t.text "grader_comment"
jittat added number (auto generated when submitting) to submissions...	r35	t.integer "number"
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\|
		t.integer "submission_id"
		t.datetime "created_at"
jittat add some lock in task...	r30	t.integer "status"
		t.datetime "updated_at"
jittat added user settings...	r13	end

jittat test interface upload...	r36	create_table "test_requests", :force => true 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"
		t.datetime "updated_at"
		t.datetime "submitted_at"
		t.datetime "compiled_at"
		t.string "compiler_message"
		t.datetime "graded_at"
		t.string "grader_comment"
		t.datetime "created_at"
		end

		add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"

jittat added user settings...	r13	create_table "users", :force => true do \|t\|
		t.string "login", :limit => 10
		t.string "full_name"
		t.string "hashed_password"
		t.string "salt", :limit => 5
		t.string "alias"
jittat add_email_to_user, fix empty problem for_in_place_editing...	r18	t.string "email"
jittat added user settings...	r13	end

		add_index "users", ["login"], :name => "index_users_on_login", :unique => true

		end