PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE authors (author_id integer primary key autoincrement, forename text, surname text, turtle text);
INSERT INTO "authors" VALUES(1,'Elizabeth','David',NULL);
INSERT INTO "authors" VALUES(2,'Robert','Pirzig','<> foaf:page <http://robertpirsig.org/>,
             <http://en.wikipedia.org/wiki/Robert_M._Pirsig> .

<http://en.wikipedia.org/wiki/Robert_M._Pirsig> dc:publisher [ foaf:name "Wikipedia" ] .');
CREATE TABLE topics (topic_id integer primary key autoincrement, label text, turtle text);
INSERT INTO "topics" VALUES(1,'Cookery','<> skos:closeMatch <http://purl.org/NET/decimalised#c641> .');
INSERT INTO "topics" VALUES(2,'France',NULL);
INSERT INTO "topics" VALUES(3,'Philosophy',NULL);
CREATE TABLE book_topics (book_id integer, topic_id integer, primary key (book_id, topic_id));
INSERT INTO "book_topics" VALUES(1,1);
INSERT INTO "book_topics" VALUES(1,2);
INSERT INTO "book_topics" VALUES(2,1);
INSERT INTO "book_topics" VALUES(3,3);
CREATE TABLE books
    (
        book_id INTEGER PRIMARY KEY AUTOINCREMENT,
        title TEXT,
        turtle TEXT
    );
INSERT INTO "books" VALUES(1,'French Provincial Cooking',NULL);
INSERT INTO "books" VALUES(2,'Italian Food','<> rdfs:comment "This book tells you how to cook Italian food."@en .');
INSERT INTO "books" VALUES(3,'Zen and the Art of Motorcycle Maintenance: An Inquiry into Values',NULL);
CREATE TABLE book_authors
    (
        book_id INTEGER,
        author_id INTEGER,
        PRIMARY KEY (book_id, author_id)
    );
INSERT INTO "book_authors" VALUES(1,1);
INSERT INTO "book_authors" VALUES(2,1);
INSERT INTO "book_authors" VALUES(3,2);
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('topics',3);
INSERT INTO "sqlite_sequence" VALUES('authors',2);
INSERT INTO "sqlite_sequence" VALUES('books',3);
COMMIT;
