Fix Issue #140 (Tables with many columns compress the end columns against the end of the table):

 - Set column sizing to "Uniform" , instead of "Sequential" - "Sequential" autosized columns so that all columns remained visible within the table, with as many columns as possible at full width, resulting in many columns being set to their minimum width.
 - Automatically delete saved column widths which are at minimum width on first run of this new version.  This will delete columns intentionally set to minimum idth (once), but otherwise all tables which had their columns autoresized had the minimum/broken widths saved so even the fix above would not show.
 - Remove old CocoaMySQL prefs upgrade code, and store the last run bundle version in the code to allow prefs upgrades to occur according to the build number in future.

2 files changed, 58 insertions, 101 deletions

diff --git a/Interfaces/English.lproj/DBView.xib b/Interfaces/English.lproj/DBView.xib
index 98620b04..aa299e49 100644
--- a/Interfaces/English.lproj/DBView.xib
+++ b/Interfaces/English.lproj/DBView.xib
@@ -8,7 +8,7 @@
 		<string key="IBDocument.HIToolboxVersion">353.00</string>
 		<object class="NSMutableArray" key="IBDocument.EditedObjectIDs">
 			<bool key="EncodedWithXMLCoder">YES</bool>
-			<integer value="27"/>
+			<integer value="676"/>
 		</object>
 		<object class="NSArray" key="IBDocument.PluginDependencies">
 			<bool key="EncodedWithXMLCoder">YES</bool>
@@ -2565,7 +2565,7 @@
 																									<reference key="NSGridColor" ref="864903678"/>
 																									<double key="NSRowHeight">1.600000e+01</double>
 																									<int key="NSTvFlags">1522532352</int>
-																									<int key="NSColumnAutoresizingStyle">2</int>
+																									<int key="NSColumnAutoresizingStyle">0</int>
 																									<int key="NSDraggingSourceMaskForLocal">15</int>
 																									<int key="NSDraggingSourceMaskForNonLocal">0</int>
 																									<bool key="NSAllowsTypeSelect">YES</bool>
