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

(-)a/installer/data/mysql/atomicupdate/bug_14570.perl (+1 lines)
Lines 10-15 if( CheckVersion( $DBversion ) ) { Link Here
10 
                  guarantee_id INT(11) NOT NULL,
 10 
                  guarantee_id INT(11) NOT NULL,
11 
                  relationship VARCHAR(100) NOT NULL,
 11 
                  relationship VARCHAR(100) NOT NULL,
12 
                  PRIMARY KEY (id),
 12 
                  PRIMARY KEY (id),
13 
                  UNIQUE KEY `guarantor_guarantee_idx` ( `guarantor_id`, `guarantee_id` ),
13 
                  CONSTRAINT r_guarantor FOREIGN KEY ( guarantor_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE,
 14 
                  CONSTRAINT r_guarantor FOREIGN KEY ( guarantor_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE,
14 
                  CONSTRAINT r_guarantee FOREIGN KEY ( guarantee_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
 15 
                  CONSTRAINT r_guarantee FOREIGN KEY ( guarantee_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
15 
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 16 
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4080-4085 CREATE TABLE `borrower_relationships` ( Link Here
4080 
      guarantee_id INT(11) NOT NULL,
 4080 
      guarantee_id INT(11) NOT NULL,
4081 
      relationship VARCHAR(100) NOT NULL,
 4081 
      relationship VARCHAR(100) NOT NULL,
4082 
      PRIMARY KEY (id),
 4082 
      PRIMARY KEY (id),
4083 
      UNIQUE KEY `guarantor_guarantee_idx` ( `guarantor_id`, `guarantee_id` ),
4083 
      CONSTRAINT r_guarantor FOREIGN KEY ( guarantor_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE,
 4084 
      CONSTRAINT r_guarantor FOREIGN KEY ( guarantor_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE,
4084 
      CONSTRAINT r_guarantee FOREIGN KEY ( guarantee_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
 4085 
      CONSTRAINT r_guarantee FOREIGN KEY ( guarantee_id ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
4085 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 4086 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4086 
-

Return to bug 14570