Bug 32030: Unique - DB
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 20 Jul 2022 09:03:35 +0000 (11:03 +0200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 8 Nov 2022 12:44:17 +0000 (09:44 -0300)
commit21610ec5f4310834637a91384a9763d137a9d851
treee7aa427fad54b62c06c54ba3a3dbbe72c5a40f57
parent372516b37e3f1148065d580245c989891039f9a8
Bug 32030: Unique - DB

alter table erm_agreement_licenses add unique key `erm_agreement_licenses_uniq` (`agreement_id`, `license_id`);
alter table erm_eholdings_packages_agreements add unique key `erm_eholdings_packages_agreements_uniq` (`package_id`, `agreement_id`);
alter table erm_eholdings_resources add UNIQUE KEY `erm_eholdings_resources_uniq` (`title_id`, `package_id`);

Signed-off-by: Jonathan Field <jonathan.field@ptfs-europe.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/erm.pl
installer/data/mysql/kohastructure.sql