PHP yii\db\mysql Schema Examples

Example #1

File: Schema.php Project: ivan-chkv/yii2-gii-plus

 /**
  * @inheritdoc
  */
 protected function findConstraints($table)
 {
     parent::findConstraints($table);
     if (!count($table->foreignKeys)) {
         foreach ($table->columns as $column) {
             if (preg_match('~^(?:pk_|fk_|uk_|tk_)?(\\w+)_id$~', $column->name, $match) && $this->getTableSchema($match[1])) {
                 $table->foreignKeys[] = [$match[1], $match[0] => 'id'];
             }
         }
     }
 }