tf开普同步

--插入forminfo
--insert into jncjext.forminfo select * from cjkz.forminfo d where d.formname like '土肥_%'

--更新forminfo中的“业务单位、创建组织、创建人 8a82b75e2ad19940012ad19eb6b80010”
/*update jncjext.forminfo t set t.belongunit = 'cjtf', t.createorgid = '070D1A20-B10B-11DF-9A20-AE091BB7C56D',
      t.createmanid = '8a82b75e2ad19940012ad19eb6b80010' where t.formname like '农垦_%'
*/

--插入rowitems
/*
insert into jncjext.rowitems
select * from cjkz.rowitems t where t.forminfoid in(select d.forminfoid from cjkz.forminfo d
       where d.formname like '农垦_%')
*/

--更新rowitems中的“创建组织” 
/*
update jncjext.rowitems d set d.createorgid = '070D1A20-B10B-11DF-9A20-AE091BB7C56D'
       where d.forminfoid in (select c.forminfoid from forminfo c where c.formname like '农垦_%')
*/

--插入colitems
/*
insert into jncjext.colitems
select * from cjkz.colitems t where t.forminfoid in(select d.forminfoid from cjkz.forminfo d
       where d.formname like '农垦_%')
*/

--更新colitems中的“创建组织”
/* 
update jncjext.colitems d set d.createorgid = '070D1A20-B10B-11DF-9A20-AE091BB7C56D'
       where d.forminfoid in (select c.forminfoid from forminfo c where c.formname like '农垦_%')
*/

--插入formtemplate
/*
insert into jncjext.formtemplate
select * from cjkz.formtemplate t where t.forminfoid in(select d.forminfoid from cjkz.forminfo d
       where d.formname like '农垦_%')
*/

--更新formtemplate中的“创建组织、创建人”
/*
update jncjext.formtemplate t set t.createorgid = '070D1A20-B10B-11DF-9A20-AE091BB7C56D',
       t.createmanid = '8a82b7ba2ab1744d012ab1744d0f0000'
       where t.forminfoid in (select c.forminfoid from forminfo c where c.formname like '农垦_%')
*/

--插入指标分类
/*
insert into jncjext.c_categoryindex
  select *
    from cjkz.c_categoryindex c2
   where c2.categoryindexid not in
         (select c1.categoryindexid from jncjext.c_categoryindex c1)
*/

--插入指标
/*     
insert into jncjext.c_guideline
  select *
    from cjkz.c_guideline c2
   where c2.categoryindexid not in
         (select c1.categoryindexid from jncjext.c_guideline c1)
*/
 
 
--插入代码分类
/*
insert into jncjext.t_common_dmfl
  select *
    from cjkz.t_common_dmfl t1
   where t1.uuid not in (select t2.uuid from jncjext.t_common_dmfl t2)
*/

--插入代码表
/*
insert into jncjext.t_common_dm
  select *
    from cjkz.t_common_dm t1
   where t1.uuid not in (select t2.uuid from jncjext.t_common_dm t2)
*/

--插入计量单位
/*
insert into jncjext.MEASUREUNIT
  select *
    from cjkz.MEASUREUNIT t1
   where t1.measureunitid not in (select t2.measureunitid from jncjext.MEASUREUNIT t2)
*/