1 files changed, 46 insertions, 47 deletions
diff --git a/Source/SPTableStructure.m b/Source/SPTableStructure.m
index 72c357d9..5b97c6b9 100644
--- a/Source/SPTableStructure.m
+++ b/Source/SPTableStructure.m
@@ -125,56 +125,55 @@ static NSString *SPRemoveFieldAndForeignKey = @"SPRemoveFieldAndForeignKey";
 
 	// Note that changing the contents or ordering of this array will affect the implementation of 
 	// SPTableFieldValidation. See it's implementation file for more details.
-	typeSuggestions = [[NSArray arrayWithObjects:
-		@"TINYINT",
-		@"SMALLINT",
-		@"MEDIUMINT",
-		@"INT",
-		@"BIGINT",
-		@"FLOAT",
-		@"DOUBLE",
-		@"DOUBLE PRECISION",
-		@"REAL",
-		@"DECIMAL",
-		@"BIT",
-		@"SERIAL",
-		@"BOOL",
-		@"BOOLEAN",
-		@"DEC",
-		@"FIXED",
-		@"NUMERIC",
+	typeSuggestions = [@[
+		SPMySQLTinyIntType,
+		SPMySQLSmallIntType,
+		SPMySQLMediumIntType,
+		SPMySQLIntType,
+		SPMySQLBigIntType,
+		SPMySQLFloatType,
+		SPMySQLDoubleType,
+		SPMySQLDoublePrecisionType,
+		SPMySQLRealType,
+		SPMySQLDecimalType,
+		SPMySQLBitType,
+		SPMySQLSerialType,
+		SPMySQLBoolType,
+		SPMySQLBoolean,
+		SPMySQLDecType,
+		SPMySQLFixedType,
+		SPMySQLNumericType,
 		@"--------",
-		@"CHAR",
-		@"VARCHAR",
-		@"TINYTEXT",
-		@"TEXT",
-		@"MEDIUMTEXT",
-		@"LONGTEXT",
-		@"TINYBLOB",
-		@"MEDIUMBLOB",
-		@"BLOB",
-		@"LONGBLOB",
-		@"BINARY",
-		@"VARBINARY",
-		@"ENUM",
-		@"SET",
+		SPMySQLCharType,
+		SPMySQLVarCharType,
+		SPMySQLTinyTextType,
+		SPMySQLTextType,
+		SPMySQLMediumTextType,
+		SPMySQLLongTextType,
+		SPMySQLTinyBlobType,
+		SPMySQLMediumBlobType,
+		SPMySQLBlobType,
+		SPMySQLLongBlobType,
+		SPMySQLBinaryType,
+		SPMySQLVarBinaryType,
+		SPMySQLEnumType,
+		SPMySQLSetType,
 		@"--------",
-		@"DATE",
-		@"DATETIME",
-		@"TIMESTAMP",
-		@"TIME",
-		@"YEAR",
+		SPMySQLDateType,
+		SPMySQLDatetimeType,
+		SPMySQLTimestampType,
+		SPMySQLTimeType,
+		SPMySQLYearType,
 		@"--------",
-		@"GEOMETRY",
-		@"POINT",
-		@"LINESTRING",
-		@"POLYGON",
-		@"MULTIPOINT",
-		@"MULTILINESTRING",
-		@"MULTIPOLYGON",
-		@"GEOMETRYCOLLECTION",
-		nil] retain];
-	
+		SPMySQLGeometryType,
+		SPMySQLPointType,
+		SPMySQLLineStringType,
+		SPMySQLPolygonType,
+		SPMySQLMultiPointType,
+		SPMySQLMultiLineStringType,
+		SPMySQLMultiPolygonType,
+		SPMySQLGeometryCollectionType] retain];
+
 	[fieldValidation setFieldTypes:typeSuggestions];
 	
 	// Add observers for document task activity