diff options
| -rw-r--r-- | Source/TableDump.m | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/Source/TableDump.m b/Source/TableDump.m index 55f81e1a..994b45bc 100644 --- a/Source/TableDump.m +++ b/Source/TableDump.m @@ -2453,8 +2453,12 @@ // Provide the field default if appropriate if ([column objectForKey:@"default"]) { + + // Some MySQL server versions show a default of NULL for NOT NULL columns - don't export those. if ([[column objectForKey:@"default"] isEqualToString:@"NULL"]) { - [fieldString appendString:@" DEFAULT NULL"]; + if ([[column objectForKey:@"null"] intValue]) + [fieldString appendString:@" DEFAULT NULL"]; + } else if ([[column objectForKey:@"type"] isEqualToString:@"TIMESTAMP"] && [[[column objectForKey:@"default"] uppercaseString] isEqualToString:@"CURRENT_TIMESTAMP"]) { [fieldString appendString:@" DEFAULT CURRENT_TIMESTAMP"]; |