PostgreSQL to MySQL mapping

AutoSync maps PostgreSQL object types to the following MySQL column types:


PostgreSQL object type	MySQL column type
`serial`	`SMALLINT`
`bigserial`	`INT`
`int2`	`SMALLINT`
`int4`	`INT`
`int8`	`BIGINT`
`numeric`	`DECIMAL`
`numeric_without_prec_scale`	`VARCHAR`
`float4`	`FLOAT`
`float8`	`DOUBLE`
`money`	`DOUBLE`
`bytea`	`BLOB`
`varchar`	`VARCHAR`
`bpchar`	`VARCHAR`
`text`	`VARCHAR`
`cidr`	`VARCHAR`
`inet`	`VARCHAR`
`macaddr`	`VARCHAR`
`macaddr8`	`VARCHAR`
`bit`	`VARCHAR`
`uuid`	`VARCHAR`
`xml`	`VARCHAR`
`json`	`JSON`
`jsonb`	`JSON`
`tsvector`	`VARCHAR`
`tsquery`	`VARCHAR`
`timestamp`	`DATETIME`
`timestamptz`	`DATETIME`
`date`	`DATE`
`time`	`TIME`
`timetz`	`TIME`
`interval`	`VARCHAR`
`point`	`VARCHAR`
`line`	`VARCHAR`
`lseg`	`VARCHAR`
`box`	`VARCHAR`
`path`	`VARCHAR`
`polygon`	`VARCHAR`
`circle`	`VARCHAR`
`geometry`	`JSON`
`array`	`VARCHAR`
`composite`	`VARCHAR`
`range`	`VARCHAR`
`oid`	`INT UNSIGNED`
`pg_lsn`	`VARCHAR`
`bool`	`BIT`
`char`	`CHAR`
`name`	`VARCHAR`
`sl_timestamp`	`DATETIME`