text: --
  -- Create a very simple database to hold book and author information
  --
  PRAGMA foreign_keys = ON;
  CREATE TABLE book (
          id          INTEGER PRIMARY KEY,
          title       TEXT ,
          rating      INTEGER
  );
  -- 'book_author' is a many-to-many join table between books & authors
  CREATE TABLE book_author (
          book_id     INTEGER REFERENCES book(id) ON DELETE CASCADE ON UPDATE CASCADE,
          author_id   INTEGER REFERENCES author(id) ON DELETE CASCADE ON UPDATE CASCADE,
          PRIMARY KEY (book_id, author_id)
  );
  CREATE TABLE author (
          id          INTEGER PRIMARY KEY,
          first_name  TEXT,
          last_name   TEXT
  );
  ---
  --- Load some sample data
  ---
  INSERT INTO book VALUES (1, 'CCSP SNRS Exam Certification Guide', 5);
  INSERT INTO book VALUES (2, 'TCP/IP Illustrated, Volume 1', 5);
  INSERT INTO book VALUES (3, 'Internetworking with TCP/IP Vol.1', 4);
  INSERT INTO book VALUES (4, 'Perl Cookbook', 5);
  INSERT INTO book VALUES (5, 'Designing with Web Standards', 5);
  INSERT INTO author VALUES (1, 'Greg', 'Bastien');
  INSERT INTO author VALUES (2, 'Sara', 'Nasseh');
  INSERT INTO author VALUES (3, 'Christian', 'Degu');
  INSERT INTO author VALUES (4, 'Richard', 'Stevens');
  INSERT INTO author VALUES (5, 'Douglas', 'Comer');
  INSERT INTO author VALUES (6, 'Tom', 'Christiansen');
  INSERT INTO author VALUES (7, 'Nathan', 'Torkington');
  INSERT INTO author VALUES (8, 'Jeffrey', 'Zeldman');
  INSERT INTO book_author VALUES (1, 1);
  INSERT INTO book_author VALUES (1, 2);
  INSERT INTO book_author VALUES (1, 3);
  INSERT INTO book_author VALUES (2, 4);
  INSERT INTO book_author VALUES (3, 5);
  INSERT INTO book_author VALUES (4, 6);
  INSERT INTO book_author VALUES (4, 7);
  INSERT INTO book_author VALUES (5, 8);