本文整理汇总了PHP中yii\db\Migration::dropForeignKey方法的典型用法代码示例。如果您正苦于以下问题：PHP Migration::dropForeignKey方法的具体用法？PHP Migration::dropForeignKey怎么用？PHP Migration::dropForeignKey使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类yii\db\Migration的用法示例。
在下文中一共展示了Migration::dropForeignKey方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: actionUpdate
/**
* Update ip-geo-base data
*
* @throws \yii\base\Exception
*/
public function actionUpdate()
{
$migrate = new Migration();
$migrate->dropForeignKey('fk-geobase_contact-geobase_city_id', 'geobase_contact');
$ipGeoBase = new IpGeoBase();
$ipGeoBase->updateDB();
$migrate->addForeignKey('fk-geobase_contact-geobase_city_id', 'geobase_contact', 'geobase_city_id', 'geobase_city', 'id', 'CASCADE', 'CASCADE');
}示例2: dropTable
public function dropTable()
{
if ($this->dropOriginTable) {
if (in_array($this->tableNameRaw, $this->_connection->schema->tableNames)) {
$schema = $this->_connection->schema->getTableSchema($this->tableNameRaw);
if ($schema) {
$keys = $schema->foreignKeys;
if (is_array($keys)) {
foreach ($keys as $name => $_next) {
$t = [];
foreach ($_next as $k => $v) {
if (!$k) {
$t['related_table'] = $v;
} else {
$t['related_field'] = $v;
$t['field'] = $k;
}
}
try {
$keyName = $this->getNameForeignKey($this->tableNameRaw, $t['related_table'], $_next[$t['field']], $t['related_field'], 255);
if ($this->hideMigrationOutput) {
ob_start();
}
$this->migrationClass->dropForeignKey($keyName, $this->tableNameRaw);
if ($this->hideMigrationOutput) {
ob_clean();
ob_flush();
}
} catch (\yii\db\Exception $exp) {
}
}
}
if ($this->hideMigrationOutput) {
ob_start();
}
try {
$this->migrationClass->dropTable($this->tableNameRaw);
} catch (\yii\db\Exception $exp) {
} catch (IntegrityException $exp) {
}
if ($this->hideMigrationOutput) {
ob_clean();
ob_flush();
}
}
}
}
}示例3: dropForeignKey
/**
* @inheritdoc
* Note: table will be auto pefixied if [[$autoWrapTableNames]] is true.
*/
public function dropForeignKey($name, $table)
{
$table = $this->autoWrappedTableName($table);
return parent::dropForeignKey($name, $table);
}示例4: remove
public function remove()
{
return $this->migrate->dropForeignKey($this->getName(), $this->getSourceTable());
}示例5: dropForeignKey
/**
* @inheritdoc
*/
public function dropForeignKey($name, $table)
{
$indexName = $name;
if (preg_match('/\\}\\}$/', $indexName)) {
$indexName = preg_replace('/^(.*)\\}\\}$/', '$1_idx}}', $indexName);
} else {
$indexName .= '_idx';
}
parent::dropForeignKey($name, $table);
$this->dropIndex($indexName, $table);
}示例6: dropForeignKey
/**
* Builds a SQL statement for dropping a foreign key constraint.
* @param string $table the table whose foreign is to be dropped. The name will be properly quoted by the method.
* @param string|array $columns the name of the column to that the constraint will be added on. If there are multiple columns, separate them with commas or use an array.
* @param string $name the name of the foreign key constraint to be dropped. The name will be properly quoted by the method.
*/
public function dropForeignKey($table, $columns, $name = null)
{
$name = $name ?: $this->getNameForeignKey($table, $columns);
parent::dropForeignKey($name, $table);
}