View | Details | Raw Unified | Return to bug 14849
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_14849.sql (+2 lines)
Line 0 Link Here
1
UPDATE uploaded_files LEFT JOIN borrowers on uploaded_files.owner=borrowers.borrowernumber SET owner=NULL WHERE borrowers.borrowernumber IS NULL;
2
ALTER TABLE uploaded_files ADD FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 3372-3378 CREATE TABLE uploaded_files ( Link Here
3372
    owner int(11),
3372
    owner int(11),
3373
    public tinyint,
3373
    public tinyint,
3374
    permanent tinyint,
3374
    permanent tinyint,
3375
    PRIMARY KEY (id)
3375
    PRIMARY KEY (id),
3376
    CONSTRAINT `uploaded_files_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
3376
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3377
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3377
3378
3378
--
3379
--
3379
- 

Return to bug 14849