-- First, remove the table if it exists
drop table if exists bookmarks;

-- Create the table anew
create table bookmarks (
  id INTEGER primary key generated by default as identity,
  bookName text,
  page INT(4)
);

-- insert some test data
-- Using a multi-row insert statement here
insert into bookmarks (bookName, page)
values
  ('The Lord of the Rings: The Return of the King', 75),
  ('Don Quixote', 213),
  ('A Man Called Ove', 12),
  ('Pride and Prejudice', 150),
  ('Olympos', 52),
  ('Feed', 79),
  ('Good Omens', 112),
  ('Discworld', 49),
  ('Creepers', 3),
  ('Greybeard', 101),