IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_SET' AND KSQL_COL_NAME ='FNODEID')
ALTER TABLE T_BAS_MUL_SCHEME_SET ADD (FNODEID INT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_SET' AND KSQL_COL_NAME ='FPNODEID')
ALTER TABLE T_BAS_MUL_SCHEME_SET ADD (FPNODEID INT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_SET' AND KSQL_COL_NAME ='FNODETYPE')
ALTER TABLE T_BAS_MUL_SCHEME_SET ADD (FNODETYPE INT DEFAULT 0 NOT NULL );

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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_MAP' AND KSQL_COL_NAME ='FBASEDATATYPE')
ALTER TABLE T_BAS_MUL_SCHEME_MAP ADD (FBASEDATATYPE INT DEFAULT 0 NOT NULL );

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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_MAP' AND KSQL_COL_NAME ='FFIELDTYPE')
ALTER TABLE T_BAS_MUL_SCHEME_MAP ADD (FFIELDTYPE INT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_MUL_SCHEME_MAP' AND KSQL_COL_NAME ='FPROPSEQ')
ALTER TABLE T_BAS_MUL_SCHEME_MAP ADD (FPROPSEQ INT DEFAULT 0 NOT NULL );