drop table if exists book cascade;


create table book (
        id bigserial not null,
        author varchar(255),
        availability varchar(255) check (availability in ('Available','Borrowed','Archive')),
        cat_id varchar(255),
        genre varchar(255) check (genre in ('Fiction','Fantasy','Scifi','Crime','History','Biography','Children','Military','Horor','Romance','Computing')),
        isbn varchar(255),
        publisher varchar(255),
        title varchar(255),
        primary key (id)
);

-- Default model used by JdbcUserDetailsManager
-- TODO 3: Define required tables required by Spring

-- Enable for custom User Details Service implementation
-- TODO 8: Define custom tables


