-----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 ([EMAIL PROTECTED])
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-----
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
