Attachment 115073 Details for Bug 26947 – Bug 26947: Remove AUTO_INCREMENT

[patch] Bug 26947: Remove AUTO_INCREMENT

Bug-26947-Remove-AUTOINCREMENT.patch (text/plain), 18.47 KB, created by Jonathan Druart on 2021-01-12 11:31:10 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-01-12 11:31:10 UTC

Size: 18.47 KB

patch

obsolete

>From d8a99783a9c5715546ee9d82252ba5443071b604 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Tue, 12 Jan 2021 12:29:25 +0100
>Subject: [PATCH] Bug 26947: Remove AUTO_INCREMENT
>
>Sending a cake there
>https://bugs.mysql.com/bug.php?id=20786
>---
> debian/scripts/koha-dump               |  2 +-
> installer/data/mysql/kohastructure.sql | 74 +++++++++++++-------------
> 2 files changed, 38 insertions(+), 38 deletions(-)
>
>diff --git a/debian/scripts/koha-dump b/debian/scripts/koha-dump
>index d1d5742c58..b7a6061c65 100755
>--- a/debian/scripts/koha-dump
>+++ b/debian/scripts/koha-dump
>@@ -79,7 +79,7 @@ dump_instance()
>         schemadump="$backupdir/$name-schema-$date.sql"
>         [ "$quiet" = "no" ] && echo "* schema to $schemadump"
>         mysqldump $dbflag -d --host="$mysqlhost" \
>-            --user="$mysqluser" --password="$mysqlpass" "$mysqldb" > "$schemadump"
>+            --user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump"
>         chown "root:$name-koha" "$schemadump"
>         chmod g+r "$schemadump"
>     else
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index f0af11b314..952cd9d296 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -193,7 +193,7 @@ CREATE TABLE `action_logs` (
>   KEY `object_idx` (`object`),
>   KEY `info_idx` (`info`(255)),
>   KEY `interface` (`interface`)
>-) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -325,7 +325,7 @@ CREATE TABLE `aqbasket` (
>   CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
>   CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
>   CONSTRAINT `aqbasket_ibfk_4` FOREIGN KEY (`branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -402,7 +402,7 @@ CREATE TABLE `aqbooksellers` (
>   KEY `name` (`name`(255)),
>   CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
>   CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -440,7 +440,7 @@ CREATE TABLE `aqbudgetperiods` (
>   `sort1_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'statistical category for this budget',
>   `sort2_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'second statistical category for this budget',
>   PRIMARY KEY (`budget_period_id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -473,7 +473,7 @@ CREATE TABLE `aqbudgets` (
>   KEY `budget_period_id` (`budget_period_id`),
>   KEY `budget_owner_id` (`budget_owner_id`),
>   CONSTRAINT `aqbudgetperiods_ibfk_1` FOREIGN KEY (`budget_period_id`) REFERENCES `aqbudgetperiods` (`budget_period_id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -794,7 +794,7 @@ CREATE TABLE `audio_alerts` (
>   `sound` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
>   PRIMARY KEY (`id`),
>   KEY `precedence` (`precedence`)
>-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -816,7 +816,7 @@ CREATE TABLE `auth_header` (
>   `marcxml` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
>   PRIMARY KEY (`authid`),
>   KEY `origincode` (`origincode`)
>-) ENGINE=InnoDB AUTO_INCREMENT=1708 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -920,7 +920,7 @@ CREATE TABLE `authorised_values` (
>   KEY `lib` (`lib`(191)),
>   KEY `auth_value_idx` (`authorised_value`),
>   CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -988,7 +988,7 @@ CREATE TABLE `biblio` (
>   `abstract` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)',
>   PRIMARY KEY (`biblionumber`),
>   KEY `blbnoidx` (`biblionumber`)
>-) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -1023,7 +1023,7 @@ CREATE TABLE `biblio_metadata` (
>   UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),
>   KEY `timestamp` (`timestamp`),
>   CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -1076,7 +1076,7 @@ CREATE TABLE `biblioitems` (
>   KEY `publishercode` (`publishercode`(191)),
>   KEY `timestamp` (`timestamp`),
>   CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -1442,7 +1442,7 @@ CREATE TABLE `borrowers` (
>   CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
>   CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
>   CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -1673,7 +1673,7 @@ CREATE TABLE `circulation_rules` (
>   CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
>   CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,
>   CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -2098,7 +2098,7 @@ CREATE TABLE `courses` (
>   `enabled` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'determines whether the course is active',
>   `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
>   PRIMARY KEY (`course_id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -2190,7 +2190,7 @@ CREATE TABLE `creator_layouts` (
>   `layout_xml` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
>   `creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels',
>   PRIMARY KEY (`layout_id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -2221,7 +2221,7 @@ CREATE TABLE `creator_templates` (
>   `creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels',
>   PRIMARY KEY (`template_id`),
>   KEY `template_profile_fk_constraint` (`profile_id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -2604,7 +2604,7 @@ CREATE TABLE `export_format` (
>   PRIMARY KEY (`export_format_id`),
>   KEY `used_for_idx` (`used_for`(191)),
>   KEY `staff_only_idx` (`staff_only`)
>-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3062,7 +3062,7 @@ CREATE TABLE `items` (
>   CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
>   CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
>   CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=973 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3184,7 +3184,7 @@ CREATE TABLE `language_descriptions` (
>   PRIMARY KEY (`id`),
>   KEY `lang` (`lang`),
>   KEY `subtag_type_lang` (`subtag`,`type`,`lang`)
>-) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3200,7 +3200,7 @@ CREATE TABLE `language_rfc4646_to_iso639` (
>   `id` int(11) NOT NULL AUTO_INCREMENT,
>   PRIMARY KEY (`id`),
>   KEY `rfc4646_subtag` (`rfc4646_subtag`)
>-) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3246,7 +3246,7 @@ CREATE TABLE `language_subtag_registry` (
>   `id` int(11) NOT NULL AUTO_INCREMENT,
>   PRIMARY KEY (`id`),
>   KEY `subtag` (`subtag`)
>-) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3376,7 +3376,7 @@ CREATE TABLE `marc_matchers` (
>   PRIMARY KEY (`matcher_id`),
>   KEY `code` (`code`),
>   KEY `record_type` (`record_type`)
>-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3410,7 +3410,7 @@ CREATE TABLE `marc_modification_template_actions` (
>   PRIMARY KEY (`mmta_id`),
>   KEY `mmta_ibfk_1` (`template_id`),
>   CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3424,7 +3424,7 @@ CREATE TABLE `marc_modification_templates` (
>   `template_id` int(11) NOT NULL AUTO_INCREMENT,
>   `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
>   PRIMARY KEY (`template_id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3558,7 +3558,7 @@ CREATE TABLE `matchpoint_components` (
>   PRIMARY KEY (`matchpoint_component_id`),
>   KEY `by_sequence` (`matchpoint_id`,`sequence`),
>   CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3576,7 +3576,7 @@ CREATE TABLE `matchpoints` (
>   PRIMARY KEY (`matchpoint_id`),
>   KEY `matchpoints_ifbk_1` (`matcher_id`),
>   CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3592,7 +3592,7 @@ CREATE TABLE `message_attributes` (
>   `takes_days` tinyint(1) NOT NULL DEFAULT 0,
>   PRIMARY KEY (`message_attribute_id`),
>   UNIQUE KEY `message_name` (`message_name`)
>-) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -3910,7 +3910,7 @@ CREATE TABLE `opac_news` (
>   KEY `opac_news_branchcode_ibfk` (`branchcode`),
>   CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
>   CONSTRAINT `opac_news_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4115,7 +4115,7 @@ CREATE TABLE `printers_profile` (
>   `creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels',
>   PRIMARY KEY (`profile_id`),
>   UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
>-) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4219,7 +4219,7 @@ CREATE TABLE `quotes` (
>   `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'text of the quote',
>   `timestamp` datetime DEFAULT NULL COMMENT 'date and time that the quote last appeared in the opac',
>   PRIMARY KEY (`id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4259,7 +4259,7 @@ CREATE TABLE `repeatable_holidays` (
>   PRIMARY KEY (`id`),
>   KEY `repeatable_holidays_ibfk_1` (`branchcode`),
>   CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4452,7 +4452,7 @@ CREATE TABLE `search_field` (
>   `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
>   PRIMARY KEY (`id`),
>   UNIQUE KEY `name` (`name`(191))
>-) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4492,7 +4492,7 @@ CREATE TABLE `search_marc_map` (
>   PRIMARY KEY (`id`),
>   UNIQUE KEY `index_name` (`index_name`,`marc_field`(191),`marc_type`),
>   KEY `index_name_2` (`index_name`)
>-) ENGINE=InnoDB AUTO_INCREMENT=611 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4818,7 +4818,7 @@ CREATE TABLE `subscription_frequencies` (
>   `unitsperissue` int(11) NOT NULL DEFAULT 1,
>   `issuesperunit` int(11) NOT NULL DEFAULT 1,
>   PRIMARY KEY (`id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -4853,7 +4853,7 @@ CREATE TABLE `subscription_numberpatterns` (
>   `setto3` int(11) DEFAULT NULL,
>   `numbering3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   PRIMARY KEY (`id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -5300,7 +5300,7 @@ CREATE TABLE `z3950servers` (
>   `add_xslt` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'zero or more paths to XSLT files to be processed on the search results',
>   `attributes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'additional attributes passed to PQF queries',
>   PRIMARY KEY (`id`)
>-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
>@@ -5331,4 +5331,4 @@ CREATE TABLE `zebraqueue` (
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
> 
>--- Dump completed on 2020-12-04 14:35:26
>+-- Dump completed on 2021-01-12 11:28:48
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 26947: 113603 | 113794 | 113799 | 113800 | 113802 | 113803 | 113804 | 113805 | 113989 | 114021 | 114022 | 114023 | 114024 | 114025 | 114195 | 114196 | 114197 | 114198 | 114199 | 114201 | 115065 | 115066 | 115067 | 115068 | 115069 | 115070 | 115073