FKs

gistfile1.txt

class AddKeys < ActiveRecord::Migration
  def self.up
    add_foreign_key "catalog_item", "catalog", :name => "catalog_item_catalog_id_fk"
    add_foreign_key "catalog_item", "product", :name => "catalog_item_product_id_fk"
    add_foreign_key "history_bak", "realm", :name => "history_bak_realm_id_fk"
    add_foreign_key "history_bak", "user", :name => "history_bak_user_id_fk"
    add_foreign_key "history", "meeting", :name => "history_meeting_id_fk"
    add_foreign_key "history", "realm", :name => "history_realm_id_fk"
    add_foreign_key "history", "user", :name => "history_user_id_fk"
    add_foreign_key "invoice_history", "user", :name => "invoice_history_user_id_fk"
    add_foreign_key "meeting", "user", :name => "meeting_owner_id_fk", :column => "owner_id"
    add_foreign_key "meeting", "realm", :name => "meeting_realm_id_fk"
    add_foreign_key "meeting_transcripts", "meeting", :name => "meeting_transcripts_meeting_id_fk"
    add_foreign_key "meeting_transcripts", "transcripts", :name => "meeting_transcripts_transcript_id_fk"
    add_foreign_key "poll", "user", :name => "poll_owner_id_fk", :column => "owner_id"
    add_foreign_key "poll_vote", "user", :name => "poll_vote_user_id_fk"
    add_foreign_key "product", "asset", :name => "product_app_asset_id_fk", :column => "app_asset_id"
    add_foreign_key "product", "asset", :name => "product_asset_id_fk"
    add_foreign_key "question_and_answer", "question_and_answer_category", :name => "question_and_answer_question_and_answer_category_id_fk"
    add_foreign_key "realm_invite", "user", :name => "realm_invite_from_user_id_fk", :column => "from_user_id"
    add_foreign_key "realm_invite", "realm", :name => "realm_invite_realm_id_fk"
    add_foreign_key "realm_set_item", "realm_set", :name => "realm_set_item_realm_set_id_fk", :dependent => :delete
    add_foreign_key "realm_set", "realm_set_type", :name => "realm_set_realm_set_type_id_fk"
    add_foreign_key "realm_stats", "realm", :name => "realm_stats_realm_id_fk"
    add_foreign_key "realm_tags", "realm", :name => "realm_tags_id_fk", :column => "id"
    add_foreign_key "realm_temp", "realm", :name => "realm_temp_id_fk", :column => "id"
    add_foreign_key "resource", "user", :name => "resource_created_by_id_fk", :column => "created_by_id"
    add_foreign_key "resource", "realm", :name => "resource_realm_id_fk"
    add_foreign_key "resource", "user", :name => "resource_updated_by_id_fk", :column => "updated_by_id"
    add_foreign_key "states", "country", :name => "states_country_id_fk"
    add_foreign_key "support_tagging", "meeting_tip", :name => "support_tagging_meeting_tip_id_fk"
    add_foreign_key "support_tagging", "question_and_answer", :name => "support_tagging_question_and_answer_id_fk"
    add_foreign_key "support_tagging", "support_tag", :name => "support_tagging_support_tag_id_fk"
    add_foreign_key "support_tagging", "tutorial", :name => "support_tagging_tutorial_id_fk"
    add_foreign_key "sys_event", "realm", :name => "sys_event_realm_id_fk"
    add_foreign_key "sys_event", "user", :name => "sys_event_user_id_fk"
    add_foreign_key "tokens_log", "asset", :name => "tokens_log_asset_id_fk"
    add_foreign_key "tokens_log", "user", :name => "tokens_log_user_id_fk"
    add_foreign_key "tool_resource", "resource", :name => "tool_resource_resource_id_fk"
    add_foreign_key "tool_resource", "tool", :name => "tool_resource_tool_id_fk"
    add_foreign_key "transcript_accesses", "transcripts", :name => "transcript_accesses_transcript_id_fk"
    add_foreign_key "transcript_accesses", "user", :name => "transcript_accesses_user_id_fk"
    add_foreign_key "transcript_items", "transcripts", :name => "transcript_items_transcript_id_fk"
    add_foreign_key "transcript_items", "user", :name => "transcript_items_user_id_fk"
    add_foreign_key "transcripts", "meeting", :name => "transcripts_meeting_id_fk"
    add_foreign_key "transcripts", "realm", :name => "transcripts_realm_id_fk"
    add_foreign_key "upload", "realm", :name => "upload_realm_id_fk"
    add_foreign_key "upload", "resource", :name => "upload_resource_id_fk"
    add_foreign_key "upload", "user", :name => "upload_user_id_fk"
    add_foreign_key "user_asset", "asset", :name => "user_asset_app_asset_id_fk", :column => "app_asset_id"
    add_foreign_key "user", "country", :name => "user_country_id_fk"
    add_foreign_key "user", "realm", :name => "user_cur_realm_id_fk", :column => "cur_realm_id"
    add_foreign_key "user_feed", "user", :name => "user_feed_feed_id_fk", :column => "feed_id"
    add_foreign_key "user_feed", "user", :name => "user_feed_user_id_fk"
    add_foreign_key "user", "iploc", :name => "user_iploc_id_fk"
    add_foreign_key "user", "offer", :name => "user_offer_id_fk"
    add_foreign_key "user", "http_session", :name => "user_session_id_fk", :column => "session_id", :primary_key => "session_id"
    add_foreign_key "user_tags", "user", :name => "user_tags_id_fk", :column => "id"
    add_foreign_key "user_widget", "user", :name => "user_widget_user_id_fk"
    add_foreign_key "users_guide_category", "users_guide_category", :name => "users_guide_category_parent_id_fk", :column => "parent_id"
    add_foreign_key "users_guide_pages", "users_guide_category", :name => "users_guide_pages_category_id_fk", :column => "category_id"
  end

  def self.down
    remove_foreign_key "catalog_item", :name => "catalog_item_catalog_id_fk"
    remove_foreign_key "catalog_item", :name => "catalog_item_product_id_fk"
    remove_foreign_key "history_bak", :name => "history_bak_realm_id_fk"
    remove_foreign_key "history_bak", :name => "history_bak_user_id_fk"
    remove_foreign_key "history", :name => "history_meeting_id_fk"
    remove_foreign_key "history", :name => "history_realm_id_fk"
    remove_foreign_key "history", :name => "history_user_id_fk"
    remove_foreign_key "invoice_history", :name => "invoice_history_user_id_fk"
    remove_foreign_key "meeting", :name => "meeting_owner_id_fk"
    remove_foreign_key "meeting", :name => "meeting_realm_id_fk"
    remove_foreign_key "meeting_transcripts", :name => "meeting_transcripts_meeting_id_fk"
    remove_foreign_key "meeting_transcripts", :name => "meeting_transcripts_transcript_id_fk"
    remove_foreign_key "poll", :name => "poll_owner_id_fk"
    remove_foreign_key "poll_vote", :name => "poll_vote_user_id_fk"
    remove_foreign_key "product", :name => "product_app_asset_id_fk"
    remove_foreign_key "product", :name => "product_asset_id_fk"
    remove_foreign_key "question_and_answer", :name => "question_and_answer_question_and_answer_category_id_fk"
    remove_foreign_key "realm_invite", :name => "realm_invite_from_user_id_fk"
    remove_foreign_key "realm_invite", :name => "realm_invite_realm_id_fk"
    remove_foreign_key "realm_set_item", :name => "realm_set_item_realm_set_id_fk"
    remove_foreign_key "realm_set", :name => "realm_set_realm_set_type_id_fk"
    remove_foreign_key "realm_stats", :name => "realm_stats_realm_id_fk"
    remove_foreign_key "realm_tags", :name => "realm_tags_id_fk"
    remove_foreign_key "realm_temp", :name => "realm_temp_id_fk"
    remove_foreign_key "resource", :name => "resource_created_by_id_fk"
    remove_foreign_key "resource", :name => "resource_realm_id_fk"
    remove_foreign_key "resource", :name => "resource_updated_by_id_fk"
    remove_foreign_key "states", :name => "states_country_id_fk"
    remove_foreign_key "support_tagging", :name => "support_tagging_meeting_tip_id_fk"
    remove_foreign_key "support_tagging", :name => "support_tagging_question_and_answer_id_fk"
    remove_foreign_key "support_tagging", :name => "support_tagging_support_tag_id_fk"
    remove_foreign_key "support_tagging", :name => "support_tagging_tutorial_id_fk"
    remove_foreign_key "sys_event", :name => "sys_event_realm_id_fk"
    remove_foreign_key "sys_event", :name => "sys_event_user_id_fk"
    remove_foreign_key "tokens_log", :name => "tokens_log_asset_id_fk"
    remove_foreign_key "tokens_log", :name => "tokens_log_user_id_fk"
    remove_foreign_key "tool_resource", :name => "tool_resource_resource_id_fk"
    remove_foreign_key "tool_resource", :name => "tool_resource_tool_id_fk"
    remove_foreign_key "transcript_accesses", :name => "transcript_accesses_transcript_id_fk"
    remove_foreign_key "transcript_accesses", :name => "transcript_accesses_user_id_fk"
    remove_foreign_key "transcript_items", :name => "transcript_items_transcript_id_fk"
    remove_foreign_key "transcript_items", :name => "transcript_items_user_id_fk"
    remove_foreign_key "transcripts", :name => "transcripts_meeting_id_fk"
    remove_foreign_key "transcripts", :name => "transcripts_realm_id_fk"
    remove_foreign_key "upload", :name => "upload_realm_id_fk"
    remove_foreign_key "upload", :name => "upload_resource_id_fk"
    remove_foreign_key "upload", :name => "upload_user_id_fk"
    remove_foreign_key "user_asset", :name => "user_asset_app_asset_id_fk"
    remove_foreign_key "user", :name => "user_country_id_fk"
    remove_foreign_key "user", :name => "user_cur_realm_id_fk"
    remove_foreign_key "user_feed", :name => "user_feed_feed_id_fk"
    remove_foreign_key "user_feed", :name => "user_feed_user_id_fk"
    remove_foreign_key "user", :name => "user_iploc_id_fk"
    remove_foreign_key "user", :name => "user_offer_id_fk"
    remove_foreign_key "user", :name => "user_session_id_fk"
    remove_foreign_key "user_tags", :name => "user_tags_id_fk"
    remove_foreign_key "user_widget", :name => "user_widget_user_id_fk"
    remove_foreign_key "users_guide_category", :name => "users_guide_category_parent_id_fk"
    remove_foreign_key "users_guide_pages", :name => "users_guide_pages_category_id_fk"
  end
end