Attachment #93568 for bug #23049

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





    $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
        }
    );

    $dbh->do(
        qq{
            INSERT IGNORE INTO account_debit_types (
              code,
              description,




) 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;

--
-- Table structure for table `accountlines`
--

- 

Return to bug 23049

Lines 2635-2640 CREATE TABLE `account_debit_types` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +12 lines)
2635	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	2635	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2636		2636
2637	--	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
		2649	--
2638	-- Table structure for table `accountlines`	2650	-- Table structure for table `accountlines`
2639	--	2651	--
2640		2652
2641	-

Lines 15-20 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (+11 lines)
15		15
16	$dbh->do(	16	$dbh->do(
17	qq{	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
		27	$dbh->do(
		28	qq{
18	INSERT IGNORE INTO account_debit_types (	29	INSERT IGNORE INTO account_debit_types (
19	code,	30	code,
20	description,	31	description,