IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP' AND KSQL_COL_NAME ='FFULLNAME') 
 ALTER TABLE T_FMM_DISPATCHWKTP ADD (FFULLNAME NVARCHAR(50)  DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP' AND KSQL_COL_NAME ='FLONGNUMBER') 
 ALTER TABLE T_FMM_DISPATCHWKTP ADD (FLONGNUMBER NVARCHAR(50)  DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP' AND KSQL_COL_NAME ='FLEVEL') 
 ALTER TABLE T_FMM_DISPATCHWKTP ADD (FLEVEL INT  DEFAULT 0   NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP' AND KSQL_COL_NAME ='FISLEAF') 
 ALTER TABLE T_FMM_DISPATCHWKTP ADD (FISLEAF  CHAR(1) DEFAULT '0' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP' AND KSQL_COL_NAME ='FPARENTID') 
 ALTER TABLE T_FMM_DISPATCHWKTP ADD (FPARENTID  BIGINT   DEFAULT 0   NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_DISPATCHWKTP_L' AND KSQL_COL_NAME ='FFULLNAME') 
 ALTER TABLE T_FMM_DISPATCHWKTP_L ADD (FFULLNAME   NVARCHAR(50)  DEFAULT ' ' NOT NULL );