IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMBD_JOBTYPE' AND KSQL_COL_NAME = 'FDESCRIPTION' )
ALTER TABLE T_PMBD_JOBTYPE ADD ( FDESCRIPTION NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMBD_PJSTAGE' AND KSQL_COL_NAME = 'FDESCRIPTION' )
ALTER TABLE T_PMBD_PJSTAGE ADD ( FDESCRIPTION NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMBD_PROJECTWBSTYPE' AND KSQL_COL_NAME = 'FDESCRIPTION' )
ALTER TABLE T_PMBD_PROJECTWBSTYPE ADD ( FDESCRIPTION NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_ASSPJMGINFO' AND KSQL_COL_NAME = 'FNAME' )
ALTER TABLE T_PMPD_ASSPJMGINFO ADD ( FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMTS_WBS' AND KSQL_COL_NAME = 'FFULLNAME' )
ALTER TABLE T_PMTS_WBS ADD ( FFULLNAME NVARCHAR(500) DEFAULT ' ' NOT NULL );
IF NOT EXISTS ( SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMTS_PLAN_MODEL' AND KSQL_COL_NAME = 'FNAME' )
ALTER TABLE T_PMTS_PLAN_MODEL ADD ( FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );