db/schema.rb in iqvoc-3.2.11 vs db/schema.rb in iqvoc-3.3.0
- old
+ new
@@ -7,208 +7,122 @@
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# 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.
+# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(version: 20141204151558) do
+ActiveRecord::Schema.define(:version => 20110615134040) do
- create_table "collection_members", force: true do |t|
- t.integer "collection_id", limit: 4
- t.integer "target_id", limit: 4
- t.string "type", limit: 255
+ create_table "collection_members", :force => true do |t|
+ t.integer "collection_id"
+ t.integer "target_id"
+ t.string "type"
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", ["collection_id", "target_id", "type"], :name => "ix_collections_fk_type"
- create_table "concept_relations", force: true do |t|
- t.string "type", limit: 255
- t.integer "owner_id", limit: 4
- t.integer "target_id", limit: 4
+ create_table "concept_relations", :force => true do |t|
+ t.string "type"
+ t.integer "owner_id"
+ t.integer "target_id"
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", ["owner_id", "target_id"], :name => "ix_concept_relations_fk"
- create_table "concepts", force: true do |t|
- t.string "type", limit: 255
- t.string "origin", limit: 4000
- t.integer "rev", limit: 4, default: 1
+ create_table "concepts", :force => true do |t|
+ t.string "type"
+ t.string "origin", :limit => 4000
+ t.integer "rev", :default => 1
t.date "published_at"
- t.integer "published_version_id", limit: 4
- t.integer "locked_by", limit: 4
+ t.integer "published_version_id"
+ t.integer "locked_by"
t.date "expired_at"
t.date "follow_up"
- t.boolean "to_review", limit: 1
+ t.boolean "to_review"
t.date "rdf_updated_at"
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", ["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", ["origin"], :name => "ix_concepts_on_origin", :length => {"origin"=>255}
+ add_index "concepts", ["published_version_id"], :name => "ix_concepts_publ_version_id"
- create_table "configuration_settings", force: true 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
- t.datetime "run_at"
- t.datetime "locked_at"
- t.datetime "failed_at"
- t.string "locked_by", limit: 255
- t.string "queue", limit: 255
+ create_table "labelings", :force => true do |t|
+ t.string "type"
+ t.integer "owner_id"
+ t.integer "target_id"
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree
+ add_index "labelings", ["owner_id", "target_id", "type"], :name => "ix_labelings_fk_type"
+ add_index "labelings", ["type"], :name => "ix_labelings_on_type"
- create_table "exports", force: true 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
+ create_table "labels", :force => true do |t|
+ t.string "type"
+ t.string "origin", :limit => 4000
+ t.string "language"
+ t.string "value", :limit => 1024
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
-
- create_table "imports", force: true 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"
- t.datetime "finished_at"
- t.string "import_file", limit: 255
- t.boolean "publish", limit: 1
- 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|
- 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", ["type"], name: "ix_labelings_on_type", using: :btree
-
- create_table "labels", force: true 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"
+ add_index "labels", ["origin"], :name => "ix_labels_on_origin", :length => {"origin"=>255}
+ add_index "labels", ["value"], :name => "ix_labels_on_value", :length => {"value"=>255}
- create_table "matches", force: true do |t|
- t.integer "concept_id", limit: 4
- t.string "type", limit: 255
- t.string "value", limit: 255
+ create_table "matches", :force => true do |t|
+ t.integer "concept_id"
+ t.string "type"
+ t.string "value"
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
+ add_index "matches", ["concept_id", "type"], :name => "ix_matches_fk_type"
+ add_index "matches", ["type"], :name => "ix_matches_on_type"
- create_table "notations", force: true 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|
- t.integer "note_id", limit: 4
- t.string "predicate", limit: 50
- t.string "value", limit: 1024
+ create_table "note_annotations", :force => true do |t|
+ t.integer "note_id"
+ 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
+ t.string "namespace", :limit => 50
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"
- create_table "notes", force: true do |t|
- t.string "language", limit: 2
- t.string "value", limit: 4000
- t.string "type", limit: 50
+ create_table "notes", :force => true 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
+ t.integer "owner_id"
+ t.string "owner_type", :null => false
end
- 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
+ add_index "notes", ["language"], :name => "ix_notes_on_language"
+ add_index "notes", ["owner_id", "owner_type", "type"], :name => "ix_notes_fk_type"
+ add_index "notes", ["type"], :name => "ix_notes_on_type"
- create_table "users", force: true 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
+ create_table "users", :force => true do |t|
+ t.string "forename"
+ t.string "surname"
+ t.string "email"
+ t.string "crypted_password"
+ 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
+ t.string "password_salt"
+ t.string "persistence_token"
+ t.string "perishable_token"
+ t.string "role"
+ t.string "telephone_number"
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 "notes", "concepts", column: "owner_id", on_update: :cascade, on_delete: :cascade
end