CREATE DATABASE IF NOT EXISTS iot_logs;
USE iot_logs;

CREATE TABLE logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    device_signature VARCHAR(255),
    log_data TEXT
);

INSERT INTO logs (device_signature, log_data) VALUES ('yamato', 'Watched anime for over 20 hours a day');
INSERT INTO logs (device_signature, log_data) VALUES ('yuloli69', 'Forgot to rename the app during the demo');

CREATE TABLE secret (
    flag VARCHAR(255)
);
INSERT INTO secret VALUES ('PoC{CVE-2024-36039_PyMySQL_0bject_Injecti0n_Success}');