[Koha-bugs] [Bug 30483] New: Should issues.borrowernumber and issues.itemnumber be NOT NULL ?

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

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

            Bug ID: 30483
           Summary: Should issues.borrowernumber and issues.itemnumber be
                    NOT NULL ?
 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

Sync problem between structure and dbrevs.
For old prod databases only (that passed the 3.05 dbrevs)
Note that I did not expect such a difference in a vital table like issues !

update     $DBversion = "3.05.00.009"; $dbh->do("ALTER TABLE issues MODIFY
COLUMN borrowernumber int(11) NOT NULL");     $dbh->do("ALTER TABLE issues
MODIFY COLUMN itemnumber int(11) NOT NULL");

Current structure allows them to be NULL.
I wonder if that is correct. An issue should have a borrower and an item,
right?

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