sql migration

004_Foreign_keys.php

<?php
class Migration_Foreign_keys extends Migration {
 
    public $migration_type = 'sql';
    
    public function up() 
    {
        $prefix = $this->db->dbprefix;
        $sql    = "
		ALTER TABLE {$prefix}supplier_pricing 
		ADD CONSTRAINT supplier_id FOREIGN KEY (supplier_id) REFERENCES {$prefix}supplier_details(id)  
		ON UPDATE CASCADE  
		ON DELETE CASCADE;";
 
        return $sql;
    }
 
    public function down() 
    {
        $prefix = $this->db->dbprefix;
        $sql    = "
		ALTER TABLE {$prefix}supplier_pricing DROP FOREIGN KEY supplier_id;
		ALTER TABLE {$prefix}supplier_pricing DROP INDEX supplier_id;";
        
        return $sql;
    } 
}
/* End of file: 004_Foreign_keys.php */
/* Location: /bonfire/modules/suppliers/migrations/004_Foreign_keys.php */