[Koha-bugs] [Bug 26573] Limit patron attribute types to more than one patron category
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Nov 4 19:37:22 CET 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26573
Kyle M Hall <kyle at bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kyle at bywatersolutions.com
Status|Signed Off |Failed QA
--- Comment #10 from Kyle M Hall <kyle at bywatersolutions.com> ---
Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `borrower_attribute_types` (
`code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'unique key
used to identify each custom field',
`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT
'description for each custom field',
`repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one
patron/borrower can have multiple values for this custom field (1 for yes, 0
for no)',
`unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value
needs to be unique (1 for yes, 0 for no)',
`opac_display` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field
is visible to patrons on their account in the OPAC (1 for yes, 0 for no)',
`opac_editable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field
is editable by patrons on their account in the OPAC (1 for yes, 0 for no)',
`staff_searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this
field is searchable via the patron search in the staff interface (1 for yes, 0
for no)',
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT
NULL COMMENT 'foreign key from authorised_values that links this custom field
to an authorized value category',
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this
field displays in checkout screens',
`class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT
'defines a class for an attribute_type',
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if
this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)',
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute
is mandatory or not',
PRIMARY KEY (`code`),
KEY `auth_val_cat_idx` (`authorised_value_category`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
) at /kohadevbox/koha/C4/Installer.pm line 583.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list