IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_USERPOSITION' AND KSQL_COL_NAME ='FPOSITION')
ALTER TABLE T_YZJ_USERPOSITION ADD (FPOSITION NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_SYNCREPORT' AND KSQL_COL_NAME ='FSYNCOBJECT')
ALTER TABLE T_YZJ_SYNCREPORT ADD (FSYNCOBJECT NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_SYNCTASK' AND KSQL_COL_NAME ='FNAME')
ALTER TABLE T_YZJ_SYNCTASK ADD (FNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_SYNCTASK' AND KSQL_COL_NAME ='FDESCRIPTION')
ALTER TABLE T_YZJ_SYNCTASK ADD (FDESCRIPTION NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_ORGSTRUCTURE' AND KSQL_COL_NAME ='FFULLNAME')
ALTER TABLE T_YZJ_ORGSTRUCTURE ADD (FFULLNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_SYNCREPORTENTRY' AND KSQL_COL_NAME ='FDESCRIPTION')
ALTER TABLE T_YZJ_SYNCREPORTENTRY ADD (FDESCRIPTION NVARCHAR(1000) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_USER' AND KSQL_COL_NAME ='FTRUENAME')
ALTER TABLE T_YZJ_USER ADD (FTRUENAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_ORG' AND KSQL_COL_NAME ='FNAME')
ALTER TABLE T_YZJ_ORG ADD (FNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_YZJ_ORG' AND KSQL_COL_NAME ='FCOMMENT')
ALTER TABLE T_YZJ_ORG ADD (FCOMMENT NVARCHAR(255) DEFAULT ' ' NOT NULL );