myexperiment-hackers
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[myexperiment-hackers] [3321] branches/wf4ever/db: WFE-810 Drop table re

From: noreply
Subject: [myexperiment-hackers] [3321] branches/wf4ever/db: WFE-810 Drop table research_objects
Date: Mon, 21 Jan 2013 16:58:41 +0000 (UTC)
Revision
3321
Author
stain
Date
2013-01-21 16:58:41 +0000 (Mon, 21 Jan 2013)

Log Message

WFE-810 Drop table research_objects

Also drop any Contributable of type ResearchObject

Modified Paths

Added Paths

Diff

Added: branches/wf4ever/db/migrate/20130121162244_drop_table_research_objects.rb (0 => 3321)


--- branches/wf4ever/db/migrate/20130121162244_drop_table_research_objects.rb	                        (rev 0)
+++ branches/wf4ever/db/migrate/20130121162244_drop_table_research_objects.rb	2013-01-21 16:58:41 UTC (rev 3321)
@@ -0,0 +1,24 @@
+# myExperiment: db/migrate/20130121162244_drop_table_research_objects.rb
+#
+# Copyright (c) 2013 University of Manchester and the University of Southampton.
+# See license.txt for details.
+class DropTableResearchObjects < ActiveRecord::Migration
+  def self.up
+    drop_table :research_objects
+    Contribution.destroy_all(:contributable_type => "ResearchObject")
+  end
+
+  def self.down
+    create_table "research_objects", :force => true do |t|
+      t.string   "title"
+      t.text     "description"
+      t.text     "description_html"
+      t.text     "url"
+      t.datetime "created_at"
+      t.datetime "updated_at"
+      t.integer  "content_blob_id"
+      t.integer  "contributor_id"
+      t.string   "contributor_type"
+    end
+  end
+end

Modified: branches/wf4ever/db/schema.rb (3320 => 3321)


--- branches/wf4ever/db/schema.rb	2013-01-21 16:58:35 UTC (rev 3320)
+++ branches/wf4ever/db/schema.rb	2013-01-21 16:58:41 UTC (rev 3321)
@@ -9,7 +9,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20121113162639) do
+ActiveRecord::Schema.define(:version => 20130121162244) do
 
   create_table "activity_limits", :force => true do |t|
     t.string   "contributor_type", :null => false
@@ -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.text     "description"
-    t.string   "phrase"
     t.text     "description_html"
-    t.integer  "vocabulary_id"
-    t.datetime "created_at"
+    t.string   "phrase"
     t.datetime "updated_at"
+    t.datetime "created_at"
+    t.text     "description"
+    t.integer  "vocabulary_id"
   end
 
   create_table "content_blobs", :force => true do |t|
@@ -169,34 +169,34 @@
   add_index "content_blobs", ["sha1"], :name => "index_content_blobs_on_sha1"
 
   create_table "content_types", :force => true do |t|
+    t.string   "mime_type"
+    t.text     "description_html"
+    t.datetime "updated_at"
     t.integer  "user_id"
+    t.datetime "created_at"
     t.text     "description"
     t.string   "title"
-    t.string   "mime_type"
     t.string   "category"
-    t.text     "description_html"
-    t.datetime "created_at"
-    t.datetime "updated_at"
   end
 
   create_table "contributions", :force => true do |t|
-    t.float    "rating"
+    t.integer  "viewings_count",       :default => 0
     t.integer  "site_viewings_count",  :default => 0
-    t.integer  "contributable_id"
-    t.integer  "contributor_id"
-    t.integer  "policy_id"
-    t.float    "rank"
-    t.string   "label"
     t.integer  "site_downloads_count", :default => 0
     t.integer  "downloads_count",      :default => 0
+    t.string   "contributor_type"
+    t.integer  "license_id"
     t.integer  "content_type_id"
-    t.integer  "viewings_count",       :default => 0
-    t.string   "contributable_type"
-    t.datetime "created_at"
+    t.float    "rank"
+    t.integer  "policy_id"
     t.string   "layout"
-    t.integer  "license_id"
     t.datetime "updated_at"
-    t.string   "contributor_type"
+    t.integer  "contributable_id"
+    t.string   "label"
+    t.datetime "created_at"
+    t.float    "rating"
+    t.string   "contributable_type"
+    t.integer  "contributor_id"
   end
 
   add_index "contributions", ["contributable_id", "contributable_type"], :name => "index_contributions_on_contributable_id_and_contributable_type"
@@ -229,10 +229,10 @@
   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.integer  "contribution_id"
