CREATE DATABASE vlogbir_billing;
USE vlogbir_billing;

CREATE TABLE admin (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(255)
);

INSERT INTO admin (username,password) VALUES ('admin',MD5('123456'));

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