spec/dummy/db/schema.rb in enju_ndl-0.2.0 vs spec/dummy/db/schema.rb in enju_ndl-0.2.1
- 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: 20160814165332) do
+ActiveRecord::Schema.define(version: 20160820004638) do
create_table "accepts", force: :cascade do |t|
t.integer "basket_id"
t.integer "item_id"
t.integer "librarian_id"
@@ -21,19 +21,19 @@
t.datetime "updated_at"
end
add_index "accepts", ["basket_id"], name: "index_accepts_on_basket_id"
add_index "accepts", ["item_id"], name: "index_accepts_on_item_id"
- add_index "accepts", ["librarian_id"], name: "index_accepts_on_librarian_id"
create_table "agent_import_file_transitions", force: :cascade do |t|
t.string "to_state"
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "agent_import_file_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "most_recent"
end
add_index "agent_import_file_transitions", ["agent_import_file_id"], name: "index_agent_import_file_transitions_on_agent_import_file_id"
add_index "agent_import_file_transitions", ["sort_key", "agent_import_file_id"], name: "index_agent_import_file_transitions_on_sort_key_and_file_id", unique: true
@@ -259,16 +259,20 @@
add_index "carrier_type_has_checkout_types", ["carrier_type_id"], name: "index_carrier_type_has_checkout_types_on_m_form_id"
add_index "carrier_type_has_checkout_types", ["checkout_type_id"], name: "index_carrier_type_has_checkout_types_on_checkout_type_id"
create_table "carrier_types", force: :cascade do |t|
- t.string "name", null: false
+ t.string "name", null: false
t.text "display_name"
t.text "note"
t.integer "position"
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "attachment_file_name"
+ t.string "attachment_content_type"
+ t.integer "attachment_file_size"
+ t.datetime "attachment_updated_at"
end
create_table "checked_items", force: :cascade do |t|
t.integer "item_id", null: false
t.integer "basket_id", null: false
@@ -608,10 +612,11 @@
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "import_request_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "most_recent"
end
add_index "import_request_transitions", ["import_request_id"], name: "index_import_request_transitions_on_import_request_id"
add_index "import_request_transitions", ["sort_key", "import_request_id"], name: "index_import_request_transitions_on_sort_key_and_request_id", unique: true
@@ -714,11 +719,11 @@
t.string "telephone_number_2"
t.string "fax_number"
t.text "note"
t.integer "call_number_rows", default: 1, null: false
t.string "call_number_delimiter", default: "|", null: false
- t.integer "library_group_id", null: false
+ t.integer "library_group_id", default: 1, null: false
t.integer "users_count", default: 0, null: false
t.integer "position"
t.integer "country_id"
t.datetime "created_at"
t.datetime "updated_at"
@@ -728,11 +733,11 @@
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"
+ add_index "libraries", ["name"], name: "index_libraries_on_name", unique: true
create_table "library_group_translations", force: :cascade do |t|
t.integer "library_group_id", null: false
t.string "locale", null: false
t.datetime "created_at", null: false
@@ -1030,10 +1035,12 @@
t.string "picture_content_type"
t.integer "picture_file_size"
t.datetime "picture_updated_at"
t.text "picture_meta"
t.string "picture_fingerprint"
+ t.integer "picture_width"
+ t.integer "picture_height"
end
add_index "picture_files", ["picture_attachable_id", "picture_attachable_type"], name: "index_picture_files_on_picture_attachable_id_and_type"
create_table "produce_types", force: :cascade do |t|
@@ -1182,10 +1189,11 @@
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "resource_export_file_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "most_recent"
end
add_index "resource_export_file_transitions", ["resource_export_file_id"], name: "index_resource_export_file_transitions_on_file_id"
add_index "resource_export_file_transitions", ["sort_key", "resource_export_file_id"], name: "index_resource_export_file_transitions_on_sort_key_and_file_id", unique: true
@@ -1205,10 +1213,11 @@
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "resource_import_file_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "most_recent"
end
add_index "resource_import_file_transitions", ["resource_import_file_id"], name: "index_resource_import_file_transitions_on_file_id"
add_index "resource_import_file_transitions", ["sort_key", "resource_import_file_id"], name: "index_resource_import_file_transitions_on_sort_key_and_file_id", unique: true
@@ -1316,11 +1325,11 @@
create_table "shelves", force: :cascade do |t|
t.string "name", null: false
t.text "display_name"
t.text "note"
- t.integer "library_id", null: false
+ t.integer "library_id", default: 1, null: false
t.integer "items_count", default: 0, null: false
t.integer "position"
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "deleted_at"
@@ -1462,11 +1471,10 @@
t.boolean "most_recent"
end
add_index "user_export_file_transitions", ["sort_key", "user_export_file_id"], name: "index_user_export_file_transitions_on_sort_key_and_file_id", unique: true
add_index "user_export_file_transitions", ["user_export_file_id"], name: "index_user_export_file_transitions_on_file_id"
- add_index "user_export_file_transitions", ["user_export_file_id"], name: "index_user_export_file_transitions_on_user_export_file_id"
create_table "user_export_files", force: :cascade do |t|
t.integer "user_id"
t.string "user_export_file_name"
t.string "user_export_content_type"
@@ -1475,12 +1483,10 @@
t.datetime "executed_at"
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "user_export_files", ["user_id"], name: "index_user_export_files_on_user_id"
-
create_table "user_group_has_checkout_types", force: :cascade do |t|
t.integer "user_group_id", null: false
t.integer "checkout_type_id", null: false
t.integer "checkout_limit", default: 0, null: false
t.integer "checkout_period", default: 0, null: false
@@ -1553,24 +1559,19 @@
t.string "user_encoding"
t.integer "default_library_id"
t.integer "default_user_group_id"
end
- add_index "user_import_files", ["user_id"], name: "index_user_import_files_on_user_id"
-
create_table "user_import_results", force: :cascade do |t|
t.integer "user_import_file_id"
t.integer "user_id"
t.text "body"
t.datetime "created_at"
t.datetime "updated_at"
t.text "error_message"
end
- add_index "user_import_results", ["user_id"], name: "index_user_import_results_on_user_id"
- add_index "user_import_results", ["user_import_file_id"], name: "index_user_import_results_on_user_import_file_id"
-
create_table "user_reserve_stat_transitions", force: :cascade do |t|
t.string "to_state"
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "user_reserve_stat_id"
@@ -1643,8 +1644,7 @@
t.datetime "updated_at", null: false
end
add_index "withdraws", ["basket_id"], name: "index_withdraws_on_basket_id"
add_index "withdraws", ["item_id"], name: "index_withdraws_on_item_id"
- add_index "withdraws", ["librarian_id"], name: "index_withdraws_on_librarian_id"
end