CREATE TABLE admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL,
    remember_token VARCHAR(255) DEFAULT NULL
);

-- Insert initial admin (password 'Sb@scratch1' hashed)
INSERT INTO admins (username, password, email) VALUES (
    'sb',
    '$2y$10$27QzHYaLfEOAeXesS33PhexQ.uj0mRKY./VpRPgdn9slVBEJw69nS',
    'admin@example.com'
);

CREATE TABLE questionnaires (
    id INT AUTO_INCREMENT PRIMARY KEY,
    unique_id VARCHAR(10) UNIQUE NOT NULL,
    title VARCHAR(255) NOT NULL,
    created_at DATETIME NOT NULL,
    json_path VARCHAR(255) NOT NULL
);