@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_13534.sql | 6 ++++++ installer/data/mysql/kohastructure.sql | 6 +++--- 2 files changed, 9 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_13534.sql --- a/installer/data/mysql/atomicupdate/bug_13534.sql +++ a/installer/data/mysql/atomicupdate/bug_13534.sql @@ -0,0 +1,6 @@ +ALTER TABLE tags_all MODIFY COLUMN borrowernumber INT(11); +ALTER TABLE tags_all drop FOREIGN KEY tags_borrowers_fk_1; +ALTER TABLE tags_all ADD CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE; + +ALTER TABLE tags_approval DROP FOREIGN KEY tags_approval_borrowers_fk_1; +ALTER TABLE tags_approval ADD CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2242,7 +2242,7 @@ CREATE TABLE `tags` ( DROP TABLE IF EXISTS `tags_all`; CREATE TABLE `tags_all` ( -- all of the tags `tag_id` int(11) NOT NULL auto_increment, -- unique id and primary key - `borrowernumber` int(11) NOT NULL, -- the patron who added the tag (borrowers.borrowernumber) + `borrowernumber` int(11) DEFAULT NULL, -- the patron who added the tag (borrowers.borrowernumber) `biblionumber` int(11) NOT NULL, -- the bib record this tag was left on (biblio.biblionumber) `term` varchar(255) NOT NULL, -- the tag `language` int(4) default NULL, -- the language the tag was left in @@ -2251,7 +2251,7 @@ CREATE TABLE `tags_all` ( -- all of the tags KEY `tags_borrowers_fk_1` (`borrowernumber`), KEY `tags_biblionumber_fk_1` (`biblionumber`), CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`) - REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, + REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; @@ -2270,7 +2270,7 @@ CREATE TABLE `tags_approval` ( -- approved tags PRIMARY KEY (`term`), KEY `tags_approval_borrowers_fk_1` (`approved_by`), CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) - REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE + REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --