/*==============================================================*/
/* 勾稽关系报告增加字段                               */
/*==============================================================*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_EXAMINE_REPORT' AND KSQL_COL_NAME IN ('FENTITYID')) 
 ALTER TABLE T_EB_EXAMINE_REPORT ADD (FENTITYID BIGINT  NOT NULL DEFAULT 0 );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_EXAMINE_REPORT' AND KSQL_COL_NAME IN ('FVERSIONID')) 
 ALTER TABLE T_EB_EXAMINE_REPORT ADD (FVERSIONID BIGINT  NOT NULL DEFAULT 0 );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_EXAMINE_REPORT' AND KSQL_COL_NAME IN ('FDATATYPEID')) 
 ALTER TABLE T_EB_EXAMINE_REPORT ADD (FDATATYPEID BIGINT  NOT NULL DEFAULT 0 );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_EXAMINE_REPORT' AND KSQL_COL_NAME IN ('FPERIODID')) 
 ALTER TABLE T_EB_EXAMINE_REPORT ADD (FPERIODID BIGINT  NOT NULL DEFAULT 0 );

 