begin transaction;

create table Bill (
	id integer PRIMARY KEY AUTOINCREMENT,
	name TEXT not null
);
create index Bill_name on Bill (name);

create table Payment (
	id integer PRIMARY KEY AUTOINCREMENT,
	billid integer,
	monthFor date not null,
	paymentDate date
);
create unique index Payment_billid_monthFor_unique on Payment (billid, monthFor);
create index Payment_billid on Payment (billid);
create index Payment_monthFor on Payment (monthFor);

commit;