Attachment #135147 for bug #21978

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




use Modern::Perl;

return {
    bug_number => "21978",
    description => "Add middle_name to borrowers table",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        if( !column_exists( 'borrowers', 'middle_name' ) ) {
            $dbh->do(q{
                ALTER TABLE borrowers
                ADD COLUMN middle_name longtext NULL DEFAULT NULL
                COMMENT "patron/borrower's middle name"
                AFTER firstname
            });
            say $out "Added middle name column to borrowers table";
        }
        if( !column_exists( 'deletedborrowers', 'middle_name' ) ) {
            $dbh->do(q{
                ALTER TABLE deletedborrowers
                ADD COLUMN middle_name longtext NULL DEFAULT NULL
                COMMENT "patron/borrower's middle name"
                AFTER firstname
            });
            say $out "Added middle name column to deletedborrowers table";
        }
        if( !column_exists( 'borrower_modifications', 'middle_name' ) ) {
            $dbh->do(q{
                ALTER TABLE borrower_modifications
                ADD COLUMN middle_name longtext NULL DEFAULT NULL
                COMMENT "patron/borrower's middle name"
                AFTER firstname
            });
            say $out "Added middle name column to borrower_modifications table";
        }
        my @default_patron_search_fields = split(',',C4::Context->preference('DefaultPatronSearchFields'));
        unless( grep /middle_name/, @default_patron_search_fields ){
            if( grep /firstname/, @default_patron_search_fields ){
                push @default_patron_search_fields,'middle_name';
                C4::Context->set_preference('DefaultPatronSearchFields', join(',',@default_patron_search_fields) );
                say $out "Added middle name to DefaultPatronSearchFields";
            } else {
                say $out "Please add 'middlename' to DefaultPatronSearchFields if you want it searched by default";
            }
        }
    },
}




  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
  `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',

  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
  `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
- 

Return to bug 21978

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_21978.pl (+47 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "21978",
	5	description => "Add middle_name to borrowers table",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	if( !column_exists( 'borrowers', 'middle_name' ) ) {
	10	$dbh->do(q{
	11	ALTER TABLE borrowers
	12	ADD COLUMN middle_name longtext NULL DEFAULT NULL
	13	COMMENT "patron/borrower's middle name"
	14	AFTER firstname
	15	});
	16	say $out "Added middle name column to borrowers table";
	17	}
	18	if( !column_exists( 'deletedborrowers', 'middle_name' ) ) {
	19	$dbh->do(q{
	20	ALTER TABLE deletedborrowers
	21	ADD COLUMN middle_name longtext NULL DEFAULT NULL
	22	COMMENT "patron/borrower's middle name"
	23	AFTER firstname
	24	});
	25	say $out "Added middle name column to deletedborrowers table";
	26	}
	27	if( !column_exists( 'borrower_modifications', 'middle_name' ) ) {
	28	$dbh->do(q{
	29	ALTER TABLE borrower_modifications
	30	ADD COLUMN middle_name longtext NULL DEFAULT NULL
	31	COMMENT "patron/borrower's middle name"
	32	AFTER firstname
	33	});
	34	say $out "Added middle name column to borrower_modifications table";
	35	}
	36	my @default_patron_search_fields = split(',',C4::Context->preference('DefaultPatronSearchFields'));
	37	unless( grep /middle_name/, @default_patron_search_fields ){
	38	if( grep /firstname/, @default_patron_search_fields ){
	39	push @default_patron_search_fields,'middle_name';
	40	C4::Context->set_preference('DefaultPatronSearchFields', join(',',@default_patron_search_fields) );
	41	say $out "Added middle name to DefaultPatronSearchFields";
	42	} else {
	43	say $out "Please add 'middlename' to DefaultPatronSearchFields if you want it searched by default";
	44	}
	45	}
	46	},
	47	}

Lines 1271-1276 CREATE TABLE `borrower_modifications` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
1271	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1271	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1272	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1272	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1273	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1273	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
		1274	`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
1274	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1275	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1275	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1276	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1276	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	1277	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
Lines 1389-1394 CREATE TABLE `borrowers` ( Link Here
1389	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',	1390	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
1390	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',	1391	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
1391	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',	1392	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
		1393	`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
1392	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',	1394	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
1393	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',	1395	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
1394	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',	1396	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
Lines 2401-2406 CREATE TABLE `deletedborrowers` ( Link Here
2401	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',	2403	`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
2402	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',	2404	`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
2403	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',	2405	`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
		2406	`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',
2404	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',	2407	`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
2405	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',	2408	`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
2406	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',	2409	`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
2407	-