Lines 1379-1385
CREATE TABLE `printers` (
Link Here
|
1379 |
`printername` varchar(40) NOT NULL default '', |
1379 |
`printername` varchar(40) NOT NULL default '', |
1380 |
`printqueue` varchar(20) default NULL, |
1380 |
`printqueue` varchar(20) default NULL, |
1381 |
`printtype` varchar(20) default NULL, |
1381 |
`printtype` varchar(20) default NULL, |
1382 |
PRIMARY KEY (`printername`) |
1382 |
PRIMARY KEY (`printername`) |
1383 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1383 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1384 |
|
1384 |
|
1385 |
-- |
1385 |
-- |
Lines 1471-1477
CREATE TABLE saved_reports (
Link Here
|
1471 |
`report_id` int(11) default NULL, |
1471 |
`report_id` int(11) default NULL, |
1472 |
`report` longtext, |
1472 |
`report` longtext, |
1473 |
`date_run` datetime default NULL, |
1473 |
`date_run` datetime default NULL, |
1474 |
PRIMARY KEY (`id`) |
1474 |
PRIMARY KEY (`id`) |
1475 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1475 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1476 |
|
1476 |
|
1477 |
-- |
1477 |
-- |
Lines 1485-1491
CREATE TABLE `search_field` (
Link Here
|
1485 |
`label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', |
1485 |
`label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', |
1486 |
`type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
1486 |
`type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
1487 |
PRIMARY KEY (`id`), |
1487 |
PRIMARY KEY (`id`), |
1488 |
UNIQUE KEY (`name` (191) ) |
1488 |
UNIQUE KEY (`name` (191)) |
1489 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1489 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1490 |
|
1490 |
|
1491 |
-- |
1491 |
-- |
Lines 1504-1510
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
1504 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1504 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1505 |
KEY `userid` (`userid`), |
1505 |
KEY `userid` (`userid`), |
1506 |
KEY `sessionid` (`sessionid`), |
1506 |
KEY `sessionid` (`sessionid`), |
1507 |
PRIMARY KEY (`id`) |
1507 |
PRIMARY KEY (`id`) |
1508 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; |
1508 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; |
1509 |
|
1509 |
|
1510 |
-- |
1510 |
-- |
Lines 1518-1524
CREATE TABLE `search_marc_map` (
Link Here
|
1518 |
marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', |
1518 |
marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', |
1519 |
marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', |
1519 |
marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', |
1520 |
PRIMARY KEY(`id`), |
1520 |
PRIMARY KEY(`id`), |
1521 |
UNIQUE key(index_name, marc_field(191), marc_type), |
1521 |
UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`), |
1522 |
INDEX (`index_name`) |
1522 |
INDEX (`index_name`) |
1523 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1523 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1524 |
|
1524 |
|
Lines 1559-1565
CREATE TABLE `serial` ( -- issues related to subscriptions
Link Here
|
1559 |
`claimdate` date default NULL, -- date claimed |
1559 |
`claimdate` date default NULL, -- date claimed |
1560 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1560 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1561 |
`routingnotes` text, -- notes from the routing list |
1561 |
`routingnotes` text, -- notes from the routing list |
1562 |
PRIMARY KEY (`serialid`) |
1562 |
PRIMARY KEY (`serialid`) |
1563 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1563 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1564 |
|
1564 |
|
1565 |
-- |
1565 |
-- |
1566 |
- |
|
|