-- Rename hrtype to flags (continued)

CREATE TABLE _wmove (
    wk        INTEGER NOT NULL,
    daynum    INTEGER NOT NULL,
    num       INTEGER NOT NULL,
    ex        INTEGER NOT NULL DEFAULT 0,
    dt        FLOAT   NOT NULL DEFAULT 0,
    supset    INTEGER NOT NULL DEFAULT 0,
    supsetopt INTEGER NOT NULL DEFAULT 0,
    ttlwgt    FLOAT   NOT NULL DEFAULT 0,
    ttlrep    FLOAT   NOT NULL DEFAULT 0,
    ttldst    FLOAT   NOT NULL DEFAULT 0,
    ttltm     INTEGER NOT NULL DEFAULT 0,
    tmstart   FLOAT   NOT NULL DEFAULT 0,
    tmend     FLOAT   NOT NULL DEFAULT 0,
    ttlcal    FLOAT   NOT NULL DEFAULT 0,
    hravg     INTEGER NOT NULL DEFAULT 0,
    hrmax     INTEGER NOT NULL DEFAULT 0,
    angle     FLOAT   NOT NULL DEFAULT 0,
    dstunit   INTEGER NOT NULL DEFAULT 0,
    wgtunit   INTEGER NOT NULL DEFAULT 0,
    rem       TEXT    NOT NULL DEFAULT "",
    color     INTEGER NOT NULL DEFAULT 0,
    caltype   INTEGER NOT NULL DEFAULT 0,
    flags     INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (wk,daynum,num)
);

INSERT INTO _wmove (wk,daynum,num,ex,dt,supset,supsetopt,ttlwgt,ttlrep,ttldst,ttltm,tmstart,tmend,ttlcal,hravg,hrmax,angle,dstunit,wgtunit,rem,color,caltype,flags)
  SELECT wk,daynum,num,ex,dt,supset,supsetopt,ttlwgt,ttlrep,ttldst,ttltm,tmstart,tmend,ttlcal,hravg,hrmax,angle,dstunit,wgtunit,rem,color,caltype,0
  FROM wmove;
  
DROP TABLE wmove;

ALTER TABLE _wmove RENAME TO wmove;

-- 
  
CREATE TABLE _wset (
    wk      INTEGER NOT NULL,
    daynum  INTEGER NOT NULL,
    movenum INTEGER NOT NULL,
    setnum  INTEGER NOT NULL,
    reps    FLOAT   NOT NULL DEFAULT 0,
    weight  FLOAT   NOT NULL DEFAULT 0,
    rest    INTEGER NOT NULL DEFAULT 0,
    dst     FLOAT   NOT NULL DEFAULT 0,
    tm      INTEGER NOT NULL DEFAULT 0,
    cal     FLOAT   NOT NULL DEFAULT 0,
    hravg   INTEGER NOT NULL DEFAULT 0,
    hrmax   INTEGER NOT NULL DEFAULT 0,
    angle   FLOAT   NOT NULL DEFAULT 0,
    settype INTEGER NOT NULL DEFAULT 0,
    color   INTEGER NOT NULL DEFAULT 0,
    note    TEXT    NOT NULL DEFAULT "",
    caltype INTEGER NOT NULL DEFAULT 0,
    flags   INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (wk,daynum,movenum,setnum)
);

INSERT INTO _wset (wk,daynum,movenum,setnum,reps,weight,rest,dst,tm,cal,hravg,hrmax,angle,settype,color,note,caltype,flags)
  SELECT wk,daynum,movenum,setnum,reps,weight,rest,dst,tm,cal,hravg,hrmax,angle,settype,color,note,caltype,0
  FROM wset;
  
DROP TABLE wset;

ALTER TABLE _wset RENAME TO wset;
