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

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (+11 lines)
Lines 13-18 if ( CheckVersion($DBversion) ) { Link Here
13
          }
13
          }
14
    );
14
    );
15
15
16
    $dbh->do(
17
        qq{
18
            CREATE TABLE IF NOT EXISTS ac_debit_types_branches (
19
                debit_type_code VARCHAR(16),
20
                branchcode VARCHAR(10),
21
                FOREIGN KEY (debit_type_code) REFERENCES account_debit_types(code) ON DELETE CASCADE,
22
                FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
23
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
24
        }
25
    );
26
16
    $dbh->do(
27
    $dbh->do(
17
        qq{
28
        qq{
18
            INSERT IGNORE INTO account_debit_types (
29
            INSERT IGNORE INTO account_debit_types (
(-)a/installer/data/mysql/kohastructure.sql (-1 / +12 lines)
Lines 2634-2639 CREATE TABLE `account_debit_types` ( Link Here
2634
  PRIMARY KEY (`code`)
2634
  PRIMARY KEY (`code`)
2635
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2635
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2636
2636
2637
--
2638
-- Table structure for table `ac_debit_types_branches`
2639
--
2640
2641
DROP TABLE IF EXISTS `ac_debit_types_branches`;
2642
CREATE TABLE `ac_debit_types_branches` (
2643
    `debit_type_code` VARCHAR(16),
2644
    `branchcode` VARCHAR(10),
2645
    FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE CASCADE,
2646
    FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE
2647
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2648
2637
--
2649
--
2638
-- Table structure for table `accountlines`
2650
-- Table structure for table `accountlines`
2639
--
2651
--
2640
- 

Return to bug 23049