The following SQL creates the tables used by the book example content repository:

-- drop table book_folder;
-- drop table book_info;

CREATE TABLE book_folder (
     id                VARCHAR(32)     not null,
     parentFolder      VARCHAR(32)     null references book_folder(id),
     folderPath        long varchar    null,
     primary key(id)
);

CREATE TABLE book_info (
     id                 VARCHAR(32)     not null,
     filePath           long varchar     null,
     parentFolder       VARCHAR(32)     null references book_folder(id),
     title              long varchar     null,
     author             long varchar     null,
     primary key(id)
);