CREATE TABLE Sheet1(Version VARCHAR(10),SETTINGS VARCHAR(10),Column_3 VARCHAR(10),Column_4 VARCHAR(10),Column_5 VARCHAR(10),Column_6 VARCHAR(10),Column_7 VARCHAR(10),Column_8 VARCHAR(10),Column_9 VARCHAR(10),Column_10 VARCHAR(10),Column_11 VARCHAR(10),Column_12 VARCHAR(10),Column_13 VARCHAR(10),Column_14 VARCHAR(10),Column_15 VARCHAR(10),Column_16 VARCHAR(10),Column_17 VARCHAR(10),Column_18 VARCHAR(10),Column_19 VARCHAR(10),Column_20 VARCHAR(10),Column_21 VARCHAR(10),Column_22 VARCHAR(10),Column_23 VARCHAR(10),Column_24 VARCHAR(10),Column_25 VARCHAR(10),Column_26 VARCHAR(10),Column_27 VARCHAR(10),Column_28 VARCHAR(10),Column_29 VARCHAR(10),Column_30 VARCHAR(10),Column_31 VARCHAR(10),Column_32 VARCHAR(10),Column_33 VARCHAR(10),Column_34 VARCHAR(10),Column_35 VARCHAR(10),Column_36 VARCHAR(10),Column_37 VARCHAR(10),Column_38 VARCHAR(10),Column_39 VARCHAR(10),Column_40 VARCHAR(10),Column_41 VARCHAR(10),Column_42 VARCHAR(10),Column_43 VARCHAR(10),Column_44 VARCHAR(10),Column_45 VARCHAR(10),Column_46 VARCHAR(10),Column_47 VARCHAR(10),Column_48 VARCHAR(10),Column_49 VARCHAR(10),Column_50 VARCHAR(10),Column_51 VARCHAR(10),Column_52 VARCHAR(10),Column_53 VARCHAR(10),Column_54 VARCHAR(10),Column_55 VARCHAR(10),Column_56 VARCHAR(10),Column_57 VARCHAR(10),Column_58 VARCHAR(10),Column_59 VARCHAR(10),METADATA VARCHAR(10),Column_61 VARCHAR(10),Column_62 VARCHAR(10),Column_63 VARCHAR(10),Column_64 VARCHAR(10),Column_65 VARCHAR(10),Column_66 VARCHAR(10),Column_67 VARCHAR(10),Column_68 VARCHAR(10),Column_69 VARCHAR(10),Column_70 VARCHAR(10),Column_71 VARCHAR(10),Column_72 VARCHAR(10),Column_73 VARCHAR(10),Column_74 VARCHAR(10),Column_75 VARCHAR(10),Column_76 VARCHAR(10),Column_77 VARCHAR(10),Column_78 VARCHAR(10),Column_79 VARCHAR(10),Column_80 VARCHAR(10),Column_81 VARCHAR(10),Column_82 VARCHAR(10),Column_83 VARCHAR(10),Column_84 VARCHAR(10),Column_85 VARCHAR(10),Column_86 VARCHAR(10),Column_87 VARCHAR(10),Column_88 VARCHAR(10),Column_89 VARCHAR(10),Column_90 VARCHAR(10),Column_91 VARCHAR(10),Column_92 VARCHAR(10),Column_93 VARCHAR(10),Column_94 VARCHAR(10),Column_95 VARCHAR(10),Column_96 VARCHAR(10),Column_97 VARCHAR(10),Column_98 VARCHAR(10),Column_99 VARCHAR(10),Column_100 VARCHAR(10),Column_101 VARCHAR(10),Column_102 VARCHAR(10),Column_103 VARCHAR(10),Column_104 VARCHAR(10),Column_105 VARCHAR(10),Column_106 VARCHAR(10),Column_107 VARCHAR(10),Column_108 VARCHAR(10),Column_109 VARCHAR(10),Column_110 VARCHAR(10),Column_111 VARCHAR(10),Column_112 VARCHAR(10),Column_113 VARCHAR(10),Column_114 VARCHAR(10),Column_115 VARCHAR(10),Column_116 VARCHAR(10),Column_117 VARCHAR(10),Column_118 VARCHAR(10),Column_119 VARCHAR(10),Column_120 VARCHAR(10),Column_121 VARCHAR(10),Column_122 VARCHAR(10),Column_123 VARCHAR(10),Column_124 VARCHAR(10),Column_125 VARCHAR(10),Column_126 VARCHAR(10),Column_127 VARCHAR(10),Column_128 VARCHAR(10),Column_129 VARCHAR(10),Column_130 VARCHAR(10),PLUGINDATA VARCHAR(10),QUERYDATA VARCHAR(10),LINKEDMODELS VARCHAR(10));
INSERT INTO Sheet1 (Version,SETTINGS,Column_3,Column_4,Column_5,Column_6,Column_7,Column_8,Column_9,Column_10,Column_11,Column_12,Column_13,Column_14,Column_15,Column_16,Column_17,Column_18,Column_19,Column_20,Column_21,Column_22,Column_23,Column_24,Column_25,Column_26,Column_27,Column_28,Column_29,Column_30,Column_31,Column_32,Column_33,Column_34,Column_35,Column_36,Column_37,Column_38,Column_39,Column_40,Column_41,Column_42,Column_43,Column_44,Column_45,Column_46,Column_47,Column_48,Column_49,Column_50,Column_51,Column_52,Column_53,Column_54,Column_55,Column_56,Column_57,Column_58,Column_59,METADATA,Column_61,Column_62,Column_63,Column_64,Column_65,Column_66,Column_67,Column_68,Column_69,Column_70,Column_71,Column_72,Column_73,Column_74,Column_75,Column_76,Column_77,Column_78,Column_79,Column_80,Column_81,Column_82,Column_83,Column_84,Column_85,Column_86,Column_87,Column_88,Column_89,Column_90,Column_91,Column_92,Column_93,Column_94,Column_95,Column_96,Column_97,Column_98,Column_99,Column_100,Column_101,Column_102,Column_103,Column_104,Column_105,Column_106,Column_107,Column_108,Column_109,Column_110,Column_111,Column_112,Column_113,Column_114,Column_115,Column_116,Column_117,Column_118,Column_119,Column_120,Column_121,Column_122,Column_123,Column_124,Column_125,Column_126,Column_127,Column_128,Column_129,Column_130,PLUGINDATA,QUERYDATA,LINKEDMODELS) VALUES 
('','GLOBALSETTINGS','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','DATATYPEGROUPS','','DATATYPES','','','','','','','','','','','','','','COMMON_DATATYPES','TABLEPREFIXES','REGIONCOLORS','POSITIONMARKERS','','','REGIONS','TABLES','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','RELATIONS','','','','','','','','','','','','','','','','','','','','','','','','','','','NOTES','IMAGES','PLUGINDATARECORDS','QUERYRECORDS',''),
('','ModelName','IDModel','IDVersion','VersionStr','Comments','UseVersionHistroy','AutoIncVersion','DatabaseType','ZoomFac','XPos','YPos','DefaultDataType','DefaultTablePrefix','DefSaveDBConn','DefSyncDBConn','DefQueryDBConn','Printer','HPageCount','PageAspectRatio','PageOrientation','PageFormat','SelectedPages','UsePositionGrid','PositionGridX','PositionGridY','TableNameInRefs','DefaultTableType','ActivateRefDefForNewRelations','FKPrefix','FKPostfix','CreateFKRefDefIndex','DBQuoteCharacter','CreateSQLforLinkedObjects','DefModelFont','CanvasWidth','CanvasHeight','DATATYPEGROUP','','DATATYPE','','','','','','','','','','','','','','COMMON_DATATYPE','TABLEPREFIX','REGIONCOLOR','POSITIONMARKER','','','','TABLE','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','RELATION','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Name','Icon','ID','IDGroup','TypeName','Description','ParamCount','OptionCount','ParamRequired','EditParamsAsString','SynonymGroup','PhysicalMapping','PhysicalTypeName','PARAMS','OPTIONS','','ID','Name','Color','ZoomFac','X','Y','','ID','Tablename','PrevTableName','XPos','YPos','TableType','TablePrefix','nmTable','Temporary','UseStandardInserts','StandardInserts','TableOptions','Comments','Collapsed','IsLinkedObject','IDLinkedModel','Obj_id_Linked','OrderPos','COLUMNS','','','','','','','','','','','','','','','RELATIONS_START','INDICES','','','','','','RELATIONS_END','ID','RelationName','Kind','SrcTable','DestTable','FKFields','FKFieldsComments','relDirection','MidOffset','OptionalStart','OptionalEnd','CaptionOffsetX','CaptionOffsetY','StartIntervalOffsetX','StartIntervalOffsetY','EndIntervalOffsetX','EndIntervalOffsetY','CreateRefDef','Invisible','RefDef','Comments','FKRefDefIndex_Obj_id','Splitted','IsLinkedObject','IDLinkedModel','Obj_id_Linked','OrderPos','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','PARAM','OPTION','','','','','','','','','','','','','','','','','','','','','','','','','','','COLUMN','','','','','','','','','','','','','','','RELATION_START','INDEX','','','','','','RELATION_END','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Name','Name','Default','','','','','','','','','','','','','','','','','','','','','','','','','','ID','ColName','PrevColName','Pos','idDatatype','DatatypeParams','Width','Prec','PrimaryKey','NotNull','AutoInc','IsForeignKey','DefaultValue','Comments','OPTIONSELECTED','ID','ID','IndexName','IndexKind','FKRefDef_Obj_id','INDEXCOLUMNS','','ID','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','OPTIONSELECT','','','','','','INDEXCOLUMN','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Value','','','','','','idColumn','LengthParam','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('4.0','dbd projeto','0','0','1.0.0.0','','1','1','MySQL','100.00','0','0','5','0','','','','','4.0','1.440892512336408','1','A4 (210x297 mm, 8.26x11.7 inches)','','0','20','20','1','0','1','','','1','`','0','Tahoma','4096','2842','Numeric Types','1','1','0','TINYINT','A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.','1','2','0','0','0','0','','length','UNSIGNED','1','47','Default (no prefix)','Red=#FFEEEC','-1.0','0','0','','1000','macewer','Table_01','158','195','0','0','0','0','0','\n','DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n','','0','0','-1','-1','2','1002','idmacewer','','0','20','(17)','-1','-1','1','1','0','0','','','0','1020','1003','PRIMARY','0','-1','1002','0','','1020','Rel_01','2','1000','1009','idmacewer=macewer_idmacewer\n','\n','2','0','0','0','0','0','0','0','0','0','1','0','Matching=0\nOnDelete=3\nOnUpdate=3\n','','1022','0','0','-1','-1','4','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Date and Time Types','2','','','','','','','','','','','','','ZEROFILL','0','48','','Yellow=#FEFDED','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1006','nome','','1','20','(25)','-1','-1','0','0','0','0','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','String Types','3','2','0','SMALLINT','A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.','1','2','0','0','0','0','','length','UNSIGNED','1','49','','Green=#EAFFE5','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1007','contador','','2','5','','-1','-1','0','0','0','0','0','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Blob and Text Types','4','','','','','','','','','','','','','ZEROFILL','0','50','','Cyan=#ECFDFF','-1.0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','User defined Types','5','3','0','MEDIUMINT','A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.','1','2','0','0','0','0','','length','UNSIGNED','1','51','','Blue=#F0F1FE','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1008','ativo','','3','22','','-1','-1','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Geographic Types','6','','','','','','','','','','','','','ZEROFILL','0','44','','Magenta=#FFEBFA','-1.0','0','0','','1009','leituraewer','Table_02','392','265','0','0','0','0','0','\n','DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n','','0','0','-1','-1','3','1012','idleituraewer','idTable_02','0','5','','-1','-1','1','1','1','0','','','1','','1013','PRIMARY','0','-1','1012','0','1020','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Common data types','3','4','0','INT','A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.','1','2','0','0','1','0','','length','UNSIGNED','0','45','','','-1.0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','','1022','leituraewer_FKIndex1','1','1020','1021','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','ZEROFILL','0','','','','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1021','macewer_idmacewer','','1','20','(17)','-1','-1','0','1','0','1','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','5','0','INTEGER','A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.','1','2','0','0','1','0','','length','UNSIGNED','1','','','','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1015','dataleitura','','1','14','','-1','-1','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','ZEROFILL','0','','','','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1016','horaleitura','','2','17','','-1','-1','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','6','0','BIGINT','A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.','1','2','0','0','0','0','','length','UNSIGNED','0','','','','-1.0','0','0','','','','','','','','','','','','','','','','','','','','1017','umidade','','3','11','','-1','-1','0','0','0','0','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','1018','temperatura','','4','11','','-1','-1','0','0','0','0','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','7','0','FLOAT','A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.','1','1','1','0','0','0','','precision','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','1019','luminosidade','','5','5','','-1','-1','0','0','0','0','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','8','0','FLOAT','A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.','2','1','0','0','0','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','9','0','DOUBLE','A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308.','2','1','0','0','2','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','10','0','DOUBLE PRECISION','This is a synonym for DOUBLE.','2','1','0','0','2','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','11','0','REAL','This is a synonym for DOUBLE.','2','1','0','0','2','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','12','0','DECIMAL','An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column.','2','1','0','0','3','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','13','0','NUMERIC','This is a synonym for DECIMAL.','2','1','1','0','3','0','','length','ZEROFILL','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','decimals','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','14','1','DATE','A date. The supported range is \a1000-01-01\a to \a9999-12-31\a.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','15','1','DATETIME','A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','16','1','TIMESTAMP','A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats.','1','0','0','0','0','0','','length','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','17','1','TIME','A time. The range is \a-838:59:59\a to \a838:59:59\a.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','18','1','YEAR','A year in 2- or 4-digit format (default is 4-digit).','1','0','0','0','0','0','','length','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','19','2','CHAR','A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given.','1','1','1','0','0','0','','length','BINARY','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','20','2','VARCHAR','A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given.','1','1','1','0','0','0','','length','BINARY','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','21','2','BIT','This is a synonym for CHAR(1).','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','22','2','BOOL','This is a synonym for CHAR(1).','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','23','3','TINYBLOB','A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','24','3','BLOB','A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','25','3','MEDIUMBLOB','A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','26','3','LONGBLOB','A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','27','3','TINYTEXT','A column maximum length of 255 (2^8 - 1) characters.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','28','3','TEXT','A column maximum length of 65535 (2^16 - 1) characters.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','29','3','MEDIUMTEXT','A column maximum length of 16777215 (2^24 - 1) characters.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','30','3','LONGTEXT','A column maximum length of 4294967295 (2^32 - 1) characters.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','31','3','ENUM','An enumeration. A string object that can have only one value, chosen from the list of values.','1','0','1','1','0','0','','values','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','32','3','SET','A set. A string object that can have zero or more values, each of which must be chosen from the list of values.','1','0','1','1','0','0','','values','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','33','4','Varchar(20)','','0','1','0','0','0','0','','','BINARY','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','34','4','Varchar(45)','','0','1','0','0','0','0','','','BINARY','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','35','4','Varchar(255)','','0','1','0','0','0','0','','','BINARY','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','36','5','GEOMETRY','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','38','5','LINESTRING','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','39','5','POLYGON','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','40','5','MULTIPOINT','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','41','5','MULTILINESTRING','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','42','5','MULTIPOLYGON','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','43','5','GEOMETRYCOLLECTION','Geographic Datatype','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','44','6','CHAR(1)','Common Boolean Format','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','45','6','CHAR(15)','Common DATE/TIME format (YYYYMMDDHHMMSSSSS)','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','47','6','CHAR','A common fixed-length string.','1','0','1','0','0','0','','length','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','48','6','VARCHAR','A common variable-length string.','1','0','1','0','0','0','','length','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','49','6','INTEGER','Common integer data type','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','50','6','FLOAT','Common float data type.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
('','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','51','6','DOUBLE','Common double data type.','0','0','0','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');