/**Begin E:\PDM\PDM1\BOS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_CURRENCYEXRULE' AND KSQL_COL_NAME ='FPRECISIONCONTROL')
ALTER TABLE T_INT_CURRENCYEXRULE ADD (FPRECISIONCONTROL CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_CURRENCYEXRULE' AND KSQL_COL_NAME ='FDEFAULTPRECISION')
ALTER TABLE T_INT_CURRENCYEXRULE ADD (FDEFAULTPRECISION VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_INT_PRECISION_ENTRY')
CREATE TABLE T_INT_PRECISION_ENTRY (
                                       FID BIGINT DEFAULT 0 NOT NULL,
                                       FENTRYID BIGINT DEFAULT 0 NOT NULL,
                                       FSEQ INT DEFAULT 0 NOT NULL,
                                       FCURRENCY1 BIGINT DEFAULT 0 NOT NULL,
                                       FCURRENCY2 BIGINT DEFAULT 0 NOT NULL,
                                       FPRECISION DECIMAL(23) DEFAULT 0 NOT NULL
);



/**End E:\PDM\PDM1\BOS_table.sql **/
