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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
Lines 4256-4265 DROP TABLE IF EXISTS `items_last_borrower`; Link Here
4256
CREATE TABLE `items_last_borrower` (
4256
CREATE TABLE `items_last_borrower` (
4257
  `id` int(11) NOT NULL AUTO_INCREMENT,
4257
  `id` int(11) NOT NULL AUTO_INCREMENT,
4258
  `itemnumber` int(11) NOT NULL,
4258
  `itemnumber` int(11) NOT NULL,
4259
  `borrowernumber` int(11) NULL,
4259
  `borrowernumber` int(11) DEFAULT NULL,
4260
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
4260
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
4261
  PRIMARY KEY (`id`),
4261
  PRIMARY KEY (`id`),
4262
  KEY `borrowernumber` (`borrowernumber`),
4262
  KEY `borrowernumber` (`borrowernumber`),
4263
  KEY `items_last_borrower_ibfk_1` (`itemnumber`),
4263
  CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4264
  CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4264
  CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
4265
  CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
4265
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4266
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4266
- 

Return to bug 23260