Lines 1349-1355
CREATE TABLE `printers` (
Link Here
|
1349 |
`printername` varchar(40) NOT NULL default '', |
1349 |
`printername` varchar(40) NOT NULL default '', |
1350 |
`printqueue` varchar(20) default NULL, |
1350 |
`printqueue` varchar(20) default NULL, |
1351 |
`printtype` varchar(20) default NULL, |
1351 |
`printtype` varchar(20) default NULL, |
1352 |
PRIMARY KEY (`printername`) |
1352 |
PRIMARY KEY (`printername`) |
1353 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1353 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1354 |
|
1354 |
|
1355 |
-- |
1355 |
-- |
Lines 1441-1447
CREATE TABLE saved_reports (
Link Here
|
1441 |
`report_id` int(11) default NULL, |
1441 |
`report_id` int(11) default NULL, |
1442 |
`report` longtext, |
1442 |
`report` longtext, |
1443 |
`date_run` datetime default NULL, |
1443 |
`date_run` datetime default NULL, |
1444 |
PRIMARY KEY (`id`) |
1444 |
PRIMARY KEY (`id`) |
1445 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1445 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1446 |
|
1446 |
|
1447 |
-- |
1447 |
-- |
Lines 1455-1461
CREATE TABLE `search_field` (
Link Here
|
1455 |
`label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', |
1455 |
`label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', |
1456 |
`type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
1456 |
`type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
1457 |
PRIMARY KEY (`id`), |
1457 |
PRIMARY KEY (`id`), |
1458 |
UNIQUE KEY (`name` (191) ) |
1458 |
UNIQUE KEY (`name` (191)) |
1459 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1459 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1460 |
|
1460 |
|
1461 |
-- |
1461 |
-- |
Lines 1474-1480
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
1474 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1474 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1475 |
KEY `userid` (`userid`), |
1475 |
KEY `userid` (`userid`), |
1476 |
KEY `sessionid` (`sessionid`), |
1476 |
KEY `sessionid` (`sessionid`), |
1477 |
PRIMARY KEY (`id`) |
1477 |
PRIMARY KEY (`id`) |
1478 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; |
1478 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; |
1479 |
|
1479 |
|
1480 |
-- |
1480 |
-- |
Lines 1488-1494
CREATE TABLE `search_marc_map` (
Link Here
|
1488 |
marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', |
1488 |
marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', |
1489 |
marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', |
1489 |
marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', |
1490 |
PRIMARY KEY(`id`), |
1490 |
PRIMARY KEY(`id`), |
1491 |
UNIQUE key(index_name, marc_field(191), marc_type), |
1491 |
UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`), |
1492 |
INDEX (`index_name`) |
1492 |
INDEX (`index_name`) |
1493 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1493 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1494 |
|
1494 |
|
Lines 1529-1535
CREATE TABLE `serial` ( -- issues related to subscriptions
Link Here
|
1529 |
`claimdate` date default NULL, -- date claimed |
1529 |
`claimdate` date default NULL, -- date claimed |
1530 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1530 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1531 |
`routingnotes` text, -- notes from the routing list |
1531 |
`routingnotes` text, -- notes from the routing list |
1532 |
PRIMARY KEY (`serialid`) |
1532 |
PRIMARY KEY (`serialid`) |
1533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1534 |
|
1534 |
|
1535 |
-- |
1535 |
-- |
1536 |
- |
|
|