+    t.integer  "user_id"
     t.datetime "created_at"
     t.string   "user_agent"
   end
@@ -307,11 +307,11 @@
   end
 
   create_table "labels", :force => true do |t|
-    t.integer "concept_id"
     t.string  "label_type"
+    t.string  "text"
     t.string  "language"
+    t.integer "concept_id"
     t.integer "vocabulary_id"
-    t.string  "text"
   end
 
   create_table "license_attributes", :force => true do |t|
@@ -406,46 +406,46 @@
   add_index "oauth_tokens", ["token"], :name => "index_oauth_tokens_on_token", :unique => true
 
   create_table "ontologies", :force => true do |t|
-    t.string   "uri"
-    t.integer  "user_id"
-    t.text     "description"
-    t.string   "title"
     t.text     "description_html"
+    t.datetime "updated_at"
     t.string   "prefix"
+    t.integer  "user_id"
     t.datetime "created_at"
-    t.datetime "updated_at"
+    t.text     "description"
+    t.string   "title"
+    t.string   "uri"
   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.integer  "pack_id",               :null => false
     t.datetime "updated_at"
+    t.integer  "contributable_id",      :null => false
     t.integer  "contributable_version"
-    t.integer  "pack_id",               :null => false
+    t.integer  "user_id",               :null => false
+    t.datetime "created_at"
+    t.string   "contributable_type"
   end
 
   create_table "pack_remote_entries", :force => true do |t|
-    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 "updated_at"
+    t.integer  "user_id",       :null => false
+    t.datetime "created_at"
+    t.string   "title"
+    t.string   "uri"
   end
 
   create_table "packs", :force => true do |t|
-    t.integer  "contributor_id"
-    t.text     "description"
-    t.string   "title"
     t.text     "description_html"
-    t.datetime "created_at"
-    t.datetime "updated_at"
     t.string   "contributor_type"
+    t.datetime "updated_at"
+    t.datetime "created_at"
+    t.text     "description"
+    t.string   "title"
+    t.integer  "contributor_id"
     t.text     "ro_uri"
   end
 
@@ -484,31 +484,31 @@
   end
 
   create_table "policies", :force => true do |t|
-    t.boolean  "public_download",  :default => false
-    t.integer  "contributor_id"
-    t.string   "name"
     t.integer  "update_mode"
-    t.integer  "share_mode"
+    t.string   "name"
+    t.string   "contributor_type"
+    t.boolean  "public_download",  :default => false
+    t.datetime "updated_at"
     t.boolean  "public_view",      :default => false
+    t.integer  "share_mode"
     t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "contributor_type"
+    t.integer  "contributor_id"
   end
 
   create_table "predicates", :force => true do |t|
-    t.integer  "ontology_id"
+    t.text     "description_html"
+    t.string   "phrase"
+    t.datetime "updated_at"
     t.text     "equivalent_to"
+    t.datetime "created_at"
     t.text     "description"
     t.string   "title"
-    t.string   "phrase"
-    t.text     "description_html"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.integer  "ontology_id"
   end
 
   create_table "previews", :force => true do |t|
-    t.integer  "svg_blob_id"
     t.integer  "image_blob_id"
+    t.integer  "svg_blob_id"
     t.datetime "created_at"
   end
 
@@ -543,14 +543,14 @@
   add_index "ratings", ["user_id"], :name => "index_ratings_on_user_id"
 
   create_table "relationships", :force => true do |t|
+    t.integer  "predicate_id"
+    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  "context_id"
     t.integer  "subject_id"
+    t.integer  "user_id"
     t.datetime "created_at"
   end
 
@@ -561,18 +561,6 @@
     t.string  "workflow_uri"
   end
 
-  create_table "research_objects", :force => true do |t|
-    t.string   "title"
-    t.text     "description"
-    t.text     "description_html"
-    t.text     "url"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "content_blob_id"
-    t.integer  "contributor_id"
-    t.string   "contributor_type"
-  end
-
   create_table "reviews", :force => true do |t|
     t.string   "title",                         :default => ""
     t.text     "review"
@@ -586,84 +574,84 @@
   add_index "reviews", ["user_id"], :name => "index_reviews_on_user_id"
 
   create_table "service_categories", :force => true do |t|
-    t.string   "uri"
     t.integer  "service_id"
-    t.string   "label"
     t.datetime "retrieved_at"
-    t.datetime "created_at"
     t.datetime "updated_at"
