-- Create updates table for auto-update system
CREATE TABLE IF NOT EXISTS updates (
    id INT PRIMARY KEY AUTO_INCREMENT,
    version VARCHAR(20) NOT NULL,
    file_path VARCHAR(255) NOT NULL,
    release_notes TEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY unique_version (version)
);

-- Insert initial version (optional)
-- INSERT INTO updates (version, file_path, release_notes) VALUES ('2.0.0', 'updates/PunisherAD_v2.0.zip', 'Initial release with auto-update support');

