CREATE TABLE _exgoal (
  ex INTEGER NOT NULL,
  msr INTEGER NOT NULL,
  startval FLOAT NOT NULL,
  startdt FLOAT NOT NULL,
  shortval FLOAT NOT NULL,
  shortdt FLOAT NOT NULL,
  longval FLOAT NOT NULL,
  longdt FLOAT NOT NULL,
PRIMARY KEY (ex,msr));

-- convert from LB to KG
UPDATE exgoal SET longval = longval * 0.45359237 WHERE unit = 0 AND msr IN (0,1,2);

INSERT INTO _exgoal (ex,msr,startval,startdt,shortval,shortdt,longval,longdt) SELECT ex,msr,startval,startdt,shortval,shortdt,longval,longdt FROM exgoal;

DROP TABLE exgoal;

ALTER TABLE _exgoal RENAME TO exgoal;

CREATE TABLE _msrgoal (
  msr INTEGER NOT NULL,
  startval FLOAT NOT NULL,
  startdt FLOAT NOT NULL,
  shortval FLOAT NOT NULL,
  shortdt FLOAT NOT NULL,
  longval FLOAT NOT NULL,
  longdt FLOAT NOT NULL,
PRIMARY KEY (msr));

-- convert from LB to KG
UPDATE msrgoal SET longval = longval * 0.45359237 WHERE unit = 0 AND msr IN (0);

-- convert from in to cm
UPDATE msrgoal SET longval = longval/0.0254/100 WHERE unit = 0 AND msr IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17);

INSERT INTO _msrgoal (msr,startval,startdt,shortval,shortdt,longval,longdt) SELECT msr,startval,startdt,shortval,shortdt,longval,longdt FROM msrgoal;

DROP TABLE msrgoal;

ALTER TABLE _msrgoal RENAME TO msrgoal;
