database

var MySQLNumericDataTypes = []VarianDataType{
	{Type: "BIT", HasSize: true},
	{Type: "TINYINT", HasSize: true, HasAutoIncrement: true},
	{Type: "BOOL"},
	{Type: "BOOLEAN"},
	{Type: "SMALLINT", HasSize: true, HasAutoIncrement: true},
	{Type: "MEDIUMINT", HasSize: true, HasAutoIncrement: true},
	{Type: "INT", HasSize: true, HasAutoIncrement: true},
	{Type: "INTEGER", HasSize: true, HasAutoIncrement: true},
	{Type: "BIGINT", HasSize: true, HasAutoIncrement: true},
	{Type: "FLOAT", HasSize: true, HasDigit: true},
	{Type: "FLOAT_PRECISION", HasSize: true},
	{Type: "DOUBLE", HasSize: true, HasDigit: true},
	{Type: "DOUBLE PRECISION", HasSize: true, HasDigit: true},
	{Type: "DECIMAL", HasSize: true, HasDigit: true},
	{Type: "DEC", HasSize: true, HasDigit: true},
}

var MySQLStringDataTypes = []VarianDataType{
	{Type: "CHAR", HasSize: true},
	{Type: "VARCHAR", HasSize: true},
	{Type: "BINARY", HasSize: true},
	{Type: "VARBINARY", HasSize: true},

	{Type: "TINYBLOB"},
	{Type: "TINYTEXT"},

	{Type: "TEXT", HasSize: true},
	{Type: "BLOB", HasSize: true},

	{Type: "MEDIUMTEXT"},
	{Type: "MEDIUMBLOB"},

	{Type: "LONGTEXT"},
	{Type: "LONGBLOB"},

	{Type: "ENUM", HasValues: true},
	{Type: "SET", HasValues: true},
}

var PostgresNumericDataTypes = []VarianDataType{
	{Type: "SMALLINT", HasAutoIncrement: true},
	{Type: "INT2", HasAutoIncrement: true},
	{Type: "INTEGER", HasAutoIncrement: true},
	{Type: "INT", HasAutoIncrement: true},
	{Type: "INT4", HasAutoIncrement: true},
	{Type: "BIGINT", HasAutoIncrement: true},
	{Type: "INT8", HasAutoIncrement: true},
	{Type: "DECIMAL", HasDigit: true},
	{Type: "NUMERIC", HasDigit: true},
	{Type: "REAL"},
	{Type: "FLOAT4"},
	{Type: "DOUBLE PRECISION"},
	{Type: "FLOAT8"},
	{Type: "SMALLSERIAL", HasAutoIncrement: true},
	{Type: "SERIAL2", HasAutoIncrement: true},
	{Type: "SERIAL", HasAutoIncrement: true},
	{Type: "SERIAL4", HasAutoIncrement: true},
	{Type: "BIGSERIAL", HasAutoIncrement: true},
	{Type: "SERIAL8", HasAutoIncrement: true},
	{Type: "MONEY"},
}

var PostgresStringDataTypes = []VarianDataType{
	{Type: "CHAR", HasSize: true},
	{Type: "CHARACTER", HasSize: true},
	{Type: "VARCHAR", HasSize: true},
	{Type: "CHARACTER VARYING", HasSize: true},
	{Type: "TEXT"},
	{Type: "BPCHAR", HasSize: true},
	{Type: "BYTEA"},
	{Type: "UUID"},
	{Type: "JSON"},
	{Type: "JSONB"},
	{Type: "XML"},
	{Type: "CITEXT"},
}

var SqliteNumericDataTypes = []VarianDataType{
	{Type: "INT"},
	{Type: "INTEGER", HasAutoIncrement: true},
	{Type: "TINYINT"},
	{Type: "SMALLINT"},
	{Type: "MEDIUMINT"},
	{Type: "BIGINT"},
	{Type: "UNSIGNED BIG INT"},
	{Type: "INT2"},
	{Type: "INT8"},
	{Type: "REAL"},
	{Type: "DOUBLE"},
	{Type: "DOUBLE PRECISION"},
	{Type: "FLOAT"},
	{Type: "NUMERIC", HasSize: true, HasDigit: true},
	{Type: "DECIMAL", HasSize: true, HasDigit: true},
	{Type: "BOOLEAN"},
	{Type: "DATE"},
	{Type: "DATETIME"},
}

var SqliteStringDataTypes = []VarianDataType{
	{Type: "TEXT"},
	{Type: "CHARACTER", HasSize: true},
	{Type: "VARCHAR", HasSize: true},
	{Type: "VARYING CHARACTER", HasSize: true},
	{Type: "NCHAR", HasSize: true},
	{Type: "NATIVE CHARACTER", HasSize: true},
	{Type: "CLOB"},
	{Type: "BLOB"},
}