Bugzilla – Attachment 174973 Details for
Bug 37592
Add a record of creation and modification to bookings
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 37592: (follow-up) Fix comments in db_rev
Bug-37592-follow-up-Fix-comments-in-dbrev.patch (text/plain), 1.61 KB, created by
Jonathan Druart
on 2024-11-25 13:23:41 UTC
(
hide
)
Description:
Bug 37592: (follow-up) Fix comments in db_rev
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2024-11-25 13:23:41 UTC
Size:
1.61 KB
patch
obsolete
>From ace4c4e31de7aeac5be416395c069f030fb86515 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 25 Nov 2024 14:15:21 +0100 >Subject: [PATCH] Bug 37592: (follow-up) Fix comments in db_rev > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > installer/data/mysql/db_revs/240600029.pl | 4 ++-- > 1 file changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/db_revs/240600029.pl b/installer/data/mysql/db_revs/240600029.pl >index 9fa86ba00b4..3dd3438afea 100644 >--- a/installer/data/mysql/db_revs/240600029.pl >+++ b/installer/data/mysql/db_revs/240600029.pl >@@ -25,10 +25,10 @@ return { > } > > my $creation_date_statement = <<~'SQL'; >- ALTER TABLE bookings ADD COLUMN creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT 'the datetime for when a bookings was created' >+ ALTER TABLE bookings ADD COLUMN creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT 'the timestamp for when a booking was created' > SQL > my $modification_date_statement = <<~'SQL'; >- ALTER TABLE bookings ADD COLUMN modification_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'the datetime for when a booking has been updated' >+ ALTER TABLE bookings ADD COLUMN modification_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'the timestamp for when a booking has been updated' > SQL > if ( @{$existing_columns} == 0 ) { > $dbh->do("$creation_date_statement AFTER `end_date`"); >-- >2.34.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 37592
:
170144
|
170161
|
170763
|
171254
|
171376
|
171377
|
171378
|
171524
|
171645
|
174968
|
174969
|
174970
|
174971
|
174972
| 174973