/*
        Copyright 2003-2005, MH Software, Inc. All Rights Reserved.

        This script and the database design that it represents
        are the intellectual property of MH Software, Inc., and
        use of the script and database design must be in accordance
        with the terms and conditions under which you license
        connectDaily Software.
*/
#define MAX_INTEGER 2147483647

#define COL_NULL NULL

#ifdef DERBY
#define IDENTITY_FUNC(x) GENERATED BY DEFAULT AS IDENTITY
#define DATETIME_TYPE timestamp
#define DATEDEFAULT_FUNC CURRENT_TIMESTAMP
#define TEXT CLOB
#define FLOAT_TYPE DOUBLE
#define COMMAND_TERM ;
#undef COL_NULL
#define COL_NULL
#define BLOCK_TERM
#ifndef SKIP_CONNECT
connect 'jdbc:derby:calendardb;create=true'
#endif
COMMAND_TERM
#define AUTO_FK_INDEXES
#define NO_DROPS
#endif

#ifdef PGSQL
#define BLOB_TYPE bytea
#define USES_SEQUENCES
#define IDENTITY_FUNC(x) DEFAULT NEXTVAL('x')
#define COMMAND_TERM ;
#define BLOCK_TERM
#define DATETIME_TYPE timestamp
#define DATEDEFAULT_FUNC now()
#endif


#ifdef MYSQL
#define IDENTITY_FUNC(x) AUTO_INCREMENT
#define BLOB_TYPE LONGBLOB
#define FLOAT_TYPE DOUBLE
#define BOOLEAN_TYPE bit(1)
#define BOOLEAN_TRUE  1
#define BOOLEAN_FALSE 0
#define DATETIME_TYPE datetime
#define DATEDEFAULT_FUNC CURRENT_TIMESTAMP()
#define COMMAND_TERM ;
#define BLOCK_TERM
#endif

#ifdef MSSQL
#define SQLSERVER
#define IDENTITY_FUNC(x) IDENTITY
#define COMMAND_TERM
#define BLOCK_TERM go
#define DATETIME_TYPE datetime2(7)
#define DATEDEFAULT_FUNC getdate()
#define BOOLEAN_TYPE bit
#define BOOLEAN_TRUE  1
#define BOOLEAN_FALSE 0
#define FLOAT_TYPE float
#define BLOB_TYPE varbinary(MAX)
SET ANSI_PADDING OFF

#endif

#if defined(ORACLE)

#define USES_SEQUENCES
#define IDENTITY_FUNC(x)
#define COMMAND_TERM ;
#define BLOCK_TERM
#define DATETIME_TYPE TIMESTAMP
#define DATEDEFAULT_FUNC SYSDATE
#define TEXT CLOB
#define BLOB_TYPE VARBINARY
#define INT_TYPE number(10)
#define INT2_TYPE number(5)
#define VARCHAR VARCHAR2
#define FLOAT_TYPE BINARY_DOUBLE
#define BOOLEAN_TYPE number(1)
#define BOOLEAN_TRUE  1
#define BOOLEAN_FALSE 0

#endif

#ifdef SYB_SQLA
#define COMMAND_TERM ;
#define BLOCK_TERM
#define FLOAT_TYPE float
#define IDENTITY_FUNC(x) IDENTITY
#define DATEDEFAULT_FUNC getdate()
#endif

#ifdef IBMDB2
#define COMMAND_TERM ;
#define BLOCK_TERM
/*
#define IDENTITY_FUNC(x) GENERATED BY DEFAULT AS IDENTITY
*/


#define IDENTITY_FUNC(x) GENERATED ALWAYS AS IDENTITY
#define TEXT LONG VARCHAR
#define DATETIME_TYPE timestamp
#define INT_TYPE integer
#define FLOAT_TYPE DOUBLE
#define BOOLEAN_TYPE SMALLINT
#define BOOLEAN_FALSE 0
#define BOOLEAN_TRUE 1
#ifdef ZOS
#define DATEDEFAULT_FUNC
#undef TEXT
#define TEXT VARCHAR(8192)
#else
#define DATEDEFAULT_FUNC CURRENT_TIMESTAMP
#define AUTO_FK_INDEXES
#endif

#undef COL_NULL
#define COL_NULL


#endif

#ifndef INT_TYPE
#define INT_TYPE int
#endif

#ifndef INT2_TYPE
#define INT2_TYPE smallint
#endif

#ifndef LONG_INT
#define LONG_INT bigint
#endif

#ifndef DATETIME_TYPE
#define DATETIME_TYPE DateTime
#endif

#ifndef BOOLEAN_TYPE
#define BOOLEAN_TYPE boolean
#define BOOLEAN_FALSE false
#define BOOLEAN_TRUE true
#endif

#ifndef FLOAT_TYPE
#define FLOAT_TYPE double precision
#endif

#ifndef BLOB_TYPE
#define BLOB_TYPE BLOB
#endif

#ifndef LOWER_FUNC
#define LOWER_FUNC lower
#endif

#define DBDEFS