myexperiment-hackers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[myexperiment-hackers] [3283] branches/wf4ever/db/schema.rb: Updated sch


From: noreply
Subject: [myexperiment-hackers] [3283] branches/wf4ever/db/schema.rb: Updated schema
Date: Fri, 4 Jan 2013 12:50:26 +0000 (UTC)

Revision
3283
Author
stain
Date
2013-01-04 12:50:25 +0000 (Fri, 04 Jan 2013)

Log Message

Updated schema

Modified Paths

Diff

Modified: branches/wf4ever/db/schema.rb (3282 => 3283)


--- branches/wf4ever/db/schema.rb	2012-12-27 17:09:00 UTC (rev 3282)
+++ branches/wf4ever/db/schema.rb	2013-01-04 12:50:25 UTC (rev 3283)
@@ -60,16 +60,16 @@
   end
 
   create_table "blobs", :force => true do |t|
+    t.integer  "contributor_id"
+    t.string   "contributor_type"
+    t.string   "local_name"
+    t.datetime "created_at"
     t.datetime "updated_at"
     t.string   "title"
+    t.text     "body"
+    t.text     "body_html"
     t.integer  "content_blob_id"
-    t.string   "local_name"
-    t.text     "body"
     t.integer  "content_type_id"
-    t.integer  "contributor_id"
-    t.datetime "created_at"
-    t.text     "body_html"
-    t.string   "contributor_type"
     t.integer  "license_id"
     t.integer  "current_version"
     t.text     "ro_uri"
@@ -145,18 +145,18 @@
   add_index "comments", ["user_id"], :name => "index_comments_on_user_id"
 
   create_table "concept_relations", :force => true do |t|
+    t.integer "subject_concept_id"
+    t.integer "object_concept_id"
     t.string  "relation_type"
-    t.integer "object_concept_id"
-    t.integer "subject_concept_id"
   end
 
   create_table "concepts", :force => true do |t|
-    t.datetime "updated_at"
-    t.text     "description_html"
     t.text     "description"
     t.string   "phrase"
+    t.text     "description_html"
+    t.integer  "vocabulary_id"
     t.datetime "created_at"
-    t.integer  "vocabulary_id"
+    t.datetime "updated_at"
   end
 
   create_table "content_blobs", :force => true do |t|
@@ -165,35 +165,38 @@
     t.string "sha1", :limit => 40
   end
 
+  add_index "content_blobs", ["md5"], :name => "index_content_blobs_on_md5"
+  add_index "content_blobs", ["sha1"], :name => "index_content_blobs_on_sha1"
+
   create_table "content_types", :force => true do |t|
-    t.datetime "updated_at"
-    t.text     "description_html"
+    t.integer  "user_id"
     t.text     "description"
     t.string   "title"
-    t.datetime "created_at"
     t.string   "mime_type"
-    t.integer  "user_id"
     t.string   "category"
+    t.text     "description_html"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   create_table "contributions", :force => true do |t|
-    t.string   "layout"
-    t.datetime "updated_at"
-    t.string   "contributable_type"
-    t.string   "label"
     t.float    "rating"
+    t.integer  "site_viewings_count",  :default => 0
+    t.integer  "contributable_id"
+    t.integer  "contributor_id"
     t.integer  "policy_id"
-    t.integer  "viewings_count",       :default => 0
+    t.float    "rank"
+    t.string   "label"
     t.integer  "site_downloads_count", :default => 0
+    t.integer  "downloads_count",      :default => 0
     t.integer  "content_type_id"
-    t.integer  "contributor_id"
-    t.integer  "contributable_id"
-    t.float    "rank"
-    t.integer  "site_viewings_count",  :default => 0
-    t.integer  "downloads_count",      :default => 0
+    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"
-    t.integer  "license_id"
   end
 
   add_index "contributions", ["contributable_id", "contributable_type"], :name => "index_contributions_on_contributable_id_and_contributable_type"
@@ -226,12 +229,12 @@
   end
 
   create_table "downloads", :force => true do |t|
+    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.integer  "contribution_id"
-    t.datetime "created_at"
-    t.integer  "user_id"
-    t.boolean  "accessed_from_site", :default => false
   end
 
   add_index "downloads", ["contribution_id"], :name => "index_downloads_on_contribution_id"
@@ -306,9 +309,9 @@
   create_table "labels", :force => true do |t|
     t.integer "concept_id"
     t.string  "label_type"
+    t.string  "language"
+    t.integer "vocabulary_id"
     t.string  "text"
-    t.integer "vocabulary_id"
-    t.string  "language"
   end
 
   create_table "license_attributes", :force => true do |t|
@@ -398,54 +401,52 @@
     t.datetime "invalidated_at"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "callback_url"
-    t.string   "verifier",              :limit => 20
-    t.string   "scope"
   end
 
   add_index "oauth_tokens", ["token"], :name => "index_oauth_tokens_on_token", :unique => true
 
   create_table "ontologies", :force => true do |t|
-    t.datetime "updated_at"
-    t.text     "description_html"
+    t.string   "uri"
+    t.integer  "user_id"
     t.text     "description"
     t.string   "title"
