Attachment #93570 for bug #23049

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

Lines 85-90 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (+6 lines)
85	}	85	}
86	);	86	);
87		87
		88	$dbh->do(
		89	qq{
		90	ALTER TABLE accountlines ADD CONSTRAINT `accountlines_check_type` CHECK (accounttype IS NOT NULL OR debit_type IS NOT NULL)
		91	}
		92	);
		93
88	# Add new permission	94	# Add new permission
89	$dbh->do(	95	$dbh->do(
90	q{	96	q{

Lines 2677-2682 CREATE TABLE `accountlines` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
2677	KEY `itemnumber` (`itemnumber`),	2677	KEY `itemnumber` (`itemnumber`),
2678	KEY `branchcode` (`branchcode`),	2678	KEY `branchcode` (`branchcode`),
2679	KEY `manager_id` (`manager_id`),	2679	KEY `manager_id` (`manager_id`),
		2680	CONSTRAINT `accountlines_check_type` CHECK (accounttype IS NOT NULL OR debit_type IS NOT NULL),
2680	CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,	2681	CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2681	CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,	2682	CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2682	CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,	2683	CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2683	-

Return to bug 23049