aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableRelations.m
diff options
context:
space:
mode:
Diffstat (limited to 'Source/SPTableRelations.m')
-rw-r--r--Source/SPTableRelations.m6
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];