db/schema.rb in iqvoc-4.8.2 vs db/schema.rb in iqvoc-4.9.0
- old
+ new
@@ -9,34 +9,34 @@
# 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: 20141204151558) do
+ActiveRecord::Schema.define(version: 20150317162953) do
- create_table "collection_members", force: true do |t|
+ create_table "collection_members", force: :cascade do |t|
t.integer "collection_id", limit: 4
t.integer "target_id", limit: 4
t.string "type", limit: 255
end
add_index "collection_members", ["collection_id", "target_id", "type"], name: "ix_collections_fk_type", using: :btree
- add_index "collection_members", ["target_id"], name: "fk_rails_207ac01588", using: :btree
+ add_index "collection_members", ["target_id"], name: "fk_rails_677feefc03", using: :btree
- create_table "concept_relations", force: true do |t|
+ create_table "concept_relations", force: :cascade do |t|
t.string "type", limit: 255
t.integer "owner_id", limit: 4
t.integer "target_id", limit: 4
t.datetime "created_at"
t.datetime "updated_at"
t.integer "rank", limit: 4, default: 100
end
add_index "concept_relations", ["owner_id", "target_id"], name: "ix_concept_relations_fk", using: :btree
- add_index "concept_relations", ["target_id"], name: "fk_rails_59b5dcff61", using: :btree
+ add_index "concept_relations", ["target_id"], name: "fk_rails_fdb9a8342e", using: :btree
- create_table "concepts", force: true do |t|
+ create_table "concepts", force: :cascade do |t|
t.string "type", limit: 255
t.string "origin", limit: 4000
t.integer "rev", limit: 4, default: 1
t.date "published_at"
t.integer "published_version_id", limit: 4
@@ -48,36 +48,44 @@
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "top_term", limit: 1, default: false
end
- add_index "concepts", ["locked_by"], name: "fk_rails_9ab9124960", using: :btree
+ add_index "concepts", ["locked_by"], name: "fk_rails_be867cf8c7", using: :btree
add_index "concepts", ["origin"], name: "ix_concepts_on_origin", length: {"origin"=>255}, using: :btree
add_index "concepts", ["published_version_id"], name: "ix_concepts_publ_version_id", using: :btree
- create_table "configuration_settings", force: true do |t|
+ create_table "configuration_settings", force: :cascade do |t|
t.string "key", limit: 255
t.string "value", limit: 255
end
- create_table "delayed_jobs", force: true do |t|
- t.integer "priority", limit: 4, default: 0, null: false
- t.integer "attempts", limit: 4, default: 0, null: false
- t.text "handler", limit: 65535, null: false
- t.text "last_error", limit: 65535
+ create_table "delayed_jobs", force: :cascade do |t|
+ t.integer "priority", limit: 4, default: 0, null: false
+ t.integer "attempts", limit: 4, default: 0, null: false
+ t.text "handler", limit: 65535, null: false
+ t.text "last_error", limit: 65535
t.datetime "run_at"
t.datetime "locked_at"
t.datetime "failed_at"
- t.string "locked_by", limit: 255
- t.string "queue", limit: 255
+ t.string "locked_by", limit: 255
+ t.string "queue", limit: 255
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "error_message", limit: 255
+ t.string "delayed_reference_type", limit: 255
+ t.integer "delayed_reference_id", limit: 4
+ t.string "delayed_global_reference_id", limit: 255
end
+ add_index "delayed_jobs", ["delayed_global_reference_id"], name: "delayed_jobs_delayed_global_reference_id", using: :btree
+ add_index "delayed_jobs", ["delayed_reference_id"], name: "delayed_jobs_delayed_reference_id", using: :btree
+ add_index "delayed_jobs", ["delayed_reference_type"], name: "delayed_jobs_delayed_reference_type", using: :btree
add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree
+ add_index "delayed_jobs", ["queue"], name: "delayed_jobs_queue", using: :btree
- create_table "exports", force: true do |t|
+ create_table "exports", force: :cascade do |t|
t.integer "user_id", limit: 4
t.text "output", limit: 65535
t.boolean "success", limit: 1, default: false
t.integer "file_type", limit: 4
t.string "token", limit: 255
@@ -87,11 +95,11 @@
t.string "default_namespace", limit: 255
end
add_index "exports", ["user_id"], name: "index_exports_on_user_id", using: :btree
- create_table "imports", force: true do |t|
+ create_table "imports", force: :cascade do |t|
t.integer "user_id", limit: 4
t.text "output", limit: 65535
t.boolean "success", limit: 1, default: false
t.datetime "created_at"
t.datetime "updated_at"
@@ -101,32 +109,23 @@
t.string "default_namespace", limit: 255
end
add_index "imports", ["user_id"], name: "index_imports_on_user_id", using: :btree
- create_table "job_relations", force: true do |t|
- t.string "type", limit: 255
- t.string "owner_reference", limit: 255
- t.string "job_id", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
- t.string "response_error", limit: 255
- end
-
- create_table "labelings", force: true do |t|
+ create_table "labelings", force: :cascade do |t|
t.string "type", limit: 255
t.integer "owner_id", limit: 4
t.integer "target_id", limit: 4
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "labelings", ["owner_id", "target_id", "type"], name: "ix_labelings_fk_type", using: :btree
- add_index "labelings", ["target_id"], name: "fk_rails_d3560f2025", using: :btree
+ add_index "labelings", ["target_id"], name: "fk_rails_4926ce64b9", using: :btree
add_index "labelings", ["type"], name: "ix_labelings_on_type", using: :btree
- create_table "labels", force: true do |t|
+ create_table "labels", force: :cascade do |t|
t.string "type", limit: 255
t.string "origin", limit: 4000
t.string "language", limit: 255
t.string "value", limit: 1024
t.datetime "created_at"
@@ -135,30 +134,30 @@
end
add_index "labels", ["language"], name: "ix_labels_on_language", using: :btree
add_index "labels", ["origin"], name: "ix_labels_on_origin", length: {"origin"=>255}, using: :btree
- create_table "matches", force: true do |t|
+ create_table "matches", force: :cascade do |t|
t.integer "concept_id", limit: 4
t.string "type", limit: 255
t.string "value", limit: 255
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "matches", ["concept_id", "type"], name: "ix_matches_fk_type", using: :btree
add_index "matches", ["type"], name: "ix_matches_on_type", using: :btree
- create_table "notations", force: true do |t|
+ create_table "notations", force: :cascade do |t|
t.integer "concept_id", limit: 4
t.string "value", limit: 4000
t.string "data_type", limit: 4000
end
add_index "notations", ["concept_id"], name: "index_notations_on_concept_id", using: :btree
- create_table "note_annotations", force: true do |t|
+ create_table "note_annotations", force: :cascade do |t|
t.integer "note_id", limit: 4
t.string "predicate", limit: 50
t.string "value", limit: 1024
t.datetime "created_at"
t.datetime "updated_at"
@@ -166,11 +165,11 @@
t.string "language", limit: 255
end
add_index "note_annotations", ["note_id"], name: "ix_note_annotations_fk", using: :btree
- create_table "notes", force: true do |t|
+ create_table "notes", force: :cascade do |t|
t.string "language", limit: 2
t.string "value", limit: 4000
t.string "type", limit: 50
t.datetime "created_at"
t.datetime "updated_at"
@@ -180,11 +179,11 @@
add_index "notes", ["language"], name: "ix_notes_on_language", using: :btree
add_index "notes", ["owner_id", "owner_type", "type"], name: "ix_notes_fk_type", using: :btree
add_index "notes", ["type"], name: "ix_notes_on_type", using: :btree
- create_table "users", force: true do |t|
+ create_table "users", force: :cascade do |t|
t.string "forename", limit: 255
t.string "surname", limit: 255
t.string "email", limit: 255
t.string "crypted_password", limit: 255
t.boolean "active", limit: 1
@@ -193,11 +192,11 @@
t.string "password_salt", limit: 255
t.string "persistence_token", limit: 255
t.string "perishable_token", limit: 255
t.string "role", limit: 255
t.string "telephone_number", limit: 255
- t.string "type", limit: 255
+ t.string "type", limit: 255, default: "User"
end
add_foreign_key "collection_members", "concepts", column: "collection_id", on_update: :cascade
add_foreign_key "collection_members", "concepts", column: "target_id", on_update: :cascade
add_foreign_key "concept_relations", "concepts", column: "owner_id", on_update: :cascade
@@ -208,7 +207,6 @@
add_foreign_key "labelings", "concepts", column: "owner_id", on_update: :cascade
add_foreign_key "labelings", "labels", column: "target_id", on_update: :cascade, on_delete: :cascade
add_foreign_key "matches", "concepts", on_update: :cascade, on_delete: :cascade
add_foreign_key "notations", "concepts", on_update: :cascade
add_foreign_key "note_annotations", "notes", on_update: :cascade, on_delete: :cascade
- add_foreign_key "notes", "concepts", column: "owner_id", on_update: :cascade, on_delete: :cascade
end