Attachment 165040 Details for Bug 30888 – Bug 30888: Db rev for new table deletedauth_header

[patch] Bug 30888: Db rev for new table deletedauth_header

Bug-30888-Db-rev-for-new-table-deletedauthheader.patch (text/plain), 3.27 KB, created by Marcel de Rooy on 2024-04-18 07:37:28 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2024-04-18 07:37:28 UTC

Size: 3.27 KB

patch

obsolete

>From 2f89c5e511a352f1ba6bdcda2f48cfd0f302fc3d Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 16 Apr 2024 13:44:23 +0000
>Subject: [PATCH] Bug 30888: Db rev for new table deletedauth_header
>Content-Type: text/plain; charset=utf-8
>
>In line with the other deleted tables. (See also bug 20271.)
>
>Note: Removed the auto_increment for this deleted table. There is
>no need for it and it could only mess up the table. Additionally,
>removed the index on origin.
>
>Test plan:
>Run updatedatabase.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> .../data/mysql/atomicupdate/bug_30888.pl      | 29 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        | 22 ++++++++++++++
> 2 files changed, 51 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_30888.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_30888.pl b/installer/data/mysql/atomicupdate/bug_30888.pl
>new file mode 100755
>index 0000000000..f3d7fcae62
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_30888.pl
>@@ -0,0 +1,29 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => 30888,
>+    description => "Add table deletedauth_header",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        if ( !TableExists('deletedauth_header') ) {
>+            $dbh->do(
>+                q|
>+CREATE TABLE `deletedauth_header` (
>+  `authid` bigint(20) unsigned NOT NULL,
>+  `authtypecode` varchar(10) NOT NULL DEFAULT '',
>+  `datecreated` date DEFAULT NULL,
>+  `modification_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
>+  `origincode` varchar(20) DEFAULT NULL,
>+  `authtrees` longtext DEFAULT NULL,
>+  `marc` blob DEFAULT NULL,
>+  `linkid` bigint(20) DEFAULT NULL,
>+  `marcxml` longtext NOT NULL,
>+  PRIMARY KEY (`authid`)
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;|
>+            );
>+            say $out "Added new table 'deletedauth_header'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index e463e8d2f4..2bd240a197 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2528,6 +2528,28 @@ CREATE TABLE `currency` (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>+--
>+-- Table structure for table `deletedauth_header`
>+--
>+
>+DROP TABLE IF EXISTS `deletedauth_header`;
>+/*!40101 SET @saved_cs_client     = @@character_set_client */;
>+/*!40101 SET character_set_client = utf8 */;
>+CREATE TABLE `deletedauth_header` (
>+  `authid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
>+  `authtypecode` varchar(10) NOT NULL DEFAULT '',
>+  `datecreated` date DEFAULT NULL,
>+  `modification_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
>+  `origincode` varchar(20) DEFAULT NULL,
>+  `authtrees` longtext DEFAULT NULL,
>+  `marc` blob DEFAULT NULL,
>+  `linkid` bigint(20) DEFAULT NULL,
>+  `marcxml` longtext NOT NULL,
>+  PRIMARY KEY (`authid`),
>+  KEY `origincode` (`origincode`)
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+/*!40101 SET character_set_client = @saved_cs_client */;
>+
> --
> -- Table structure for table `deletedbiblio`
> --
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 30888: 165040 | 165041 | 165042 | 165043 | 171850 | 171851 | 172090 | 172091 | 172092 | 172093 | 172094 | 172095 | 172096 | 172097 | 172098 | 172099 | 172549 | 172550 | 172551 | 172552 | 172553