Installation
installation
Insert this in your database and you are good to go!
CREATE TABLE IF NOT EXISTS loans ( id INT AUTO_INCREMENT PRIMARY KEY,
identifier VARCHAR(50),
amount DECIMAL(10, 2),
remaining DECIMAL(10, 2),
interest DECIMAL(5, 2),
loanDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP, taken_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );
Last updated