ALTER TRIGGER raf_havuzu INACTIVE;

dELETE FROM rafbarkodu;

update urunler set usonalfiyat=usonsatfiy*0.6 where usonsatfiy>0  and usonalfiyat=0;

Update urunler set usonsatfiy=round(usonsatfiy*1.3),usonalfiyat=usonalfiyat*1.3 where usonsatfiy>0



insert into RAFBARKODU (RFURID, KUL)
select uid,'TOPTAN' from urunler where usonsatfiy> 0 ;

  merge into rafbarkodu r
  using urunler u
  on r.rfurid=u.uid
  when matched then
  update set
  r.umensei=u.umensei,
  r.rfbrkdno=u.ubarkod,
  r.rfsatfiy=u.usonsatfiy,
  r.rfbrkdurad=u.uad;

ALTER TRIGGER raf_havuzu ACTIVE;