-- 2014-12-26

INSERT INTO exercise (id,name,type,tweight,tuse,tiso,diff,descr,media,uid,price,logsets,logvals)
SELECT 376, "American football",4,1,0,1,0,"",0,376,0,0,0
UNION ALL SELECT 377, "Archery",4,1,0,1,0,"",0,377,0,0,0
UNION ALL SELECT 378, "Australian football",4,1,0,1,0,"",0, 378, 0,0,0
UNION ALL SELECT 379, "Badminton",4,1,0,1,0,"",0, 379, 0,0,0
UNION ALL SELECT 380, "Baseball",4,1,0,1,0,"",0, 380, 0,0,0
UNION ALL SELECT 382, "Bowling",4,1,0,1,0,"",0, 382, 0,0,0
UNION ALL SELECT 383, "Boxing / MMA",4,1,0,1,0,"",0, 383, 0,0,0
UNION ALL SELECT 384, "Climbing",4,1,0,1,0,"",0, 384, 0,0,0
UNION ALL SELECT 385, "Core strengthening",4,1,0,1,0,"",0, 385, 0,0,0
UNION ALL SELECT 386, "Cricket",4,1,0,1,0,"",0, 386, 0,0,0
UNION ALL SELECT 387, "Cross-Country skiing",4,1,0,1,0,"",0, 387, 0,0,0
UNION ALL SELECT 388, "Curling",4,1,0,1,0,"",0, 388, 0,0,0
UNION ALL SELECT 389, "Downhill skiing",4,1,0,1,0,"",0, 389, 0,0,0
UNION ALL SELECT 390, "Equestrian sports",4,1,0,1,0,"",0, 390, 0,0,0
UNION ALL SELECT 391, "Fencing",4,1,0,1,0,"",0, 391, 0,0,0
UNION ALL SELECT 392, "Fishing",4,1,0,1,0,"",0, 392, 0,0,0
UNION ALL SELECT 393, "Golf",4,1,0,1,0,"",0, 393, 0,0,0
UNION ALL SELECT 394, "Gymnastics",4,1,0,1,0,"",0, 394, 0,0,0
UNION ALL SELECT 395, "Handball",4,1,0,1,0,"",0, 395, 0,0,0
UNION ALL SELECT 396, "Hockey",4,1,0,1,0,"",0, 396, 0,0,0
UNION ALL SELECT 397, "Hunting",4,1,0,1,0,"",0, 397, 0,0,0
UNION ALL SELECT 398, "Martial arts",4,1,0,1,0,"",0, 398, 0,0,0
UNION ALL SELECT 399, "Meditation",4,1,0,1,0,"",0, 399, 0,0,0
UNION ALL SELECT 400, "Mountain biking",4,1,0,1,0,"",0, 400, 0,0,0
UNION ALL SELECT 401, "Nordic walking",4,1,0,1,0,"",0, 401, 0,0,0
UNION ALL SELECT 402, "Paddling",4,1,0,1,0,"",0, 402, 0,0,0
UNION ALL SELECT 403, "Pilates",4,1,0,1,0,"",0, 403, 0,0,0
UNION ALL SELECT 404, "Rowing",4,1,0,1,0,"",0, 404, 0,0,0
UNION ALL SELECT 405, "Rugby",4,1,0,1,0,"",0, 405, 0,0,0
UNION ALL SELECT 406, "Sailing",4,1,0,1,0,"",0, 406, 0,0,0
UNION ALL SELECT 407, "Skating",4,1,0,1,0,"",0, 407, 0,0,0
UNION ALL SELECT 408, "Snowboarding",4,1,0,1,0,"",0, 408, 0,0,0
UNION ALL SELECT 409, "Soccer",4,1,0,1,0,"",0, 409, 0,0,0
UNION ALL SELECT 410, "Sports",4,1,0,1,0,"",0, 410, 0,0,0
UNION ALL SELECT 411, "Surfing sports",4,1,0,1,0,"",0, 411, 0,0,0
UNION ALL SELECT 412, "Table tennis",4,1,0,1,0,"",0, 412, 0,0,0
UNION ALL SELECT 413, "Track and field",4,1,0,1,0,"",0, 413, 0,0,0
UNION ALL SELECT 414, "Wheelchair",4,1,0,1,0,"",0, 414, 0,0,0
UNION ALL SELECT 415, "Wrestling",4,1,0,1,0,"",0, 415, 0,0,0
UNION ALL SELECT 416, "Yoga",4,1,0,1,0,"",0, 416, 0,0,0;

UPDATE exercise SET name = "Walking" WHERE id = 35;

ALTER TABLE exlog ADD COLUMN links TEXT;