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

(-)a/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl (-1 / +3 lines)
Lines 45-54 return { Link Here
45
                  `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id',
45
                  `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id',
46
                  `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id',
46
                  `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id',
47
                  `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber',
47
                  `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber',
48
                  `type` enum('ISSUE','RENEW') NOT NULL COMMENT 'The type of usage this is',
49
                  `creation_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the timestamp for when a usage was recorded',
48
                  PRIMARY KEY (`id`),
50
                  PRIMARY KEY (`id`),
49
                  KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`),
51
                  KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`),
50
51
                  KEY `patron_quota_usage_ibfk_2` (`patron_id`),
52
                  KEY `patron_quota_usage_ibfk_2` (`patron_id`),
53
                  KEY `patron_quota_usage_issue_id` (`issue_id`),
52
                  CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
54
                  CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
53
                  CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
55
                  CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
54
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
56
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 7147-7155 CREATE TABLE `patron_quota_usage` ( Link Here
7147
  `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id',
7147
  `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id',
7148
  `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id',
7148
  `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id',
7149
  `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber',
7149
  `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber',
7150
  `type` enum('ISSUE','RENEW') NOT NULL COMMENT 'The type of usage this is',
7151
  `creation_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the timestamp for when a usage was recorded',
7150
  PRIMARY KEY (`id`),
7152
  PRIMARY KEY (`id`),
7151
  KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`),
7153
  KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`),
7152
  KEY `patron_quota_usage_ibfk_2` (`patron_id`),
7154
  KEY `patron_quota_usage_ibfk_2` (`patron_id`),
7155
  KEY `patron_quota_usage_issue_id` (`issue_id`),
7153
  CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
7156
  CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
7154
  CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
7157
  CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
7155
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
7158
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
7156
- 

Return to bug 38924