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