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

(-)a/installer/data/mysql/atomicupdate/bug_19166.perl (-1 / +1 lines)
Lines 13-19 if( CheckVersion( $DBversion ) ) { Link Here
13 
            PRIMARY KEY (adjustment_id),
 13 
            PRIMARY KEY (adjustment_id),
14 
            CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
 14 
            CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
15 
            CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
 15 
            CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
16 
        )
 16 
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
17 
        " );
 17 
        " );
18 
    $dbh->do("INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('ADJ_REASON')");
 18 
    $dbh->do("INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('ADJ_REASON')");
19 
    SetVersion( $DBversion );
 19 
    SetVersion( $DBversion );
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 840-846 CREATE TABLE IF NOT EXISTS invoice_adjustments ( Link Here
840 
    PRIMARY KEY (adjustment_id),
 840 
    PRIMARY KEY (adjustment_id),
841 
    CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
 841 
    CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
842 
    CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
 842 
    CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
843 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 843 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
844 

          844
          

        

        

          845
          
--

          845
          
--

        

        

          846
          
-- Table structure for table `issuingrules`

          846
          
-- Table structure for table `issuingrules`

        

            

              847
              
- 

              
              
            






  

  Return to bug 19166