CREATE TABLE authors
(
    id INTEGER PRIMARY KEY NOT NULL,
    name VARCHAR(255)
);

INSERT INTO public.authors (id, name) VALUES (1, 'Charles Blum');
INSERT INTO public.authors (id, name) VALUES (2, 'Larry Ulman');
INSERT INTO public.authors (id, name) VALUES (3, 'Dave Cheney');
INSERT INTO public.authors (id, name) VALUES (4, 'Aamir Khan');
INSERT INTO public.authors (id, name) VALUES (5, 'Aaron Torres');

--

CREATE TABLE books
(
    id INTEGER PRIMARY KEY NOT NULL,
    title VARCHAR(255) NOT NULL,
    author_id INTEGER NOT NULL,
    trash BOOLEAN DEFAULT false NOT NULL
);

--

CREATE TABLE books_bookshelfs
(
    book_id INTEGER NOT NULL,
    bookshelf_id INTEGER NOT NULL
);

--

CREATE TABLE bookshelfs
(
    id INTEGER PRIMARY KEY NOT NULL,
    title VARCHAR(255) NOT NULL
);