PHPize Online / SQLize Online  /  SQLtest Online

CREATE DATABASE IF NOT EXISTS bug_bounty_db; USE bug_bounty_db; -- Create the `users` table CREATE TABLE IF NOT EXISTS users ( id INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, role ENUM('user', 'admin') NOT NULL, PRIMARY KEY (id) ); -- Create the `bounties` table CREATE TABLE IF NOT EXISTS bounties ( id INT(11) NOT NULL AUTO_INCREMENT, scope TEXT NOT NULL, reward INT(11) NOT NULL, rules TEXT NOT NULL, PRIMARY KEY (id) ); -- Create the `bug_reports` table CREATE TABLE IF NOT EXISTS bug_reports ( id INT(11) NOT NULL AUTO_INCREMENT, user_id INT(11) NOT NULL, bounty_id INT(11) NOT NULL, details TEXT NOT NULL, poc TEXT NOT NULL, steps_to_reproduce TEXT NOT NULL, severity ENUM('low', 'medium', 'high') NOT NULL, status ENUM('open', 'closed') NOT NULL DEFAULT 'open', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE, FOREIGN KEY (bounty_id) REFERENCES bounties(id) ON DELETE CASCADE );