#
# Copyright 2006-2008 Appcelerator, Inc.
# 
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
# 
#    http://www.apache.org/licenses/LICENSE-2.0
# 
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License. 


if defined?(ActiveRecord)
  module ActiveRecord
  	class Migration
  	  def self.add_foreign_key(from_table, from_column, to_table)
  		constraint_name = "fk_#{from_table}_#{from_column}"		
  		execute %{ALTER TABLE #{from_table} ADD CONSTRAINT #{constraint_name} FOREIGN KEY (#{from_column}) REFERENCES #{to_table}(id)}
  	  end
  	  def self.remove_foreign_key(from_table,from_column,to_table)
  		constraint_name = "fk_#{from_table}_#{from_column}"		
  		execute %{ALTER TABLE #{from_table} DROP FOREIGN KEY #{constraint_name}}
  	  end
  	end
  end
end