-- 项目名称，项目编码
--IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HAOS_PROJTEAMBASE' AND KSQL_COL_NAME IN ('FPROJECTNAME'))
-- alter table T_HAOS_PROJTEAMBASE add FPROJECTNAME varchar(50) default 'PRO' not null;
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HAOS_PROJTEAMBASE' AND KSQL_COL_NAME IN ('FPROJECTNUMBER'))
 alter table T_HAOS_PROJTEAMBASE add FPROJECTNUMBER varchar(50) default ' ' not null;