+    t.string   "label"
+    t.datetime "created_at"
+    t.string   "uri"
   end
 
   create_table "service_deployments", :force => true do |t|
     t.integer  "service_id"
     t.string   "submitter_label"
-    t.string   "uri"
+    t.datetime "retrieved_at"
+    t.string   "submitter_uri"
+    t.string   "endpoint"
     t.string   "iso3166_country_code"
-    t.integer  "service_provider_id"
+    t.datetime "updated_at"
     t.string   "country"
     t.datetime "created"
     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"
+    t.integer  "service_provider_id"
+    t.string   "uri"
   end
 
   create_table "service_providers", :force => true do |t|
-    t.string   "uri"
+    t.datetime "retrieved_at"
     t.string   "name"
+    t.datetime "updated_at"
     t.datetime "created"
     t.text     "description"
-    t.datetime "retrieved_at"
     t.datetime "created_at"
-    t.datetime "updated_at"
+    t.string   "uri"
   end
 
   create_table "service_tags", :force => true do |t|
-    t.string   "uri"
     t.integer  "service_id"
-    t.string   "label"
     t.datetime "retrieved_at"
-    t.datetime "created_at"
     t.datetime "updated_at"
+    t.string   "label"
+    t.datetime "created_at"
+    t.string   "uri"
   end
 
   create_table "service_types", :force => true do |t|
     t.integer  "service_id"
-    t.string   "label"
     t.datetime "retrieved_at"
-    t.datetime "created_at"
     t.datetime "updated_at"
+    t.string   "label"
+    t.datetime "created_at"
   end
 
   create_table "services", :force => true do |t|
     t.string   "submitter_label"
-    t.string   "uri"
+    t.datetime "retrieved_at"
+    t.string   "monitor_symbol_url"
+    t.string   "endpoint"
     t.string   "provider_label"
-    t.integer  "contributor_id"
-    t.string   "iso3166_country_code"
+    t.string   "provider_uri"
     t.string   "name"
+    t.string   "submitter_uri"
+    t.string   "documentation_uri"
+    t.string   "iso3166_country_code"
+    t.string   "contributor_type"
+    t.string   "monitor_label"
+    t.string   "wsdl"
+    t.datetime "updated_at"
     t.string   "country"
+    t.datetime "monitor_last_checked"
     t.string   "monitor_small_symbol_url"
-    t.string   "monitor_symbol_url"
-    t.text     "monitor_message"
+    t.datetime "created"
     t.text     "description"
     t.string   "flag_url"
-    t.datetime "created"
-    t.string   "wsdl"
-    t.datetime "monitor_last_checked"
-    t.string   "monitor_label"
-    t.string   "endpoint"
     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"
+    t.text     "monitor_message"
+    t.string   "uri"
+    t.integer  "contributor_id"
   end
 
   create_table "sessions", :force => true do |t|
@@ -726,10 +714,10 @@
   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.datetime "submit_dt"
+    t.integer  "user_id"
   end
 
   create_table "topic_runs", :force => true do |t|
@@ -738,31 +726,31 @@
   end
 
   create_table "topic_tag_map", :force => true do |t|
+    t.integer "tag_id"
+    t.integer "topic_id"
     t.float   "probability"
     t.boolean "display_flag"
-    t.integer "topic_id"
-    t.integer "tag_id"
   end
 
   create_table "topic_workflow_map", :force => true do |t|
-    t.integer "workflow_id"
+    t.integer "topic_id"
     t.float   "probability"
     t.boolean "display_flag"
-    t.integer "topic_id"
+    t.integer "workflow_id"
   end
 
   create_table "topics", :force => true do |t|
+    t.string  "name"
     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.integer  "user_id"
     t.text     "content"
-    t.text     "report"
     t.integer  "subject_id"
+    t.text     "report"
+    t.integer  "user_id"
     t.datetime "created_at"
   end
 
@@ -801,21 +789,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.text     "description"
-    t.string   "title"
     t.text     "description_html"
+    t.datetime "updated_at"
     t.string   "prefix"
+    t.integer  "user_id"
     t.datetime "created_at"
-    t.datetime "updated_at"
+    t.text     "description"
+    t.string   "title"
+    t.string   "uri"
   end
 
   create_table "workflow_processors", :force => true do |t|
-    t.integer "workflow_id"
+    t.string  "wsdl_operation"
     t.string  "name"
     t.string  "wsdl"
-    t.string  "wsdl_operation"
+    t.integer "workflow_id"
   end
 
   create_table "workflow_versions", :force => true do |t|
reply via email to
[Prev in Thread] Current Thread [Next in Thread]