--exercise uid and price
ALTER TABLE exercise ADD uid INTEGER NOT NULL DEFAULT 0;
ALTER TABLE exercise ADD price INTEGER NOT NULL DEFAULT 0;

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

--list exercises available only in paid-for GymGoal versions
UPDATE exercise SET price = 1 WHERE id IN (1,13,22,45,46,47,51,54,55,56,57,59,60,63,64,67,68,71,73,75,77,78,79,81,82,84,85,96,97,101,102,103,106,107,108,109,111,113,114,115,122,123,124,130,134,135,136,137,141,143,145,148,150,151,152,153,154,158,159,160,162,163,167,170,176,186,187,188,192,194,195,198,200,203,204,207,208,212,215,219,222,223,225,228,230,235,236,238,240,242,243,244,245,246,249,250,251,252,253,254,255,256,257,264,265,266,267,268,269,270,271,273,275,276,277,278,279,280,281,282,286,287,289,290,292,293,294,296,300,301,302,305,306,308,309,310,311,314,315,316,317,320,321,322,323,324,326,328,330,331,332,333,334,336,337,338,339,340,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,364,365,366,367,368,369,370,371,372,373,374);

--add price to workouts
ALTER TABLE workout ADD price INTEGER NOT NULL DEFAULT 0;
ALTER TABLE edt_workout ADD price INTEGER NOT NULL DEFAULT 0;

--list routines available only in paid-for GymGoal versions
UPDATE workout SET price = 1 WHERE id IN (1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,9919,9920,9921,9922,9923,9924,9925,9926,9927,9928,9929,9930,9931,9932,9933,9934,9935,9936,9937,9938,9939);