CREATE DATABASE vlogbir_billing;
USE vlogbir_billing;

CREATE TABLE invoices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    client_name VARCHAR(100),
    amount DECIMAL(10,2),
    gst DECIMAL(10,2),
    total DECIMAL(10,2),
    gst_type VARCHAR(10),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);