@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_14849.sql | 2 ++ installer/data/mysql/kohastructure.sql | 3 ++- 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14849.sql --- a/installer/data/mysql/atomicupdate/bug_14849.sql +++ a/installer/data/mysql/atomicupdate/bug_14849.sql @@ -0,0 +1,2 @@ +UPDATE uploaded_files LEFT JOIN borrowers on uploaded_files.owner=borrowers.borrowernumber SET owner=NULL WHERE borrowers.borrowernumber IS NULL; +ALTER TABLE uploaded_files ADD FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3372,7 +3372,8 @@ CREATE TABLE uploaded_files ( owner int(11), public tinyint, permanent tinyint, - PRIMARY KEY (id) + PRIMARY KEY (id), + CONSTRAINT `uploaded_files_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --