ALTER TABLE wmove ADD rem TEXT NOT NULL default "";
ALTER TABLE edt_wmove ADD rem TEXT NOT NULL default "";

CREATE TABLE exgoal (
  ex INTEGER NOT NULL,
  msr INTEGER NOT NULL,
  unit 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));

CREATE TABLE msrgoal (
  msr INTEGER NOT NULL,
  unit 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));
