$dbh->do(

        qq{

            CREATE TABLE IF NOT EXISTS ac_debit_types_branches (

                debit_type_code VARCHAR(16),

                branchcode VARCHAR(10),

                FOREIGN KEY (debit_type_code) REFERENCES account_debit_types(code) ON DELETE CASCADE,

                FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE

            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

        }

    );

--

-- Table structure for table `ac_debit_types_branches`

--

DROP TABLE IF EXISTS `ac_debit_types_branches`;

CREATE TABLE `ac_debit_types_branches` (

    `debit_type_code` VARCHAR(16),

    `branchcode` VARCHAR(10),

    FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE CASCADE,

    FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;