-    t.string   "uri"
+    t.text     "description_html"
     t.string   "prefix"
     t.datetime "created_at"
-    t.integer  "user_id"
+    t.datetime "updated_at"
   end
 
   create_table "pack_contributable_entries", :force => true do |t|
+    t.integer  "user_id",               :null => false
+    t.integer  "contributable_id",      :null => false
+    t.text     "comment"
+    t.string   "contributable_type"
+    t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "contributable_type"
     t.integer  "contributable_version"
     t.integer  "pack_id",               :null => false
-    t.integer  "contributable_id",      :null => false
-    t.datetime "created_at"
-    t.integer  "user_id",               :null => false
-    t.text     "comment"
   end
 
   create_table "pack_remote_entries", :force => true do |t|
-    t.datetime "updated_at"
+    t.integer  "user_id",       :null => false
     t.string   "uri"
+    t.string   "alternate_uri"
     t.string   "title"
+    t.text     "comment"
+    t.datetime "created_at"
+    t.datetime "updated_at"
     t.integer  "pack_id",       :null => false
-    t.string   "alternate_uri"
-    t.datetime "created_at"
-    t.integer  "user_id",       :null => false
-    t.text     "comment"
   end
 
   create_table "packs", :force => true do |t|
-    t.datetime "updated_at"
-    t.text     "description_html"
+    t.integer  "contributor_id"
     t.text     "description"
     t.string   "title"
-    t.integer  "contributor_id"
+    t.text     "description_html"
     t.datetime "created_at"
+    t.datetime "updated_at"
     t.string   "contributor_type"
+    t.text     "ro_uri"
   end
 
   create_table "pending_invitations", :force => true do |t|
@@ -483,32 +484,32 @@
   end
 
   create_table "policies", :force => true do |t|
-    t.datetime "updated_at"
     t.boolean  "public_download",  :default => false
+    t.integer  "contributor_id"
+    t.string   "name"
     t.integer  "update_mode"
     t.integer  "share_mode"
-    t.integer  "contributor_id"
-    t.string   "name"
     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.text     "description_html"
+    t.integer  "ontology_id"
+    t.text     "equivalent_to"
     t.text     "description"
+    t.string   "title"
     t.string   "phrase"
-    t.string   "title"
-    t.text     "equivalent_to"
+    t.text     "description_html"
     t.datetime "created_at"
-    t.integer  "ontology_id"
+    t.datetime "updated_at"
   end
 
   create_table "previews", :force => true do |t|
     t.integer  "svg_blob_id"
+    t.integer  "image_blob_id"
     t.datetime "created_at"
-    t.integer  "image_blob_id"
   end
 
   create_table "profiles", :force => true do |t|
@@ -542,15 +543,15 @@
   add_index "ratings", ["user_id"], :name => "index_ratings_on_user_id"
 
   create_table "relationships", :force => true do |t|
-    t.string   "context_type"
     t.string   "subject_type"
+    t.integer  "user_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.integer  "context_id"
     t.datetime "created_at"
-    t.integer  "predicate_id"
-    t.integer  "user_id"
-    t.integer  "objekt_id"
   end
 
   create_table "remote_workflows", :force => true do |t|
@@ -585,84 +586,84 @@
   add_index "reviews", ["user_id"], :name => "index_reviews_on_user_id"
 
   create_table "service_categories", :force => true do |t|
-    t.datetime "updated_at"
+    t.string   "uri"
+    t.integer  "service_id"
     t.string   "label"
-    t.string   "uri"
     t.datetime "retrieved_at"
-    t.integer  "service_id"
     t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   create_table "service_deployments", :force => true do |t|
+    t.integer  "service_id"
+    t.string   "submitter_label"
+    t.string   "uri"
     t.string   "iso3166_country_code"
-    t.datetime "updated_at"
+    t.integer  "service_provider_id"
+    t.string   "country"
     t.datetime "created"
     t.string   "flag_url"
-    t.string   "uri"
+    t.string   "endpoint"
+    t.string   "city"
     t.datetime "retrieved_at"
-    t.integer  "service_provider_id"
-    t.string   "endpoint"
-    t.integer  "service_id"
-    t.string   "submitter_label"
-    t.string   "country"
     t.string   "submitter_uri"
     t.datetime "created_at"
-    t.string   "city"
+    t.datetime "updated_at"
   end
 
   create_table "service_providers", :force => true do |t|
+    t.string   "uri"
+    t.string   "name"
+    t.datetime "created"
     t.text     "description"
-    t.datetime "updated_at"
-    t.datetime "created"
-    t.string   "uri"
     t.datetime "retrieved_at"
-    t.string   "name"
     t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   create_table "service_tags", :force => true do |t|
-    t.datetime "updated_at"
+    t.string   "uri"
+    t.integer  "service_id"
     t.string   "label"
-    t.string   "uri"
     t.datetime "retrieved_at"
-    t.integer  "service_id"
     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.integer  "service_id"
     t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   create_table "services", :force => true do |t|
