diff --git a/db/schema.rb b/db/schema.rb
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -22,14 +22,6 @@
     t.string   "title"
   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 "configurations", :force => true do |t|
     t.string   "key"
     t.string   "value_type"
@@ -156,15 +148,6 @@
     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"
@@ -191,17 +174,6 @@
     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
diff --git a/test/fixtures/contests.yml b/test/fixtures/contests.yml
--- a/test/fixtures/contests.yml
+++ b/test/fixtures/contests.yml
@@ -1,9 +1,13 @@
 # Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html
 
-one:
-  title: MyString
-  enabled: false
+contest_a:
+  title: Contest A
+  enabled: true
 
-two:
-  title: MyString
+contest_b:
+  title: Contest B
+  enabled: true
+
+contest_c:
+  title: Contest C
   enabled: false
diff --git a/test/test_helper.rb b/test/test_helper.rb
--- a/test/test_helper.rb
+++ b/test/test_helper.rb
@@ -16,7 +16,7 @@
   # don't care one way or the other, switching from MyISAM to InnoDB tables
   # is recommended.
 
-  self.use_transactional_fixtures = false
+  self.use_transactional_fixtures = true
 
   # Instantiated fixtures are slow, but give you @david where otherwise you
   # would need people(:david).  If you don't want to migrate your existing