-- Movies (youtube)
CREATE TABLE exmvi (
  ex INTEGER NOT NULL, 
  mvi INTEGER NOT NULL, 
  ord INTEGER NOT NULL, 
  kind INTEGER NOT NULL, 
  url TEXT NOT NULL, 
  PRIMARY KEY (ex,mvi));

-- Fix log units
UPDATE exlog SET unit = 0 WHERE unit NOT IN (0,1) 
  AND EXISTS (SELECT * FROM exercise AS e WHERE e.id = exlog.ex AND e.type = 2);