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 ,
.
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 .');
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;