[Koha-bugs] [Bug 3206] OAI repositry deleted record support

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3206

--- Comment #9 from Matthias Meusburger <matthias.meusburger at biblibre.com> ---
(In reply to Frédéric Demians from comment #7)
> Adding a new syspref, you're supposed to add it also to sysprefs.sql file.

Added ! 

> 
> I don't understand this in your patch:
> 
> diff --git a/installer/data/mysql/kohastructure.sql
> b/installer/data/mysql/kohastructure.sql
> index c41710c..5fd5612 100644
> --- a/installer/data/mysql/kohastructure.sql
> +++ b/installer/data/mysql/kohastructure.sql
> @@ -1609,7 +1609,6 @@ CREATE TABLE `oai_sets_biblios` (
>    `biblionumber` int(11) NOT NULL,
>    `set_id` int(11) NOT NULL,
>    PRIMARY KEY (`biblionumber`, `set_id`),
> -  CONSTRAINT `oai_sets_biblios_ibfk_1` FOREIGN KEY (`biblionumber`)
> REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>    CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES
> `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

This is required to be able to display deleted records in a set.
With the constraint, when a record is deleted, its biblionumber is
automatically deleted from the oai_sets_biblio, and thus removed from the set.

-- 
You are receiving this mail because:
You are watching all bug changes.