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;