--workout uid
ALTER TABLE workout ADD uid INTEGER NOT NULL DEFAULT 0;
ALTER TABLE edt_workout ADD uid INTEGER NOT NULL DEFAULT 0;

--workout: uid = id for built-in workouts
--workout: uid = 0 (default) for custom workouts (assign uid programmatically)
UPDATE workout SET uid = id WHERE id > 0;

--workout day uid
ALTER TABLE wday ADD uid INTEGER NOT NULL DEFAULT 0;
--edt
ALTER TABLE edt_wday ADD uid INTEGER NOT NULL DEFAULT 0;

--workout day: uid is made of day num and workout id for built-in workouts
--workout day: uid = 0 (default) for custom workouts (assign uid programmatically)
UPDATE wday SET uid = ((num*100000)+wk) WHERE wk > 0;

--workout log should save the workout day uid
ALTER TABLE wklog ADD wduid INTEGER NOT NULL DEFAULT 0;
