Bug 20144: [sql_modes] Add default values for export_format columns

[koha.git] / installer / data / mysql / atomicupdate / bug_xxxxx_export_format_default.sql

ALTER TABLE export_format MODIFY csv_separator VARCHAR(2) NOT NULL DEFAULT ',', MODIFY field_separator VARCHAR(2), MODIFY subfield_separator VARCHAR(2);
ALTER TABLE export_format MODIFY encoding VARCHAR(255) DEFAULT 'utf8';