INSERT INTO creator ( bio, birth, death, firstname, lastname) VALUES ('Bold Questerson really likes tacos', 1, 1000001, 'Bold', 'Questerson'), -- 1 ('Curious Explo really likes hamburgers', 2, 1000002, 'Curious', 'Explo'), -- 2 ('Randy Worldson really likes pizza', 3, 1000003, 'Randy', 'Worldson'), -- 3 ('Cheaper Bythedozen really likes fish', 4, 1000004, 'Cheaper', 'Bythedozen'), -- 4 ('Mister History really likes bread', 5, 1000005, 'Mister', 'History'), -- 5 ('Nancy Whodunnit really likes pancakes', 6, 1000006, 'Nancy', 'Whodunnit'), -- 6 ('No Havey really likes asparagus', 7, 1000007, 'No', 'Havey'), -- 7 ('Some writer 8 really likes oranges', 8, 1000008, 'Some8', 'Writer8'); -- 8 INSERT INTO attribution (title, link, accessed) VALUES ('Bold Questerson', 'https://en.wikipedia.org/bold_questerson', CURRENT_TIMESTAMP), -- 1 ('Curious Explo', 'https://en.wikipedia.org/curious_explo', CURRENT_TIMESTAMP), -- 2 ('Randy Worldson', 'https://en.wikipedia.org/randy_worldson', CURRENT_TIMESTAMP), -- 3 ('Cheaper Bythedozen', 'https://en.wikipedia.org/cheaper_bythedozen', CURRENT_TIMESTAMP), -- 4 ('Mister History', 'https://en.wikipedia.org/mister_history', CURRENT_TIMESTAMP), -- 5 ('Nancy Whodunnit', 'https://en.wikipedia.org/nancy_whodunnit', CURRENT_TIMESTAMP), -- 6 ('No Havey', 'https://en.wikipedia.org/no_havey', CURRENT_TIMESTAMP), -- 7 ('Some writer 8', 'https://en.wikipedia.org/some_writer_8', CURRENT_TIMESTAMP); -- 8 INSERT INTO creator_attribution (creator_id, attribution_id) VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8); INSERT INTO series (title, synopsis, total_book_members, total_subseries) VALUES ('Questathon', 'A noble quest is undertaken', 4, 1), -- 1 ('Exploration', 'The unknown is discovered', 3, 1), -- 2 ('Universarium', 'A sprawling universe is painted', 7, 3); -- 3 INSERT INTO subseries (title, synopsis, total_book_members, series_id) VALUES ('Creation', 'The universe is created', 2, 3), -- 1 ('Meet and Greet', 'Heroes are introduced', 2, 3), -- 2 ('The Tasking', 'A quest is given and completed', 3, 3); -- 3 INSERT INTO attribution (title, link, accessed) VALUES ('Questathon', 'https://en.wikipedia.org/questathon_series', CURRENT_TIMESTAMP), -- 9 ('Exploration', 'https://en.wikipedia.org/exploration_series', CURRENT_TIMESTAMP), -- 10 ('Universarium', 'https://en.wikipedia.org/universarium', CURRENT_TIMESTAMP); -- 11 INSERT INTO series_attribution (series_id, attribution_id) VALUES (1, 9), (2, 10), (3, 11); INSERT INTO subseries_attribution (subseries_id, attribution_id) VALUES (1, 11), (2, 11), (3, 11); INSERT INTO genre (genre, enum) VALUES ('Childrens', 'CHILDRENS'), -- 1 ('History', 'HISTORY'), -- 2 ('Mystery', 'MYSTERY'), -- 3 ('High Fantasy', 'HIGH_FANTASY'); -- 4 -- Questathon INSERT INTO title (title, year, synopsis, series_part, series_id) VALUES ('Calling', 1980, 'Heroes are called to quest', '1', 1), -- 1 ('Travel', 1981, 'Heroes travail and travel', '2', 1), -- 2 ('Struggle', 1982, 'Heroes struggle against the foe', '3', 1), -- 3 ('Prevail', 1998, 'Heroes prevail', '4', 1); -- 4 INSERT INTO title_genre (title_id, genre_id) VALUES (1, 4), (2, 4), (3, 4), (4, 4); INSERT INTO creator_title (title_id, creator_id) VALUES (1, 1), (2, 1), (3, 1), (4, 1); -- Exploration INSERT INTO title (title, year, synopsis, series_part, series_id) VALUES ('First Encounter', 2010, 'The unknown presents itself', '1', 1), -- 5 ('Into the Unknown', 2011, 'Boldventurers enter the unknown', '2', 1), -- 6 ('Denouement', 2012, 'The unfamiliar becomes known', '3', 1); -- 7 INSERT INTO title_genre (title_id, genre_id) VALUES (5, 4), (6, 4), (7, 4); INSERT INTO creator_title (title_id, creator_id) VALUES (5, 2), (6, 2), (7, 2); -- Universarium -- creation INSERT INTO title (title, year, synopsis, series_part, series_id, subseries_part, subseries_id) VALUES ('The Void', 1970, 'At the start of it all, it was void', '1', 1, '1', 1), -- 8 ('The Beginning', 1971, 'And then there was creation', '2', 1, '2', 1); -- 9 INSERT INTO title_genre (title_id, genre_id) VALUES (8, 4), (9, 4); INSERT INTO creator_title (title_id, creator_id) VALUES (8, 3), (9, 3); -- meet and greet INSERT INTO title (title, year, synopsis, series_part, series_id, subseries_part, subseries_id) VALUES ('The Meeting', 1972, 'Heroes arise', '3', 1, '1', 2), -- 10 ('The Crux', 1973, 'The nemesis awakens', '4', 1, '2', 2); -- 11 INSERT INTO title_genre (title_id, genre_id) VALUES (10, 4), (11, 4); INSERT INTO creator_title (title_id, creator_id) VALUES (10, 3), (11, 3); -- the tasking INSERT INTO title (title, year, synopsis, series_part, series_id, subseries_part, subseries_id) VALUES ('The Charge', 1974, 'A clarion call is issued', '5', 1, '1', 3), -- 12 ('The Depths', 1975, 'Heroes are onset by the nemesis', '6', 1, '2', 3), -- 13 ('The Reckoning', 1976, 'The heroes reprisal', '7', 1, '3', 3); -- 14 INSERT INTO title_genre (title_id, genre_id) VALUES (12, 4), (13, 4), (14, 4); INSERT INTO creator_title (title_id, creator_id) VALUES (12, 3), (13, 3), (14, 3); -- cheaper by the dozen childrens' books INSERT INTO series (title, synopsis, total_book_members, total_subseries) VALUES ('That is not my', 'stuff looks like stuff, but isnt', 13, 1); -- 4 INSERT INTO title (title, year, synopsis, series_part, series_id) VALUES ('That is not my scrench', 2004, 'Several tools do not resemble a scrench', '1', 4), -- 15 ('That is not my blowtorch', 2004, 'Several tools do not resemble a blowtorch', '2', 4), -- 16 ('That is not my pulley', 2004, 'Several tools do not resemble a pulley', '3', 4), -- 17 ('That is not my hammer', 2004, 'Several tools do not resemble a hammer', '4', 4), -- 18 ('That is not my plumbline', 2005, 'Several tools do not resemble a plumbline', '5', 4), -- 19 ('That is not my speedsquare', 2005, 'Several tools do not resemble a speedsquare', '6', 4), -- 20 ('That is not my plunger', 2006, 'Several tools do not resemble a plunger', '7', 4), -- 21 ('That is not my trowel', 2007, 'Several tools do not resemble a trowel', '8', 4), -- 22 ('That is not my heatgun', 2008, 'Several tools do not resemble a heatgun', '9', 4), -- 23 ('That is not my screwdriver', 2008, 'Several tools do not resemble a screwdriver', '10', 4), -- 24 ('That is not my awl', 2008, 'Several tools do not resemble an awl', '11', 4), -- 25 ('That is not my multimeter', 2009, 'Several tools do not resemble a multimeter', '12', 4), -- 26 ('That is not my level', 2010, 'Several tools do not resemble a level', '13', 4); -- 27 INSERT INTO title_genre (title_id, genre_id) VALUES (15, 1), (16, 1), (17, 1), (18, 1), (19, 1), (20, 1), (21, 1), (22, 1), (23, 1), (24, 1), (25, 1), (26, 1), (27, 1); INSERT INTO creator_title (title_id, creator_id) VALUES (15, 4), (16, 4), (17, 4), (18, 4), (19, 4), (20, 4), (21, 4), (22, 4), (23, 4), (24, 4), (25, 4), (26, 4), (27, 4); -- history INSERT INTO title (title, year, synopsis) VALUES ('The 30 years snore', 1948, 'Covers the outset of the sleep all the way to the treaty of Westpillowia'); -- 28 INSERT INTO title_genre (title_id, genre_id) VALUES (28, 2); INSERT INTO creator_title (title_id, creator_id) VALUES (28, 5); -- mystery INSERT INTO title (title, year, synopsis) VALUES ('B is for Bludgeoned', 1995, 'Whodunnit in this bashful tale?'); -- 29 INSERT INTO title_genre (title_id, genre_id) VALUES (29, 3); INSERT INTO creator_title (title_id, creator_id) VALUES (29, 6); -- multiple creator title INSERT INTO title (title, year, synopsis) VALUES ('The Multiauthor story', 1988, 'A yarn so long it had to be spun by more than one author'); -- 30 INSERT INTO title_genre (title_id, genre_id) VALUES (30, 2); INSERT INTO creator_title (title_id, creator_id) VALUES (30, 5); INSERT INTO creator_title (title_id, creator_id) VALUES (30, 8);