@@ -, +, @@ kohastructure.sql $ reset_all $ koha-mysql kohadev > SHOW CREATE TABLE language_descriptions; --- Koha/Schema/Result/LanguageDescription.pm | 22 ++++++++++++++++++++-- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 21 insertions(+), 3 deletions(-) --- a/Koha/Schema/Result/LanguageDescription.pm +++ a/Koha/Schema/Result/LanguageDescription.pm @@ -80,9 +80,27 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); +=head1 UNIQUE CONSTRAINTS -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fQEN7ks3f7aLuoDQWqEv+Q +=head2 C + +=over 4 + +=item * L + +=item * L + +=item * L + +=back + +=cut + +__PACKAGE__->add_unique_constraint("subtag_type_lang", ["subtag", "type", "lang"]); + + +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-30 13:58:48 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:47kn6QYcK/PKIvsxwsUl0w # You can replace this text with custom content, and it will be preserved on regeneration --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3216,7 +3216,7 @@ CREATE TABLE `language_descriptions` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `lang` (`lang`), - KEY `subtag_type_lang` (`subtag`,`type`,`lang`) + UNIQUE KEY `subtag_type_lang` (`subtag`,`type`,`lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; --