generated from dave/wails-template
19 lines
477 B
SQL
19 lines
477 B
SQL
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; |