CREATE DATABASE IF NOT EXISTS brazy_hotspot CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE brazy_hotspot;
CREATE TABLE admins (
 id INT AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(80) NOT NULL UNIQUE,
 password_hash VARCHAR(255) NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE voucher_batches (
 id INT AUTO_INCREMENT PRIMARY KEY,
 batch_name VARCHAR(120) NOT NULL,
 profile_name VARCHAR(80) NOT NULL,
 quantity INT NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE vouchers (
 id INT AUTO_INCREMENT PRIMARY KEY,
 batch_id INT NULL,
 username VARCHAR(80) NOT NULL UNIQUE,
 password VARCHAR(80) NOT NULL,
 profile_name VARCHAR(80) NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 FOREIGN KEY (batch_id) REFERENCES voucher_batches(id) ON DELETE SET NULL
);