-- Add hrtype field

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

UPDATE exlog SET hrtype = -1 WHERE hrmax<>0;
UPDATE exlog SET hrtype = 1 WHERE hrmax==0;

UPDATE exlogset SET hrtype = -1 WHERE hrmax<>0;
UPDATE exlogset SET hrtype = 1 WHERE hrmax==0;

UPDATE wmove SET hrtype = -1 WHERE hrmax<>0;
UPDATE wmove SET hrtype = 1 WHERE hrmax==0;

UPDATE wset SET hrtype = -1 WHERE hrmax<>0;
UPDATE wset SET hrtype = 1 WHERE hrmax==0;

UPDATE edt_wmove SET hrtype = -1 WHERE hrmax<>0;
UPDATE edt_wmove SET hrtype = 1 WHERE hrmax==0;

UPDATE edt_wset SET hrtype = -1 WHERE hrmax<>0;
UPDATE edt_wset SET hrtype = 1 WHERE hrmax==0;
