diff options
| author | rowanbeentje <rowan@beent.je> | 2010-01-21 00:45:34 +0000 |
|---|---|---|
| committer | rowanbeentje <rowan@beent.je> | 2010-01-21 00:45:34 +0000 |
| commit | ce340132e43b5f0d90286704d1232f77f6ffbc8a (patch) | |
| tree | 6c37a93a9f97ad82ac3317e84c46952577478528 | |
| parent | 3eb2dc85b5bd6e2efcb65a900293627d0d977078 (diff) | |
| download | sequelpro-ce340132e43b5f0d90286704d1232f77f6ffbc8a.tar.gz sequelpro-ce340132e43b5f0d90286704d1232f77f6ffbc8a.tar.bz2 sequelpro-ce340132e43b5f0d90286704d1232f77f6ffbc8a.zip | |
- Correctly escape field names when creating foreign keys, and escape the database name when looking up tables to add to the dropdown. Addresses Issue #537.
| -rw-r--r-- | Source/SPTableRelations.m | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Source/SPTableRelations.m b/Source/SPTableRelations.m index ee72fd3a..acb5c29c 100644 --- a/Source/SPTableRelations.m +++ b/Source/SPTableRelations.m @@ -115,9 +115,9 @@ NSString *query = [NSString stringWithFormat:@"ALTER TABLE %@ ADD FOREIGN KEY (%@) REFERENCES %@ (%@)", [thisTable backtickQuotedString], - thisColumn, + [thisColumn backtickQuotedString], [thatTable backtickQuotedString], - thatColumn]; + [thatColumn backtickQuotedString]]; // If required add ON DELETE if ([onDeletePopUpButton indexOfSelectedItem] > 0) { @@ -176,7 +176,7 @@ [refTablePopUpButton removeAllItems]; // Get all InnoDB tables in the current database - MCPResult *result = [connection queryString:[NSString stringWithFormat:@"SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND engine = 'InnoDB' AND table_schema = '%@'", [tableDocumentInstance database]]]; + MCPResult *result = [connection queryString:[NSString stringWithFormat:@"SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND engine = 'InnoDB' AND table_schema = %@", [[tableDocumentInstance database] tickQuotedString]]]; [result dataSeek:0]; |