--schday uid
ALTER TABLE schday ADD uid INTEGER NOT NULL DEFAULT 0;
ALTER TABLE wklog ADD sduid INTEGER NOT NULL DEFAULT 0;

--exercise: uid = id for built-in workouts
--exercise: uid = 0 (default) for custom workouts (assign uid programmatically)
UPDATE schday SET uid = num*1000+wdnum;

--date-time
UPDATE exgoal SET startdt = startdt+[ZONE_OFFSET] WHERE startdt<>0;
UPDATE exgoal SET shortdt = shortdt+[ZONE_OFFSET] WHERE shortdt<>0;
UPDATE exgoal SET longdt = longdt+[ZONE_OFFSET] WHERE longdt<>0;
--
UPDATE msrgoal SET startdt = startdt+[ZONE_OFFSET] WHERE startdt<>0;
UPDATE msrgoal SET shortdt = shortdt+[ZONE_OFFSET] WHERE shortdt<>0;
UPDATE msrgoal SET longdt = longdt+[ZONE_OFFSET] WHERE longdt<>0;
--
UPDATE exlog SET tmstart = tmstart+[ZONE_OFFSET] WHERE tmstart<>0;
UPDATE exlog SET tmend = tmend+[ZONE_OFFSET] WHERE tmend<>0;
--
UPDATE wmove SET tmstart = tmstart+[ZONE_OFFSET] WHERE tmstart<>0;
UPDATE wmove SET tmend = tmend+[ZONE_OFFSET] WHERE tmend<>0;
--
UPDATE msrpic SET dt = dt+[ZONE_OFFSET] WHERE dt<>0;
--
UPDATE OR IGNORE exlog SET dt = dt+[ZONE_OFFSET] WHERE dt<>0;
UPDATE OR IGNORE exlogset SET dt = dt+[ZONE_OFFSET] WHERE dt<>0;
UPDATE OR IGNORE wklog SET dt = dt+[ZONE_OFFSET] WHERE dt<>0;
UPDATE OR IGNORE msr SET dt = dt+[ZONE_OFFSET] WHERE dt<>0;
