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 );