CREATE TABLE wset (
  wk INTEGER NOT NULL, 
  daynum INTEGER NOT NULL, 
  movenum INTEGER NOT NULL, 
  setnum INTEGER NOT NULL,
  reps INTEGER NOT NULL,
  weight FLOAT NOT NULL,
  rest INTEGER NOT NULL,
  PRIMARY KEY (wk, daynum, movenum, setnum)
);

ALTER TABLE workout ADD COLUMN pstype INTEGER NOT NULL DEFAULT 0;
ALTER TABLE workout ADD COLUMN wtype INTEGER NOT NULL DEFAULT 0;
ALTER TABLE workout ADD COLUMN wtsets INTEGER NOT NULL DEFAULT 0;
ALTER TABLE workout ADD COLUMN wtrepsfrom INTEGER NOT NULL DEFAULT 0;
ALTER TABLE workout ADD COLUMN wtrepsto INTEGER NOT NULL DEFAULT 0;

CREATE TABLE NEW_wmove (
  wk INTEGER NOT NULL, 
  daynum INTEGER NOT NULL, 
  num INTEGER NOT NULL, 
  ex INTEGER NOT NULL,
  unit INTEGER NOT NULL, 
  supset INTEGER NOT NULL, 
  ttldst FLOAT NOT NULL,
  ttltm INTEGER NOT NULL,
  tmstart FLOAT NOT NULL,
  tmend FLOAT NOT NULL,
  ttlcal FLOAT NOT NULL,
  hravg INTEGER NOT NULL,
  hrmax INTEGER NOT NULL, 
  PRIMARY KEY (wk, daynum, num)
);

INSERT INTO NEW_wmove (wk, daynum, num, ex, unit, supset, ttldst, ttltm, tmstart, tmend, ttlcal, hravg, hrmax) SELECT wk, daynum, num, ex, unit, supset, 0, 0, 0, 0, 0, 0, 0 FROM wmove;

DROP TABLE wmove;

ALTER TABLE NEW_wmove RENAME TO wmove;

ALTER TABLE exlogset ADD COLUMN rest INTEGER NOT NULL DEFAULT 0;

CREATE TABLE edt_workout (
  id INTEGER NOT NULL PRIMARY KEY, 
  name TEXT NOT NULL, 
  split INTEGER NOT NULL, 
  ordno INTEGER NOT NULL, 
  equip INTEGER NOT NULL, 
  diff INTEGER NOT NULL, 
  pstype INTEGER NOT NULL,
  wtype INTEGER NOT NULL, 
  wtsets INTEGER NOT NULL, 
  wtrepsfrom INTEGER NOT NULL, 
  wtrepsto INTEGER NOT NULL
);

CREATE TABLE edt_wday (
  wk INTEGER NOT NULL, 
  num INTEGER NOT NULL, 
  color INTEGER NOT NULL, 
  descr TEXT NOT NULL, 
  PRIMARY KEY (wk,num)
);

CREATE TABLE edt_wmove (
  wk INTEGER NOT NULL, 
  daynum INTEGER NOT NULL, 
  num INTEGER NOT NULL, 
  ex INTEGER NOT NULL,
  unit INTEGER NOT NULL, 
  supset INTEGER NOT NULL, 
  ttldst FLOAT NOT NULL,
  ttltm INTEGER NOT NULL,
  tmstart FLOAT NOT NULL,
  tmend FLOAT NOT NULL,
  ttlcal FLOAT NOT NULL,
  hravg INTEGER NOT NULL,
  hrmax INTEGER NOT NULL, 
  PRIMARY KEY (wk, daynum, num)
);


CREATE TABLE edt_wset (
  wk INTEGER NOT NULL, 
  daynum INTEGER NOT NULL, 
  movenum INTEGER NOT NULL, 
  setnum INTEGER NOT NULL,
  reps INTEGER NOT NULL,
  weight FLOAT NOT NULL,
  rest INTEGER NOT NULL,
  PRIMARY KEY (wk, daynum, movenum, setnum)
);
