/**Begin D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FACCOUNTCLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FACCOUNTCLASSTYPE VARCHAR(50) DEFAULT 'bcm_accountmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FMULTIGAAPCLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FMULTIGAAPCLASSTYPE VARCHAR(50) DEFAULT 'bcm_rulemembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM1CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM1CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM2CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM2CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM3CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM3CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM4CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM4CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM5CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM5CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDIM6CLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDIM6CLASSTYPE VARCHAR(50) DEFAULT 'bcm_userdefinedmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FDATASORTCLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FDATASORTCLASSTYPE VARCHAR(50) DEFAULT 'bcm_datasortmembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FCHANGETYPECLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FCHANGETYPECLASSTYPE VARCHAR(50) DEFAULT 'bcm_changetypemembertree' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INTRADJSETENTRY' AND KSQL_COL_NAME ='FAUDITTRAILCLASSTYPE') 
 ALTER TABLE T_BCM_INTRADJSETENTRY ADD (FAUDITTRAILCLASSTYPE VARCHAR(50) DEFAULT 'bcm_audittrialmembertree' NOT NULL );

/**End D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_table.sql **/
