CREATE TABLE Printers (
    id INT PRIMARY KEY AUTO_INCREMENT UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT(CURRENT_TIMESTAMP),
    last_modified TIMESTAMP NOT NULL DEFAULT(CURRENT_TIMESTAMP) ON UPDATE CURRENT_TIMESTAMP,

    printer_name VARCHAR(255) UNIQUE NOT NULL,
    printer_tag VARCHAR(255) UNIQUE NOT NULL,

    printer_location INT NOT NULL,
    printer_model INT NOT NULL,

    ip_address VARCHAR(255) DEFAULT('N/A'),
    api_key VARCHAR(255) DEFAULT('N/A'),

    status VARCHAR(255) DEFAULT('operational')
    
); 