-- Saving gps and device UID in the workout log

ALTER TABLE wklog ADD gps BLOB NOT NULL default '';
ALTER TABLE wklog ADD duid INTEGER NOT NULL default 0;
UPDATE wklog SET gps = '', duid = 0;
UPDATE wklog SET duid = 1 WHERE length(hr) > 0 AND substr(hr,1,1) = '.';
