# HG changeset patch
# User Jittat Fakcharoenphol <jittat@gmail.com>
# Date 2015-01-28 16:14:08
# Node ID 894c9826b6b5f9b5bc082c677773f9ff0186f099
# Parent  91238b16dbc9be0d2e2b3a8e1d0af66c9df9c5e6

updated db/schema.rb to remove unused fields incorrected added from the code jom branch

diff --git a/db/schema.rb b/db/schema.rb
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -17,27 +17,19 @@
     t.string   "author"
     t.text     "body"
     t.boolean  "published"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    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 "codejom_statuses", :force => true do |t|
-    t.integer  "user_id"
-    t.boolean  "alive"
-    t.integer  "num_problems_passed"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
   create_table "contests", :force => true do |t|
     t.string   "title"
     t.boolean  "enabled"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at", :null => false
+    t.datetime "updated_at", :null => false
     t.string   "name"
   end
 
@@ -53,23 +45,23 @@
 
   create_table "countries", :force => true do |t|
     t.string   "name"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at", :null => false
+    t.datetime "updated_at", :null => false
   end
 
   create_table "descriptions", :force => true do |t|
     t.text     "body"
     t.boolean  "markdowned"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at", :null => false
+    t.datetime "updated_at", :null => false
   end
 
   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.datetime "created_at",  :null => false
+    t.datetime "updated_at",  :null => false
     t.text     "description"
   end
 
@@ -78,8 +70,8 @@
     t.integer  "pid"
     t.string   "mode"
     t.boolean  "active"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",               :null => false
+    t.datetime "updated_at",               :null => false
     t.integer  "task_id"
     t.string   "task_type"
     t.boolean  "terminated"
@@ -100,23 +92,21 @@
     t.integer  "replying_message_id"
     t.text     "body"
     t.boolean  "replied"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    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
-    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"
+    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.string  "description_filename"
   end
 
   create_table "rights", :force => true do |t|
@@ -156,21 +146,12 @@
     t.string   "name"
     t.boolean  "started"
     t.datetime "start_time"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at", :null => false
+    t.datetime "updated_at", :null => false
     t.integer  "country_id"
     t.string   "password"
   end
 
-  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
-
   create_table "submissions", :force => true do |t|
     t.integer  "user_id"
     t.integer  "problem_id"
@@ -197,24 +178,12 @@
     t.datetime "updated_at"
   end
 
-  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
-
   create_table "test_pairs", :force => true do |t|
     t.integer  "problem_id"
     t.text     "input",      :limit => 16777215
     t.text     "solution",   :limit => 16777215
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "number"
+    t.datetime "created_at",                     :null => false
+    t.datetime "updated_at",                     :null => false
   end
 
   create_table "test_requests", :force => true do |t|
@@ -225,13 +194,13 @@
     t.string   "output_file_name"
     t.string   "running_stat"
     t.integer  "status"
-    t.datetime "updated_at"
+    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"
+    t.datetime "created_at",       :null => false
     t.float    "running_time"
     t.string   "exit_status"
     t.integer  "memory_usage"
@@ -242,30 +211,23 @@
   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"
+    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
+    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.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"
   end
 
   add_index "users", ["login"], :name => "index_users_on_login", :unique => true