@@ -, +, @@
---
Koha/Schema/Result/LibraryGroup.pm | 18 ++++++++++++++++--
installer/data/mysql/atomicupdate/library_groups.sql | 3 ++-
installer/data/mysql/kohastructure.sql | 3 ++-
3 files changed, 20 insertions(+), 4 deletions(-)
--- a/Koha/Schema/Result/LibraryGroup.pm
+++ a/Koha/Schema/Result/LibraryGroup.pm
@@ -104,6 +104,20 @@ __PACKAGE__->add_columns(
__PACKAGE__->set_primary_key("id");
+=head1 UNIQUE CONSTRAINTS
+
+=head2 C
+
+=over 4
+
+=item * L
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("title", ["title"]);
+
=head1 RELATIONS
=head2 branchcode
@@ -162,8 +176,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-11-02 13:23:16
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aQJgATq8JW4hCBFZfYus7w
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-01 13:07:33
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K63IXlbjifZWzBnbvFIz0A
# You can replace this text with custom code or comments, and it will be preserved on regeneration
--- a/installer/data/mysql/atomicupdate/library_groups.sql
+++ a/installer/data/mysql/atomicupdate/library_groups.sql
@@ -8,5 +8,6 @@ CREATE TABLE library_groups (
updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
PRIMARY KEY id ( id ),
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
- FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
+ FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE,
+ UNIQUE( title )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--- a/installer/data/mysql/kohastructure.sql
+++ a/installer/data/mysql/kohastructure.sql
@@ -3970,7 +3970,8 @@ CREATE TABLE library_groups (
updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
PRIMARY KEY id ( id ),
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
- FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
+ FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE,
+ UNIQUE( title )
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--