INSERT INTO muscle (id, name, nic, grp, expand, descr, ordno) 
SELECT 100, "Stretches", "", 0, 0, "", 0
UNION ALL SELECT 101, "Neck", "", 100, 1, "", 10
UNION ALL SELECT 102, "Shoulders and Chest", "", 100, 1, "", 20
UNION ALL SELECT 103, "Arms and Forearms", "", 100, 1, "", 30
UNION ALL SELECT 104, "Side bends", "", 100, 1, "", 40
UNION ALL SELECT 105, "Torso rotations", "", 100, 1, "", 50
UNION ALL SELECT 106, "Back relaxation", "", 100, 1, "", 60
UNION ALL SELECT 107, "Hips", "", 100, 1, "", 70
UNION ALL SELECT 108, "Buttocks", "", 100, 1, "", 80
UNION ALL SELECT 109, "Quadriceps", "", 100, 1, "", 90
UNION ALL SELECT 110, "Hamstrings", "", 100, 1, "", 100
UNION ALL SELECT 111, "Groin", "", 100, 1, "", 110
UNION ALL SELECT 112, "Calves", "", 100, 1, "", 120
UNION ALL SELECT 200, "Cardio", "", 0, 0, "", 0
UNION ALL SELECT 201, "Indoor", "", 200, 1, "", 10
UNION ALL SELECT 202, "Outdoor", "", 200, 1, "", 10
UNION ALL SELECT 203, "High-Impact", "", 200, 1, "", 10
UNION ALL SELECT 204, "Low-Impact", "", 200, 1, "", 10;

INSERT INTO exercise (id,name,type,tweight,tuse,tiso,diff,descr,media,uid,price,logsets,logvals,bdypcnt,wgtx2, conf,names) 
SELECT 1001, 'Ear to shoulder (lateral neck stretch)', 3, 1, 0, 0, 0, '', 0, 1001, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1002, 'Chin to shoulder (neck rotation stretch)', 3, 1, 0, 0, 0, '', 0, 1002, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1003, 'Chin to chest (neck flexion stretch)', 3, 1, 0, 0, 0, '', 0, 1003, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1004, 'Shoulder Squeeze Stretch', 3, 1, 0, 0, 1, '', 0, 1004, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1005, 'Side Shoulder Stretch', 3, 1, 0, 0, 0, '', 0, 1005, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1006, 'Side Shoulder Stretch with a support', 3, 1, 0, 0, 0, '', 0, 1006, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1007, 'Cow face pose (shoulder and triceps stretch)', 3, 1, 0, 0, 2, '', 0, 1007, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1008, 'Chest stretch with support, bent arm', 3, 1, 0, 0, 0, '', 0, 1008, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1009, 'Chest stretch with support, straight arm', 3, 1, 0, 0, 0, '', 0, 1009, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1010, 'Elbow behind head (shoulder and triceps stretch)', 3, 1, 0, 0, 1, '', 0, 1010, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1011, 'Wrist flexor stretch, seated', 3, 1, 0, 0, 1, '', 0, 1011, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1012, 'Wrist extensor stretch, seated', 3, 1, 0, 0, 1, '', 0, 1012, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1013, 'Side bends, seated', 3, 1, 0, 0, 0, '', 0, 1013, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1014, 'Torso rotations, seated', 3, 1, 0, 0, 1, '', 0, 1014, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1015, 'Torso rotations, seated, straight leg', 3, 1, 0, 0, 1, '', 0, 1015, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1016, 'Torso rotations, seated, straight leg, advanced', 3, 1, 0, 0, 2, '', 0, 1016, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1017, 'Cobra stretch', 3, 1, 0, 0, 2, '', 0, 1017, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1018, 'Kneeling lats stretch with rotation', 3, 1, 0, 0, 2, '', 0, 1018, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1019, 'Hip stretch on a bench, advanced', 3, 1, 0, 0, 2, '', 0, 1019, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1020, 'Hip stretch, seated', 3, 1, 0, 0, 0, '', 0, 1020, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1021, 'Hip stretch, seated, advanced', 3, 1, 0, 0, 2, '', 0, 1021, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1022, 'Lying buttock stretch', 3, 1, 0, 0, 0, '', 0, 1022, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1023, 'Standing buttock stretch', 3, 1, 0, 0, 1, '', 0, 1023, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1024, 'Lunge to a bench (buttock stretch)', 3, 1, 0, 0, 1, '', 0, 1024, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1025, 'Bilateral quadriceps stretch', 3, 1, 0, 0, 1, '', 0, 1025, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1026, 'Bilateral quadriceps stretch, advanced', 3, 1, 0, 0, 2, '', 0, 1026, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1027, 'Unilateral quadriceps stretch', 3, 1, 0, 0, 1, '', 0, 1027, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1028, 'Balancing quadriceps stretch', 3, 1, 0, 0, 1, '', 0, 1028, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1029, 'Standing quadriceps stretch with a support', 3, 1, 0, 0, 2, '', 0, 1029, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1030, 'Unilateral standing hamstring stretch', 3, 1, 0, 0, 1, '', 0, 1030, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1031, 'Unilateral standing hamstring stretch, advanced', 3, 1, 0, 0, 2, '', 0, 1031, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1032, 'Lying hamstring stretch, very advanced', 3, 1, 0, 0, 2, '', 0, 1032, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1033, 'Straight leg standing groin stretch', 3, 1, 0, 0, 0, '', 0, 1033, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1034, 'Straight leg standing groin stretch, advanced', 3, 1, 0, 0, 1, '', 0, 1034, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1035, 'Bent-over groin stretch', 3, 1, 0, 0, 0, '', 0, 1035, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1036, 'Side lunge stretch', 3, 1, 0, 0, 1, '', 0, 1036, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1037, 'Straight leg calf stretch', 3, 1, 0, 0, 0, '', 0, 1037, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1038, 'Bent-leg calf stretch', 3, 1, 0, 0, 0, '', 0, 1038, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1039, 'Calf stretch in a lunge', 3, 1, 0, 0, 1, '', 0, 1039, 1, 0, 0, 0, 0, '', ''
UNION ALL SELECT 1040, 'Calf and ankle stretch', 3, 1, 0, 0, 0, '', 0, 1040, 1, 0, 0, 0, 0, '', '';

