Bugzilla – Attachment 147665 Details for
Bug 31212
Datelastseen should be a datetime
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 31212: Add Database update
Bug-31212-Add-Database-update.patch (text/plain), 1.36 KB, created by
Andrew Fuerste-Henry
on 2023-03-02 18:07:24 UTC
(
hide
)
Description:
Bug 31212: Add Database update
Filename:
MIME Type:
Creator:
Andrew Fuerste-Henry
Created:
2023-03-02 18:07:24 UTC
Size:
1.36 KB
patch
obsolete
>From e4baa0861545a3121c2b6a17ff9e3cb2263ed5e1 Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >Date: Fri, 19 Aug 2022 17:55:32 +0000 >Subject: [PATCH] Bug 31212: Add Database update > >Signed-off-by: Ann Flournoy <aflournoy@cityofkeller.com> > >Signed-off-by: David Nind <david@davidnind.com> >Signed-off-by: Andrew Fuerste-Henry <andrewfh@dubcolib.org> >--- > .../data/mysql/atomicupdate/bug_31212_dbrev.pl | 17 +++++++++++++++++ > 1 file changed, 17 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_31212_dbrev.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_31212_dbrev.pl b/installer/data/mysql/atomicupdate/bug_31212_dbrev.pl >new file mode 100755 >index 0000000000..40e790439a >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_31212_dbrev.pl >@@ -0,0 +1,17 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "31212", >+ description => "Update items.datelastseen and deleteditems.datelastseen to datetime data format", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ $dbh->do(q{ >+ ALTER TABLE `items` MODIFY COLUMN `datelastseen` DATETIME DEFAULT NULL >+ }); >+ $dbh->do(q{ >+ ALTER TABLE `deleteditems` MODIFY COLUMN `datelastseen` DATETIME DEFAULT NULL >+ }); >+ say $out "items and deleteditems table updated"; >+ }, >+}; >-- >2.30.2
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 31212
:
138053
|
139510
|
142262
|
142263
|
142264
|
142282
|
142283
|
142284
|
142286
|
142287
|
142288
|
143595
|
146369
|
146370
|
146371
|
146372
|
147664
|
147665
|
147666
|
147667
|
148939
|
150378
|
150379
|
150380
|
150381
|
150382
|
150383
|
151189
|
151190
|
151194