
--跨行业协调单增加油漆部件
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FSPARYMATERIAL')
ALTER TABLE T_POM_COORDINATION ADD (FSPARYMATERIAL BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FPAINTMATERIAL')
ALTER TABLE T_POM_COORDINATION ADD (FPAINTMATERIAL BIGINT DEFAULT 0 NOT NULL);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FANNAUNCEMENT')
ALTER TABLE T_POM_COORDINATION ADD (FANNAUNCEMENT NVARCHAR(255) NOT NULL DEFAULT ' ');

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FANNAUNCEMENT_TAG')
ALTER TABLE T_POM_COORDINATION ADD (FANNAUNCEMENT_TAG NCLOB);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FPAINTGRN')
ALTER TABLE T_POM_COORDINATION ADD (FPAINTGRN VARCHAR(50) NOT NULL DEFAULT ' ');

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_COORDINATION' AND KSQL_COL_NAME ='FISSPARYMATERAIL')
ALTER TABLE T_POM_COORDINATION ADD (FISSPARYMATERAIL CHAR(1) NOT NULL DEFAULT '0');


