-- Change the meaning of caltype

UPDATE exlog SET caltype = -1 WHERE caltype = 1;
UPDATE exlog SET caltype = 1 WHERE caltype = 0;

UPDATE exlogset SET caltype = -1 WHERE caltype = 1;
UPDATE exlogset SET caltype = 1 WHERE caltype = 0;

UPDATE wmove SET caltype = -1 WHERE caltype = 1;
UPDATE wmove SET caltype = 1 WHERE caltype = 0;

UPDATE wset SET caltype = -1 WHERE caltype = 1;
UPDATE wset SET caltype = 1 WHERE caltype = 0;

UPDATE edt_wmove SET caltype = -1 WHERE caltype = 1;
UPDATE edt_wmove SET caltype = 1 WHERE caltype = 0;

UPDATE edt_wset SET caltype = -1 WHERE caltype = 1;
UPDATE edt_wset SET caltype = 1 WHERE caltype = 0;

ALTER TABLE wklog ADD metcode INTEGER NOT NULL default 0;
ALTER TABLE wday ADD metcode INTEGER NOT NULL default 0;
ALTER TABLE edt_wday ADD metcode INTEGER NOT NULL default 0;

ALTER TABLE wklog ADD ttlcal FLOAT NOT NULL default 0;
