ALTER TRIGGER SILINEN_EKLE INACTIVE;
Delete from stok;
Delete from sbaslik;
delete from sfatdetay;
delete from hizli;
delete from alfatbaslik;
delete from alfatdetay;
delete from brkd;
delete from carikart;
delete from cari where cid>6;
delete from gider;
delete from prntr;
delete from rafbarkodu;
delete from STSYMTBL;
delete from STKMVCT;
delete from STKOKUNAN;
delete from STKSONUC;
delete from STOKDRM;
delete from STSYMTBL;
delete from URMRG;
delete from satis_silinen;
Delete from ufiydeg;
Delete from islem_log;
UPDATE URUNLER SET uakpas='P',ustkgtar=current_date, usonsatfiy=0;
Delete from firma
Delete from urunler where ubarkod like '10%';
Delete from urunler where ubarkod is null;
Delete from urunler where uad is null;
Delete from urunler where char_length(ubarkod)<8;
ALTER SEQUENCE GEN_ALFATBASLIK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_ALFATDETAY_ID RESTART WITH 1;
ALTER SEQUENCE GEN_ALFEXCEL_ID RESTART WITH 1;
ALTER SEQUENCE GEN_BANKAHESAP_ID RESTART WITH 1;
ALTER SEQUENCE GEN_BRKD_ID RESTART WITH 14600000;
ALTER SEQUENCE GEN_CARIGRUP_ID RESTART WITH 1;
ALTER SEQUENCE GEN_CARIKART_ID RESTART WITH 1;
ALTER SEQUENCE GEN_CARI_ID RESTART WITH 6;
ALTER SEQUENCE GEN_GIDER_ID RESTART WITH 1;
ALTER SEQUENCE GEN_HIZLI_ID RESTART WITH 1;
ALTER SEQUENCE GEN_PRNTR_ID RESTART WITH 1;
ALTER SEQUENCE GEN_RAFBARKODU_ID RESTART WITH 1;
ALTER SEQUENCE GEN_SBASLIK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_SFATDETAY_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKMVCT_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKOKUNAN_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKSONUC_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STOKDRM_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STOK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STSYMTBL_ID RESTART WITH 1 ;
ALTER SEQUENCE GEN_YARDIM_ID RESTART WITH 1 ;
ALTER SEQUENCE GEN_ISLEM_LOG_ID RESTART WITH 1 ;
ALTER SEQUENCE GEN_SATIS_SILINEN_ID RESTART WITH 1 ;

update FIRMABILGI
set FIRMAADI = '',
    FIRMAYETKILI = '',
    FIRMATEL = '',
    FIRMAADRES = '',
    FIRMAIL = 'ISTANBUL',
    FIRMAILCE = '',
    FIRMAYETTEL = '',
    FIRMAKEY = '',
    FIRMAAKTIVASYON = '',
    TARIH = current_date,
    SAAT = current_time,
    ISLETMETURU = 'MAGAZA',
    DEPOIP = '',
    YIL = 0,
    SUNUCUID = 0,
    BULUT = 0,
    VERSIYON = 0,
    SONYEDEKTARIHI = current_date,
    SILSIFRE = 11,
    RAPORSIFRE = 11,
    BOLGE = '';
ALTER TRIGGER SILINEN_EKLE ACTIVE;