spec/dummy/db/schema.rb in bit_player-0.4.10 vs spec/dummy/db/schema.rb in bit_player-0.5.0

@@ -14,21 +14,20 @@
 ActiveRecord::Schema.define(version: 20140620222851) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
 
-  create_table "bit_core_content_modules", force: true do |t|
+  create_table "bit_core_content_modules", force: :cascade do |t|
     t.string   "title",                        null: false
     t.integer  "position",         default: 1, null: false
     t.integer  "bit_core_tool_id",             null: false
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.index ["bit_core_tool_id", "position"], name: "bit_core_content_module_position", unique: true, using: :btree
   end
 
-  add_index "bit_core_content_modules", ["bit_core_tool_id", "position"], name: "bit_core_content_module_position", unique: true, using: :btree
-
-  create_table "bit_core_content_providers", force: true do |t|
+  create_table "bit_core_content_providers", force: :cascade do |t|
     t.string   "type",                                   null: false
     t.string   "source_content_type"
     t.integer  "source_content_id"
     t.integer  "bit_core_content_module_id",             null: false
     t.integer  "position",                   default: 1, null: false
@@ -37,51 +36,50 @@
     t.string   "template_path"
     t.string   "data_class_name"
     t.text     "data_attributes"
     t.boolean  "show_next_nav"
     t.text     "locals"
+    t.index ["bit_core_content_module_id", "position"], name: "bit_core_content_provider_position", unique: true, using: :btree
   end
 
-  add_index "bit_core_content_providers", ["bit_core_content_module_id", "position"], name: "bit_core_content_provider_position", unique: true, using: :btree
-
-  create_table "bit_core_slides", force: true do |t|
+  create_table "bit_core_slides", force: :cascade do |t|
     t.string   "title",                                null: false
     t.text     "body",                                 null: false
     t.integer  "position",              default: 1,    null: false
     t.integer  "bit_core_slideshow_id",                null: false
     t.string   "type"
     t.boolean  "is_title_visible",      default: true, null: false
     t.datetime "created_at"
     t.datetime "updated_at"
     t.text     "options"
+    t.index ["bit_core_slideshow_id", "position"], name: "bit_core_slide_position", unique: true, using: :btree
   end
 
-  add_index "bit_core_slides", ["bit_core_slideshow_id", "position"], name: "bit_core_slide_position", unique: true, using: :btree
-
-  create_table "bit_core_slideshows", force: true do |t|
+  create_table "bit_core_slideshows", force: :cascade do |t|
     t.string   "title",      null: false
     t.datetime "created_at"
     t.datetime "updated_at"
   end
 
-  create_table "bit_core_tools", force: true do |t|
+  create_table "bit_core_tools", force: :cascade do |t|
     t.string   "title",                  null: false
     t.integer  "position",   default: 0, null: false
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.index ["position"], name: "bit_core_tool_position", unique: true, using: :btree
   end
 
-  add_index "bit_core_tools", ["position"], name: "bit_core_tool_position", unique: true, using: :btree
-
-  create_table "bit_player_participant_statuses", force: true do |t|
+  create_table "bit_player_participant_statuses", force: :cascade do |t|
     t.string   "context"
     t.integer  "module_position"
     t.integer  "provider_position"
     t.integer  "content_position"
     t.integer  "participant_id",    null: false
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.index ["participant_id"], name: "index_participant_statuses_on_participant_id", using: :btree
   end
 
-  add_index "bit_player_participant_statuses", ["participant_id"], name: "index_participant_statuses_on_participant_id", using: :btree
-
+  add_foreign_key "bit_core_content_modules", "bit_core_tools", name: "fk_content_modules_tools"
+  add_foreign_key "bit_core_content_providers", "bit_core_content_modules", name: "fk_content_providers_modules"
+  add_foreign_key "bit_core_slides", "bit_core_slideshows", name: "fk_slideshows_slides"
 end