/**Begin D:\PDM_UPGRADE\PDM1\FCS_table.sql **/
---超额控制添加多金额处理---
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_SUBAMT' AND KSQL_COL_NAME IN ('FISOTHERABS'))
 ALTER TABLE T_FCS_CHECKCTRL_SUBAMT ADD (FISOTHERABS CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_SUBAMT' AND KSQL_COL_NAME IN ('FISOTHERMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_SUBAMT ADD (FISOTHERMULAMT CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_SUBAMT' AND KSQL_COL_NAME IN ('FOTHERMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_SUBAMT ADD (FOTHERMULAMT NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_SUBAMT' AND KSQL_COL_NAME IN ('FOTHERMULAMT_TAG'))
 ALTER TABLE T_FCS_CHECKCTRL_SUBAMT ADD (FOTHERMULAMT_TAG NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_SUBAMT' AND KSQL_COL_NAME IN ('FOTHERMULAMTDESC'))
 ALTER TABLE T_FCS_CHECKCTRL_SUBAMT ADD (FOTHERMULAMTDESC NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FISSRCABS'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FISSRCABS CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FISSRCMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FISSRCMULAMT CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FSRCMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FSRCMULAMT NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FSRCMULAMT_TAG'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FSRCMULAMT_TAG NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FSRCMULAMTDESC'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FSRCMULAMTDESC NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FISTARGETABS'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FISTARGETABS CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FISTARGETMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FISTARGETMULAMT CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FTARGETMULAMT'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FTARGETMULAMT NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FTARGETMULAMT_TAG'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FTARGETMULAMT_TAG NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FCS_CHECKCTRL_AMTCTRL' AND KSQL_COL_NAME IN ('FTARGETMULAMTDESC'))
 ALTER TABLE T_FCS_CHECKCTRL_AMTCTRL ADD (FTARGETMULAMTDESC NVARCHAR(100) DEFAULT ' ' NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\FCS_table.sql **/
