protected function getForeignKeys($src)
{
$matches = array();
$brackets = '\\(([^\\)]+)\\)';
$find = "/FOREIGN\\s+KEY\\s+{$brackets}\\s+REFERENCES\\s+([^\\(]+){$brackets}/i";
if (preg_match($find, $src, $matches)) {
$keys = preg_split('/,\\s+/', $matches[1]);
$fkeys = array();
foreach (preg_split('/,\\s+/', $matches[3]) as $i => $fkey) {
$fkeys[$keys[$i]] = $fkey;
}
return array('table' => str_replace('"', '', $matches[2]), 'keys' => $fkeys);
}
}