-- Body weight percent in exercise

ALTER TABLE exercise ADD bdypcnt INTEGER NOT NULL default 0;

-- Total weight = weight x 2

ALTER TABLE exercise ADD wgtx2 INTEGER NOT NULL default 0;
UPDATE exercise SET wgtx2 = 1 WHERE id IN (125,341,128,48,197,53,80,248,199,50,52,74,14,76,104,274,318,131,155,149,83,98,105,319,307,375,261,262,99,156);

-- alter built-in "assisted weight" and "bodyweight" exercises

UPDATE exercise SET logvals = 2054 WHERE id IN (290, 143, 357);
UPDATE exercise SET bdypcnt = 100 WHERE id IN (290, 143, 357);

UPDATE exercise SET logvals = 4102 WHERE id IN (301, 142, 158, 56, 283, 285, 196, 284, 160, 348, 189, 208, 207, 166, 163, 206, 327, 163, 350, 298, 299, 162, 58, 354, 349, 170, 204, 176, 351, 194, 164, 141, 235, 302, 203, 304, 347, 219);

UPDATE exercise SET bdypcnt = 25 WHERE id IN (160, 208, 166, 176, 235);
UPDATE exercise SET bdypcnt = 30 WHERE id IN (206, 298, 351, 302, 347);
UPDATE exercise SET bdypcnt = 35 WHERE id IN (299, 162);
UPDATE exercise SET bdypcnt = 40 WHERE id IN (163, 327, 163, 349);
UPDATE exercise SET bdypcnt = 50 WHERE id IN (301, 348, 350, 170, 204, 194, 203);
UPDATE exercise SET bdypcnt = 60 WHERE id IN (189, 207, 354, 164, 304);
UPDATE exercise SET bdypcnt = 70 WHERE id IN (158, 58);
UPDATE exercise SET bdypcnt = 80 WHERE id IN (142);
UPDATE exercise SET bdypcnt = 85 WHERE id IN (219);
UPDATE exercise SET bdypcnt = 100 WHERE id IN (56, 283, 285, 196, 284, 141);

-- Set note

ALTER TABLE edt_wset ADD note TEXT NOT NULL DEFAULT "";
ALTER TABLE wset ADD note TEXT NOT NULL DEFAULT "";
ALTER TABLE exlogset ADD note TEXT NOT NULL DEFAULT "";
