2 lists_version bigint not null,
3 db_revision bigint not null );
5 insert into globals(lists_version, db_revision) values(1, 0);
7 create table shopping_lists(
8 id bigserial primary key,
10 version bigint not null default 1 );
12 create table shopping_list_items(
13 id bigserial primary key,
14 shopping_list bigint not null
15 references shopping_lists(id)
17 description text not null,
18 version bigint not null default 1,
19 done boolean not null default false );