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