db/schema.rb in iqvoc-4.11.1 vs db/schema.rb in iqvoc-4.12.0
- old
+ new
@@ -9,203 +9,205 @@
# 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: 20_150_317_162_953) do
- 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
+ActiveRecord::Schema.define(version: 20170626074649) do
+
+ 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', %w(collection_id target_id type), name: 'ix_collections_fk_type', using: :btree
- add_index 'collection_members', ['target_id'], name: 'fk_rails_2a51b48094', using: :btree
+ 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_2a51b48094", using: :btree
- 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
+ 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', %w(owner_id target_id), name: 'ix_concept_relations_fk', using: :btree
- add_index 'concept_relations', ['target_id'], name: 'fk_rails_fd6c6e6fd7', using: :btree
+ add_index "concept_relations", ["owner_id", "target_id"], name: "ix_concept_relations_fk", using: :btree
+ add_index "concept_relations", ["target_id"], name: "fk_rails_fd6c6e6fd7", using: :btree
- 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
- t.integer 'locked_by', limit: 4
- t.date 'expired_at'
- t.date 'follow_up'
- t.boolean 'to_review'
- t.date 'rdf_updated_at'
- t.datetime 'created_at'
- t.datetime 'updated_at'
- t.boolean 'top_term', default: false
+ 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
+ t.integer "locked_by", limit: 4
+ t.date "expired_at"
+ t.date "follow_up"
+ t.boolean "to_review"
+ t.date "rdf_updated_at"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.boolean "top_term", default: false
end
- add_index 'concepts', ['locked_by'], name: 'fk_rails_69655c7fd3', 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
+ add_index "concepts", ["locked_by"], name: "fk_rails_69655c7fd3", 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: :cascade do |t|
- t.string 'key', limit: 255
- t.string 'value', limit: 255
+ create_table "configuration_settings", force: :cascade do |t|
+ t.string "key", limit: 255
+ t.string "value", limit: 255
end
- 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: 65_535, null: false
- t.text 'last_error', limit: 65_535
- t.datetime 'run_at'
- t.datetime 'locked_at'
- t.datetime 'failed_at'
- 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
+ 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.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', %w(priority run_at), name: 'delayed_jobs_priority', using: :btree
- add_index 'delayed_jobs', ['queue'], name: 'delayed_jobs_queue', using: :btree
+ 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: :cascade do |t|
- t.integer 'user_id', limit: 4
- t.text 'output', limit: 65_535
- t.boolean 'success', default: false
- t.integer 'file_type', limit: 4
- t.string 'token', limit: 255
- t.datetime 'created_at'
- t.datetime 'updated_at'
- t.datetime 'finished_at'
- t.string 'default_namespace', limit: 255
+ create_table "exports", force: :cascade do |t|
+ t.integer "user_id", limit: 4
+ t.text "output", limit: 4294967295
+ t.boolean "success", default: false
+ t.integer "file_type", limit: 4
+ t.string "token", limit: 255
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.datetime "finished_at"
+ t.string "default_namespace", limit: 255
end
- add_index 'exports', ['user_id'], name: 'index_exports_on_user_id', using: :btree
+ add_index "exports", ["user_id"], name: "index_exports_on_user_id", using: :btree
- create_table 'imports', force: :cascade do |t|
- t.integer 'user_id', limit: 4
- t.text 'output', limit: 65_535
- t.boolean 'success', default: false
- t.datetime 'created_at'
- t.datetime 'updated_at'
- t.datetime 'finished_at'
- t.string 'import_file', limit: 255
- t.boolean 'publish'
- t.string 'default_namespace', limit: 255
+ create_table "imports", force: :cascade do |t|
+ t.integer "user_id", limit: 4
+ t.text "output", limit: 4294967295
+ t.boolean "success", default: false
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.datetime "finished_at"
+ t.string "import_file", limit: 255
+ t.boolean "publish"
+ t.string "default_namespace", limit: 255
end
- add_index 'imports', ['user_id'], name: 'index_imports_on_user_id', using: :btree
+ add_index "imports", ["user_id"], name: "index_imports_on_user_id", using: :btree
- 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'
+ 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', %w(owner_id target_id type), name: 'ix_labelings_fk_type', using: :btree
- add_index 'labelings', ['target_id'], name: 'fk_rails_5897707e64', using: :btree
- add_index 'labelings', ['type'], name: 'ix_labelings_on_type', using: :btree
+ add_index "labelings", ["owner_id", "target_id", "type"], name: "ix_labelings_fk_type", using: :btree
+ add_index "labelings", ["target_id"], name: "fk_rails_5897707e64", using: :btree
+ add_index "labelings", ["type"], name: "ix_labelings_on_type", using: :btree
- 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'
- t.datetime 'updated_at'
- t.date 'published_at'
+ 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"
+ t.datetime "updated_at"
+ t.date "published_at"
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
+ 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: :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'
+ 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', %w(concept_id type), name: 'ix_matches_fk_type', using: :btree
- add_index 'matches', ['type'], name: 'ix_matches_on_type', using: :btree
+ 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: :cascade do |t|
- t.integer 'concept_id', limit: 4
- t.string 'value', limit: 4000
- t.string 'data_type', limit: 4000
+ 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
+ add_index "notations", ["concept_id"], name: "index_notations_on_concept_id", using: :btree
- 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'
- t.string 'namespace', limit: 50
- t.string 'language', limit: 255
+ 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"
+ t.string "namespace", limit: 50
+ t.string "language", limit: 255
end
- add_index 'note_annotations', ['note_id'], name: 'ix_note_annotations_fk', using: :btree
+ add_index "note_annotations", ["note_id"], name: "ix_note_annotations_fk", using: :btree
+ add_index "note_annotations", ["value"], name: "index_note_annotations_on_value", using: :btree
- 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'
- t.integer 'owner_id', limit: 4
- t.string 'owner_type', limit: 255, null: false
+ 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"
+ t.integer "owner_id", limit: 4
+ t.string "owner_type", limit: 255, null: false
end
- add_index 'notes', ['language'], name: 'ix_notes_on_language', using: :btree
- add_index 'notes', %w(owner_id owner_type type), name: 'ix_notes_fk_type', using: :btree
- add_index 'notes', ['type'], name: 'ix_notes_on_type', using: :btree
+ 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: :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'
- t.datetime 'created_at'
- t.datetime 'updated_at'
- 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, default: 'User'
+ 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"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ 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, 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
- add_foreign_key 'concept_relations', 'concepts', column: 'target_id', on_update: :cascade
- add_foreign_key 'concepts', 'users', column: 'locked_by', on_update: :cascade, on_delete: :nullify
- add_foreign_key 'exports', 'users', on_update: :cascade, on_delete: :nullify
- add_foreign_key 'imports', 'users', on_update: :cascade, on_delete: :nullify
- 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 "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
+ add_foreign_key "concept_relations", "concepts", column: "target_id", on_update: :cascade
+ add_foreign_key "concepts", "users", column: "locked_by", on_update: :cascade, on_delete: :nullify
+ add_foreign_key "exports", "users", on_update: :cascade, on_delete: :nullify
+ add_foreign_key "imports", "users", on_update: :cascade, on_delete: :nullify
+ 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
end