create table shopping_list_items(
id bigserial primary key,
- shopping_list bigint not null references shopping_lists(id),
+ shopping_list bigint not null
+ references shopping_lists(id)
+ on delete cascade,
description text not null,
version bigint not null default 1,
done boolean not null default false );