-- Export selected days of one routine

-- Delete from unneeded tables
DELETE FROM dbprops WHERE name <> "version";
DELETE FROM edt_wday;
DELETE FROM edt_wmove;
DELETE FROM edt_workout;
DELETE FROM edt_wset;
DELETE FROM exfav;
DELETE FROM exfavgrp;
DELETE FROM exgoal;
DELETE FROM exlog;
DELETE FROM exlogset;
DELETE FROM msr;
DELETE FROM msrgoal;
DELETE FROM msrpic;
DELETE FROM muscle;
DELETE FROM notes;
DELETE FROM sch;
DELETE FROM schday;
DELETE FROM schwk;
DELETE FROM viewstate;
--(used in loading wk) wkfav;
DELETE FROM wkfavgrp;
DELETE FROM wklog;

-- Delete unneeded exercises
DELETE FROM exercise WHERE id NOT IN ([EXPEXS]);
DELETE FROM exms WHERE ex NOT IN ([EXPEXS]);
DELETE FROM expic WHERE ex NOT IN ([EXPEXS]);

-- Delete unneeded routines
DELETE FROM wday WHERE wk <> [EXPWK];
DELETE FROM wmove WHERE wk <> [EXPWK];
DELETE FROM workout WHERE id <> [EXPWK];
DELETE FROM wset WHERE wk <> [EXPWK];

-- Delete unneeded routine days
DELETE FROM wday WHERE num NOT IN ([EXPWDAYS]);
DELETE FROM wmove WHERE daynum NOT IN ([EXPWDAYS]);
DELETE FROM wset WHERE daynum NOT IN ([EXPWDAYS]);
