db.props

来自「torque服务器源代码」· PROPS 代码 · 共 49 行

# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to SapDB mappings.

BIT = FIXED(1,0)
TINYINT = CHAR BYTE
SMALLINT = SMALLINT
INTEGER = INTEGER
BIGINT = FIXED(38,0)
FLOAT = FLOAT
REAL = REAL
DOUBLE = DOUBLE PRECISION
NUMERIC = DECIMAL
DECIMAL = DECIMAL
CHAR = CHAR
VARCHAR = VARCHAR
LONGVARCHAR = LONG VARCHAR
DATE = DATE
TIME = TIME
TIMESTAMP = TIMESTAMP
BINARY = CHAR(254) BYTE
VARBINARY = LONG BYTE
LONGVARBINARY = LONG BYTE
NULL = NULL
OTHER =
JAVA_OBJECT = LONG BYTE
DISTINCT = DISTINCT
STRUCT =
ARRAY =
BLOB = LONG BYTE
CLOB = LONG UNICODE
REF =
BOOLEAN = BOOLEAN
BOOLEANINT = SMALLINT
BOOLEANCHAR = CHAR


AUTOINCREMENT = DEFAULT SERIAL
NOTNULL = NOT NULL

primaryKeyInsideTableDirective = true
foreignKeyInsideTableDirective = true
indexInsideTableDirective = false

removeNotNullWithAutoIncrement = false

suppressDefaults = false

idMethod=sequence