Attachment #13872 for bug #9207

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

Lines 896-902 CREATE TABLE `import_records` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
896	CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)	896	CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
897	REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,	897	REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
898	KEY `branchcode` (`branchcode`),	898	KEY `branchcode` (`branchcode`),
899	KEY `batch_sequence` (`import_batch_id`, `record_sequence`)	899	KEY `batch_sequence` (`import_batch_id`, `record_sequence`),
		900	KEY `batch_id__record_type` (`import_batch_id`,`record_type`)
900	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	901	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
901		902
902	--	903	--




    SetVersion($DBversion);
}

$DBversion = "3.11.00.XXX";
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
    $dbh->do(qq{
        ALTER TABLE  import_records ADD INDEX batch_id__record_type ( import_batch_id, record_type );
    });

    print "Upgrade to $DBversion done (Bug 9207: Add new index batch_id__record_type to import_records)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 9207

Lines 6114-6119 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
6114	SetVersion($DBversion);	6114	SetVersion($DBversion);
6115	}	6115	}
6116		6116
		6117	$DBversion = "3.11.00.XXX";
		6118	if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
		6119	$dbh->do(qq{
		6120	ALTER TABLE import_records ADD INDEX batch_id__record_type ( import_batch_id, record_type );
		6121	});
		6122
		6123	print "Upgrade to $DBversion done (Bug 9207: Add new index batch_id__record_type to import_records)\n";
		6124	SetVersion($DBversion);
		6125	}
		6126
6117	=head1 FUNCTIONS	6127	=head1 FUNCTIONS
6118		6128
6119	=head2 TableExists($table)	6129	=head2 TableExists($table)
6120	-