Я дал список колонок просто.
SQL:
ALTER TABLE xf_resource
ADD 'resource_cover_image' => 'TINYINT(3) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_color' => 'VARCHAR(7) NOT NULL DEFAULT 0',
ADD 'resource_cover_date' => 'INT(10) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_width' => 'SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_height' => 'SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_crop_x' => 'INT(10) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_crop_y' => 'INT(10) UNSIGNED NOT NULL DEFAULT 0',
ADD 'resource_cover_state' => 'ENUM(\'visible\', \'moderated\', \'deleted\') DEFAULT \'visible\';