CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
mobile VARCHAR(20),
password VARCHAR(255),
nid_number VARCHAR(50),
is_admin TINYINT DEFAULT 0
);

CREATE TABLE drive_files(
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
drive_link TEXT
);

CREATE TABLE payments(
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
amount DECIMAL(10,2),
status VARCHAR(20)
);

CREATE TABLE resellers(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
email VARCHAR(255),
password VARCHAR(255),
wallet DECIMAL(10,2) DEFAULT 0
);

CREATE TABLE reseller_clients(
id INT AUTO_INCREMENT PRIMARY KEY,
reseller_id INT,
user_id INT
);