User may view and answer only one randomly chosen question from group

When adding user to category associate user with one question from each
group in this category. Feature to make sure question listings are
correct.

1 files changed, 19 insertions, 1 deletions

diff --git a/db/schema.rb b/db/schema.rb
index 65124ef..c45c263 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20100708182335) do
+ActiveRecord::Schema.define(:version => 20100708182355) do
 
   create_table "answers", :force => true do |t|
     t.text     "content"
@@ -51,6 +51,12 @@ ActiveRecord::Schema.define(:version => 20100708182335) do
     t.datetime "updated_at"
   end
 
+  create_table "question_groups", :force => true do |t|
+    t.string   "name",       :null => false
+    t.datetime "created_at"
+    t.datetime "updated_at"
+  end
+
   create_table "questions", :force => true do |t|
     t.string   "title"
     t.text     "content"
@@ -60,9 +66,11 @@ ActiveRecord::Schema.define(:version => 20100708182335) do
     t.datetime "updated_at"
     t.integer  "user_id"
     t.integer  "question_category_id"
+    t.integer  "question_group_id"
   end
 
   add_index "questions", ["question_category_id"], :name => "index_questions_on_question_category_id"
+  add_index "questions", ["question_group_id"], :name => "index_questions_on_question_group_id"
   add_index "questions", ["user_id"], :name => "index_questions_on_user_id"
 
   create_table "user_categories", :force => true do |t|
@@ -75,6 +83,16 @@ ActiveRecord::Schema.define(:version => 20100708182335) do
   add_index "user_categories", ["question_category_id"], :name => "index_user_categories_on_question_category_id"
   add_index "user_categories", ["user_id"], :name => "index_user_categories_on_user_id"
 
+  create_table "user_question_groups", :force => true do |t|
+    t.datetime "created_at"
+    t.datetime "updated_at"
+    t.integer  "user_id"
+    t.integer  "question_id"
+  end
+
+  add_index "user_question_groups", ["question_id"], :name => "index_user_question_groups_on_question_id"
+  add_index "user_question_groups", ["user_id"], :name => "index_user_question_groups_on_user_id"
+
   create_table "users", :force => true do |t|
     t.string   "crypted_password",          :limit => 40
     t.string   "salt",                      :limit => 40