-- Table structure for table `matchchecks`
--

CREATE TABLE `matchchecks` (
  `matcher_id` int(11) NOT NULL,
  `matchcheck_id` int(11) NOT NULL AUTO_INCREMENT,
  `source_matchpoint_id` int(11) NOT NULL,
  `target_matchpoint_id` int(11) NOT NULL,
  PRIMARY KEY (`matchcheck_id`),
  KEY `matcher_matchchecks_ifbk_1` (`matcher_id`),
  KEY `matcher_matchchecks_ifbk_2` (`source_matchpoint_id`),
  KEY `matcher_matchchecks_ifbk_3` (`target_matchpoint_id`),
  CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matchchecks`
--


--
-- Table structure for table `matcher_matchpoints`
--

CREATE TABLE `matcher_matchpoints` (
  `matcher_id` int(11) NOT NULL,
  `matchpoint_id` int(11) NOT NULL,
  KEY `matcher_matchpoints_ifbk_1` (`matcher_id`),
  KEY `matcher_matchpoints_ifbk_2` (`matchpoint_id`),
  CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matcher_matchpoints`
--

INSERT INTO `matcher_matchpoints` VALUES
(1,1),
(2,2),
(3,3);

--
-- Table structure for table `matchpoint_component_norms`
--

CREATE TABLE `matchpoint_component_norms` (
  `matchpoint_component_id` int(11) NOT NULL,
  `sequence` int(11) NOT NULL DEFAULT 0,
  `norm_routine` varchar(50) NOT NULL DEFAULT '',
  KEY `matchpoint_component_norms` (`matchpoint_component_id`,`sequence`),
  CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`) REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matchpoint_component_norms`
--

INSERT INTO `matchpoint_component_norms` VALUES
(1,1,'ISBN'),
(2,1,'ISSN'),
(3,1,'Biblionumber');

--
-- Table structure for table `matchpoint_components`
--

CREATE TABLE `matchpoint_components` (
  `matchpoint_id` int(11) NOT NULL,
  `matchpoint_component_id` int(11) NOT NULL AUTO_INCREMENT,
  `sequence` int(11) NOT NULL DEFAULT 0,
  `tag` varchar(3) NOT NULL DEFAULT '',
  `subfields` varchar(40) NOT NULL DEFAULT '',
  `offset` int(4) NOT NULL DEFAULT 0,
  `length` int(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`matchpoint_component_id`),
  KEY `by_sequence` (`matchpoint_id`,`sequence`),
  CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matchpoint_components`
--

INSERT INTO `matchpoint_components` VALUES
(1,1,1,'020','a',0,0),
(2,2,1,'022','a',0,0),
(3,3,1,'999','c',0,0);

--
-- Table structure for table `matchpoints`
--

CREATE TABLE `matchpoints` (
  `matcher_id` int(11) NOT NULL,
  `matchpoint_id` int(11) NOT NULL AUTO_INCREMENT,
  `search_index` varchar(30) NOT NULL DEFAULT '',
  `score` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`matchpoint_id`),
  KEY `matchpoints_ifbk_1` (`matcher_id`),
  CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matchpoints`
--

INSERT INTO `matchpoints` VALUES
(1,1,'isbn',1000),
(2,2,'issn',1000),
(3,3,'local-number',1000);

--
-- Table structure for table `message_attributes`
--

CREATE TABLE `message_attributes` (
  `message_attribute_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_name` varchar(40) NOT NULL DEFAULT '',
  `takes_days` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`message_attribute_id`),
  UNIQUE KEY `message_name` (`message_name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_attributes`
--

INSERT INTO `message_attributes` VALUES
(1,'Item_Due',0),
(2,'Advance_Notice',1),
(4,'Hold_Filled',0),
(5,'Item_Check_in',0),
(6,'Item_Checkout',0),
(7,'Ill_ready',0),
(8,'Ill_unavailable',0),
(9,'Auto_Renewals',0),
(10,'Hold_Reminder',0),
(11,'Ill_update',0);

--
-- Table structure for table `message_queue`
--

CREATE TABLE `message_queue` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `letter_id` int(11) DEFAULT NULL COMMENT 'Foreign key to the letters table',
  `borrowernumber` int(11) DEFAULT NULL,
  `subject` mediumtext DEFAULT NULL,
  `content` mediumtext DEFAULT NULL,
  `metadata` mediumtext DEFAULT NULL,
  `letter_code` varchar(64) DEFAULT NULL,
  `message_transport_type` varchar(20) NOT NULL,
  `status` enum('sent','pending','failed','deleted') NOT NULL DEFAULT 'pending',
  `time_queued` timestamp NULL DEFAULT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `to_address` longtext DEFAULT NULL,
  `from_address` longtext DEFAULT NULL,
  `reply_address` longtext DEFAULT NULL,
  `content_type` mediumtext DEFAULT NULL,
  `failure_code` mediumtext DEFAULT NULL,
  PRIMARY KEY (`message_id`),
  KEY `borrowernumber` (`borrowernumber`),
  KEY `message_transport_type` (`message_transport_type`),
  KEY `letter_fk` (`letter_id`),
  CONSTRAINT `letter_fk` FOREIGN KEY (`letter_id`) REFERENCES `letter` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_queue`
--


--
-- Table structure for table `message_transport_types`
--

CREATE TABLE `message_transport_types` (
  `message_transport_type` varchar(20) NOT NULL,
  PRIMARY KEY (`message_transport_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_transport_types`
--

INSERT INTO `message_transport_types` VALUES
('email'),
('itiva'),
('phone'),
('print'),
('sms');

--
-- Table structure for table `message_transports`
--

CREATE TABLE `message_transports` (
  `message_attribute_id` int(11) NOT NULL,
  `message_transport_type` varchar(20) NOT NULL,
  `is_digest` tinyint(1) NOT NULL DEFAULT 0,
  `letter_module` varchar(20) NOT NULL DEFAULT '',
  `letter_code` varchar(20) NOT NULL DEFAULT '',
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`message_attribute_id`,`message_transport_type`,`is_digest`),
  KEY `message_transport_type` (`message_transport_type`),
  KEY `letter_module` (`letter_module`,`letter_code`),
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_transports`
--

INSERT INTO `message_transports` VALUES
(1,'email',0,'circulation','DUE',''),
(1,'email',1,'circulation','DUEDGST',''),
(1,'phone',0,'circulation','DUE',''),
(1,'phone',1,'circulation','DUEDGST',''),
(1,'sms',0,'circulation','DUE',''),
(1,'sms',1,'circulation','DUEDGST',''),
(2,'email',0,'circulation','PREDUE',''),
(2,'email',1,'circulation','PREDUEDGST',''),
(2,'itiva',0,'circulation','PREDUE',''),
(2,'itiva',1,'circulation','PREDUEDGST',''),
(2,'phone',0,'circulation','PREDUE',''),
(2,'phone',1,'circulation','PREDUEDGST',''),
(2,'sms',0,'circulation','PREDUE',''),
(2,'sms',1,'circulation','PREDUEDGST',''),
(4,'email',0,'reserves','HOLD',''),
(4,'itiva',0,'reserves','HOLD',''),
(4,'phone',0,'reserves','HOLD',''),
(4,'sms',0,'reserves','HOLD',''),
(5,'email',0,'circulation','CHECKIN',''),
(5,'phone',0,'circulation','CHECKIN',''),
(5,'sms',0,'circulation','CHECKIN',''),
(6,'email',0,'circulation','CHECKOUT',''),
(6,'phone',0,'circulation','CHECKOUT',''),
(6,'sms',0,'circulation','CHECKOUT',''),
(7,'email',0,'ill','ILL_PICKUP_READY',''),
(7,'phone',0,'ill','ILL_PICKUP_READY',''),
(7,'sms',0,'ill','ILL_PICKUP_READY',''),
(8,'email',0,'ill','ILL_REQUEST_UNAVAIL',''),
(8,'phone',0,'ill','ILL_REQUEST_UNAVAIL',''),
(8,'sms',0,'ill','ILL_REQUEST_UNAVAIL',''),
(9,'email',0,'circulation','AUTO_RENEWALS',''),
(9,'email',1,'circulation','AUTO_RENEWALS_DGST',''),
(9,'sms',0,'circulation','AUTO_RENEWALS',''),
(9,'sms',1,'circulation','AUTO_RENEWALS_DGST',''),
(10,'email',0,'circulation','HOLD_REMINDER',''),
(10,'itiva',0,'circulation','HOLD_REMINDER',''),
(10,'phone',0,'circulation','HOLD_REMINDER',''),
(10,'sms',0,'circulation','HOLD_REMINDER',''),
(11,'email',0,'ill','ILL_REQUEST_UPDATE',''),
(11,'phone',0,'ill','ILL_REQUEST_UPDATE',''),
(11,'sms',0,'ill','ILL_REQUEST_UPDATE','');

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key linking this message to the borrowers table',
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key linking the message to the branches table',
  `message_type` varchar(1) NOT NULL COMMENT 'whether the message is for the librarians (L) or the patron (B)',
  `message` mediumtext NOT NULL COMMENT 'the text of the message',
  `message_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the message was written',
  `manager_id` int(11) DEFAULT NULL COMMENT 'creator of message',
  PRIMARY KEY (`message_id`),
  KEY `messages_ibfk_1` (`manager_id`),
  KEY `messages_borrowernumber` (`borrowernumber`),
  CONSTRAINT `messages_borrowernumber` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--


--
-- Table structure for table `misc_files`
--

CREATE TABLE `misc_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the file record',
  `table_tag` varchar(255) NOT NULL COMMENT 'usually table name, or arbitrary unique tag',
  `record_id` int(11) NOT NULL COMMENT 'record id from the table this file is associated to',
  `file_name` varchar(255) NOT NULL COMMENT 'file name',
  `file_type` varchar(255) NOT NULL COMMENT 'MIME type of the file',
  `file_description` varchar(255) DEFAULT NULL COMMENT 'description given to the file',
  `file_content` longblob NOT NULL COMMENT 'file content',
  `date_uploaded` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time the file was added',
  PRIMARY KEY (`file_id`),
  KEY `table_tag` (`table_tag`(191)),
  KEY `record_id` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `misc_files`
--


--
-- Table structure for table `need_merge_authorities`
--

CREATE TABLE `need_merge_authorities` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id',
  `authid` bigint(20) NOT NULL COMMENT 'reference to original authority record',
  `authid_new` bigint(20) DEFAULT NULL COMMENT 'reference to optional new authority record',
  `reportxml` mediumtext DEFAULT NULL COMMENT 'xml showing original reporting tag',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time last modified',
  `done` tinyint(4) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `need_merge_authorities`
--


--
-- Table structure for table `oai_sets`
--

CREATE TABLE `oai_sets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `spec` varchar(80) NOT NULL,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spec` (`spec`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oai_sets`
--


--
-- Table structure for table `oai_sets_biblios`
--

CREATE TABLE `oai_sets_biblios` (
  `biblionumber` int(11) NOT NULL,
  `set_id` int(11) NOT NULL,
  PRIMARY KEY (`biblionumber`,`set_id`),
  KEY `oai_sets_biblios_ibfk_2` (`set_id`),
  CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oai_sets_biblios`
--


--
-- Table structure for table `oai_sets_descriptions`
--

CREATE TABLE `oai_sets_descriptions` (
  `set_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  KEY `oai_sets_descriptions_ibfk_1` (`set_id`),
  CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oai_sets_descriptions`
--


--
-- Table structure for table `oai_sets_mappings`
--

CREATE TABLE `oai_sets_mappings` (
  `set_id` int(11) NOT NULL,
  `rule_order` int(11) DEFAULT NULL,
  `rule_operator` varchar(3) DEFAULT NULL,
  `marcfield` char(3) NOT NULL,
  `marcsubfield` char(1) NOT NULL,
  `operator` varchar(8) NOT NULL DEFAULT 'equal',
  `marcvalue` varchar(80) NOT NULL,
  KEY `oai_sets_mappings_ibfk_1` (`set_id`),
  CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oai_sets_mappings`
--


--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `access_token` varchar(191) NOT NULL COMMENT 'generarated access token',
  `client_id` varchar(191) NOT NULL COMMENT 'the client id the access token belongs to',
  `expires` int(11) NOT NULL COMMENT 'expiration time in seconds',
  PRIMARY KEY (`access_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--


--
-- Table structure for table `old_issues`
--

CREATE TABLE `old_issues` (
  `issue_id` int(11) NOT NULL COMMENT 'primary key for issues table',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to',
  `issuer_id` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the user who checked out this item',
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out',
  `date_due` datetime DEFAULT NULL COMMENT 'date the item is due (yyyy-mm-dd)',
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',
  `returndate` datetime DEFAULT NULL COMMENT 'date the item was returned',
  `lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',
  `renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',
  `unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',
  `auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal',
  `auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched',
  `issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued',
  `onsite_checkout` int(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
  `note` longtext DEFAULT NULL COMMENT 'issue note text',
  `notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)',
  `noteseen` int(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null',
  PRIMARY KEY (`issue_id`),
  KEY `old_issuesborridx` (`borrowernumber`),
  KEY `old_issuesitemidx` (`itemnumber`),
  KEY `branchcode_idx` (`branchcode`),
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_issues`
--


--
-- Table structure for table `old_reserves`
--

CREATE TABLE `old_reserves` (
  `reserve_id` int(11) NOT NULL COMMENT 'primary key',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron this hold is for',
  `reservedate` date DEFAULT NULL COMMENT 'the date the hold was places',
  `biblionumber` int(11) DEFAULT NULL COMMENT 'foreign key from the biblio table defining which bib record this hold is on',
  `item_group_id` int(11) DEFAULT NULL COMMENT 'foreign key from the item_groups table defining if this is an item group level hold',
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at',
  `desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at',
  `notificationdate` date DEFAULT NULL COMMENT 'currently unused',
  `reminderdate` date DEFAULT NULL COMMENT 'currently unused',
  `cancellationdate` date DEFAULT NULL COMMENT 'the date this hold was cancelled',
  `cancellation_reason` varchar(80) DEFAULT NULL COMMENT 'optional authorised value CANCELLATION_REASON',
  `reservenotes` longtext DEFAULT NULL COMMENT 'notes related to this hold',
  `priority` smallint(6) NOT NULL DEFAULT 1 COMMENT 'where in the queue the patron sits',
  `found` varchar(1) DEFAULT NULL COMMENT 'a one letter code defining what the status is of the hold is after it has been confirmed',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this hold was last updated',
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
  `waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
  `expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (usually the date entered by the patron to say they don''t need the hold after a certain date)',
  `patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)',
  `suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',
  `suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
  PRIMARY KEY (`reserve_id`),
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
  KEY `old_reserves_biblionumber` (`biblionumber`),
  KEY `old_reserves_itemnumber` (`itemnumber`),
  KEY `old_reserves_branchcode` (`branchcode`),
  KEY `old_reserves_itemtype` (`itemtype`),
  KEY `old_reserves_ibfk_ig` (`item_group_id`),
  CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_reserves`
--


--
-- Table structure for table `overduerules`
--

CREATE TABLE `overduerules` (
  `overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules',
  `branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)',
  `categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for',
  `delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent',
  `letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice',
  `debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)',
  `delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent',
  `debarred2` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)',
  `letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice',
  `delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent',
  `letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice',
  `debarred3` int(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)',
  PRIMARY KEY (`overduerules_id`),
  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `overduerules`
--


--
-- Table structure for table `overduerules_transport_types`
--

CREATE TABLE `overduerules_transport_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `letternumber` int(1) NOT NULL DEFAULT 1,
  `message_transport_type` varchar(20) NOT NULL DEFAULT 'email',
  `overduerules_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `overduerules_fk` (`overduerules_id`),
  KEY `mtt_fk` (`message_transport_type`),
  CONSTRAINT `mtt_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `overduerules_fk` FOREIGN KEY (`overduerules_id`) REFERENCES `overduerules` (`overduerules_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `overduerules_transport_types`
--


--
-- Table structure for table `patron_consent`
--

CREATE TABLE `patron_consent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `borrowernumber` int(11) NOT NULL,
  `type` enum('GDPR_PROCESSING') DEFAULT NULL COMMENT 'allows for future extension',
  `given_on` datetime DEFAULT NULL,
  `refused_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `borrowernumber` (`borrowernumber`),
  CONSTRAINT `patron_consent_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `patron_consent`
--


--
-- Table structure for table `patron_list_patrons`
--

CREATE TABLE `patron_list_patrons` (
  `patron_list_patron_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `patron_list_id` int(11) NOT NULL COMMENT 'the list this entry is part of',
  `borrowernumber` int(11) NOT NULL COMMENT 'the borrower that is part of this list',
  PRIMARY KEY (`patron_list_patron_id`),
  KEY `patron_list_id` (`patron_list_id`),
  KEY `borrowernumber` (`borrowernumber`),
  CONSTRAINT `patron_list_patrons_ibfk_1` FOREIGN KEY (`patron_list_id`) REFERENCES `patron_lists` (`patron_list_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `patron_list_patrons_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `patron_list_patrons`
--


--
-- Table structure for table `patron_lists`
--

CREATE TABLE `patron_lists` (
  `patron_list_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'the list''s name',
  `owner` int(11) NOT NULL COMMENT 'borrowernumber of the list creator',
  `shared` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`patron_list_id`),
  KEY `owner` (`owner`),
  CONSTRAINT `patron_lists_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `patron_lists`
--


--
-- Table structure for table `patronimage`
--

CREATE TABLE `patronimage` (
  `borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)',
  `mimetype` varchar(15) NOT NULL COMMENT 'the format of the image (png, jpg, etc)',
  `imagefile` mediumblob NOT NULL COMMENT 'the image',
  PRIMARY KEY (`borrowernumber`),
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `patronimage`
--


--
-- Table structure for table `pending_offline_operations`
--

CREATE TABLE `pending_offline_operations` (
  `operationid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) NOT NULL,
  `branchcode` varchar(10) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `action` varchar(10) NOT NULL,
  `barcode` varchar(20) DEFAULT NULL,
  `cardnumber` varchar(32) DEFAULT NULL,
  `amount` decimal(28,6) DEFAULT NULL,
  PRIMARY KEY (`operationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pending_offline_operations`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `module_bit` int(11) NOT NULL DEFAULT 0,
  `code` varchar(64) NOT NULL DEFAULT '',
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`module_bit`,`code`),
  CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES
(1,'circulate_remaining_permissions','Remaining circulation permissions'),
(1,'force_checkout','Force checkout if a limitation exists'),
(1,'manage_checkout_notes','Mark checkout notes as seen/not seen'),
(1,'manage_curbside_pickups','Manage curbside pickups'),
(1,'manage_restrictions','Manage restrictions for accounts'),
(1,'overdues_report','Execute overdue items report'),
(1,'override_renewals','Override blocked renewals'),
(3,'manage_accounts','Manage Account Debit and Credit Types'),
(3,'manage_additional_fields','Add, edit, or delete additional custom fields for baskets or subscriptions (also requires order_manage or edit_subscription permissions)'),
(3,'manage_audio_alerts','Manage audio alerts'),
(3,'manage_auth_values','Manage authorized values'),
(3,'manage_background_jobs','Manage background jobs'),
(3,'manage_cash_registers','Add and remove cash registers'),
(3,'manage_circ_rules','Manage circulation rules'),
(3,'manage_circ_rules_from_any_libraries','Manage circ rules for any libraries'),
(3,'manage_cities','Manage cities and towns'),
(3,'manage_classifications','Manage classification sources'),
(3,'manage_column_config','Manage column configuration'),
(3,'manage_curbside_pickups','Manage curbside pickups'),
(3,'manage_didyoumean','Manage Did you mean? configuration'),
(3,'manage_identity_providers','Manage identity providers'),
(3,'manage_item_circ_alerts','Manage item circulation alerts'),
(3,'manage_item_search_fields','Manage item search fields'),
(3,'manage_itemtypes','Manage item types'),
(3,'manage_keyboard_shortcuts','Manage keyboard shortcuts for the advanced cataloging editor'),
(3,'manage_libraries','Manage libraries and library groups'),
(3,'manage_mana','Manage Mana KB content sharing'),
(3,'manage_marc_frameworks','Manage MARC bibliographic and authority frameworks'),
(3,'manage_marc_overlay_rules','Manage MARC overlay rules configuration'),
(3,'manage_matching_rules','Manage record matching rules'),
(3,'manage_oai_sets','Manage OAI sets'),
(3,'manage_patron_attributes','Manage extended patron attributes'),
(3,'manage_patron_categories','Manage patron categories'),
(3,'manage_patron_restrictions','Manage patron restrictions'),
(3,'manage_search_engine_config','Manage search engine configuration'),
(3,'manage_search_filters','Manage custom search filters'),
(3,'manage_search_targets','Manage Z39.50 and SRU server configuration'),
(3,'manage_sms_providers','Manage SMS cellular providers'),
(3,'manage_smtp_servers','Manage SMTP servers configuration'),
(3,'manage_sysprefs','Manage global system preferences'),
(3,'manage_transfers','Manage library transfer limits and transport cost matrix'),
(3,'manage_usage_stats','Manage usage statistics settings'),
(3,'parameters_remaining_permissions','Remaining system parameters permissions'),
(4,'delete_borrowers','Delete patrons'),
(4,'edit_borrowers','Add, modify and view patron information'),
(4,'view_borrower_infos_from_any_libraries','View patron infos from any libraries'),
(6,'modify_holds_priority','Modify holds priority'),
(6,'place_holds','Place holds for patrons'),
(9,'advanced_editor','Use the advanced cataloging editor (requires edit_catalogue)'),
(9,'create_shared_macros','Create shared macros'),
(9,'delete_all_items','Delete all items at once'),
(9,'delete_shared_macros','Delete shared macros'),
(9,'edit_catalogue','Edit catalog (Modify bibliographic/holdings data)'),
(9,'edit_items','Edit items'),
(9,'edit_items_restricted','Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),
(9,'fast_cataloging','Fast cataloging'),
(9,'manage_item_editor_templates','Update and delete item editor template owned by others'),
(9,'manage_item_groups','Create, update and delete item groups, add or remove items from a item groups'),
(10,'discount','Perform account discount action'),
(10,'manual_credit','Add manual credits to a patron account'),
(10,'manual_invoice','Add manual invoices to a patron account'),
(10,'payout','Perform account payout action'),
(10,'refund','Perform account refund action'),
(10,'remaining_permissions','Remaining permissions for managing fines and fees'),
(10,'writeoff','Write off fines and fees'),
(11,'budget_add_del','Add and delete funds (but can\'t modify funds)'),
(11,'budget_manage','Manage funds'),
(11,'budget_manage_all','Manage all funds'),
(11,'budget_modify','Modify funds (can\'t create lines, but can modify existing ones)'),
(11,'contracts_manage','Manage contracts'),
(11,'currencies_manage','Manage currencies and exchange rates'),
(11,'delete_baskets','Delete baskets'),
(11,'delete_invoices','Delete invoices'),
(11,'edi_manage','Manage EDIFACT transmissions'),
(11,'edit_invoices','Edit invoices'),
(11,'group_manage','Manage basket groups'),
(11,'merge_invoices','Merge invoices'),
(11,'order_manage','Manage baskets and order lines'),
(11,'order_manage_all','Manage all baskets and order lines, regardless of restrictions on them'),
(11,'order_receive','Receive orders and manage shipments'),
(11,'period_manage','Manage budgets'),
(11,'planning_manage','Manage budget plannings'),
(11,'reopen_closed_invoices','Reopen closed invoices'),
(11,'vendors_manage','Manage vendors'),
(12,'suggestions_manage','Manage purchase suggestions'),
(13,'access_files','Access to the files stored on the server'),
(13,'batch_extend_due_dates','Perform batch extend due dates'),
(13,'batch_upload_patron_images','Upload patron images in a batch or one at a time'),
(13,'delete_anonymize_patrons','Delete old borrowers and anonymize circulation history (deletes borrower checkout history)'),
(13,'edit_additional_contents','Write additional contents for the OPAC and staff interfaces (news and HTML customizations)'),
(13,'edit_calendar','Define days when the library is closed'),
(13,'edit_notice_status_triggers','Set notice/status triggers for overdue items'),
(13,'edit_notices','Define notices'),
(13,'edit_patrons','Perform batch modification of patrons'),
(13,'edit_quotes','Edit quotes for quote-of-the-day feature'),
(13,'export_catalog','Export bibliographic and holdings data'),
(13,'import_patrons','Import patron data'),
(13,'inventory','Perform inventory (stocktaking) of your catalog'),
(13,'items_batchdel','Perform batch deletion of items'),
(13,'items_batchmod','Perform batch modification of items'),
(13,'items_batchmod_restricted','Limit batch item modification to subfields defined in the SubfieldsToAllowForRestrictedBatchmod preference (please note that items_batchmod is still required)'),
(13,'label_creator','Create printable labels and barcodes from catalog and patron data'),
(13,'manage_csv_profiles','Manage CSV export profiles'),
(13,'manage_patron_lists','Add, edit and delete patron lists and their contents'),
(13,'manage_staged_marc','Manage staged MARC records, including completing and reversing imports'),
(13,'marc_modification_templates','Manage marc modification templates'),
(13,'moderate_comments','Moderate patron comments'),
(13,'moderate_tags','Moderate patron tags'),
(13,'records_batchdel','Perform batch deletion of records (bibliographic or authority)'),
(13,'records_batchmod','Perform batch modification of records (biblios or authorities)'),
(13,'rotating_collections','Manage rotating collections'),
(13,'schedule_tasks','Schedule tasks to run'),
(13,'stage_marc_import','Stage MARC records into the reservoir'),
(13,'upload_general_files','Upload any file'),
(13,'upload_local_cover_images','Upload local cover images'),
(13,'upload_manage','Manage uploaded files'),
(13,'view_system_logs','Browse the system logs'),
(15,'check_expiration','Check the expiration of a serial'),
(15,'claim_serials','Claim missing serials'),
(15,'create_subscription','Create a new subscription'),
(15,'delete_subscription','Delete an existing subscription'),
(15,'edit_subscription','Edit an existing subscription'),
(15,'receive_serials','Serials receiving'),
(15,'renew_subscription','Renew a subscription'),
(15,'routing','Routing'),
(15,'superserials','Manage subscriptions from any branch (only applies when IndependentBranches is used)'),
(16,'create_reports','Create SQL reports'),
(16,'delete_reports','Delete SQL reports'),
(16,'execute_reports','Execute SQL reports'),
(18,'add_reserves','Add course reserves'),
(18,'delete_reserves','Remove course reserves'),
(18,'manage_courses','Add, edit and delete courses'),
(19,'configure','Configure plugins'),
(19,'manage','Manage plugins ( install / uninstall )'),
(19,'report','Use report plugins'),
(19,'tool','Use tool plugins'),
(20,'delete_public_lists','Delete public lists'),
(20,'edit_public_lists','Edit public lists'),
(21,'edit_clubs','Create and update clubs'),
(21,'edit_templates','Create and update club templates'),
(21,'enroll','Enroll patrons in clubs'),
(23,'self_checkin_module','Log into the self check-in module'),
(23,'self_checkout_module','Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID'),
(24,'manage_rota_items','Add and remove items from rotas'),
(24,'manage_rotas','Create, edit and delete rotas'),
(25,'anonymous_refund','Perform refund actions from cash registers'),
(25,'cashup','Perform cash register cashup action'),
(25,'takepayment','Access the point of sale page and take payments'),
(26,'manage_problem_reports','Manage OPAC problem reports'),
(27,'manage_recalls','Manage recalls for patrons');

--
-- Table structure for table `plugin_data`
--

CREATE TABLE `plugin_data` (
  `plugin_class` varchar(255) NOT NULL,
  `plugin_key` varchar(255) NOT NULL,
  `plugin_value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`plugin_class`(191),`plugin_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugin_data`
--


--
-- Table structure for table `plugin_methods`
--

CREATE TABLE `plugin_methods` (
  `plugin_class` varchar(255) NOT NULL,
  `plugin_method` varchar(255) NOT NULL,
  PRIMARY KEY (`plugin_class`(191),`plugin_method`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugin_methods`
--


--
-- Table structure for table `printers_profile`
--

CREATE TABLE `printers_profile` (
  `profile_id` int(4) NOT NULL AUTO_INCREMENT,
  `printer_name` varchar(40) NOT NULL DEFAULT 'Default Printer',
  `template_id` int(4) NOT NULL DEFAULT 0,
  `paper_bin` varchar(20) NOT NULL DEFAULT 'Bypass',
  `offset_horz` float NOT NULL DEFAULT 0,
  `offset_vert` float NOT NULL DEFAULT 0,
  `creep_horz` float NOT NULL DEFAULT 0,
  `creep_vert` float NOT NULL DEFAULT 0,
  `units` char(20) NOT NULL DEFAULT 'POINT',
  `creator` char(15) NOT NULL DEFAULT 'Labels',
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `printers_profile`
--

INSERT INTO `printers_profile` VALUES
(1,'Impresora laser de la biblioteca',1,'Bypass',-2,9,3,0,'POINT','Labels'),
(13,'Impresora laser de la biblioteca',7,'Tray 1',0,0,0,0,'POINT','Labels'),
(14,'Impresora laser de la biblioteca',12,'Tray 2',0,0,0,0,'POINT','Labels'),
(16,'Impresora de prueba 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
(22,'Impresora laser de la biblioteca',0,'Tray 3',0,0,0,0,'POINT','Labels');

--
-- Table structure for table `problem_reports`
--

CREATE TABLE `problem_reports` (
  `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `title` varchar(40) NOT NULL DEFAULT '' COMMENT 'report subject line',
  `content` text NOT NULL COMMENT 'report message content',
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report',
  `branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'borrower''s branch',
  `username` varchar(75) DEFAULT NULL COMMENT 'OPAC username',
  `problempage` text DEFAULT NULL COMMENT 'page the user triggered the problem report form from',
  `recipient` enum('admin','library') NOT NULL DEFAULT 'library' COMMENT 'the ''to-address'' of the problem report',
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'timestamp of report submission',
  `status` varchar(6) NOT NULL DEFAULT 'New' COMMENT 'status of the report. New, Viewed, Closed',
  PRIMARY KEY (`reportid`),
  KEY `problem_reports_ibfk1` (`borrowernumber`),
  KEY `problem_reports_ibfk2` (`branchcode`),
  CONSTRAINT `problem_reports_ibfk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `problem_reports_ibfk2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `problem_reports`
--


--
-- Table structure for table `pseudonymized_borrower_attributes`
--

CREATE TABLE `pseudonymized_borrower_attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
  `transaction_id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
  PRIMARY KEY (`id`),
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
  KEY `anonymized_borrower_attributes_ibfk_2` (`code`),
  CONSTRAINT `anonymized_borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `pseudonymized_borrower_attributes_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pseudonymized_borrower_attributes`
--


--
-- Table structure for table `pseudonymized_transactions`
--

CREATE TABLE `pseudonymized_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hashed_borrowernumber` varchar(60) NOT NULL,
  `has_cardnumber` tinyint(1) NOT NULL DEFAULT 0,
  `title` longtext DEFAULT NULL,
  `city` longtext DEFAULT NULL,
  `state` mediumtext DEFAULT NULL,
  `zipcode` varchar(25) DEFAULT NULL,
  `country` mediumtext DEFAULT NULL,
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `categorycode` varchar(10) NOT NULL DEFAULT '',
  `dateenrolled` date DEFAULT NULL,
  `sex` varchar(1) DEFAULT NULL,
  `sort1` varchar(80) DEFAULT NULL,
  `sort2` varchar(80) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `transaction_branchcode` varchar(10) DEFAULT NULL,
  `transaction_type` varchar(16) DEFAULT NULL,
  `itemnumber` int(11) DEFAULT NULL,
  `itemtype` varchar(10) DEFAULT NULL,
  `holdingbranch` varchar(10) DEFAULT NULL,
  `homebranch` varchar(10) DEFAULT NULL,
  `location` varchar(80) DEFAULT NULL,
  `itemcallnumber` varchar(255) DEFAULT NULL,
  `ccode` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pseudonymized_transactions_ibfk_1` (`categorycode`),
  KEY `pseudonymized_transactions_borrowers_ibfk_2` (`branchcode`),
  KEY `pseudonymized_transactions_borrowers_ibfk_3` (`transaction_branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pseudonymized_transactions`
--


--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the quote',
  `source` mediumtext DEFAULT NULL COMMENT 'source/credit for the quote',
  `text` longtext NOT NULL COMMENT 'text of the quote',
  `timestamp` datetime DEFAULT NULL COMMENT 'date and time that the quote last appeared in the opac',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` VALUES
(1,'George Washington','Estar preparado para la guerra es una de las formas más efectivas de preservar la paz.','2024-01-02 16:08:23'),
(2,'Thomas Jefferson','Cuando estés enojado, cuenta hasta diez, antes de hablar; si estás muy enojado, hasta cien.','2024-01-02 16:08:23'),
(3,'Abraham Lincoln','Hace ochenta y siete años nuestros padres trajeron a este continente una nueva nación, concebida en libertad, y dedicada a la idea de que todos los hombres son creados iguales.','2024-01-02 16:08:23'),
(4,'Abraham Lincoln','Siempre he encontrado que la misericordia entrega mejores frutos que la justicia estricta.','2024-01-02 16:08:23'),
(5,'Andrew Johnson','Me siento incompetente para realizar obligaciones...que han sido tan inesperadamente lanzadas sobre mí.','2024-01-02 16:08:23'),
(6,'Rutherford B. Hayes','Sirve mejor a su partido quien sirve mejor a su país.','2024-01-02 16:08:23'),
(7,'Theodore Roosevelt','¿Ningún presidente se ha disfrutado tanto como yo?','2024-01-02 16:08:23'),
(8,'Theodore Roosevelt','Habla suavemente y carga un gran palo.','2024-01-02 16:08:23'),
(9,'William H. Taft','I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.','2024-01-02 16:08:23'),
(11,'Woodrow Wilson','You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.','2024-01-02 16:08:23'),
(12,'Calvin Coolidge','If you don\'t say anything, you won\'t be called on to repeat it.','2024-01-02 16:08:23'),
(13,'Calvin Coolidge','Las cuatro quintas partes de todos nuestros problemas en esta vida desaparecerían si sólo nos sentamos y nos quedamos quietos.','2024-01-02 16:08:23'),
(14,'Herbert Hoover','The slogan of progress is changing from the full dinner pail to the full garage.','2024-01-02 16:08:23'),
(15,'Franklin D. Roosevelt','Let me assert my firm belief that the only thing we have to fear is fear itself.','2024-01-02 16:08:23'),
(16,'Harry S. Truman','If you can\'t stand the heat, get out of the kitchen.','2024-01-02 16:08:23'),
(17,'Harry S. Truman','The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.','2024-01-02 16:08:23'),
(18,'Harry S. Truman','The buck stops here.','2024-01-02 16:08:23'),
(19,'Dwight D. Eisenhower','La historia ya no confía el cuidado de la libertad a los débiles o a los tímidos.','2024-01-02 16:08:23'),
(20,'John F. Kennedy','My fellow Americans, ask not what your country can do for you; ask what you can do for your country.','2024-01-02 16:08:23'),
(22,'John F. Kennedy','No creo que sea del todo inapropiado presentarme a esta audiencia. Yo soy el hombre que acompañó a Jacqueline Kennedy a París, y lo he disfrutado.','2024-01-02 16:08:23'),
(23,'Lyndon B. Johnson','The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.','2024-01-02 16:08:23'),
(24,'Richard Nixon','People have got to know whether or not their president is a crook. Well, I\'m not a crook.','2024-01-02 16:08:23'),
(25,'Richard Nixon','When the President does it, that means that it is not illegal.','2024-01-02 16:08:23'),
(26,'Gerald R. Ford','Our Long national nightmare is over.','2024-01-02 16:08:23'),
(27,'Gerald R. Ford','Nuestra constitución funciona. Nuestra gran república es un gobierno de leyes, no de hombres.','2024-01-02 16:08:23'),
(28,'Jimmy Carter','A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.','2024-01-02 16:08:23'),
(30,'Ronald Reagan','It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.','2024-01-02 16:08:23'),
(31,'Ronald Reagan','Cada generación va más allá de la generación anterior, porque se levanta sobre los hombros de esa generación. Ustedes tendrán oportunidades más allá de lo que jamás hemos conocido.','2024-01-02 16:08:23'),
(32,'George H. W. Bush','We have ...drawn a line in the sand.','2024-01-02 16:08:23'),
(33,'George W. Bush','If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.','2024-01-02 16:08:23'),
(34,'George W. Bush','Cada nación en cada región tiene ahora que tomar una decisión. Están con nosotros o están con los terroristas.','2024-01-02 16:08:23'),
(35,'Katherine Johnson','Girls are capable of doing everything men are capable of doing. Sometimes they have more imagination than men.','2024-01-02 16:08:23'),
(36,'Serena Williams','I really think a champion is defined not by their wins but by how they can recover when they fall.','2024-01-02 16:08:23'),
(37,'Shirley Chisholm','Tremendous amounts of talent are being lost to our society just because that talent wears a skirt.','2024-01-02 16:08:23'),
(38,'Frida Kahlo','Al final del día, podemos hacer mucho mas de lo que pensamos que podemos.','2024-01-02 16:08:23'),
(39,'Marie Curie','No le temas a la perfección; nunca la alcanzarás.','2024-01-02 16:08:23'),
(40,'Indira Gandhi','You cannot shake hands with a clenched fist.','2024-01-02 16:08:23'),
(41,'Maya Angelou','If you don\'t like something, change it. If you can\'t change it, change your attitude.','2024-01-02 16:08:23'),
(42,'Marilyn Monroe','I don\'t mind living in a man\'s world, as long as I get to be a woman in it.','2024-01-02 16:08:23'),
(43,'Maya Angelou','My mission in life is not merely to survive but to thrive and to do so with some passion, some compassion, some humor, and some style.','2024-01-02 16:08:23'),
(44,'Alex Elle','I am thankful for my struggle because, without it, I wouldn\'t have stumbled across my strength.','2024-01-02 16:08:23'),
(45,'Madeleine Albright','It took me quite a long time to develop a voice, and now that I have it, I am not going to be silent.','2024-01-02 16:08:23'),
(46,'Jane Goodall','What you do makes a difference, and you have to decide what kind of difference you want to make.','2024-01-02 16:08:23'),
(47,'Dolly Parton','The way I see it, if you want the rainbow, you gotta put up with the rain!','2024-01-02 16:08:23'),
(48,'Laverne Cox','Each and every one of us has the capacity to be an oppressor. I want to encourage each and every one of us to interrogate how we might be an oppressor and how we might be able to become liberators for ourselves and for each other.','2024-01-02 16:08:23'),
(49,'Gloria Steinem','The future depends entirely on what each of us does every day; a movement is only people moving.','2024-01-02 16:08:23'),
(50,'Robin Wall Kimmerer','The land knows you, even when you are lost.','2024-01-02 16:08:23');

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron who left this rating (borrowers.borrowernumber)',
  `biblionumber` int(11) NOT NULL COMMENT 'the biblio this rating is for (biblio.biblionumber)',
  `rating_value` tinyint(1) NOT NULL COMMENT 'the rating, from 1 to 5',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`borrowernumber`,`biblionumber`),
  KEY `ratings_ibfk_2` (`biblionumber`),
  CONSTRAINT `ratings_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ratings_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ratings`
--


--
-- Table structure for table `recalls`
--

CREATE TABLE `recalls` (
  `recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall',
  `patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall',
  `created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested',
  `biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled',
  `pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library',
  `completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)',
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall',
  `priority` smallint(6) DEFAULT NULL COMMENT 'Where in the queue the patron sits',
  `status` enum('requested','overdue','waiting','in_transit','cancelled','expired','fulfilled') DEFAULT 'requested' COMMENT 'Status of recall',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time the recall was last updated',
  `item_id` int(11) DEFAULT NULL COMMENT 'Identifier for item record that was recalled, if an item-level recall',
  `waiting_date` datetime DEFAULT NULL COMMENT 'Date an item was marked as waiting for the patron at the library',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Date recall is no longer required, or date recall will expire after waiting on shelf for pickup',
  `completed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Flag if recall is old and no longer active, i.e. expired, cancelled or completed',
  `item_level` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Flag if recall is for a specific item',
  PRIMARY KEY (`recall_id`),
  KEY `recalls_ibfk_1` (`patron_id`),
  KEY `recalls_ibfk_2` (`biblio_id`),
  KEY `recalls_ibfk_3` (`item_id`),
  KEY `recalls_ibfk_4` (`pickup_library_id`),
  CONSTRAINT `recalls_ibfk_1` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recalls_ibfk_2` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recalls_ibfk_3` FOREIGN KEY (`item_id`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recalls_ibfk_4` FOREIGN KEY (`pickup_library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Information related to recalls in Koha';

--
-- Dumping data for table `recalls`
--


--
-- Table structure for table `repeatable_holidays`
--

CREATE TABLE `repeatable_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for',
  `weekday` smallint(6) DEFAULT NULL COMMENT 'day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on',
  `day` smallint(6) DEFAULT NULL COMMENT 'day of the month this closing is on',
  `month` smallint(6) DEFAULT NULL COMMENT 'month this closing is in',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'title of this closing',
  `description` mediumtext NOT NULL COMMENT 'description for this closing',
  PRIMARY KEY (`id`),
  KEY `repeatable_holidays_ibfk_1` (`branchcode`),
  CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `repeatable_holidays`
--


--
-- Table structure for table `reports_dictionary`
--

CREATE TABLE `reports_dictionary` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `name` varchar(255) DEFAULT NULL COMMENT 'name for this definition',
  `description` mediumtext DEFAULT NULL COMMENT 'description for this definition',
  `date_created` datetime DEFAULT NULL COMMENT 'date and time this definition was created',
  `date_modified` datetime DEFAULT NULL COMMENT 'date and time this definition was last modified',
  `saved_sql` mediumtext DEFAULT NULL COMMENT 'SQL snippet for us in reports',
  `report_area` varchar(6) DEFAULT NULL COMMENT 'Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)',
  PRIMARY KEY (`id`),
  KEY `dictionary_area_idx` (`report_area`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reports_dictionary`
--


--
-- Table structure for table `reserves`
--

CREATE TABLE `reserves` (
  `reserve_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for',
  `reservedate` date DEFAULT NULL COMMENT 'the date the hold was placed',
  `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this hold is on',
  `item_group_id` int(11) DEFAULT NULL COMMENT 'foreign key from the item_groups table defining if this is an item group level hold',
  `branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at',
  `desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at',
  `notificationdate` date DEFAULT NULL COMMENT 'currently unused',
  `reminderdate` date DEFAULT NULL COMMENT 'currently unused',
  `cancellationdate` date DEFAULT NULL COMMENT 'the date this hold was cancelled',
  `cancellation_reason` varchar(80) DEFAULT NULL COMMENT 'optional authorised value CANCELLATION_REASON',
  `reservenotes` longtext DEFAULT NULL COMMENT 'notes related to this hold',
  `priority` smallint(6) NOT NULL DEFAULT 1 COMMENT 'where in the queue the patron sits',
  `found` varchar(1) DEFAULT NULL COMMENT 'a one letter code defining what the status is of the hold is after it has been confirmed',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this hold was last updated',
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
  `waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
  `expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (calculated value)',
  `patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
  `suspend_until` datetime DEFAULT NULL,
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
  PRIMARY KEY (`reserve_id`),
  KEY `priorityfoundidx` (`priority`,`found`),
  KEY `borrowernumber` (`borrowernumber`),
  KEY `biblionumber` (`biblionumber`),
  KEY `itemnumber` (`itemnumber`),
  KEY `branchcode` (`branchcode`),
  KEY `desk_id` (`desk_id`),
  KEY `itemtype` (`itemtype`),
  KEY `reserves_ibfk_ig` (`item_group_id`),
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reserves`
--


--
-- Table structure for table `restriction_types`
--

CREATE TABLE `restriction_types` (
  `code` varchar(50) NOT NULL,
  `display_text` text NOT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT 0,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `restriction_types`
--

INSERT INTO `restriction_types` VALUES
('DISCHARGE','Discharge',1,0),
('MANUAL','Manual',0,1),
('OVERDUES','Overdues',1,0),
('SUSPENSION','Suspension',1,0);

--
-- Table structure for table `return_claims`
--

CREATE TABLE `return_claims` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the return claim',
  `itemnumber` int(11) NOT NULL COMMENT 'ID of the item',
  `issue_id` int(11) DEFAULT NULL COMMENT 'ID of the checkout that triggered the claim',
  `borrowernumber` int(11) NOT NULL COMMENT 'ID of the patron',
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes about the claim',
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was created',
  `created_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that registered the claim',
  `updated_on` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() COMMENT 'Time and date of the latest change on the claim (notes)',
  `updated_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that updated the claim',
  `resolution` varchar(80) DEFAULT NULL COMMENT 'Resolution code (RETURN_CLAIM_RESOLUTION AVs)',
  `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved',
  `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim',
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_issue` (`itemnumber`,`issue_id`),
  KEY `itemnumber` (`itemnumber`),
  KEY `rc_borrowers_ibfk` (`borrowernumber`),
  KEY `rc_created_by_ibfk` (`created_by`),
  KEY `rc_updated_by_ibfk` (`updated_by`),
  KEY `rc_resolved_by_ibfk` (`resolved_by`),
  CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rc_resolved_by_ibfk` FOREIGN KEY (`resolved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `rc_updated_by_ibfk` FOREIGN KEY (`updated_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `return_claims`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `reviewid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for this comment',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron left this comment',
  `biblionumber` int(11) DEFAULT NULL COMMENT 'foreign key from the biblio table defining which bibliographic record this comment is for',
  `review` mediumtext DEFAULT NULL COMMENT 'the body of the comment',
  `approved` tinyint(4) DEFAULT 0 COMMENT 'whether this comment has been approved by a librarian (1 for yes, 0 for no)',
  `datereviewed` datetime DEFAULT NULL COMMENT 'the date the comment was left',
  PRIMARY KEY (`reviewid`),
  KEY `reviews_ibfk_1` (`borrowernumber`),
  KEY `reviews_ibfk_2` (`biblionumber`),
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--


--
-- Table structure for table `saved_reports`
--

CREATE TABLE `saved_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `report_id` int(11) DEFAULT NULL,
  `report` longtext DEFAULT NULL,
  `date_run` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `saved_reports`
--


--
-- Table structure for table `saved_sql`
--

CREATE TABLE `saved_sql` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id and primary key assigned by Koha',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'the staff member who created this report (borrowers.borrowernumber)',
  `date_created` datetime DEFAULT NULL COMMENT 'the date this report was created',
  `last_modified` datetime DEFAULT NULL COMMENT 'the date this report was last edited',
  `savedsql` mediumtext DEFAULT NULL COMMENT 'the SQL for this report',
  `last_run` datetime DEFAULT NULL,
  `report_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'the name of this report',
  `type` varchar(255) DEFAULT NULL COMMENT 'always 1 for tabular',
  `notes` mediumtext DEFAULT NULL COMMENT 'the notes or description given to this report',
  `cache_expiry` int(11) NOT NULL DEFAULT 300,
  `public` tinyint(1) NOT NULL DEFAULT 0,
  `report_area` varchar(6) DEFAULT NULL,
  `report_group` varchar(80) DEFAULT NULL,
  `report_subgroup` varchar(80) DEFAULT NULL,
  `mana_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sql_area_group_idx` (`report_group`,`report_subgroup`),
  KEY `boridx` (`borrowernumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `saved_sql`
--


--
-- Table structure for table `search_field`
--

CREATE TABLE `search_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
  `type` enum('','string','date','number','boolean','sum','isbn','stdno','year','callnumber') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
  `weight` decimal(5,2) DEFAULT NULL,
  `facet_order` tinyint(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
  `opac` tinyint(1) NOT NULL DEFAULT 1,
  `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_field`
--

INSERT INTO `search_field` VALUES
(1,'author-title','author-title','',NULL,NULL,1,1,NULL),
(2,'coded-location-qualifier','coded-location-qualifier','',NULL,NULL,1,1,NULL),
(3,'stack','stack','',NULL,NULL,1,1,NULL),
(4,'number-local-acquisition','number-local-acquisition','',NULL,NULL,1,1,NULL),
(5,'reserves','reserves','',NULL,NULL,1,1,NULL),
(6,'nlm-call-number','nlm-call-number','',NULL,NULL,1,1,NULL),
(7,'datelastseen','datelastseen','',NULL,NULL,1,1,NULL),
(8,'notforloan','notforloan','number',NULL,NULL,1,1,NULL),
(9,'acqsource','acqsource','',NULL,NULL,1,1,NULL),
(10,'title-later','title-later','',NULL,NULL,1,1,NULL),
(11,'totalissues','totalissues','',NULL,NULL,1,1,NULL),
(12,'record-control-number','record-control-number','',NULL,NULL,1,1,NULL),
(13,'ff7-01','ff7-01','',NULL,NULL,1,1,NULL),
(14,'restricted','restricted','',NULL,NULL,1,1,NULL),
(15,'ff7-01-02','ff7-01-02','',NULL,NULL,1,1,NULL),
(16,'ff7-02','ff7-02','',NULL,NULL,1,1,NULL),
(17,'subject','subject','string',NULL,6,1,1,NULL),
(18,'itemtype','itemtype','',NULL,NULL,1,1,NULL),
(19,'llength','llength','',NULL,NULL,1,1,NULL),
(20,'ln-subtitle','ln-subtitle','',NULL,NULL,1,1,NULL),
(21,'provider','provider','',NULL,NULL,1,1,NULL),
(22,'date-entered-on-file','date-entered-on-file','',NULL,NULL,1,1,NULL),
(23,'number-govt-pub','number-govt-pub','',NULL,NULL,1,1,NULL),
(24,'report-number','report-number','',NULL,NULL,1,1,NULL),
(25,'lf','lf','',NULL,NULL,1,1,NULL),
(26,'reading-grade-level','reading-grade-level','',NULL,NULL,1,1,NULL),
(27,'title-former','title-former','',NULL,NULL,1,1,NULL),
(28,'microform-generation','microform-generation','',NULL,NULL,1,1,NULL),
(29,'lost','lost','',NULL,NULL,1,1,NULL),
(30,'identifier-other','identifier-other','',NULL,NULL,1,1,NULL),
(31,'cn-item','cn-item','',NULL,NULL,1,1,NULL),
(32,'author','author','string',NULL,1,1,1,NULL),
(33,'copydate','copydate','date',NULL,NULL,1,1,NULL),
(34,'title-expanded','title-expanded','',NULL,NULL,1,1,NULL),
(35,'conference-name','conference-name','',NULL,NULL,1,1,NULL),
(36,'barcode','barcode','',NULL,NULL,1,1,NULL),
(37,'dissertation-information','dissertation-information','',NULL,NULL,1,1,NULL),
(38,'stock-number','stock-number','',NULL,NULL,1,1,NULL),
(39,'curriculum','curriculum','',NULL,NULL,1,1,NULL),
(40,'udc-classification','udc-classification','',NULL,NULL,1,1,NULL),
(41,'withdrawn','withdrawn','',NULL,NULL,1,1,NULL),
(42,'editor','editor','',NULL,NULL,1,1,NULL),
(43,'material-type','material-type','',NULL,NULL,1,1,NULL),
(44,'ff7-00','ff7-00','',NULL,NULL,1,1,NULL),
(45,'lc-call-number','lc-call-number','',NULL,NULL,1,1,NULL),
(46,'title-uniform','title-uniform','',NULL,NULL,1,1,NULL),
(47,'publisher','publisher','string',NULL,NULL,1,1,NULL),
(48,'location','location','',NULL,3,1,1,NULL),
(49,'ta','ta','',NULL,NULL,1,1,NULL),
(50,'ccode','collection-code','',NULL,7,1,1,NULL),
(51,'replacementprice','replacementprice','',NULL,NULL,1,1,NULL),
(52,'dewey-classification','dewey-classification','',NULL,NULL,1,1,NULL),
(53,'date-time-last-modified','date-time-last-modified','',NULL,NULL,1,1,NULL),
(54,'materials-specified','materials-specified','',NULL,NULL,1,1,NULL),
(55,'itemnumber','itemnumber','number',NULL,NULL,1,1,NULL),
(56,'number-natl-biblio','number-natl-biblio','',NULL,NULL,1,1,NULL),
(57,'title-series','title-series','string',NULL,5,1,1,NULL),
(58,'biblioitemnumber','biblioitemnumber','',NULL,NULL,1,1,NULL),
(59,'nal-call-number','nal-call-number','',NULL,NULL,1,1,NULL),
(60,'date-of-acquisition','date-of-acquisition','date',NULL,NULL,1,1,NULL),
(61,'author-in-order','author-in-order','',NULL,NULL,1,1,NULL),
(62,'available','available','boolean',NULL,NULL,1,1,NULL),
(63,'onloan','onloan','boolean',NULL,NULL,1,1,NULL),
(64,'pl','pl','',NULL,NULL,1,1,NULL),
(65,'author-personal-bibliography','author-personal-bibliography','',NULL,NULL,1,1,NULL),
(66,'cn-bib-sort','cn-bib-sort','',NULL,NULL,1,1,NULL),
(67,'note','note','',NULL,NULL,1,1,NULL),
(68,'map-scale','map-scale','',NULL,NULL,1,1,NULL),
(69,'holdingbranch','holdinglibrary','string',NULL,8,1,1,NULL),
(70,'homebranch','homelibrary','string',NULL,9,1,1,NULL),
(71,'issn','issn','stdno',NULL,NULL,1,1,NULL),
(72,'identifier-standard','identifier-standard','stdno',NULL,NULL,1,1,NULL),
(73,'replacementpricedate','replacementpricedate','',NULL,NULL,1,1,NULL),
(74,'title','title','string',NULL,NULL,1,1,1),
(75,'author-name-corporate','author-name-corporate','',NULL,NULL,1,1,NULL),
(76,'bio','bio','',NULL,NULL,1,1,NULL),
(77,'related-periodical','related-periodical','',NULL,NULL,1,1,NULL),
(78,'host-item','host-item','',NULL,NULL,1,1,NULL),
(79,'title-collective','title-collective','',NULL,NULL,1,1,NULL),
(80,'ff8-23','ff8-23','',NULL,NULL,1,1,NULL),
(81,'uri','uri','',NULL,NULL,1,1,NULL),
(82,'interest-age-level','interest-age-level','',NULL,NULL,1,1,NULL),
(83,'koha-auth-number','koha-auth-number','',NULL,NULL,1,1,NULL),
(84,'suppress','suppress','boolean',NULL,NULL,1,1,NULL),
(85,'ff8-29','ff8-29','',NULL,NULL,1,1,NULL),
(86,'index-term-genre','index-term-genre','',NULL,NULL,1,1,NULL),
(87,'number-db','number-db','',NULL,NULL,1,1,NULL),
(88,'damaged','damaged','',NULL,NULL,1,1,NULL),
(89,'abstract','abstract','',NULL,NULL,1,1,NULL),
(90,'personal-name','personal-name','',NULL,NULL,1,1,NULL),
(91,'language-original','language-original','',NULL,NULL,1,1,NULL),
(92,'bgf-number','bgf-number','',NULL,NULL,1,1,NULL),
(93,'bnb-card-number','bnb-card-number','',NULL,NULL,1,1,NULL),
(94,'author-name-personal','author-name-personal','',NULL,NULL,1,1,NULL),
(95,'identifier-publisher-for-music','identifier-publisher-for-music','',NULL,NULL,1,1,NULL),
(96,'coden','coden','',NULL,NULL,1,1,NULL),
(97,'not-onloan-count','not-onloan-count','',NULL,NULL,1,1,NULL),
(98,'number-legal-deposit','number-legal-deposit','',NULL,NULL,1,1,NULL),
(99,'classification-source','classification-source','',NULL,NULL,1,1,NULL),
(100,'cross-reference','cross-reference','',NULL,NULL,1,1,NULL),
(101,'extent','extent','',NULL,NULL,1,1,NULL),
(102,'cn-suffix','cn-suffix','',NULL,NULL,1,1,NULL),
(103,'name-and-title','name-and-title','',NULL,NULL,1,1,NULL),
(104,'rtype','rtype','',NULL,NULL,1,1,NULL),
(105,'control-number','control-number','',NULL,NULL,1,1,NULL),
(106,'indexed-by','indexed-by','',NULL,NULL,1,1,NULL),
(107,'renewals','renewals','',NULL,NULL,1,1,NULL),
(108,'itype','itype','string',NULL,2,1,1,NULL),
(109,'local-classification','local-classification','',NULL,NULL,1,1,NULL),
(110,'title-other-variant','title-other-variant','',NULL,NULL,1,1,NULL),
(111,'cn-sort','cn-sort','callnumber',NULL,NULL,1,1,NULL),
(112,'price','price','',NULL,NULL,1,1,NULL),
(113,'ln','ln','',NULL,10,1,1,NULL),
(114,'date-of-publication','date-of-publication','',NULL,NULL,1,1,NULL),
(115,'title-cover','title-cover','',NULL,NULL,1,1,NULL),
(116,'datelastborrowed','datelastborrowed','',NULL,NULL,1,1,NULL),
(117,'title-abbreviated','title-abbreviated','',NULL,NULL,1,1,NULL),
(118,'bib-level','bib-level','',NULL,NULL,1,1,NULL),
(119,'lc-card-number','lc-card-number','',NULL,NULL,1,1,NULL),
(120,'interest-grade-level','interest-grade-level','',NULL,NULL,1,1,NULL),
(121,'ln-audio','ln-audio','',NULL,NULL,1,1,NULL),
(122,'cn-bib-source','cn-bib-source','',NULL,NULL,1,1,NULL),
(123,'arp','arp','',NULL,NULL,1,1,NULL),
(124,'copynumber','copynumber','',NULL,NULL,1,1,NULL),
(125,'cn-class','cn-class','',NULL,NULL,1,1,NULL),
(126,'host-item-number','host-item-number','number',NULL,NULL,1,1,NULL),
(127,'isbn','isbn','isbn',NULL,NULL,1,1,NULL),
(128,'issues','issues','sum',NULL,NULL,1,1,1),
(129,'title-key','title-key','',NULL,NULL,1,1,NULL),
(130,'thematic-number','thematic-number','',NULL,NULL,1,1,NULL),
(131,'record-source','record-source','',NULL,NULL,1,1,NULL),
(132,'subject-name-personal','subject-name-personal','',NULL,NULL,1,1,NULL),
(133,'code-geographic','code-geographic','',NULL,NULL,1,1,NULL),
(134,'name','name','',NULL,NULL,1,1,NULL),
(135,'music-key','music-key','',NULL,NULL,1,1,NULL),
(136,'code-institution','code-institution','',NULL,NULL,1,1,NULL),
(137,'local-number','local-number','number',NULL,NULL,1,1,NULL),
(138,'su-geo','su-geo','string',NULL,4,1,1,NULL),
(139,'geographic-class','geographic-class','',NULL,NULL,1,1,NULL),
(140,'ctype','ctype','',NULL,NULL,1,1,NULL),
(141,'cn-prefix','cn-prefix','',NULL,NULL,1,1,NULL),
(142,'lexile-number','lexile-number','',NULL,NULL,1,1,NULL),
(143,'control-number-identifier','control-number-identifier','',NULL,NULL,1,1,NULL),
(144,'arl','arl','',NULL,NULL,1,1,NULL),
(145,'other-control-number','other-control-number','',NULL,NULL,1,1,NULL),
(146,'name-geographic','name-geographic','',NULL,NULL,1,1,NULL),
(147,'index-term-uncontrolled','index-term-uncontrolled','',NULL,NULL,1,1,NULL),
(148,'corporate-name','corporate-name','',NULL,NULL,1,1,NULL),
(149,'Personal-name-heading','Personal-name-heading','',NULL,NULL,1,1,NULL),
(150,'Heading-Main','Heading-Main','',NULL,NULL,1,1,NULL),
(151,'Heading','Heading','',NULL,NULL,1,1,NULL),
(152,'Corporate-name-see-also-from','Corporate-name-see-also-from','',NULL,NULL,1,1,NULL),
(153,'Meeting-name-see-from','Meeting-name-see-from','',NULL,NULL,1,1,NULL),
(154,'Descriptive-cataloging-rules','Descriptive-cataloging-rules','',NULL,NULL,1,1,NULL),
(155,'Heading-use-main-or-added-entry','Heading-use-main-or-added-entry','',NULL,NULL,1,1,NULL),
(156,'Heading-use-series-added-entry','Heading-use-series-added-entry','',NULL,NULL,1,1,NULL),
(157,'Meeting-name-heading','Meeting-name-heading','',NULL,NULL,1,1,NULL),
(158,'Meeting-name-see-also-from','Meeting-name-see-also-from','',NULL,NULL,1,1,NULL),
(159,'Match','Match','',NULL,NULL,1,1,NULL),
(160,'Personal-name-see-also-from','Personal-name-see-also-from','',NULL,NULL,1,1,NULL),
(161,'Heading-use-subject-added-entry','Heading-use-subject-added-entry','',NULL,NULL,1,1,NULL),
(162,'See-also-from','See-also-from','',NULL,NULL,1,1,NULL),
(163,'authtype','authtype','',NULL,NULL,1,1,NULL),
(164,'Kind-of-record','Kind-of-record','',NULL,NULL,1,1,NULL),
(165,'Personal-name-see-from','Personal-name-see-from','',NULL,NULL,1,1,NULL),
(166,'Corporate-name-see-from','Corporate-name-see-from','',NULL,NULL,1,1,NULL),
(167,'Match-heading-see-from','Match-heading-see-from','',NULL,NULL,1,1,NULL),
(168,'See-from','See-from','',NULL,NULL,1,1,NULL),
(169,'Meeting-name','Meeting-name','',NULL,NULL,1,1,NULL);

--
-- Table structure for table `search_filters`
--

CREATE TABLE `search_filters` (
  `search_filter_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT 'filter name',
  `query` mediumtext DEFAULT NULL COMMENT 'filter query part',
  `limits` mediumtext DEFAULT NULL COMMENT 'filter limits part',
  `opac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown on OPAC',
  `staff_client` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown in staff client',
  PRIMARY KEY (`search_filter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_filters`
--


--
-- Table structure for table `search_history`
--

CREATE TABLE `search_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'search history id',
  `userid` int(11) NOT NULL COMMENT 'the patron who performed the search (borrowers.borrowernumber)',
  `sessionid` varchar(32) NOT NULL COMMENT 'a system generated session id',
  `query_desc` varchar(255) NOT NULL COMMENT 'the search that was performed',
  `query_cgi` mediumtext NOT NULL COMMENT 'the string to append to the search url to rerun the search',
  `type` varchar(16) NOT NULL DEFAULT 'biblio' COMMENT 'search type, must be ''biblio'' or ''authority''',
  `total` int(11) NOT NULL COMMENT 'the total of results found',
  `time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the search was run',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `sessionid` (`sessionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';

--
-- Dumping data for table `search_history`
--


--
-- Table structure for table `search_marc_map`
--

CREATE TABLE `search_marc_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `index_name` enum('biblios','authorities') NOT NULL COMMENT 'what storage index this map is for',
  `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for',
  `marc_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'the MARC specifier for this field',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_name` (`index_name`,`marc_field`(191),`marc_type`),
  KEY `index_name_2` (`index_name`)
) ENGINE=InnoDB AUTO_INCREMENT=485 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_marc_map`
--

INSERT INTO `search_marc_map` VALUES
(1,'biblios','marc21','100'),
(2,'biblios','marc21','110'),
(3,'biblios','marc21','111'),
(4,'biblios','marc21','400t'),
(5,'biblios','marc21','410t'),
(6,'biblios','marc21','411t'),
(7,'biblios','marc21','700t'),
(8,'biblios','marc21','710t'),
(9,'biblios','marc21','711t'),
(10,'biblios','marc21','800t'),
(11,'biblios','marc21','810t'),
(12,'biblios','marc21','811t'),
(13,'biblios','marc21','952f'),
(14,'biblios','marc21','952j'),
(15,'biblios','marc21','952i'),
(16,'biblios','marc21','952n'),
(17,'biblios','marc21','060'),
(18,'biblios','marc21','952r'),
(19,'biblios','marc21','9527'),
(20,'biblios','unimarc','995o'),
(21,'biblios','marc21','952e'),
(22,'biblios','marc21','785'),
(23,'biblios','marc21','9420'),
(24,'biblios','marc21','770w'),
(25,'biblios','marc21','772w'),
(26,'biblios','marc21','773w'),
(27,'biblios','marc21','774w'),
(28,'biblios','marc21','775w'),
(29,'biblios','marc21','776w'),
(30,'biblios','marc21','777w'),
(31,'biblios','marc21','780w'),
(32,'biblios','marc21','785w'),
(33,'biblios','marc21','787w'),
(34,'biblios','marc21','800w'),
(35,'biblios','marc21','810w'),
(36,'biblios','marc21','811w'),
(37,'biblios','marc21','830w'),
(38,'biblios','marc21','007_/1'),
(39,'biblios','marc21','9525'),
(40,'biblios','marc21','007_/0-1'),
(41,'biblios','marc21','007_/2'),
(42,'biblios','marc21','600a'),
(43,'biblios','marc21','600t'),
(44,'biblios','marc21','610a'),
(45,'biblios','marc21','610t'),
(46,'biblios','marc21','611'),
(47,'biblios','marc21','630n'),
(48,'biblios','marc21','630r'),
(49,'biblios','marc21','650a'),
(50,'biblios','marc21','650b'),
(51,'biblios','marc21','650c'),
(52,'biblios','marc21','650d'),
(53,'biblios','marc21','650v'),
(54,'biblios','marc21','650x'),
(55,'biblios','marc21','650y'),
(56,'biblios','marc21','650z'),
(57,'biblios','marc21','651'),
(58,'biblios','marc21','653a'),
(59,'biblios','unimarc','600'),
(60,'biblios','unimarc','600a'),
(61,'biblios','unimarc','601'),
(62,'biblios','unimarc','602'),
(63,'biblios','unimarc','604'),
(64,'biblios','unimarc','605'),
(65,'biblios','unimarc','606'),
(66,'biblios','unimarc','607'),
(67,'biblios','unimarc','608'),
(68,'biblios','unimarc','610'),
(69,'biblios','marc21','942c'),
(70,'biblios','marc21','leader_/0-4'),
(71,'biblios','marc21','041j'),
(72,'biblios','marc21','260'),
(73,'biblios','marc21','264'),
(74,'biblios','marc21','008_/0-5'),
(75,'biblios','unimarc','099c'),
(76,'biblios','marc21','086'),
(77,'biblios','marc21','027'),
(78,'biblios','marc21','008_/33'),
(79,'biblios','unimarc','105a_/11'),
(80,'biblios','marc21','521a'),
(81,'biblios','marc21','246'),
(82,'biblios','marc21','247'),
(83,'biblios','marc21','780'),
(84,'biblios','marc21','007_/11'),
(85,'biblios','marc21','9521'),
(86,'biblios','marc21','024a'),
(87,'biblios','marc21','942i'),
(88,'biblios','marc21','100a'),
(89,'biblios','marc21','110a'),
(90,'biblios','marc21','111a'),
(91,'biblios','marc21','245c'),
(92,'biblios','marc21','700a'),
(93,'biblios','marc21','710a'),
(94,'biblios','marc21','711a'),
(95,'biblios','unimarc','200f'),
(96,'biblios','unimarc','200g'),
(97,'biblios','unimarc','700a'),
(98,'biblios','unimarc','701'),
(99,'biblios','marc21','260c'),
(100,'biblios','marc21','264c'),
(101,'biblios','marc21','214'),
(102,'biblios','marc21','411'),
(103,'biblios','marc21','711'),
(104,'biblios','marc21','811'),
(105,'biblios','marc21','952p'),
(106,'biblios','marc21','502'),
(107,'biblios','marc21','037'),
(108,'biblios','marc21','658abc'),
(109,'biblios','marc21','080'),
(110,'biblios','marc21','9520'),
(111,'biblios','marc21','700'),
(112,'biblios','marc21','007'),
(113,'biblios','marc21','007_/0'),
(114,'biblios','marc21','050ab'),
(115,'biblios','marc21','130'),
(116,'biblios','marc21','240'),
(117,'biblios','marc21','730'),
(118,'biblios','marc21','260b'),
(119,'biblios','marc21','264b'),
(120,'biblios','unimarc','210c'),
(121,'biblios','marc21','952c'),
(122,'biblios','unimarc','995e'),
(123,'biblios','marc21','008_/22'),
(124,'biblios','unimarc','100a_/17'),
(125,'biblios','marc21','9528'),
(126,'biblios','unimarc','9958'),
(127,'biblios','marc21','952v'),
(128,'biblios','marc21','082'),
(129,'biblios','marc21','005'),
(130,'biblios','unimarc','099d'),
(131,'biblios','marc21','9523'),
(132,'biblios','marc21','9529'),
(133,'biblios','unimarc','9959'),
(134,'biblios','marc21','015'),
(135,'biblios','marc21','440a'),
(136,'biblios','marc21','490a'),
(137,'biblios','marc21','830a'),
(138,'biblios','unimarc','225a'),
(139,'biblios','marc21','999d'),
(140,'biblios','marc21','070'),
(141,'biblios','marc21','952d'),
(142,'biblios','unimarc','9955'),
(143,'biblios','marc21','952q'),
(144,'biblios','unimarc','995n'),
(145,'biblios','marc21','008_/15-17'),
(146,'biblios','marc21','9426'),
(147,'biblios','marc21','500'),
(148,'biblios','marc21','505'),
(149,'biblios','marc21','590'),
(150,'biblios','marc21','952z'),
(151,'biblios','marc21','034'),
(152,'biblios','marc21','952b'),
(153,'biblios','unimarc','995c'),
(154,'biblios','marc21','952a'),
(155,'biblios','unimarc','995b'),
(156,'biblios','marc21','022a'),
(157,'biblios','unimarc','011ayz'),
(158,'biblios','marc21','010'),
(159,'biblios','marc21','011'),
(160,'biblios','marc21','017'),
(161,'biblios','marc21','018'),
(162,'biblios','marc21','020a'),
(163,'biblios','unimarc','010az'),
(164,'biblios','marc21','952w'),
(165,'biblios','marc21','210'),
(166,'biblios','marc21','211'),
(167,'biblios','marc21','212'),
(168,'biblios','marc21','222'),
(169,'biblios','marc21','245abp'),
(170,'biblios','marc21','505t'),
(171,'biblios','marc21','740'),
(172,'biblios','unimarc','200a'),
(173,'biblios','unimarc','200c'),
(174,'biblios','unimarc','200d'),
(175,'biblios','unimarc','200e'),
(176,'biblios','unimarc','200h'),
(177,'biblios','unimarc','200i'),
(178,'biblios','unimarc','205'),
(179,'biblios','unimarc','304a'),
(180,'biblios','unimarc','327a'),
(181,'biblios','unimarc','327b'),
(182,'biblios','unimarc','327c'),
(183,'biblios','unimarc','327d'),
(184,'biblios','unimarc','327e'),
(185,'biblios','unimarc','327f'),
(186,'biblios','unimarc','327g'),
(187,'biblios','unimarc','327h'),
(188,'biblios','unimarc','327i'),
(189,'biblios','unimarc','328t'),
(190,'biblios','unimarc','410t'),
(191,'biblios','unimarc','411t'),
(192,'biblios','unimarc','412t'),
(193,'biblios','unimarc','413t'),
(194,'biblios','unimarc','421t'),
(195,'biblios','unimarc','422t'),
(196,'biblios','unimarc','423t'),
(197,'biblios','unimarc','424t'),
(198,'biblios','unimarc','425t'),
(199,'biblios','unimarc','430t'),
(200,'biblios','unimarc','431t'),
(201,'biblios','unimarc','432t'),
(202,'biblios','unimarc','433t'),
(203,'biblios','unimarc','434t'),
(204,'biblios','unimarc','435t'),
(205,'biblios','unimarc','436t'),
(206,'biblios','unimarc','437t'),
(207,'biblios','unimarc','440t'),
(208,'biblios','unimarc','441t'),
(209,'biblios','unimarc','442t'),
(210,'biblios','unimarc','443t'),
(211,'biblios','unimarc','444t'),
(212,'biblios','unimarc','445t'),
(213,'biblios','unimarc','446t'),
(214,'biblios','unimarc','447t'),
(215,'biblios','unimarc','448t'),
(216,'biblios','unimarc','451t'),
(217,'biblios','unimarc','452t'),
(218,'biblios','unimarc','453t'),
(219,'biblios','unimarc','454t'),
(220,'biblios','unimarc','455t'),
(221,'biblios','unimarc','456t'),
(222,'biblios','unimarc','461t'),
(223,'biblios','unimarc','462t'),
(224,'biblios','unimarc','463t'),
(225,'biblios','unimarc','464t'),
(226,'biblios','unimarc','470t'),
(227,'biblios','unimarc','481t'),
(228,'biblios','unimarc','482t'),
(229,'biblios','unimarc','488t'),
(230,'biblios','marc21','710'),
(231,'biblios','marc21','810'),
(232,'biblios','marc21','008_/34'),
(233,'biblios','unimarc','105a_/12'),
(234,'biblios','marc21','773at'),
(235,'biblios','marc21','243'),
(236,'biblios','marc21','008_/23'),
(237,'biblios','marc21','952u'),
(238,'biblios','marc21','1009'),
(239,'biblios','marc21','1109'),
(240,'biblios','marc21','1119'),
(241,'biblios','marc21','1309'),
(242,'biblios','marc21','2459'),
(243,'biblios','marc21','4009'),
(244,'biblios','marc21','4109'),
(245,'biblios','marc21','4409'),
(246,'biblios','marc21','4909'),
(247,'biblios','marc21','6009'),
(248,'biblios','marc21','6109'),
(249,'biblios','marc21','6119'),
(250,'biblios','marc21','6309'),
(251,'biblios','marc21','6489'),
(252,'biblios','marc21','6509'),
(253,'biblios','marc21','6519'),
(254,'biblios','marc21','6529'),
(255,'biblios','marc21','6539'),
(256,'biblios','marc21','6549'),
(257,'biblios','marc21','6559'),
(258,'biblios','marc21','6569'),
(259,'biblios','marc21','6579'),
(260,'biblios','marc21','6629'),
(261,'biblios','marc21','6909'),
(262,'biblios','marc21','6919'),
(263,'biblios','marc21','6969'),
(264,'biblios','marc21','6979'),
(265,'biblios','marc21','6989'),
(266,'biblios','marc21','6999'),
(267,'biblios','marc21','7009'),
(268,'biblios','marc21','7109'),
(269,'biblios','marc21','7119'),
(270,'biblios','marc21','7309'),
(271,'biblios','marc21','7519'),
(272,'biblios','marc21','7969'),
(273,'biblios','marc21','7979'),
(274,'biblios','marc21','7989'),
(275,'biblios','marc21','7999'),
(276,'biblios','marc21','8009'),
(277,'biblios','marc21','8109'),
(278,'biblios','marc21','8119'),
(279,'biblios','marc21','8309'),
(280,'biblios','marc21','8969'),
(281,'biblios','marc21','8979'),
(282,'biblios','marc21','8989'),
(283,'biblios','marc21','8999'),
(284,'biblios','marc21','942n'),
(285,'biblios','unimarc','955n'),
(286,'biblios','marc21','008_/29'),
(287,'biblios','unimarc','105a_/8'),
(288,'biblios','marc21','655avxyz'),
(289,'biblios','marc21','9524'),
(290,'biblios','marc21','520'),
(291,'biblios','marc21','400'),
(292,'biblios','marc21','800'),
(293,'biblios','marc21','041h'),
(294,'biblios','marc21','028'),
(295,'biblios','marc21','030'),
(296,'biblios','marc21','999x'),
(297,'biblios','unimarc','999x'),
(298,'biblios','marc21','9522'),
(299,'biblios','marc21','300'),
(300,'biblios','marc21','942m'),
(301,'biblios','marc21','400at'),
(302,'biblios','marc21','410a'),
(303,'biblios','marc21','411a'),
(304,'biblios','marc21','600at'),
(305,'biblios','marc21','610at'),
(306,'biblios','marc21','611at'),
(307,'biblios','marc21','710at'),
(308,'biblios','marc21','800at'),
(309,'biblios','marc21','810at'),
(310,'biblios','marc21','811at'),
(311,'biblios','marc21','leader_/6'),
(312,'biblios','marc21','001'),
(313,'biblios','marc21','510'),
(314,'biblios','marc21','952m'),
(315,'biblios','marc21','952y'),
(316,'biblios','unimarc','200b'),
(317,'biblios','unimarc','995r'),
(318,'biblios','marc21','952o'),
(319,'biblios','unimarc','686'),
(320,'biblios','unimarc','995k'),
(321,'biblios','marc21','9526'),
(322,'biblios','marc21','952g'),
(323,'biblios','marc21','008_/35-37'),
(324,'biblios','unimarc','101a'),
(325,'biblios','marc21','008_/7-10'),
(326,'biblios','unimarc','100a_/9-12'),
(327,'biblios','marc21','245a'),
(328,'biblios','marc21','952s'),
(329,'biblios','marc21','leader_/7'),
(330,'biblios','unimarc','995j'),
(331,'biblios','marc21','041a'),
(332,'biblios','marc21','9422'),
(333,'biblios','marc21','526d'),
(334,'biblios','marc21','952t'),
(335,'biblios','marc21','942h'),
(336,'biblios','marc21','7739'),
(337,'biblios','unimarc','4619'),
(338,'biblios','marc21','952l'),
(339,'biblios','marc21','130n'),
(340,'biblios','marc21','240n'),
(341,'biblios','marc21','243n'),
(342,'biblios','marc21','700n'),
(343,'biblios','marc21','730n'),
(344,'biblios','marc21','008_/39'),
(345,'biblios','marc21','043'),
(346,'biblios','marc21','610'),
(347,'biblios','marc21','130r'),
(348,'biblios','marc21','240r'),
(349,'biblios','marc21','243r'),
(350,'biblios','marc21','700r'),
(351,'biblios','marc21','730r'),
(352,'biblios','marc21','040'),
(353,'biblios','marc21','999c'),
(354,'biblios','unimarc','001'),
(355,'biblios','marc21','651a'),
(356,'biblios','unimarc','607a'),
(357,'biblios','marc21','052'),
(358,'biblios','marc21','008_/24-27'),
(359,'biblios','unimarc','105a_/4-7'),
(360,'biblios','marc21','942k'),
(361,'biblios','marc21','003'),
(362,'biblios','marc21','526c'),
(363,'biblios','marc21','035'),
(364,'biblios','marc21','751a'),
(365,'biblios','marc21','410'),
(366,'authorities','marc21','100(abcdefghjklmnopqrstvxyz)'),
(367,'authorities','marc21','100a'),
(368,'authorities','marc21','110a'),
(369,'authorities','marc21','111a'),
(370,'authorities','marc21','130a'),
(371,'authorities','marc21','148a'),
(372,'authorities','marc21','150a'),
(373,'authorities','marc21','151a'),
(374,'authorities','marc21','155a'),
(375,'authorities','unimarc','200a'),
(376,'authorities','unimarc','210a'),
(377,'authorities','unimarc','215a'),
(378,'authorities','unimarc','216a'),
(379,'authorities','unimarc','220a'),
(380,'authorities','unimarc','230a'),
(381,'authorities','unimarc','235a'),
(382,'authorities','unimarc','240a'),
(383,'authorities','unimarc','250a'),
(384,'authorities','unimarc','260a'),
(385,'authorities','unimarc','280a'),
(386,'authorities','marc21','110(abcdefghjklnpqstvxyz)'),
(387,'authorities','marc21','111(acdefghjklmnopqrstvxyz)'),
(388,'authorities','marc21','130(adefghjklnpqstvxyz)'),
(389,'authorities','marc21','148(abcdefghjklmnopqrstvxyz)'),
(390,'authorities','marc21','150(abgvxyz)'),
(391,'authorities','marc21','151(agvxyz)'),
(392,'authorities','marc21','155(avxyz)'),
(393,'authorities','unimarc','200(abcdfgjxyz)'),
(394,'authorities','unimarc','210(abcdefghjxyz)'),
(395,'authorities','unimarc','215(ajxyz)'),
(396,'authorities','unimarc','216(afcjxyz)'),
(397,'authorities','unimarc','220(afjxyz)'),
(398,'authorities','unimarc','230(abhijklmnqrsuwxyz)'),
(399,'authorities','unimarc','235(abejkmrsuwxyz)'),
(400,'authorities','unimarc','240(atjxyz)'),
(401,'authorities','unimarc','250(ajxyz)'),
(402,'authorities','unimarc','260(abcdjxyz)'),
(403,'authorities','unimarc','280(ajxyz)'),
(404,'authorities','marc21','510(abcdefghklmnoprstvxyz)'),
(405,'authorities','marc21','411(acdefghjklnpqstvxyz)'),
(406,'authorities','marc21','040(acd)'),
(407,'authorities','marc21','008_/10'),
(408,'authorities','marc21','008_/14'),
(409,'authorities','marc21','001'),
(410,'authorities','unimarc','001'),
(411,'authorities','marc21','008_/16'),
(412,'authorities','marc21','111(acdefghjklnpqstvxyz)'),
(413,'authorities','marc21','511(acdefghjklnpqstvxyz)'),
(414,'authorities','marc21','400(abcdefghjklmnopqrstvxyz)'),
(415,'authorities','marc21','410(abcdefghklmnoprstvxyz)'),
(416,'authorities','marc21','430(adfghklmnoprstvxyz)'),
(417,'authorities','marc21','448(avxyz)'),
(418,'authorities','marc21','450(abvxyz)'),
(419,'authorities','marc21','451(avxyz)'),
(420,'authorities','marc21','455(avxyz)'),
(421,'authorities','marc21','500(abcdefghjklmnopqrstvxyz)'),
(422,'authorities','marc21','530(adfghklmnoprstvxyz)'),
(423,'authorities','marc21','548(avxyz)'),
(424,'authorities','marc21','550(abvxyz)'),
(425,'authorities','marc21','551(avxyz)'),
(426,'authorities','marc21','555(avxyz)'),
(427,'authorities','unimarc','200(3478abcdfgjxyz)'),
(428,'authorities','unimarc','210(3478abcdefghxyz)'),
(429,'authorities','unimarc','215(78ajxyz)'),
(430,'authorities','unimarc','216(378acfjxyz)'),
(431,'authorities','unimarc','220(378afjxyz)'),
(432,'authorities','unimarc','230(8abhijklmqrsuwxyz)'),
(433,'authorities','unimarc','235(378abeijkmratsuwxyz)'),
(434,'authorities','unimarc','240(8abcfjtxyz)'),
(435,'authorities','unimarc','245(ajtxyz)'),
(436,'authorities','unimarc','250(8abcdjvxyz)'),
(437,'authorities','unimarc','260(378abcd)'),
(438,'authorities','unimarc','280(378ajxyz)'),
(439,'authorities','unimarc','400(0234568abcdfgjxyz)'),
(440,'authorities','unimarc','410(02345678abcdefghjxyz)'),
(441,'authorities','unimarc','415(0235678ajxyz)'),
(442,'authorities','unimarc','416(acfjxyz)'),
(443,'authorities','unimarc','420(afjxyz)'),
(444,'authorities','unimarc','430(0235678abhijklmnqrsuwxyz)'),
(445,'authorities','unimarc','435(0235678abejkmrsuwxyz)'),
(446,'authorities','unimarc','440(0235678abcdfjtxyz)'),
(447,'authorities','unimarc','445(ajtxyz)'),
(448,'authorities','unimarc','450(0235678ajxyz)'),
(449,'authorities','unimarc','460(abcd)'),
(450,'authorities','unimarc','480(ajxyz)'),
(451,'authorities','unimarc','500(023456789abcdfgjxyz)'),
(452,'authorities','unimarc','510(02345678abcdefghjxyz)'),
(453,'authorities','unimarc','515(0356789ajxyz)'),
(454,'authorities','unimarc','516(9acfjxyz)'),
(455,'authorities','unimarc','520(9afjxyz)'),
(456,'authorities','unimarc','530(02356789abhijklmnqrsuwxyz)'),
(457,'authorities','unimarc','535(02356789abjkmqrsuwxyz)'),
(458,'authorities','unimarc','540(0235678ajtxyz)'),
(459,'authorities','unimarc','545(9ajtxyz)'),
(460,'authorities','unimarc','550(02356789abjxyz)'),
(461,'authorities','unimarc','560(59abcd)'),
(462,'authorities','unimarc','580(59ajxyz)'),
(463,'authorities','unimarc','700(23478abcdfgjxyz)'),
(464,'authorities','unimarc','710(23478abcdefghjxyz)'),
(465,'authorities','unimarc','715(2378ajxyz)'),
(466,'authorities','unimarc','716(acfjxyz)'),
(467,'authorities','unimarc','720(afjxyz)'),
(468,'authorities','unimarc','730(2378abhijklmnqrsuwxyz)'),
(469,'authorities','unimarc','740(2378ajtxyz)'),
(470,'authorities','unimarc','745(378ajtxyz)'),
(471,'authorities','unimarc','750(23789abjxyz)'),
(472,'authorities','unimarc','760(abcd)'),
(473,'authorities','unimarc','780(ajxyz)'),
(474,'authorities','marc21','008_/15'),
(475,'authorities','marc21','547(acdgvxyz)'),
(476,'authorities','marc21','550(abgvxyz)'),
(477,'authorities','marc21','551(agvxyz)'),
(478,'authorities','marc21','562(avxyz)'),
(479,'authorities','marc21','010az'),
(480,'authorities','marc21','942a'),
(481,'authorities','unimarc','152b'),
(482,'authorities','marc21','008_/9'),
(483,'authorities','marc21','447(acdgvxyz)'),
(484,'authorities','marc21','462(abcdefghklmnoprstvxyz)');

--
-- Table structure for table `search_marc_to_field`
--

CREATE TABLE `search_marc_to_field` (
  `search` tinyint(1) NOT NULL DEFAULT 1,
  `search_marc_map_id` int(11) NOT NULL,
  `search_field_id` int(11) NOT NULL,
  `facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this',
  `suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse',
  `sort` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this',
  PRIMARY KEY (`search_marc_map_id`,`search_field_id`),
  KEY `search_field_id` (`search_field_id`),
  CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `search_marc_to_field_ibfk_2` FOREIGN KEY (`search_field_id`) REFERENCES `search_field` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_marc_to_field`
--

INSERT INTO `search_marc_to_field` VALUES
(1,1,1,0,0,1),
(1,1,90,0,0,1),
(1,1,94,0,0,1),
(1,1,103,0,0,1),
(1,1,134,0,0,1),
(1,2,1,0,0,1),
(1,2,75,0,0,1),
(1,2,103,0,0,1),
(1,2,134,0,0,1),
(1,2,148,0,0,1),
(1,3,1,0,0,1),
(1,3,35,0,0,1),
(1,3,75,0,0,1),
(1,3,103,0,0,1),
(1,3,134,0,0,1),
(1,4,1,0,0,1),
(1,5,1,0,0,1),
(1,6,1,0,0,1),
(1,7,1,0,0,1),
(1,7,46,0,0,1),
(1,7,74,0,1,1),
(1,7,103,0,0,1),
(1,8,1,0,0,1),
(1,8,46,0,0,1),
(1,8,74,0,1,1),
(1,9,1,0,0,1),
(1,9,46,0,0,1),
(1,9,74,0,1,1),
(1,10,1,0,0,1),
(1,10,57,1,0,1),
(1,11,1,0,0,1),
(1,11,57,1,0,1),
(1,12,1,0,0,1),
(1,12,57,1,0,1),
(1,13,2,0,0,1),
(1,14,3,0,0,1),
(1,15,4,0,0,1),
(1,16,5,0,0,1),
(1,17,6,0,0,0),
(1,18,7,0,0,1),
(1,19,8,0,0,0),
(1,20,8,0,0,0),
(1,21,9,0,0,1),
(1,22,10,0,0,1),
(1,22,74,0,0,1),
(1,22,77,0,0,1),
(1,23,11,0,0,1),
(1,24,12,0,0,1),
(1,25,12,0,0,1),
(1,26,12,0,0,1),
(1,27,12,0,0,1),
(1,28,12,0,0,1),
(1,29,12,0,0,1),
(1,30,12,0,0,1),
(1,31,12,0,0,1),
(1,32,12,0,0,1),
(1,33,12,0,0,1),
(1,34,12,0,0,1),
(1,35,12,0,0,1),
(1,36,12,0,0,1),
(1,37,12,0,0,1),
(1,38,13,0,0,1),
(1,39,14,0,0,1),
(1,40,15,0,0,1),
(1,41,16,0,0,1),
(1,42,17,1,1,1),
(1,42,90,0,0,1),
(1,42,132,0,0,1),
(1,42,134,0,0,1),
(1,43,17,1,1,1),
(1,44,17,1,1,1),
(1,45,17,1,1,1),
(1,46,17,1,1,1),
(1,46,35,0,0,1),
(1,46,134,0,0,1),
(1,47,17,1,1,1),
(1,47,130,0,0,1),
(1,48,17,1,1,1),
(1,48,135,0,0,1),
(1,49,17,1,1,1),
(1,50,17,1,1,1),
(1,51,17,1,1,1),
(1,52,17,1,1,1),
(1,53,17,1,1,1),
(1,54,17,1,1,1),
(1,55,17,1,1,1),
(1,56,17,1,1,1),
(1,57,17,1,1,1),
(1,57,146,0,0,1),
(1,58,17,1,1,1),
(1,58,147,0,0,1),
(1,59,17,1,1,1),
(1,60,17,1,1,1),
(1,61,17,1,1,1),
(1,62,17,1,1,1),
(1,63,17,1,1,1),
(1,64,17,1,1,1),
(1,65,17,1,1,1),
(1,66,17,1,1,1),
(1,67,17,1,1,1),
(1,68,17,1,1,1),
(1,69,18,0,0,1),
(1,69,108,1,0,1),
(1,70,19,0,0,1),
(1,71,20,0,0,1),
(1,72,21,0,0,1),
(1,73,21,0,0,1),
(1,74,22,0,0,1),
(1,75,22,0,0,1),
(1,76,23,0,0,1),
(1,77,24,0,0,1),
(1,78,25,0,0,1),
(1,79,25,0,0,1),
(1,80,26,0,0,1),
(1,80,82,0,0,1),
(1,80,120,0,0,1),
(1,80,142,0,0,1),
(1,81,27,0,0,1),
(1,81,34,0,0,1),
(1,81,74,0,1,1),
(1,81,117,0,0,1),
(1,82,27,0,0,1),
(1,82,74,0,1,1),
(1,82,77,0,0,1),
(1,82,110,0,0,1),
(1,83,27,0,0,1),
(1,83,74,0,0,1),
(1,83,77,0,0,1),
(1,84,28,0,0,1),
(1,85,29,0,0,1),
(1,86,30,0,0,1),
(1,87,31,0,0,1),
(1,88,32,1,1,1),
(1,88,42,0,0,1),
(1,88,65,0,0,1),
(1,89,32,1,1,1),
(1,90,32,1,1,1),
(1,91,32,0,0,1),
(1,91,61,0,0,1),
(1,92,32,1,1,1),
(1,93,32,1,1,1),
(1,94,32,1,1,1),
(1,94,103,0,0,1),
(1,95,32,1,1,1),
(1,96,32,1,1,1),
(1,97,32,1,1,1),
(1,98,32,0,0,1),
(1,99,33,1,0,1),
(1,100,33,1,0,1),
(1,101,34,0,0,1),
(1,101,74,0,0,1),
(1,102,35,0,0,1),
(1,103,35,0,0,1),
(1,103,75,0,0,1),
(1,103,134,0,0,1),
(1,104,35,0,0,1),
(1,104,75,0,0,1),
(1,104,134,0,0,1),
(1,105,36,0,0,1),
(1,106,37,0,0,1),
(1,107,38,0,0,1),
(1,108,39,0,0,1),
(1,109,40,0,0,1),
(1,110,41,0,0,1),
(1,111,42,0,0,1),
(1,111,90,0,0,1),
(1,111,94,0,0,1),
(1,111,134,0,0,0),
(1,112,43,0,0,1),
(1,113,44,0,0,1),
(1,114,45,0,0,1),
(1,115,46,0,0,1),
(1,115,74,0,0,1),
(1,116,46,0,0,1),
(1,116,74,0,0,1),
(1,117,46,0,0,1),
(1,117,74,0,0,1),
(1,118,47,1,0,1),
(1,119,47,1,0,1),
(1,120,47,1,0,1),
(1,121,48,1,0,0),
(1,122,48,1,0,0),
(1,123,49,0,0,1),
(1,124,49,0,0,1),
(1,125,50,1,0,1),
(1,126,50,1,0,1),
(1,127,51,0,0,1),
(1,128,52,0,0,1),
(1,129,53,0,0,1),
(1,130,53,0,0,1),
(1,131,54,0,0,1),
(1,132,55,0,0,0),
(1,133,55,0,0,0),
(1,134,56,0,0,1),
(1,134,72,0,0,1),
(1,134,87,0,0,1),
(1,134,92,0,0,1),
(1,134,93,0,0,1),
(1,135,57,1,0,1),
(1,136,57,1,0,1),
(1,136,74,0,1,1),
(1,137,57,1,0,1),
(1,138,57,1,0,1),
(1,139,58,0,0,1),
(1,140,59,0,0,1),
(1,141,60,0,0,1),
(1,142,60,0,0,1),
(1,143,63,0,0,0),
(1,144,63,0,0,0),
(1,145,64,0,0,1),
(1,146,66,0,0,1),
(1,147,67,0,0,1),
(1,148,67,0,0,1),
(1,149,67,0,0,1),
(1,150,67,0,0,1),
(1,151,68,0,0,1),
(1,152,69,1,0,0),
(1,153,69,0,0,0),
(1,154,70,1,0,0),
(1,155,70,1,0,0),
(1,156,71,0,0,1),
(1,156,72,0,0,1),
(1,157,71,0,0,1),
(1,157,72,0,0,1),
(1,158,72,0,0,1),
(1,158,119,0,0,1),
(1,159,72,0,0,1),
(1,159,119,0,0,1),
(1,160,72,0,0,1),
(1,160,98,0,0,1),
(1,161,72,0,0,1),
(1,162,72,0,0,1),
(1,162,127,0,0,1),
(1,163,72,0,0,1),
(1,163,127,0,0,1),
(1,164,73,0,0,1),
(1,165,74,0,0,1),
(1,165,117,0,0,1),
(1,166,74,0,0,1),
(1,166,117,0,0,1),
(1,167,74,0,0,1),
(1,167,110,0,0,1),
(1,168,74,0,0,1),
(1,168,129,0,0,1),
(1,169,74,0,1,1),
(1,170,74,0,1,1),
(1,171,74,0,0,1),
(1,171,110,0,0,1),
(1,172,74,0,1,1),
(1,173,74,0,1,1),
(1,174,74,0,1,1),
(1,175,74,0,1,1),
(1,176,74,0,1,1),
(1,177,74,0,1,1),
(1,178,74,0,1,1),
(1,179,74,0,1,1),
(1,180,74,0,0,1),
(1,181,74,0,0,1),
(1,182,74,0,0,1),
(1,183,74,0,0,1),
(1,184,74,0,0,1),
(1,185,74,0,0,1),
(1,186,74,0,0,1),
(1,187,74,0,0,1),
(1,188,74,0,0,1),
(1,189,74,0,0,1),
(1,190,74,0,0,1),
(1,191,74,0,0,1),
(1,192,74,0,0,1),
(1,193,74,0,0,1),
(1,194,74,0,0,1),
(1,195,74,0,0,1),
(1,196,74,0,0,1),
(1,197,74,0,0,1),
(1,198,74,0,0,1),
(1,199,74,0,0,1),
(1,200,74,0,0,1),
(1,201,74,0,0,1),
(1,202,74,0,0,1),
(1,203,74,0,0,1),
(1,204,74,0,0,1),
(1,205,74,0,0,1),
(1,206,74,0,0,1),
(1,207,74,0,0,1),
(1,208,74,0,0,1),
(1,209,74,0,0,1),
(1,210,74,0,0,1),
(1,211,74,0,0,1),
(1,212,74,0,0,1),
(1,213,74,0,0,1),
(1,214,74,0,0,1),
(1,215,74,0,0,1),
(1,216,74,0,0,1),
(1,217,74,0,0,1),
(1,218,74,0,0,1),
(1,219,74,0,0,1),
(1,220,74,0,0,1),
(1,221,74,0,0,1),
(1,222,74,0,0,1),
(1,223,74,0,0,1),
(1,224,74,0,0,1),
(1,225,74,0,0,1),
(1,226,74,0,0,1),
(1,227,74,0,0,1),
(1,228,74,0,0,1),
(1,229,74,0,0,1),
(1,230,75,0,0,1),
(1,230,134,0,0,1),
(1,230,148,0,0,1),
(1,231,75,0,0,1),
(1,231,134,0,0,1),
(1,231,148,0,0,1),
(1,232,76,0,0,1),
(1,233,76,0,0,1),
(1,234,78,0,0,1),
(1,235,79,0,0,1),
(1,236,80,0,0,1),
(1,237,81,0,0,1),
(1,238,83,0,0,1),
(1,238,100,0,0,1),
(1,239,83,0,0,1),
(1,240,83,0,0,1),
(1,241,83,0,0,1),
(1,242,83,0,0,1),
(1,242,100,0,0,1),
(1,243,83,0,0,1),
(1,244,83,0,0,1),
(1,245,83,0,0,1),
(1,246,83,0,0,1),
(1,247,83,0,0,1),
(1,248,83,0,0,1),
(1,249,83,0,0,1),
(1,250,83,0,0,1),
(1,251,83,0,0,1),
(1,252,83,0,0,1),
(1,253,83,0,0,1),
(1,254,83,0,0,1),
(1,255,83,0,0,1),
(1,256,83,0,0,1),
(1,257,83,0,0,1),
(1,258,83,0,0,1),
(1,259,83,0,0,1),
(1,260,83,0,0,1),
(1,261,83,0,0,1),
(1,262,83,0,0,1),
(1,263,83,0,0,1),
(1,264,83,0,0,1),
(1,265,83,0,0,1),
(1,266,83,0,0,1),
(1,267,83,0,0,1),
(1,267,100,0,0,1),
(1,268,83,0,0,1),
(1,269,83,0,0,1),
(1,270,83,0,0,1),
(1,271,83,0,0,1),
(1,272,83,0,0,1),
(1,273,83,0,0,1),
(1,274,83,0,0,1),
(1,275,83,0,0,1),
(1,276,83,0,0,1),
(1,277,83,0,0,1),
(1,278,83,0,0,1),
(1,279,83,0,0,1),
(1,280,83,0,0,1),
(1,281,83,0,0,1),
(1,282,83,0,0,1),
(1,283,83,0,0,1),
(1,284,84,0,0,1),
(1,285,84,0,0,1),
(1,286,85,0,0,1),
(1,287,85,0,0,1),
(1,288,86,0,0,1),
(1,289,88,0,0,1),
(1,290,89,0,0,1),
(1,291,90,0,0,1),
(1,291,94,0,0,1),
(1,291,134,0,0,1),
(1,292,90,0,0,1),
(1,292,94,0,0,1),
(1,292,134,0,0,1),
(1,293,91,0,0,1),
(1,294,95,0,0,1),
(1,295,96,0,0,1),
(1,296,97,0,0,1),
(1,297,97,0,0,1),
(1,298,99,0,0,1),
(1,299,101,0,0,1),
(1,300,102,0,0,1),
(1,301,103,0,0,1),
(1,302,103,0,0,1),
(1,303,103,0,0,1),
(1,304,103,0,0,1),
(1,305,103,0,0,1),
(1,306,103,0,0,1),
(1,307,103,0,0,1),
(1,308,103,0,0,1),
(1,309,103,0,0,1),
(1,310,103,0,0,1),
(1,311,104,0,0,1),
(1,312,105,0,0,1),
(1,313,106,0,0,1),
(1,314,107,0,0,1),
(1,315,108,1,0,1),
(1,316,108,1,0,1),
(1,317,108,1,0,1),
(1,318,109,0,1,0),
(1,319,109,0,0,0),
(1,320,109,0,1,0),
(1,321,111,0,0,1),
(1,322,112,0,0,1),
(1,323,113,1,0,1),
(1,324,113,1,0,1),
(1,325,114,0,0,1),
(1,326,114,0,0,1),
(1,327,115,0,0,1),
(1,328,116,0,0,1),
(1,329,118,0,0,1),
(1,330,119,0,0,1),
(1,331,121,0,0,1),
(1,332,122,0,0,1),
(1,333,123,0,0,1),
(1,334,124,0,0,1),
(1,335,125,0,0,1),
(1,336,126,0,0,1),
(1,337,126,0,0,1),
(1,338,128,0,0,1),
(1,339,130,0,0,1),
(1,340,130,0,0,1),
(1,341,130,0,0,1),
(1,342,130,0,0,1),
(1,343,130,0,0,1),
(1,344,131,0,0,1),
(1,345,133,0,0,1),
(1,346,134,0,0,1),
(1,346,148,0,0,1),
(1,347,135,0,0,1),
(1,348,135,0,0,1),
(1,349,135,0,0,1),
(1,350,135,0,0,1),
(1,351,135,0,0,1),
(1,352,136,0,0,1),
(1,353,137,0,0,1),
(1,354,137,0,0,1),
(1,355,138,1,0,1),
(1,356,138,1,0,1),
(1,357,139,0,0,1),
(1,358,140,0,0,1),
(1,359,140,0,0,1),
(1,360,141,0,0,1),
(1,361,143,0,0,1),
(1,362,144,0,0,1),
(1,363,145,0,0,1),
(1,364,146,0,0,1),
(1,365,148,0,0,1),
(1,366,90,0,0,1),
(1,366,149,0,0,1),
(1,366,151,0,0,1),
(1,366,159,0,0,1),
(1,367,150,0,0,1),
(1,368,150,0,0,1),
(1,369,150,0,0,1),
(1,370,150,0,0,1),
(1,371,150,0,0,1),
(1,372,150,0,0,1),
(1,373,150,0,0,1),
(1,374,150,0,0,1),
(1,375,150,0,0,1),
(1,376,150,0,0,1),
(1,377,150,0,0,1),
(1,378,150,0,0,1),
(1,379,150,0,0,1),
(1,380,150,0,0,1),
(1,381,150,0,0,1),
(1,382,150,0,0,1),
(1,383,150,0,0,1),
(1,384,150,0,0,1),
(1,385,150,0,0,1),
(1,386,151,0,0,1),
(1,387,151,0,0,1),
(1,388,151,0,0,1),
(1,389,151,0,0,1),
(1,390,151,0,0,1),
(1,391,151,0,0,1),
(1,392,151,0,0,1),
(1,393,151,0,0,1),
(1,394,151,0,0,1),
(1,395,151,0,0,1),
(1,396,151,0,0,1),
(1,397,151,0,0,1),
(1,398,151,0,0,1),
(1,399,151,0,0,1),
(1,400,151,0,0,1),
(1,401,151,0,0,1),
(1,402,151,0,0,1),
(1,403,151,0,0,1),
(1,404,152,0,0,1),
(1,404,159,0,0,1),
(1,404,162,0,0,1),
(1,405,153,0,0,1),
(1,405,159,0,0,1),
(1,405,167,0,0,1),
(1,405,168,0,0,1),
(1,406,131,0,0,1),
(1,407,154,0,0,1),
(1,408,155,0,0,1),
(1,409,137,0,0,1),
(1,410,137,0,0,1),
(1,411,156,0,0,1),
(1,412,157,0,0,1),
(1,412,159,0,0,1),
(1,412,169,0,0,1),
(1,413,158,0,0,1),
(1,413,159,0,0,1),
(1,413,162,0,0,1),
(1,414,159,0,0,1),
(1,414,165,0,0,1),
(1,414,167,0,0,1),
(1,414,168,0,0,1),
(1,415,159,0,0,1),
(1,415,166,0,0,1),
(1,415,167,0,0,1),
(1,415,168,0,0,1),
(1,416,159,0,0,1),
(1,416,167,0,0,1),
(1,416,168,0,0,1),
(1,417,159,0,0,1),
(1,417,167,0,0,1),
(1,417,168,0,0,1),
(1,418,159,0,0,1),
(1,418,167,0,0,1),
(1,418,168,0,0,1),
(1,419,159,0,0,1),
(1,419,167,0,0,1),
(1,419,168,0,0,1),
(1,420,159,0,0,1),
(1,420,167,0,0,1),
(1,420,168,0,0,1),
(1,421,159,0,0,1),
(1,421,160,0,0,1),
(1,421,162,0,0,1),
(1,422,159,0,0,1),
(1,422,162,0,0,1),
(1,423,159,0,0,1),
(1,423,162,0,0,1),
(1,424,159,0,0,1),
(1,425,159,0,0,1),
(1,426,159,0,0,1),
(1,426,162,0,0,1),
(1,427,159,0,0,1),
(1,428,159,0,0,1),
(1,429,159,0,0,1),
(1,430,159,0,0,1),
(1,431,159,0,0,1),
(1,432,159,0,0,1),
(1,433,159,0,0,1),
(1,434,159,0,0,1),
(1,435,159,0,0,1),
(1,436,159,0,0,1),
(1,437,159,0,0,1),
(1,438,159,0,0,1),
(1,439,159,0,0,1),
(1,440,159,0,0,1),
(1,441,159,0,0,1),
(1,442,159,0,0,1),
(1,443,159,0,0,1),
(1,444,159,0,0,1),
(1,445,159,0,0,1),
(1,446,159,0,0,1),
(1,447,159,0,0,1),
(1,448,159,0,0,1),
(1,449,159,0,0,1),
(1,450,159,0,0,1),
(1,451,159,0,0,1),
(1,452,159,0,0,1),
(1,453,159,0,0,1),
(1,454,159,0,0,1),
(1,455,159,0,0,1),
(1,456,159,0,0,1),
(1,457,159,0,0,1),
(1,458,159,0,0,1),
(1,459,159,0,0,1),
(1,460,159,0,0,1),
(1,461,159,0,0,1),
(1,462,159,0,0,1),
(1,463,159,0,0,1),
(1,464,159,0,0,1),
(1,465,159,0,0,1),
(1,466,159,0,0,1),
(1,467,159,0,0,1),
(1,468,159,0,0,1),
(1,469,159,0,0,1),
(1,470,159,0,0,1),
(1,471,159,0,0,1),
(1,472,159,0,0,1),
(1,473,159,0,0,1),
(1,474,161,0,0,1),
(1,475,162,0,0,1),
(1,476,162,0,0,1),
(1,477,162,0,0,1),
(1,478,162,0,0,1),
(1,479,119,0,0,1),
(1,480,163,0,0,1),
(1,481,163,0,0,1),
(1,482,164,0,0,1),
(1,483,168,0,0,1),
(1,484,168,0,0,1);

--
-- Table structure for table `serial`
--

CREATE TABLE `serial` (
  `serialid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the issue',
  `biblionumber` int(11) NOT NULL COMMENT 'foreign key for the biblio.biblionumber that this issue is attached to',
  `subscriptionid` int(11) NOT NULL COMMENT 'foreign key to the subscription.subscriptionid that this issue is part of',
  `serialseq` varchar(100) NOT NULL DEFAULT '' COMMENT 'issue information (volume, number, etc)',
  `serialseq_x` varchar(100) DEFAULT NULL COMMENT 'first part of issue information',
  `serialseq_y` varchar(100) DEFAULT NULL COMMENT 'second part of issue information',
  `serialseq_z` varchar(100) DEFAULT NULL COMMENT 'third part of issue information',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'status code for this issue (see manual for full descriptions)',
  `planneddate` date DEFAULT NULL COMMENT 'date expected',
  `notes` mediumtext DEFAULT NULL COMMENT 'notes',
  `publisheddate` date DEFAULT NULL COMMENT 'date published',
  `publisheddatetext` varchar(100) DEFAULT NULL COMMENT 'date published (descriptive)',
  `claimdate` date DEFAULT NULL COMMENT 'date claimed',
  `claims_count` int(11) DEFAULT 0 COMMENT 'number of claims made related to this issue',
  `routingnotes` mediumtext DEFAULT NULL COMMENT 'notes from the routing list',
  PRIMARY KEY (`serialid`),
  KEY `serial_ibfk_1` (`biblionumber`),
  KEY `serial_ibfk_2` (`subscriptionid`),
  CONSTRAINT `serial_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `serial_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `serial`
--


--
-- Table structure for table `serialitems`
--

CREATE TABLE `serialitems` (
  `itemnumber` int(11) NOT NULL,
  `serialid` int(11) NOT NULL,
  PRIMARY KEY (`itemnumber`),
  KEY `serialitems_sfk_1` (`serialid`),
  CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `serialitems`
--


--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(32) NOT NULL,
  `a_session` longblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `sms_providers`
--

CREATE TABLE `sms_providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `domain` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_providers`
--


--
-- Table structure for table `smtp_servers`
--

CREATE TABLE `smtp_servers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
  `port` int(11) NOT NULL DEFAULT 25,
  `timeout` int(11) NOT NULL DEFAULT 120,
  `ssl_mode` enum('disabled','ssl','starttls') NOT NULL,
  `user_name` varchar(80) DEFAULT NULL,
  `password` varchar(80) DEFAULT NULL,
  `debug` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `host_idx` (`host`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smtp_servers`
--


--
-- Table structure for table `social_data`
--

CREATE TABLE `social_data` (
  `isbn` varchar(30) NOT NULL DEFAULT '',
  `num_critics` int(11) DEFAULT NULL,
  `num_critics_pro` int(11) DEFAULT NULL,
  `num_quotations` int(11) DEFAULT NULL,
  `num_videos` int(11) DEFAULT NULL,
  `score_avg` decimal(5,2) DEFAULT NULL,
  `num_scores` int(11) DEFAULT NULL,
  PRIMARY KEY (`isbn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_data`
--


--
-- Table structure for table `special_holidays`
--

CREATE TABLE `special_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for',
  `day` smallint(6) NOT NULL DEFAULT 0 COMMENT 'day of the month this closing is on',
  `month` smallint(6) NOT NULL DEFAULT 0 COMMENT 'month this closing is in',
  `year` smallint(6) NOT NULL DEFAULT 0 COMMENT 'year this closing is in',
  `isexception` smallint(1) NOT NULL DEFAULT 1 COMMENT 'is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'title for this closing',
  `description` mediumtext NOT NULL COMMENT 'description of this closing',
  PRIMARY KEY (`id`),
  KEY `special_holidays_ibfk_1` (`branchcode`),
  CONSTRAINT `special_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `special_holidays`
--


--
-- Table structure for table `statistics`
--

CREATE TABLE `statistics` (
  `datetime` datetime DEFAULT NULL COMMENT 'date and time of the transaction',
  `branch` varchar(10) DEFAULT NULL COMMENT 'foreign key, branch where the transaction occurred',
  `value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction',
  `type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)',
  `other` longtext DEFAULT NULL COMMENT 'used by SIP',
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item',
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type',
  `location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower',
  `ccode` varchar(80) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code',
  `categorycode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',
  KEY `timeidx` (`datetime`),
  KEY `branch_idx` (`branch`),
  KEY `type_idx` (`type`),
  KEY `itemnumber_idx` (`itemnumber`),
  KEY `itemtype_idx` (`itemtype`),
  KEY `borrowernumber_idx` (`borrowernumber`),
  KEY `ccode_idx` (`ccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statistics`
--


--
-- Table structure for table `stockrotationitems`
--

CREATE TABLE `stockrotationitems` (
  `itemnumber_id` int(11) NOT NULL COMMENT 'Itemnumber to link to a stage & rota',
  `stage_id` int(11) NOT NULL COMMENT 'stage ID to link the item to',
  `indemand` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should this item be skipped for rotation?',
  `fresh` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Flag showing item is only just added to rota',
  PRIMARY KEY (`itemnumber_id`),
  KEY `stockrotationitems_sifk` (`stage_id`),
  CONSTRAINT `stockrotationitems_iifk` FOREIGN KEY (`itemnumber_id`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `stockrotationitems_sifk` FOREIGN KEY (`stage_id`) REFERENCES `stockrotationstages` (`stage_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stockrotationitems`
--


--
-- Table structure for table `stockrotationrotas`
--

CREATE TABLE `stockrotationrotas` (
  `rota_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Stockrotation rota ID',
  `title` varchar(100) NOT NULL COMMENT 'Title for this rota',
  `description` text NOT NULL COMMENT 'Description for this rota',
  `cyclical` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should items on this rota keep cycling?',
  `active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this rota currently active?',
  PRIMARY KEY (`rota_id`),
  UNIQUE KEY `stockrotationrotas_title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stockrotationrotas`
--


--
-- Table structure for table `stockrotationstages`
--

CREATE TABLE `stockrotationstages` (
  `stage_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique stage ID',
  `position` int(11) NOT NULL COMMENT 'The position of this stage within its rota',
  `rota_id` int(11) NOT NULL COMMENT 'The rota this stage belongs to',
  `branchcode_id` varchar(10) NOT NULL COMMENT 'Branch this stage relates to',
  `duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items shoud occupy this stage',
  PRIMARY KEY (`stage_id`),
  KEY `stockrotationstages_rifk` (`rota_id`),
  KEY `stockrotationstages_bifk` (`branchcode_id`),
  CONSTRAINT `stockrotationstages_bifk` FOREIGN KEY (`branchcode_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `stockrotationstages_rifk` FOREIGN KEY (`rota_id`) REFERENCES `stockrotationrotas` (`rota_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stockrotationstages`
--


--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `biblionumber` int(11) NOT NULL COMMENT 'foreign key for biblio.biblionumber that this subscription is attached to',
  `subscriptionid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for this subscription',
  `librarian` varchar(100) DEFAULT '' COMMENT 'the librarian''s username from borrowers.userid',
  `startdate` date DEFAULT NULL COMMENT 'start date for this subscription',
  `aqbooksellerid` int(11) DEFAULT 0 COMMENT 'foreign key for aqbooksellers.id to link to the vendor',
  `cost` int(11) DEFAULT 0,
  `aqbudgetid` int(11) DEFAULT 0,
  `weeklength` int(11) DEFAULT 0 COMMENT 'subscription length in weeks (will not be filled in if monthlength or numberlength is set)',
  `monthlength` int(11) DEFAULT 0 COMMENT 'subscription length in weeks (will not be filled in if weeklength or numberlength is set)',
  `numberlength` int(11) DEFAULT 0 COMMENT 'subscription length in weeks (will not be filled in if monthlength or weeklength is set)',
  `periodicity` int(11) DEFAULT NULL COMMENT 'frequency type links to subscription_frequencies.id',
  `countissuesperunit` int(11) NOT NULL DEFAULT 1,
  `notes` longtext DEFAULT NULL COMMENT 'notes',
  `status` varchar(100) NOT NULL DEFAULT '' COMMENT 'status of this subscription',
  `lastvalue1` int(11) DEFAULT NULL,
  `innerloop1` int(11) DEFAULT 0,
  `lastvalue2` int(11) DEFAULT NULL,
  `innerloop2` int(11) DEFAULT 0,
  `lastvalue3` int(11) DEFAULT NULL,
  `innerloop3` int(11) DEFAULT 0,
  `firstacquidate` date DEFAULT NULL COMMENT 'first issue received date',
  `manualhistory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes or no to managing the history manually',
  `irregularity` mediumtext DEFAULT NULL COMMENT 'any irregularities in the subscription',
  `skip_serialseq` tinyint(1) NOT NULL DEFAULT 0,
  `letter` varchar(20) DEFAULT NULL,
  `numberpattern` int(11) DEFAULT NULL COMMENT 'the numbering pattern used links to subscription_numberpatterns.id',
  `locale` varchar(80) DEFAULT NULL COMMENT 'for foreign language subscriptions to display months, seasons, etc correctly',
  `distributedto` mediumtext DEFAULT NULL,
  `internalnotes` longtext DEFAULT NULL,
  `callnumber` mediumtext DEFAULT NULL COMMENT 'default call number',
  `location` varchar(80) DEFAULT '' COMMENT 'default shelving location (items.location)',
  `branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)',
  `lastbranch` varchar(10) DEFAULT NULL,
  `serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record',
  `staffdisplaycount` int(11) DEFAULT NULL COMMENT 'how many issues to show to the staff',
  `opacdisplaycount` int(11) DEFAULT NULL COMMENT 'how many issues to show to the public',
  `graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days',
  `enddate` date DEFAULT NULL COMMENT 'subscription end date',
  `closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed',
  `reneweddate` date DEFAULT NULL COMMENT 'date of last renewal for the subscription',
  `itemtype` varchar(10) DEFAULT NULL,
  `previousitemtype` varchar(10) DEFAULT NULL,
  `mana_id` int(11) DEFAULT NULL,
  `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items',
  PRIMARY KEY (`subscriptionid`),
  KEY `subscription_ibfk_1` (`periodicity`),
  KEY `subscription_ibfk_2` (`numberpattern`),
  KEY `subscription_ibfk_3` (`biblionumber`),
  CONSTRAINT `subscription_ibfk_1` FOREIGN KEY (`periodicity`) REFERENCES `subscription_frequencies` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `subscription_ibfk_2` FOREIGN KEY (`numberpattern`) REFERENCES `subscription_numberpatterns` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `subscription_ibfk_3` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription`
--


--
-- Table structure for table `subscription_frequencies`
--

CREATE TABLE `subscription_frequencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` mediumtext NOT NULL,
  `displayorder` int(11) DEFAULT NULL,
  `unit` enum('day','week','month','year') DEFAULT NULL,
  `unitsperissue` int(11) NOT NULL DEFAULT 1,
  `issuesperunit` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_frequencies`
--

INSERT INTO `subscription_frequencies` VALUES
(1,'2/día',1,'day',1,2),
(2,'1/día',2,'day',1,1),
(3,'3/semana',3,'week',1,3),
(4,'1/semana',4,'week',1,1),
(5,'1/2 semana',5,'week',2,1),
(6,'1/3 semanas',6,'week',3,1),
(7,'1/mes',7,'month',1,1),
(8,'1/2 meses',8,'month',2,1),
(9,'1/3 meses',9,'month',3,1),
(10,'2/año',10,'month',6,1),
(11,'1/año',11,'year',1,1),
(12,'1/2 año',12,'year',2,1),
(13,'Irregular',13,NULL,1,1);

--
-- Table structure for table `subscription_numberpatterns`
--

CREATE TABLE `subscription_numberpatterns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `displayorder` int(11) DEFAULT NULL,
  `description` mediumtext NOT NULL,
  `numberingmethod` varchar(255) NOT NULL,
  `label1` varchar(255) DEFAULT NULL,
  `add1` int(11) DEFAULT NULL,
  `every1` int(11) DEFAULT NULL,
  `whenmorethan1` int(11) DEFAULT NULL,
  `setto1` int(11) DEFAULT NULL,
  `numbering1` varchar(255) DEFAULT NULL,
  `label2` varchar(255) DEFAULT NULL,
  `add2` int(11) DEFAULT NULL,
  `every2` int(11) DEFAULT NULL,
  `whenmorethan2` int(11) DEFAULT NULL,
  `setto2` int(11) DEFAULT NULL,
  `numbering2` varchar(255) DEFAULT NULL,
  `label3` varchar(255) DEFAULT NULL,
  `add3` int(11) DEFAULT NULL,
  `every3` int(11) DEFAULT NULL,
  `whenmorethan3` int(11) DEFAULT NULL,
  `setto3` int(11) DEFAULT NULL,
  `numbering3` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_numberpatterns`
--

INSERT INTO `subscription_numberpatterns` VALUES
(1,'Número',1,'Método de numeración simple','Nro. {X}','Número',1,1,99999,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'Volumen, Número, Ejemplar',2,'Volumen Número Ejemplar 1','Vol. {X}, Nro. {Y}, Ejemplar {Z}','Volumen',1,48,99999,1,NULL,'Número',1,4,12,1,NULL,'Ítem',1,1,4,1,NULL),
(3,'Volumen, Número',3,'Volumen Número 1','Vol. {X}, Nro. {Y}','Volumen',1,12,99999,1,NULL,'Número',1,1,12,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(4,'Estacional',4,'Estación del año','{X} {Y}','Estación',1,1,3,0,'season','Año',1,4,99999,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `subscriptionhistory`
--

CREATE TABLE `subscriptionhistory` (
  `biblionumber` int(11) NOT NULL,
  `subscriptionid` int(11) NOT NULL,
  `histstartdate` date DEFAULT NULL,
  `histenddate` date DEFAULT NULL,
  `missinglist` longtext NOT NULL,
  `recievedlist` longtext NOT NULL,
  `opacnote` longtext DEFAULT NULL,
  `librariannote` longtext DEFAULT NULL,
  PRIMARY KEY (`subscriptionid`),
  KEY `subscription_history_ibfk_1` (`biblionumber`),
  CONSTRAINT `subscription_history_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `subscription_history_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptionhistory`
--


--
-- Table structure for table `subscriptionroutinglist`
--

CREATE TABLE `subscriptionroutinglist` (
  `routingid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines with patron is on the routing list',
  `ranking` int(11) DEFAULT NULL COMMENT 'where the patron stands in line to receive the serial',
  `subscriptionid` int(11) NOT NULL COMMENT 'foreign key from the subscription table, defines which subscription this routing list is for',
  PRIMARY KEY (`routingid`),
  UNIQUE KEY `subscriptionid` (`subscriptionid`,`borrowernumber`),
  KEY `subscriptionroutinglist_ibfk_1` (`borrowernumber`),
  CONSTRAINT `subscriptionroutinglist_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `subscriptionroutinglist_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptionroutinglist`
--


--
-- Table structure for table `suggestions`
--

CREATE TABLE `suggestions` (
  `suggestionid` int(8) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned automatically by Koha',
  `suggestedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the person making the suggestion, foreign key linking to the borrowers table',
  `suggesteddate` date NOT NULL COMMENT 'date the suggestion was submitted',
  `managedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table',
  `manageddate` date DEFAULT NULL COMMENT 'date the suggestion was updated',
  `acceptedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table',
  `accepteddate` date DEFAULT NULL COMMENT 'date the suggestion was marked as accepted',
  `rejectedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table',
  `rejecteddate` date DEFAULT NULL COMMENT 'date the suggestion was marked as rejected',
  `lastmodificationby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the librarian who edit the suggestion for the last time',
  `lastmodificationdate` date DEFAULT NULL COMMENT 'date of the last modification',
  `STATUS` varchar(10) NOT NULL DEFAULT '' COMMENT 'suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)',
  `archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?',
  `note` longtext DEFAULT NULL COMMENT 'note entered on the suggestion',
  `staff_note` longtext DEFAULT NULL COMMENT 'non-public note entered on the suggestion',
  `author` varchar(80) DEFAULT NULL COMMENT 'author of the suggested item',
  `title` varchar(255) DEFAULT NULL COMMENT 'title of the suggested item',
  `copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item',
  `publishercode` varchar(255) DEFAULT NULL COMMENT 'publisher of the suggested item',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time the suggestion was updated',
  `volumedesc` varchar(255) DEFAULT NULL,
  `publicationyear` smallint(6) DEFAULT 0,
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place of the suggested item',
  `isbn` varchar(30) DEFAULT NULL COMMENT 'isbn of the suggested item',
  `biblionumber` int(11) DEFAULT NULL COMMENT 'foreign key linking the suggestion to the biblio table after the suggestion has been ordered',
  `reason` mediumtext DEFAULT NULL COMMENT 'reason for accepting or rejecting the suggestion',
  `patronreason` mediumtext DEFAULT NULL COMMENT 'reason for making the suggestion',
  `budgetid` int(11) DEFAULT NULL COMMENT 'foreign key linking the suggested budget to the aqbudgets table',
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key linking the suggested branch to the branches table',
  `collectiontitle` mediumtext DEFAULT NULL COMMENT 'collection name for the suggested item',
  `itemtype` varchar(30) DEFAULT NULL COMMENT 'suggested item type',
  `quantity` smallint(6) DEFAULT NULL COMMENT 'suggested quantity to be purchased',
  `currency` varchar(10) DEFAULT NULL COMMENT 'suggested currency for the suggested price',
  `price` decimal(28,6) DEFAULT NULL COMMENT 'suggested price',
  `total` decimal(28,6) DEFAULT NULL COMMENT 'suggested total cost (price*quantity updated for currency)',
  PRIMARY KEY (`suggestionid`),
  KEY `suggestedby` (`suggestedby`),
  KEY `managedby` (`managedby`),
  KEY `acceptedby` (`acceptedby`),
  KEY `rejectedby` (`rejectedby`),
  KEY `biblionumber` (`biblionumber`),
  KEY `budgetid` (`budgetid`),
  KEY `branchcode` (`branchcode`),
  KEY `status` (`STATUS`),
  KEY `suggestions_ibfk_lastmodificationby` (`lastmodificationby`),
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_acceptedby` FOREIGN KEY (`acceptedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_lastmodificationby` FOREIGN KEY (`lastmodificationby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_managedby` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_rejectedby` FOREIGN KEY (`rejectedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `suggestions_ibfk_suggestedby` FOREIGN KEY (`suggestedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suggestions`
--


--
-- Table structure for table `systempreferences`
--

CREATE TABLE `systempreferences` (
  `variable` varchar(50) NOT NULL DEFAULT '' COMMENT 'system preference name',
  `value` mediumtext DEFAULT NULL COMMENT 'system preference values',
  `options` longtext DEFAULT NULL COMMENT 'options for multiple choice system preferences',
  `explanation` mediumtext DEFAULT NULL COMMENT 'descriptive text for the system preference',
  `type` varchar(20) DEFAULT NULL COMMENT 'type of question this preference asks (multiple choice, plain text, yes or no, etc)',
  PRIMARY KEY (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `systempreferences`
--

INSERT INTO `systempreferences` VALUES
('AccessControlAllowOrigin','',NULL,'Set the Access-Control-Allow-Origin header to the specified value','Free'),
('AccountAutoReconcile','0',NULL,'If enabled, patron balances will get reconciled automatically on each transaction.','YesNo'),
('AcqCreateItem','ordering','ordering|receiving|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),
('AcqEnableFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to invoice records.','YesNo'),
('AcqItemSetSubfieldsWhenReceiptIsCancelled','','','Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a=\"bar foo\")','Free'),
('AcqItemSetSubfieldsWhenReceived','','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a=\"foo bar\")','Free'),
('AcquisitionDetails','1','','Hide/Show acquisition details on the biblio detail page.','YesNo'),
('AcquisitionLog','0',NULL,'If ON, log acquisitions activity','YesNo'),
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'),
('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
('AdditionalContentsEditor','tinymce','tinymce|codemirror','Choose tool for editing News.','Choice'),
('AdditionalFieldsInZ3950ResultSearch','',NULL,'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950','Free'),
('AddressForFailedOverdueNotices','',NULL,'Destination email for failed overdue notices. If left empty then it will fallback to the first defined address in the following list: Library ReplyTo, Library Email, ReplytoDefault and KohaAdminEmailAddress','free'),
('AddressFormat','us','us|de|fr','Choose format to display postal addresses','Choice'),
('advancedMARCeditor','0','','If ON, the MARC editor won\'t display field/subfield descriptions','YesNo'),
('AdvancedSearchLanguages','','','ISO 639-2 codes of languages you wish to see appear as an Advanced search option.  Example: eng|fre|ita','Textarea'),
('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'),
('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','free'),
('AgeRestrictionOverride','0',NULL,'Allow staff to check out an item with age restriction.','YesNo'),
('AggressiveMatchOnISBN','0',NULL,'If enabled, attempt to match aggressively by trying all variations of the ISBNs in the imported record as a phrase in the ISBN fields of already cataloged records when matching on ISBN with the record import tool','YesNo'),
('AggressiveMatchOnISSN','0',NULL,'If enabled, attempt to match aggressively by trying all variations of the ISSNs in the imported record as a phrase in the ISSN fields of already cataloged records when matching on ISSN with the record import tool','YesNo'),
('AllFinesNeedOverride','1','0','If on, staff will be asked to override every fine, even if it is below noissuescharge.','YesNo'),
('AllowAllMessageDeletion','0','','Allow any Library to delete any message','YesNo'),
('AllowCheckoutNotes','0',NULL,'Allow patrons to submit notes about checked out items.','YesNo'),
('AllowFineOverride','0','0','If on, staff will be able to issue books to patrons with fines greater than noissuescharge.','YesNo'),
('AllowHoldDateInFuture','0','','If set a date field is displayed on the Hold screen of the Staff Interface, allowing the hold date to be set in the future.','YesNo'),
('AllowHoldItemTypeSelection','0','','If enabled, patrons and staff will be able to select the itemtype when placing a hold','YesNo'),
('AllowHoldPolicyOverride','0',NULL,'Allow staff to override hold policies when placing holds','YesNo'),
('AllowHoldsOnDamagedItems','1','','Allow hold requests to be placed on damaged items','YesNo'),
('AllowHoldsOnPatronsPossessions','1',NULL,'Allow holds on records that patron have items of it','YesNo'),
('AllowItemsOnHoldCheckoutSCO','0','','Do not generate RESERVE_WAITING and RESERVED warning in the SCO module when checking out items reserved to someone else. This allows self checkouts for those items.','YesNo'),
('AllowItemsOnHoldCheckoutSIP','0','','Do not generate RESERVED warning when checking out items reserved to someone else via SIP. This allows self checkouts for those items.','YesNo'),
('AllowMultipleCovers','0','1','Allow multiple cover images to be attached to each bibliographic record.','YesNo'),
('AllowMultipleIssuesOnABiblio','1','Allow/Don\'t allow patrons to check out multiple items from one biblio','','YesNo'),
('AllowNotForLoanOverride','0','','If ON, Koha will allow the librarian to loan a not for loan item.','YesNo'),
('AllowOfflineCirculation','0','','If on, enables HTML5 offline circulation functionality.','YesNo'),
('AllowPatronToControlAutorenewal','0',NULL,'If enabled, patrons will have a field in their account to choose whether their checkouts are auto renewed or not','YesNo'),
('AllowPatronToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, the patron can set checkouts to be visible to their guarantor','YesNo'),
('AllowPatronToSetFinesVisibilityForGuarantor','0',NULL,'If enabled, the patron can set fines to be visible to their guarantor','YesNo'),
('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'),
('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
('AllowRenewalOnHoldOverride','0',NULL,'If ON, allow items on hold to be renewed with a specified due date','YesNo'),
('AllowReturnToBranch','anywhere','anywhere|homebranch|holdingbranch|homeorholdingbranch','Where an item may be returned','Choice'),
('AllowSetAutomaticRenewal','1',NULL,'If ON, allows staff to flag items for automatic renewal on the check out page','YesNo'),
('AllowStaffToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s checkouts to be visible to linked patrons from the opac.','YesNo'),
('AllowStaffToSetFinesVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s fines to be visible to linked patrons from the opac.','YesNo'),
('AllowTooManyOverride','1','','If on, allow staff to override and check out items when the patron has reached the maximum number of allowed checkouts','YesNo'),
('alphabet','A B C D E F G H I J K L M N O P Q R S T U V W X Y Z',NULL,'Alphabet than can be expanded into browse links, e.g. on Home > Patrons','free'),
('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','free'),
('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','free'),
('AmazonAssocTag','','','See:  http://aws.amazon.com','free'),
('AmazonCoverImages','0','','Display Cover Images in staff interface from Amazon Web Services','YesNo'),
('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for suggestion and checkout history privacy',''),
('ApplyFrameworkDefaults','new','new|duplicate|changed|imported','Configure when to apply framework default values - when cataloguing a new record, or when editing a record as new (duplicating), or when changing framework, or when importing a record','multiple'),
('ArticleRequests','0',NULL,'Enables the article request feature','YesNo'),
('ArticleRequestsLinkControl','calc','always|calc','Control display of article request link on search results','Choice'),
('ArticleRequestsMandatoryFields','',NULL,'Comma delimited list of required fields for bibs where article requests rule = \'yes\'','multiple'),
('ArticleRequestsMandatoryFieldsItemOnly','',NULL,'Comma delimited list of required fields for bibs where article requests rule = \'item_only\'','multiple'),
('ArticleRequestsMandatoryFieldsRecordOnly','',NULL,'Comma delimited list of required fields for bibs where article requests rule = \'bib_only\'','multiple'),
('ArticleRequestsOpacHostRedirection','0',NULL,'Enables redirection from child to host when requesting articles on the Opac','YesNo'),
('ArticleRequestsSupportedFormats','PHOTOCOPY','PHOTOCOPY|SCAN','List supported formats between vertical bars','free'),
('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
('AuthFailureLog','0',NULL,'If enabled, log authentication failures','YesNo'),
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
('AuthorityControlledIndicators','# PERSO_NAME  100 600 696 700 796 800 896\nmarc21, 100, ind1:auth1\nmarc21, 600, ind1:auth1, ind2:thesaurus\nmarc21, 696, ind1:auth1\nmarc21, 700, ind1:auth1\nmarc21, 796, ind1:auth1\nmarc21, 800, ind1:auth1\nmarc21, 896, ind1:auth1\n# CORPO_NAME  110 610 697 710 797 810 897\nmarc21, 110, ind1:auth1\nmarc21, 610, ind1:auth1, ind2:thesaurus\nmarc21, 697, ind1:auth1\nmarc21, 710, ind1:auth1\nmarc21, 797, ind1:auth1\nmarc21, 810, ind1:auth1\nmarc21, 897, ind1:auth1\n# MEETI_NAME    111 611 698 711 798 811 898\nmarc21, 111, ind1:auth1\nmarc21, 611, ind1:auth1, ind2:thesaurus\nmarc21, 698, ind1:auth1\nmarc21, 711, ind1:auth1\nmarc21, 798, ind1:auth1\nmarc21, 811, ind1:auth1\nmarc21, 898, ind1:auth1\n# UNIF_TITLE        130 440 630 699 730 799 830 899\nmarc21, 130, ind1:auth2\nmarc21, 240, , ind2:auth2\nmarc21, 440, , ind2:auth2\nmarc21, 630, ind1:auth2, ind2:thesaurus\nmarc21, 699, ind1:auth2\nmarc21, 730, ind1:auth2\nmarc21, 799, ind1:auth2\nmarc21, 830, , ind2:auth2\nmarc21, 899, ind1:auth2\n# CHRON_TERM    648 \nmarc21, 648, , ind2:thesaurus\n# TOPIC_TERM      650 654 656 657 658 690\nmarc21, 650, , ind2:thesaurus\n# GEOGR_NAME   651 662 691\nmarc21, 651, , ind2:thesaurus\n# GENRE/FORM    655 \nmarc21, 655, , ind2:thesaurus\n\n# UNIMARC: Always copy the indicators from the authority\nunimarc, *, ind1:auth1, ind2:auth2',NULL,'Authority controlled indicators per biblio field','Free'),
('AuthorityMergeLimit','100',NULL,'Maximum number of biblio records updated immediately when an authority record has been modified.','integer'),
('AuthorityMergeMode','loose','loose|strict','Authority merge mode','Choice'),
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
('AuthorityXSLTOpacDetailsDisplay','','','Enable XSL stylesheet control over authority details page in the OPAC','Free'),
('AuthorityXSLTOpacResultsDisplay','','','Enable XSL stylesheet control over authority results page in the OPAC','Free'),
('AuthorityXSLTResultsDisplay','','','Enable XSL stylesheet control over authority results page display on intranet','Free'),
('AuthSuccessLog','0',NULL,'If enabled, log successful authentications','YesNo'),
('autoBarcode','OFF','incremental|annual|hbyymmincr|EAN13|OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','Choice'),
('autoControlNumber','OFF','biblionumber|OFF','Used to autogenerate a Control Number: biblionumber will be as biblionumber, OFF will leave the field as it is;','Choice'),
('AutoCreateAuthorities','0',NULL,'Automatically create authorities that do not exist when cataloging records.','YesNo'),
('AutoCreditNumber','','','Automatically generate a number for account credits','Choice'),
('AutoEmailNewUser','0',NULL,'Send an email to newly created patrons.','YesNo'),
('AutoEmailPrimaryAddress','OFF','email|emailpro|B_email|cardnumber|OFF','Defines the default email address where \'Account Details\' emails are sent.','Choice'),
('AutoLinkBiblios','0',NULL,'If enabled, link biblio to authorities on creation and edit','YesNo'),
('AutoLocation','0',NULL,'If ON, IP authentication is enabled, blocking access to the staff interface from unauthorized IP addresses','YesNo'),
('AutomaticConfirmTransfer','0',NULL,'Defines whether transfers should be automatically confirmed at checkin if modal dismissed','YesNo'),
('AutomaticItemReturn','1',NULL,'If ON, Koha will automatically set up a transfer of this item to its homebranch','YesNo'),
('autoMemberNum','0','','If ON, patron number is auto-calculated','YesNo'),
('AutoRemoveOverduesRestrictions','0',NULL,'Defines whether an OVERDUES debarment should be lifted automatically if all overdue items are returned by the patron.','YesNo'),
('AutoRenewalNotices','cron','cron|preferences|never','How should Koha determine whether to end autorenewal notices','Choice'),
('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'),
('AutoReturnCheckedOutItems','0','','If disabled, librarian must confirm return of checked out item when checking out to another.','YesNo'),
('AutoSelfCheckAllowed','0','','For corporate and special libraries which want web-based self-check available from any PC without the need for a manual staff login. Most libraries will want to leave this turned off. If on, requires self-check ID and password to be entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.','YesNo'),
('AutoSelfCheckID','','','Staff ID with circulation rights to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','free'),
('AutoSelfCheckPass','','','Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','free'),
('AutoShareWithMana','subscription','','defines datas automatically shared with mana','multiple'),
('AutoSwitchPatron','0','','Auto switch to patron','YesNo'),
('Babeltheque','0','','Turn ON Babeltheque content  - See babeltheque.com to subscribe to this service','YesNo'),
('Babeltheque_url_js','','','Url for Babeltheque javascript (e.g. http://www.babeltheque.com/bw_XX.js)','Free'),
('Babeltheque_url_update','','','Url for Babeltheque update (E.G. http://www.babeltheque.com/.../file.csv.bz2)','Free'),
('BakerTaylorBookstoreURL','','','URL template for \"My Libary Bookstore\" links, to which the \"key\" value is appended, and \"https://\" is prepended.  It should include your hostname and \"Parent Number\".  Make this variable empty to turn MLB links off.  Example: ocls.mylibrarybookstore.com/MLB/actions/searchHandler.do?nextPage=bookDetails&parentNum=10923&key=',''),
('BakerTaylorEnabled','0','','Enable or disable all Baker & Taylor features.','YesNo'),
('BakerTaylorPassword','','','Baker & Taylor Password for Content Cafe (external content)','Free'),
('BakerTaylorUsername','','','Baker & Taylor Username for Content Cafe (external content)','Free'),
('BarcodeSeparators','\\s\\r\\n','','Splitting characters for barcodes','Free'),
('BasketConfirmations','1','always ask for confirmation.|do not ask for confirmation.','When closing or reopening a basket,','Choice'),
('BatchCheckouts','0','','Enable or disable batch checkouts','YesNo'),
('BatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch','Free'),
('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
('BiblioItemtypeInfo','0','0','Control which itemtype info displays for biblio level itemtypes','YesNo'),
('BibtexExportAdditionalFields','',NULL,'Define additional BibTex tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.','textarea'),
('BlockExpiredPatronOpacActions','1',NULL,'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis','YesNo'),
('BlockReturnOfLostItems','0','0','If enabled, items that are marked as lost cannot be returned.','YesNo'),
('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','free'),
('borrowerRelationship','padre|madre','','Define valid relationships between a guarantor & a guarantee (separated by | or ,)','free'),
('BorrowerRenewalPeriodBase','now','dateexpiry|now|combination','Set whether the borrower renewal date should be counted from the dateexpiry, from the current date or by combination: if the dateexpiry is in future use dateexpiry, else use current date ','Choice'),
('BorrowersLog','1',NULL,'If ON, log edit/create/delete actions on patron data','YesNo'),
('BorrowersTitles','Sr.|Sra.',NULL,'Define appropriate Titles for patrons','free'),
('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','free'),
('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'),
('BrowseResultSelection','0',NULL,'Enable/Disable browsing search results fromt the bibliographic record detail page in staff interface','YesNo'),
('BundleLostValue','5',NULL,'Sets the LOST AV value that represents \"Missing from bundle\" as a lost value','Free'),
('BundleNotLoanValue','3',NULL,'Sets the NOT_LOAN AV value that represents \"Added to bundle\" as a not for loan value','Free'),
('CalculateFinesOnBackdate','1','','Switch to control if overdue fines are calculated on return when backdating','YesNo'),
('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),
('CalendarFirstDayOfWeek','1','0|1|2|3|4|5|6','Select the first day of week to use in the calendar.','Choice'),
('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow|allow|allow_and_notify','Add a button to the \"Holds to pull\" screen to mark an item as lost and notify the patron.','Choice'),
('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),
('CardnumberLength','','','Set a length for card numbers with a maximum of 32 characters.','Free'),
('casAuthentication','0','','Enable or disable CAS authentication','YesNo'),
('casLogout','0','','Does a logout from Koha should also log the user out of CAS?','YesNo'),
('casServerUrl','https://localhost:8443/cas','','URL of the cas server','Free'),
('casServerVersion','2','2|3','Version of the CAS server Koha will connect to.','Choice'),
('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'),
('CataloguingLog','1',NULL,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'),
('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'),
('CheckPrevCheckout','hardno','hardyes|softyes|softno|hardno','By default, for every item checked out, should we warn if the patron has borrowed that item in the past?','Choice'),
('CheckPrevCheckoutDelay','0',NULL,'Maximum number of days that will trigger a warning if the patron has borrowed that item in the past when CheckPrevCheckout is enabled.','free'),
('CircAutoPrintQuickSlip','qslip',NULL,'Choose what should happen when an empty barcode field is submitted in circulation: Display a print quick slip window, Display a print slip window or Clear the screen.','Choice'),
('CircConfirmItemParts','0',NULL,'Require staff to confirm that all parts of an item are present at checkin/checkout.','Yes/No'),
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
('CircControlReturnsBranch','ItemHomeLibrary','ItemHomeLibrary|ItemHoldingLibrary|CheckInLibrary','Specify the agency that controls the return policy','Choice'),
('CircSidebar','1',NULL,'Activate or deactivate the navigation sidebar on all Circulation pages','YesNo'),
('CirculateILL','0','','If enabled, it is possible to circulate ILL items from within ILL','YesNo'),
('ClaimReturnedChargeFee','ask','ask|charge|no_charge','Controls whether or not a lost item fee is charged for return claims','Choice'),
('ClaimReturnedLostValue','','','Sets the LOST AV value that represents \"Claims returned\" as a lost value','Free'),
('ClaimReturnedWarningThreshold','','','Sets the number of return claims past which the librarian will be warned the patron has many return claims','Integer'),
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
('ClaimsLog','1',NULL,'If ON, log all notices sent','YesNo'),
('CleanUpDatabaseReturnClaims','','','Sets the age of resolved return claims to delete from the database for cleanup_database.pl','Integer'),
('CoceHost','',NULL,'Coce server URL','Free'),
('CoceProviders','','aws,gb,ol','Coce providers','multiple'),
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
('CollapseFieldsPatronAddForm','',NULL,'Collapse these fields by default when adding a new patron. These fields can still be expanded.','Multiple'),
('ComponentSortField','title','call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
('ComponentSortOrder','asc','asc|dsc|az|za','Specify the default sort order','Choice'),
('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'),
('ConsiderOnSiteCheckoutsAsNormalCheckouts','1',NULL,'Consider on-site checkouts as normal checkouts','YesNo'),
('CreateAVFromCataloguing','1','','Ability to create authorized values from the cataloguing module','YesNo'),
('CronjobLog','1',NULL,'If ON, log information from cron jobs.','YesNo'),
('CSVDelimiter',',',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
('CumulativeRestrictionPeriods','0',NULL,'Cumulate the restriction periods instead of keeping the highest','YesNo'),
('CurbsidePickup','0',NULL,'Enable curbside pickup','YesNo'),
('CurrencyFormat','US','US|FR|CH','Determines the display format of currencies. eg: \'36000\' is displayed as \'360 000,00\'  in \'FR\' or \'360,000.00\'  in \'US\'.','Choice'),
('CustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed in the staff interface. CustomCoverImagesURL must be defined.','YesNo'),
('CustomCoverImagesURL','',NULL,'Define an URL serving book cover images, using the following patterns: %issn%, %isbn%, FIXME ADD MORE (use it with CustomCoverImages and/or OPACCustomCoverImages)','free'),
('dateformat','metric','metric|us|iso|dmydot','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)','Choice'),
('DebugLevel','2','0|1|2','Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','Choice'),
('decreaseLoanHighHolds','0','','Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue','YesNo'),
('decreaseLoanHighHoldsControl','static','static|dynamic','Chooses between static and dynamic high holds checking','Choice'),
('decreaseLoanHighHoldsDuration',NULL,'','Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds','Integer'),
('decreaseLoanHighHoldsIgnoreStatuses','','damaged|itemlost|notforloan|withdrawn','Ignore items with these statuses for dynamic high holds checking','Choice'),
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
('DefaultCountryField008','','','Fill in the default country code for field 008 Range 15-17 of MARC21 - Place of publication, production, or execution. See <a href=\"http://www.loc.gov/marc/countries/countries_code.html\">MARC Code List for Countries</a>','Free'),
('DefaultHoldExpirationdate','0','','Automatically set expiration date for holds','YesNo'),
('DefaultHoldExpirationdatePeriod','0','','How long into the future default expiration date is set to be.','integer'),
('DefaultHoldExpirationdateUnitOfTime','days','days|months|years','Which unit of time is used when setting the default expiration date. ','choice'),
('DefaultHoldPickupLocation','loggedinlibrary','loggedinlibrary|homebranch|holdingbranch','Which branch should a hold pickup location default to. ','choice'),
('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'),
('DefaultLongOverdueChargeValue','',NULL,'Charge a lost item to the borrower\'s account when the LOST value of the item changes to n.','integer'),
('DefaultLongOverdueDays','',NULL,'Set the LOST value of an item when the item has been overdue for more than n days.','integer'),
('DefaultLongOverdueLostValue','',NULL,'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.','integer'),
('DefaultLongOverdueSkipLostStatuses','',NULL,'Skip these lost statuses by default in longoverdue.pl','Free'),
('DefaultPatronSearchFields','firstname,middle_name,surname,othernames,cardnumber,userid',NULL,'Comma separated list defining the default fields to be used during a patron search using the \"standard\" option. If empty Koha will default to \"firstname,surname,othernames,cardnumber,userid\". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'),
('DefaultPatronSearchMethod','starts_with','Choose which search method to use by default when searching with PatronAutoComplete','starts_with|contains','Choice'),
('DefaultSaveRecordFileID','biblionumber','biblionumber|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'),
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
('DefaultToLoggedInLibraryCircRules','0',NULL,'If enabled, circ rules editor will default to the logged in library\'s rules, rather than the \'all libraries\' rules.','YesNo'),
('DefaultToLoggedInLibraryNoticesSlips','0',NULL,'If enabled,slips and notices editor will default to the logged in library\'s rules, rather than the \'all libraries\' rules.','YesNo'),
('DefaultToLoggedInLibraryOverdueTriggers','0',NULL,'If enabled, overdue status triggers editor will default to the logged in library\'s rules, rather than the \'default\' rules.','YesNo'),
('Display856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding staff interface XSLT option must be on','Choice'),
('DisplayClearScreenButton','no','no|issueslip|issueqslip','If set to ON, a clear screen button will appear on the circulation page.','Choice'),
('displayFacetCount','0',NULL,NULL,'YesNo'),
('DisplayIconsXSLT','1','','If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.','YesNo'),
('DisplayLibraryFacets','holding','home|holding|both','Defines which library facets to display.','Choice'),
('DisplayMultiPlaceHold','1','','Display the ability to place multiple holds or not','YesNo'),
('DisplayOPACiconsXSLT','1','','If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages in the OPAC.','YesNo'),
('DumpSearchQueryTemplate','0','','Add the search query being passed to the search engine into the template for debugging','YesNo'),
('DumpTemplateVarsIntranet','0',NULL,'If enabled, dump all Template Toolkit variable to a comment in the html source for the staff intranet.','YesNo'),
('DumpTemplateVarsOpac','0',NULL,'If enabled, dump all Template Toolkit variable to a comment in the html source for the opac.','YesNo'),
('EasyAnalyticalRecords','0','','If on, display in the catalogue screens tools to easily setup analytical record relationships','YesNo'),
('EDIFACT','0',NULL,'Enables EDIFACT acquisitions functions','YesNo'),
('EdifactInvoiceImport','automatic','automatic|manual','If on, don\'t auto-import EDI invoices, just keep them in the database with the status \'new\'','Choice'),
('EdifactLSQ','location','location|ccode','Map EDI sequence code (GIR+LSQ) to Koha Item field','Choice'),
('ElasticsearchCrossFields','1','','Enable \"cross_fields\" option for searches using Elastic search.','YesNo'),
('ElasticsearchIndexStatus_authorities','0','Authorities index status',NULL,NULL),
('ElasticsearchIndexStatus_biblios','0','Biblios index status',NULL,NULL),
('ElasticsearchMARCFormat','ISO2709','ISO2709|ARRAY','Elasticsearch MARC format. ISO2709 format is recommended as it is faster and takes less space, whereas array is searchable.','Choice'),
('EmailAddressForPatronRegistrations','','',' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ','free'),
('EmailAddressForSuggestions','','',' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','free'),
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
('EmailOverduesNoEmail','1',NULL,'Send send overdues of patrons without email address to staff','YesNo'),
('EmailPatronRegistrations','0','0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that new patron registrations will be sent to: ','Choice'),
('EmailPurchaseSuggestions','0','0|EmailAddressForSuggestions|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that new purchase suggestions will be sent to: ','Choice'),
('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'),
('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
('EnableExpiredPasswordReset','0',NULL,'Enable ability for patrons with expired password to reset their password directly','YesNo'),
('EnableItemGroupHolds','0','','Enable item groups holds feature','YesNo'),
('EnableItemGroups','0','','Enable the item groups feature','YesNo'),
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
('EnablePointOfSale','0',NULL,'Enable the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)','YesNo'),
('EnableSearchHistory','0','','Enable or disable search history','YesNo'),
('EnhancedMessagingPreferences','1','','If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
('EnhancedMessagingPreferencesOPAC','1',NULL,'If ON, show patrons messaging setting on the OPAC.','YesNo'),
('ERMModule','0',NULL,'Enable the e-resource management module','YesNo'),
('ERMProviderEbscoApiKey','','','API key for EBSCO','free'),
('ERMProviderEbscoCustomerID','','','Customer ID for EBSCO','free'),
('ERMProviders','local','local|ebsco','Set the providers for the ERM module','Choice'),
('ExcludeHolidaysFromMaxPickUpDelay','0',NULL,'If ON, reserves max pickup delay takes into accountthe closed days.','YesNo'),
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'),
('ExpireReservesAutoFillEmail','',NULL,'Send email notification of hold filled from automatically expired/cancelled hold to this address. If not defined, Koha will fallback to the library reply-to address','Free'),
('ExpireReservesMaxPickUpDelay','0','','Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay','YesNo'),
('ExpireReservesMaxPickUpDelayCharge','0',NULL,'If ExpireReservesMaxPickUpDelay is enabled, and this field has a non-zero value, than a borrower whose waiting hold has expired will be charged this amount.','free'),
('ExpireReservesOnHolidays','1',NULL,'If false, reserves at a library will not be canceled on days the library is not open.','YesNo'),
('ExportCircHistory','0',NULL,'Display the export circulation options','YesNo'),
('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'),
('ExtendedPatronAttributes','1',NULL,'Use extended patron IDs and attributes','YesNo'),
('FacetLabelTruncationLength','20',NULL,'Specify the facet max length in OPAC','Integer'),
('FacetMaxCount','20',NULL,'Specify the max facet count for each category','Integer'),
('FacetOrder','Alphabetical','Alphabetical|Usage','Specify the order of facets within each category','Choice'),
('FailedLoginAttempts','','','Number of login attempts before lockout the patron account','Integer'),
('FallbackToSMSIfNoEmail','0','Enable|Disable','Send messages by SMS if no patron email is defined','YesNo'),
('FeeOnChangePatronCategory','1','','If set, when a patron changes to a category with enrolment fee, a fee is charged','YesNo'),
('FilterBeforeOverdueReport','0','','Do not run overdue report until filter selected','YesNo'),
('FineNotifyAtCheckin','0',NULL,'If ON notify librarians of overdue fines on the items they are checking in.','YesNo'),
('FinePaymentAutoPopup','0',NULL,'If enabled, automatically display a print dialog for a payment receipt when making a payment.','YesNo'),
('finesCalendar','noFinesWhenClosed','ignoreCalendar|noFinesWhenClosed','Specify whether to use the Calendar in calculating duedates and fines','Choice'),
('FinesIncludeGracePeriod','1',NULL,'If enabled, fines calculations will include the grace period.','YesNo'),
('FinesLog','1',NULL,'If ON, log fines','YesNo'),
('finesMode','off','off|production','Choose the fines mode, \'off\' (no charges), \'production\' (accrue overdue fines).  Requires accruefines cronjob.','Choice'),
('FrameworksLoaded','sysprefs.sql|subtag_registry.sql|auth_val_cat.sql|message_transport_types.sql|sample_notices_message_attributes.sql|sample_notices_message_transports.sql|keyboard_shortcuts.sql|account_credit_types.yml|account_debit_types.yml|auth_val.yml|auth_values.yml|authorities_normal_marc21.yml|class_sources.yml|marc21_default_matching_rules.yml|marc21_framework_DEFAULT.yml|marc21_holdings_coded_values.yml|marc21_relatorterms.yml|marc21_sample_fastadd_framework.yml|marc21_simple_bib_frameworks.yml|patron_atributes.yml|patron_restriction_types.yml|sample_creator_data.yml|sample_frequencies.yml|sample_news.yml|sample_notices.yml|sample_numberpatterns.yml|sample_quotes.yml|sample_z3950_servers.yml|userflags.sql|userpermissions.sql|audio_alerts.sql|custom.sql',NULL,'Frameworks loaded through webinstaller','choice'),
('FRBRizeEditions','0','','If ON, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
('GenerateAuthorityField667','Machine generated authority record',NULL,'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 667$a field of MARC21 records','free'),
('GenerateAuthorityField670','Work cat.',NULL,'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 670$a field of MARC21 records','free'),
('GoogleJackets','0',NULL,'if ON, displays jacket covers from Google Books API','YesNo'),
('GoogleOAuth2ClientID','',NULL,'Client ID for the web app registered with Google','Free'),
('GoogleOAuth2ClientSecret','',NULL,'Client Secret for the web app registered with Google','Free'),
('GoogleOpenIDConnect','0',NULL,'if ON, allows the use of Google OpenID Connect for login','YesNo'),
('GoogleOpenIDConnectAutoRegister','0',NULL,' Google OpenID Connect logins to auto-register patrons.','YesNo'),
('GoogleOpenIDConnectDefaultBranch','','','This branch code will be used to create Google OpenID Connect patrons.','Textarea'),
('GoogleOpenIDConnectDefaultCategory','','','This category code will be used to create Google OpenID Connect patrons.','Textarea'),
('GoogleOpenIDConnectDomain','',NULL,'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains','Free'),
('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'),
('hidelostitems','0','','If ON, disables display of\"lost\" items in OPAC.','YesNo'),
('HidePatronName','0','','If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'),
('HoldFeeMode','not_always','any_time_is_placed|not_always|any_time_is_collected','Set the hold fee mode','Choice'),
('HoldsAutoFill','0',NULL,'If on, librarian will not be asked if hold should be filled, it will be filled automatically','YesNo'),
('HoldsAutoFillPrintSlip','0',NULL,'If on, hold slip print dialog will be displayed automatically','YesNo'),
('HoldsLog','0',NULL,'If ON, log create/cancel/suspend/resume actions on holds.','YesNo'),
('HoldsNeedProcessingSIP','0',NULL,'Require staff to check-in before hold is set to waiting state','YesNo'),
('HoldsQueueSkipClosed','0',NULL,'If enabled, any libraries that are closed when the holds queue is built will be ignored for the purpose of filling holds.','YesNo'),
('HoldsSplitQueue','nothing','nothing|branch|itemtype|branch_itemtype','In the staff interface, split the holds view by the given criteria','Choice'),
('HoldsSplitQueueNumbering','actual','actual|virtual','If the holds queue is split, decide if the actual priorities should be displayed','Choice'),
('HoldsToPullStartDate','2',NULL,'Set the default start date for the Holds to pull list to this many days ago','Integer'),
('HomeOrHoldingBranch','holdingbranch','holdingbranch|homebranch','Used by Circulation to determine which branch of an item to check with independent branches on, and by search to determine which branch to choose for availability ','Choice'),
('HouseboundModule','0','','If ON, enable housebound module functionality.','YesNo'),
('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt','','Media file extensions','free'),
('HTML5MediaYouTube','0','Embed|Don\'t embed','YouTube links as videos','YesNo'),
('IdRef','0','','Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
('IllCheckAvailability','0','','If ON, during the ILL request process third party sources will be checked for current availability','YesNo'),
('ILLDefaultStaffEmail','',NULL,'Fallback email address for staff ILL notices to be sent to in the absence of a branch address','Free'),
('ILLHiddenRequestStatuses',NULL,NULL,'ILL statuses that are considered finished and should not be displayed in the ILL module','multiple'),
('IllLog','0','','If ON, log information about ILL requests','YesNo'),
('ILLModule','0','If ON, enables the interlibrary loans module.','','YesNo'),
('ILLModuleCopyrightClearance','','70|10','Enter text to enable the copyright clearance stage of request creation. Text will be displayed','Textarea'),
('ILLModuleUnmediated','0','','If enabled, try to immediately progress newly placed ILL requests.','YesNo'),
('ILLOpacbackends',NULL,NULL,'ILL backends to enabled for OPAC initiated requests','multiple'),
('ILLSendStaffNotices',NULL,NULL,'Send these ILL notices to staff','multiple'),
('ILS-DI','0','','Enables ILS-DI services at OPAC.','YesNo'),
('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'),
('ImageLimit','5','','Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
('IncludeSeeFromInSearches','0','','Include see-from references in searches.','YesNo'),
('IndependentBranches','0',NULL,'If ON, increases security between libraries','YesNo'),
('IndependentBranchesPatronModifications','0',NULL,'Show only modification request for the logged in branch','YesNo'),
('IndependentBranchesTransfers','0',NULL,'Allow non-superlibrarians to transfer items between libraries','YesNo'),
('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'),
('IntranetAddMastheadLibraryPulldown','0',NULL,'Add a library select pulldown menu on the staff header search','YesNo'),
('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'),
('intranetbookbag','1','','If ON, enables display of Cart feature in the intranet','YesNo'),
('IntranetCatalogSearchPulldown','0',NULL,'Show a search field pulldown for \"Search the catalog\" boxes','YesNo'),
('IntranetCirculationHomeHTML','',NULL,'Show the following HTML in a div on the bottom of the reports home page','Free'),
('IntranetCoce','0',NULL,'If on, enables cover retrieval from the configured Coce server in the staff interface','YesNo'),
('intranetcolorstylesheet','','50','Define the color stylesheet to use in the staff interface','free'),
('IntranetFavicon','','','Enter a complete URL to an image to replace the default Koha favicon on the staff interface','free'),
('IntranetmainUserblock','','70|10','Add a block of HTML that will display on the intranet home page','Textarea'),
('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'),
('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'),
('intranetreadinghistory','1','','If ON, Checkout history is enabled for all patrons','YesNo'),
('IntranetReportsHomeHTML','',NULL,'Show the following HTML in a div on the bottom of the reports home page','Free'),
('IntranetSlipPrinterJS','','','Use this JavaScript for printing slips. Define at least function printThenClose(). For use e.g. with Firefox PlugIn jsPrintSetup, see http://jsprintsetup.mozdev.org/','Free'),
('intranetstylesheet','','50','Enter a complete URL to use an alternate layout stylesheet in Intranet','free'),
('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded <style> tag.','free'),
('IntranetUserJS','','70|10','Custom javascript for inclusion in Intranet','Textarea'),
('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','ISBD','Textarea'),
('IssueLog','1',NULL,'If ON, log checkout activity','YesNo'),
('IssueLostItem','alert','Defines what should be done when an attempt is made to issue an item that has been marked as lost.','alert|confirm|nothing','Choice'),
('IssuingInProcess','0',NULL,'If ON, disables fines if the patron is issuing item that accumulate debt','YesNo'),
('item-level_itypes','1','','If ON, enables Item-level Itemtype / Issuing Rules','YesNo'),
('itemBarcodeFallbackSearch','0',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
('itemcallnumber','',NULL,'The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record','free'),
('ItemsDeniedRenewal','','','This syspref allows to define custom rules for denying renewal of specific items.','Textarea'),
('KohaAdminEmailAddress','root@localhost','','Define the email address where patron modification requests are sent','free'),
('KohaManualBaseURL','https://koha-community.org/manual/','','Where is the Koha manual/documentation located?','Free'),
('KohaManualLanguage','en','en|ar|cs|de|es|fr|it|pt_BR|tr|zh_TW','What is the language of the online manual you want to use?','Choice'),
('LabelMARCView','standard','standard|economical','Define how a MARC record will display','Choice'),
('language','en,es-ES',NULL,'Set the default language in the staff interface.','Languages'),
('LibraryName','','','Define the library name as displayed on the OPAC',''),
('LibraryThingForLibrariesEnabled','0','','Enable or Disable Library Thing for Libraries Features','YesNo'),
('LibraryThingForLibrariesID','','','See:http://librarything.com/forlibraries/','free'),
('LibraryThingForLibrariesTabbedView','0','','Put LibraryThingForLibraries Content in Tabs.','YesNo'),
('LibrisKey','','This key must be obtained at http://api.libris.kb.se/. It is unique for the IP of the server.',NULL,'Free'),
('LibrisURL','http://api.libris.kb.se/bibspell/','This it the base URL for the Libris spellchecking API.',NULL,'Free'),
('LinkerConsiderThesaurus','0',NULL,'If ON the authority linker will only search for 6XX authorities from the same source as the heading','YesNo'),
('LinkerKeepStale','0',NULL,'If ON the authority linker will keep existing authority links for headings where it is unable to find a match.','YesNo'),
('LinkerModule','Default','Default|FirstMatch|LastMatch','Chooses which linker module to use (see documentation).','Choice'),
('LinkerOptions','','','A pipe-separated list of options for the linker.','free'),
('LinkerRelink','1',NULL,'If ON the authority linker will relink headings that have previously been linked every time it runs.','YesNo'),
('ListOwnerDesignated',NULL,NULL,'Designated list owner at patron deletion','Free'),
('ListOwnershipUponPatronDeletion','delete','delete|transfer','Defines the action on their public or shared lists when patron is deleted','Choice'),
('LoadSearchHistoryToTheFirstLoggedUser','1',NULL,'If ON, the next user will automatically get the last searches in their history','YesNo'),
('LocalCoverImages','0','1','Display local cover images on intranet details pages.','YesNo'),
('LocalHoldsPriority','0',NULL,'Enables the LocalHoldsPriority feature','YesNo'),
('LocalHoldsPriorityItemControl','holdingbranch','holdingbranch|homebranch','decides if the feature operates using the item\'s home or holding library.','Choice'),
('LocalHoldsPriorityPatronControl','PickupLibrary','HomeLibrary|PickupLibrary','decides if the feature operates using the library set as the patron\'s home library, or the library set as the pickup library for the given hold.','Choice'),
('LockExpiredDelay','','','Delay for locking expired patrons (empty means no locking)','Integer'),
('makePreviousSerialAvailable','0','','make previous serial automatically available when collecting a new serial. Please note that the item-level_itypes syspref must be set to specific item.','YesNo'),
('Mana','2',NULL,'request to Mana Webservice. Mana centralize common information between other Koha to facilitate the creation of new subscriptions, vendors, report queries etc... You can search, share, import and comment the content of Mana.','Choice'),
('ManInvInNoissuesCharge','1',NULL,'MANUAL_INV charges block checkouts (added to noissuescharge).','YesNo'),
('MARCAuthorityControlField008','|| aca||aabn           | a|a     d',NULL,'Define the contents of MARC21 authority control field 008 position 06-39','Textarea'),
('MarcFieldDocURL',NULL,NULL,'URL used for MARC field documentation. Following substitutions are available: {MARC} = marc flavour, eg. \"MARC21\" or \"UNIMARC\". {FIELD} = field number, eg. \"000\" or \"048\". {LANG} = user language, eg. \"en\" or \"fi-FI\"','free'),
('MarcFieldForCreatorId','',NULL,'Where to store the borrowernumber of the record\'s creator','Free'),
('MarcFieldForCreatorName','',NULL,'Where to store the name of the record\'s creator','Free'),
('MarcFieldForModifierId','',NULL,'Where to store the borrowernumber of the record\'s last modifier','Free'),
('MarcFieldForModifierName','',NULL,'Where to store the name of the record\'s last modifier','Free'),
('MarcFieldsToOrder','',NULL,'Set the mapping values for a new order line created from a MARC record in a staged file. In a YAML format.','textarea'),
('marcflavour','MARC21','MARC21|UNIMARC','Define global MARC flavor (MARC21 or UNIMARC) used for character encoding','Choice'),
('MarcItemFieldsToOrder','',NULL,'Set the mapping values for new item records created from a MARC record in a staged file. In a YAML format.','textarea'),
('MARCOrgCode','OSt','','Define MARC Organization Code for MARC21 records - http://www.loc.gov/marc/organizations/orgshome.html','free'),
('MARCOverlayRules','0',NULL,'Use the MARC record overlay rules system to decide what actions to take for each field when modifying records.','YesNo'),
('MarkLostItemsAsReturned','batchmod,moredetail,cronjob,additem,pendingreserves,onpayment','claim_returned|batchmod|moredetail|cronjob|additem|pendingreserves|onpayment','Mark items as returned when flagged as lost','multiple'),
('MaxComponentRecords','300','','Max number of component records to display','Integer'),
('MaxFine',NULL,'','Maximum fine a patron can have for all late returns at one moment. Single item caps are specified in the circulation rules matrix.','Integer'),
('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','free'),
('MaxItemsToDisplayForBatchDel','1000',NULL,'Display up to a given number of items in a single item deletionbatch.','Integer'),
('MaxItemsToDisplayForBatchMod','1000',NULL,'Display up to a given number of items in a single item modification batch.','Integer'),
('MaxItemsToProcessForBatchMod','1000',NULL,'Process up to a given number of items in a single item modification batch.','Integer'),
('MaxOpenSuggestions','',NULL,'Limit the number of open suggestions a patron can have at once','Integer'),
('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'),
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
('MaxTotalSuggestions','',NULL,'Number of total suggestions used for time limit with NumberOfSuggestionDays','Free'),
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
('minPasswordLength','8',NULL,'Specify the minimum length of a patron/staff password','free'),
('NewItemsDefaultLocation','','','If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
('NewsAuthorDisplay','none','none|opac|staff|both','Display the author name for news items.','Choice'),
('NewsLog','0',NULL,'If ON, log OPAC news changes','YesNo'),
('noissuescharge','5','','Define maximum amount withstanding before checkouts are blocked','Integer'),
('NoIssuesChargeGuarantees','','','Define maximum amount withstanding before checkouts are blocked','Integer'),
('NoIssuesChargeGuarantorsWithGuarantees','','','Define maximum amount withstanding before checkouts are blocked including guarantors and their other guarantees','Integer'),
('noItemTypeImages','0',NULL,'If ON, disables itemtype images in the staff interface','YesNo'),
('NoRefundOnLostReturnedItemsAge','','','Do not refund lost item fees if item is lost for more than this number of days','Integer'),
('NoRenewalBeforePrecision','exact_time','date|exact_time','Calculate \"No renewal before\" based on date only or exact time of due date','Choice'),
('NotesToHide','',NULL,'List of notes fields that should not appear in the title notes/description separator of details','free'),
('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','free'),
('NoticeBcc','','','Email address to bcc outgoing notices sent by email','free'),
('NoticeCSS','',NULL,'Notices CSS url.','free'),
('NoticesLog','0',NULL,'If enabled, log changes to notice templates','YesNo'),
('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'),
('NotifyPasswordChange','1',NULL,'Notify patrons whenever their password is changed.','YesNo'),
('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content.  Requires Novelist Profile and Password','YesNo'),
('NovelistSelectPassword','',NULL,'Novelist select user Password','free'),
('NovelistSelectProfile','',NULL,'Novelist Select user Profile','free'),
('NovelistSelectStaffEnabled','0',NULL,'Enable Novelist Select content in the staff interface.  Requires Novelist Profile and Password','YesNo'),
('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff interface','free'),
('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff interface','Choice'),
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
('NumberOfSuggestionDays','',NULL,'Number of days that will be used to determine the MaxTotalSuggestions limit','Free'),
('numReturnedItemsToShow','20',NULL,'Number of returned items to show on the check-in page','Integer'),
('numSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
('numSearchResultsDropdown','0',NULL,'Enable option list of number of results per page to show in staff interface search results','YesNo'),
('numSearchRSSResults','50',NULL,'Specify the maximum number of results to display on a RSS page of results','Integer'),
('OAI-PMH','0',NULL,'if ON, OAI-PMH server is enabled','YesNo'),
('OAI-PMH:archiveID','KOHA-OAI-TEST',NULL,'OAI-PMH archive identification','Free'),
('OAI-PMH:AutoUpdateSetEmbedItemData','0','','Embed item information when automatically updating OAI sets. Requires OAI-PMH:AutoUpdateSets syspref to be enabled','YesNo'),
('OAI-PMH:AutoUpdateSets','0','','Automatically update OAI sets when a bibliographic or item record is created or updated','YesNo'),
('OAI-PMH:ConfFile','',NULL,'If empty, Koha OAI Server operates in normal mode, otherwise it operates in extended mode.','File'),
('OAI-PMH:DeletedRecord','persistent','Koha\'s deletedbiblio table will never be deleted (persistent), might be deleted (transient), or will never have any data in it (no)','transient|persistent|no','Choice'),
('OAI-PMH:MaxCount','50',NULL,'OAI-PMH maximum number of records by answer to ListRecords and ListIdentifiers queries','Integer'),
('OnSiteCheckoutAutoCheck','0','','Enable/Do not enable onsite checkout by default if last checkout was an onsite checkout','YesNo'),
('OnSiteCheckouts','0','','Enable/Disable the on-site checkouts feature','YesNo'),
('OnSiteCheckoutsForce','0','','Enable/Disable the on-site for all cases (Even if a user is debarred, etc.)','YesNo'),
('OPACAcquisitionDetails','0','','Show the acquisition details at the OPAC','YesNo'),
('OpacAdditionalStylesheet','','','Define an auxiliary stylesheet for OPAC use, to override specified settings from the primary opac.css stylesheet. Enter the filename (if the file is in the server\'s css directory) or a complete URL beginning with http (if the file lives on a remote server).','free'),
('OpacAddMastheadLibraryPulldown','0','','Adds a pulldown menu to select the library to search on the opac masthead.','YesNo'),
('OpacAdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields are available as limits on the OPAC advanced search page','Choice'),
('OpacAdvSearchMoreOptions','pubdate,itemtype,language,subtype,sorting,location','Show search options for the expanded view (More options)','pubdate|itemtype|language|subtype|sorting|location','multiple'),
('OpacAdvSearchOptions','pubdate,itemtype,language,sorting,location','Show search options','pubdate|itemtype|language|subtype|sorting|location','multiple'),
('OPACAllowHoldDateInFuture','0','','If set, along with the AllowHoldDateInFuture system preference, OPAC users can set the date of a hold to be in the future.','YesNo'),
('OpacAllowPublicListCreation','1',NULL,'If set, allows opac users to create public lists','YesNo'),
('OpacAllowSharingPrivateLists','0',NULL,'If set, allows opac users to share private lists with other patrons','YesNo'),
('OPACAllowUserToChangeBranch','','Pending, In-Transit, Suspended','Allow users to change the library to pick up a hold for these statuses:','multiple'),
('OPACAllowUserToChooseBranch','1','1','Allow the user to choose the branch they want to pickup their hold from','YesNo'),
('OPACAmazonCoverImages','0','','Display cover images on OPAC from Amazon Web Services','YesNo'),
('OPACAuthorIdentifiers','0','','Display author identifiers on the OPAC detail page','YesNo'),
('OpacAuthorities','1',NULL,'If ON, enables the search authorities link on OPAC','YesNo'),
('OPACBaseURL','',NULL,'Specify the Base URL of the OPAC, e.g., http://opac.mylibrary.com, including the protocol (http:// or https://). Otherwise, the http:// will be added automatically by Koha upon saving.','Free'),
('opacbookbag','1','','If ON, enables display of Cart feature','YesNo'),
('OpacBrowser','0',NULL,'If ON, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)','YesNo'),
('OpacBrowseResults','1',NULL,'Disable/enable browsing and paging search results from the OPAC detail page.','YesNo'),
('OpacBrowseSearch','0',NULL,'Elasticsearch only: add a page allowing users to \'browse\' all items in the collection','YesNo'),
('OpacCloud','0',NULL,'If ON, enables subject cloud on OPAC','YesNo'),
('OpacCoce','0',NULL,'If on, enables cover retrieval from the configured Coce server in the OPAC','YesNo'),
('OPACComments','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
('OPACCustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed at the OPAC. CustomCoverImagesURL must be defined.','YesNo'),
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
('OPACFallback','prog','bootstrap|prog','Define the fallback theme for the OPAC interface.','Themes'),
('OpacFavicon','','','Enter a complete URL to an image to replace the default Koha favicon on the OPAC','free'),
('OPACFineNoRenewals','100','','Fine limit above which user cannot renew books via OPAC','Integer'),
('OPACFineNoRenewalsBlockAutoRenew','0','','Block/Allow auto renewals if the patron owe more than OPACFineNoRenewals','YesNo'),
('OPACFineNoRenewalsIncludeCredits','1',NULL,'If enabled the value specified in OPACFineNoRenewals should include any unapplied account credits in the calculation','YesNo'),
('OPACFinesTab','1','','If OFF the patron fines tab in the OPAC is disabled.','YesNo'),
('OPACFRBRizeEditions','0','','If ON, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
('OpacHiddenItems','','','This syspref allows to define custom rules for hiding specific items at the OPAC. See http://wiki.koha-community.org/wiki/OpacHiddenItems for more information.','Textarea'),
('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by comma, that can see items otherwise hidden by OpacHiddenItems','Textarea'),
('OpacHiddenItemsHidesRecord','1','','Hide biblio record when all its items are hidden because of OpacHiddenItems','YesNo'),
('OpacHighlightedWords','1','','If Set, then queried words are higlighted in OPAC','YesNo'),
('OPACHoldingsDefaultSortField','first_column','first_column|homebranch|holdingbranch','Default sort field for the holdings table at the OPAC','choice'),
('OpacHoldNotes','0','','Show hold notes on OPAC','YesNo'),
('OPACHoldRequests','1',NULL,'If ON, globally enables patron holds on OPAC','YesNo'),
('OPACHoldsHistory','0','','If ON, enables display of Patron Holds History in OPAC','YesNo'),
('OPACHoldsIfAvailableAtPickup','1','','Allow patrons to place a hold at pickup locations (libraries) where the item is available','YesNo'),
('OPACHoldsIfAvailableAtPickupExceptions','','','List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'),
('OPACISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','OPAC ISBD','Textarea'),
('OpacItemLocation','callnum','callnum|ccode|location|library','Show the shelving location of items in the opac','Choice'),
('OpacKohaUrl','1',NULL,'Show \'Powered by Koha\' text on OPAC footer.',NULL),
('OpacLangSelectorMode','both','top|both|footer','Select the location to display the language selector in OPAC','Choice'),
('OPACLanguages','en,es-ES',NULL,'Set the default language in the OPAC.','Languages'),
('opaclanguagesdisplay','1','','If ON, enables display of Change Language feature on OPAC','YesNo'),
('opaclayoutstylesheet','opac.css','','Enter the name of the layout CSS stylesheet to use in the OPAC','free'),
('OPACLocalCoverImages','0','1','Display local cover images on OPAC search and details pages.','YesNo'),
('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'),
('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.','Choice'),
('OpacMaintenance','0','','If ON, enables maintenance warning in OPAC','YesNo'),
('OpacMaintenanceNotice','','','A user-defined block of HTML to appear on screen when OpacMaintenace is enabled','Textarea'),
('OPACMandatoryHoldDates','','|start|end|both','Define which hold dates are required on OPAC reserve form','Choice'),
('OpacMaxItemsToDisplay','50','','Max items to display at the OPAC on a biblio detail','Integer'),
('OpacMetaDescription','','','This description will show in search engine results (160 characters).','Textarea'),
('OPACMySummaryHTML','','70|10','Enter the HTML that will appear in a column on the \'my summary\' and \'my checkout history\' tabs when a user is logged in to the OPAC. Enter {BIBLIONUMBER}, {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the HTML. Leave blank to disable.','Textarea'),
('OpacNewsLibrarySelect','0','','Show selector for branches on OPAC news page','YesNo'),
('OpacNoItemTypeImages','0',NULL,'If ON, disables itemtype images in the OPAC','YesNo'),
('OPACNoResultsFound','','70|10','Display this HTML when no results are found for a search in the OPAC','Textarea'),
('OPACNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number OPAC searches','YesNo'),
('OPACnumSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
('OPACnumSearchResultsDropdown','0',NULL,'Enable option list of number of results per page to show in OPAC search results','YesNo'),
('OPACOpenURLItemTypes','',NULL,'Show the OpenURL link only for these item types','Free'),
('OpacPasswordChange','1',NULL,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)','YesNo'),
('OPACPatronDetails','1','','If OFF the patron details tab in the OPAC is disabled.','YesNo'),
('OPACpatronimages','0',NULL,'Enable patron images in the OPAC','YesNo'),
('OPACPlayMusicalInscripts','0','','If displayed musical inscripts, play midi conversion on the OPAC record details page.','YesNo'),
('OpacPrivacy','0',NULL,'if ON, allows patrons to define their privacy rules (checkout history)','YesNo'),
('OpacPublic','1',NULL,'Turn on/off public OPAC','YesNo'),
('opacreadinghistory','1','','If ON, enables display of Patron Circulation History in OPAC','YesNo'),
('OpacRenewalAllowed','1',NULL,'If ON, users can renew their issues directly from their OPAC account','YesNo'),
('OpacRenewalBranch','checkoutbranch','itemhomebranch|patronhomebranch|checkoutbranch|none','Choose how the branch for an OPAC renewal is recorded in statistics','Choice'),
('OPACReportProblem','0',NULL,'Allow patrons to submit problem reports for OPAC pages to the library or Koha Administrator','YesNo'),
('OpacResetPassword','0','','Shows the \'Forgot your password?\' link in the OPAC','YesNo'),
('OPACResultsLibrary','homebranch','homebranch|holdingbranch','Defines whether the OPAC displays the holding or home branch in search results when using XSLT','Choice'),
('OPACResultsMaxItems','1','','Maximum number of available items displayed in search results','Integer'),
('OPACResultsMaxItemsUnavailable','0','','Maximum number of unavailable items displayed in search results','Integer'),
('OPACResultsSidebar','','70|10','Define HTML to be included on the search results page, underneath the facets sidebar','Textarea'),
('OPACResultsUnavailableGroupingBy','branch','branch|substatus|branchonly','Group OPAC XSLT results by branch and substatus, or substatus only, or branch only','Choice'),
('OPACSearchForTitleIn','<a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a>\n<a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a>\n<a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a>\n<a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a>','70|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'),
('OpacSeparateHoldings','0',NULL,'Separate current branch holdings from other holdings (OPAC)','YesNo'),
('OpacSeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings (OPAC)','Choice'),
('opacSerialDefaultTab','subscriptions','holdings|serialcollection|subscriptions','Define the default tab for serials in OPAC.','Choice'),
('OPACSerialIssueDisplayCount','3','','Number of serial issues to display per subscription in the OPAC','Integer'),
('OPACShelfBrowser','1','','Enable/disable Shelf Browser on item details page. WARNING: this feature is very resource consuming on collections with large numbers of items.','YesNo'),
('OPACShowCheckoutName','0','','Displays in the OPAC the name of patron who has checked out the material. WARNING: Most sites should leave this off. It is intended for corporate or special sites which need to track who has the item.','YesNo'),
('OPACShowHoldQueueDetails','none','none|priority|holds|holds_priority','Show holds details in OPAC','Choice'),
('OPACShowMusicalInscripts','0','','Display musical inscripts on the OPAC record details page when available.','YesNo'),
('OPACShowOpenURL','0',NULL,'Enable display of OpenURL links in OPAC search results and detail page','YesNo'),
('OpacShowRecentComments','0',NULL,'If ON a link to recent comments will appear in the OPAC masthead','YesNo'),
('OPACShowUnusedAuthorities','1','','Show authorities that are not being used in the OPAC.','YesNo'),
('OpacStarRatings','all','disable|all|details',NULL,'Choice'),
('OPACSuggestionAutoFill','0',NULL,'Automatically fill OPAC suggestion form with data from Google Books API','YesNo'),
('OpacSuggestionManagedBy','1','','Show the name of the staff member who managed a suggestion in OPAC','YesNo'),
('OPACSuggestionUnwantedFields',NULL,'','Define the hidden fields for a patron purchase suggestions made via OPAC.','multiple'),
('OpacSuppression','0','','Turn ON the OPAC Suppression feature, requires further setup, ask your system administrator for details','YesNo'),
('OpacSuppressionByIPRange','','','Restrict the suppression to IP adresses outside of the IP range','free'),
('OpacSuppressionMessage','','Display this message on the redirect page for suppressed biblios','70|10','Textarea'),
('OpacSuppressionRedirect','1','Redirect the opac detail page for suppressed records to an explanatory page (otherwise redirect to 404 error page)','','YesNo'),
('opacthemes','bootstrap','','Define the current theme for the OPAC interface.','Themes'),
('OpacTopissue','0',NULL,'If ON, enables the \'most popular items\' link on OPAC. Warning, this is an EXPERIMENTAL feature, turning ON may overload your server','YesNo'),
('OPACURLOpenInNewWindow','0',NULL,'If ON, URLs in the OPAC open in a new window','YesNo'),
('OPACUserCSS','*{padding: 0; margin: 0; box-sizing: border-box;}\r\nbody{height: 900px;}\r\nheader {\r\n	/*background: url(\'http://www.autodatz.com/wp-content/uploads/2017/05/Old-Car-Wallpapers-Hd-36-with-Old-Car-Wallpapers-Hd.jpg\');*/\r\n	text-align: left;\r\n	width: 100%;\r\n	/*height: auto;*/\r\n    height: 60%;\r\n	background-size: cover;\r\n	background-attachment: fixed;\r\n	position: relative;\r\n	overflow: hidden;\r\n	border-radius: 0 0 85% 85% / 30%;\r\n}\r\nheader .overlay{\r\n	width: 100%;\r\n	height: 60%;\r\n	/*padding: 20px;*/\r\n    padding-top: 10px;\r\n    padding-bottom: 35px;\r\n	color: #FFF;\r\n	text-shadow: 1px 1px 1px #333;\r\n    /*background-image: linear-gradient( 135deg, #9f05ff69 10%, #fd5e086b 100%);*/\r\n    /*background-image: linear-gradient(270deg, rgba(177,19,47,1) 25%, rgba(255,255,255,0.01) 100%);*/\r\n    /*background-image: linear-gradient( 180deg, #afacac 25%, #efeeee 100%);*/\r\n    /*background-image: linear-gradient(180deg, rgba(51,80,0,1) 25%, rgba(84,131,0,1) 100%);*/\r\n    background: linear-gradient(317deg, rgba(62,90,125,1) 20%, rgba(0,33,76,1) 91%);\r\n    /*background: linear-gradient(180deg, rgb(211 211 211) 70%, rgba(89,4,18,1) 30%);*/\r\n	\r\n}',NULL,'Add CSS to be included in the OPAC in an embedded <style> tag.','free'),
('OPACUserJS','$(\'#logo\').hide();\r\n\r\n/* TABS MAINUSERBLOCK */\r\n$(document).ready(function(){\r\n    $(\".nav-tabs a\").click(function(){\r\n        $(this).tab(\'show\');\r\n    });\r\n});','70|10','Define custom javascript for inclusion in OPAC','Textarea'),
('opacuserlogin','1',NULL,'Enable or disable display of user login features','YesNo'),
('OPACUserSummary','1',NULL,'Show the summary of a logged in user\'s checkouts, overdues, holds and fines on the mainpage','YesNo'),
('OPACViewOthersSuggestions','0',NULL,'If ON, allows all suggestions to be displayed in the OPAC','YesNo'),
('OPACXSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on OPAC','Free'),
('OPACXSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on OPAC','Free'),
('OPACXSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on OPAC','Free'),
('OpenLibraryCovers','0',NULL,'If ON Openlibrary book covers will be show','YesNo'),
('OpenLibrarySearch','0',NULL,'If Yes Open Library search results will show in OPAC','YesNo'),
('OpenURLImageLocation','',NULL,'Location of image for OpenURL links','Free'),
('OpenURLResolverURL','',NULL,'URL of OpenURL Resolver','Free'),
('OpenURLText','',NULL,'Text of OpenURL links (or image title if OpenURLImageLocation is defined)','Free'),
('OrderPdfFormat','pdfformat::layout3pages','Controls what script is used for printing (basketgroups)','','free'),
('OrderPriceRounding','','|nearest_cent','Local preference for rounding orders before calculations to ensure correct calculations','Choice'),
('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo'),
('OverDriveClientKey','','Client key for OverDrive integration','30','Free'),
('OverDriveClientSecret','','Client key for OverDrive integration','30','Free'),
('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'),
('OverDrivePasswordRequired','0',NULL,'Does the library require passwords for OverDrive SIP authentication','YesNo'),
('OverDriveUsername','cardnumber','cardnumber|userid','Which patron information should be passed as OverDrive username','Choice'),
('OverdueNoticeCalendar','0',NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
('OverdueNoticeFrom','cron','cron|item-issuebranch|item-homebranch','Organize and send overdue notices by item home library or checkout library','Choice'),
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
('PassItemMarcToXSLT','0',NULL,'If enabled, item fields in the MARC record will be made avaiable to XSLT sheets. Otherwise they will be removed.','YesNo'),
('PatronAnonymizeDelay','',NULL,'Delay for anonymizing patrons','Integer'),
('PatronAutoComplete','1','Try|Don\'t try','to guess the patron being entered while typing a patron search for circulation or patron search. Only returns the first 10 results at a time.','YesNo'),
('PatronDuplicateMatchingAddFields','surname|firstname|dateofbirth',NULL,'A list of fields separated by \"|\" to deduplicate patrons when created','Free'),
('patronimages','0',NULL,'Enable patron images for the staff interface','YesNo'),
('PatronQuickAddFields','',NULL,'A list of fields separated by \"|\" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry','Free'),
('PatronRemovalDelay','',NULL,'Delay for removing anonymized patrons','Integer'),
('PatronRestrictionTypes','0',NULL,'Specify type of patron restriction being applied','YesNo'),
('PatronSelfModificationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when a patron is editing their information via the OPAC.','free'),
('PatronSelfModificationMandatoryField','',NULL,'Define the required fields when a patron is editing their information via the OPAC','free'),
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
('PatronSelfRegistrationAdditionalInstructions','','','A free text field to display additional instructions to newly self registered patrons.','free'),
('PatronSelfRegistrationBorrowerMandatoryField','surname|firstname',NULL,'Choose the mandatory fields for a patron\'s account, when registering via the OPAC.','free'),
('PatronSelfRegistrationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when registering a new patron via the OPAC.','free'),
('PatronSelfRegistrationConfirmEmail','0',NULL,'Require users to confirm their email address by entering it twice.','YesNo'),
('PatronSelfRegistrationDefaultCategory','','','A patron registered via the OPAC will receive a borrower category code set in this system preference.','free'),
('PatronSelfRegistrationEmailMustBeUnique','0','If set, the field borrowers.email will be considered as a unique field on self registering',NULL,'YesNo'),
('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'),
('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),
('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),
('PrefillGuaranteeField','phone,email,streetnumber,address,city,state,zipcode,country',NULL,'Prefill these fields in guarantee member entry form from guarantor patron record','Multiple'),
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
('PreserveSerialNotes','1','','When a new \"Expected\" issue is generated, should it be prefilled with last created issue notes?','YesNo'),
('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
('PrintNoticesMaxLines','0','','If greater than 0, sets the maximum number of lines an overdue notice will print. If the number of items is greater than this number, the notice will end with a warning asking the borrower to check their online account for a full list of overdue items.','Integer'),
('PrivacyPolicyConsent','','Enforced|Permissive|Disabled','Data privacy policy consent in the OPAC','Choice'),
('PrivacyPolicyURL','',NULL,'This URL is used in messages about GDPR consents.','Free'),
('ProcessingFeeNote','',NULL,'Set the text to be recorded in the column note, table accountlines when the processing fee (defined in item type) is applied','textarea'),
('ProtectSuperlibrarianPrivileges','1',NULL,'If enabled, non-superlibrarians cannot set superlibrarian privileges','YesNo'),
('Pseudonymization','0',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo'),
('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the pseudonymized_transactions table','multiple'),
('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the pseudonymized_transactions table','multiple'),
('PurgeSuggestionsOlderThan','',NULL,'If this script is called without the days parameter','Integer'),
('QueryAutoTruncate','1',NULL,'If ON, query truncation is enabled by default','YesNo'),
('QueryFuzzy','1',NULL,'If ON, enables fuzzy option for searches','YesNo'),
('QueryRegexEscapeOptions','escape','dont_escape|escape|unescape_escaped','Escape option for regexps delimiters in Elasicsearch queries.','Choice'),
('QueryStemming','1',NULL,'If ON, enables query stemming','YesNo'),
('QueryWeightFields','1',NULL,'If ON, enables field weighting','YesNo'),
('QuoteOfTheDay','','intranet,opac','Enable or disable display of Quote of the Day on the OPAC and staff interface home page','multiple'),
('RandomizeHoldsQueueWeight','0',NULL,'if ON, the holds queue in circulation will be randomized, either based on all location codes, or by the location codes specified in StaticHoldsQueueWeight','YesNo'),
('RealTimeHoldsQueue','0',NULL,'Enable updating the holds queue in real time','YesNo'),
('RecallsLog','1',NULL,'If ON, log create/cancel/expire/fulfill actions on recalls','YesNo'),
('RecallsMaxPickUpDelay','7',NULL,'Define the maximum time a recall can be awaiting pickup','Integer'),
('RecordLocalUseOnReturn','0',NULL,'If ON, statistically record returns of unissued items as local use, instead of return','YesNo'),
('Reference_NFL_Statuses','1|2',NULL,'Contains not for loan statuses considered as available for reference','Free'),
('RefundLostOnReturnControl','CheckinLibrary','CheckinLibrary|ItemHomeBranch|ItemHoldingBranch','If a lost item is returned, choose which branch to pick rules for refunding.','Choice'),
('RenewAccruingItemInOpac','0','','If enabled, when the fines on an item accruing is paid off in the OPAC via a payment plugin, attempt to renew that item. If the syspref \"RenewalPeriodBase\" is set to \"due date\", renewed items may still be overdue','YesNo'),
('RenewAccruingItemWhenPaid','0','','If enabled, when the fines on an item accruing is paid off, attempt to renew that item. If the syspref \"RenewalPeriodBase\" is set to \"due date\", renewed items may still be overdue','YesNo'),
('RenewalLog','0','','If ON, log information about renewals','YesNo'),
('RenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal ','Choice'),
('RenewalSendNotice','0','',NULL,'YesNo'),
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
('RentalFeesCheckoutConfirmation','0',NULL,'Allow user to confirm when checking out an item with rental fees.','YesNo'),
('RentalsInNoissuesCharge','1',NULL,'Rental charges block checkouts (added to noissuescharge).','YesNo'),
('ReplyToDefault','',NULL,'Use this email address as the replyto in emails','Free'),
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
('RequireChoosingExistingAuthority','0',NULL,'Require existing authority selection in controlled fields during cataloging.','YesNo'),
('RequirePaymentType','0','','Require staff to select a payment type when a payment is made','YesNo'),
('RequireStrongPassword','1','','Require a strong login password for staff and patrons','YesNo'),
('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'),
('ReservesMaxPickUpDelay','7','','Define the Maximum delay to pick up an item on hold','Integer'),
('ReservesNeedReturns','1','','If ON, a hold placed on an item available in this library must be checked-in, otherwise, a hold on a specific item, that is in the library & available is considered available','YesNo'),
('RESTBasicAuth','0',NULL,'If enabled, Basic authentication is enabled for the REST API.','YesNo'),
('RESTdefaultPageSize','20','','Default page size for endpoints listing objects','Integer'),
('RESTOAuth2ClientCredentials','0',NULL,'If enabled, the OAuth2 client credentials flow is enabled for the REST API.','YesNo'),
('RESTPublicAnonymousRequests','1',NULL,'If enabled, the API will allow anonymous access to public routes that don\'t require authenticated access.','YesNo'),
('RESTPublicAPI','1',NULL,'If enabled, the REST API will expose the /public endpoints.','YesNo'),
('RestrictedPageContent','',NULL,'HTML content of the restricted page','TextArea'),
('RestrictedPageLocalIPs','',NULL,'Beginning of IP addresses considered as local (comma separated ex: \"127.0.0,127.0.2\")','Free'),
('RestrictedPageTitle','',NULL,'Title of the restricted page (breadcrumb and header)','Free'),
('RestrictionBlockRenewing','0',NULL,'If patron is restricted, should renewal be allowed or blocked','YesNo'),
('RetainCatalogSearchTerms','1',NULL,'If enabled, searches entered into the catalog search bar will be retained','YesNo'),
('RetainPatronsSearchTerms','1',NULL,'If enabled, searches entered into the checkout and patrons search bar will be retained','YesNo'),
('ReturnBeforeExpiry','0',NULL,'If ON, checkout will be prevented if returndate is after patron card expiry','YesNo'),
('ReturnLog','1',NULL,'If ON, enables the circulation (returns) log','YesNo'),
('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'),
('RisExportAdditionalFields','',NULL,'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.','textarea'),
('RoundFinesAtPayment','0',NULL,'If enabled any fines with fractions of a cent will be rounded to the nearest cent when payments are coll    ected. e.g. 1.004 will be paid off by a 1.00 payment','YesNo'),
('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70|10','Define a note to be shown on all routing lists','Textarea'),
('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
('SavedSearchFilters','0',NULL,'Allow staff with permission to create/edit custom search filters','YesNo'),
('SCOAllowCheckin','0','','If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
('SCOMainUserBlock','','70|10','Add a block of HTML that will display on the self checkout screen','Textarea'),
('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),
('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),
('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'),
('SearchLimitLibrary','homebranch','homebranch|holdingbranch|both','When limiting search results with a library or library group, use the item\'s home library, or holding library, or both.','Choice'),
('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),
('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),
('SearchWithISSNVariations','0',NULL,'If enabled, search on all variations of the ISSN','YesNo'),
('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'),
('SelfCheckHelpMessage','','70|10','Enter HTML to include under the basic Web-based Self Checkout instructions on the Help page','Textarea'),
('SelfCheckInMainUserBlock','','70|10','Add a block of HTML that will display on the self check-in screen.','Textarea'),
('SelfCheckInModule','0',NULL,'Enable the standalone self-checkin module.','YesNo'),
('SelfCheckInTimeout','120','','Define the number of seconds before the self check-in module times out.','Integer'),
('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','free'),
('SelfCheckInUserJS','',NULL,'Define custom javascript for inclusion in the self check-in module.','free'),
('SelfCheckoutByLogin','1',NULL,'Have patrons login into the web-based self checkout system with their username/password or their cardnumber','YesNo'),
('SelfCheckReceiptPrompt','1','NULL','If ON, print receipt dialog pops up when self checkout is finished','YesNo'),
('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','free'),
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'),
('SessionRestrictionByIP','1','Check for change in remote IP address for session security. Disable only when remote IP address changes frequently.','','YesNo'),
('SessionStorage','mysql','mysql|Pg|tmp','Use database or a temporary file for storing session data','Choice'),
('ShelfBrowserUsesCcode','1','0','Use the item collection code when finding items for the shelf browser.','YesNo'),
('ShelfBrowserUsesHomeBranch','1','1','Use the item home branch when finding items for the shelf browser.','YesNo'),
('ShelfBrowserUsesLocation','1','1','Use the item location when finding items for the shelf browser.','YesNo'),
('ShowAllCheckins','0','','Show all checkins','YesNo'),
('ShowComponentRecords','nowhere','nowhere|staff|opac|both','In which record detail pages to show list of the component records, as linked via 773','Choice'),
('ShowHeadingUse','0',NULL,'Show whether authority record contains an established heading that conforms to descriptive cataloguing rules, and can therefore be used as a main/added entry, or subject, or series title','YesNo'),
('showLastPatron','0','','If ON, enables the last patron feature in the intranet','YesNo'),
('ShowPatronImageInWebBasedSelfCheck','0','','If ON, displays patron image when a patron uses web-based self-checkout','YesNo'),
('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
('ShowReviewerPhoto','1','','If ON, photo of reviewer will be shown beside comments in OPAC','YesNo'),
('SIP2SortBinMapping','',NULL,'Use the following mappings to determine the sort_bin of a returned item. The mapping should be on the form \"branchcode:item field:item field value:sort bin number\", with one mapping per line.','free'),
('SkipHoldTrapOnNotForLoanValue','',NULL,'If set, Koha will never trap items for hold with this notforloan value','Integer'),
('SlipCSS','',NULL,'Slips CSS url.','free'),
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
('SMSSendPassword','','','Password used to send SMS messages','free'),
('SMSSendUsername','','','Username/Login used to send SMS messages','free'),
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
('SpecifyReturnDate','1','','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
('SpineLabelFormat','<itemcallnumber><copynumber>','30|10','This preference defines the format for the quick spine label printer. Just list the fields you would like to see in the order you would like to see them, surrounded by <>, for example <itemcallnumber>.','Textarea'),
('SpineLabelShowPrintOnBibDetails','0','','If turned on, a \"Print label\" link will appear for each item on the bib details page in the staff interface.','YesNo'),
('staffClientBaseURL','',NULL,'Specify the base URL of the staff interface starting with http:// or https://. Do not include a trailing slash in the URL. (This must be filled in correctly for CAS, svc, and load_testing to work.)','free'),
('StaffDetailItemSelection','1',NULL,'Enable item selection in record detail page','YesNo'),
('StaffHighlightedWords','1','','Highlight search terms on staff interface','YesNo'),
('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
('StaffLoginInstructions','',NULL,'HTML to go into the login box for the staff interface','Free'),
('StaffSearchResultsDisplayBranch','holdingbranch','holdingbranch|homebranch','Controls the display of the home or holding branch for staff search results','Choice'),
('StaffSerialIssueDisplayCount','3','','Number of serial issues to display per subscription in the staff interface','Integer'),
('StaticHoldsQueueWeight','0',NULL,'Specify a list of library location codes separated by commas -- the list of codes will be traversed and weighted with first values given higher weight for holds fulfillment -- alternatively, if RandomizeHoldsQueueWeight is set, the list will be randomly selective','Integer'),
('StatisticsFields','location|itype|ccode',NULL,'Define Fields (from the items table) used for statistics members','Free'),
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo'),
('SubfieldsToAllowForRestrictedBatchmod','','Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j',NULL,'Free'),
('SubfieldsToAllowForRestrictedEditing','','Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j',NULL,'Free'),
('SubfieldsToUseWhenPrefill','','','Define a list of subfields to use when prefilling items (separated by space)','Free'),
('SubscriptionDuplicateDroppedInput','','','List of fields which must not be rewritten when a subscription is duplicated (Separated by pipe |)','Free'),
('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'),
('SubscriptionLog','1',NULL,'If ON, enables subscriptions log','YesNo'),
('suggestion','1','','If ON, enables patron suggestions feature in OPAC','YesNo'),
('suggestionPatronCategoryExceptions','','','List the patron categories not affected by suggestion system preference if on','Free'),
('SuspendHoldsIntranet','1','Allow holds to be suspended from the intranet.',NULL,'YesNo'),
('SuspendHoldsOpac','1','Allow holds to be suspended from the OPAC.',NULL,'YesNo'),
('SuspensionsCalendar','noSuspensionsWhenClosed','ignoreCalendar|noSuspensionsWhenClosed','Specify whether to use the Calendar in calculating suspension expiration','Choice'),
('SvcMaxReportRows','10',NULL,'Maximum number of rows to return via the report web service.','Integer'),
('SwitchOnSiteCheckouts','0',NULL,'Automatically switch an on-site checkout to a normal checkout','YesNo'),
('SyndeticsAuthorNotes','0','','Display Notes about the Author on OPAC from Syndetics','YesNo'),
('SyndeticsAwards','0','','Display Awards on OPAC from Syndetics','YesNo'),
('SyndeticsClientCode','0','','Client Code for using Syndetics Solutions content','free'),
('SyndeticsCoverImages','0','','Display Cover Images from Syndetics','YesNo'),
('SyndeticsCoverImageSize','MC','MC|LC','Choose the size of the Syndetics Cover Image to display on the OPAC detail page, MC is Medium, LC is Large','Choice'),
('SyndeticsEditions','0','','Display Editions from Syndetics','YesNo'),
('SyndeticsEnabled','0','','Turn on Syndetics Enhanced Content','YesNo'),
('SyndeticsExcerpt','0','','Display Excerpts and first chapters on OPAC from Syndetics','YesNo'),
('SyndeticsReviews','0','','Display Reviews on OPAC from Syndetics','YesNo'),
('SyndeticsSeries','0','','Display Series information on OPAC from Syndetics','YesNo'),
('SyndeticsSummary','0','','Display Summary Information from Syndetics','YesNo'),
('SyndeticsTOC','0','','Display Table of Content information from Syndetics','YesNo'),
('TagsEnabled','1','','Enables or disables all tagging features.  This is the main switch for tags.','YesNo'),
('TagsExternalDictionary','','','Path on server to local ispell executable, used to set $Lingua::Ispell::path  This dictionary is used as a \"whitelist\" of pre-allowed tags.',''),
('TagsInputOnDetail','1','','Allow users to input tags from the detail page.','YesNo'),
('TagsInputOnList','0','','Allow users to input tags from the search results list.','YesNo'),
('TagsModeration','0','','Require tags from patrons to be approved before becoming visible.','YesNo'),
('TagsShowOnDetail','10','','Number of tags to display on detail page.  0 is off.','Integer'),
('TagsShowOnList','6','','Number of tags to display on search results list.  0 is off.','Integer'),
('TalkingTechItivaPhoneNotification','0',NULL,'If ON, enables Talking Tech I-tiva phone notifications','YesNo'),
('TaxRates','0','','Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST','Integer'),
('template','prog','','Define the preferred staff interface template','Themes'),
('ThingISBN','0','','Use with FRBRizeEditions. If ON, Koha will use the ThingISBN web service in the Editions tab on the detail pages.','YesNo'),
('TimeFormat','24hr','12hr|24hr','Defines the global time format for visual output.','Choice'),
('timeout','1d',NULL,'Inactivity timeout for cookies authentication','Free'),
('todaysIssuesDefaultSortOrder','desc','asc|desc','Specify the sort order of Todays Issues on the circulation page','Choice'),
('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
('TrackClicks','0',NULL,'Track links clicked','Integer'),
('TrackLastPatronActivity','0',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron is seen','YesNo'),
('TransfersBlockCirc','1',NULL,'Should the transfer modal block circulation staff from continuing scanning items','YesNo'),
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
('TranslateNotices','0',NULL,'Allow notices to be translated','YesNo'),
('TrapHoldsOnOrder','1',NULL,'If enabled, Koha will trap holds for on order items ( notforloan < 0 )','YesNo'),
('TwoFactorAuthentication','disabled','enforced|enabled|disabled','Enables two-factor authentication','Choice'),
('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
('UNIMARCAuthorsFacetsSeparator',', ',NULL,'UNIMARC authors facets separator','short'),
('UNIMARCField100Language','fre',NULL,'UNIMARC field 100 default language','short'),
('UniqueItemFields','barcode','','Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table','Free'),
('UnseenRenewals','0','','Allow renewals to be recorded as \"unseen\" by the library, and count against the patrons unseen renewals limit.','YesNo'),
('UnsubscribeReflectionDelay','',NULL,'Delay for locking unsubscribers','Integer'),
('UpdateItemLocationOnCheckin','','NULL','This is a list of value pairs.\n Examples:\n\nPROC: FIC - causes an item in the Processing Center location to be updated into the Fiction location on check in.\nFIC: GEN - causes an item in the Fiction location to be updated into the General stacks location on check in.\n_BLANK_:FIC - causes an item that has no location to be updated into the Fiction location on check in.\nFIC: _BLANK_ - causes an item in location FIC to be updated to a blank location on check in.\n_ALL_:FIC - causes all items to be updated into the Fiction location on check in.\nPROC: _PERM_ - causes an item that is in the Processing Center to be updated to it\'s permanent location.\n\nGeneral rule: if the location value on the left matches the item\'s current location, it will be updated to match the location value on the right.\nNote: PROC and CART are special values, for these locations only can location and permanent_location differ, in all other cases an update will affect both. Items in the CART location will be returned to their permanent location on checkout.\n\nThe special term _BLANK_ may be used on either side of a value pair to update or remove the location from items with no location assigned.\nThe special term _ALL_ is used on the left side of the colon (:) to affect all items.\nThe special term _PERM_ is used on the right side of the colon (:) to return items to their permanent location.','Free'),
('UpdateItemWhenLostFromHoldList','',NULL,'This is a list of values to update an item when it is marked as lost from the holds to pull screen','Free'),
('UpdateNotForLoanStatusOnCheckin','','NULL','This is a list of value pairs. When an item is checked in, if the not for loan value on the left matches the items not for loan value it will be updated to the right-hand value. E.g. \'-1: 0\' will cause an item that was set to \'Ordered\' to now be available for loan. Can be used for showing only the not for loan description. E.g. \'-1: ONLYMESSAGE\'. Each pair of values should be on a separate line.','Free'),
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','integer'),
('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'),
('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','free'),
('UsageStats','2',NULL,'Share anonymous usage data on the Hea Koha community website.','integer'),
('UsageStatsCountry','',NULL,'The country where your library is located, to be shown on the Hea Koha community website','Choice'),
('UsageStatsGeolocation','',NULL,'Geolocation of the main library.','Free'),
('UsageStatsID','',NULL,'This preference is part of Koha but it should not be deleted or updated manually.','Free'),
('UsageStatsLastUpdateTime','',NULL,'This preference is part of Koha but it should not be deleted or updated manually.','Free'),
('UsageStatsLibrariesInfo','0',NULL,'Share libraries information','YesNo'),
('UsageStatsLibraryName','',NULL,'The library name to be shown on Hea Koha community website','Free'),
('UsageStatsLibraryType','','public|school|academic|research|private|societyAssociation|corporate|government|religiousOrg|subscription','The library type to be shown on the Hea Koha community website','Choice'),
('UsageStatsLibraryUrl','',NULL,'The library URL to be shown on Hea Koha community website','Free'),
('UsageStatsPublicID','',NULL,'Public ID for Hea website','Free'),
('UseACQFrameworkForBiblioRecords','0','','Use the ACQ framework for the catalog details','YesNo'),
('UseAuthoritiesForTracings','1','0','Use authority record numbers for subject tracings instead of heading strings.','YesNo'),
('UseBranchTransferLimits','0','','If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),
('UseCashRegisters','0','','Use cash registers with the accounting system and assign patron transactions to them.','YesNo'),
('UseCirculationDesks','0','','Use circulation desks with circulation.','YesNo'),
('UseControlNumber','0','','If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','YesNo'),
('UseCourseReserves','0',NULL,'Enable the course reserves feature.','YesNo'),
('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'),
('useDefaultReplacementCost','0',NULL,'default replacement cost defined in item type','YesNo'),
('useDischarge','0','','Allows librarians to discharge borrowers and borrowers to request a discharge','YesNo'),
('UseEmailReceipts','0','','Send email receipts for payments and write-offs','YesNo'),
('UseICUStyleQuotes','0','1','Tell Koha whether to use ICU style quotes ({) or default (\") when tracing subjects .','YesNo'),
('UseLocationAsAQInSIP','0','','Use permanent_location instead of homebranch for AQ in SIP response','YesNo'),
('UseOCLCEncodingLevels','0',NULL,'If enabled, include OCLC encoding levels in leader value builder dropdown for position 17.','YesNo'),
('UseRecalls','0',NULL,'Enable or disable recalls','YesNo'),
('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),
('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),
('Version','22.1112000',NULL,'The Koha database version. WARNING: Do not change this value manually, it is maintained by the webinstaller',NULL),
('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),
('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),
('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),
('virtualshelves','1','','If ON, enables Lists management','YesNo'),
('WaitingNotifyAtCheckin','0',NULL,'If ON, notify librarians of waiting holds for the patron whose items they are checking in.','YesNo'),
('WebBasedSelfCheck','0',NULL,'If ON, enables the web-based self-check system','YesNo'),
('WhenLostChargeReplacementFee','1',NULL,'If ON, Charge the replacement price when a patron loses an item.','YesNo'),
('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo'),
('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'),
('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo');

--
