[Bug 31172] New: Shouldn't issues.issuedate have a DEFAULT NOW() and be NOT NULL?
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31172 Bug ID: 31172 Summary: Shouldn't issues.issuedate have a DEFAULT NOW() and be NOT NULL? Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org We are currently defaulting to dt_from_string in code, we could just set `NOT NULL DEFAULT NOW()` to get a more consistent behaviour couldn't we? I see this as a good starting place for moving C4::Circulation::AddIssue to Koha::Checkouts->store() eventually. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31172 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com, | |kyle@bywatersolutions.com, | |tomascohen@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31172 --- Comment #1 from Kyle M Hall <kyle@bywatersolutions.com> --- That seems totally reasonable to me now that we can set the database timezone to the Koha timezone! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31172 --- Comment #2 from Tomás Cohen Arazi <tomascohen@gmail.com> --- I like the idea, but we need to think of bad data and the upgrade process. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org