Bugzilla – Attachment 139510 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.20 KB, created by
Lucas Gass
on 2022-08-19 17:56:00 UTC
(
hide
)
Description:
Bug 31212: Add Database update
Filename:
MIME Type:
Creator:
Lucas Gass
Created:
2022-08-19 17:56:00 UTC
Size:
1.20 KB
patch
obsolete
>From f0780229d76b8b9f984e67f7332ec8d4ec5d1883 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 > >--- > .../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