Lines 5553-5559
DROP TABLE IF EXISTS `z3950servers`;
Link Here
|
5553 |
/*!40101 SET character_set_client = utf8 */; |
5553 |
/*!40101 SET character_set_client = utf8 */; |
5554 |
CREATE TABLE `z3950servers` ( |
5554 |
CREATE TABLE `z3950servers` ( |
5555 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5555 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5556 |
`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s host name', |
5556 |
`host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'target''s host name', |
5557 |
`port` int(11) DEFAULT NULL COMMENT 'port number used to connect to target', |
5557 |
`port` int(11) DEFAULT NULL COMMENT 'port number used to connect to target', |
5558 |
`db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s database name', |
5558 |
`db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s database name', |
5559 |
`userid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'username needed to log in to target', |
5559 |
`userid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'username needed to log in to target', |
Lines 5561-5570
CREATE TABLE `z3950servers` (
Link Here
|
5561 |
`servername` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name given to the target by the library', |
5561 |
`servername` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name given to the target by the library', |
5562 |
`checked` smallint(6) DEFAULT NULL COMMENT 'whether this target is checked by default (1 for yes, 0 for no)', |
5562 |
`checked` smallint(6) DEFAULT NULL COMMENT 'whether this target is checked by default (1 for yes, 0 for no)', |
5563 |
`rank` int(11) DEFAULT NULL COMMENT 'where this target appears in the list of targets', |
5563 |
`rank` int(11) DEFAULT NULL COMMENT 'where this target appears in the list of targets', |
5564 |
`syntax` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'marc format provided by this target', |
5564 |
`syntax` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'marc format provided by this target', |
5565 |
`timeout` int(11) NOT NULL DEFAULT 0 COMMENT 'number of seconds before Koha stops trying to access this server', |
5565 |
`timeout` int(11) NOT NULL DEFAULT 0 COMMENT 'number of seconds before Koha stops trying to access this server', |
5566 |
`servertype` enum('zed','sru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zed' COMMENT 'zed means z39.50 server', |
5566 |
`servertype` enum('zed','sru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zed' COMMENT 'zed means z39.50 server', |
5567 |
`encoding` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'characters encoding provided by this target', |
5567 |
`encoding` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'characters encoding provided by this target', |
5568 |
`recordtype` enum('authority','biblio') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'biblio' COMMENT 'server contains bibliographic or authority records', |
5568 |
`recordtype` enum('authority','biblio') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'biblio' COMMENT 'server contains bibliographic or authority records', |
5569 |
`sru_options` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'options like sru=get, sru_version=1.1; will be passed to the server via ZOOM', |
5569 |
`sru_options` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'options like sru=get, sru_version=1.1; will be passed to the server via ZOOM', |
5570 |
`sru_fields` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'contains the mapping between the Z3950 search fields and the specific SRU server indexes', |
5570 |
`sru_fields` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'contains the mapping between the Z3950 search fields and the specific SRU server indexes', |
5571 |
- |
|
|