@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_29605.pl | 3 +++ installer/data/mysql/db_revs/210600031.pl | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_29605.pl +++ a/installer/data/mysql/atomicupdate/bug_29605.pl @@ -59,6 +59,9 @@ return { ); say $out "Ensure additional_contents.lang is VARCHAR(50)"; + $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'}); + say $out "Ensure NOT NULL on search_marc_map.marc_type"; + }, } --- a/installer/data/mysql/db_revs/210600031.pl +++ a/installer/data/mysql/db_revs/210600031.pl @@ -7,6 +7,6 @@ return { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; $dbh->do(q{DELETE FROM search_marc_map WHERE marc_type='normarc'}); - $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') COMMENT 'what MARC type this map is for'}); + $dbh->do(q{ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'}); }, } --