+    t.string   "submitter_label"
+    t.string   "uri"
+    t.string   "provider_label"
+    t.integer  "contributor_id"
+    t.string   "iso3166_country_code"
+    t.string   "name"
+    t.string   "country"
+    t.string   "monitor_small_symbol_url"
+    t.string   "monitor_symbol_url"
+    t.text     "monitor_message"
     t.text     "description"
-    t.string   "documentation_uri"
-    t.string   "iso3166_country_code"
-    t.datetime "updated_at"
     t.string   "flag_url"
-    t.string   "provider_label"
     t.datetime "created"
-    t.string   "uri"
-    t.text     "monitor_message"
+    t.string   "wsdl"
     t.datetime "monitor_last_checked"
-    t.string   "monitor_symbol_url"
+    t.string   "monitor_label"
+    t.string   "endpoint"
+    t.string   "city"
+    t.string   "provider_uri"
     t.datetime "retrieved_at"
-    t.integer  "contributor_id"
-    t.string   "endpoint"
-    t.string   "name"
-    t.string   "country"
-    t.string   "submitter_label"
+    t.string   "documentation_uri"
     t.string   "submitter_uri"
     t.datetime "created_at"
-    t.string   "wsdl"
+    t.datetime "updated_at"
     t.string   "contributor_type"
-    t.string   "city"
-    t.string   "monitor_small_symbol_url"
-    t.string   "monitor_label"
-    t.string   "provider_uri"
   end
 
   create_table "sessions", :force => true do |t|
@@ -676,12 +677,14 @@
 
   create_table "statements", :force => true do |t|
     t.integer  "research_object_id"
+    t.string   "resource"
+    t.integer  "version"
+    t.text     "context_uri"
     t.string   "subject_text"
     t.string   "predicate_text"
     t.string   "objekt_text"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.text     "context_uri"
   end
 
   create_table "taggings", :force => true do |t|
@@ -723,44 +726,44 @@
   end
 
   create_table "topic_feedbacks", :force => true do |t|
+    t.integer  "user_id"
+    t.datetime "submit_dt"
+    t.integer  "topic_id"
     t.integer  "score"
-    t.integer  "topic_id"
-    t.datetime "submit_dt"
-    t.integer  "user_id"
   end
 
   create_table "topic_runs", :force => true do |t|
+    t.datetime "runtime"
     t.string   "description"
-    t.datetime "runtime"
   end
 
   create_table "topic_tag_map", :force => true do |t|
+    t.float   "probability"
     t.boolean "display_flag"
-    t.float   "probability"
+    t.integer "topic_id"
     t.integer "tag_id"
-    t.integer "topic_id"
   end
 
   create_table "topic_workflow_map", :force => true do |t|
+    t.integer "workflow_id"
+    t.float   "probability"
     t.boolean "display_flag"
-    t.float   "probability"
-    t.integer "workflow_id"
     t.integer "topic_id"
   end
 
   create_table "topics", :force => true do |t|
+    t.integer "run_id"
     t.integer "orig_run_id"
-    t.integer "run_id"
     t.string  "name"
   end
 
   create_table "user_reports", :force => true do |t|
+    t.string   "subject_type"
+    t.integer  "user_id"
     t.text     "content"
-    t.string   "subject_type"
     t.text     "report"
     t.integer  "subject_id"
     t.datetime "created_at"
-    t.integer  "user_id"
   end
 
   create_table "users", :force => true do |t|
@@ -798,21 +801,21 @@
   add_index "viewings", ["contribution_id"], :name => "index_viewings_on_contribution_id"
 
   create_table "vocabularies", :force => true do |t|
-    t.datetime "updated_at"
-    t.text     "description_html"
+    t.string   "uri"
+    t.integer  "user_id"
     t.text     "description"
     t.string   "title"
-    t.string   "uri"
+    t.text     "description_html"
     t.string   "prefix"
     t.datetime "created_at"
-    t.integer  "user_id"
+    t.datetime "updated_at"
   end
 
   create_table "workflow_processors", :force => true do |t|
+    t.integer "workflow_id"
     t.string  "name"
+    t.string  "wsdl"
     t.string  "wsdl_operation"
-    t.integer "workflow_id"
-    t.string  "wsdl"
   end
 
   create_table "workflow_versions", :force => true do |t|
@@ -826,6 +829,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"
@@ -833,29 +838,27 @@
     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"
 
   create_table "workflows", :force => true do |t|
-    t.datetime "updated_at"
-    t.string   "unique_name"
+    t.integer  "contributor_id"
+    t.string   "contributor_type"
     t.string   "image"
+    t.string   "svg"
     t.string   "title"
-    t.integer  "content_blob_id"
+    t.string   "unique_name"
     t.text     "body"
-    t.integer  "content_type_id"
+    t.text     "body_html"
     t.integer  "current_version"
-    t.integer  "contributor_id"
     t.integer  "preview_id"
-    t.string   "svg"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+    t.integer  "content_blob_id"
     t.string   "file_ext"
-    t.datetime "created_at"
-    t.text     "body_html"
-    t.string   "contributor_type"
     t.string   "last_edited_by"
+    t.integer  "content_type_id"
     t.integer  "license_id"
     t.text     "ro_uri"
   end

reply via email to

[Prev in Thread] Current Thread [Next in Thread]