# Custom mapping from Java AIDA types to SQL types (used when writing).
# It only modifies the default JDBC behaviour.
#
# $Id: Type.properties,v 1.17 2007/05/22 23:33:20 hrivnac Exp $

# MySQL
hep.aida.ref.sql.Type.mysql.Boolean        = bool
hep.aida.ref.sql.Type.mysql.Byte           = tinyint(1)
hep.aida.ref.sql.Type.mysql.Character      = char
hep.aida.ref.sql.Type.mysql.Short          = smallint(6)
hep.aida.ref.sql.Type.mysql.Integer        = int(11)
hep.aida.ref.sql.Type.mysql.Long           = bigint(20)
hep.aida.ref.sql.Type.mysql.Float          = float
hep.aida.ref.sql.Type.mysql.Double         = double
hep.aida.ref.sql.Type.mysql.String         = text

# PostgreSQL
hep.aida.ref.sql.Type.postgresql.Boolean   = bool
hep.aida.ref.sql.Type.postgresql.Byte      = int2
hep.aida.ref.sql.Type.postgresql.Character = text
hep.aida.ref.sql.Type.postgresql.Long      = int8
hep.aida.ref.sql.Type.postgresql.Integer   = int4
hep.aida.ref.sql.Type.postgresql.Double    = float8
hep.aida.ref.sql.Type.postgresql.String    = text

# Derby
hep.aida.ref.sql.Type.derby.Boolean        = SMALLINT
hep.aida.ref.sql.Type.derby.Byte           = SMALLINT
hep.aida.ref.sql.Type.derby.Character      = CHAR
hep.aida.ref.sql.Type.derby.Short          = SMALLINT
hep.aida.ref.sql.Type.derby.Integer        = INTEGER
hep.aida.ref.sql.Type.derby.Long           = BIGINT
hep.aida.ref.sql.Type.derby.Float          = FLOAT
hep.aida.ref.sql.Type.derby.Double         = DOUBLE
hep.aida.ref.sql.Type.derby.String         = VARCHAR(4000)

# SQLite
hep.aida.ref.sql.Type.sqlite.Boolean       = INTEGER
hep.aida.ref.sql.Type.sqlite.Byte          = INTEGER
hep.aida.ref.sql.Type.sqlite.Character     = TEXT
hep.aida.ref.sql.Type.sqlite.Short         = INTEGER
hep.aida.ref.sql.Type.sqlite.Integer       = INTEGER
hep.aida.ref.sql.Type.sqlite.Long          = INTEGER
hep.aida.ref.sql.Type.sqlite.Float         = REAL
hep.aida.ref.sql.Type.sqlite.Double        = REAL
hep.aida.ref.sql.Type.sqlite.String        = TEXT

# Oracle
hep.aida.ref.sql.Type.oracle.String        = VARCHAR(4000)
hep.aida.ref.sql.Type.oracle.Integer       = NUMBER(3)
hep.aida.ref.sql.Type.oracle.Long          = NUMBER(10)
hep.aida.ref.sql.Type.oracle.Double        = BINARY_DOUBLE
hep.aida.ref.sql.Type.oracle.Float         = BINARY_FLOAT


