--Myyntitapahtumien poisto # delete from tuotemyy # delete from rahaliik # delete from rlalv # delete from myyjamyy # delete from kerv # delete from kerp # delete from kerk # delete from apaine # delete from asker # delete from tosseuranta # --Ostotapahtumien poisto # delete from osto # delete from ostolajitelmat # delete from tillista # --Varastosaldojen poisto # delete from varsaldo # delete from lajvs # delete from invtulta # --Sarjanumeroiden poisto # delete from sarjanro # delete from snrohist # --Asiakastilitapahtumien poisto # delete from kassaldo # delete from assaldo # delete from salsuor # --Kanta-asiakastapahtumien poisto # delete from kantasaldo # --Bonustapahtumien poisto # delete from bonustapah # --Asiakashakutermien poisto # delete from ashakuterm # --Tuoteteksti-indeksien poisto # delete from tuoteti # --Laskutuksen poisto # delete from laskut # delete from lasrivi # delete from lassaa # delete from laskualv # delete from latilog # --Maksupaatetapahtumien (offline) poisto # delete from mptilera # delete from mplahera # delete from mptapah # --Kassan tietokantojen poisto(poytamyynnit jne) # delete from wpoyta # delete from poytarivi # delete from poytapaikka # delete from poytapaikkamaksut # delete from poytarivimaksettu # delete from tosite # delete from tositealv # delete from tositemt # delete from tositeum # update ksnro set tosite=0,maksutosite=0,gtotal=0 # --Myyntitilauksien poisto # delete from mtrivi # delete from mt # delete from mttoimri # delete from MTTOIMRISARJANRO # delete from mtkuormak # delete from mt2 # delete from mtkolli # delete from mttxt # --Ostotilauksien poisto # delete from winot # delete from winotri # delete from winottoi # delete from winottxt # delete from winotjako # delete from winotsaapuu # --Piccolink mt-kerailyjen poisto # delete from plmt # delete from plmtrivi # --Kirpputoritietojen poisto # delete from kirptil # update tryhma set tarraarkki=0 # delete from kktuote # delete from kirpmyy # update asiakas2 set viimkirppistarra=0 # --Kompensiotapahtumien poisto # delete from kompensio # --Ulosmaksujen poisto # delete from ulosmaks # --Aserekisterien poisto # delete from aluvat # delete from asemyy # delete from aseosto # delete from patmyy # --Keittiojonon poisto # delete from kpqueue1 # delete from kpqueue2 # delete from kpqueue3 # delete from kpqueue4 # delete from kpqueue5 # --Lokitietojen poisto # delete from skjlog # --Sokkotilityksien poisto # delete from sokkotilitys # delete from sokkotilitysrivit # --Asiakasmuutoksien poisto # delete from muutosdata # delete from muutoslog # delete from muutoslogtxt #