/**Begin D:\PDM_UPGRADE\PDM\补充多语言文本字段\CFM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_BONDISSUE' AND KSQL_COL_NAME IN ('FNAME'))
 ALTER TABLE T_TM_BONDISSUE ADD (FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_APPHOME_SETTING' AND KSQL_COL_NAME IN ('FPROJECTNAME'))
 ALTER TABLE T_TM_APPHOME_SETTING ADD (FPROJECTNAME NVARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_REQLIMIT' AND KSQL_COL_NAME IN ('FDESC'))
 ALTER TABLE T_TM_REQLIMIT ADD (FDESC NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_BIZRECORD' AND KSQL_COL_NAME IN ('FDESC'))
 ALTER TABLE T_TM_BIZRECORD ADD (FDESC NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_TRADE' AND KSQL_COL_NAME IN ('FDESC'))
 ALTER TABLE T_TM_TRADE ADD (FDESC NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_TRADE' AND KSQL_COL_NAME IN ('FNAME'))
 ALTER TABLE T_TM_TRADE ADD (FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_LOWRISK' AND KSQL_COL_NAME IN ('FNAME'))
 ALTER TABLE T_TM_LOWRISK ADD (FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TM_BUSINESSBILL' AND KSQL_COL_NAME IN ('FDESC'))
 ALTER TABLE T_TM_BUSINESSBILL ADD (FDESC NVARCHAR(255) DEFAULT ' ' NOT NULL );

/**End D:\PDM_UPGRADE\PDM\补充多语言文本字段\CFM_table.sql **/