Attachment #23262 for bug #11249

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

Lines 271-276 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here

(-)a/installer/data/mysql/kohastructure.sql (+3 lines)
271	KEY `branchcode` (`branchcode`),	271	KEY `branchcode` (`branchcode`),
272	KEY `userid` (`userid`),	272	KEY `userid` (`userid`),
273	KEY `guarantorid` (`guarantorid`),	273	KEY `guarantorid` (`guarantorid`),
		274	KEY `surname_idx` (`surname`(255)),
		275	KEY `firstname_idx` (`firstname`(255)),
		276	KEY `othernames_idx` (`othernames`(255)),
274	CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),	277	CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
275	CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)	278	CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
276	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	279	) ENGINE=InnoDB DEFAULT CHARSET=utf8;




    SetVersion($DBversion);
}

$DBversion = "3.15.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        ALTER TABLE `borrowers`
        ADD KEY `surname_idx` (`surname`(255)),
        ADD KEY `firstname_idx` (`firstname`(255)),
        ADD KEY `othernames_idx` (`othernames`(255))
    });
    print "Upgrade to $DBversion done (Bug 11249 - Add db indexes on borrowers names)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 11249

Lines 7778-7783 if(CheckVersion($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
7778	SetVersion($DBversion);	7778	SetVersion($DBversion);
7779	}	7779	}
7780		7780
		7781	$DBversion = "3.15.00.XXX";
		7782	if(CheckVersion($DBversion)) {
		7783	$dbh->do(q{
		7784	ALTER TABLE `borrowers`
		7785	ADD KEY `surname_idx` (`surname`(255)),
		7786	ADD KEY `firstname_idx` (`firstname`(255)),
		7787	ADD KEY `othernames_idx` (`othernames`(255))
		7788	});
		7789	print "Upgrade to $DBversion done (Bug 11249 - Add db indexes on borrowers names)\n";
		7790	SetVersion($DBversion);
		7791	}
		7792
7781	=head1 FUNCTIONS	7793	=head1 FUNCTIONS
7782		7794
7783	=head2 TableExists($table)	7795	=head2 TableExists($table)
7784	-