From 2c193825031bb19e4f186481a802b40adc604791 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>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 .../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.39.5