Modified: trunk/db/schema.rb (3232 => 3233)
--- trunk/db/schema.rb 2012-12-06 12:33:15 UTC (rev 3232)
+++ trunk/db/schema.rb 2012-12-06 12:33:21 UTC (rev 3233)
@@ -145,17 +145,17 @@
create_table "concept_relations", :force => true do |t|
t.integer "subject_concept_id"
- t.string "relation_type"
t.integer "object_concept_id"
+ t.string "relation_type"
end
create_table "concepts", :force => true do |t|
- t.datetime "updated_at"
- t.text "description_html"
- t.string "phrase"
t.text "description"
+ t.string "phrase"
+ t.text "description_html"
t.integer "vocabulary_id"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "content_blobs", :force => true do |t|
@@ -169,33 +169,33 @@
create_table "content_types", :force => true do |t|
t.integer "user_id"
- t.string "title"
t.text "description"
- t.text "description_html"
+ t.string "title"
t.string "mime_type"
+ t.string "category"
+ t.text "description_html"
t.datetime "created_at"
t.datetime "updated_at"
- t.string "category"
end
create_table "contributions", :force => true do |t|
- t.integer "contributor_id"
- t.string "contributor_type"
+ t.float "rating"
+ t.integer "site_viewings_count", :default => 0
t.integer "contributable_id"
- t.string "contributable_type"
+ t.integer "contributor_id"
t.integer "policy_id"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.integer "downloads_count", :default => 0
- t.integer "viewings_count", :default => 0
- t.float "rating"
t.float "rank"
- t.integer "content_type_id"
- t.integer "license_id"
- t.integer "site_downloads_count", :default => 0
- t.integer "site_viewings_count", :default => 0
t.string "label"
+ t.integer "site_downloads_count", :default => 0
+ t.integer "downloads_count", :default => 0
+ t.integer "content_type_id"
+ t.integer "viewings_count", :default => 0
+ t.string "contributable_type"
+ t.datetime "created_at"
t.string "layout"
+ t.integer "license_id"
+ t.datetime "updated_at"
+ t.string "contributor_type"
end
add_index "contributions", ["contributable_id", "contributable_type"], :name => "index_contributions_on_contributable_id_and_contributable_type"
@@ -228,12 +228,12 @@
end
create_table "downloads", :force => true do |t|
- t.integer "contribution_id"
t.integer "user_id"
+ t.integer "contribution_id"
+ t.string "kind"
+ t.boolean "accessed_from_site", :default => false
t.datetime "created_at"
t.string "user_agent"
- t.boolean "accessed_from_site", :default => false
- t.string "kind"
end
add_index "downloads", ["contribution_id"], :name => "index_downloads_on_contribution_id"
@@ -307,10 +307,10 @@
create_table "labels", :force => true do |t|
t.integer "concept_id"
+ t.string "label_type"
t.string "language"
- t.string "text"
t.integer "vocabulary_id"
- t.string "label_type"
+ t.string "text"
end
create_table "license_attributes", :force => true do |t|
@@ -405,46 +405,46 @@
add_index "oauth_tokens", ["token"], :name => "index_oauth_tokens_on_token", :unique => true
create_table "ontologies", :force => true do |t|
- t.string "prefix"
- t.datetime "updated_at"
t.string "uri"
+ t.integer "user_id"
+ t.text "description"
t.string "title"
t.text "description_html"
- t.text "description"
- t.integer "user_id"
+ t.string "prefix"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "pack_contributable_entries", :force => true do |t|
- t.integer "pack_id", :null => false
+ t.integer "user_id", :null => false
t.integer "contributable_id", :null => false
- t.integer "contributable_version"
- t.string "contributable_type"
t.text "comment"
- t.integer "user_id", :null => false
+ t.string "contributable_type"
t.datetime "created_at"
t.datetime "updated_at"
+ t.integer "contributable_version"
+ t.integer "pack_id", :null => false
end
create_table "pack_remote_entries", :force => true do |t|
- t.integer "pack_id", :null => false
- t.string "title"
+ t.integer "user_id", :null => false
t.string "uri"
t.string "alternate_uri"
+ t.string "title"
t.text "comment"
- t.integer "user_id", :null => false
t.datetime "created_at"
t.datetime "updated_at"
+ t.integer "pack_id", :null => false
end
create_table "packs", :force => true do |t|
t.integer "contributor_id"
- t.string "contributor_type"
- t.string "title"
t.text "description"
+ t.string "title"
t.text "description_html"
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "contributor_type"
end
create_table "pending_invitations", :force => true do |t|
@@ -481,32 +481,27 @@
t.integer "user_id"
end
- create_table "plugin_schema_info", :id => false, :force => true do |t|
- t.string "plugin_name"
- t.integer "version"
- end
-
create_table "policies", :force => true do |t|
+ t.boolean "public_download", :default => false
t.integer "contributor_id"
- t.string "contributor_type"
t.string "name"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.integer "share_mode"
t.integer "update_mode"
- t.boolean "public_download", :default => false
+ t.integer "share_mode"
t.boolean "public_view", :default => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.string "contributor_type"
end
create_table "predicates", :force => true do |t|
- t.datetime "updated_at"
- t.string "title"
- t.text "description_html"
- t.string "phrase"
t.integer "ontology_id"
- t.text "description"
t.text "equivalent_to"
+ t.text "description"
+ t.string "title"
+ t.string "phrase"
+ t.text "description_html"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "previews", :force => true do |t|
@@ -546,15 +541,15 @@
add_index "ratings", ["user_id"], :name => "index_ratings_on_user_id"
create_table "relationships", :force => true do |t|
- t.string "objekt_type"
- t.integer "objekt_id"
t.string "subject_type"
- t.integer "subject_id"
t.integer "user_id"
- t.datetime "created_at"
- t.integer "context_id"
+ t.integer "objekt_id"
t.integer "predicate_id"
+ t.integer "context_id"
+ t.string "objekt_type"
t.string "context_type"
+ t.integer "subject_id"
+ t.datetime "created_at"
end
create_table "remote_workflows", :force => true do |t|
@@ -578,83 +573,83 @@
create_table "service_categories", :force => true do |t|
t.string "uri"
- t.datetime "updated_at"
t.integer "service_id"
t.string "label"
t.datetime "retrieved_at"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "service_deployments", :force => true do |t|
- t.string "iso3166_country_code"
- t.string "city"
+ t.integer "service_id"
t.string "submitter_label"
t.string "uri"
- t.datetime "updated_at"
- t.string "submitter_uri"
+ t.string "iso3166_country_code"
+ t.integer "service_provider_id"
t.string "country"
- t.integer "service_id"
t.datetime "created"
- t.integer "service_provider_id"
t.string "flag_url"
t.string "endpoint"
+ t.string "city"
t.datetime "retrieved_at"
+ t.string "submitter_uri"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "service_providers", :force => true do |t|
- t.string "name"
t.string "uri"
- t.datetime "updated_at"
- t.text "description"
+ t.string "name"
t.datetime "created"
+ t.text "description"
t.datetime "retrieved_at"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "service_tags", :force => true do |t|
t.string "uri"
- t.datetime "updated_at"
t.integer "service_id"
t.string "label"
t.datetime "retrieved_at"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "service_types", :force => true do |t|
- t.datetime "updated_at"
t.integer "service_id"
t.string "label"
t.datetime "retrieved_at"
t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "services", :force => true do |t|
- t.string "documentation_uri"
- t.string "iso3166_country_code"
- t.string "city"
- t.string "name"
- t.string "provider_uri"
t.string "submitter_label"
t.string "uri"
- t.datetime "updated_at"
- t.string "monitor_symbol_url"
- t.datetime "monitor_last_checked"
- t.string "monitor_label"
+ t.string "provider_label"
+ t.integer "contributor_id"
+ t.string "iso3166_country_code"
+ t.string "name"
t.string "country"
- t.string "submitter_uri"
t.string "monitor_small_symbol_url"
+ t.string "monitor_symbol_url"
t.text "monitor_message"
t.text "description"
- t.string "wsdl"
- t.datetime "created"
- t.string "contributor_type"
- t.integer "contributor_id"
t.string "flag_url"
+ t.datetime "created"
+ t.string "wsdl"
+ t.datetime "monitor_last_checked"
+ t.string "monitor_label"
t.string "endpoint"
- t.string "provider_label"
+ t.string "city"
+ t.string "provider_uri"
t.datetime "retrieved_at"
+ t.string "documentation_uri"
+ t.string "submitter_uri"
t.datetime "created_at"
+ t.datetime "updated_at"
+ t.string "contributor_type"
end
create_table "sessions", :force => true do |t|
@@ -705,10 +700,10 @@
end
create_table "topic_feedbacks", :force => true do |t|
- t.integer "score"
- t.integer "topic_id"
- t.datetime "submit_dt"
t.integer "user_id"
+ t.datetime "submit_dt"
+ t.integer "topic_id"
+ t.integer "score"
end
create_table "topic_runs", :force => true do |t|
@@ -717,31 +712,31 @@
end
create_table "topic_tag_map", :force => true do |t|
- t.integer "topic_id"
+ t.float "probability"
t.boolean "display_flag"
+ t.integer "topic_id"
t.integer "tag_id"
- t.float "probability"
end
create_table "topic_workflow_map", :force => true do |t|
- t.integer "topic_id"
- t.boolean "display_flag"
t.integer "workflow_id"
t.float "probability"
+ t.boolean "display_flag"
+ t.integer "topic_id"
end
create_table "topics", :force => true do |t|
- t.string "name"
- t.integer "orig_run_id"
t.integer "run_id"
+ t.integer "orig_run_id"
+ t.string "name"
end
create_table "user_reports", :force => true do |t|
t.string "subject_type"
- t.text "content"
- t.integer "subject_id"
t.integer "user_id"
+ t.text "content"
t.text "report"
+ t.integer "subject_id"
t.datetime "created_at"
end
@@ -780,21 +775,21 @@
add_index "viewings", ["contribution_id"], :name => "index_viewings_on_contribution_id"
create_table "vocabularies", :force => true do |t|
+ t.string "uri"
t.integer "user_id"
- t.string "title"
t.text "description"
+ t.string "title"
t.text "description_html"
+ t.string "prefix"
t.datetime "created_at"
t.datetime "updated_at"
- t.string "prefix"
- t.string "uri"
end
create_table "workflow_processors", :force => true do |t|
+ t.integer "workflow_id"
t.string "name"
- t.string "wsdl_operation"
t.string "wsdl"
- t.integer "workflow_id"
+ t.string "wsdl_operation"
end
create_table "workflow_versions", :force => true do |t|
@@ -808,6 +803,8 @@
t.text "body_html"
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "license"
+ t.integer "preview_id"
t.string "image"
t.string "svg"
t.text "revision_comments"
@@ -815,8 +812,6 @@
t.string "file_ext"
t.string "last_edited_by"
t.integer "content_type_id"
- t.string "license"
- t.integer "preview_id"
end
add_index "workflow_versions", ["workflow_id"], :name => "index_workflow_versions_on_workflow_id"
@@ -830,15 +825,15 @@
t.string "unique_name"
t.text "body"
t.text "body_html"
+ t.integer "current_version"
+ t.integer "preview_id"
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "current_version"
t.integer "content_blob_id"
t.string "file_ext"
t.string "last_edited_by"
t.integer "content_type_id"
t.integer "license_id"
- t.integer "preview_id"
end
create_table "wsdl_deprecations", :force => true do |t|