begin;

drop table if exists accounts;

create table accounts (
   id integer primary key,
   owner varchar(32) not null,
   balance integer check (balance >= 0)
);

insert into accounts values (1,   'Jones', 500);
insert into accounts values (2,   'Smith',   700);
insert into accounts values (3,   'Smith',  400);
insert into accounts values (4,   'Hatfield',  350);
insert into accounts values (5,   'McCoy',  900);
insert into accounts values (6,   'Harris',  700);
insert into accounts values (7,   'Lewis', 750);
insert into accounts values (8,   'Urban',  850);
insert into accounts values (9,   'Jones',  625);

commit;