INSERT INTO exms (ex, ms, lvl, opt)
SELECT 1001, 101, 0, 1
UNION ALL SELECT 1002, 101, 0, 1
UNION ALL SELECT 1003, 101, 0, 1
UNION ALL SELECT 1004, 102, 0, 1
UNION ALL SELECT 1005, 102, 0, 1
UNION ALL SELECT 1006, 102, 0, 1
UNION ALL SELECT 1007, 102, 0, 1
UNION ALL SELECT 1008, 102, 0, 1
UNION ALL SELECT 1009, 102, 0, 1
UNION ALL SELECT 1010, 102, 0, 1
UNION ALL SELECT 1011, 103, 0, 1
UNION ALL SELECT 1012, 103, 0, 1
UNION ALL SELECT 1013, 104, 0, 1
UNION ALL SELECT 1014, 105, 0, 1
UNION ALL SELECT 1015, 105, 0, 1
UNION ALL SELECT 1016, 105, 0, 1
UNION ALL SELECT 1017, 106, 0, 1
UNION ALL SELECT 1018, 106, 0, 1
UNION ALL SELECT 1019, 107, 0, 1
UNION ALL SELECT 1020, 107, 0, 1
UNION ALL SELECT 1021, 107, 0, 1
UNION ALL SELECT 1022, 108, 0, 1
UNION ALL SELECT 1023, 108, 0, 1
UNION ALL SELECT 1024, 108, 0, 1
UNION ALL SELECT 1025, 109, 0, 1
UNION ALL SELECT 1026, 109, 0, 1
UNION ALL SELECT 1027, 109, 0, 1
UNION ALL SELECT 1028, 109, 0, 1
UNION ALL SELECT 1029, 109, 0, 1
UNION ALL SELECT 1030, 110, 0, 1
UNION ALL SELECT 1031, 110, 0, 1
UNION ALL SELECT 1032, 110, 0, 1
UNION ALL SELECT 1033, 111, 0, 1
UNION ALL SELECT 1034, 111, 0, 1
UNION ALL SELECT 1035, 111, 0, 1
UNION ALL SELECT 1036, 111, 0, 1
UNION ALL SELECT 1037, 112, 0, 1
UNION ALL SELECT 1038, 112, 0, 1
UNION ALL SELECT 1039, 112, 0, 1
UNION ALL SELECT 1040, 112, 0, 1;

