|
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 |
- |
|
|