NuoDB Migrator Mappings for DEFAULT Values

The NuoDB Migrator does DEFAULT value translations (where DEFAULT is part of the syntax for, e.g. CREATE TABLE table (column [DEFAULT default_expr], ...)).

MySQL DEFAULT Value Translations

Date translator

MySQL NuoDB
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), NOW(), LOCALTIME, LOCALTIME(), LOCALTIMESTAMP, LOCALTIMESTAMP() NOW

Bit field literal translator http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html

MySQL NuoDB
b'1' TRUE
b'0' FALSE

MSSQL DEFAULT Value Translations

Date translator

MSSQL NuoDB
GETDATE(), CURRENT_TIMESTAMP, NOW() NOW

Unicode constant translator http://msdn.microsoft.com/en-us/library/ms179899.aspx Paragraph Unicode strings

MSSQL NuoDB
N'(constant)' constant

PostgreSQL DEFAULT Value Translations

Date translator

PostgreSQL NuoDB
CURRENT_TIMESTAMP, NOW() NOW

Casted expressions as default value http://www.postgresql.org/docs/9.2/static/sql-expressions.html #4.29

PostgreSQL NuoDB
expression::type expression

Oracle DEFAULT Value Translations

Date translator

Oracle NuoDB
CURRENT_DATE, SYSDATE NOW

IBM DB2 DEFAULT Value Translations

Date translator

IBM DB2 NuoDB
CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP NOW