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

(-)a/installer/data/mysql/atomicupdate/bug_30472.pl (+13 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => 30472,
5
    description => "borrower_relationships.guarantor_id NOT NULL",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
ALTER TABLE borrower_relationships CHANGE COLUMN guarantor_id guarantor_id int(11) NOT NULL
11
        });
12
    },
13
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1372-1378 DROP TABLE IF EXISTS `borrower_relationships`; Link Here
1372
/*!40101 SET character_set_client = utf8 */;
1372
/*!40101 SET character_set_client = utf8 */;
1373
CREATE TABLE `borrower_relationships` (
1373
CREATE TABLE `borrower_relationships` (
1374
  `id` int(11) NOT NULL AUTO_INCREMENT,
1374
  `id` int(11) NOT NULL AUTO_INCREMENT,
1375
  `guarantor_id` int(11) DEFAULT NULL,
1375
  `guarantor_id` int(11) NOT NULL,
1376
  `guarantee_id` int(11) NOT NULL,
1376
  `guarantee_id` int(11) NOT NULL,
1377
  `relationship` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1377
  `relationship` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1378
  PRIMARY KEY (`id`),
1378
  PRIMARY KEY (`id`),
1379
- 

Return to bug 30472