From b77bf37a46b2592890eb345fdca18dd8e2f5e379 Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
Date: Mon, 13 Jan 2020 11:41:21 -0300
Subject: [PATCH] Bug 22987: Add biblioimages.timestamp

This patch adds the timestamp column to the biblioimages table.
To test:
1. Apply this patch
2. Run:
   $ updatedatabase
   $ koha-mysql kohadev
   > SHOW CREATE TABLE biblioimages;
=> SUCCESS: Notice the new column is there with the right settings
3. Sign off :-D
---
 installer/data/mysql/atomicupdate/bug_22987.perl | 11 +++++++++++
 installer/data/mysql/kohastructure.sql           |  1 +
 2 files changed, 12 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_22987.perl

diff --git a/installer/data/mysql/atomicupdate/bug_22987.perl b/installer/data/mysql/atomicupdate/bug_22987.perl
new file mode 100644
index 0000000000..85ec28c511
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_22987.perl
@@ -0,0 +1,11 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do(q{
+        ALTER TABLE biblioimages
+            ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+                AFTER `thumbnail`;
+    });
+
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 22987 - Add biblioimages.timestamp)\n";
+}
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index c702d405a0..2517987fb7 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3305,6 +3305,7 @@ CREATE TABLE `biblioimages` ( -- local cover images
  `mimetype` varchar(15) NOT NULL, -- image type
  `imagefile` mediumblob NOT NULL, -- image file contents
  `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
+ `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- image creation/update time
  PRIMARY KEY (`imagenumber`),
  CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- 
2.24.1