-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Philip M. Gollucci wrote: | Hi all, | | http://www.freebsd.org/cgi/query-pr.cgi?pr=123905 | | The attached patch is required to have the ALTER statements parse as vaild | SQL. I guess this must be a MySQL 5.1 thing since it looks like MySQL | 5.0 is | the primary testing location. It is back-compatible. If would help more if I updated the generated and sent that -- svn diff Index: Kernel/System/DB/mysql.pm =================================================================== - --- Kernel/System/DB/mysql.pm (revision 9224) +++ Kernel/System/DB/mysql.pm (working copy) @@ -397,7 +397,7 @@ ~ } ~ my $SQL = "ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; ~ $SQL .= "$Param{Local}) REFERENCES "; - - $SQL .= "`$Param{ForeignTableName}`(`$Param{Foreign}`)"; + $SQL .= "`$Param{ForeignTableName}($Param{Foreign})`"; ~ # return SQL ~ return ($SQL); ~ } - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.8 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFINbiddbiP+9ubjBwRAuE4AJ0UUYjEfrO7ivbBIX1cKb1cDw8ujgCfZInW xAetWwhVQc5leZECDG7Obbw= =zJo9 -----END PGP SIGNATURE-----