Lines 5543-5549
DROP TABLE IF EXISTS `z3950servers`;
Link Here
|
5543 |
/*!40101 SET character_set_client = utf8 */; |
5543 |
/*!40101 SET character_set_client = utf8 */; |
5544 |
CREATE TABLE `z3950servers` ( |
5544 |
CREATE TABLE `z3950servers` ( |
5545 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5545 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5546 |
`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s host name', |
5546 |
`host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'target''s host name', |
5547 |
`port` int(11) DEFAULT NULL COMMENT 'port number used to connect to target', |
5547 |
`port` int(11) DEFAULT NULL COMMENT 'port number used to connect to target', |
5548 |
`db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s database name', |
5548 |
`db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s database name', |
5549 |
`userid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'username needed to log in to target', |
5549 |
`userid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'username needed to log in to target', |
Lines 5551-5560
CREATE TABLE `z3950servers` (
Link Here
|
5551 |
`servername` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name given to the target by the library', |
5551 |
`servername` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name given to the target by the library', |
5552 |
`checked` smallint(6) DEFAULT NULL COMMENT 'whether this target is checked by default (1 for yes, 0 for no)', |
5552 |
`checked` smallint(6) DEFAULT NULL COMMENT 'whether this target is checked by default (1 for yes, 0 for no)', |
5553 |
`rank` int(11) DEFAULT NULL COMMENT 'where this target appears in the list of targets', |
5553 |
`rank` int(11) DEFAULT NULL COMMENT 'where this target appears in the list of targets', |
5554 |
`syntax` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'marc format provided by this target', |
5554 |
`syntax` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'marc format provided by this target', |
5555 |
`timeout` int(11) NOT NULL DEFAULT 0 COMMENT 'number of seconds before Koha stops trying to access this server', |
5555 |
`timeout` int(11) NOT NULL DEFAULT 0 COMMENT 'number of seconds before Koha stops trying to access this server', |
5556 |
`servertype` enum('zed','sru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zed' COMMENT 'zed means z39.50 server', |
5556 |
`servertype` enum('zed','sru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zed' COMMENT 'zed means z39.50 server', |
5557 |
`encoding` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'characters encoding provided by this target', |
5557 |
`encoding` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'characters encoding provided by this target', |
5558 |
`recordtype` enum('authority','biblio') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'biblio' COMMENT 'server contains bibliographic or authority records', |
5558 |
`recordtype` enum('authority','biblio') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'biblio' COMMENT 'server contains bibliographic or authority records', |
5559 |
`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', |
5559 |
`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', |
5560 |
`sru_fields` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'contains the mapping between the Z3950 search fields and the specific SRU server indexes', |
5560 |
`sru_fields` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'contains the mapping between the Z3950 search fields and the specific SRU server indexes', |
5561 |
- |
|
|