CREATE TABLE IF NOT EXISTS media_library (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    filename VARCHAR(255) NOT NULL,
    original_name VARCHAR(255) NOT NULL,
    file_url VARCHAR(1000) NOT NULL,
    file_type ENUM('video','image') NOT NULL,
    file_size BIGINT DEFAULT 0,
    created_at DATETIME DEFAULT NOW()
);