/**Begin D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HAOS_ORGTEAM' AND KSQL_COL_NAME IN ('FPARENTID')) 
 ALTER TABLE T_HAOS_ORGTEAM ADD (FPARENTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HAOS_ORGTEAMSTRUCT' AND KSQL_COL_NAME IN ('FORGTEAMHISID')) 
 ALTER TABLE T_HAOS_ORGTEAMSTRUCT ADD (FORGTEAMHISID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HAOS_ORGTEAMSTRUCT' AND KSQL_COL_NAME IN ('FOTCLASSIFYID')) 
 ALTER TABLE T_HAOS_ORGTEAMSTRUCT ADD (FOTCLASSIFYID BIGINT DEFAULT 0 NOT NULL );


/**End D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
