-- Rename hrtype to flags (continued)

CREATE TABLE _exlogset (
    dt      FLOAT   NOT NULL,
    movenum INTEGER NOT NULL,
    setnum  INTEGER NOT NULL,
    reps    INTEGER 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 (dt,movenum,setnum)
);
  
INSERT INTO _exlogset (dt,movenum,setnum,reps,weight,rest,dst,tm,cal,hravg,hrmax,angle,settype,color,note,caltype,flags)
  SELECT dt,movenum,setnum,reps,weight,rest,dst,tm,cal,hravg,hrmax,angle,settype,color,note,caltype,0
  FROM exlogset
  WHERE dt IS NOT NULL AND movenum IS NOT NULL AND setnum IS NOT NULL;
  
DROP TABLE exlogset;

ALTER TABLE _exlogset RENAME TO exlogset;

