diff options
author | 2010-07-07 11:11:20 +0200 | |
---|---|---|
committer | 2010-07-12 19:17:11 +0200 | |
commit | eeb8448766d00776516a71367bf8fb3a09cc8ece (patch) | |
tree | fb0933b9ddde57662b8b7962f6039962df7239b5 /db | |
parent | Allow users to suggest questions (diff) | |
download | recruiting-webapp-eeb8448766d00776516a71367bf8fb3a09cc8ece.tar.gz recruiting-webapp-eeb8448766d00776516a71367bf8fb3a09cc8ece.tar.bz2 recruiting-webapp-eeb8448766d00776516a71367bf8fb3a09cc8ece.zip |
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.
Diffstat (limited to 'db')
-rw-r--r-- | db/schema.rb | 20 |
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 |