INSERT INTO exms (ex, ms, lvl, opt)
SELECT 24, 201, 0, 1
UNION ALL SELECT 25, 201, 0, 1
UNION ALL SELECT 26, 201, 0, 1
UNION ALL SELECT 27, 201, 0, 1
UNION ALL SELECT 29, 201, 0, 1
UNION ALL SELECT 30, 202, 0, 1
UNION ALL SELECT 31, 202, 0, 1
UNION ALL SELECT 32, 201, 0, 1
UNION ALL SELECT 33, 202, 0, 1
UNION ALL SELECT 34, 201, 0, 1
UNION ALL SELECT 35, 202, 0, 1
UNION ALL SELECT 37, 201, 0, 1
UNION ALL SELECT 38, 201, 0, 1
UNION ALL SELECT 39, 201, 0, 1
UNION ALL SELECT 40, 201, 0, 1
UNION ALL SELECT 41, 201, 0, 1
UNION ALL SELECT 42, 201, 0, 1
UNION ALL SELECT 43, 201, 0, 1
UNION ALL SELECT 44, 201, 0, 1
UNION ALL SELECT 342, 201, 0, 1
UNION ALL SELECT 343, 201, 0, 1
UNION ALL SELECT 344, 202, 0, 1
UNION ALL SELECT 345, 201, 0, 1
UNION ALL SELECT 346, 201, 0, 1
UNION ALL SELECT 376, 202, 0, 1
UNION ALL SELECT 377, 202, 0, 1
UNION ALL SELECT 378, 202, 0, 1
UNION ALL SELECT 379, 201, 0, 1
UNION ALL SELECT 380, 202, 0, 1
UNION ALL SELECT 382, 201, 0, 1
UNION ALL SELECT 383, 201, 0, 1
UNION ALL SELECT 384, 201, 0, 1
UNION ALL SELECT 385, 201, 0, 1
UNION ALL SELECT 386, 202, 0, 1
UNION ALL SELECT 387, 202, 0, 1
UNION ALL SELECT 388, 201, 0, 1
UNION ALL SELECT 389, 202, 0, 1
UNION ALL SELECT 390, 201, 0, 1
UNION ALL SELECT 391, 201, 0, 1
UNION ALL SELECT 392, 202, 0, 1
UNION ALL SELECT 393, 202, 0, 1
UNION ALL SELECT 394, 201, 0, 1
UNION ALL SELECT 395, 201, 0, 1
UNION ALL SELECT 396, 201, 0, 1
UNION ALL SELECT 397, 202, 0, 1
UNION ALL SELECT 398, 201, 0, 1
UNION ALL SELECT 399, 201, 0, 1
UNION ALL SELECT 400, 202, 0, 1
UNION ALL SELECT 401, 202, 0, 1
UNION ALL SELECT 402, 202, 0, 1
UNION ALL SELECT 403, 201, 0, 1
UNION ALL SELECT 404, 202, 0, 1
UNION ALL SELECT 405, 202, 0, 1
UNION ALL SELECT 406, 202, 0, 1
UNION ALL SELECT 407, 201, 0, 1
UNION ALL SELECT 408, 202, 0, 1
UNION ALL SELECT 409, 201, 0, 1
UNION ALL SELECT 410, 201, 0, 1
UNION ALL SELECT 411, 202, 0, 1
UNION ALL SELECT 412, 201, 0, 1
UNION ALL SELECT 413, 201, 0, 1
UNION ALL SELECT 414, 201, 0, 1
UNION ALL SELECT 415, 201, 0, 1;

INSERT INTO exms (ex, ms, lvl, opt)
SELECT 25, 202, 0, 1
UNION ALL SELECT 29, 202, 0, 1
UNION ALL SELECT 39, 202, 0, 1
UNION ALL SELECT 40, 202, 0, 1
UNION ALL SELECT 43, 202, 0, 1
UNION ALL SELECT 379, 202, 0, 1
UNION ALL SELECT 384, 202, 0, 1
UNION ALL SELECT 390, 202, 0, 1
UNION ALL SELECT 396, 202, 0, 1
UNION ALL SELECT 399, 202, 0, 1
UNION ALL SELECT 407, 202, 0, 1
UNION ALL SELECT 409, 202, 0, 1
UNION ALL SELECT 410, 202, 0, 1
UNION ALL SELECT 413, 202, 0, 1
UNION ALL SELECT 414, 202, 0, 1;
