aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableData.m
diff options
context:
space:
mode:
authorBibiko <bibiko@eva.mpg.de>2010-11-01 11:04:01 +0000
committerBibiko <bibiko@eva.mpg.de>2010-11-01 11:04:01 +0000
commit7587849d307c6c0a7fa11ddbc2ee48af87ab9087 (patch)
tree3ae2092799de52002d553baa463a0c04878439f1 /Source/SPTableData.m
parenta6325dbb88629e7bc5e170bb23955ebf1910c17b (diff)
downloadsequelpro-7587849d307c6c0a7fa11ddbc2ee48af87ab9087.tar.gz
sequelpro-7587849d307c6c0a7fa11ddbc2ee48af87ab9087.tar.bz2
sequelpro-7587849d307c6c0a7fa11ddbc2ee48af87ab9087.zip
• improved Structure editing logic to allow to choose auto_increment for Extra only if table has no auto_increment field set since MySQL allows only one auto column
- the user has still the chance to type 'auto_increment' into the Extra manually
Diffstat (limited to 'Source/SPTableData.m')
-rw-r--r--Source/SPTableData.m8
1 files changed, 8 insertions, 0 deletions
diff --git a/Source/SPTableData.m b/Source/SPTableData.m
index e39635c7..404395b9 100644
--- a/Source/SPTableData.m
+++ b/Source/SPTableData.m
@@ -34,6 +34,8 @@
@implementation SPTableData
@synthesize isWorking;
+@synthesize tableHasAutoIncrementField;
+;
/**
* Init class.
@@ -51,6 +53,8 @@
tableCreateSyntax = nil;
mySQLConnection = nil;
isWorking = NO;
+ tableHasAutoIncrementField = NO;
+
}
return self;
@@ -385,6 +389,7 @@
[columns removeAllObjects];
[columnNames removeAllObjects];
[constraints removeAllObjects];
+ tableHasAutoIncrementField = NO;
if( [tableListInstance tableType] == SPTableTypeTable || [tableListInstance tableType] == SPTableTypeView ) {
tableData = [self informationForTable:[tableListInstance tableName]];
@@ -425,6 +430,8 @@
NSDictionary *columnData;
NSEnumerator *enumerator;
+ tableHasAutoIncrementField = NO;
+
if (viewData == nil) {
[columns removeAllObjects];
[columnNames removeAllObjects];
@@ -1244,6 +1251,7 @@
// Whether fields should auto-increment
} else if ([detailString isEqualToString:@"AUTO_INCREMENT"]) {
[fieldDetails setValue:boolYES forKey:@"autoincrement"];
+ tableHasAutoIncrementField = YES;
// Field defaults
} else if ([detailString isEqualToString:@"DEFAULT"] && (definitionPartsIndex + 1 < partsArrayLength)) {