CIV v2 Databases

In order for the program to be able to save past history, I need to make a database.

The database will be quite simple. It needs to just store the amount of money that is still currently available.

So the columns of the database will be as follows
Date
User
twodollars
oneDollar
fiftyCents
twentyCents
tenCents
fiveCents

-- a Date is needed because we want to know what time the money was taken out of the system
-- the user is required because we want to know who is taking the money

Also we need to make sure an ID is available.

The SQL Command that I used is


create table civtable (
id integer primary key generated always as identity,
username varchar(30),
twodollars int,
onedollar int,
fiftycents int,
twentycents int,
tencents int,
fivecents int
);