drop table if exists tracks_tmp;
drop table if exists tracks;

create table tracks_tmp
(
  name string,
  species string,
  revision string,
  kind string,
  descriptionXML string,
  docURL string,
  optparam string
);

create table tracks
(
  id integer not null primary key autoincrement,
  name string,
  species string,
  revision string,
  kind string,
  descriptionXML string,
  docURL string,
  optparam string
);

.separator |
.mode list
.import input/tracklist.dat tracks_tmp
.import input/tracklist.medaka3.dat tracks_tmp


insert into tracks(name, species, revision, kind, descriptionXML, docURL, optparam) select * from tracks_tmp;

drop table tracks_tmp;

