-- Drop existing tables
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS products;

-- Create users table
CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    password TEXT NOT NULL
);

INSERT INTO users (username, password) VALUES
('anthony.mark@cybercorp.com', 'justinbieber'),
('johnson.alice@cybercorp.com', 'tigUE-sTRap-MENTATE'),
('smith.bob@cybercorp.com', 'tM82O6KPdD!'),
('mallory.eve@cybercorp.com', 'ZBce3O1f*5}7K');

-- Create products table
CREATE TABLE products (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    description TEXT NOT NULL
);

INSERT INTO products (name, description) VALUES
('SuperSecure USB', 'Military grade encryption'),
('Hardened Laptop', 'Designed for cybersecurity experts'),
('VPN Subscription', 'Private, fast, and anonymous browsing'),
('Firewall Pro', 'Enterprise-class perimeter defense'),
('Phishing Simulator', 'Test your team with fake phishing campaigns');