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

(-)a/api/v1/swagger/definitions/patron.yaml (+5 lines)
Lines 9-14 properties: Link Here
9
    $ref: ../x-primitives.yaml#/surname
9
    $ref: ../x-primitives.yaml#/surname
10
  firstname:
10
  firstname:
11
    $ref: ../x-primitives.yaml#/firstname
11
    $ref: ../x-primitives.yaml#/firstname
12
  preferred_name:
13
    type:
14
      - string
15
      - "null"
16
    description: patron's preferred named
12
  title:
17
  title:
13
    type:
18
    type:
14
      - string
19
      - string
(-)a/installer/data/mysql/atomicupdate/bug_28633.pl (+47 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "28633",
5
    description => "Add preferred_name to borrowers table",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        if( !column_exists( 'borrowers', 'preferred_name' ) ) {
10
            $dbh->do(q{
11
                ALTER TABLE borrowers
12
                ADD COLUMN preferred_name longtext NULL DEFAULT NULL
13
                COMMENT "patron/borrower's preferred name"
14
                AFTER firstname
15
            });
16
            say $out "Added preferred name column to borrowers table";
17
        }
18
        if( !column_exists( 'deletedborrowers', 'preferred_name' ) ) {
19
            $dbh->do(q{
20
                ALTER TABLE deletedborrowers
21
                ADD COLUMN preferred_name longtext NULL DEFAULT NULL
22
                COMMENT "patron/borrower's preferred name"
23
                AFTER firstname
24
            });
25
            say $out "Added preferred name column to deletedborrowers table";
26
        }
27
        if( !column_exists( 'borrower_modifications', 'preferred_name' ) ) {
28
            $dbh->do(q{
29
                ALTER TABLE borrower_modifications
30
                ADD COLUMN preferred_name longtext NULL DEFAULT NULL
31
                COMMENT "patron/borrower's preferred name"
32
                AFTER firstname
33
            });
34
            say $out "Added preferred name column to borrower_modifications table";
35
        }
36
        my @default_patron_search_fields = split(',',C4::Context->preference('DefaultPatronSearchFields'));
37
        unless( grep /preferred_name/, @default_patron_search_fields ){
38
            if( grep /firstname/, @default_patron_search_fields ){
39
                push @default_patron_search_fields,'preferred_name';
40
                C4::Context->set_preference('DefaultPatronSearchFields', join(',',@default_patron_search_fields) );
41
                say $out "Added preferred name to DefaultPatronSearchFields";
42
            } else {
43
                say $out "Please add 'preferredname' to DefaultPatronSearchFields if you want it searched by default";
44
            }
45
        }
46
    },
47
}
(-)a/installer/data/mysql/kohastructure.sql (+3 lines)
Lines 1261-1266 CREATE TABLE `borrower_modifications` ( Link Here
1261
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1261
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1262
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1262
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1263
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1263
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1264
  `preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name',
1264
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1265
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1265
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1266
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1266
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1267
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
Lines 1379-1384 CREATE TABLE `borrowers` ( Link Here
1379
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
1380
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
1380
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
1381
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
1381
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
1382
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
1383
  `preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name',
1382
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
1384
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
1383
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
1385
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
1384
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
1386
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
Lines 2387-2392 CREATE TABLE `deletedborrowers` ( Link Here
2387
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
2389
  `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',
2388
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
2390
  `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',
2389
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
2391
  `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',
2392
  `preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name',
2390
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
2393
  `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',
2391
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
2394
  `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',
2392
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
2395
  `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',
(-)a/koha-tmpl/intranet-tmpl/prog/en/columns.def (-1 / +1 lines)
Lines 2-7 Link Here
2
<field name="borrowers.title">Salutation</field>
2
<field name="borrowers.title">Salutation</field>
3
<field name="borrowers.surname">Surname</field>
3
<field name="borrowers.surname">Surname</field>
4
<field name="borrowers.firstname">First name</field>
4
<field name="borrowers.firstname">First name</field>
5
<field name="borrowers.preferred_name">Preferred name</field>
5
<field name="borrowers.dateofbirth">Date of birth</field>
6
<field name="borrowers.dateofbirth">Date of birth</field>
6
<field name="borrowers.initials">Initials</field>
7
<field name="borrowers.initials">Initials</field>
7
<field name="borrowers.othernames">Other name</field>
8
<field name="borrowers.othernames">Other name</field>
8
- 

Return to bug 28633