diff options
| -rw-r--r-- | Source/SPSQLExporter.m | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/Source/SPSQLExporter.m b/Source/SPSQLExporter.m index 10f039f6..fa1df5d0 100644 --- a/Source/SPSQLExporter.m +++ b/Source/SPSQLExporter.m @@ -884,7 +884,11 @@ if ([[column objectForKey:@"unsigned"] integerValue] == 1) [fieldString appendString:@" UNSIGNED"]; if ([[column objectForKey:@"zerofill"] integerValue] == 1) [fieldString appendString:@" ZEROFILL"]; if ([[column objectForKey:@"binary"] integerValue] == 1) [fieldString appendString:@" BINARY"]; - if ([[column objectForKey:@"null"] integerValue] == 0) [fieldString appendString:@" NOT NULL"]; + if ([[column objectForKey:@"null"] integerValue] == 0) { + [fieldString appendString:@" NOT NULL"]; + } else { + [fieldString appendString:@" NULL"]; + } // Provide the field default if appropriate if ([column objectForKey:@"default"]) { |