DROP TABLE tv;
VACUUM;
CREATE TABLE 'tv' (
  'index'       STRING,
  'type'        STRING,
  'name'        STRING,
  'pid'         STRING,
  'available'   STRING,
  'episode'     STRING,
  'seriesnum'   STRING,
  'episodenum'  STRING,
  'versions'    STRING,
  'duration'    STRING,
  'desc'        STRING,
  'channel'     STRING,
  'categories'  STRING,
  'thumbnail'   STRING,
  'timeadded'   STRING,
  'guidance'    STRING,
  'web'         STRING,
  'dummy_last'  STRING
);

.mode csv
.separator "|"
.import tmp.cache tv
.quit