diff --git a/Source/MainController.m b/Source/MainController.m
index 597adc16..f05d7046 100644
--- a/Source/MainController.m
+++ b/Source/MainController.m
@@ -636,117 +636,74 @@ checks for updates and opens download page in default browser
 
 - (void)awakeFromNib
 {
-	NSEnumerator *enumerator;
-	id favorite;
-	NSString *name, *host, *user, *database, *password;
-	//int code;
+	int currentVersionNumber;
 
-	//register MainController as services provider
+	// Register MainController as services provider
 	[NSApp setServicesProvider:self];
 
-	//register MainController for AppleScript events
-	[[ NSScriptExecutionContext sharedScriptExecutionContext] setTopLevelObject: self ];
-	
+	// Register MainController for AppleScript events
+	[[NSScriptExecutionContext sharedScriptExecutionContext] setTopLevelObject:self];
+
+	// Get the current bundle version number (the SVN build number) for per-version upgrades
+	currentVersionNumber = [[[[NSBundle mainBundle] infoDictionary] objectForKey:@"CFBundleVersion"] intValue];
+
 	prefs = [[NSUserDefaults standardUserDefaults] retain];
 	isNewFavorite = NO;
 	[prefs registerDefaults:[NSDictionary dictionaryWithObjectsAndKeys:
-							 [NSNumber numberWithBool:YES], @"limitRows",
-							 [NSNumber numberWithInt:1000], @"limitRowsValue",
-							 nil]];
-
-	//set standard preferences if no preferences are found
-	if ( [prefs objectForKey:@"reloadAfterAdding"] == nil )
-	{
-		[prefs setObject:@"0.3" forKey:@"version"];
-		[prefs setBool:YES forKey:@"reloadAfterAdding"];
-		[prefs setBool:YES forKey:@"reloadAfterEditing"];
-		[prefs setBool:NO forKey:@"reloadAfterRemoving"];
-		[prefs setObject:@"NULL" forKey:@"nullValue"];
-		//[prefs setBool:YES forKey:@"showError"];
-		//[prefs setBool:NO forKey:@"dontShowBlob"];
-		//[prefs setBool:NO forKey:@"limitRows"];
-		//[prefs setInteger:100 forKey:@"limitRowsValue"];
-		//[prefs setObject:[NSString stringWithString:NSHomeDirectory()] forKey:@"savePath"];
-		//[prefs setObject:[NSString stringWithString:NSHomeDirectory()] forKey:@"openPath"];
-	}
-
-	//new preferences and changes in v0.4
-	if ( [prefs objectForKey:@"showError"] == nil )	{
-		[prefs setObject:@"0.4" forKey:@"version"];
-		
-		//set standard values for new preferences
-		[prefs setBool:YES forKey:@"showError"];
-		[prefs setBool:NO forKey:@"dontShowBlob"];
-		//[prefs setBool:NO forKey:@"limitRows"];
-		//[prefs setInteger:100 forKey:@"limitRowsValue"];
-		[prefs setObject:[NSString stringWithString:NSHomeDirectory()] forKey:@"savePath"];
-		[prefs setObject:[NSString stringWithString:NSHomeDirectory()] forKey:@"openPath"];
-		
-		//remove old preferences
-		[prefs removeObjectForKey:@"allowDragAndDropReordering"];
-		
-		//rewrite passwords to keychain (with new format)
-		if ( [prefs objectForKey:@"favorites"] ) {
-			NSRunAlertPanel(NSLocalizedString(@"Warning", @"warning"), NSLocalizedString(@"With version 0.4 Sequel Pro has introduced a new format to save passwords in the Keychain.\nPlease allow Sequel Pro to decrypt all passwords of your favorites. Otherwise you have to reenter all passwords of your saved favorites in the Preferences.", @"message of panel when passwords have to be updated for v0.4"), NSLocalizedString(@"OK", @"OK button"), nil, nil);
-			enumerator = [[prefs objectForKey:@"favorites"] objectEnumerator];
-
-			while ( (favorite = [enumerator nextObject]) ) {
-				//replace password
-				name = [favorite objectForKey:@"name"];
-				host = [favorite objectForKey:@"host"];
-				user = [favorite objectForKey:@"user"];
-				database = [favorite objectForKey:@"database"];
-				password = [keyChainInstance getPasswordForName:[NSString stringWithFormat:@"%@/%@", host, database]
-								account:user];
-				[keyChainInstance deletePasswordForName:[NSString stringWithFormat:@"%@/%@", host, database] account:user];
-				if ( ![password isEqualToString:@""] )
-					[keyChainInstance addPassword:password
-						forName:[NSString stringWithFormat:@"Sequel Pro : %@", name]
-						account:[NSString stringWithFormat:@"%@@%@/%@", user, host, database]];
+							[NSNumber numberWithBool:YES], @"reloadAfterAdding",
+							[NSNumber numberWithBool:YES], @"reloadAfterEditing",
+							[NSNumber numberWithBool:NO], @"reloadAfterRemoving",
+							[NSString stringWithString:@"NULL"], @"nullValue",
+							[NSNumber numberWithBool:YES], @"showError",
+							[NSNumber numberWithBool:NO], @"dontShowBlob",
+							[NSString stringWithString:NSHomeDirectory()], @"savePath",
+							[NSString stringWithString:NSHomeDirectory()], @"openPath",
+							[NSString stringWithString:@"Autodetect"], @"encoding",
+							[NSNumber numberWithBool:NO], @"useMonospacedFonts",
+							[NSNumber numberWithBool:YES], @"fetchRowCount",
+							[NSNumber numberWithBool:YES], @"limitRows",
+							[NSNumber numberWithInt:1000], @"limitRowsValue",
+							nil]];
+
+	// If no version number is present in prefs, and column widths have been saved, walk through
+	// them and remove any table widths set to 15 or less (fix for mangled columns caused by Issue #140)
+	if ([prefs objectForKey:@"lastUsedVersion"] == nil && [prefs objectForKey:@"tableColumnWidths"] != nil) {
+		NSEnumerator *databaseEnumerator, *tableEnumerator, *columnEnumerator;
+		NSString *databaseKey, *tableKey, *columnKey;
+		NSMutableDictionary *newDatabase, *newTable;
+		float columnWidth;
+		NSMutableDictionary *newTableColumnWidths = [[NSMutableDictionary alloc] init];
+
+		databaseEnumerator = [[prefs objectForKey:@"tableColumnWidths"] keyEnumerator];
+		while (databaseKey = [databaseEnumerator nextObject]) {
+			newDatabase = [[NSMutableDictionary alloc] init];
+			tableEnumerator = [[[prefs objectForKey:@"tableColumnWidths"] objectForKey:databaseKey] keyEnumerator];
+			while (tableKey = [tableEnumerator nextObject]) {
+				newTable = [[NSMutableDictionary alloc] init];
+				columnEnumerator = [[[[prefs objectForKey:@"tableColumnWidths"] objectForKey:databaseKey] objectForKey:tableKey] keyEnumerator];
+				while (columnKey = [columnEnumerator nextObject]) {
+					columnWidth = [[[[[prefs objectForKey:@"tableColumnWidths"] objectForKey:databaseKey] objectForKey:tableKey] objectForKey:columnKey] floatValue];
+					if (columnWidth >= 15) {
+						[newTable setObject:[NSNumber numberWithFloat:columnWidth] forKey:[NSString stringWithString:columnKey]];
+					}
+				}
+				if ([newTable count]) {
+					[newDatabase setObject:[NSDictionary dictionaryWithDictionary:newTable] forKey:[NSString stringWithString:tableKey]];
+				}
+				[newTable release];
 			}
-		}
-	}
-	
-	//new preferences and changes in v0.5
-	if ( [[prefs objectForKey:@"version"] isEqualToString:@"0.4"] )	{
-		[prefs setObject:@"0.5" forKey:@"version"];
-		
-		//set standard values for new preferences
-		[prefs setObject:@"ISO Latin 1" forKey:@"encoding"];
-		[prefs setBool:NO forKey:@"useMonospacedFonts"];
-		
-		//add socket field to favorites
-		if ( [prefs objectForKey:@"favorites"] ) {
-			NSMutableArray *tempFavorites = [NSMutableArray array];
-			NSMutableDictionary *tempFavorite;
-			enumerator = [[prefs objectForKey:@"favorites"] objectEnumerator];
-			while ( (favorite = [enumerator nextObject]) ) {
-				tempFavorite = [NSMutableDictionary dictionaryWithDictionary:favorite];
-				[tempFavorite setObject:@"" forKey:@"socket"];
-				[tempFavorites addObject:[NSDictionary dictionaryWithDictionary:tempFavorite]];
+			if ([newDatabase count]) {
+				[newTableColumnWidths setObject:[NSDictionary dictionaryWithDictionary:newDatabase] forKey:[NSString stringWithString:databaseKey]];
 			}
-			[prefs setObject:tempFavorites forKey:@"favorites"];
+			[newDatabase release];
 		}
+		[prefs setObject:[NSDictionary dictionaryWithDictionary:newTableColumnWidths] forKey:@"tableColumnWidths"];
+		[newTableColumnWidths release];
 	}
 	
-	//new preferences and changes in v0.7
-	if ( [[prefs objectForKey:@"version"] isEqualToString:@"0.5"] ||
-			[[prefs objectForKey:@"version"] isEqualToString:@"0.6beta"] ||
-			[[prefs objectForKey:@"version"] isEqualToString:@"0.7b2"] )
-	{
-		[prefs setObject:@"0.7b3" forKey:@"version"];
-		[prefs setObject:@"Autodetect" forKey:@"encoding"];
-		[prefs setBool:YES forKey:@"fetchRowCount"];
-	}
+	// Write the current bundle version to the prefs
+	[prefs setObject:[NSNumber numberWithInt:currentVersionNumber] forKey:@"lastUsedVersion"];
 
-//set up interface
-/*
-	enumerator = [tableColumns objectEnumerator];
-	while ( (column = [enumerator nextObject]) )
-	{
-		[[column dataCell] setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
-	}
-*/
 	[tableView registerForDraggedTypes:[NSArray arrayWithObjects:@"SequelProPreferencesPasteboard", nil]];
 	[tableView reloadData];
 }