
-- Rename hrtype to flags


CREATE TABLE _edt_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 _edt_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 edt_wmove;
  
DROP TABLE edt_wmove;

ALTER TABLE _edt_wmove RENAME TO edt_wmove;

-- 
  
CREATE TABLE _edt_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 _edt_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 edt_wset;
  
DROP TABLE edt_wset;

ALTER TABLE _edt_wset RENAME TO edt_wset;
