[Koha-bugs] [Bug 30572] New: Field search_marc_to_field.sort needs syncing too

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30572

            Bug ID: 30572
           Summary: Field search_marc_to_field.sort needs syncing too
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: m.de.rooy at rijksmuseum.nl
        QA Contact: testopia at bugs.koha-community.org

$DBversion = '20.11.03.003';
if( CheckVersion( $DBversion ) ) {
    $dbh->do( "UPDATE search_marc_to_field SET sort = 1 WHERE sort IS NULL" );
    $dbh->do( "ALTER TABLE search_marc_to_field MODIFY COLUMN sort tinyint(1)
DEFAULT 1 NOT NULL COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in
the index, 0 (no) will prevent this'" );

kohastructure:

CREATE TABLE `search_marc_to_field` (
  `sort` tinyint(1) DEFAULT NULL COMMENT 'true/false creates special sort
handling, null doesn''t',

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.