ALTER TABLE articles
ADD COLUMN minimum_stock DECIMAL(10,2) DEFAULT 0.00 AFTER selling_price;

CREATE TABLE IF NOT EXISTS article_files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    article_id INT NOT NULL,
    file_name VARCHAR(255) NOT NULL,
    original_name VARCHAR(255) NOT NULL,
    file_path VARCHAR(500) NOT NULL,
    mime_type VARCHAR(100),
    file_size INT NULL,
    description VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (article_id) REFERENCES articles(id) ON DELETE CASCADE
);
