CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
password VARCHAR(255)
);

INSERT INTO users(name,email,password)
VALUES('Administrator','admin@caravan.com',
'$2y$10$CwTycUXWue0Thq9StjUM0uJ8oKXc5x4yYdExgkt1lEuzMdGII4XyO');

CREATE TABLE categories(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
type ENUM('income','expense'),
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO categories(name,type) VALUES
('Sales','income'),
('Service Revenue','income'),
('Consulting','income'),
('Salary','expense'),
('Electricity','expense'),
('Office Expense','expense');

CREATE TABLE income(
id INT AUTO_INCREMENT PRIMARY KEY,
category VARCHAR(100),
amount DECIMAL(12,2),
mode VARCHAR(50),
description TEXT,
bill VARCHAR(255),
date DATE,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE expense(
id INT AUTO_INCREMENT PRIMARY KEY,
category VARCHAR(100),
amount DECIMAL(12,2),
mode VARCHAR(50),
description TEXT,
bill VARCHAR(255),
date DATE,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);