Mapeo Predeterminado de Tipos de Datos

El mapeo predeterminado de tipos de datos es una tabla hash construida internamente dentro de SynchDB con: * clave: {tipo de dato, auto_increment} * valor: {tipo de dato, tamaño}

donde: * tipo de dato: la representación en cadena de un tipo de dato como INT, TEXT, NUMERIC * auto_increment: una bandera que indica si el tipo de dato tiene atributo auto_increment * tamaño: el valor de tamaño traducido. -1: sin cambios, 0: sin tamaño especificado

Las entradas del mapeo predeterminado de tipos de datos pueden sobrescribirse definiendo reglas de transformación de tipos de datos con un archivo de reglas. Consulte archivo de reglas de transformación para más información.

MySQL Default Data Type Mapping

DatatypeHashEntry mysql_defaultTypeMappings[] =
{
    {{"INT", true}, "SERIAL", 0},
    {{"BIGINT", true}, "BIGSERIAL", 0},
    {{"SMALLINT", true}, "SMALLSERIAL", 0},
    {{"MEDIUMINT", true}, "SERIAL", 0},
    {{"ENUM", false}, "TEXT", 0},
    {{"SET", false}, "TEXT", 0},
    {{"BIGINT", false}, "BIGINT", 0},
    {{"BIGINT UNSIGNED", false}, "NUMERIC", -1},
    {{"NUMERIC UNSIGNED", false}, "NUMERIC", -1},
    {{"DEC", false}, "DECIMAL", -1},
    {{"DEC UNSIGNED", false}, "DECIMAL", -1},
    {{"DECIMAL UNSIGNED", false}, "DECIMAL", -1},
    {{"FIXED", false}, "DECIMAL", -1},
    {{"FIXED UNSIGNED", false}, "DECIMAL", -1},
    {{"BIT(1)", false}, "BOOLEAN", 0},
    {{"BIT", false}, "BIT", -1},
    {{"BOOL", false}, "BOOLEAN", -1},
    {{"DOUBLE", false}, "DOUBLE PRECISION", 0},
    {{"DOUBLE PRECISION", false}, "DOUBLE PRECISION", 0},
    {{"DOUBLE PRECISION UNSIGNED", false}, "DOUBLE PRECISION", 0},
    {{"DOUBLE UNSIGNED", false}, "DOUBLE PRECISION", 0},
    {{"REAL", false}, "REAL", 0},
    {{"REAL UNSIGNED", false}, "REAL", 0},
    {{"FLOAT", false}, "REAL", 0},
    {{"FLOAT UNSIGNED", false}, "REAL", 0},
    {{"INT", false}, "INT", 0},
    {{"INT UNSIGNED", false}, "BIGINT", 0},
    {{"INTEGER", false}, "INT", 0},
    {{"INTEGER UNSIGNED", false}, "BIGINT", 0},
    {{"MEDIUMINT", false}, "INT", 0},
    {{"MEDIUMINT UNSIGNED", false}, "INT", 0},
    {{"YEAR", false}, "INT", 0},
    {{"SMALLINT", false}, "SMALLINT", 0},
    {{"SMALLINT UNSIGNED", false}, "INT", 0},
    {{"TINYINT", false}, "SMALLINT", 0},
    {{"TINYINT UNSIGNED", false}, "SMALLINT", 0},
    {{"DATETIME", false}, "TIMESTAMP", -1},
    {{"TIMESTAMP", false}, "TIMESTAMPTZ", -1},
    {{"BINARY", false}, "BYTEA", 0},
    {{"VARBINARY", false}, "BYTEA", 0},
    {{"BLOB", false}, "BYTEA", 0},
    {{"MEDIUMBLOB", false}, "BYTEA", 0},
    {{"LONGBLOB", false}, "BYTEA", 0},
    {{"TINYBLOB", false}, "BYTEA", 0},
    {{"LONG VARCHAR", false}, "TEXT", -1},
    {{"LONGTEXT", false}, "TEXT", -1},
    {{"MEDIUMTEXT", false}, "TEXT", -1},
    {{"TINYTEXT", false}, "TEXT", -1},
    {{"JSON", false}, "JSONB", -1},

    /* spatial types - map to TEXT by default */
    {{"GEOMETRY", false}, "TEXT", -1},
    {{"GEOMETRYCOLLECTION", false}, "TEXT", -1},
    {{"GEOMCOLLECTION", false}, "TEXT", -1},
    {{"LINESTRING", false}, "TEXT", -1},
    {{"MULTILINESTRING", false}, "TEXT", -1},
    {{"MULTIPOINT", false}, "TEXT", -1},
    {{"MULTIPOLYGON", false}, "TEXT", -1},
    {{"POINT", false}, "TEXT", -1},
    {{"POLYGON", false}, "TEXT", -1}
};

SQL Server Default Data Type Mapping

DatatypeHashEntry sqlserver_defaultTypeMappings[] =
{
    {{"int identity", true}, "SERIAL", 0},
    {{"bigint identity", true}, "BIGSERIAL", 0},
    {{"smallint identity", true}, "SMALLSERIAL", 0},
    {{"enum", false}, "TEXT", 0},
    {{"int", false}, "INT", 0},
    {{"bigint", false}, "BIGINT", 0},
    {{"smallint", false}, "SMALLINT", 0},
    {{"tinyint", false}, "SMALLINT", 0},
    {{"numeric", false}, "NUMERIC", 0},
    {{"decimal", false}, "NUMERIC", 0},
    {{"bit(1)", false}, "BOOL", 0},
    {{"bit", false}, "BIT", 0},
    {{"money", false}, "MONEY", 0},
    {{"smallmoney", false}, "MONEY", 0},
    {{"real", false}, "REAL", 0},
    {{"float", false}, "REAL", 0},
    {{"date", false}, "DATE", 0},
    {{"time", false}, "TIME", 0},
    {{"datetime", false}, "TIMESTAMP", 0},
    {{"datetime2", false}, "TIMESTAMP", 0},
    {{"datetimeoffset", false}, "TIMESTAMPTZ", 0},
    {{"smalldatetime", false}, "TIMESTAMP", 0},
    {{"char", false}, "CHAR", 0},
    {{"varchar", false}, "VARCHAR", -1},
    {{"text", false}, "TEXT", 0},
    {{"nchar", false}, "CHAR", 0},
    {{"nvarchar", false}, "VARCHAR", -1},
    {{"ntext", false}, "TEXT", 0},
    {{"binary", false}, "BYTEA", 0},
    {{"varbinary", false}, "BYTEA", 0},
    {{"image", false}, "BYTEA", 0},
    {{"uniqueidentifier", false}, "UUID", 0},
    {{"xml", false}, "TEXT", 0},
    /* spatial types - map to TEXT by default */
    {{"geometry", false}, "TEXT", 0},
    {{"geography", false}, "TEXT", 0},
};