spec/dummy/db/schema.rb in enju_search_log-0.2.0.beta.1 vs spec/dummy/db/schema.rb in enju_search_log-0.2.0.beta.3
- 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: 20150221063719) do
+ActiveRecord::Schema.define(version: 20160814165332) do
create_table "accepts", force: :cascade do |t|
t.integer "basket_id"
t.integer "item_id"
t.integer "librarian_id"
@@ -96,28 +96,115 @@
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
+ 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
+ t.datetime "updated_at", null: false
+ t.text "login_banner"
+ t.text "footer_banner"
+ end
+
+ add_index "library_group_translations", ["library_group_id"], name: "index_library_group_translations_on_library_group_id"
+ add_index "library_group_translations", ["locale"], name: "index_library_group_translations_on_locale"
+
create_table "library_groups", force: :cascade do |t|
- t.string "name", null: false
+ t.string "name", null: false
t.text "display_name"
- t.string "short_name", null: false
+ t.string "short_name", null: false
t.text "my_networks"
t.text "login_banner"
t.text "note"
t.integer "country_id"
t.integer "position"
t.datetime "created_at"
t.datetime "updated_at"
t.text "admin_networks"
- t.string "url", default: "http://localhost:3000/"
+ t.string "url", default: "http://localhost:3000/"
t.text "settings"
+ t.text "html_snippet"
+ t.integer "max_number_of_results", default: 500
+ t.boolean "family_name_first", default: true
+ t.integer "pub_year_facet_range_interval", default: 10
+ t.integer "user_id"
end
add_index "library_groups", ["short_name"], name: "index_library_groups_on_short_name"
+ add_index "library_groups", ["user_id"], name: "index_library_groups_on_user_id"
+ create_table "message_request_transitions", force: :cascade do |t|
+ t.string "to_state"
+ t.text "metadata", default: "{}"
+ t.integer "sort_key"
+ t.integer "message_request_id"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.boolean "most_recent"
+ end
+
+ add_index "message_request_transitions", ["message_request_id"], name: "index_message_request_transitions_on_message_request_id"
+ add_index "message_request_transitions", ["sort_key", "message_request_id"], name: "index_message_request_transitions_on_sort_key_and_request_id", unique: true
+
+ create_table "message_requests", force: :cascade do |t|
+ t.integer "sender_id"
+ t.integer "receiver_id"
+ t.integer "message_template_id"
+ t.datetime "sent_at"
+ t.datetime "deleted_at"
+ t.text "body"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ create_table "message_templates", force: :cascade do |t|
+ t.string "status", null: false
+ t.text "title", null: false
+ t.text "body", null: false
+ t.integer "position"
+ t.string "locale", default: "en"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ 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.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
+
+ create_table "messages", force: :cascade do |t|
+ t.datetime "read_at"
+ t.integer "receiver_id"
+ t.integer "sender_id"
+ t.string "subject", null: false
+ t.text "body"
+ t.integer "message_request_id"
+ t.integer "parent_id"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.integer "lft"
+ t.integer "rgt"
+ t.integer "depth"
+ end
+
+ add_index "messages", ["message_request_id"], name: "index_messages_on_message_request_id"
+ add_index "messages", ["parent_id"], name: "index_messages_on_parent_id"
+ add_index "messages", ["receiver_id"], name: "index_messages_on_receiver_id"
+ add_index "messages", ["sender_id"], name: "index_messages_on_sender_id"
+
create_table "profiles", force: :cascade do |t|
t.integer "user_id"
t.integer "user_group_id"
t.integer "library_id"
t.string "locale"
@@ -251,10 +338,11 @@
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "user_export_file_id"
t.datetime "created_at"
t.datetime "updated_at"
+ 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"
@@ -296,10 +384,11 @@
t.text "metadata", default: "{}"
t.integer "sort_key"
t.integer "user_import_file_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "most_recent"
end
add_index "user_import_file_transitions", ["sort_key", "user_import_file_id"], name: "index_user_import_file_transitions_on_sort_key_and_file_id", unique: true
add_index "user_import_file_transitions", ["user_import_file_id"], name: "index_user_import_file_transitions_on_user_import_file_id"
@@ -307,11 +396,11 @@
t.integer "user_id"
t.text "note"
t.datetime "executed_at"
t.string "user_import_file_name"
t.string "user_import_content_type"
- t.string "user_import_file_size"
+ t.integer "user_import_file_size"
t.datetime "user_import_updated_at"
t.string "user_import_fingerprint"
t.string "edit_mode"
t.text "error_message"
t.datetime "created_at"
@@ -325,10 +414,11 @@
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
create_table "users", force: :cascade do |t|
t.string "email", default: "", null: false
t.string "encrypted_password", default: "", null: false
@@ -365,7 +455,18 @@
t.text "object"
t.datetime "created_at"
end
add_index "versions", ["item_type", "item_id"], name: "index_versions_on_item_type_and_item_id"
+
+ 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 "withdraws", ["basket_id"], name: "index_withdraws_on_basket_id"
+ add_index "withdraws", ["item_id"], name: "index_withdraws_on_item_id"
end