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

(-)a/Koha/Schema/Result/Display.pm (-3 / +3 lines)
Lines 205-211 __PACKAGE__->belongs_to( Link Here
205
  {
205
  {
206
    is_deferrable => 1,
206
    is_deferrable => 1,
207
    join_type     => "LEFT",
207
    join_type     => "LEFT",
208
    on_delete     => "CASCADE",
208
    on_delete     => "SET NULL",
209
    on_update     => "CASCADE",
209
    on_update     => "CASCADE",
210
  },
210
  },
211
);
211
);
Lines 225-231 __PACKAGE__->belongs_to( Link Here
225
  {
225
  {
226
    is_deferrable => 1,
226
    is_deferrable => 1,
227
    join_type     => "LEFT",
227
    join_type     => "LEFT",
228
    on_delete     => "CASCADE",
228
    on_delete     => "SET NULL",
229
    on_update     => "CASCADE",
229
    on_update     => "CASCADE",
230
  },
230
  },
231
);
231
);
Lines 260-266 __PACKAGE__->belongs_to( Link Here
260
  {
260
  {
261
    is_deferrable => 1,
261
    is_deferrable => 1,
262
    join_type     => "LEFT",
262
    join_type     => "LEFT",
263
    on_delete     => "CASCADE",
263
    on_delete     => "SET NULL",
264
    on_update     => "CASCADE",
264
    on_update     => "CASCADE",
265
  },
265
  },
266
);
266
);
(-)a/installer/data/mysql/atomicupdate/bug_14962-temporary_shelves.pl (-3 / +3 lines)
Lines 30-38 return { Link Here
30
                    KEY `display_branch` (`display_branch`),
30
                    KEY `display_branch` (`display_branch`),
31
                    KEY `display_holding_branch` (`display_holding_branch`),
31
                    KEY `display_holding_branch` (`display_holding_branch`),
32
                    KEY `display_itype` (`display_itype`),
32
                    KEY `display_itype` (`display_itype`),
33
                    CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
33
                    CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
34
                    CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
34
                    CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
35
                    CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
35
                    CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE CASCADE
36
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
36
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
37
            }
37
            }
38
            );
38
            );
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 2912-2920 CREATE TABLE `displays` ( Link Here
2912
  KEY `display_branch` (`display_branch`),
2912
  KEY `display_branch` (`display_branch`),
2913
  KEY `display_holding_branch` (`display_holding_branch`),
2913
  KEY `display_holding_branch` (`display_holding_branch`),
2914
  KEY `display_itype` (`display_itype`),
2914
  KEY `display_itype` (`display_itype`),
2915
  CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2915
  CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
2916
  CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2916
  CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
2917
  CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
2917
  CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE CASCADE
2918
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2918
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2919
/*!40101 SET character_set_client = @saved_cs_client */;
2919
/*!40101 SET character_set_client = @saved_cs_client */;
2920
2920
2921
- 

Return to bug 14962