Bug 30483: Make issues.borrowernumber and itemnumber NOT NULL
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 7 Apr 2022 12:51:42 +0000 (12:51 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Mon, 31 Oct 2022 20:26:55 +0000 (20:26 +0000)
commitce7a85ad645cce000d79844c931f10c5498eb816
tree8fa88087c78310b521ca90d7a62d74049f77e77c
parent0c6eef3816c60f0645c8c3da4ea6e166dfc1b029
Bug 30483: Make issues.borrowernumber and itemnumber NOT NULL

Note: This change does NOT apply to old_issues, where constraints
may result in nullifying these columns.

Test plan:
Run dbrev.
Try checkout, checkin.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 1f44891fd835080133fa1a73634ced0e68b96892)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_30483.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql