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

(-)a/C4/Auth_with_ldap.pm (+1 lines)
Lines 478-483 C4::Auth - Authenticates Koha users Link Here
478
		| contactfirstname    | text         | YES  |     | NULL    |                |
478
		| contactfirstname    | text         | YES  |     | NULL    |                |
479
		| contacttitle        | text         | YES  |     | NULL    |                |
479
		| contacttitle        | text         | YES  |     | NULL    |                |
480
		| borrowernotes       | mediumtext   | YES  |     | NULL    |                |
480
		| borrowernotes       | mediumtext   | YES  |     | NULL    |                |
481
		| relationship        | varchar(100) | YES  |     | NULL    |                |
481
		| ethnicity           | varchar(50)  | YES  |     | NULL    |                |
482
		| ethnicity           | varchar(50)  | YES  |     | NULL    |                |
482
		| ethnotes            | varchar(255) | YES  |     | NULL    |                |
483
		| ethnotes            | varchar(255) | YES  |     | NULL    |                |
483
		| sex                 | varchar(1)   | YES  |     | NULL    |                |
484
		| sex                 | varchar(1)   | YES  |     | NULL    |                |
(-)a/C4/SIP/ILS/Patron.pm (+1 lines)
Lines 690-695 __END__ Link Here
690
| contactfirstname    | text         | YES  |     | NULL    |                |
690
| contactfirstname    | text         | YES  |     | NULL    |                |
691
| contacttitle        | text         | YES  |     | NULL    |                |
691
| contacttitle        | text         | YES  |     | NULL    |                |
692
| borrowernotes       | mediumtext   | YES  |     | NULL    |                |
692
| borrowernotes       | mediumtext   | YES  |     | NULL    |                |
693
| relationship        | varchar(100) | YES  |     | NULL    |                |
693
| ethnicity           | varchar(50)  | YES  |     | NULL    |                |
694
| ethnicity           | varchar(50)  | YES  |     | NULL    |                |
694
| ethnotes            | varchar(255) | YES  |     | NULL    |                |
695
| ethnotes            | varchar(255) | YES  |     | NULL    |                |
695
| sex                 | varchar(1)   | YES  |     | NULL    |                |
696
| sex                 | varchar(1)   | YES  |     | NULL    |                |
(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 1283-1288 CREATE TABLE `borrower_modifications` ( Link Here
1283
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1283
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1284
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1284
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1285
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1285
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1286
  `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1286
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1287
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1287
  `password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1288
  `password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1288
  `flags` int(11) DEFAULT NULL,
1289
  `flags` int(11) DEFAULT NULL,
Lines 1399-1404 CREATE TABLE `borrowers` ( Link Here
1399
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
1400
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
1400
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
1401
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
1401
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
1402
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
1403
  `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor',
1402
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender',
1404
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender',
1403
  `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password',
1405
  `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password',
1404
  `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
1406
  `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
Lines 2401-2406 CREATE TABLE `deletedborrowers` ( Link Here
2401
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
2403
  `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
2402
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
2404
  `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
2403
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
2405
  `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
2406
  `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor',
2404
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender',
2407
  `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender',
2405
  `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password',
2408
  `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password',
2406
  `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
2409
  `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
2407
- 

Return to bug 28490