protected function getForeignKeys($table)
{
$sql = "PRAGMA foreign_key_list({$table})";
$command = $this->getDbConnection()->createCommand($sql);
$fkeys = array();
foreach ($command->query() as $col) {
$fkeys[$col['table']]['keys'][$col['from']] = $col['to'];
$fkeys[$col['table']]['table'] = $col['table'];
}
return count($fkeys) > 0 ? array_values($fkeys) : $fkeys;
}