-- Add real filename and comment fields to attachments.

ALTER TABLE `#__kunena_attachments`
  ADD `protected` TINYINT(4) NOT NULL DEFAULT '0'
  AFTER `userid`;
ALTER TABLE `#__kunena_attachments`
  ADD `filename_real` VARCHAR(255) NOT NULL DEFAULT ''
COMMENT 'Filename for downloads.';
ALTER TABLE `#__kunena_attachments`
  ADD `caption` VARCHAR(255) NOT NULL DEFAULT 'Caption text.';
UPDATE `#__kunena_attachments`
SET `filename_real` = `filename`
WHERE `filename_real` = '';
ALTER TABLE `#__kunena_attachments`
  ADD INDEX `filename_real` (`filename_real`);