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) );