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