--workout favorites
CREATE TABLE wkfavgrp (
id INTEGER NOT NULL PRIMARY KEY, 
name TEXT NOT NULL,
ordno INTEGER NOT NULL);

CREATE TABLE NEW_wkfav (
fav INTEGER NOT NULL,
wk INTEGER NOT NULL,
wknum INTEGER NOT NULL,
PRIMARY KEY (fav,wk));

INSERT OR IGNORE INTO NEW_wkfav (fav, wk, wknum) SELECT 0, wk, 0 FROM wkfav;

DROP TABLE IF EXISTS wkfav;

ALTER TABLE NEW_wkfav RENAME TO wkfav;
