BEGIN TRANSACTION;

INSERT OR IGNORE INTO Types VALUES ( NULL, 'Book' );

INSERT OR IGNORE INTO Attributes VALUES ( NULL, 'author' );
INSERT OR IGNORE INTO Attributes VALUES ( NULL, 'title' );
INSERT OR IGNORE INTO Attributes VALUES ( NULL, 'year' );
INSERT OR IGNORE INTO Attributes VALUES ( NULL, 'publisher' );
INSERT OR IGNORE INTO Attributes VALUES ( NULL, 'isbn' );

INSERT INTO Records VALUES (
  NULL,
  (SELECT TypeID FROM Types WHERE Name = 'Book'),
  'eusterbrock92ininfix',
  NULL,
  NULL
);

INSERT INTO Entries VALUES (
  NULL,
  (SELECT MAX(RecordID) FROM Records),
  (SELECT AttributeID FROM Attributes WHERE Name = 'author'),
  'Jutta Eusterbrock'
);
INSERT INTO Entries VALUES (
  NULL,
  (SELECT MAX(RecordID) FROM Records),
  (SELECT AttributeID FROM Attributes WHERE Name = 'title'),
  'Wissensbasierte Verfahren zur Synthese mathematischer Beweise: Eine kombinatorische Anwendung.'
);
INSERT INTO Entries VALUES (
  NULL,
  (SELECT MAX(RecordID) FROM Records),
  (SELECT AttributeID FROM Attributes WHERE Name = 'year'),
  '1992'
);
INSERT INTO Entries VALUES (
  NULL,
  (SELECT MAX(RecordID) FROM Records),
  (SELECT AttributeID FROM Attributes WHERE Name = 'publisher'),
  'Infix Verlag, St. Augustin, Germany'
);
INSERT INTO Entries VALUES (
  NULL,
  (SELECT MAX(RecordID) FROM Records),
  (SELECT AttributeID FROM Attributes WHERE Name = 'isbn'),
  '3-929037-10-6'
);

COMMIT TRANSACTION;