CREATE TABLE productions (
  id INTEGER PRIMARY KEY,
  title TEXT,
  creator TEXT,
  subject TEXT,
  description TEXT,
  publisher TEXT,
  date TEXT,
  type TEXT,
  format TEXT,
  identifier TEXT,
  source TEXT,
  language TEXT,
  rights TEXT,
  sourceDate TEXT,
  sourceEdition TEXT,
  sourcePublisher TEXT,
  sourceRights TEXT,
  multimediaType TEXT,
  multimediaContent TEXT,
  narrator TEXT,
  producer TEXT,
  producedDate TEXT,
  revision TEXT,
  revisionDate TEXT,
  revisionDescription TEXT,
  totalTime TEXT,
  audioFormat TEXT,
  -- SBS specific columns 
  state TEXT,
  productNumber TEXT
);

INSERT INTO productions (title, creator, source, language, sourcePublisher) VALUES 
("Unter dem Deich", "Hart, Maarten", "978-3-492-05573-4", "de", "Piper"),
("Aus dem Berliner Journal", "Frisch, Max", "978-3-518-42352-3", "de", "Suhrkamp"),
("Info-Express, Februar 2014", "SZB Taubblinden-Beratung", "", "de", "");

-- Meta data for a production
-- see http://www.daisy.org/z3986/2005/Z3986-2005.html#PubMed
CREATE TABLE productions (
  id INTEGER PRIMARY KEY,
  title TEXT,
  creator TEXT,
  subject TEXT,
  description TEXT,
  publisher TEXT,
  date TEXT,
  type TEXT,
  format TEXT,
  identifier TEXT,
  source TEXT,
  language TEXT,
  rights TEXT,
  sourceDate TEXT,
  sourceEdition TEXT,
  sourcePublisher TEXT,
  sourceRights TEXT,
  multimediaType TEXT,
  multimediaContent TEXT,
  narrator TEXT,
  producer TEXT,
  producedDate TEXT,
  revision TEXT,
  revisionDate TEXT,
  revisionDescription TEXT,
  totalTime TEXT,
  audioFormat TEXT,
  -- SBS specific columns 
  state TEXT,
  productNumber TEXT
);

INSERT INTO productions (title, creator, source, language, sourcePublisher) VALUES 
("Unter dem Deich", "Hart, Maarten", "978-3-492-05573-4", "de", "Piper"),
("Aus dem Berliner Journal", "Frisch, Max", "978-3-518-42352-3", "de", "Suhrkamp"),
("Info-Express, Februar 2014", "SZB Taubblinden-Beratung", "", "de", "");

Add a note about the origin of the meta data schema
Add a note about the origin of the meta data schema
