/**Begin D:\PDM\PDM_UPGRADE\pdm1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_DSMAINDATA' AND KSQL_COL_NAME ='FDEFINED1NUMBER') 
 ALTER TABLE T_BCM_DSMAINDATA ADD (FDEFINED1NUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_DSMAINDATA' AND KSQL_COL_NAME ='FDEFINED1NAME') 
 ALTER TABLE T_BCM_DSMAINDATA ADD (FDEFINED1NAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_DSMAINDATA' AND KSQL_COL_NAME ='FDEFINED1PARENT') 
 ALTER TABLE T_BCM_DSMAINDATA ADD (FDEFINED1PARENT VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_DSMAINDATA' AND KSQL_COL_NAME ='FDEFINED1NOSHARE') 
 ALTER TABLE T_BCM_DSMAINDATA ADD (FDEFINED1NOSHARE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_DSMAINDATA_L' AND KSQL_COL_NAME ='FDEFINED1NAME') 
 ALTER TABLE T_BCM_DSMAINDATA_L ADD (FDEFINED1NAME NVARCHAR(50) DEFAULT ' ' NOT NULL );

/**End D:\PDM\PDM_UPGRADE\pdm1\BCM_table.sql **/
