spec/dummy/db/schema.rb in enju_leaf-1.2.0.beta.1 vs spec/dummy/db/schema.rb in enju_leaf-1.2.0.beta.2

- old
+ new

@@ -9,11 +9,11 @@ # from scratch. The latter is a flawed and unsustainable approach (the more migrations # you'll amass, the slower it'll run and the greater likelihood for issues). # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20160703185015) do +ActiveRecord::Schema.define(version: 20160703190209) do create_table "accepts", force: :cascade do |t| t.integer "basket_id" t.integer "item_id" t.integer "librarian_id" @@ -336,17 +336,19 @@ t.integer "checkout_renewal_count", default: 0, null: false t.integer "lock_version", default: 0, null: false t.datetime "created_at" t.datetime "updated_at" t.integer "shelf_id" + t.integer "library_id" end add_index "checkouts", ["basket_id"], name: "index_checkouts_on_basket_id" add_index "checkouts", ["checkin_id"], name: "index_checkouts_on_checkin_id" add_index "checkouts", ["item_id", "basket_id"], name: "index_checkouts_on_item_id_and_basket_id", unique: true add_index "checkouts", ["item_id"], name: "index_checkouts_on_item_id" add_index "checkouts", ["librarian_id"], name: "index_checkouts_on_librarian_id" + add_index "checkouts", ["library_id"], name: "index_checkouts_on_library_id" add_index "checkouts", ["shelf_id"], name: "index_checkouts_on_shelf_id" add_index "checkouts", ["user_id"], name: "index_checkouts_on_user_id" create_table "circulation_statuses", force: :cascade do |t| t.string "name", null: false @@ -355,10 +357,21 @@ t.integer "position" t.datetime "created_at" t.datetime "updated_at" end + create_table "colors", force: :cascade do |t| + t.integer "library_group_id" + t.string "property" + t.string "code" + t.integer "position" + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "colors", ["library_group_id"], name: "index_colors_on_library_group_id" + create_table "content_types", force: :cascade do |t| t.string "name", null: false t.text "display_name" t.text "note" t.integer "position" @@ -400,10 +413,22 @@ end add_index "creates", ["agent_id"], name: "index_creates_on_agent_id" add_index "creates", ["work_id"], name: "index_creates_on_work_id" + create_table "demands", force: :cascade do |t| + t.integer "user_id" + t.integer "item_id" + t.integer "message_id" + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + add_index "demands", ["item_id"], name: "index_demands_on_item_id" + add_index "demands", ["message_id"], name: "index_demands_on_message_id" + add_index "demands", ["user_id"], name: "index_demands_on_user_id" + create_table "donates", force: :cascade do |t| t.integer "agent_id", null: false t.integer "item_id", null: false t.datetime "created_at" t.datetime "updated_at" @@ -642,11 +667,14 @@ t.integer "position" t.integer "country_id" t.datetime "created_at" t.datetime "updated_at" t.datetime "deleted_at" + t.text "opening_hour" t.string "isil" + t.float "latitude" + t.float "longitude" end add_index "libraries", ["library_group_id"], name: "index_libraries_on_library_group_id" add_index "libraries", ["name"], name: "index_libraries_on_name", unique: true @@ -675,10 +703,11 @@ t.datetime "updated_at" t.text "admin_networks" t.boolean "allow_bookmark_external_url", default: false, null: false t.string "url", default: "http://localhost:3000/" t.text "settings" + t.text "html_snippet" end add_index "library_groups", ["short_name"], name: "index_library_groups_on_short_name" create_table "licenses", force: :cascade do |t| @@ -695,10 +724,11 @@ t.text "metadata", default: "{}" t.integer "sort_key" t.integer "manifestation_checkout_stat_id" t.datetime "created_at" t.datetime "updated_at" + t.boolean "most_recent" end add_index "manifestation_checkout_stat_transitions", ["manifestation_checkout_stat_id"], name: "index_manifestation_checkout_stat_transitions_on_stat_id" add_index "manifestation_checkout_stat_transitions", ["sort_key", "manifestation_checkout_stat_id"], name: "index_manifestation_checkout_stat_transitions_on_transition", unique: true @@ -741,10 +771,11 @@ t.text "metadata", default: "{}" t.integer "sort_key" t.integer "manifestation_reserve_stat_id" t.datetime "created_at" t.datetime "updated_at" + t.boolean "most_recent" end add_index "manifestation_reserve_stat_transitions", ["manifestation_reserve_stat_id"], name: "index_manifestation_reserve_stat_transitions_on_stat_id" add_index "manifestation_reserve_stat_transitions", ["sort_key", "manifestation_reserve_stat_id"], name: "index_manifestation_reserve_stat_transitions_on_transition", unique: true @@ -874,16 +905,15 @@ add_index "message_templates", ["status"], name: "index_message_templates_on_status", unique: true create_table "message_transitions", force: :cascade do |t| t.string "to_state" - t.text "metadata", default: "{}" + t.text "metadata", default: "{}" t.integer "sort_key" t.integer "message_id" t.datetime "created_at" t.datetime "updated_at" - t.boolean "most_recent" end add_index "message_transitions", ["message_id"], name: "index_message_transitions_on_message_id" add_index "message_transitions", ["sort_key", "message_id"], name: "index_message_transitions_on_sort_key_and_message_id", unique: true @@ -1044,15 +1074,16 @@ add_index "reserve_stat_has_users", ["user_id"], name: "index_reserve_stat_has_users_on_user_id" add_index "reserve_stat_has_users", ["user_reserve_stat_id"], name: "index_reserve_stat_has_users_on_user_reserve_stat_id" create_table "reserve_transitions", force: :cascade do |t| t.string "to_state" - t.text "metadata", default: "{}" + t.text "metadata", default: "{}" t.integer "sort_key" t.integer "reserve_id" t.datetime "created_at" t.datetime "updated_at" + t.boolean "most_recent" end add_index "reserve_transitions", ["reserve_id"], name: "index_reserve_transitions_on_reserve_id" add_index "reserve_transitions", ["sort_key", "reserve_id"], name: "index_reserve_transitions_on_sort_key_and_reserve_id", unique: true @@ -1067,17 +1098,19 @@ t.datetime "canceled_at" t.datetime "expired_at" t.datetime "deleted_at" t.boolean "expiration_notice_to_patron", default: false t.boolean "expiration_notice_to_library", default: false + t.integer "pickup_location_id" t.datetime "retained_at" t.datetime "postponed_at" t.integer "lock_version", default: 0, null: false end add_index "reserves", ["item_id"], name: "index_reserves_on_item_id" add_index "reserves", ["manifestation_id"], name: "index_reserves_on_manifestation_id" + add_index "reserves", ["pickup_location_id"], name: "index_reserves_on_pickup_location_id" add_index "reserves", ["request_status_type_id"], name: "index_reserves_on_request_status_type_id" add_index "reserves", ["user_id"], name: "index_reserves_on_user_id" create_table "resource_export_file_transitions", force: :cascade do |t| t.string "to_state" @@ -1339,10 +1372,11 @@ t.text "metadata", default: "{}" t.integer "sort_key" t.integer "user_checkout_stat_id" t.datetime "created_at" t.datetime "updated_at" + t.boolean "most_recent" end add_index "user_checkout_stat_transitions", ["sort_key", "user_checkout_stat_id"], name: "index_user_checkout_stat_transitions_on_sort_key_and_stat_id", unique: true add_index "user_checkout_stat_transitions", ["user_checkout_stat_id"], name: "index_user_checkout_stat_transitions_on_user_checkout_stat_id" @@ -1473,10 +1507,11 @@ t.text "metadata", default: "{}" t.integer "sort_key" t.integer "user_reserve_stat_id" t.datetime "created_at" t.datetime "updated_at" + t.boolean "most_recent" end add_index "user_reserve_stat_transitions", ["sort_key", "user_reserve_stat_id"], name: "index_user_reserve_stat_transitions_on_sort_key_and_stat_id", unique: true add_index "user_reserve_stat_transitions", ["user_reserve_stat_id"], name: "index_user_reserve_stat_transitions_on_user_reserve_stat_id" @@ -1523,17 +1558,17 @@ add_index "users", ["email"], name: "index_users_on_email" add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true add_index "users", ["unlock_token"], name: "index_users_on_unlock_token", unique: true add_index "users", ["username"], name: "index_users_on_username", unique: true - create_table "versions", force: :cascade do |t| - t.string "item_type", null: false - t.integer "item_id", null: false - t.string "event", null: false - t.string "whodunnit" - t.text "object" - t.datetime "created_at" + create_table "withdraws", force: :cascade do |t| + t.integer "basket_id" + t.integer "item_id" + t.integer "librarian_id" + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end - add_index "versions", ["item_type", "item_id"], name: "index_versions_on_item_type_and_item_id" + add_index "withdraws", ["basket_id"], name: "index_withdraws_on_basket_id" + add_index "withdraws", ["item_id"], name: "index_withdraws_on_item_id" end