CREATE TABLE video  (
  id INTEGER NOT NULL,
  room VARCHAR NOT NULL,
  video_id VARCHAR NOT NULL,
  title VARCHAR NOT NULL,
  duration INTEGER,
  added_by_key VARCHAR NOT NULL,
  added_ts DATETIME NOT NULL,
  lastplayed DATETIME,
  position INTEGER NOT NULL,
  pending BOOLEAN,
  status VARCHAR(11) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (position)
)