aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--Source/SPTableFieldValidation.m2
-rw-r--r--Source/SPTablesList.m2
2 files changed, 2 insertions, 2 deletions
diff --git a/Source/SPTableFieldValidation.m b/Source/SPTableFieldValidation.m
index ceee9b3b..0811aa33 100644
--- a/Source/SPTableFieldValidation.m
+++ b/Source/SPTableFieldValidation.m
@@ -25,7 +25,7 @@
#import "SPTableFieldValidation.h"
-@interface SPTableFieldValidation (PrivateAPI)
+@interface SPTableFieldValidation ()
- (NSString *)_formatType:(NSString *)type;
diff --git a/Source/SPTablesList.m b/Source/SPTablesList.m
index fe43c845..be9e54d7 100644
--- a/Source/SPTablesList.m
+++ b/Source/SPTablesList.m
@@ -2196,7 +2196,7 @@ static NSString *SPDuplicateTable = @"SPDuplicateTable";
engineStatement = [NSString stringWithFormat:@"%@ = %@", [[tableDocumentInstance serverSupport] engineTypeQueryName], [tableType backtickQuotedString]];
}
- NSString *createStatement = [NSString stringWithFormat:@"CREATE TABLE %@ (%@) %@ %@", [tableName backtickQuotedString], ([tableType isEqualToString:@"CSV"]) ? @"id INT NOT NULL" : @"id INT", charSetStatement, engineStatement];
+ NSString *createStatement = [NSString stringWithFormat:@"CREATE TABLE %@ (id INT(11) UNSIGNED NOT NULL%@) %@ %@", [tableName backtickQuotedString], [tableType isEqualToString:@"CSV"] ? @"" : @" PRIMARY KEY AUTO_INCREMENT", charSetStatement, engineStatement];
// Create the table
[mySQLConnection queryString:createStatement];