appserver/persistence/cmp/generator-database/src/main/java/com/sun/jdo/spi/persistence/generator/database/SQL92.properties

#
# Copyright (c) 1997, 2018 Oracle and/or its affiliates. All rights reserved.
#
# This program and the accompanying materials are made available under the
# terms of the Eclipse Public License v. 2.0, which is available at
# http://www.eclipse.org/legal/epl-2.0.
#
# This Source Code may also be made available under the following Secondary
# Licenses when the conditions for such availability set forth in the
# Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
# version 2 with the GNU Classpath Exception, which is available at
# https://www.gnu.org/software/classpath/license.html.
#
# SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0
#


# Default table name
{class-name}.table-name={CLASSNAME}

# Default column name
{class-name}.{field-name}.column-name={FIELDNAME}

# Default elements of relationship policies
{class-name}.{relationship-field-name}.join-table-name={CLASSNAMES}
{class-name}.{relationship-field-name}.constraint-name={FIELDNAMES}

# maximum length for table name, column name and constraint name
table-name.maximum-length=30
column-name.maximum-length=30
constraint-name.maximum-length=30

#
# Mappings between jdbc and sql92.  Note that BLOB and CLOB are not part of
# the SQL92 spec, but we provide support since most databases allow them.
#
BIT=BIT
TINYINT=SMALLINT
CHAR=CHAR
DOUBLE=DOUBLE
REAL=REAL
INTEGER=INTEGER
BIGINT=DECIMAL
SMALLINT=SMALLINT
BLOB=BLOB
CLOB=CLOB
VARCHAR=VARCHAR
DECIMAL=DECIMAL
TIMESTAMP=TIMESTAMP
DATE=DATE
TIME=TIME

# Map user overrides which specify type names to appropriate JDBC types.  This
# allows databases to use different type names in creating columns and
# accessing those columns via JDBC.  By default, they map to themselves.
#
# While SQL92 does not, strictly speaking, support LOBs, most databases do, so
# we provide a level of support.
BLOB.jdbc-type=BLOB
CLOB.jdbc-type=CLOB

# By default, LOBs must not provide a length.
BLOB.jdbc-maximum-length=null
CLOB.jdbc-maximum-length=null

# By default, LOBs are nullable.
BLOB.jdbc-nullable=true
CLOB.jdbc-nullable=true

#
# Mappings between java type to jdbc type
#
boolean.jdbc-type = BIT
boolean.jdbc-nullable=false

byte.jdbc-type = TINYINT
byte.jdbc-nullable = false

char.jdbc-type = CHAR
char.jdbc-nullable = false
char.jdbc-precision = 1

double.jdbc-type = DOUBLE
double.jdbc-nullable = false

float.jdbc-type = REAL
float.jdbc-nullable = false

int.jdbc-type = INTEGER
int.jdbc-nullable = false

long.jdbc-type = BIGINT
long.jdbc-nullable = false

short.jdbc-type = SMALLINT
short.jdbc-nullable = false

java.lang.Double.jdbc-type = DOUBLE
java.lang.Double.jdbc-nullable = true

java.lang.Integer.jdbc-type = INTEGER
java.lang.Integer.jdbc-nullable = true

java.lang.Long.jdbc-type = BIGINT
java.lang.Long.jdbc-nullable = true

java.lang.Float.jdbc-type = REAL
java.lang.Float.jdbc-nullable = true

java.lang.Character.jdbc-type = CHAR
java.lang.Character.jdbc-nullable = true
java.lang.Character.jdbc-precision = 1

java.lang.Byte.jdbc-type = TINYINT
java.lang.Byte.jdbc-nullable = true

# Ideally, java.lang.Boolean should be mapped to jdbc type BOOLEAN.
# Mapping this type to BIT is a workaround since most of the drivers
# currently do not support setNull with BOOLEAN.
#
java.lang.Boolean.jdbc-type = BIT
java.lang.Boolean.jdbc-nullable = true

java.lang.Short.jdbc-type = SMALLINT
java.lang.Short.jdbc-nullable = true

java.lang.Object.jdbc-type = BLOB
java.lang.Object.jdbc-nullable = true

java.lang.Object[].jdbc-type = BLOB
java.lang.Object[].jdbc-nullable = true

java.lang.String.jdbc-type = VARCHAR
java.lang.String.jdbc-nullable = true
java.lang.String.jdbc-maximum-length = 256

java.lang.StringBuffer.jdbc-type = VARCHAR
java.lang.StringBuffer.jdbc-nullable = true
java.lang.StringBuffer.jdbc-maximum-length = 4000

java.math.BigDecimal.jdbc-type = DECIMAL
java.math.BigDecimal.jdbc-nullable = true
java.math.BigDecimal.jdbc-precision = 38

