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

(-)a/installer/data/mysql/atomicupdate/bug_32729.pl (+14 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "32729",
5
    description => "Drop constraint to items.itemnumber from old_issues-table",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{ALTER TABLE old_issues DROP CONSTRAINT IF EXISTS old_issues_ibfk_2;});
11
12
        say $out "Dropped constraint old_issues_ibfk_2 from old_issues";
13
    },
14
};
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 4867-4873 CREATE TABLE `old_issues` ( Link Here
4867
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
4867
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
4868
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4868
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4869
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
4869
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
4870
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
4871
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
4870
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
4872
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4871
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4873
/*!40101 SET character_set_client = @saved_cs_client */;
4872
/*!40101 SET character_set_client = @saved_cs_client */;
4874
- 

Return to bug 32729