-- normalize msr, add UID for healthkit integration

CREATE TABLE _msr (
  `dt` FLOAT NOT NULL,
  `idn` INTEGER NOT NULL default 0,
  `val` FLOAT NOT NULL default 0,
  `units` INTEGER NOT NULL default 0,
  `uid` TEXT NOT NULL default "",
  `src` INTEGER NOT NULL default 0,
  PRIMARY KEY  (`dt`, `idn`)
);

INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 0, weight, units, "", 0 FROM msr WHERE weight > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 1, neck, units, "", 0 FROM msr WHERE neck > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 2, shoulder, units, "", 0 FROM msr WHERE shoulder > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 3, forearml, units, "", 0 FROM msr WHERE forearml > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 4, forearmr, units, "", 0 FROM msr WHERE forearmr > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 5, bicepl, units, "", 0 FROM msr WHERE bicepl > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 6, bicepr, units, "", 0 FROM msr WHERE bicepr > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 7, chest, units, "", 0 FROM msr WHERE chest > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 8, waist, units, "", 0 FROM msr WHERE waist > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 9, abdomen, units, "", 0 FROM msr WHERE abdomen > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 10, hips, units, "", 0 FROM msr WHERE hips > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 11, thighl, units, "", 0 FROM msr WHERE thighl > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 12, thighr, units, "", 0 FROM msr WHERE thighr > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 13, calfl, units, "", 0 FROM msr WHERE calfl > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 14, calfr, units, "", 0 FROM msr WHERE calfr > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 15, height, units, "", 0 FROM msr WHERE height > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 16, wristl, units, "", 0 FROM msr WHERE wristl > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 17, wristr, units, "", 0 FROM msr WHERE wristr > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 18, x0, units, "", 0 FROM msr WHERE x0 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 19, x1, units, "", 0 FROM msr WHERE x1 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 20, x2, units, "", 0 FROM msr WHERE x2 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 21, x3, units, "", 0 FROM msr WHERE x3 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 22, x4, units, "", 0 FROM msr WHERE x4 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 23, x5, units, "", 0 FROM msr WHERE x5 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 24, x6, units, "", 0 FROM msr WHERE x6 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 25, x7, units, "", 0 FROM msr WHERE x7 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 26, x8, units, "", 0 FROM msr WHERE x8 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 27, x9, units, "", 0 FROM msr WHERE x9 > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 1000, age, units, "", 0 FROM msr WHERE age > 0;
INSERT INTO _msr (dt, idn, val, units, uid, src) SELECT dt, 1001, gender, units, "", 0 FROM msr;

DROP TABLE msr;

ALTER TABLE _msr RENAME TO msr;