java.math.BigInteger.jdbc-type = DECIMAL
java.math.BigInteger.jdbc-nullable = true
java.math.BigInteger.jdbc-precision = 38

java.util.Date.jdbc-type = TIMESTAMP
java.util.Date.jdbc-nullable = true

java.sql.Date.jdbc-type = DATE
java.sql.Date.jdbc-nullable = true

java.sql.Time.jdbc-type = TIME
java.sql.Time.jdbc-nullable = true

java.sql.Timestamp.jdbc-type = TIMESTAMP
java.sql.Timestamp.jdbc-nullable = true

#
# Properties to indicate how to format SQL
#

statementSeparator.sql-format=;

# Create table template
# {0} - table name
createTableStart.sql-format=CREATE TABLE {0} (
createTableEnd.sql-format=)

# Create index
# {0} - table name
# {1} - column name (comma separated, if more than one column name)
createIndex.sql-format=

# Text used to indicate that a column is nullable
columnNullability.sql-format=NULL

# Alter table for constraint
# {0} - table name
# {1} - constraint name
alterTableAddConstraintStart.sql-format=ALTER TABLE {0} ADD
alterTableDropConstraint.sql-format=ALTER TABLE {0} DROP CONSTRAINT {1}

# Primary and Foreign key
# {0} - constraint name
# {1} - column name (comma separated, if more than one column name)
# {2} - reference table name
# {3} - reference column name (comma separated, if more than one column name)
primaryKeyConstraint.sql-format=CONSTRAINT {0} PRIMARY KEY ({1})
foreignKeyConstraint.sql-format=CONSTRAINT {0} FOREIGN KEY ({1}) REFERENCES {2} ({3})

# Drop table
# {0} - table name
dropTable.sql-format=DROP TABLE {0}

# Reserved words
reserved-words=ABSOLUTE, ACTION, ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, \
    ASC, ASSERTION, AT, AUTHORIZATION, AVG, BEGIN, BETWEEN, BIT, \
    BIT-LENGTH, BOTH, BY, CASCADE, CASCADED, CASE, CAST, CATALOG, \
    CHAR, CHAR-LENGTH, CHARACTER, CHARACTER-LENGTH, CHECK, CLOSE, \
    COALESCE, COLLATE, COLLATION, COLUMN, COMMIT, CONNECT, CONNECTION, \
    CONSTRAINT, CONSTRAINTS, CONTINUE, CONVERT, CORRESPONDING, COUNT, \
    CREATE, CROSS, CURRENT, CURRENT-DATE, CURRENT-TIME, CURRENT-TIMESTAMP, \
    CURRENT-USER, CURSOR, DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, \
    DEFAULT, DEFERRABLE, DEFERRED, DELETE, DESC, DESCRIBE, DESCRIPTOR, \
    DIAGNOSTICS, DISCONNECT, DISTINCT, DOMAIN, DOUBLE, DROP, ELSE, \
    END, END-EXEC, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS, \
    EXTERNAL, EXTRACT, FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, \
    FOUND, FROM, FULL, GET, GLOBAL, GO, GOTO, GRANT, GROUP, HAVING, \
    HOUR, IDENTITY, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INPUT, \
    INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, \
    IS, ISOLATION, JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LEVEL, \
    LIKE, LOCAL, LOWER, MATCH, MAX, MIN, MINUTE, MODULE, MONTH, \
    NAMES, NATIONAL, NATURAL, NCHAR, NEXT, NO, NOT, NULL, NULLIF, \
    NUMERIC, OCTET-LENGTH, OF, ON, ONLY, OPEN, OPTION, OR, ORDER, \
    OUTER, OUTPUT, OVERLAPS, PAD, PARTIAL, POSITION, PRECISION, PREPARE, \
    PRESERVE, PRIMARY, PRIOR, PRIVILEGES, PROCEDURE, PUBLIC, READ, \
    REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, ROLLBACK, \
    ROWS, SCHEMA, SCROLL, SECOND, SECTION, SELECT, SESSION, SESSION-USER, \
    SET, SIZE, SMALLINT, SOME, SPACE, SQL, SQLCODE, SQLERROR, SQLSTATE, \
    SUBSTRING, SUM, SYSTEM-USER, TABLE, TEMPORARY, THEN, TIME, TIMESTAMP, \
    TIMEZONE-HOUR, TIMEZONE-MINUTE, TO, TRAILING, TRANSACTION, TRANSLATE, \
    TRANSLATION, TRIM, TRUE, UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, \
    USAGE, USER, USING, VALUE, VALUES, VARCHAR, VARYING, VIEW, WHEN, \
    WHENEVER, WHERE, WITH, WORK, WRITE, YEAR, ZONE