public function testAddForeignKey()
{
$q = new AlterTableQuery('products');
$q->add()->foreignKey('created_by')->references('users', array('id'));
$q->add()->constraint('fk_updated_by')->foreignKey('updated_by')->references('users', array('id'));
$this->assertDriverQuery(new MySQLDriver(), $q);
$this->assertDriverQuery(new PgSQLDriver(), $q);
$this->assertSqlStrings($q, [[new MySQLDriver(), 'ALTER TABLE `products` ADD FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),' . "\n" . ' ADD CONSTRAINT `fk_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)']]);
}