insert-stmts.sql

INSERT INTO genres (name, parent_id) VALUES ('Arts & Photography',NULL);
INSERT INTO genres (name, parent_id) VALUES ('Architecture',1);
INSERT INTO genres (name, parent_id) VALUES ('Graphic Design',1);
INSERT INTO genres (name, parent_id) VALUES ('Music',1); -- 4
INSERT INTO genres (name, parent_id) VALUES ('Songbooks',4);
INSERT INTO genres (name, parent_id) VALUES ('Instruments & Performers',4); -- 6
INSERT INTO genres (name, parent_id) VALUES ('Brass',6);
INSERT INTO genres (name, parent_id) VALUES ('Woodwinds',6);

INSERT INTO genres (name, parent_id) VALUES ('Comics & Graphic Novels', NULL); -- 9
INSERT INTO genres (name, parent_id) VALUES ('Comic Strips',9);
INSERT INTO genres (name, parent_id) VALUES ('Graphic Novels',9);
INSERT INTO genres (name, parent_id) VALUES ('Manga',9);

INSERT INTO genres (name, parent_id) VALUES ('Comic Strips',NULL); -- 13
INSERT INTO genres (name, parent_id) VALUES ('Mystery, Thriller and Suspense', NULL); -- 14
INSERT INTO genres (name, parent_id) VALUES ('Mystery',14); -- 15
INSERT INTO genres (name, parent_id) VALUES ('Hard Boiled',15);
INSERT INTO genres (name, parent_id) VALUES ('Police Procedurals',15); -- 17
INSERT INTO genres (name, parent_id) VALUES ('British Detectives',17);
INSERT INTO genres (name, parent_id) VALUES ('FBI Agents',17);
INSERT INTO genres (name, parent_id) VALUES ('Police Officers',17);

INSERT INTO genres (name, parent_id) VALUES ('Nonfiction', NULL); -- 21
INSERT INTO genres (name, parent_id) VALUES ('Biographies and Memoirs',21);
INSERT INTO genres (name, parent_id) VALUES ('Business & Investing',21);
INSERT INTO genres (name, parent_id) VALUES ('Computers & Technology',21); -- 24
INSERT INTO genres (name, parent_id) VALUES ('Databases',24);
INSERT INTO genres (name, parent_id) VALUES ('Hardware',24);
INSERT INTO genres (name, parent_id) VALUES ('Software',24);