-- Compatibility correction for MySQL/MariaDB versions that do not support ADD COLUMN IF NOT EXISTS.
-- Safe to execute more than once.
SET @schema_name = DATABASE();
SET @column_exists = (
 SELECT COUNT(*) FROM information_schema.COLUMNS
 WHERE TABLE_SCHEMA=@schema_name AND TABLE_NAME='document_templates' AND COLUMN_NAME='subject'
);
SET @sql = IF(@column_exists=0,
 'ALTER TABLE `document_templates` ADD COLUMN `subject` VARCHAR(190) NULL AFTER `name`',
 'SELECT 1');
PREPARE v020_stmt FROM @sql;
EXECUTE v020_stmt;
DEALLOCATE PREPARE v020_stmt;