同步脚本

 

 

IF NOT EXISTS  (select * from KSQL_USERCOLUMNS where KSQL_COL_TABNAME='T_GL_HGDataBaseBuilder') 
Create Table T_GL_HGDataBaseBuilder ( FHGDataBaseCreator NVARCHAR(255),FasstHGAttribute NVARCHAR(255));

If not exists (select * from KSQL_USERCOLUMNS where KSQL_COL_NAME ='FTYPE' and KSQL_COL_TABNAME='T_GL_HGDataBaseBuilder')
alter table T_GL_HGDataBaseBuilder add FTYPE NVARCHAR(255);

If exists (select * from KSQL_USERCOLUMNS where KSQL_COL_NAME ='FTYPE' and KSQL_COL_TABNAME='T_GL_HGDataBaseBuilder')
update T_GL_HGDataBaseBuilder set FTYPE='voucherImportBulider' where FTYPE is null;

 

 

if not exists (select * from T_BAS_ParamValueRange where  fid in ('8F5R26irSXCSLRv/XbIjhxsoUZM='))
insert into t_bas_paramvaluerange(FID, FexclusValue_L1, FexclusValue_L2, FexclusValue_L3, FvalueEnum_L1, 
FvalueEnum_L2, FvalueEnum_L3, FmaxValue, FminValue, FvalueEnum, FexclusValue)
 values 
(N'8F5R26irSXCSLRv/XbIjhxsoUZM=', null, null, null, null, null, null, null, null, null, null);