-- Add caltype field

ALTER TABLE exlog ADD caltype INTEGER NOT NULL default 0;
ALTER TABLE exlogset ADD caltype INTEGER NOT NULL default 0;
ALTER TABLE wmove ADD caltype INTEGER NOT NULL default 0;
ALTER TABLE wset ADD caltype INTEGER NOT NULL default 0;
ALTER TABLE edt_wmove ADD caltype INTEGER NOT NULL default 0;
ALTER TABLE edt_wset ADD caltype INTEGER NOT NULL default 0;

UPDATE exlog SET caltype = 0 WHERE ttlcal=0;
UPDATE exlog SET caltype = 1 WHERE ttlcal<>0;

UPDATE exlogset SET caltype = 0 WHERE cal=0;
UPDATE exlogset SET caltype = 1 WHERE cal<>0;

UPDATE wmove SET caltype = 0 WHERE ttlcal=0;
UPDATE wmove SET caltype = 1 WHERE ttlcal<>0;

UPDATE wset SET caltype = 0 WHERE cal=0;
UPDATE wset SET caltype = 1 WHERE cal<>0;

UPDATE edt_wmove SET caltype = 0 WHERE ttlcal=0;
UPDATE edt_wmove SET caltype = 1 WHERE ttlcal<>0;

UPDATE edt_wset SET caltype = 0 WHERE cal=0;
UPDATE edt_wset SET caltype = 1 WHERE cal<>0;
