Lines 21-27
Link Here
|
21 |
|
21 |
|
22 |
DROP TABLE IF EXISTS `account_credit_types`; |
22 |
DROP TABLE IF EXISTS `account_credit_types`; |
23 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
23 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
24 |
/*!40101 SET character_set_client = utf8 */; |
24 |
/*!40101 SET character_set_client = utf8mb4 */; |
25 |
CREATE TABLE `account_credit_types` ( |
25 |
CREATE TABLE `account_credit_types` ( |
26 |
`code` varchar(80) NOT NULL, |
26 |
`code` varchar(80) NOT NULL, |
27 |
`description` varchar(200) DEFAULT NULL, |
27 |
`description` varchar(200) DEFAULT NULL, |
Lines 39-45
CREATE TABLE `account_credit_types` (
Link Here
|
39 |
|
39 |
|
40 |
DROP TABLE IF EXISTS `account_credit_types_branches`; |
40 |
DROP TABLE IF EXISTS `account_credit_types_branches`; |
41 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
41 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
42 |
/*!40101 SET character_set_client = utf8 */; |
42 |
/*!40101 SET character_set_client = utf8mb4 */; |
43 |
CREATE TABLE `account_credit_types_branches` ( |
43 |
CREATE TABLE `account_credit_types_branches` ( |
44 |
`credit_type_code` varchar(80) DEFAULT NULL, |
44 |
`credit_type_code` varchar(80) DEFAULT NULL, |
45 |
`branchcode` varchar(10) DEFAULT NULL, |
45 |
`branchcode` varchar(10) DEFAULT NULL, |
Lines 56-62
CREATE TABLE `account_credit_types_branches` (
Link Here
|
56 |
|
56 |
|
57 |
DROP TABLE IF EXISTS `account_debit_types`; |
57 |
DROP TABLE IF EXISTS `account_debit_types`; |
58 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
58 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
59 |
/*!40101 SET character_set_client = utf8 */; |
59 |
/*!40101 SET character_set_client = utf8mb4 */; |
60 |
CREATE TABLE `account_debit_types` ( |
60 |
CREATE TABLE `account_debit_types` ( |
61 |
`code` varchar(80) NOT NULL, |
61 |
`code` varchar(80) NOT NULL, |
62 |
`description` varchar(200) DEFAULT NULL, |
62 |
`description` varchar(200) DEFAULT NULL, |
Lines 76-82
CREATE TABLE `account_debit_types` (
Link Here
|
76 |
|
76 |
|
77 |
DROP TABLE IF EXISTS `account_debit_types_branches`; |
77 |
DROP TABLE IF EXISTS `account_debit_types_branches`; |
78 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
78 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
79 |
/*!40101 SET character_set_client = utf8 */; |
79 |
/*!40101 SET character_set_client = utf8mb4 */; |
80 |
CREATE TABLE `account_debit_types_branches` ( |
80 |
CREATE TABLE `account_debit_types_branches` ( |
81 |
`debit_type_code` varchar(80) DEFAULT NULL, |
81 |
`debit_type_code` varchar(80) DEFAULT NULL, |
82 |
`branchcode` varchar(10) DEFAULT NULL, |
82 |
`branchcode` varchar(10) DEFAULT NULL, |
Lines 93-99
CREATE TABLE `account_debit_types_branches` (
Link Here
|
93 |
|
93 |
|
94 |
DROP TABLE IF EXISTS `account_offsets`; |
94 |
DROP TABLE IF EXISTS `account_offsets`; |
95 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
95 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
96 |
/*!40101 SET character_set_client = utf8 */; |
96 |
/*!40101 SET character_set_client = utf8mb4 */; |
97 |
CREATE TABLE `account_offsets` ( |
97 |
CREATE TABLE `account_offsets` ( |
98 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each offset', |
98 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each offset', |
99 |
`credit_id` int(11) DEFAULT NULL COMMENT 'The id of the accountline the increased the patron''s balance', |
99 |
`credit_id` int(11) DEFAULT NULL COMMENT 'The id of the accountline the increased the patron''s balance', |
Lines 115-121
CREATE TABLE `account_offsets` (
Link Here
|
115 |
|
115 |
|
116 |
DROP TABLE IF EXISTS `accountlines`; |
116 |
DROP TABLE IF EXISTS `accountlines`; |
117 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
117 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
118 |
/*!40101 SET character_set_client = utf8 */; |
118 |
/*!40101 SET character_set_client = utf8mb4 */; |
119 |
CREATE TABLE `accountlines` ( |
119 |
CREATE TABLE `accountlines` ( |
120 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
120 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
121 |
`issue_id` int(11) DEFAULT NULL, |
121 |
`issue_id` int(11) DEFAULT NULL, |
Lines 166-172
CREATE TABLE `accountlines` (
Link Here
|
166 |
|
166 |
|
167 |
DROP TABLE IF EXISTS `action_logs`; |
167 |
DROP TABLE IF EXISTS `action_logs`; |
168 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
168 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
169 |
/*!40101 SET character_set_client = utf8 */; |
169 |
/*!40101 SET character_set_client = utf8mb4 */; |
170 |
CREATE TABLE `action_logs` ( |
170 |
CREATE TABLE `action_logs` ( |
171 |
`action_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each action', |
171 |
`action_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each action', |
172 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the action took place', |
172 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the action took place', |
Lines 196-202
CREATE TABLE `action_logs` (
Link Here
|
196 |
|
196 |
|
197 |
DROP TABLE IF EXISTS `additional_contents`; |
197 |
DROP TABLE IF EXISTS `additional_contents`; |
198 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
198 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
199 |
/*!40101 SET character_set_client = utf8 */; |
199 |
/*!40101 SET character_set_client = utf8mb4 */; |
200 |
CREATE TABLE `additional_contents` ( |
200 |
CREATE TABLE `additional_contents` ( |
201 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content category', |
201 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content category', |
202 |
`category` varchar(20) NOT NULL COMMENT 'category for the additional content', |
202 |
`category` varchar(20) NOT NULL COMMENT 'category for the additional content', |
Lines 223-229
CREATE TABLE `additional_contents` (
Link Here
|
223 |
|
223 |
|
224 |
DROP TABLE IF EXISTS `additional_contents_localizations`; |
224 |
DROP TABLE IF EXISTS `additional_contents_localizations`; |
225 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
225 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
226 |
/*!40101 SET character_set_client = utf8 */; |
226 |
/*!40101 SET character_set_client = utf8mb4 */; |
227 |
CREATE TABLE `additional_contents_localizations` ( |
227 |
CREATE TABLE `additional_contents_localizations` ( |
228 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content', |
228 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content', |
229 |
`additional_content_id` int(10) unsigned NOT NULL COMMENT 'link to the additional content', |
229 |
`additional_content_id` int(10) unsigned NOT NULL COMMENT 'link to the additional content', |
Lines 243-249
CREATE TABLE `additional_contents_localizations` (
Link Here
|
243 |
|
243 |
|
244 |
DROP TABLE IF EXISTS `additional_field_values`; |
244 |
DROP TABLE IF EXISTS `additional_field_values`; |
245 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
245 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
246 |
/*!40101 SET character_set_client = utf8 */; |
246 |
/*!40101 SET character_set_client = utf8mb4 */; |
247 |
CREATE TABLE `additional_field_values` ( |
247 |
CREATE TABLE `additional_field_values` ( |
248 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
248 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
249 |
`field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)', |
249 |
`field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)', |
Lines 261-267
CREATE TABLE `additional_field_values` (
Link Here
|
261 |
|
261 |
|
262 |
DROP TABLE IF EXISTS `additional_fields`; |
262 |
DROP TABLE IF EXISTS `additional_fields`; |
263 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
263 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
264 |
/*!40101 SET character_set_client = utf8 */; |
264 |
/*!40101 SET character_set_client = utf8mb4 */; |
265 |
CREATE TABLE `additional_fields` ( |
265 |
CREATE TABLE `additional_fields` ( |
266 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
266 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
267 |
`tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
267 |
`tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
Lines 282-288
CREATE TABLE `additional_fields` (
Link Here
|
282 |
|
282 |
|
283 |
DROP TABLE IF EXISTS `advanced_editor_macros`; |
283 |
DROP TABLE IF EXISTS `advanced_editor_macros`; |
284 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
284 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
285 |
/*!40101 SET character_set_client = utf8 */; |
285 |
/*!40101 SET character_set_client = utf8mb4 */; |
286 |
CREATE TABLE `advanced_editor_macros` ( |
286 |
CREATE TABLE `advanced_editor_macros` ( |
287 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the macro', |
287 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the macro', |
288 |
`name` varchar(80) NOT NULL COMMENT 'Name of the macro', |
288 |
`name` varchar(80) NOT NULL COMMENT 'Name of the macro', |
Lines 301-307
CREATE TABLE `advanced_editor_macros` (
Link Here
|
301 |
|
301 |
|
302 |
DROP TABLE IF EXISTS `alert`; |
302 |
DROP TABLE IF EXISTS `alert`; |
303 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
303 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
304 |
/*!40101 SET character_set_client = utf8 */; |
304 |
/*!40101 SET character_set_client = utf8mb4 */; |
305 |
CREATE TABLE `alert` ( |
305 |
CREATE TABLE `alert` ( |
306 |
`alertid` int(11) NOT NULL AUTO_INCREMENT, |
306 |
`alertid` int(11) NOT NULL AUTO_INCREMENT, |
307 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
307 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
Lines 320-326
CREATE TABLE `alert` (
Link Here
|
320 |
|
320 |
|
321 |
DROP TABLE IF EXISTS `api_keys`; |
321 |
DROP TABLE IF EXISTS `api_keys`; |
322 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
322 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
323 |
/*!40101 SET character_set_client = utf8 */; |
323 |
/*!40101 SET character_set_client = utf8mb4 */; |
324 |
CREATE TABLE `api_keys` ( |
324 |
CREATE TABLE `api_keys` ( |
325 |
`client_id` varchar(191) NOT NULL COMMENT 'API client ID', |
325 |
`client_id` varchar(191) NOT NULL COMMENT 'API client ID', |
326 |
`secret` varchar(191) NOT NULL COMMENT 'API client secret used for API authentication', |
326 |
`secret` varchar(191) NOT NULL COMMENT 'API client secret used for API authentication', |
Lines 340-346
CREATE TABLE `api_keys` (
Link Here
|
340 |
|
340 |
|
341 |
DROP TABLE IF EXISTS `aqbasket`; |
341 |
DROP TABLE IF EXISTS `aqbasket`; |
342 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
342 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
343 |
/*!40101 SET character_set_client = utf8 */; |
343 |
/*!40101 SET character_set_client = utf8mb4 */; |
344 |
CREATE TABLE `aqbasket` ( |
344 |
CREATE TABLE `aqbasket` ( |
345 |
`basketno` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, Koha defined number', |
345 |
`basketno` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, Koha defined number', |
346 |
`basketname` varchar(50) DEFAULT NULL COMMENT 'name given to the basket at creation', |
346 |
`basketname` varchar(50) DEFAULT NULL COMMENT 'name given to the basket at creation', |
Lines 377-383
CREATE TABLE `aqbasket` (
Link Here
|
377 |
|
377 |
|
378 |
DROP TABLE IF EXISTS `aqbasketgroups`; |
378 |
DROP TABLE IF EXISTS `aqbasketgroups`; |
379 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
379 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
380 |
/*!40101 SET character_set_client = utf8 */; |
380 |
/*!40101 SET character_set_client = utf8mb4 */; |
381 |
CREATE TABLE `aqbasketgroups` ( |
381 |
CREATE TABLE `aqbasketgroups` ( |
382 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
382 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
383 |
`name` varchar(50) DEFAULT NULL, |
383 |
`name` varchar(50) DEFAULT NULL, |
Lines 399-405
CREATE TABLE `aqbasketgroups` (
Link Here
|
399 |
|
399 |
|
400 |
DROP TABLE IF EXISTS `aqbasketusers`; |
400 |
DROP TABLE IF EXISTS `aqbasketusers`; |
401 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
401 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
402 |
/*!40101 SET character_set_client = utf8 */; |
402 |
/*!40101 SET character_set_client = utf8mb4 */; |
403 |
CREATE TABLE `aqbasketusers` ( |
403 |
CREATE TABLE `aqbasketusers` ( |
404 |
`basketno` int(11) NOT NULL, |
404 |
`basketno` int(11) NOT NULL, |
405 |
`borrowernumber` int(11) NOT NULL, |
405 |
`borrowernumber` int(11) NOT NULL, |
Lines 416-422
CREATE TABLE `aqbasketusers` (
Link Here
|
416 |
|
416 |
|
417 |
DROP TABLE IF EXISTS `aqbookseller_aliases`; |
417 |
DROP TABLE IF EXISTS `aqbookseller_aliases`; |
418 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
418 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
419 |
/*!40101 SET character_set_client = utf8 */; |
419 |
/*!40101 SET character_set_client = utf8mb4 */; |
420 |
CREATE TABLE `aqbookseller_aliases` ( |
420 |
CREATE TABLE `aqbookseller_aliases` ( |
421 |
`alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
421 |
`alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
422 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
422 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
Lines 433-439
CREATE TABLE `aqbookseller_aliases` (
Link Here
|
433 |
|
433 |
|
434 |
DROP TABLE IF EXISTS `aqbookseller_interfaces`; |
434 |
DROP TABLE IF EXISTS `aqbookseller_interfaces`; |
435 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
435 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
436 |
/*!40101 SET character_set_client = utf8 */; |
436 |
/*!40101 SET character_set_client = utf8mb4 */; |
437 |
CREATE TABLE `aqbookseller_interfaces` ( |
437 |
CREATE TABLE `aqbookseller_interfaces` ( |
438 |
`interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
438 |
`interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
439 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
439 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
Lines 456-462
CREATE TABLE `aqbookseller_interfaces` (
Link Here
|
456 |
|
456 |
|
457 |
DROP TABLE IF EXISTS `aqbookseller_issues`; |
457 |
DROP TABLE IF EXISTS `aqbookseller_issues`; |
458 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
458 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
459 |
/*!40101 SET character_set_client = utf8 */; |
459 |
/*!40101 SET character_set_client = utf8mb4 */; |
460 |
CREATE TABLE `aqbookseller_issues` ( |
460 |
CREATE TABLE `aqbookseller_issues` ( |
461 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
461 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
462 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
462 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
Lines 476-482
CREATE TABLE `aqbookseller_issues` (
Link Here
|
476 |
|
476 |
|
477 |
DROP TABLE IF EXISTS `aqbooksellers`; |
477 |
DROP TABLE IF EXISTS `aqbooksellers`; |
478 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
478 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
479 |
/*!40101 SET character_set_client = utf8 */; |
479 |
/*!40101 SET character_set_client = utf8mb4 */; |
480 |
CREATE TABLE `aqbooksellers` ( |
480 |
CREATE TABLE `aqbooksellers` ( |
481 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
481 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
482 |
`name` longtext NOT NULL COMMENT 'vendor name', |
482 |
`name` longtext NOT NULL COMMENT 'vendor name', |
Lines 516-522
CREATE TABLE `aqbooksellers` (
Link Here
|
516 |
|
516 |
|
517 |
DROP TABLE IF EXISTS `aqbudgetborrowers`; |
517 |
DROP TABLE IF EXISTS `aqbudgetborrowers`; |
518 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
518 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
519 |
/*!40101 SET character_set_client = utf8 */; |
519 |
/*!40101 SET character_set_client = utf8mb4 */; |
520 |
CREATE TABLE `aqbudgetborrowers` ( |
520 |
CREATE TABLE `aqbudgetborrowers` ( |
521 |
`budget_id` int(11) NOT NULL, |
521 |
`budget_id` int(11) NOT NULL, |
522 |
`borrowernumber` int(11) NOT NULL, |
522 |
`borrowernumber` int(11) NOT NULL, |
Lines 533-539
CREATE TABLE `aqbudgetborrowers` (
Link Here
|
533 |
|
533 |
|
534 |
DROP TABLE IF EXISTS `aqbudgetperiods`; |
534 |
DROP TABLE IF EXISTS `aqbudgetperiods`; |
535 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
535 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
536 |
/*!40101 SET character_set_client = utf8 */; |
536 |
/*!40101 SET character_set_client = utf8mb4 */; |
537 |
CREATE TABLE `aqbudgetperiods` ( |
537 |
CREATE TABLE `aqbudgetperiods` ( |
538 |
`budget_period_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned by Koha', |
538 |
`budget_period_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned by Koha', |
539 |
`budget_period_startdate` date NOT NULL COMMENT 'date when the budget starts', |
539 |
`budget_period_startdate` date NOT NULL COMMENT 'date when the budget starts', |
Lines 554-560
CREATE TABLE `aqbudgetperiods` (
Link Here
|
554 |
|
554 |
|
555 |
DROP TABLE IF EXISTS `aqbudgets`; |
555 |
DROP TABLE IF EXISTS `aqbudgets`; |
556 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
556 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
557 |
/*!40101 SET character_set_client = utf8 */; |
557 |
/*!40101 SET character_set_client = utf8mb4 */; |
558 |
CREATE TABLE `aqbudgets` ( |
558 |
CREATE TABLE `aqbudgets` ( |
559 |
`budget_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned to each fund by Koha', |
559 |
`budget_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned to each fund by Koha', |
560 |
`budget_parent_id` int(11) DEFAULT NULL COMMENT 'if this fund is a child of another this will include the parent id (aqbudgets.budget_id)', |
560 |
`budget_parent_id` int(11) DEFAULT NULL COMMENT 'if this fund is a child of another this will include the parent id (aqbudgets.budget_id)', |
Lines 587-593
CREATE TABLE `aqbudgets` (
Link Here
|
587 |
|
587 |
|
588 |
DROP TABLE IF EXISTS `aqbudgets_planning`; |
588 |
DROP TABLE IF EXISTS `aqbudgets_planning`; |
589 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
589 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
590 |
/*!40101 SET character_set_client = utf8 */; |
590 |
/*!40101 SET character_set_client = utf8mb4 */; |
591 |
CREATE TABLE `aqbudgets_planning` ( |
591 |
CREATE TABLE `aqbudgets_planning` ( |
592 |
`plan_id` int(11) NOT NULL AUTO_INCREMENT, |
592 |
`plan_id` int(11) NOT NULL AUTO_INCREMENT, |
593 |
`budget_id` int(11) NOT NULL, |
593 |
`budget_id` int(11) NOT NULL, |
Lines 609-615
CREATE TABLE `aqbudgets_planning` (
Link Here
|
609 |
|
609 |
|
610 |
DROP TABLE IF EXISTS `aqcontacts`; |
610 |
DROP TABLE IF EXISTS `aqcontacts`; |
611 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
611 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
612 |
/*!40101 SET character_set_client = utf8 */; |
612 |
/*!40101 SET character_set_client = utf8mb4 */; |
613 |
CREATE TABLE `aqcontacts` ( |
613 |
CREATE TABLE `aqcontacts` ( |
614 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned by Koha', |
614 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique number assigned by Koha', |
615 |
`name` varchar(100) DEFAULT NULL COMMENT 'name of contact at vendor', |
615 |
`name` varchar(100) DEFAULT NULL COMMENT 'name of contact at vendor', |
Lines 637-643
CREATE TABLE `aqcontacts` (
Link Here
|
637 |
|
637 |
|
638 |
DROP TABLE IF EXISTS `aqcontract`; |
638 |
DROP TABLE IF EXISTS `aqcontract`; |
639 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
639 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
640 |
/*!40101 SET character_set_client = utf8 */; |
640 |
/*!40101 SET character_set_client = utf8mb4 */; |
641 |
CREATE TABLE `aqcontract` ( |
641 |
CREATE TABLE `aqcontract` ( |
642 |
`contractnumber` int(11) NOT NULL AUTO_INCREMENT, |
642 |
`contractnumber` int(11) NOT NULL AUTO_INCREMENT, |
643 |
`contractstartdate` date DEFAULT NULL, |
643 |
`contractstartdate` date DEFAULT NULL, |
Lines 657-663
CREATE TABLE `aqcontract` (
Link Here
|
657 |
|
657 |
|
658 |
DROP TABLE IF EXISTS `aqinvoice_adjustments`; |
658 |
DROP TABLE IF EXISTS `aqinvoice_adjustments`; |
659 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
659 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
660 |
/*!40101 SET character_set_client = utf8 */; |
660 |
/*!40101 SET character_set_client = utf8mb4 */; |
661 |
CREATE TABLE `aqinvoice_adjustments` ( |
661 |
CREATE TABLE `aqinvoice_adjustments` ( |
662 |
`adjustment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for adjustments', |
662 |
`adjustment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for adjustments', |
663 |
`invoiceid` int(11) NOT NULL COMMENT 'foreign key to link an adjustment to an invoice', |
663 |
`invoiceid` int(11) NOT NULL COMMENT 'foreign key to link an adjustment to an invoice', |
Lines 681-687
CREATE TABLE `aqinvoice_adjustments` (
Link Here
|
681 |
|
681 |
|
682 |
DROP TABLE IF EXISTS `aqinvoices`; |
682 |
DROP TABLE IF EXISTS `aqinvoices`; |
683 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
683 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
684 |
/*!40101 SET character_set_client = utf8 */; |
684 |
/*!40101 SET character_set_client = utf8mb4 */; |
685 |
CREATE TABLE `aqinvoices` ( |
685 |
CREATE TABLE `aqinvoices` ( |
686 |
`invoiceid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the invoice, primary key', |
686 |
`invoiceid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the invoice, primary key', |
687 |
`invoicenumber` longtext NOT NULL COMMENT 'Name of invoice', |
687 |
`invoicenumber` longtext NOT NULL COMMENT 'Name of invoice', |
Lines 708-714
CREATE TABLE `aqinvoices` (
Link Here
|
708 |
|
708 |
|
709 |
DROP TABLE IF EXISTS `aqorder_users`; |
709 |
DROP TABLE IF EXISTS `aqorder_users`; |
710 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
710 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
711 |
/*!40101 SET character_set_client = utf8 */; |
711 |
/*!40101 SET character_set_client = utf8mb4 */; |
712 |
CREATE TABLE `aqorder_users` ( |
712 |
CREATE TABLE `aqorder_users` ( |
713 |
`ordernumber` int(11) NOT NULL COMMENT 'the order this patrons receive notifications from (aqorders.ordernumber)', |
713 |
`ordernumber` int(11) NOT NULL COMMENT 'the order this patrons receive notifications from (aqorders.ordernumber)', |
714 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)', |
714 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)', |
Lines 725-731
CREATE TABLE `aqorder_users` (
Link Here
|
725 |
|
725 |
|
726 |
DROP TABLE IF EXISTS `aqorders`; |
726 |
DROP TABLE IF EXISTS `aqorders`; |
727 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
727 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
728 |
/*!40101 SET character_set_client = utf8 */; |
728 |
/*!40101 SET character_set_client = utf8mb4 */; |
729 |
CREATE TABLE `aqorders` ( |
729 |
CREATE TABLE `aqorders` ( |
730 |
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha to each line', |
730 |
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha to each line', |
731 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio being ordered (biblio.biblionumber)', |
731 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio being ordered (biblio.biblionumber)', |
Lines 807-813
CREATE TABLE `aqorders` (
Link Here
|
807 |
|
807 |
|
808 |
DROP TABLE IF EXISTS `aqorders_claims`; |
808 |
DROP TABLE IF EXISTS `aqorders_claims`; |
809 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
809 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
810 |
/*!40101 SET character_set_client = utf8 */; |
810 |
/*!40101 SET character_set_client = utf8mb4 */; |
811 |
CREATE TABLE `aqorders_claims` ( |
811 |
CREATE TABLE `aqorders_claims` ( |
812 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the claims', |
812 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the claims', |
813 |
`ordernumber` int(11) NOT NULL COMMENT 'order linked to this claim', |
813 |
`ordernumber` int(11) NOT NULL COMMENT 'order linked to this claim', |
Lines 824-830
CREATE TABLE `aqorders_claims` (
Link Here
|
824 |
|
824 |
|
825 |
DROP TABLE IF EXISTS `aqorders_items`; |
825 |
DROP TABLE IF EXISTS `aqorders_items`; |
826 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
826 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
827 |
/*!40101 SET character_set_client = utf8 */; |
827 |
/*!40101 SET character_set_client = utf8mb4 */; |
828 |
CREATE TABLE `aqorders_items` ( |
828 |
CREATE TABLE `aqorders_items` ( |
829 |
`ordernumber` int(11) NOT NULL COMMENT 'the order this item is attached to (aqorders.ordernumber)', |
829 |
`ordernumber` int(11) NOT NULL COMMENT 'the order this item is attached to (aqorders.ordernumber)', |
830 |
`itemnumber` int(11) NOT NULL COMMENT 'the item number for this item (items.itemnumber)', |
830 |
`itemnumber` int(11) NOT NULL COMMENT 'the item number for this item (items.itemnumber)', |
Lines 841-847
CREATE TABLE `aqorders_items` (
Link Here
|
841 |
|
841 |
|
842 |
DROP TABLE IF EXISTS `aqorders_transfers`; |
842 |
DROP TABLE IF EXISTS `aqorders_transfers`; |
843 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
843 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
844 |
/*!40101 SET character_set_client = utf8 */; |
844 |
/*!40101 SET character_set_client = utf8mb4 */; |
845 |
CREATE TABLE `aqorders_transfers` ( |
845 |
CREATE TABLE `aqorders_transfers` ( |
846 |
`ordernumber_from` int(11) DEFAULT NULL, |
846 |
`ordernumber_from` int(11) DEFAULT NULL, |
847 |
`ordernumber_to` int(11) DEFAULT NULL, |
847 |
`ordernumber_to` int(11) DEFAULT NULL, |
Lines 859-865
CREATE TABLE `aqorders_transfers` (
Link Here
|
859 |
|
859 |
|
860 |
DROP TABLE IF EXISTS `article_requests`; |
860 |
DROP TABLE IF EXISTS `article_requests`; |
861 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
861 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
862 |
/*!40101 SET character_set_client = utf8 */; |
862 |
/*!40101 SET character_set_client = utf8mb4 */; |
863 |
CREATE TABLE `article_requests` ( |
863 |
CREATE TABLE `article_requests` ( |
864 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
864 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
865 |
`borrowernumber` int(11) NOT NULL, |
865 |
`borrowernumber` int(11) NOT NULL, |
Lines 903-909
CREATE TABLE `article_requests` (
Link Here
|
903 |
|
903 |
|
904 |
DROP TABLE IF EXISTS `audio_alerts`; |
904 |
DROP TABLE IF EXISTS `audio_alerts`; |
905 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
905 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
906 |
/*!40101 SET character_set_client = utf8 */; |
906 |
/*!40101 SET character_set_client = utf8mb4 */; |
907 |
CREATE TABLE `audio_alerts` ( |
907 |
CREATE TABLE `audio_alerts` ( |
908 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
908 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
909 |
`precedence` smallint(5) unsigned NOT NULL, |
909 |
`precedence` smallint(5) unsigned NOT NULL, |
Lines 920-926
CREATE TABLE `audio_alerts` (
Link Here
|
920 |
|
920 |
|
921 |
DROP TABLE IF EXISTS `auth_header`; |
921 |
DROP TABLE IF EXISTS `auth_header`; |
922 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
922 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
923 |
/*!40101 SET character_set_client = utf8 */; |
923 |
/*!40101 SET character_set_client = utf8mb4 */; |
924 |
CREATE TABLE `auth_header` ( |
924 |
CREATE TABLE `auth_header` ( |
925 |
`authid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
925 |
`authid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
926 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
926 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
Lines 942-948
CREATE TABLE `auth_header` (
Link Here
|
942 |
|
942 |
|
943 |
DROP TABLE IF EXISTS `auth_subfield_structure`; |
943 |
DROP TABLE IF EXISTS `auth_subfield_structure`; |
944 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
944 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
945 |
/*!40101 SET character_set_client = utf8 */; |
945 |
/*!40101 SET character_set_client = utf8mb4 */; |
946 |
CREATE TABLE `auth_subfield_structure` ( |
946 |
CREATE TABLE `auth_subfield_structure` ( |
947 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
947 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
948 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
948 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
Lines 974-980
CREATE TABLE `auth_subfield_structure` (
Link Here
|
974 |
|
974 |
|
975 |
DROP TABLE IF EXISTS `auth_tag_structure`; |
975 |
DROP TABLE IF EXISTS `auth_tag_structure`; |
976 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
976 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
977 |
/*!40101 SET character_set_client = utf8 */; |
977 |
/*!40101 SET character_set_client = utf8mb4 */; |
978 |
CREATE TABLE `auth_tag_structure` ( |
978 |
CREATE TABLE `auth_tag_structure` ( |
979 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
979 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
980 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
980 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
Lines 994-1000
CREATE TABLE `auth_tag_structure` (
Link Here
|
994 |
|
994 |
|
995 |
DROP TABLE IF EXISTS `auth_types`; |
995 |
DROP TABLE IF EXISTS `auth_types`; |
996 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
996 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
997 |
/*!40101 SET character_set_client = utf8 */; |
997 |
/*!40101 SET character_set_client = utf8mb4 */; |
998 |
CREATE TABLE `auth_types` ( |
998 |
CREATE TABLE `auth_types` ( |
999 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
999 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
1000 |
`authtypetext` varchar(255) NOT NULL DEFAULT '', |
1000 |
`authtypetext` varchar(255) NOT NULL DEFAULT '', |
Lines 1010-1016
CREATE TABLE `auth_types` (
Link Here
|
1010 |
|
1010 |
|
1011 |
DROP TABLE IF EXISTS `authorised_value_categories`; |
1011 |
DROP TABLE IF EXISTS `authorised_value_categories`; |
1012 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1012 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1013 |
/*!40101 SET character_set_client = utf8 */; |
1013 |
/*!40101 SET character_set_client = utf8mb4 */; |
1014 |
CREATE TABLE `authorised_value_categories` ( |
1014 |
CREATE TABLE `authorised_value_categories` ( |
1015 |
`category_name` varchar(32) NOT NULL DEFAULT '', |
1015 |
`category_name` varchar(32) NOT NULL DEFAULT '', |
1016 |
`is_system` tinyint(1) DEFAULT 0, |
1016 |
`is_system` tinyint(1) DEFAULT 0, |
Lines 1025-1031
CREATE TABLE `authorised_value_categories` (
Link Here
|
1025 |
|
1025 |
|
1026 |
DROP TABLE IF EXISTS `authorised_values`; |
1026 |
DROP TABLE IF EXISTS `authorised_values`; |
1027 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1027 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1028 |
/*!40101 SET character_set_client = utf8 */; |
1028 |
/*!40101 SET character_set_client = utf8mb4 */; |
1029 |
CREATE TABLE `authorised_values` ( |
1029 |
CREATE TABLE `authorised_values` ( |
1030 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value', |
1030 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value', |
1031 |
`category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category', |
1031 |
`category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category', |
Lines 1048-1054
CREATE TABLE `authorised_values` (
Link Here
|
1048 |
|
1048 |
|
1049 |
DROP TABLE IF EXISTS `authorised_values_branches`; |
1049 |
DROP TABLE IF EXISTS `authorised_values_branches`; |
1050 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1050 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1051 |
/*!40101 SET character_set_client = utf8 */; |
1051 |
/*!40101 SET character_set_client = utf8mb4 */; |
1052 |
CREATE TABLE `authorised_values_branches` ( |
1052 |
CREATE TABLE `authorised_values_branches` ( |
1053 |
`av_id` int(11) NOT NULL, |
1053 |
`av_id` int(11) NOT NULL, |
1054 |
`branchcode` varchar(10) NOT NULL, |
1054 |
`branchcode` varchar(10) NOT NULL, |
Lines 1065-1071
CREATE TABLE `authorised_values_branches` (
Link Here
|
1065 |
|
1065 |
|
1066 |
DROP TABLE IF EXISTS `background_jobs`; |
1066 |
DROP TABLE IF EXISTS `background_jobs`; |
1067 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1067 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1068 |
/*!40101 SET character_set_client = utf8 */; |
1068 |
/*!40101 SET character_set_client = utf8mb4 */; |
1069 |
CREATE TABLE `background_jobs` ( |
1069 |
CREATE TABLE `background_jobs` ( |
1070 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1070 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1071 |
`status` varchar(32) DEFAULT NULL, |
1071 |
`status` varchar(32) DEFAULT NULL, |
Lines 1092-1098
CREATE TABLE `background_jobs` (
Link Here
|
1092 |
|
1092 |
|
1093 |
DROP TABLE IF EXISTS `biblio`; |
1093 |
DROP TABLE IF EXISTS `biblio`; |
1094 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1094 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1095 |
/*!40101 SET character_set_client = utf8 */; |
1095 |
/*!40101 SET character_set_client = utf8mb4 */; |
1096 |
CREATE TABLE `biblio` ( |
1096 |
CREATE TABLE `biblio` ( |
1097 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
1097 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
1098 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record', |
1098 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record', |
Lines 1121-1127
CREATE TABLE `biblio` (
Link Here
|
1121 |
|
1121 |
|
1122 |
DROP TABLE IF EXISTS `biblio_framework`; |
1122 |
DROP TABLE IF EXISTS `biblio_framework`; |
1123 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1123 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1124 |
/*!40101 SET character_set_client = utf8 */; |
1124 |
/*!40101 SET character_set_client = utf8mb4 */; |
1125 |
CREATE TABLE `biblio_framework` ( |
1125 |
CREATE TABLE `biblio_framework` ( |
1126 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'the unique code assigned to the framework', |
1126 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'the unique code assigned to the framework', |
1127 |
`frameworktext` varchar(255) NOT NULL DEFAULT '' COMMENT 'the description/name given to the framework', |
1127 |
`frameworktext` varchar(255) NOT NULL DEFAULT '' COMMENT 'the description/name given to the framework', |
Lines 1135-1141
CREATE TABLE `biblio_framework` (
Link Here
|
1135 |
|
1135 |
|
1136 |
DROP TABLE IF EXISTS `biblio_metadata`; |
1136 |
DROP TABLE IF EXISTS `biblio_metadata`; |
1137 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1137 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1138 |
/*!40101 SET character_set_client = utf8 */; |
1138 |
/*!40101 SET character_set_client = utf8mb4 */; |
1139 |
CREATE TABLE `biblio_metadata` ( |
1139 |
CREATE TABLE `biblio_metadata` ( |
1140 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1140 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1141 |
`biblionumber` int(11) NOT NULL, |
1141 |
`biblionumber` int(11) NOT NULL, |
Lines 1159-1165
CREATE TABLE `biblio_metadata` (
Link Here
|
1159 |
|
1159 |
|
1160 |
DROP TABLE IF EXISTS `biblioitems`; |
1160 |
DROP TABLE IF EXISTS `biblioitems`; |
1161 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1161 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1162 |
/*!40101 SET character_set_client = utf8 */; |
1162 |
/*!40101 SET character_set_client = utf8mb4 */; |
1163 |
CREATE TABLE `biblioitems` ( |
1163 |
CREATE TABLE `biblioitems` ( |
1164 |
`biblioitemnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, unique identifier assigned by Koha', |
1164 |
`biblioitemnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, unique identifier assigned by Koha', |
1165 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking this table to the biblio table', |
1165 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking this table to the biblio table', |
Lines 1212-1218
CREATE TABLE `biblioitems` (
Link Here
|
1212 |
|
1212 |
|
1213 |
DROP TABLE IF EXISTS `bookings`; |
1213 |
DROP TABLE IF EXISTS `bookings`; |
1214 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1214 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1215 |
/*!40101 SET character_set_client = utf8 */; |
1215 |
/*!40101 SET character_set_client = utf8mb4 */; |
1216 |
CREATE TABLE `bookings` ( |
1216 |
CREATE TABLE `bookings` ( |
1217 |
`booking_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
1217 |
`booking_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
1218 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
1218 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this booking is for', |
Lines 1243-1249
CREATE TABLE `bookings` (
Link Here
|
1243 |
|
1243 |
|
1244 |
DROP TABLE IF EXISTS `borrower_attribute_types`; |
1244 |
DROP TABLE IF EXISTS `borrower_attribute_types`; |
1245 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1245 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1246 |
/*!40101 SET character_set_client = utf8 */; |
1246 |
/*!40101 SET character_set_client = utf8mb4 */; |
1247 |
CREATE TABLE `borrower_attribute_types` ( |
1247 |
CREATE TABLE `borrower_attribute_types` ( |
1248 |
`code` varchar(64) NOT NULL COMMENT 'unique key used to identify each custom field', |
1248 |
`code` varchar(64) NOT NULL COMMENT 'unique key used to identify each custom field', |
1249 |
`description` varchar(255) NOT NULL COMMENT 'description for each custom field', |
1249 |
`description` varchar(255) NOT NULL COMMENT 'description for each custom field', |
Lines 1274-1280
CREATE TABLE `borrower_attribute_types` (
Link Here
|
1274 |
|
1274 |
|
1275 |
DROP TABLE IF EXISTS `borrower_attribute_types_branches`; |
1275 |
DROP TABLE IF EXISTS `borrower_attribute_types_branches`; |
1276 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1276 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1277 |
/*!40101 SET character_set_client = utf8 */; |
1277 |
/*!40101 SET character_set_client = utf8mb4 */; |
1278 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1278 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1279 |
`bat_code` varchar(64) DEFAULT NULL, |
1279 |
`bat_code` varchar(64) DEFAULT NULL, |
1280 |
`b_branchcode` varchar(10) DEFAULT NULL, |
1280 |
`b_branchcode` varchar(10) DEFAULT NULL, |
Lines 1291-1297
CREATE TABLE `borrower_attribute_types_branches` (
Link Here
|
1291 |
|
1291 |
|
1292 |
DROP TABLE IF EXISTS `borrower_attributes`; |
1292 |
DROP TABLE IF EXISTS `borrower_attributes`; |
1293 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1293 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1294 |
/*!40101 SET character_set_client = utf8 */; |
1294 |
/*!40101 SET character_set_client = utf8mb4 */; |
1295 |
CREATE TABLE `borrower_attributes` ( |
1295 |
CREATE TABLE `borrower_attributes` ( |
1296 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1296 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1297 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
1297 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
Lines 1311-1317
CREATE TABLE `borrower_attributes` (
Link Here
|
1311 |
|
1311 |
|
1312 |
DROP TABLE IF EXISTS `borrower_debarments`; |
1312 |
DROP TABLE IF EXISTS `borrower_debarments`; |
1313 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1313 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1314 |
/*!40101 SET character_set_client = utf8 */; |
1314 |
/*!40101 SET character_set_client = utf8mb4 */; |
1315 |
CREATE TABLE `borrower_debarments` ( |
1315 |
CREATE TABLE `borrower_debarments` ( |
1316 |
`borrower_debarment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the restriction', |
1316 |
`borrower_debarment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the restriction', |
1317 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key for borrowers.borrowernumber for patron who is restricted', |
1317 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key for borrowers.borrowernumber for patron who is restricted', |
Lines 1335-1341
CREATE TABLE `borrower_debarments` (
Link Here
|
1335 |
|
1335 |
|
1336 |
DROP TABLE IF EXISTS `borrower_files`; |
1336 |
DROP TABLE IF EXISTS `borrower_files`; |
1337 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1337 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1338 |
/*!40101 SET character_set_client = utf8 */; |
1338 |
/*!40101 SET character_set_client = utf8mb4 */; |
1339 |
CREATE TABLE `borrower_files` ( |
1339 |
CREATE TABLE `borrower_files` ( |
1340 |
`file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
1340 |
`file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
1341 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key linking to the patron via the borrowernumber', |
1341 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key linking to the patron via the borrowernumber', |
Lines 1356-1362
CREATE TABLE `borrower_files` (
Link Here
|
1356 |
|
1356 |
|
1357 |
DROP TABLE IF EXISTS `borrower_message_preferences`; |
1357 |
DROP TABLE IF EXISTS `borrower_message_preferences`; |
1358 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1358 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1359 |
/*!40101 SET character_set_client = utf8 */; |
1359 |
/*!40101 SET character_set_client = utf8mb4 */; |
1360 |
CREATE TABLE `borrower_message_preferences` ( |
1360 |
CREATE TABLE `borrower_message_preferences` ( |
1361 |
`borrower_message_preference_id` int(11) NOT NULL AUTO_INCREMENT, |
1361 |
`borrower_message_preference_id` int(11) NOT NULL AUTO_INCREMENT, |
1362 |
`borrowernumber` int(11) DEFAULT NULL, |
1362 |
`borrowernumber` int(11) DEFAULT NULL, |
Lines 1380-1386
CREATE TABLE `borrower_message_preferences` (
Link Here
|
1380 |
|
1380 |
|
1381 |
DROP TABLE IF EXISTS `borrower_message_transport_preferences`; |
1381 |
DROP TABLE IF EXISTS `borrower_message_transport_preferences`; |
1382 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1382 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1383 |
/*!40101 SET character_set_client = utf8 */; |
1383 |
/*!40101 SET character_set_client = utf8mb4 */; |
1384 |
CREATE TABLE `borrower_message_transport_preferences` ( |
1384 |
CREATE TABLE `borrower_message_transport_preferences` ( |
1385 |
`borrower_message_preference_id` int(11) NOT NULL DEFAULT 0, |
1385 |
`borrower_message_preference_id` int(11) NOT NULL DEFAULT 0, |
1386 |
`message_transport_type` varchar(20) NOT NULL DEFAULT '0', |
1386 |
`message_transport_type` varchar(20) NOT NULL DEFAULT '0', |
Lines 1397-1403
CREATE TABLE `borrower_message_transport_preferences` (
Link Here
|
1397 |
|
1397 |
|
1398 |
DROP TABLE IF EXISTS `borrower_modifications`; |
1398 |
DROP TABLE IF EXISTS `borrower_modifications`; |
1399 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1399 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1400 |
/*!40101 SET character_set_client = utf8 */; |
1400 |
/*!40101 SET character_set_client = utf8mb4 */; |
1401 |
CREATE TABLE `borrower_modifications` ( |
1401 |
CREATE TABLE `borrower_modifications` ( |
1402 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
1402 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
1403 |
`verification_token` varchar(255) NOT NULL DEFAULT '', |
1403 |
`verification_token` varchar(255) NOT NULL DEFAULT '', |
Lines 1486-1492
CREATE TABLE `borrower_modifications` (
Link Here
|
1486 |
|
1486 |
|
1487 |
DROP TABLE IF EXISTS `borrower_password_recovery`; |
1487 |
DROP TABLE IF EXISTS `borrower_password_recovery`; |
1488 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1488 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1489 |
/*!40101 SET character_set_client = utf8 */; |
1489 |
/*!40101 SET character_set_client = utf8mb4 */; |
1490 |
CREATE TABLE `borrower_password_recovery` ( |
1490 |
CREATE TABLE `borrower_password_recovery` ( |
1491 |
`borrowernumber` int(11) NOT NULL COMMENT 'the user asking a password recovery', |
1491 |
`borrowernumber` int(11) NOT NULL COMMENT 'the user asking a password recovery', |
1492 |
`uuid` varchar(128) NOT NULL COMMENT 'a unique string to identify a password recovery attempt', |
1492 |
`uuid` varchar(128) NOT NULL COMMENT 'a unique string to identify a password recovery attempt', |
Lines 1502-1508
CREATE TABLE `borrower_password_recovery` (
Link Here
|
1502 |
|
1502 |
|
1503 |
DROP TABLE IF EXISTS `borrower_relationships`; |
1503 |
DROP TABLE IF EXISTS `borrower_relationships`; |
1504 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1504 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1505 |
/*!40101 SET character_set_client = utf8 */; |
1505 |
/*!40101 SET character_set_client = utf8mb4 */; |
1506 |
CREATE TABLE `borrower_relationships` ( |
1506 |
CREATE TABLE `borrower_relationships` ( |
1507 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1507 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1508 |
`guarantor_id` int(11) NOT NULL, |
1508 |
`guarantor_id` int(11) NOT NULL, |
Lines 1522-1528
CREATE TABLE `borrower_relationships` (
Link Here
|
1522 |
|
1522 |
|
1523 |
DROP TABLE IF EXISTS `borrowers`; |
1523 |
DROP TABLE IF EXISTS `borrowers`; |
1524 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1524 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1525 |
/*!40101 SET character_set_client = utf8 */; |
1525 |
/*!40101 SET character_set_client = utf8mb4 */; |
1526 |
CREATE TABLE `borrowers` ( |
1526 |
CREATE TABLE `borrowers` ( |
1527 |
`borrowernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, Koha assigned ID number for patrons/borrowers', |
1527 |
`borrowernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, Koha assigned ID number for patrons/borrowers', |
1528 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1528 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
Lines 1632-1638
CREATE TABLE `borrowers` (
Link Here
|
1632 |
|
1632 |
|
1633 |
DROP TABLE IF EXISTS `branch_transfer_limits`; |
1633 |
DROP TABLE IF EXISTS `branch_transfer_limits`; |
1634 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1634 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1635 |
/*!40101 SET character_set_client = utf8 */; |
1635 |
/*!40101 SET character_set_client = utf8mb4 */; |
1636 |
CREATE TABLE `branch_transfer_limits` ( |
1636 |
CREATE TABLE `branch_transfer_limits` ( |
1637 |
`limitId` int(8) NOT NULL AUTO_INCREMENT, |
1637 |
`limitId` int(8) NOT NULL AUTO_INCREMENT, |
1638 |
`toBranch` varchar(10) NOT NULL, |
1638 |
`toBranch` varchar(10) NOT NULL, |
Lines 1650-1656
CREATE TABLE `branch_transfer_limits` (
Link Here
|
1650 |
|
1650 |
|
1651 |
DROP TABLE IF EXISTS `branches`; |
1651 |
DROP TABLE IF EXISTS `branches`; |
1652 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1652 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1653 |
/*!40101 SET character_set_client = utf8 */; |
1653 |
/*!40101 SET character_set_client = utf8mb4 */; |
1654 |
CREATE TABLE `branches` ( |
1654 |
CREATE TABLE `branches` ( |
1655 |
`branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'a unique key assigned to each branch', |
1655 |
`branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'a unique key assigned to each branch', |
1656 |
`branchname` longtext NOT NULL COMMENT 'the name of your library or branch', |
1656 |
`branchname` longtext NOT NULL COMMENT 'the name of your library or branch', |
Lines 1687-1693
CREATE TABLE `branches` (
Link Here
|
1687 |
|
1687 |
|
1688 |
DROP TABLE IF EXISTS `branches_overdrive`; |
1688 |
DROP TABLE IF EXISTS `branches_overdrive`; |
1689 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1689 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1690 |
/*!40101 SET character_set_client = utf8 */; |
1690 |
/*!40101 SET character_set_client = utf8mb4 */; |
1691 |
CREATE TABLE `branches_overdrive` ( |
1691 |
CREATE TABLE `branches_overdrive` ( |
1692 |
`branchcode` varchar(10) NOT NULL, |
1692 |
`branchcode` varchar(10) NOT NULL, |
1693 |
`authname` varchar(255) NOT NULL, |
1693 |
`authname` varchar(255) NOT NULL, |
Lines 1702-1708
CREATE TABLE `branches_overdrive` (
Link Here
|
1702 |
|
1702 |
|
1703 |
DROP TABLE IF EXISTS `branchtransfers`; |
1703 |
DROP TABLE IF EXISTS `branchtransfers`; |
1704 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1704 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1705 |
/*!40101 SET character_set_client = utf8 */; |
1705 |
/*!40101 SET character_set_client = utf8mb4 */; |
1706 |
CREATE TABLE `branchtransfers` ( |
1706 |
CREATE TABLE `branchtransfers` ( |
1707 |
`branchtransfer_id` int(12) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
1707 |
`branchtransfer_id` int(12) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
1708 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the itemnumber that it is in transit (items.itemnumber)', |
1708 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the itemnumber that it is in transit (items.itemnumber)', |
Lines 1731-1737
CREATE TABLE `branchtransfers` (
Link Here
|
1731 |
|
1731 |
|
1732 |
DROP TABLE IF EXISTS `browser`; |
1732 |
DROP TABLE IF EXISTS `browser`; |
1733 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1733 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1734 |
/*!40101 SET character_set_client = utf8 */; |
1734 |
/*!40101 SET character_set_client = utf8mb4 */; |
1735 |
CREATE TABLE `browser` ( |
1735 |
CREATE TABLE `browser` ( |
1736 |
`level` int(11) NOT NULL, |
1736 |
`level` int(11) NOT NULL, |
1737 |
`classification` varchar(20) NOT NULL, |
1737 |
`classification` varchar(20) NOT NULL, |
Lines 1747-1753
CREATE TABLE `browser` (
Link Here
|
1747 |
|
1747 |
|
1748 |
DROP TABLE IF EXISTS `cash_register_actions`; |
1748 |
DROP TABLE IF EXISTS `cash_register_actions`; |
1749 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1749 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1750 |
/*!40101 SET character_set_client = utf8 */; |
1750 |
/*!40101 SET character_set_client = utf8mb4 */; |
1751 |
CREATE TABLE `cash_register_actions` ( |
1751 |
CREATE TABLE `cash_register_actions` ( |
1752 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each account register action', |
1752 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each account register action', |
1753 |
`code` varchar(24) NOT NULL COMMENT 'action code denoting the type of action recorded (enum),', |
1753 |
`code` varchar(24) NOT NULL COMMENT 'action code denoting the type of action recorded (enum),', |
Lines 1769-1775
CREATE TABLE `cash_register_actions` (
Link Here
|
1769 |
|
1769 |
|
1770 |
DROP TABLE IF EXISTS `cash_registers`; |
1770 |
DROP TABLE IF EXISTS `cash_registers`; |
1771 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1771 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1772 |
/*!40101 SET character_set_client = utf8 */; |
1772 |
/*!40101 SET character_set_client = utf8mb4 */; |
1773 |
CREATE TABLE `cash_registers` ( |
1773 |
CREATE TABLE `cash_registers` ( |
1774 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each account register', |
1774 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for each account register', |
1775 |
`name` varchar(24) NOT NULL COMMENT 'the user friendly identifier for each account register', |
1775 |
`name` varchar(24) NOT NULL COMMENT 'the user friendly identifier for each account register', |
Lines 1791-1797
CREATE TABLE `cash_registers` (
Link Here
|
1791 |
|
1791 |
|
1792 |
DROP TABLE IF EXISTS `categories`; |
1792 |
DROP TABLE IF EXISTS `categories`; |
1793 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1793 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1794 |
/*!40101 SET character_set_client = utf8 */; |
1794 |
/*!40101 SET character_set_client = utf8mb4 */; |
1795 |
CREATE TABLE `categories` ( |
1795 |
CREATE TABLE `categories` ( |
1796 |
`categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'unique primary key used to idenfity the patron category', |
1796 |
`categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'unique primary key used to idenfity the patron category', |
1797 |
`description` longtext DEFAULT NULL COMMENT 'description of the patron category', |
1797 |
`description` longtext DEFAULT NULL COMMENT 'description of the patron category', |
Lines 1830-1836
CREATE TABLE `categories` (
Link Here
|
1830 |
|
1830 |
|
1831 |
DROP TABLE IF EXISTS `categories_branches`; |
1831 |
DROP TABLE IF EXISTS `categories_branches`; |
1832 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1832 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1833 |
/*!40101 SET character_set_client = utf8 */; |
1833 |
/*!40101 SET character_set_client = utf8mb4 */; |
1834 |
CREATE TABLE `categories_branches` ( |
1834 |
CREATE TABLE `categories_branches` ( |
1835 |
`categorycode` varchar(10) DEFAULT NULL, |
1835 |
`categorycode` varchar(10) DEFAULT NULL, |
1836 |
`branchcode` varchar(10) DEFAULT NULL, |
1836 |
`branchcode` varchar(10) DEFAULT NULL, |
Lines 1847-1853
CREATE TABLE `categories_branches` (
Link Here
|
1847 |
|
1847 |
|
1848 |
DROP TABLE IF EXISTS `checkout_renewals`; |
1848 |
DROP TABLE IF EXISTS `checkout_renewals`; |
1849 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1849 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1850 |
/*!40101 SET character_set_client = utf8 */; |
1850 |
/*!40101 SET character_set_client = utf8mb4 */; |
1851 |
CREATE TABLE `checkout_renewals` ( |
1851 |
CREATE TABLE `checkout_renewals` ( |
1852 |
`renewal_id` int(11) NOT NULL AUTO_INCREMENT, |
1852 |
`renewal_id` int(11) NOT NULL AUTO_INCREMENT, |
1853 |
`checkout_id` int(11) DEFAULT NULL COMMENT 'the id of the checkout this renewal pertains to', |
1853 |
`checkout_id` int(11) DEFAULT NULL COMMENT 'the id of the checkout this renewal pertains to', |
Lines 1868-1874
CREATE TABLE `checkout_renewals` (
Link Here
|
1868 |
|
1868 |
|
1869 |
DROP TABLE IF EXISTS `circulation_rules`; |
1869 |
DROP TABLE IF EXISTS `circulation_rules`; |
1870 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1870 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1871 |
/*!40101 SET character_set_client = utf8 */; |
1871 |
/*!40101 SET character_set_client = utf8mb4 */; |
1872 |
CREATE TABLE `circulation_rules` ( |
1872 |
CREATE TABLE `circulation_rules` ( |
1873 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1873 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1874 |
`branchcode` varchar(10) DEFAULT NULL, |
1874 |
`branchcode` varchar(10) DEFAULT NULL, |
Lines 1893-1899
CREATE TABLE `circulation_rules` (
Link Here
|
1893 |
|
1893 |
|
1894 |
DROP TABLE IF EXISTS `cities`; |
1894 |
DROP TABLE IF EXISTS `cities`; |
1895 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1895 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1896 |
/*!40101 SET character_set_client = utf8 */; |
1896 |
/*!40101 SET character_set_client = utf8mb4 */; |
1897 |
CREATE TABLE `cities` ( |
1897 |
CREATE TABLE `cities` ( |
1898 |
`cityid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier added by Koha', |
1898 |
`cityid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier added by Koha', |
1899 |
`city_name` varchar(100) NOT NULL DEFAULT '' COMMENT 'name of the city', |
1899 |
`city_name` varchar(100) NOT NULL DEFAULT '' COMMENT 'name of the city', |
Lines 1910-1916
CREATE TABLE `cities` (
Link Here
|
1910 |
|
1910 |
|
1911 |
DROP TABLE IF EXISTS `class_sort_rules`; |
1911 |
DROP TABLE IF EXISTS `class_sort_rules`; |
1912 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1912 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1913 |
/*!40101 SET character_set_client = utf8 */; |
1913 |
/*!40101 SET character_set_client = utf8mb4 */; |
1914 |
CREATE TABLE `class_sort_rules` ( |
1914 |
CREATE TABLE `class_sort_rules` ( |
1915 |
`class_sort_rule` varchar(10) NOT NULL DEFAULT '', |
1915 |
`class_sort_rule` varchar(10) NOT NULL DEFAULT '', |
1916 |
`description` longtext DEFAULT NULL, |
1916 |
`description` longtext DEFAULT NULL, |
Lines 1926-1932
CREATE TABLE `class_sort_rules` (
Link Here
|
1926 |
|
1926 |
|
1927 |
DROP TABLE IF EXISTS `class_sources`; |
1927 |
DROP TABLE IF EXISTS `class_sources`; |
1928 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1928 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1929 |
/*!40101 SET character_set_client = utf8 */; |
1929 |
/*!40101 SET character_set_client = utf8mb4 */; |
1930 |
CREATE TABLE `class_sources` ( |
1930 |
CREATE TABLE `class_sources` ( |
1931 |
`cn_source` varchar(10) NOT NULL DEFAULT '', |
1931 |
`cn_source` varchar(10) NOT NULL DEFAULT '', |
1932 |
`description` longtext DEFAULT NULL, |
1932 |
`description` longtext DEFAULT NULL, |
Lines 1949-1955
CREATE TABLE `class_sources` (
Link Here
|
1949 |
|
1949 |
|
1950 |
DROP TABLE IF EXISTS `class_split_rules`; |
1950 |
DROP TABLE IF EXISTS `class_split_rules`; |
1951 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1951 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1952 |
/*!40101 SET character_set_client = utf8 */; |
1952 |
/*!40101 SET character_set_client = utf8mb4 */; |
1953 |
CREATE TABLE `class_split_rules` ( |
1953 |
CREATE TABLE `class_split_rules` ( |
1954 |
`class_split_rule` varchar(10) NOT NULL DEFAULT '', |
1954 |
`class_split_rule` varchar(10) NOT NULL DEFAULT '', |
1955 |
`description` longtext DEFAULT NULL, |
1955 |
`description` longtext DEFAULT NULL, |
Lines 1966-1972
CREATE TABLE `class_split_rules` (
Link Here
|
1966 |
|
1966 |
|
1967 |
DROP TABLE IF EXISTS `club_enrollment_fields`; |
1967 |
DROP TABLE IF EXISTS `club_enrollment_fields`; |
1968 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1968 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1969 |
/*!40101 SET character_set_client = utf8 */; |
1969 |
/*!40101 SET character_set_client = utf8mb4 */; |
1970 |
CREATE TABLE `club_enrollment_fields` ( |
1970 |
CREATE TABLE `club_enrollment_fields` ( |
1971 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1971 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1972 |
`club_enrollment_id` int(11) NOT NULL, |
1972 |
`club_enrollment_id` int(11) NOT NULL, |
Lines 1986-1992
CREATE TABLE `club_enrollment_fields` (
Link Here
|
1986 |
|
1986 |
|
1987 |
DROP TABLE IF EXISTS `club_enrollments`; |
1987 |
DROP TABLE IF EXISTS `club_enrollments`; |
1988 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1988 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1989 |
/*!40101 SET character_set_client = utf8 */; |
1989 |
/*!40101 SET character_set_client = utf8mb4 */; |
1990 |
CREATE TABLE `club_enrollments` ( |
1990 |
CREATE TABLE `club_enrollments` ( |
1991 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1991 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1992 |
`club_id` int(11) NOT NULL, |
1992 |
`club_id` int(11) NOT NULL, |
Lines 2012-2018
CREATE TABLE `club_enrollments` (
Link Here
|
2012 |
|
2012 |
|
2013 |
DROP TABLE IF EXISTS `club_fields`; |
2013 |
DROP TABLE IF EXISTS `club_fields`; |
2014 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2014 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2015 |
/*!40101 SET character_set_client = utf8 */; |
2015 |
/*!40101 SET character_set_client = utf8mb4 */; |
2016 |
CREATE TABLE `club_fields` ( |
2016 |
CREATE TABLE `club_fields` ( |
2017 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2017 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2018 |
`club_template_field_id` int(11) NOT NULL, |
2018 |
`club_template_field_id` int(11) NOT NULL, |
Lines 2032-2038
CREATE TABLE `club_fields` (
Link Here
|
2032 |
|
2032 |
|
2033 |
DROP TABLE IF EXISTS `club_holds`; |
2033 |
DROP TABLE IF EXISTS `club_holds`; |
2034 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2034 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2035 |
/*!40101 SET character_set_client = utf8 */; |
2035 |
/*!40101 SET character_set_client = utf8mb4 */; |
2036 |
CREATE TABLE `club_holds` ( |
2036 |
CREATE TABLE `club_holds` ( |
2037 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2037 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2038 |
`club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for', |
2038 |
`club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for', |
Lines 2055-2061
CREATE TABLE `club_holds` (
Link Here
|
2055 |
|
2055 |
|
2056 |
DROP TABLE IF EXISTS `club_holds_to_patron_holds`; |
2056 |
DROP TABLE IF EXISTS `club_holds_to_patron_holds`; |
2057 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2057 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2058 |
/*!40101 SET character_set_client = utf8 */; |
2058 |
/*!40101 SET character_set_client = utf8mb4 */; |
2059 |
CREATE TABLE `club_holds_to_patron_holds` ( |
2059 |
CREATE TABLE `club_holds_to_patron_holds` ( |
2060 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2060 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2061 |
`club_hold_id` int(11) NOT NULL, |
2061 |
`club_hold_id` int(11) NOT NULL, |
Lines 2079-2085
CREATE TABLE `club_holds_to_patron_holds` (
Link Here
|
2079 |
|
2079 |
|
2080 |
DROP TABLE IF EXISTS `club_template_enrollment_fields`; |
2080 |
DROP TABLE IF EXISTS `club_template_enrollment_fields`; |
2081 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2081 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2082 |
/*!40101 SET character_set_client = utf8 */; |
2082 |
/*!40101 SET character_set_client = utf8mb4 */; |
2083 |
CREATE TABLE `club_template_enrollment_fields` ( |
2083 |
CREATE TABLE `club_template_enrollment_fields` ( |
2084 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2084 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2085 |
`club_template_id` int(11) NOT NULL, |
2085 |
`club_template_id` int(11) NOT NULL, |
Lines 2098-2104
CREATE TABLE `club_template_enrollment_fields` (
Link Here
|
2098 |
|
2098 |
|
2099 |
DROP TABLE IF EXISTS `club_template_fields`; |
2099 |
DROP TABLE IF EXISTS `club_template_fields`; |
2100 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2100 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2101 |
/*!40101 SET character_set_client = utf8 */; |
2101 |
/*!40101 SET character_set_client = utf8mb4 */; |
2102 |
CREATE TABLE `club_template_fields` ( |
2102 |
CREATE TABLE `club_template_fields` ( |
2103 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2103 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2104 |
`club_template_id` int(11) NOT NULL, |
2104 |
`club_template_id` int(11) NOT NULL, |
Lines 2117-2123
CREATE TABLE `club_template_fields` (
Link Here
|
2117 |
|
2117 |
|
2118 |
DROP TABLE IF EXISTS `club_templates`; |
2118 |
DROP TABLE IF EXISTS `club_templates`; |
2119 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2119 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2120 |
/*!40101 SET character_set_client = utf8 */; |
2120 |
/*!40101 SET character_set_client = utf8mb4 */; |
2121 |
CREATE TABLE `club_templates` ( |
2121 |
CREATE TABLE `club_templates` ( |
2122 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2122 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2123 |
`name` text NOT NULL, |
2123 |
`name` text NOT NULL, |
Lines 2140-2146
CREATE TABLE `club_templates` (
Link Here
|
2140 |
|
2140 |
|
2141 |
DROP TABLE IF EXISTS `clubs`; |
2141 |
DROP TABLE IF EXISTS `clubs`; |
2142 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2142 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2143 |
/*!40101 SET character_set_client = utf8 */; |
2143 |
/*!40101 SET character_set_client = utf8mb4 */; |
2144 |
CREATE TABLE `clubs` ( |
2144 |
CREATE TABLE `clubs` ( |
2145 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2145 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2146 |
`club_template_id` int(11) NOT NULL, |
2146 |
`club_template_id` int(11) NOT NULL, |
Lines 2165-2171
CREATE TABLE `clubs` (
Link Here
|
2165 |
|
2165 |
|
2166 |
DROP TABLE IF EXISTS `collections`; |
2166 |
DROP TABLE IF EXISTS `collections`; |
2167 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2167 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2168 |
/*!40101 SET character_set_client = utf8 */; |
2168 |
/*!40101 SET character_set_client = utf8mb4 */; |
2169 |
CREATE TABLE `collections` ( |
2169 |
CREATE TABLE `collections` ( |
2170 |
`colId` int(11) NOT NULL AUTO_INCREMENT, |
2170 |
`colId` int(11) NOT NULL AUTO_INCREMENT, |
2171 |
`colTitle` varchar(100) NOT NULL DEFAULT '', |
2171 |
`colTitle` varchar(100) NOT NULL DEFAULT '', |
Lines 2183-2189
CREATE TABLE `collections` (
Link Here
|
2183 |
|
2183 |
|
2184 |
DROP TABLE IF EXISTS `collections_tracking`; |
2184 |
DROP TABLE IF EXISTS `collections_tracking`; |
2185 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2185 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2186 |
/*!40101 SET character_set_client = utf8 */; |
2186 |
/*!40101 SET character_set_client = utf8mb4 */; |
2187 |
CREATE TABLE `collections_tracking` ( |
2187 |
CREATE TABLE `collections_tracking` ( |
2188 |
`collections_tracking_id` int(11) NOT NULL AUTO_INCREMENT, |
2188 |
`collections_tracking_id` int(11) NOT NULL AUTO_INCREMENT, |
2189 |
`colId` int(11) NOT NULL DEFAULT 0 COMMENT 'collections.colId', |
2189 |
`colId` int(11) NOT NULL DEFAULT 0 COMMENT 'collections.colId', |
Lines 2200-2206
CREATE TABLE `collections_tracking` (
Link Here
|
2200 |
|
2200 |
|
2201 |
DROP TABLE IF EXISTS `columns_settings`; |
2201 |
DROP TABLE IF EXISTS `columns_settings`; |
2202 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2202 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2203 |
/*!40101 SET character_set_client = utf8 */; |
2203 |
/*!40101 SET character_set_client = utf8mb4 */; |
2204 |
CREATE TABLE `columns_settings` ( |
2204 |
CREATE TABLE `columns_settings` ( |
2205 |
`module` varchar(255) NOT NULL, |
2205 |
`module` varchar(255) NOT NULL, |
2206 |
`page` varchar(255) NOT NULL, |
2206 |
`page` varchar(255) NOT NULL, |
Lines 2218-2224
CREATE TABLE `columns_settings` (
Link Here
|
2218 |
|
2218 |
|
2219 |
DROP TABLE IF EXISTS `course_instructors`; |
2219 |
DROP TABLE IF EXISTS `course_instructors`; |
2220 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2220 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2221 |
/*!40101 SET character_set_client = utf8 */; |
2221 |
/*!40101 SET character_set_client = utf8mb4 */; |
2222 |
CREATE TABLE `course_instructors` ( |
2222 |
CREATE TABLE `course_instructors` ( |
2223 |
`course_id` int(11) NOT NULL COMMENT 'foreign key to link to courses.course_id', |
2223 |
`course_id` int(11) NOT NULL COMMENT 'foreign key to link to courses.course_id', |
2224 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key to link to borrowers.borrowernumber for instructor information', |
2224 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key to link to borrowers.borrowernumber for instructor information', |
Lines 2235-2241
CREATE TABLE `course_instructors` (
Link Here
|
2235 |
|
2235 |
|
2236 |
DROP TABLE IF EXISTS `course_items`; |
2236 |
DROP TABLE IF EXISTS `course_items`; |
2237 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2237 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2238 |
/*!40101 SET character_set_client = utf8 */; |
2238 |
/*!40101 SET character_set_client = utf8mb4 */; |
2239 |
CREATE TABLE `course_items` ( |
2239 |
CREATE TABLE `course_items` ( |
2240 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id', |
2240 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id', |
2241 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on reserve', |
2241 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on reserve', |
Lines 2277-2283
CREATE TABLE `course_items` (
Link Here
|
2277 |
|
2277 |
|
2278 |
DROP TABLE IF EXISTS `course_reserves`; |
2278 |
DROP TABLE IF EXISTS `course_reserves`; |
2279 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2279 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2280 |
/*!40101 SET character_set_client = utf8 */; |
2280 |
/*!40101 SET character_set_client = utf8mb4 */; |
2281 |
CREATE TABLE `course_reserves` ( |
2281 |
CREATE TABLE `course_reserves` ( |
2282 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
2282 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
2283 |
`course_id` int(11) NOT NULL COMMENT 'foreign key to link to courses.course_id', |
2283 |
`course_id` int(11) NOT NULL COMMENT 'foreign key to link to courses.course_id', |
Lines 2300-2306
CREATE TABLE `course_reserves` (
Link Here
|
2300 |
|
2300 |
|
2301 |
DROP TABLE IF EXISTS `courses`; |
2301 |
DROP TABLE IF EXISTS `courses`; |
2302 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2302 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2303 |
/*!40101 SET character_set_client = utf8 */; |
2303 |
/*!40101 SET character_set_client = utf8mb4 */; |
2304 |
CREATE TABLE `courses` ( |
2304 |
CREATE TABLE `courses` ( |
2305 |
`course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the course', |
2305 |
`course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the course', |
2306 |
`department` varchar(80) DEFAULT NULL COMMENT 'the authorised value for the DEPARTMENT', |
2306 |
`department` varchar(80) DEFAULT NULL COMMENT 'the authorised value for the DEPARTMENT', |
Lines 2323-2329
CREATE TABLE `courses` (
Link Here
|
2323 |
|
2323 |
|
2324 |
DROP TABLE IF EXISTS `cover_images`; |
2324 |
DROP TABLE IF EXISTS `cover_images`; |
2325 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2325 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2326 |
/*!40101 SET character_set_client = utf8 */; |
2326 |
/*!40101 SET character_set_client = utf8mb4 */; |
2327 |
CREATE TABLE `cover_images` ( |
2327 |
CREATE TABLE `cover_images` ( |
2328 |
`imagenumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the image', |
2328 |
`imagenumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the image', |
2329 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'foreign key from biblio table to link to biblionumber', |
2329 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'foreign key from biblio table to link to biblionumber', |
Lines 2346-2352
CREATE TABLE `cover_images` (
Link Here
|
2346 |
|
2346 |
|
2347 |
DROP TABLE IF EXISTS `creator_batches`; |
2347 |
DROP TABLE IF EXISTS `creator_batches`; |
2348 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2348 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2349 |
/*!40101 SET character_set_client = utf8 */; |
2349 |
/*!40101 SET character_set_client = utf8mb4 */; |
2350 |
CREATE TABLE `creator_batches` ( |
2350 |
CREATE TABLE `creator_batches` ( |
2351 |
`label_id` int(11) NOT NULL AUTO_INCREMENT, |
2351 |
`label_id` int(11) NOT NULL AUTO_INCREMENT, |
2352 |
`batch_id` int(10) NOT NULL DEFAULT 1, |
2352 |
`batch_id` int(10) NOT NULL DEFAULT 1, |
Lines 2372-2378
CREATE TABLE `creator_batches` (
Link Here
|
2372 |
|
2372 |
|
2373 |
DROP TABLE IF EXISTS `creator_images`; |
2373 |
DROP TABLE IF EXISTS `creator_images`; |
2374 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2374 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2375 |
/*!40101 SET character_set_client = utf8 */; |
2375 |
/*!40101 SET character_set_client = utf8mb4 */; |
2376 |
CREATE TABLE `creator_images` ( |
2376 |
CREATE TABLE `creator_images` ( |
2377 |
`image_id` int(4) NOT NULL AUTO_INCREMENT, |
2377 |
`image_id` int(4) NOT NULL AUTO_INCREMENT, |
2378 |
`imagefile` mediumblob DEFAULT NULL, |
2378 |
`imagefile` mediumblob DEFAULT NULL, |
Lines 2388-2394
CREATE TABLE `creator_images` (
Link Here
|
2388 |
|
2388 |
|
2389 |
DROP TABLE IF EXISTS `creator_layouts`; |
2389 |
DROP TABLE IF EXISTS `creator_layouts`; |
2390 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2390 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2391 |
/*!40101 SET character_set_client = utf8 */; |
2391 |
/*!40101 SET character_set_client = utf8mb4 */; |
2392 |
CREATE TABLE `creator_layouts` ( |
2392 |
CREATE TABLE `creator_layouts` ( |
2393 |
`layout_id` int(4) NOT NULL AUTO_INCREMENT, |
2393 |
`layout_id` int(4) NOT NULL AUTO_INCREMENT, |
2394 |
`barcode_type` char(100) NOT NULL DEFAULT 'CODE39', |
2394 |
`barcode_type` char(100) NOT NULL DEFAULT 'CODE39', |
Lines 2417-2423
CREATE TABLE `creator_layouts` (
Link Here
|
2417 |
|
2417 |
|
2418 |
DROP TABLE IF EXISTS `creator_templates`; |
2418 |
DROP TABLE IF EXISTS `creator_templates`; |
2419 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2419 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2420 |
/*!40101 SET character_set_client = utf8 */; |
2420 |
/*!40101 SET character_set_client = utf8mb4 */; |
2421 |
CREATE TABLE `creator_templates` ( |
2421 |
CREATE TABLE `creator_templates` ( |
2422 |
`template_id` int(4) NOT NULL AUTO_INCREMENT, |
2422 |
`template_id` int(4) NOT NULL AUTO_INCREMENT, |
2423 |
`profile_id` int(4) DEFAULT NULL, |
2423 |
`profile_id` int(4) DEFAULT NULL, |
Lines 2448-2454
CREATE TABLE `creator_templates` (
Link Here
|
2448 |
|
2448 |
|
2449 |
DROP TABLE IF EXISTS `curbside_pickup_issues`; |
2449 |
DROP TABLE IF EXISTS `curbside_pickup_issues`; |
2450 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2450 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2451 |
/*!40101 SET character_set_client = utf8 */; |
2451 |
/*!40101 SET character_set_client = utf8mb4 */; |
2452 |
CREATE TABLE `curbside_pickup_issues` ( |
2452 |
CREATE TABLE `curbside_pickup_issues` ( |
2453 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2453 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2454 |
`curbside_pickup_id` int(11) NOT NULL, |
2454 |
`curbside_pickup_id` int(11) NOT NULL, |
Lines 2466-2472
CREATE TABLE `curbside_pickup_issues` (
Link Here
|
2466 |
|
2466 |
|
2467 |
DROP TABLE IF EXISTS `curbside_pickup_opening_slots`; |
2467 |
DROP TABLE IF EXISTS `curbside_pickup_opening_slots`; |
2468 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2468 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2469 |
/*!40101 SET character_set_client = utf8 */; |
2469 |
/*!40101 SET character_set_client = utf8mb4 */; |
2470 |
CREATE TABLE `curbside_pickup_opening_slots` ( |
2470 |
CREATE TABLE `curbside_pickup_opening_slots` ( |
2471 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2471 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2472 |
`curbside_pickup_policy_id` int(11) NOT NULL, |
2472 |
`curbside_pickup_policy_id` int(11) NOT NULL, |
Lines 2487-2493
CREATE TABLE `curbside_pickup_opening_slots` (
Link Here
|
2487 |
|
2487 |
|
2488 |
DROP TABLE IF EXISTS `curbside_pickup_policy`; |
2488 |
DROP TABLE IF EXISTS `curbside_pickup_policy`; |
2489 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2489 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2490 |
/*!40101 SET character_set_client = utf8 */; |
2490 |
/*!40101 SET character_set_client = utf8mb4 */; |
2491 |
CREATE TABLE `curbside_pickup_policy` ( |
2491 |
CREATE TABLE `curbside_pickup_policy` ( |
2492 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2492 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2493 |
`branchcode` varchar(10) NOT NULL, |
2493 |
`branchcode` varchar(10) NOT NULL, |
Lines 2508-2514
CREATE TABLE `curbside_pickup_policy` (
Link Here
|
2508 |
|
2508 |
|
2509 |
DROP TABLE IF EXISTS `curbside_pickups`; |
2509 |
DROP TABLE IF EXISTS `curbside_pickups`; |
2510 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2510 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2511 |
/*!40101 SET character_set_client = utf8 */; |
2511 |
/*!40101 SET character_set_client = utf8mb4 */; |
2512 |
CREATE TABLE `curbside_pickups` ( |
2512 |
CREATE TABLE `curbside_pickups` ( |
2513 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2513 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2514 |
`borrowernumber` int(11) NOT NULL, |
2514 |
`borrowernumber` int(11) NOT NULL, |
Lines 2536-2542
CREATE TABLE `curbside_pickups` (
Link Here
|
2536 |
|
2536 |
|
2537 |
DROP TABLE IF EXISTS `currency`; |
2537 |
DROP TABLE IF EXISTS `currency`; |
2538 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2538 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2539 |
/*!40101 SET character_set_client = utf8 */; |
2539 |
/*!40101 SET character_set_client = utf8mb4 */; |
2540 |
CREATE TABLE `currency` ( |
2540 |
CREATE TABLE `currency` ( |
2541 |
`currency` varchar(10) NOT NULL DEFAULT '', |
2541 |
`currency` varchar(10) NOT NULL DEFAULT '', |
2542 |
`symbol` varchar(5) DEFAULT NULL, |
2542 |
`symbol` varchar(5) DEFAULT NULL, |
Lines 2557-2563
CREATE TABLE `currency` (
Link Here
|
2557 |
|
2557 |
|
2558 |
DROP TABLE IF EXISTS `deletedauth_header`; |
2558 |
DROP TABLE IF EXISTS `deletedauth_header`; |
2559 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2559 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2560 |
/*!40101 SET character_set_client = utf8 */; |
2560 |
/*!40101 SET character_set_client = utf8mb4 */; |
2561 |
CREATE TABLE `deletedauth_header` ( |
2561 |
CREATE TABLE `deletedauth_header` ( |
2562 |
`authid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
2562 |
`authid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
2563 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
2563 |
`authtypecode` varchar(10) NOT NULL DEFAULT '', |
Lines 2578-2584
CREATE TABLE `deletedauth_header` (
Link Here
|
2578 |
|
2578 |
|
2579 |
DROP TABLE IF EXISTS `deletedbiblio`; |
2579 |
DROP TABLE IF EXISTS `deletedbiblio`; |
2580 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2580 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2581 |
/*!40101 SET character_set_client = utf8 */; |
2581 |
/*!40101 SET character_set_client = utf8mb4 */; |
2582 |
CREATE TABLE `deletedbiblio` ( |
2582 |
CREATE TABLE `deletedbiblio` ( |
2583 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
2583 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
2584 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record', |
2584 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record', |
Lines 2607-2613
CREATE TABLE `deletedbiblio` (
Link Here
|
2607 |
|
2607 |
|
2608 |
DROP TABLE IF EXISTS `deletedbiblio_metadata`; |
2608 |
DROP TABLE IF EXISTS `deletedbiblio_metadata`; |
2609 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2609 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2610 |
/*!40101 SET character_set_client = utf8 */; |
2610 |
/*!40101 SET character_set_client = utf8mb4 */; |
2611 |
CREATE TABLE `deletedbiblio_metadata` ( |
2611 |
CREATE TABLE `deletedbiblio_metadata` ( |
2612 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2612 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2613 |
`biblionumber` int(11) NOT NULL, |
2613 |
`biblionumber` int(11) NOT NULL, |
Lines 2631-2637
CREATE TABLE `deletedbiblio_metadata` (
Link Here
|
2631 |
|
2631 |
|
2632 |
DROP TABLE IF EXISTS `deletedbiblioitems`; |
2632 |
DROP TABLE IF EXISTS `deletedbiblioitems`; |
2633 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2633 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2634 |
/*!40101 SET character_set_client = utf8 */; |
2634 |
/*!40101 SET character_set_client = utf8mb4 */; |
2635 |
CREATE TABLE `deletedbiblioitems` ( |
2635 |
CREATE TABLE `deletedbiblioitems` ( |
2636 |
`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key, unique identifier assigned by Koha', |
2636 |
`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key, unique identifier assigned by Koha', |
2637 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking this table to the biblio table', |
2637 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking this table to the biblio table', |
Lines 2682-2688
CREATE TABLE `deletedbiblioitems` (
Link Here
|
2682 |
|
2682 |
|
2683 |
DROP TABLE IF EXISTS `deletedborrowers`; |
2683 |
DROP TABLE IF EXISTS `deletedborrowers`; |
2684 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2684 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2685 |
/*!40101 SET character_set_client = utf8 */; |
2685 |
/*!40101 SET character_set_client = utf8mb4 */; |
2686 |
CREATE TABLE `deletedborrowers` ( |
2686 |
CREATE TABLE `deletedborrowers` ( |
2687 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key, Koha assigned ID number for patrons/borrowers', |
2687 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key, Koha assigned ID number for patrons/borrowers', |
2688 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2688 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
Lines 2780-2786
CREATE TABLE `deletedborrowers` (
Link Here
|
2780 |
|
2780 |
|
2781 |
DROP TABLE IF EXISTS `deleteditems`; |
2781 |
DROP TABLE IF EXISTS `deleteditems`; |
2782 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2782 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2783 |
/*!40101 SET character_set_client = utf8 */; |
2783 |
/*!40101 SET character_set_client = utf8mb4 */; |
2784 |
CREATE TABLE `deleteditems` ( |
2784 |
CREATE TABLE `deleteditems` ( |
2785 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key and unique identifier added by Koha', |
2785 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'primary key and unique identifier added by Koha', |
2786 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record', |
2786 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record', |
Lines 2848-2854
CREATE TABLE `deleteditems` (
Link Here
|
2848 |
|
2848 |
|
2849 |
DROP TABLE IF EXISTS `desks`; |
2849 |
DROP TABLE IF EXISTS `desks`; |
2850 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2850 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2851 |
/*!40101 SET character_set_client = utf8 */; |
2851 |
/*!40101 SET character_set_client = utf8mb4 */; |
2852 |
CREATE TABLE `desks` ( |
2852 |
CREATE TABLE `desks` ( |
2853 |
`desk_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
2853 |
`desk_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
2854 |
`desk_name` varchar(100) NOT NULL DEFAULT '' COMMENT 'name of the desk', |
2854 |
`desk_name` varchar(100) NOT NULL DEFAULT '' COMMENT 'name of the desk', |
Lines 2865-2871
CREATE TABLE `desks` (
Link Here
|
2865 |
|
2865 |
|
2866 |
DROP TABLE IF EXISTS `discharges`; |
2866 |
DROP TABLE IF EXISTS `discharges`; |
2867 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2867 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2868 |
/*!40101 SET character_set_client = utf8 */; |
2868 |
/*!40101 SET character_set_client = utf8mb4 */; |
2869 |
CREATE TABLE `discharges` ( |
2869 |
CREATE TABLE `discharges` ( |
2870 |
`discharge_id` int(11) NOT NULL AUTO_INCREMENT, |
2870 |
`discharge_id` int(11) NOT NULL AUTO_INCREMENT, |
2871 |
`borrower` int(11) DEFAULT NULL, |
2871 |
`borrower` int(11) DEFAULT NULL, |
Lines 2883-2889
CREATE TABLE `discharges` (
Link Here
|
2883 |
|
2883 |
|
2884 |
DROP TABLE IF EXISTS `edifact_ean`; |
2884 |
DROP TABLE IF EXISTS `edifact_ean`; |
2885 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2885 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2886 |
/*!40101 SET character_set_client = utf8 */; |
2886 |
/*!40101 SET character_set_client = utf8mb4 */; |
2887 |
CREATE TABLE `edifact_ean` ( |
2887 |
CREATE TABLE `edifact_ean` ( |
2888 |
`ee_id` int(11) NOT NULL AUTO_INCREMENT, |
2888 |
`ee_id` int(11) NOT NULL AUTO_INCREMENT, |
2889 |
`description` varchar(128) DEFAULT NULL, |
2889 |
`description` varchar(128) DEFAULT NULL, |
Lines 2902-2908
CREATE TABLE `edifact_ean` (
Link Here
|
2902 |
|
2902 |
|
2903 |
DROP TABLE IF EXISTS `edifact_errors`; |
2903 |
DROP TABLE IF EXISTS `edifact_errors`; |
2904 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2904 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2905 |
/*!40101 SET character_set_client = utf8 */; |
2905 |
/*!40101 SET character_set_client = utf8mb4 */; |
2906 |
CREATE TABLE `edifact_errors` ( |
2906 |
CREATE TABLE `edifact_errors` ( |
2907 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2907 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2908 |
`message_id` int(11) NOT NULL, |
2908 |
`message_id` int(11) NOT NULL, |
Lines 2921-2927
CREATE TABLE `edifact_errors` (
Link Here
|
2921 |
|
2921 |
|
2922 |
DROP TABLE IF EXISTS `edifact_messages`; |
2922 |
DROP TABLE IF EXISTS `edifact_messages`; |
2923 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2923 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2924 |
/*!40101 SET character_set_client = utf8 */; |
2924 |
/*!40101 SET character_set_client = utf8mb4 */; |
2925 |
CREATE TABLE `edifact_messages` ( |
2925 |
CREATE TABLE `edifact_messages` ( |
2926 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2926 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2927 |
`message_type` varchar(10) NOT NULL, |
2927 |
`message_type` varchar(10) NOT NULL, |
Lines 2949-2955
CREATE TABLE `edifact_messages` (
Link Here
|
2949 |
|
2949 |
|
2950 |
DROP TABLE IF EXISTS `erm_agreement_licenses`; |
2950 |
DROP TABLE IF EXISTS `erm_agreement_licenses`; |
2951 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2951 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2952 |
/*!40101 SET character_set_client = utf8 */; |
2952 |
/*!40101 SET character_set_client = utf8mb4 */; |
2953 |
CREATE TABLE `erm_agreement_licenses` ( |
2953 |
CREATE TABLE `erm_agreement_licenses` ( |
2954 |
`agreement_license_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
2954 |
`agreement_license_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
2955 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
2955 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
Lines 2972-2978
CREATE TABLE `erm_agreement_licenses` (
Link Here
|
2972 |
|
2972 |
|
2973 |
DROP TABLE IF EXISTS `erm_agreement_periods`; |
2973 |
DROP TABLE IF EXISTS `erm_agreement_periods`; |
2974 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2974 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2975 |
/*!40101 SET character_set_client = utf8 */; |
2975 |
/*!40101 SET character_set_client = utf8mb4 */; |
2976 |
CREATE TABLE `erm_agreement_periods` ( |
2976 |
CREATE TABLE `erm_agreement_periods` ( |
2977 |
`agreement_period_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
2977 |
`agreement_period_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
2978 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
2978 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
Lines 2992-2998
CREATE TABLE `erm_agreement_periods` (
Link Here
|
2992 |
|
2992 |
|
2993 |
DROP TABLE IF EXISTS `erm_agreement_relationships`; |
2993 |
DROP TABLE IF EXISTS `erm_agreement_relationships`; |
2994 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2994 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
2995 |
/*!40101 SET character_set_client = utf8 */; |
2995 |
/*!40101 SET character_set_client = utf8mb4 */; |
2996 |
CREATE TABLE `erm_agreement_relationships` ( |
2996 |
CREATE TABLE `erm_agreement_relationships` ( |
2997 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
2997 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
2998 |
`related_agreement_id` int(11) NOT NULL COMMENT 'link to the related agreement', |
2998 |
`related_agreement_id` int(11) NOT NULL COMMENT 'link to the related agreement', |
Lines 3011-3017
CREATE TABLE `erm_agreement_relationships` (
Link Here
|
3011 |
|
3011 |
|
3012 |
DROP TABLE IF EXISTS `erm_agreements`; |
3012 |
DROP TABLE IF EXISTS `erm_agreements`; |
3013 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3013 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3014 |
/*!40101 SET character_set_client = utf8 */; |
3014 |
/*!40101 SET character_set_client = utf8mb4 */; |
3015 |
CREATE TABLE `erm_agreements` ( |
3015 |
CREATE TABLE `erm_agreements` ( |
3016 |
`agreement_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3016 |
`agreement_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3017 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
3017 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
Lines 3034-3040
CREATE TABLE `erm_agreements` (
Link Here
|
3034 |
|
3034 |
|
3035 |
DROP TABLE IF EXISTS `erm_counter_files`; |
3035 |
DROP TABLE IF EXISTS `erm_counter_files`; |
3036 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3036 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3037 |
/*!40101 SET character_set_client = utf8 */; |
3037 |
/*!40101 SET character_set_client = utf8mb4 */; |
3038 |
CREATE TABLE `erm_counter_files` ( |
3038 |
CREATE TABLE `erm_counter_files` ( |
3039 |
`erm_counter_files_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3039 |
`erm_counter_files_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3040 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
3040 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
Lines 3054-3060
CREATE TABLE `erm_counter_files` (
Link Here
|
3054 |
|
3054 |
|
3055 |
DROP TABLE IF EXISTS `erm_counter_logs`; |
3055 |
DROP TABLE IF EXISTS `erm_counter_logs`; |
3056 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3056 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3057 |
/*!40101 SET character_set_client = utf8 */; |
3057 |
/*!40101 SET character_set_client = utf8mb4 */; |
3058 |
CREATE TABLE `erm_counter_logs` ( |
3058 |
CREATE TABLE `erm_counter_logs` ( |
3059 |
`erm_counter_log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3059 |
`erm_counter_log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3060 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
3060 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
Lines 3079-3085
CREATE TABLE `erm_counter_logs` (
Link Here
|
3079 |
|
3079 |
|
3080 |
DROP TABLE IF EXISTS `erm_default_usage_reports`; |
3080 |
DROP TABLE IF EXISTS `erm_default_usage_reports`; |
3081 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3081 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3082 |
/*!40101 SET character_set_client = utf8 */; |
3082 |
/*!40101 SET character_set_client = utf8mb4 */; |
3083 |
CREATE TABLE `erm_default_usage_reports` ( |
3083 |
CREATE TABLE `erm_default_usage_reports` ( |
3084 |
`erm_default_usage_report_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3084 |
`erm_default_usage_report_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3085 |
`report_name` varchar(50) DEFAULT NULL COMMENT 'name of the default report', |
3085 |
`report_name` varchar(50) DEFAULT NULL COMMENT 'name of the default report', |
Lines 3094-3100
CREATE TABLE `erm_default_usage_reports` (
Link Here
|
3094 |
|
3094 |
|
3095 |
DROP TABLE IF EXISTS `erm_documents`; |
3095 |
DROP TABLE IF EXISTS `erm_documents`; |
3096 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3096 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3097 |
/*!40101 SET character_set_client = utf8 */; |
3097 |
/*!40101 SET character_set_client = utf8mb4 */; |
3098 |
CREATE TABLE `erm_documents` ( |
3098 |
CREATE TABLE `erm_documents` ( |
3099 |
`document_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3099 |
`document_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3100 |
`agreement_id` int(11) DEFAULT NULL COMMENT 'link to the agreement', |
3100 |
`agreement_id` int(11) DEFAULT NULL COMMENT 'link to the agreement', |
Lines 3121-3127
CREATE TABLE `erm_documents` (
Link Here
|
3121 |
|
3121 |
|
3122 |
DROP TABLE IF EXISTS `erm_eholdings_packages`; |
3122 |
DROP TABLE IF EXISTS `erm_eholdings_packages`; |
3123 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3123 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3124 |
/*!40101 SET character_set_client = utf8 */; |
3124 |
/*!40101 SET character_set_client = utf8mb4 */; |
3125 |
CREATE TABLE `erm_eholdings_packages` ( |
3125 |
CREATE TABLE `erm_eholdings_packages` ( |
3126 |
`package_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3126 |
`package_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3127 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
3127 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
Lines 3144-3150
CREATE TABLE `erm_eholdings_packages` (
Link Here
|
3144 |
|
3144 |
|
3145 |
DROP TABLE IF EXISTS `erm_eholdings_packages_agreements`; |
3145 |
DROP TABLE IF EXISTS `erm_eholdings_packages_agreements`; |
3146 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3146 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3147 |
/*!40101 SET character_set_client = utf8 */; |
3147 |
/*!40101 SET character_set_client = utf8mb4 */; |
3148 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
3148 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
3149 |
`package_id` int(11) NOT NULL COMMENT 'link to the package', |
3149 |
`package_id` int(11) NOT NULL COMMENT 'link to the package', |
3150 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
3150 |
`agreement_id` int(11) NOT NULL COMMENT 'link to the agreement', |
Lines 3161-3167
CREATE TABLE `erm_eholdings_packages_agreements` (
Link Here
|
3161 |
|
3161 |
|
3162 |
DROP TABLE IF EXISTS `erm_eholdings_resources`; |
3162 |
DROP TABLE IF EXISTS `erm_eholdings_resources`; |
3163 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3163 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3164 |
/*!40101 SET character_set_client = utf8 */; |
3164 |
/*!40101 SET character_set_client = utf8mb4 */; |
3165 |
CREATE TABLE `erm_eholdings_resources` ( |
3165 |
CREATE TABLE `erm_eholdings_resources` ( |
3166 |
`resource_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3166 |
`resource_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3167 |
`title_id` int(11) NOT NULL, |
3167 |
`title_id` int(11) NOT NULL, |
Lines 3186-3192
CREATE TABLE `erm_eholdings_resources` (
Link Here
|
3186 |
|
3186 |
|
3187 |
DROP TABLE IF EXISTS `erm_eholdings_titles`; |
3187 |
DROP TABLE IF EXISTS `erm_eholdings_titles`; |
3188 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3188 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3189 |
/*!40101 SET character_set_client = utf8 */; |
3189 |
/*!40101 SET character_set_client = utf8mb4 */; |
3190 |
CREATE TABLE `erm_eholdings_titles` ( |
3190 |
CREATE TABLE `erm_eholdings_titles` ( |
3191 |
`title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3191 |
`title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3192 |
`biblio_id` int(11) DEFAULT NULL, |
3192 |
`biblio_id` int(11) DEFAULT NULL, |
Lines 3227-3233
CREATE TABLE `erm_eholdings_titles` (
Link Here
|
3227 |
|
3227 |
|
3228 |
DROP TABLE IF EXISTS `erm_licenses`; |
3228 |
DROP TABLE IF EXISTS `erm_licenses`; |
3229 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3229 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3230 |
/*!40101 SET character_set_client = utf8 */; |
3230 |
/*!40101 SET character_set_client = utf8mb4 */; |
3231 |
CREATE TABLE `erm_licenses` ( |
3231 |
CREATE TABLE `erm_licenses` ( |
3232 |
`license_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3232 |
`license_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3233 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
3233 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
Lines 3249-3255
CREATE TABLE `erm_licenses` (
Link Here
|
3249 |
|
3249 |
|
3250 |
DROP TABLE IF EXISTS `erm_usage_data_providers`; |
3250 |
DROP TABLE IF EXISTS `erm_usage_data_providers`; |
3251 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3251 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3252 |
/*!40101 SET character_set_client = utf8 */; |
3252 |
/*!40101 SET character_set_client = utf8mb4 */; |
3253 |
CREATE TABLE `erm_usage_data_providers` ( |
3253 |
CREATE TABLE `erm_usage_data_providers` ( |
3254 |
`erm_usage_data_provider_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3254 |
`erm_usage_data_provider_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3255 |
`name` varchar(80) NOT NULL COMMENT 'name of the data provider', |
3255 |
`name` varchar(80) NOT NULL COMMENT 'name of the data provider', |
Lines 3277-3283
CREATE TABLE `erm_usage_data_providers` (
Link Here
|
3277 |
|
3277 |
|
3278 |
DROP TABLE IF EXISTS `erm_usage_databases`; |
3278 |
DROP TABLE IF EXISTS `erm_usage_databases`; |
3279 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3279 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3280 |
/*!40101 SET character_set_client = utf8 */; |
3280 |
/*!40101 SET character_set_client = utf8mb4 */; |
3281 |
CREATE TABLE `erm_usage_databases` ( |
3281 |
CREATE TABLE `erm_usage_databases` ( |
3282 |
`database_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3282 |
`database_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3283 |
`database` varchar(255) DEFAULT NULL COMMENT 'item title', |
3283 |
`database` varchar(255) DEFAULT NULL COMMENT 'item title', |
Lines 3297-3303
CREATE TABLE `erm_usage_databases` (
Link Here
|
3297 |
|
3297 |
|
3298 |
DROP TABLE IF EXISTS `erm_usage_items`; |
3298 |
DROP TABLE IF EXISTS `erm_usage_items`; |
3299 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3299 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3300 |
/*!40101 SET character_set_client = utf8 */; |
3300 |
/*!40101 SET character_set_client = utf8mb4 */; |
3301 |
CREATE TABLE `erm_usage_items` ( |
3301 |
CREATE TABLE `erm_usage_items` ( |
3302 |
`item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3302 |
`item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3303 |
`item` varchar(500) DEFAULT NULL COMMENT 'item title', |
3303 |
`item` varchar(500) DEFAULT NULL COMMENT 'item title', |
Lines 3316-3322
CREATE TABLE `erm_usage_items` (
Link Here
|
3316 |
|
3316 |
|
3317 |
DROP TABLE IF EXISTS `erm_usage_mus`; |
3317 |
DROP TABLE IF EXISTS `erm_usage_mus`; |
3318 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3318 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3319 |
/*!40101 SET character_set_client = utf8 */; |
3319 |
/*!40101 SET character_set_client = utf8mb4 */; |
3320 |
CREATE TABLE `erm_usage_mus` ( |
3320 |
CREATE TABLE `erm_usage_mus` ( |
3321 |
`monthly_usage_summary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3321 |
`monthly_usage_summary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3322 |
`title_id` int(11) DEFAULT NULL COMMENT 'item title id number', |
3322 |
`title_id` int(11) DEFAULT NULL COMMENT 'item title id number', |
Lines 3351-3357
CREATE TABLE `erm_usage_mus` (
Link Here
|
3351 |
|
3351 |
|
3352 |
DROP TABLE IF EXISTS `erm_usage_platforms`; |
3352 |
DROP TABLE IF EXISTS `erm_usage_platforms`; |
3353 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3353 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3354 |
/*!40101 SET character_set_client = utf8 */; |
3354 |
/*!40101 SET character_set_client = utf8mb4 */; |
3355 |
CREATE TABLE `erm_usage_platforms` ( |
3355 |
CREATE TABLE `erm_usage_platforms` ( |
3356 |
`platform_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3356 |
`platform_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3357 |
`platform` varchar(255) DEFAULT NULL COMMENT 'item title', |
3357 |
`platform` varchar(255) DEFAULT NULL COMMENT 'item title', |
Lines 3368-3374
CREATE TABLE `erm_usage_platforms` (
Link Here
|
3368 |
|
3368 |
|
3369 |
DROP TABLE IF EXISTS `erm_usage_titles`; |
3369 |
DROP TABLE IF EXISTS `erm_usage_titles`; |
3370 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3370 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3371 |
/*!40101 SET character_set_client = utf8 */; |
3371 |
/*!40101 SET character_set_client = utf8mb4 */; |
3372 |
CREATE TABLE `erm_usage_titles` ( |
3372 |
CREATE TABLE `erm_usage_titles` ( |
3373 |
`title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3373 |
`title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3374 |
`title` mediumtext DEFAULT NULL COMMENT 'item title', |
3374 |
`title` mediumtext DEFAULT NULL COMMENT 'item title', |
Lines 3394-3400
CREATE TABLE `erm_usage_titles` (
Link Here
|
3394 |
|
3394 |
|
3395 |
DROP TABLE IF EXISTS `erm_usage_yus`; |
3395 |
DROP TABLE IF EXISTS `erm_usage_yus`; |
3396 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3396 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3397 |
/*!40101 SET character_set_client = utf8 */; |
3397 |
/*!40101 SET character_set_client = utf8mb4 */; |
3398 |
CREATE TABLE `erm_usage_yus` ( |
3398 |
CREATE TABLE `erm_usage_yus` ( |
3399 |
`yearly_usage_summary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3399 |
`yearly_usage_summary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3400 |
`title_id` int(11) DEFAULT NULL COMMENT 'item title id number', |
3400 |
`title_id` int(11) DEFAULT NULL COMMENT 'item title id number', |
Lines 3428-3434
CREATE TABLE `erm_usage_yus` (
Link Here
|
3428 |
|
3428 |
|
3429 |
DROP TABLE IF EXISTS `erm_user_roles`; |
3429 |
DROP TABLE IF EXISTS `erm_user_roles`; |
3430 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3430 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3431 |
/*!40101 SET character_set_client = utf8 */; |
3431 |
/*!40101 SET character_set_client = utf8mb4 */; |
3432 |
CREATE TABLE `erm_user_roles` ( |
3432 |
CREATE TABLE `erm_user_roles` ( |
3433 |
`user_role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3433 |
`user_role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
3434 |
`agreement_id` int(11) DEFAULT NULL COMMENT 'link to the agreement', |
3434 |
`agreement_id` int(11) DEFAULT NULL COMMENT 'link to the agreement', |
Lines 3451-3457
CREATE TABLE `erm_user_roles` (
Link Here
|
3451 |
|
3451 |
|
3452 |
DROP TABLE IF EXISTS `export_format`; |
3452 |
DROP TABLE IF EXISTS `export_format`; |
3453 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3453 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3454 |
/*!40101 SET character_set_client = utf8 */; |
3454 |
/*!40101 SET character_set_client = utf8mb4 */; |
3455 |
CREATE TABLE `export_format` ( |
3455 |
CREATE TABLE `export_format` ( |
3456 |
`export_format_id` int(11) NOT NULL AUTO_INCREMENT, |
3456 |
`export_format_id` int(11) NOT NULL AUTO_INCREMENT, |
3457 |
`profile` varchar(255) NOT NULL, |
3457 |
`profile` varchar(255) NOT NULL, |
Lines 3476-3482
CREATE TABLE `export_format` (
Link Here
|
3476 |
|
3476 |
|
3477 |
DROP TABLE IF EXISTS `hold_cancellation_requests`; |
3477 |
DROP TABLE IF EXISTS `hold_cancellation_requests`; |
3478 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3478 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3479 |
/*!40101 SET character_set_client = utf8 */; |
3479 |
/*!40101 SET character_set_client = utf8mb4 */; |
3480 |
CREATE TABLE `hold_cancellation_requests` ( |
3480 |
CREATE TABLE `hold_cancellation_requests` ( |
3481 |
`hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request', |
3481 |
`hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request', |
3482 |
`hold_id` int(11) NOT NULL COMMENT 'ID of the hold', |
3482 |
`hold_id` int(11) NOT NULL COMMENT 'ID of the hold', |
Lines 3491-3497
CREATE TABLE `hold_cancellation_requests` (
Link Here
|
3491 |
|
3491 |
|
3492 |
DROP TABLE IF EXISTS `hold_fill_targets`; |
3492 |
DROP TABLE IF EXISTS `hold_fill_targets`; |
3493 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3493 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3494 |
/*!40101 SET character_set_client = utf8 */; |
3494 |
/*!40101 SET character_set_client = utf8mb4 */; |
3495 |
CREATE TABLE `hold_fill_targets` ( |
3495 |
CREATE TABLE `hold_fill_targets` ( |
3496 |
`borrowernumber` int(11) NOT NULL, |
3496 |
`borrowernumber` int(11) NOT NULL, |
3497 |
`biblionumber` int(11) NOT NULL, |
3497 |
`biblionumber` int(11) NOT NULL, |
Lines 3516-3522
CREATE TABLE `hold_fill_targets` (
Link Here
|
3516 |
|
3516 |
|
3517 |
DROP TABLE IF EXISTS `housebound_profile`; |
3517 |
DROP TABLE IF EXISTS `housebound_profile`; |
3518 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3518 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3519 |
/*!40101 SET character_set_client = utf8 */; |
3519 |
/*!40101 SET character_set_client = utf8mb4 */; |
3520 |
CREATE TABLE `housebound_profile` ( |
3520 |
CREATE TABLE `housebound_profile` ( |
3521 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.', |
3521 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.', |
3522 |
`day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.', |
3522 |
`day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.', |
Lines 3537-3543
CREATE TABLE `housebound_profile` (
Link Here
|
3537 |
|
3537 |
|
3538 |
DROP TABLE IF EXISTS `housebound_role`; |
3538 |
DROP TABLE IF EXISTS `housebound_role`; |
3539 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3539 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3540 |
/*!40101 SET character_set_client = utf8 */; |
3540 |
/*!40101 SET character_set_client = utf8mb4 */; |
3541 |
CREATE TABLE `housebound_role` ( |
3541 |
CREATE TABLE `housebound_role` ( |
3542 |
`borrowernumber_id` int(11) NOT NULL COMMENT 'borrowernumber link', |
3542 |
`borrowernumber_id` int(11) NOT NULL COMMENT 'borrowernumber link', |
3543 |
`housebound_chooser` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'set to 1 to indicate this patron is a housebound chooser volunteer', |
3543 |
`housebound_chooser` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'set to 1 to indicate this patron is a housebound chooser volunteer', |
Lines 3553-3559
CREATE TABLE `housebound_role` (
Link Here
|
3553 |
|
3553 |
|
3554 |
DROP TABLE IF EXISTS `housebound_visit`; |
3554 |
DROP TABLE IF EXISTS `housebound_visit`; |
3555 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3555 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3556 |
/*!40101 SET character_set_client = utf8 */; |
3556 |
/*!40101 SET character_set_client = utf8mb4 */; |
3557 |
CREATE TABLE `housebound_visit` ( |
3557 |
CREATE TABLE `housebound_visit` ( |
3558 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the visit.', |
3558 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of the visit.', |
3559 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower, & the profile, linked to this visit.', |
3559 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower, & the profile, linked to this visit.', |
Lines 3577-3583
CREATE TABLE `housebound_visit` (
Link Here
|
3577 |
|
3577 |
|
3578 |
DROP TABLE IF EXISTS `identity_provider_domains`; |
3578 |
DROP TABLE IF EXISTS `identity_provider_domains`; |
3579 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3579 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3580 |
/*!40101 SET character_set_client = utf8 */; |
3580 |
/*!40101 SET character_set_client = utf8mb4 */; |
3581 |
CREATE TABLE `identity_provider_domains` ( |
3581 |
CREATE TABLE `identity_provider_domains` ( |
3582 |
`identity_provider_domain_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify providers domain', |
3582 |
`identity_provider_domain_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify providers domain', |
3583 |
`identity_provider_id` int(11) NOT NULL COMMENT 'Reference to provider', |
3583 |
`identity_provider_id` int(11) NOT NULL COMMENT 'Reference to provider', |
Lines 3607-3613
CREATE TABLE `identity_provider_domains` (
Link Here
|
3607 |
|
3607 |
|
3608 |
DROP TABLE IF EXISTS `identity_providers`; |
3608 |
DROP TABLE IF EXISTS `identity_providers`; |
3609 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3609 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3610 |
/*!40101 SET character_set_client = utf8 */; |
3610 |
/*!40101 SET character_set_client = utf8mb4 */; |
3611 |
CREATE TABLE `identity_providers` ( |
3611 |
CREATE TABLE `identity_providers` ( |
3612 |
`identity_provider_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the provider', |
3612 |
`identity_provider_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the provider', |
3613 |
`code` varchar(20) NOT NULL COMMENT 'Provider code', |
3613 |
`code` varchar(20) NOT NULL COMMENT 'Provider code', |
Lines 3629-3635
CREATE TABLE `identity_providers` (
Link Here
|
3629 |
|
3629 |
|
3630 |
DROP TABLE IF EXISTS `illbatch_statuses`; |
3630 |
DROP TABLE IF EXISTS `illbatch_statuses`; |
3631 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3631 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3632 |
/*!40101 SET character_set_client = utf8 */; |
3632 |
/*!40101 SET character_set_client = utf8mb4 */; |
3633 |
CREATE TABLE `illbatch_statuses` ( |
3633 |
CREATE TABLE `illbatch_statuses` ( |
3634 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Status ID', |
3634 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Status ID', |
3635 |
`name` varchar(100) NOT NULL COMMENT 'Name of status', |
3635 |
`name` varchar(100) NOT NULL COMMENT 'Name of status', |
Lines 3646-3652
CREATE TABLE `illbatch_statuses` (
Link Here
|
3646 |
|
3646 |
|
3647 |
DROP TABLE IF EXISTS `illbatches`; |
3647 |
DROP TABLE IF EXISTS `illbatches`; |
3648 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3648 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3649 |
/*!40101 SET character_set_client = utf8 */; |
3649 |
/*!40101 SET character_set_client = utf8mb4 */; |
3650 |
CREATE TABLE `illbatches` ( |
3650 |
CREATE TABLE `illbatches` ( |
3651 |
`ill_batch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Batch ID', |
3651 |
`ill_batch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Batch ID', |
3652 |
`name` varchar(100) NOT NULL COMMENT 'Unique name of batch', |
3652 |
`name` varchar(100) NOT NULL COMMENT 'Unique name of batch', |
Lines 3671-3677
CREATE TABLE `illbatches` (
Link Here
|
3671 |
|
3671 |
|
3672 |
DROP TABLE IF EXISTS `illcomments`; |
3672 |
DROP TABLE IF EXISTS `illcomments`; |
3673 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3673 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3674 |
/*!40101 SET character_set_client = utf8 */; |
3674 |
/*!40101 SET character_set_client = utf8mb4 */; |
3675 |
CREATE TABLE `illcomments` ( |
3675 |
CREATE TABLE `illcomments` ( |
3676 |
`illcomment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the comment', |
3676 |
`illcomment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the comment', |
3677 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
3677 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
Lines 3692-3698
CREATE TABLE `illcomments` (
Link Here
|
3692 |
|
3692 |
|
3693 |
DROP TABLE IF EXISTS `illrequestattributes`; |
3693 |
DROP TABLE IF EXISTS `illrequestattributes`; |
3694 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3694 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3695 |
/*!40101 SET character_set_client = utf8 */; |
3695 |
/*!40101 SET character_set_client = utf8mb4 */; |
3696 |
CREATE TABLE `illrequestattributes` ( |
3696 |
CREATE TABLE `illrequestattributes` ( |
3697 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
3697 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
3698 |
`backend` varchar(80) NOT NULL COMMENT 'API ILL backend name', |
3698 |
`backend` varchar(80) NOT NULL COMMENT 'API ILL backend name', |
Lines 3710-3716
CREATE TABLE `illrequestattributes` (
Link Here
|
3710 |
|
3710 |
|
3711 |
DROP TABLE IF EXISTS `illrequests`; |
3711 |
DROP TABLE IF EXISTS `illrequests`; |
3712 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3712 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3713 |
/*!40101 SET character_set_client = utf8 */; |
3713 |
/*!40101 SET character_set_client = utf8mb4 */; |
3714 |
CREATE TABLE `illrequests` ( |
3714 |
CREATE TABLE `illrequests` ( |
3715 |
`illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number', |
3715 |
`illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number', |
3716 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request', |
3716 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request', |
Lines 3753-3759
CREATE TABLE `illrequests` (
Link Here
|
3753 |
|
3753 |
|
3754 |
DROP TABLE IF EXISTS `import_auths`; |
3754 |
DROP TABLE IF EXISTS `import_auths`; |
3755 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3755 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3756 |
/*!40101 SET character_set_client = utf8 */; |
3756 |
/*!40101 SET character_set_client = utf8mb4 */; |
3757 |
CREATE TABLE `import_auths` ( |
3757 |
CREATE TABLE `import_auths` ( |
3758 |
`import_record_id` int(11) NOT NULL, |
3758 |
`import_record_id` int(11) NOT NULL, |
3759 |
`matched_authid` int(11) DEFAULT NULL, |
3759 |
`matched_authid` int(11) DEFAULT NULL, |
Lines 3773-3779
CREATE TABLE `import_auths` (
Link Here
|
3773 |
|
3773 |
|
3774 |
DROP TABLE IF EXISTS `import_batch_profiles`; |
3774 |
DROP TABLE IF EXISTS `import_batch_profiles`; |
3775 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3775 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3776 |
/*!40101 SET character_set_client = utf8 */; |
3776 |
/*!40101 SET character_set_client = utf8mb4 */; |
3777 |
CREATE TABLE `import_batch_profiles` ( |
3777 |
CREATE TABLE `import_batch_profiles` ( |
3778 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
3778 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
3779 |
`name` varchar(100) NOT NULL COMMENT 'name of this profile', |
3779 |
`name` varchar(100) NOT NULL COMMENT 'name of this profile', |
Lines 3798-3804
CREATE TABLE `import_batch_profiles` (
Link Here
|
3798 |
|
3798 |
|
3799 |
DROP TABLE IF EXISTS `import_batches`; |
3799 |
DROP TABLE IF EXISTS `import_batches`; |
3800 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3800 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3801 |
/*!40101 SET character_set_client = utf8 */; |
3801 |
/*!40101 SET character_set_client = utf8mb4 */; |
3802 |
CREATE TABLE `import_batches` ( |
3802 |
CREATE TABLE `import_batches` ( |
3803 |
`import_batch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
3803 |
`import_batch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
3804 |
`matcher_id` int(11) DEFAULT NULL COMMENT 'the id of the match rule used (matchpoints.matcher_id)', |
3804 |
`matcher_id` int(11) DEFAULT NULL COMMENT 'the id of the match rule used (matchpoints.matcher_id)', |
Lines 3829-3835
CREATE TABLE `import_batches` (
Link Here
|
3829 |
|
3829 |
|
3830 |
DROP TABLE IF EXISTS `import_biblios`; |
3830 |
DROP TABLE IF EXISTS `import_biblios`; |
3831 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3831 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3832 |
/*!40101 SET character_set_client = utf8 */; |
3832 |
/*!40101 SET character_set_client = utf8mb4 */; |
3833 |
CREATE TABLE `import_biblios` ( |
3833 |
CREATE TABLE `import_biblios` ( |
3834 |
`import_record_id` int(11) NOT NULL, |
3834 |
`import_record_id` int(11) NOT NULL, |
3835 |
`matched_biblionumber` int(11) DEFAULT NULL, |
3835 |
`matched_biblionumber` int(11) DEFAULT NULL, |
Lines 3855-3861
CREATE TABLE `import_biblios` (
Link Here
|
3855 |
|
3855 |
|
3856 |
DROP TABLE IF EXISTS `import_items`; |
3856 |
DROP TABLE IF EXISTS `import_items`; |
3857 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3857 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3858 |
/*!40101 SET character_set_client = utf8 */; |
3858 |
/*!40101 SET character_set_client = utf8mb4 */; |
3859 |
CREATE TABLE `import_items` ( |
3859 |
CREATE TABLE `import_items` ( |
3860 |
`import_items_id` int(11) NOT NULL AUTO_INCREMENT, |
3860 |
`import_items_id` int(11) NOT NULL AUTO_INCREMENT, |
3861 |
`import_record_id` int(11) NOT NULL, |
3861 |
`import_record_id` int(11) NOT NULL, |
Lines 3878-3884
CREATE TABLE `import_items` (
Link Here
|
3878 |
|
3878 |
|
3879 |
DROP TABLE IF EXISTS `import_oai_authorities`; |
3879 |
DROP TABLE IF EXISTS `import_oai_authorities`; |
3880 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3880 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3881 |
/*!40101 SET character_set_client = utf8 */; |
3881 |
/*!40101 SET character_set_client = utf8mb4 */; |
3882 |
CREATE TABLE `import_oai_authorities` ( |
3882 |
CREATE TABLE `import_oai_authorities` ( |
3883 |
`import_oai_authority_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
3883 |
`import_oai_authority_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
3884 |
`authid` bigint(20) unsigned NOT NULL COMMENT 'unique identifier assigned to each koha record', |
3884 |
`authid` bigint(20) unsigned NOT NULL COMMENT 'unique identifier assigned to each koha record', |
Lines 3899-3905
CREATE TABLE `import_oai_authorities` (
Link Here
|
3899 |
|
3899 |
|
3900 |
DROP TABLE IF EXISTS `import_oai_biblios`; |
3900 |
DROP TABLE IF EXISTS `import_oai_biblios`; |
3901 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3901 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3902 |
/*!40101 SET character_set_client = utf8 */; |
3902 |
/*!40101 SET character_set_client = utf8mb4 */; |
3903 |
CREATE TABLE `import_oai_biblios` ( |
3903 |
CREATE TABLE `import_oai_biblios` ( |
3904 |
`import_oai_biblio_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
3904 |
`import_oai_biblio_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
3905 |
`biblionumber` int(11) NOT NULL COMMENT 'unique identifier assigned to each koha record', |
3905 |
`biblionumber` int(11) NOT NULL COMMENT 'unique identifier assigned to each koha record', |
Lines 3920-3926
CREATE TABLE `import_oai_biblios` (
Link Here
|
3920 |
|
3920 |
|
3921 |
DROP TABLE IF EXISTS `import_record_matches`; |
3921 |
DROP TABLE IF EXISTS `import_record_matches`; |
3922 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3922 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3923 |
/*!40101 SET character_set_client = utf8 */; |
3923 |
/*!40101 SET character_set_client = utf8mb4 */; |
3924 |
CREATE TABLE `import_record_matches` ( |
3924 |
CREATE TABLE `import_record_matches` ( |
3925 |
`import_record_id` int(11) NOT NULL COMMENT 'the id given to the imported bib record (import_records.import_record_id)', |
3925 |
`import_record_id` int(11) NOT NULL COMMENT 'the id given to the imported bib record (import_records.import_record_id)', |
3926 |
`candidate_match_id` int(11) NOT NULL COMMENT 'the biblio the imported record matches (biblio.biblionumber)', |
3926 |
`candidate_match_id` int(11) NOT NULL COMMENT 'the biblio the imported record matches (biblio.biblionumber)', |
Lines 3938-3944
CREATE TABLE `import_record_matches` (
Link Here
|
3938 |
|
3938 |
|
3939 |
DROP TABLE IF EXISTS `import_records`; |
3939 |
DROP TABLE IF EXISTS `import_records`; |
3940 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3940 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3941 |
/*!40101 SET character_set_client = utf8 */; |
3941 |
/*!40101 SET character_set_client = utf8mb4 */; |
3942 |
CREATE TABLE `import_records` ( |
3942 |
CREATE TABLE `import_records` ( |
3943 |
`import_record_id` int(11) NOT NULL AUTO_INCREMENT, |
3943 |
`import_record_id` int(11) NOT NULL AUTO_INCREMENT, |
3944 |
`import_batch_id` int(11) NOT NULL, |
3944 |
`import_batch_id` int(11) NOT NULL, |
Lines 3968-3974
CREATE TABLE `import_records` (
Link Here
|
3968 |
|
3968 |
|
3969 |
DROP TABLE IF EXISTS `issues`; |
3969 |
DROP TABLE IF EXISTS `issues`; |
3970 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3970 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3971 |
/*!40101 SET character_set_client = utf8 */; |
3971 |
/*!40101 SET character_set_client = utf8mb4 */; |
3972 |
CREATE TABLE `issues` ( |
3972 |
CREATE TABLE `issues` ( |
3973 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3973 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3974 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
3974 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
Lines 4008-4014
CREATE TABLE `issues` (
Link Here
|
4008 |
|
4008 |
|
4009 |
DROP TABLE IF EXISTS `item_bundles`; |
4009 |
DROP TABLE IF EXISTS `item_bundles`; |
4010 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4010 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4011 |
/*!40101 SET character_set_client = utf8 */; |
4011 |
/*!40101 SET character_set_client = utf8mb4 */; |
4012 |
CREATE TABLE `item_bundles` ( |
4012 |
CREATE TABLE `item_bundles` ( |
4013 |
`item` int(11) NOT NULL, |
4013 |
`item` int(11) NOT NULL, |
4014 |
`host` int(11) NOT NULL, |
4014 |
`host` int(11) NOT NULL, |
Lines 4025-4031
CREATE TABLE `item_bundles` (
Link Here
|
4025 |
|
4025 |
|
4026 |
DROP TABLE IF EXISTS `item_circulation_alert_preferences`; |
4026 |
DROP TABLE IF EXISTS `item_circulation_alert_preferences`; |
4027 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4027 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4028 |
/*!40101 SET character_set_client = utf8 */; |
4028 |
/*!40101 SET character_set_client = utf8mb4 */; |
4029 |
CREATE TABLE `item_circulation_alert_preferences` ( |
4029 |
CREATE TABLE `item_circulation_alert_preferences` ( |
4030 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4030 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4031 |
`branchcode` varchar(10) NOT NULL, |
4031 |
`branchcode` varchar(10) NOT NULL, |
Lines 4043-4049
CREATE TABLE `item_circulation_alert_preferences` (
Link Here
|
4043 |
|
4043 |
|
4044 |
DROP TABLE IF EXISTS `item_editor_templates`; |
4044 |
DROP TABLE IF EXISTS `item_editor_templates`; |
4045 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4045 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4046 |
/*!40101 SET character_set_client = utf8 */; |
4046 |
/*!40101 SET character_set_client = utf8mb4 */; |
4047 |
CREATE TABLE `item_editor_templates` ( |
4047 |
CREATE TABLE `item_editor_templates` ( |
4048 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the template', |
4048 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the template', |
4049 |
`patron_id` int(11) DEFAULT NULL COMMENT 'creator of this template', |
4049 |
`patron_id` int(11) DEFAULT NULL COMMENT 'creator of this template', |
Lines 4062-4068
CREATE TABLE `item_editor_templates` (
Link Here
|
4062 |
|
4062 |
|
4063 |
DROP TABLE IF EXISTS `item_group_items`; |
4063 |
DROP TABLE IF EXISTS `item_group_items`; |
4064 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4064 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4065 |
/*!40101 SET character_set_client = utf8 */; |
4065 |
/*!40101 SET character_set_client = utf8mb4 */; |
4066 |
CREATE TABLE `item_group_items` ( |
4066 |
CREATE TABLE `item_group_items` ( |
4067 |
`item_group_items_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the group/item link', |
4067 |
`item_group_items_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the group/item link', |
4068 |
`item_group_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key making this table a 1 to 1 join from items to item groups', |
4068 |
`item_group_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key making this table a 1 to 1 join from items to item groups', |
Lines 4081-4087
CREATE TABLE `item_group_items` (
Link Here
|
4081 |
|
4081 |
|
4082 |
DROP TABLE IF EXISTS `item_groups`; |
4082 |
DROP TABLE IF EXISTS `item_groups`; |
4083 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4083 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4084 |
/*!40101 SET character_set_client = utf8 */; |
4084 |
/*!40101 SET character_set_client = utf8mb4 */; |
4085 |
CREATE TABLE `item_groups` ( |
4085 |
CREATE TABLE `item_groups` ( |
4086 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
4086 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
4087 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to', |
4087 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to', |
Lines 4101-4107
CREATE TABLE `item_groups` (
Link Here
|
4101 |
|
4101 |
|
4102 |
DROP TABLE IF EXISTS `items`; |
4102 |
DROP TABLE IF EXISTS `items`; |
4103 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4103 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4104 |
/*!40101 SET character_set_client = utf8 */; |
4104 |
/*!40101 SET character_set_client = utf8mb4 */; |
4105 |
CREATE TABLE `items` ( |
4105 |
CREATE TABLE `items` ( |
4106 |
`itemnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier added by Koha', |
4106 |
`itemnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier added by Koha', |
4107 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record', |
4107 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record', |
Lines 4176-4182
CREATE TABLE `items` (
Link Here
|
4176 |
|
4176 |
|
4177 |
DROP TABLE IF EXISTS `items_last_borrower`; |
4177 |
DROP TABLE IF EXISTS `items_last_borrower`; |
4178 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4178 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4179 |
/*!40101 SET character_set_client = utf8 */; |
4179 |
/*!40101 SET character_set_client = utf8mb4 */; |
4180 |
CREATE TABLE `items_last_borrower` ( |
4180 |
CREATE TABLE `items_last_borrower` ( |
4181 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4181 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4182 |
`itemnumber` int(11) NOT NULL, |
4182 |
`itemnumber` int(11) NOT NULL, |
Lines 4196-4202
CREATE TABLE `items_last_borrower` (
Link Here
|
4196 |
|
4196 |
|
4197 |
DROP TABLE IF EXISTS `items_search_fields`; |
4197 |
DROP TABLE IF EXISTS `items_search_fields`; |
4198 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4198 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4199 |
/*!40101 SET character_set_client = utf8 */; |
4199 |
/*!40101 SET character_set_client = utf8mb4 */; |
4200 |
CREATE TABLE `items_search_fields` ( |
4200 |
CREATE TABLE `items_search_fields` ( |
4201 |
`name` varchar(255) NOT NULL, |
4201 |
`name` varchar(255) NOT NULL, |
4202 |
`label` varchar(255) NOT NULL, |
4202 |
`label` varchar(255) NOT NULL, |
Lines 4215-4221
CREATE TABLE `items_search_fields` (
Link Here
|
4215 |
|
4215 |
|
4216 |
DROP TABLE IF EXISTS `itemtypes`; |
4216 |
DROP TABLE IF EXISTS `itemtypes`; |
4217 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4217 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4218 |
/*!40101 SET character_set_client = utf8 */; |
4218 |
/*!40101 SET character_set_client = utf8mb4 */; |
4219 |
CREATE TABLE `itemtypes` ( |
4219 |
CREATE TABLE `itemtypes` ( |
4220 |
`itemtype` varchar(10) NOT NULL DEFAULT '' COMMENT 'unique key, a code associated with the item type', |
4220 |
`itemtype` varchar(10) NOT NULL DEFAULT '' COMMENT 'unique key, a code associated with the item type', |
4221 |
`parent_type` varchar(10) DEFAULT NULL COMMENT 'unique key, a code associated with the item type', |
4221 |
`parent_type` varchar(10) DEFAULT NULL COMMENT 'unique key, a code associated with the item type', |
Lines 4250-4256
CREATE TABLE `itemtypes` (
Link Here
|
4250 |
|
4250 |
|
4251 |
DROP TABLE IF EXISTS `itemtypes_branches`; |
4251 |
DROP TABLE IF EXISTS `itemtypes_branches`; |
4252 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4252 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4253 |
/*!40101 SET character_set_client = utf8 */; |
4253 |
/*!40101 SET character_set_client = utf8mb4 */; |
4254 |
CREATE TABLE `itemtypes_branches` ( |
4254 |
CREATE TABLE `itemtypes_branches` ( |
4255 |
`itemtype` varchar(10) NOT NULL, |
4255 |
`itemtype` varchar(10) NOT NULL, |
4256 |
`branchcode` varchar(10) NOT NULL, |
4256 |
`branchcode` varchar(10) NOT NULL, |
Lines 4267-4273
CREATE TABLE `itemtypes_branches` (
Link Here
|
4267 |
|
4267 |
|
4268 |
DROP TABLE IF EXISTS `keyboard_shortcuts`; |
4268 |
DROP TABLE IF EXISTS `keyboard_shortcuts`; |
4269 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4269 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4270 |
/*!40101 SET character_set_client = utf8 */; |
4270 |
/*!40101 SET character_set_client = utf8mb4 */; |
4271 |
CREATE TABLE `keyboard_shortcuts` ( |
4271 |
CREATE TABLE `keyboard_shortcuts` ( |
4272 |
`shortcut_name` varchar(80) NOT NULL, |
4272 |
`shortcut_name` varchar(80) NOT NULL, |
4273 |
`shortcut_keys` varchar(80) NOT NULL, |
4273 |
`shortcut_keys` varchar(80) NOT NULL, |
Lines 4281-4287
CREATE TABLE `keyboard_shortcuts` (
Link Here
|
4281 |
|
4281 |
|
4282 |
DROP TABLE IF EXISTS `language_descriptions`; |
4282 |
DROP TABLE IF EXISTS `language_descriptions`; |
4283 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4283 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4284 |
/*!40101 SET character_set_client = utf8 */; |
4284 |
/*!40101 SET character_set_client = utf8mb4 */; |
4285 |
CREATE TABLE `language_descriptions` ( |
4285 |
CREATE TABLE `language_descriptions` ( |
4286 |
`subtag` varchar(25) DEFAULT NULL, |
4286 |
`subtag` varchar(25) DEFAULT NULL, |
4287 |
`type` varchar(25) DEFAULT NULL, |
4287 |
`type` varchar(25) DEFAULT NULL, |
Lines 4300-4306
CREATE TABLE `language_descriptions` (
Link Here
|
4300 |
|
4300 |
|
4301 |
DROP TABLE IF EXISTS `language_rfc4646_to_iso639`; |
4301 |
DROP TABLE IF EXISTS `language_rfc4646_to_iso639`; |
4302 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4302 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4303 |
/*!40101 SET character_set_client = utf8 */; |
4303 |
/*!40101 SET character_set_client = utf8mb4 */; |
4304 |
CREATE TABLE `language_rfc4646_to_iso639` ( |
4304 |
CREATE TABLE `language_rfc4646_to_iso639` ( |
4305 |
`rfc4646_subtag` varchar(25) DEFAULT NULL, |
4305 |
`rfc4646_subtag` varchar(25) DEFAULT NULL, |
4306 |
`iso639_2_code` varchar(25) DEFAULT NULL, |
4306 |
`iso639_2_code` varchar(25) DEFAULT NULL, |
Lines 4317-4323
CREATE TABLE `language_rfc4646_to_iso639` (
Link Here
|
4317 |
|
4317 |
|
4318 |
DROP TABLE IF EXISTS `language_script_bidi`; |
4318 |
DROP TABLE IF EXISTS `language_script_bidi`; |
4319 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4319 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4320 |
/*!40101 SET character_set_client = utf8 */; |
4320 |
/*!40101 SET character_set_client = utf8mb4 */; |
4321 |
CREATE TABLE `language_script_bidi` ( |
4321 |
CREATE TABLE `language_script_bidi` ( |
4322 |
`rfc4646_subtag` varchar(25) DEFAULT NULL COMMENT 'script subtag, Arab, Hebr, etc.', |
4322 |
`rfc4646_subtag` varchar(25) DEFAULT NULL COMMENT 'script subtag, Arab, Hebr, etc.', |
4323 |
`bidi` varchar(3) DEFAULT NULL COMMENT 'rtl ltr', |
4323 |
`bidi` varchar(3) DEFAULT NULL COMMENT 'rtl ltr', |
Lines 4331-4337
CREATE TABLE `language_script_bidi` (
Link Here
|
4331 |
|
4331 |
|
4332 |
DROP TABLE IF EXISTS `language_script_mapping`; |
4332 |
DROP TABLE IF EXISTS `language_script_mapping`; |
4333 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4333 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4334 |
/*!40101 SET character_set_client = utf8 */; |
4334 |
/*!40101 SET character_set_client = utf8mb4 */; |
4335 |
CREATE TABLE `language_script_mapping` ( |
4335 |
CREATE TABLE `language_script_mapping` ( |
4336 |
`language_subtag` varchar(25) NOT NULL, |
4336 |
`language_subtag` varchar(25) NOT NULL, |
4337 |
`script_subtag` varchar(25) DEFAULT NULL, |
4337 |
`script_subtag` varchar(25) DEFAULT NULL, |
Lines 4345-4351
CREATE TABLE `language_script_mapping` (
Link Here
|
4345 |
|
4345 |
|
4346 |
DROP TABLE IF EXISTS `language_subtag_registry`; |
4346 |
DROP TABLE IF EXISTS `language_subtag_registry`; |
4347 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4347 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4348 |
/*!40101 SET character_set_client = utf8 */; |
4348 |
/*!40101 SET character_set_client = utf8mb4 */; |
4349 |
CREATE TABLE `language_subtag_registry` ( |
4349 |
CREATE TABLE `language_subtag_registry` ( |
4350 |
`subtag` varchar(25) DEFAULT NULL, |
4350 |
`subtag` varchar(25) DEFAULT NULL, |
4351 |
`type` varchar(25) DEFAULT NULL COMMENT 'language-script-region-variant-extension-privateuse', |
4351 |
`type` varchar(25) DEFAULT NULL COMMENT 'language-script-region-variant-extension-privateuse', |
Lines 4364-4370
CREATE TABLE `language_subtag_registry` (
Link Here
|
4364 |
|
4364 |
|
4365 |
DROP TABLE IF EXISTS `letter`; |
4365 |
DROP TABLE IF EXISTS `letter`; |
4366 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4366 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4367 |
/*!40101 SET character_set_client = utf8 */; |
4367 |
/*!40101 SET character_set_client = utf8mb4 */; |
4368 |
CREATE TABLE `letter` ( |
4368 |
CREATE TABLE `letter` ( |
4369 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
4369 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
4370 |
`module` varchar(20) NOT NULL DEFAULT '' COMMENT 'Koha module that triggers this notice or slip', |
4370 |
`module` varchar(20) NOT NULL DEFAULT '' COMMENT 'Koha module that triggers this notice or slip', |
Lines 4391-4397
CREATE TABLE `letter` (
Link Here
|
4391 |
|
4391 |
|
4392 |
DROP TABLE IF EXISTS `library_groups`; |
4392 |
DROP TABLE IF EXISTS `library_groups`; |
4393 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4393 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4394 |
/*!40101 SET character_set_client = utf8 */; |
4394 |
/*!40101 SET character_set_client = utf8mb4 */; |
4395 |
CREATE TABLE `library_groups` ( |
4395 |
CREATE TABLE `library_groups` ( |
4396 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group', |
4396 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group', |
4397 |
`parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group', |
4397 |
`parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group', |
Lines 4421-4427
CREATE TABLE `library_groups` (
Link Here
|
4421 |
|
4421 |
|
4422 |
DROP TABLE IF EXISTS `library_hours`; |
4422 |
DROP TABLE IF EXISTS `library_hours`; |
4423 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4423 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4424 |
/*!40101 SET character_set_client = utf8 */; |
4424 |
/*!40101 SET character_set_client = utf8mb4 */; |
4425 |
CREATE TABLE `library_hours` ( |
4425 |
CREATE TABLE `library_hours` ( |
4426 |
`library_id` varchar(10) NOT NULL, |
4426 |
`library_id` varchar(10) NOT NULL, |
4427 |
`day` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0', |
4427 |
`day` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0', |
Lines 4438-4444
CREATE TABLE `library_hours` (
Link Here
|
4438 |
|
4438 |
|
4439 |
DROP TABLE IF EXISTS `library_smtp_servers`; |
4439 |
DROP TABLE IF EXISTS `library_smtp_servers`; |
4440 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4440 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4441 |
/*!40101 SET character_set_client = utf8 */; |
4441 |
/*!40101 SET character_set_client = utf8mb4 */; |
4442 |
CREATE TABLE `library_smtp_servers` ( |
4442 |
CREATE TABLE `library_smtp_servers` ( |
4443 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4443 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4444 |
`library_id` varchar(10) NOT NULL, |
4444 |
`library_id` varchar(10) NOT NULL, |
Lines 4457-4463
CREATE TABLE `library_smtp_servers` (
Link Here
|
4457 |
|
4457 |
|
4458 |
DROP TABLE IF EXISTS `linktracker`; |
4458 |
DROP TABLE IF EXISTS `linktracker`; |
4459 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4459 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4460 |
/*!40101 SET character_set_client = utf8 */; |
4460 |
/*!40101 SET character_set_client = utf8mb4 */; |
4461 |
CREATE TABLE `linktracker` ( |
4461 |
CREATE TABLE `linktracker` ( |
4462 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
4462 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
4463 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'biblionumber of the record the link is from', |
4463 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'biblionumber of the record the link is from', |
Lines 4482-4488
CREATE TABLE `linktracker` (
Link Here
|
4482 |
|
4482 |
|
4483 |
DROP TABLE IF EXISTS `localization`; |
4483 |
DROP TABLE IF EXISTS `localization`; |
4484 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4484 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4485 |
/*!40101 SET character_set_client = utf8 */; |
4485 |
/*!40101 SET character_set_client = utf8mb4 */; |
4486 |
CREATE TABLE `localization` ( |
4486 |
CREATE TABLE `localization` ( |
4487 |
`localization_id` int(11) NOT NULL AUTO_INCREMENT, |
4487 |
`localization_id` int(11) NOT NULL AUTO_INCREMENT, |
4488 |
`entity` varchar(16) NOT NULL, |
4488 |
`entity` varchar(16) NOT NULL, |
Lines 4500-4506
CREATE TABLE `localization` (
Link Here
|
4500 |
|
4500 |
|
4501 |
DROP TABLE IF EXISTS `marc_matchers`; |
4501 |
DROP TABLE IF EXISTS `marc_matchers`; |
4502 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4502 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4503 |
/*!40101 SET character_set_client = utf8 */; |
4503 |
/*!40101 SET character_set_client = utf8mb4 */; |
4504 |
CREATE TABLE `marc_matchers` ( |
4504 |
CREATE TABLE `marc_matchers` ( |
4505 |
`matcher_id` int(11) NOT NULL AUTO_INCREMENT, |
4505 |
`matcher_id` int(11) NOT NULL AUTO_INCREMENT, |
4506 |
`code` varchar(10) NOT NULL DEFAULT '', |
4506 |
`code` varchar(10) NOT NULL DEFAULT '', |
Lines 4519-4525
CREATE TABLE `marc_matchers` (
Link Here
|
4519 |
|
4519 |
|
4520 |
DROP TABLE IF EXISTS `marc_modification_template_actions`; |
4520 |
DROP TABLE IF EXISTS `marc_modification_template_actions`; |
4521 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4521 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4522 |
/*!40101 SET character_set_client = utf8 */; |
4522 |
/*!40101 SET character_set_client = utf8mb4 */; |
4523 |
CREATE TABLE `marc_modification_template_actions` ( |
4523 |
CREATE TABLE `marc_modification_template_actions` ( |
4524 |
`mmta_id` int(11) NOT NULL AUTO_INCREMENT, |
4524 |
`mmta_id` int(11) NOT NULL AUTO_INCREMENT, |
4525 |
`template_id` int(11) NOT NULL, |
4525 |
`template_id` int(11) NOT NULL, |
Lines 4553-4559
CREATE TABLE `marc_modification_template_actions` (
Link Here
|
4553 |
|
4553 |
|
4554 |
DROP TABLE IF EXISTS `marc_modification_templates`; |
4554 |
DROP TABLE IF EXISTS `marc_modification_templates`; |
4555 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4555 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4556 |
/*!40101 SET character_set_client = utf8 */; |
4556 |
/*!40101 SET character_set_client = utf8mb4 */; |
4557 |
CREATE TABLE `marc_modification_templates` ( |
4557 |
CREATE TABLE `marc_modification_templates` ( |
4558 |
`template_id` int(11) NOT NULL AUTO_INCREMENT, |
4558 |
`template_id` int(11) NOT NULL AUTO_INCREMENT, |
4559 |
`name` mediumtext NOT NULL, |
4559 |
`name` mediumtext NOT NULL, |
Lines 4567-4573
CREATE TABLE `marc_modification_templates` (
Link Here
|
4567 |
|
4567 |
|
4568 |
DROP TABLE IF EXISTS `marc_order_accounts`; |
4568 |
DROP TABLE IF EXISTS `marc_order_accounts`; |
4569 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4569 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4570 |
/*!40101 SET character_set_client = utf8 */; |
4570 |
/*!40101 SET character_set_client = utf8mb4 */; |
4571 |
CREATE TABLE `marc_order_accounts` ( |
4571 |
CREATE TABLE `marc_order_accounts` ( |
4572 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
4572 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier and primary key', |
4573 |
`description` varchar(250) NOT NULL COMMENT 'description of this account', |
4573 |
`description` varchar(250) NOT NULL COMMENT 'description of this account', |
Lines 4598-4604
CREATE TABLE `marc_order_accounts` (
Link Here
|
4598 |
|
4598 |
|
4599 |
DROP TABLE IF EXISTS `marc_overlay_rules`; |
4599 |
DROP TABLE IF EXISTS `marc_overlay_rules`; |
4600 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4600 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4601 |
/*!40101 SET character_set_client = utf8 */; |
4601 |
/*!40101 SET character_set_client = utf8mb4 */; |
4602 |
CREATE TABLE `marc_overlay_rules` ( |
4602 |
CREATE TABLE `marc_overlay_rules` ( |
4603 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4603 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4604 |
`tag` varchar(255) NOT NULL, |
4604 |
`tag` varchar(255) NOT NULL, |
Lines 4618-4624
CREATE TABLE `marc_overlay_rules` (
Link Here
|
4618 |
|
4618 |
|
4619 |
DROP TABLE IF EXISTS `marc_subfield_structure`; |
4619 |
DROP TABLE IF EXISTS `marc_subfield_structure`; |
4620 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4620 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4621 |
/*!40101 SET character_set_client = utf8 */; |
4621 |
/*!40101 SET character_set_client = utf8mb4 */; |
4622 |
CREATE TABLE `marc_subfield_structure` ( |
4622 |
CREATE TABLE `marc_subfield_structure` ( |
4623 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
4623 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
4624 |
`tagsubfield` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', |
4624 |
`tagsubfield` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', |
Lines 4655-4661
CREATE TABLE `marc_subfield_structure` (
Link Here
|
4655 |
|
4655 |
|
4656 |
DROP TABLE IF EXISTS `marc_tag_structure`; |
4656 |
DROP TABLE IF EXISTS `marc_tag_structure`; |
4657 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4657 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4658 |
/*!40101 SET character_set_client = utf8 */; |
4658 |
/*!40101 SET character_set_client = utf8mb4 */; |
4659 |
CREATE TABLE `marc_tag_structure` ( |
4659 |
CREATE TABLE `marc_tag_structure` ( |
4660 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
4660 |
`tagfield` varchar(3) NOT NULL DEFAULT '', |
4661 |
`liblibrarian` varchar(255) NOT NULL DEFAULT '', |
4661 |
`liblibrarian` varchar(255) NOT NULL DEFAULT '', |
Lines 4677-4683
CREATE TABLE `marc_tag_structure` (
Link Here
|
4677 |
|
4677 |
|
4678 |
DROP TABLE IF EXISTS `matchchecks`; |
4678 |
DROP TABLE IF EXISTS `matchchecks`; |
4679 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4679 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4680 |
/*!40101 SET character_set_client = utf8 */; |
4680 |
/*!40101 SET character_set_client = utf8mb4 */; |
4681 |
CREATE TABLE `matchchecks` ( |
4681 |
CREATE TABLE `matchchecks` ( |
4682 |
`matcher_id` int(11) NOT NULL, |
4682 |
`matcher_id` int(11) NOT NULL, |
4683 |
`matchcheck_id` int(11) NOT NULL AUTO_INCREMENT, |
4683 |
`matchcheck_id` int(11) NOT NULL AUTO_INCREMENT, |
Lines 4699-4705
CREATE TABLE `matchchecks` (
Link Here
|
4699 |
|
4699 |
|
4700 |
DROP TABLE IF EXISTS `matcher_matchpoints`; |
4700 |
DROP TABLE IF EXISTS `matcher_matchpoints`; |
4701 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4701 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4702 |
/*!40101 SET character_set_client = utf8 */; |
4702 |
/*!40101 SET character_set_client = utf8mb4 */; |
4703 |
CREATE TABLE `matcher_matchpoints` ( |
4703 |
CREATE TABLE `matcher_matchpoints` ( |
4704 |
`matcher_id` int(11) NOT NULL, |
4704 |
`matcher_id` int(11) NOT NULL, |
4705 |
`matchpoint_id` int(11) NOT NULL, |
4705 |
`matchpoint_id` int(11) NOT NULL, |
Lines 4716-4722
CREATE TABLE `matcher_matchpoints` (
Link Here
|
4716 |
|
4716 |
|
4717 |
DROP TABLE IF EXISTS `matchpoint_component_norms`; |
4717 |
DROP TABLE IF EXISTS `matchpoint_component_norms`; |
4718 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4718 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4719 |
/*!40101 SET character_set_client = utf8 */; |
4719 |
/*!40101 SET character_set_client = utf8mb4 */; |
4720 |
CREATE TABLE `matchpoint_component_norms` ( |
4720 |
CREATE TABLE `matchpoint_component_norms` ( |
4721 |
`matchpoint_component_id` int(11) NOT NULL, |
4721 |
`matchpoint_component_id` int(11) NOT NULL, |
4722 |
`sequence` int(11) NOT NULL DEFAULT 0, |
4722 |
`sequence` int(11) NOT NULL DEFAULT 0, |
Lines 4732-4738
CREATE TABLE `matchpoint_component_norms` (
Link Here
|
4732 |
|
4732 |
|
4733 |
DROP TABLE IF EXISTS `matchpoint_components`; |
4733 |
DROP TABLE IF EXISTS `matchpoint_components`; |
4734 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4734 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4735 |
/*!40101 SET character_set_client = utf8 */; |
4735 |
/*!40101 SET character_set_client = utf8mb4 */; |
4736 |
CREATE TABLE `matchpoint_components` ( |
4736 |
CREATE TABLE `matchpoint_components` ( |
4737 |
`matchpoint_id` int(11) NOT NULL, |
4737 |
`matchpoint_id` int(11) NOT NULL, |
4738 |
`matchpoint_component_id` int(11) NOT NULL AUTO_INCREMENT, |
4738 |
`matchpoint_component_id` int(11) NOT NULL AUTO_INCREMENT, |
Lines 4753-4759
CREATE TABLE `matchpoint_components` (
Link Here
|
4753 |
|
4753 |
|
4754 |
DROP TABLE IF EXISTS `matchpoints`; |
4754 |
DROP TABLE IF EXISTS `matchpoints`; |
4755 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4755 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4756 |
/*!40101 SET character_set_client = utf8 */; |
4756 |
/*!40101 SET character_set_client = utf8mb4 */; |
4757 |
CREATE TABLE `matchpoints` ( |
4757 |
CREATE TABLE `matchpoints` ( |
4758 |
`matcher_id` int(11) NOT NULL, |
4758 |
`matcher_id` int(11) NOT NULL, |
4759 |
`matchpoint_id` int(11) NOT NULL AUTO_INCREMENT, |
4759 |
`matchpoint_id` int(11) NOT NULL AUTO_INCREMENT, |
Lines 4771-4777
CREATE TABLE `matchpoints` (
Link Here
|
4771 |
|
4771 |
|
4772 |
DROP TABLE IF EXISTS `message_attributes`; |
4772 |
DROP TABLE IF EXISTS `message_attributes`; |
4773 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4773 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4774 |
/*!40101 SET character_set_client = utf8 */; |
4774 |
/*!40101 SET character_set_client = utf8mb4 */; |
4775 |
CREATE TABLE `message_attributes` ( |
4775 |
CREATE TABLE `message_attributes` ( |
4776 |
`message_attribute_id` int(11) NOT NULL AUTO_INCREMENT, |
4776 |
`message_attribute_id` int(11) NOT NULL AUTO_INCREMENT, |
4777 |
`message_name` varchar(40) NOT NULL DEFAULT '', |
4777 |
`message_name` varchar(40) NOT NULL DEFAULT '', |
Lines 4787-4793
CREATE TABLE `message_attributes` (
Link Here
|
4787 |
|
4787 |
|
4788 |
DROP TABLE IF EXISTS `message_queue`; |
4788 |
DROP TABLE IF EXISTS `message_queue`; |
4789 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4789 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4790 |
/*!40101 SET character_set_client = utf8 */; |
4790 |
/*!40101 SET character_set_client = utf8mb4 */; |
4791 |
CREATE TABLE `message_queue` ( |
4791 |
CREATE TABLE `message_queue` ( |
4792 |
`message_id` int(11) NOT NULL AUTO_INCREMENT, |
4792 |
`message_id` int(11) NOT NULL AUTO_INCREMENT, |
4793 |
`letter_id` int(11) DEFAULT NULL COMMENT 'Foreign key to the letters table', |
4793 |
`letter_id` int(11) DEFAULT NULL COMMENT 'Foreign key to the letters table', |
Lines 4822-4828
CREATE TABLE `message_queue` (
Link Here
|
4822 |
|
4822 |
|
4823 |
DROP TABLE IF EXISTS `message_transport_types`; |
4823 |
DROP TABLE IF EXISTS `message_transport_types`; |
4824 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4824 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4825 |
/*!40101 SET character_set_client = utf8 */; |
4825 |
/*!40101 SET character_set_client = utf8mb4 */; |
4826 |
CREATE TABLE `message_transport_types` ( |
4826 |
CREATE TABLE `message_transport_types` ( |
4827 |
`message_transport_type` varchar(20) NOT NULL, |
4827 |
`message_transport_type` varchar(20) NOT NULL, |
4828 |
PRIMARY KEY (`message_transport_type`) |
4828 |
PRIMARY KEY (`message_transport_type`) |
Lines 4835-4841
CREATE TABLE `message_transport_types` (
Link Here
|
4835 |
|
4835 |
|
4836 |
DROP TABLE IF EXISTS `message_transports`; |
4836 |
DROP TABLE IF EXISTS `message_transports`; |
4837 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4837 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4838 |
/*!40101 SET character_set_client = utf8 */; |
4838 |
/*!40101 SET character_set_client = utf8mb4 */; |
4839 |
CREATE TABLE `message_transports` ( |
4839 |
CREATE TABLE `message_transports` ( |
4840 |
`message_attribute_id` int(11) NOT NULL, |
4840 |
`message_attribute_id` int(11) NOT NULL, |
4841 |
`message_transport_type` varchar(20) NOT NULL, |
4841 |
`message_transport_type` varchar(20) NOT NULL, |
Lines 4857-4863
CREATE TABLE `message_transports` (
Link Here
|
4857 |
|
4857 |
|
4858 |
DROP TABLE IF EXISTS `messages`; |
4858 |
DROP TABLE IF EXISTS `messages`; |
4859 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4859 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4860 |
/*!40101 SET character_set_client = utf8 */; |
4860 |
/*!40101 SET character_set_client = utf8mb4 */; |
4861 |
CREATE TABLE `messages` ( |
4861 |
CREATE TABLE `messages` ( |
4862 |
`message_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
4862 |
`message_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
4863 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key linking this message to the borrowers table', |
4863 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key linking this message to the borrowers table', |
Lines 4881-4887
CREATE TABLE `messages` (
Link Here
|
4881 |
|
4881 |
|
4882 |
DROP TABLE IF EXISTS `misc_files`; |
4882 |
DROP TABLE IF EXISTS `misc_files`; |
4883 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4883 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4884 |
/*!40101 SET character_set_client = utf8 */; |
4884 |
/*!40101 SET character_set_client = utf8mb4 */; |
4885 |
CREATE TABLE `misc_files` ( |
4885 |
CREATE TABLE `misc_files` ( |
4886 |
`file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the file record', |
4886 |
`file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the file record', |
4887 |
`table_tag` varchar(255) NOT NULL COMMENT 'usually table name, or arbitrary unique tag', |
4887 |
`table_tag` varchar(255) NOT NULL COMMENT 'usually table name, or arbitrary unique tag', |
Lines 4903-4909
CREATE TABLE `misc_files` (
Link Here
|
4903 |
|
4903 |
|
4904 |
DROP TABLE IF EXISTS `need_merge_authorities`; |
4904 |
DROP TABLE IF EXISTS `need_merge_authorities`; |
4905 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4905 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4906 |
/*!40101 SET character_set_client = utf8 */; |
4906 |
/*!40101 SET character_set_client = utf8mb4 */; |
4907 |
CREATE TABLE `need_merge_authorities` ( |
4907 |
CREATE TABLE `need_merge_authorities` ( |
4908 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id', |
4908 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id', |
4909 |
`authid` bigint(20) NOT NULL COMMENT 'reference to original authority record', |
4909 |
`authid` bigint(20) NOT NULL COMMENT 'reference to original authority record', |
Lines 4921-4927
CREATE TABLE `need_merge_authorities` (
Link Here
|
4921 |
|
4921 |
|
4922 |
DROP TABLE IF EXISTS `oai_servers`; |
4922 |
DROP TABLE IF EXISTS `oai_servers`; |
4923 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4923 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4924 |
/*!40101 SET character_set_client = utf8 */; |
4924 |
/*!40101 SET character_set_client = utf8mb4 */; |
4925 |
CREATE TABLE `oai_servers` ( |
4925 |
CREATE TABLE `oai_servers` ( |
4926 |
`oai_server_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
4926 |
`oai_server_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
4927 |
`endpoint` varchar(255) NOT NULL COMMENT 'OAI endpoint (host + port + path)', |
4927 |
`endpoint` varchar(255) NOT NULL COMMENT 'OAI endpoint (host + port + path)', |
Lines 4940-4946
CREATE TABLE `oai_servers` (
Link Here
|
4940 |
|
4940 |
|
4941 |
DROP TABLE IF EXISTS `oai_sets`; |
4941 |
DROP TABLE IF EXISTS `oai_sets`; |
4942 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4942 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4943 |
/*!40101 SET character_set_client = utf8 */; |
4943 |
/*!40101 SET character_set_client = utf8mb4 */; |
4944 |
CREATE TABLE `oai_sets` ( |
4944 |
CREATE TABLE `oai_sets` ( |
4945 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4945 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4946 |
`spec` varchar(80) NOT NULL, |
4946 |
`spec` varchar(80) NOT NULL, |
Lines 4956-4962
CREATE TABLE `oai_sets` (
Link Here
|
4956 |
|
4956 |
|
4957 |
DROP TABLE IF EXISTS `oai_sets_biblios`; |
4957 |
DROP TABLE IF EXISTS `oai_sets_biblios`; |
4958 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4958 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4959 |
/*!40101 SET character_set_client = utf8 */; |
4959 |
/*!40101 SET character_set_client = utf8mb4 */; |
4960 |
CREATE TABLE `oai_sets_biblios` ( |
4960 |
CREATE TABLE `oai_sets_biblios` ( |
4961 |
`biblionumber` int(11) NOT NULL, |
4961 |
`biblionumber` int(11) NOT NULL, |
4962 |
`set_id` int(11) NOT NULL, |
4962 |
`set_id` int(11) NOT NULL, |
Lines 4972-4978
CREATE TABLE `oai_sets_biblios` (
Link Here
|
4972 |
|
4972 |
|
4973 |
DROP TABLE IF EXISTS `oai_sets_descriptions`; |
4973 |
DROP TABLE IF EXISTS `oai_sets_descriptions`; |
4974 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4974 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4975 |
/*!40101 SET character_set_client = utf8 */; |
4975 |
/*!40101 SET character_set_client = utf8mb4 */; |
4976 |
CREATE TABLE `oai_sets_descriptions` ( |
4976 |
CREATE TABLE `oai_sets_descriptions` ( |
4977 |
`set_id` int(11) NOT NULL, |
4977 |
`set_id` int(11) NOT NULL, |
4978 |
`description` varchar(255) NOT NULL, |
4978 |
`description` varchar(255) NOT NULL, |
Lines 4987-4993
CREATE TABLE `oai_sets_descriptions` (
Link Here
|
4987 |
|
4987 |
|
4988 |
DROP TABLE IF EXISTS `oai_sets_mappings`; |
4988 |
DROP TABLE IF EXISTS `oai_sets_mappings`; |
4989 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4989 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4990 |
/*!40101 SET character_set_client = utf8 */; |
4990 |
/*!40101 SET character_set_client = utf8mb4 */; |
4991 |
CREATE TABLE `oai_sets_mappings` ( |
4991 |
CREATE TABLE `oai_sets_mappings` ( |
4992 |
`set_id` int(11) NOT NULL, |
4992 |
`set_id` int(11) NOT NULL, |
4993 |
`rule_order` int(11) DEFAULT NULL, |
4993 |
`rule_order` int(11) DEFAULT NULL, |
Lines 5007-5013
CREATE TABLE `oai_sets_mappings` (
Link Here
|
5007 |
|
5007 |
|
5008 |
DROP TABLE IF EXISTS `oauth_access_tokens`; |
5008 |
DROP TABLE IF EXISTS `oauth_access_tokens`; |
5009 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5009 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5010 |
/*!40101 SET character_set_client = utf8 */; |
5010 |
/*!40101 SET character_set_client = utf8mb4 */; |
5011 |
CREATE TABLE `oauth_access_tokens` ( |
5011 |
CREATE TABLE `oauth_access_tokens` ( |
5012 |
`access_token` varchar(191) NOT NULL COMMENT 'generarated access token', |
5012 |
`access_token` varchar(191) NOT NULL COMMENT 'generarated access token', |
5013 |
`client_id` varchar(191) NOT NULL COMMENT 'the client id the access token belongs to', |
5013 |
`client_id` varchar(191) NOT NULL COMMENT 'the client id the access token belongs to', |
Lines 5023-5029
CREATE TABLE `oauth_access_tokens` (
Link Here
|
5023 |
|
5023 |
|
5024 |
DROP TABLE IF EXISTS `old_issues`; |
5024 |
DROP TABLE IF EXISTS `old_issues`; |
5025 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5025 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5026 |
/*!40101 SET character_set_client = utf8 */; |
5026 |
/*!40101 SET character_set_client = utf8mb4 */; |
5027 |
CREATE TABLE `old_issues` ( |
5027 |
CREATE TABLE `old_issues` ( |
5028 |
`issue_id` int(11) NOT NULL COMMENT 'primary key for issues table', |
5028 |
`issue_id` int(11) NOT NULL COMMENT 'primary key for issues table', |
5029 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
5029 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
Lines 5062-5068
CREATE TABLE `old_issues` (
Link Here
|
5062 |
|
5062 |
|
5063 |
DROP TABLE IF EXISTS `old_reserves`; |
5063 |
DROP TABLE IF EXISTS `old_reserves`; |
5064 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5064 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5065 |
/*!40101 SET character_set_client = utf8 */; |
5065 |
/*!40101 SET character_set_client = utf8mb4 */; |
5066 |
CREATE TABLE `old_reserves` ( |
5066 |
CREATE TABLE `old_reserves` ( |
5067 |
`reserve_id` int(11) NOT NULL COMMENT 'primary key', |
5067 |
`reserve_id` int(11) NOT NULL COMMENT 'primary key', |
5068 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
5068 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
Lines 5112-5118
CREATE TABLE `old_reserves` (
Link Here
|
5112 |
|
5112 |
|
5113 |
DROP TABLE IF EXISTS `overduerules`; |
5113 |
DROP TABLE IF EXISTS `overduerules`; |
5114 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5114 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5115 |
/*!40101 SET character_set_client = utf8 */; |
5115 |
/*!40101 SET character_set_client = utf8mb4 */; |
5116 |
CREATE TABLE `overduerules` ( |
5116 |
CREATE TABLE `overduerules` ( |
5117 |
`overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', |
5117 |
`overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', |
5118 |
`branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)', |
5118 |
`branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)', |
Lines 5137-5143
CREATE TABLE `overduerules` (
Link Here
|
5137 |
|
5137 |
|
5138 |
DROP TABLE IF EXISTS `overduerules_transport_types`; |
5138 |
DROP TABLE IF EXISTS `overduerules_transport_types`; |
5139 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5139 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5140 |
/*!40101 SET character_set_client = utf8 */; |
5140 |
/*!40101 SET character_set_client = utf8mb4 */; |
5141 |
CREATE TABLE `overduerules_transport_types` ( |
5141 |
CREATE TABLE `overduerules_transport_types` ( |
5142 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5142 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5143 |
`letternumber` int(1) NOT NULL DEFAULT 1, |
5143 |
`letternumber` int(1) NOT NULL DEFAULT 1, |
Lines 5157-5163
CREATE TABLE `overduerules_transport_types` (
Link Here
|
5157 |
|
5157 |
|
5158 |
DROP TABLE IF EXISTS `patron_consent`; |
5158 |
DROP TABLE IF EXISTS `patron_consent`; |
5159 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5159 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5160 |
/*!40101 SET character_set_client = utf8 */; |
5160 |
/*!40101 SET character_set_client = utf8mb4 */; |
5161 |
CREATE TABLE `patron_consent` ( |
5161 |
CREATE TABLE `patron_consent` ( |
5162 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5162 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5163 |
`borrowernumber` int(11) NOT NULL, |
5163 |
`borrowernumber` int(11) NOT NULL, |
Lines 5176-5182
CREATE TABLE `patron_consent` (
Link Here
|
5176 |
|
5176 |
|
5177 |
DROP TABLE IF EXISTS `patron_list_patrons`; |
5177 |
DROP TABLE IF EXISTS `patron_list_patrons`; |
5178 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5178 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5179 |
/*!40101 SET character_set_client = utf8 */; |
5179 |
/*!40101 SET character_set_client = utf8mb4 */; |
5180 |
CREATE TABLE `patron_list_patrons` ( |
5180 |
CREATE TABLE `patron_list_patrons` ( |
5181 |
`patron_list_patron_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
5181 |
`patron_list_patron_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
5182 |
`patron_list_id` int(11) NOT NULL COMMENT 'the list this entry is part of', |
5182 |
`patron_list_id` int(11) NOT NULL COMMENT 'the list this entry is part of', |
Lines 5195-5201
CREATE TABLE `patron_list_patrons` (
Link Here
|
5195 |
|
5195 |
|
5196 |
DROP TABLE IF EXISTS `patron_lists`; |
5196 |
DROP TABLE IF EXISTS `patron_lists`; |
5197 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5197 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5198 |
/*!40101 SET character_set_client = utf8 */; |
5198 |
/*!40101 SET character_set_client = utf8mb4 */; |
5199 |
CREATE TABLE `patron_lists` ( |
5199 |
CREATE TABLE `patron_lists` ( |
5200 |
`patron_list_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
5200 |
`patron_list_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', |
5201 |
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'the list''s name', |
5201 |
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'the list''s name', |
Lines 5213-5219
CREATE TABLE `patron_lists` (
Link Here
|
5213 |
|
5213 |
|
5214 |
DROP TABLE IF EXISTS `patronimage`; |
5214 |
DROP TABLE IF EXISTS `patronimage`; |
5215 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5215 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5216 |
/*!40101 SET character_set_client = utf8 */; |
5216 |
/*!40101 SET character_set_client = utf8mb4 */; |
5217 |
CREATE TABLE `patronimage` ( |
5217 |
CREATE TABLE `patronimage` ( |
5218 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)', |
5218 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)', |
5219 |
`mimetype` varchar(15) NOT NULL COMMENT 'the format of the image (png, jpg, etc)', |
5219 |
`mimetype` varchar(15) NOT NULL COMMENT 'the format of the image (png, jpg, etc)', |
Lines 5229-5235
CREATE TABLE `patronimage` (
Link Here
|
5229 |
|
5229 |
|
5230 |
DROP TABLE IF EXISTS `pending_offline_operations`; |
5230 |
DROP TABLE IF EXISTS `pending_offline_operations`; |
5231 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5231 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5232 |
/*!40101 SET character_set_client = utf8 */; |
5232 |
/*!40101 SET character_set_client = utf8mb4 */; |
5233 |
CREATE TABLE `pending_offline_operations` ( |
5233 |
CREATE TABLE `pending_offline_operations` ( |
5234 |
`operationid` int(11) NOT NULL AUTO_INCREMENT, |
5234 |
`operationid` int(11) NOT NULL AUTO_INCREMENT, |
5235 |
`userid` varchar(30) NOT NULL, |
5235 |
`userid` varchar(30) NOT NULL, |
Lines 5249-5255
CREATE TABLE `pending_offline_operations` (
Link Here
|
5249 |
|
5249 |
|
5250 |
DROP TABLE IF EXISTS `permissions`; |
5250 |
DROP TABLE IF EXISTS `permissions`; |
5251 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5251 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5252 |
/*!40101 SET character_set_client = utf8 */; |
5252 |
/*!40101 SET character_set_client = utf8mb4 */; |
5253 |
CREATE TABLE `permissions` ( |
5253 |
CREATE TABLE `permissions` ( |
5254 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5254 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5255 |
`code` varchar(64) NOT NULL DEFAULT '', |
5255 |
`code` varchar(64) NOT NULL DEFAULT '', |
Lines 5265-5271
CREATE TABLE `permissions` (
Link Here
|
5265 |
|
5265 |
|
5266 |
DROP TABLE IF EXISTS `plugin_data`; |
5266 |
DROP TABLE IF EXISTS `plugin_data`; |
5267 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5267 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5268 |
/*!40101 SET character_set_client = utf8 */; |
5268 |
/*!40101 SET character_set_client = utf8mb4 */; |
5269 |
CREATE TABLE `plugin_data` ( |
5269 |
CREATE TABLE `plugin_data` ( |
5270 |
`plugin_class` varchar(255) NOT NULL, |
5270 |
`plugin_class` varchar(255) NOT NULL, |
5271 |
`plugin_key` varchar(255) NOT NULL, |
5271 |
`plugin_key` varchar(255) NOT NULL, |
Lines 5280-5286
CREATE TABLE `plugin_data` (
Link Here
|
5280 |
|
5280 |
|
5281 |
DROP TABLE IF EXISTS `plugin_methods`; |
5281 |
DROP TABLE IF EXISTS `plugin_methods`; |
5282 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5282 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5283 |
/*!40101 SET character_set_client = utf8 */; |
5283 |
/*!40101 SET character_set_client = utf8mb4 */; |
5284 |
CREATE TABLE `plugin_methods` ( |
5284 |
CREATE TABLE `plugin_methods` ( |
5285 |
`plugin_class` varchar(255) NOT NULL, |
5285 |
`plugin_class` varchar(255) NOT NULL, |
5286 |
`plugin_method` varchar(255) NOT NULL, |
5286 |
`plugin_method` varchar(255) NOT NULL, |
Lines 5294-5300
CREATE TABLE `plugin_methods` (
Link Here
|
5294 |
|
5294 |
|
5295 |
DROP TABLE IF EXISTS `preservation_processing_attributes`; |
5295 |
DROP TABLE IF EXISTS `preservation_processing_attributes`; |
5296 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5296 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5297 |
/*!40101 SET character_set_client = utf8 */; |
5297 |
/*!40101 SET character_set_client = utf8mb4 */; |
5298 |
CREATE TABLE `preservation_processing_attributes` ( |
5298 |
CREATE TABLE `preservation_processing_attributes` ( |
5299 |
`processing_attribute_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5299 |
`processing_attribute_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5300 |
`processing_id` int(11) NOT NULL COMMENT 'link to the processing', |
5300 |
`processing_id` int(11) NOT NULL COMMENT 'link to the processing', |
Lines 5313-5319
CREATE TABLE `preservation_processing_attributes` (
Link Here
|
5313 |
|
5313 |
|
5314 |
DROP TABLE IF EXISTS `preservation_processing_attributes_items`; |
5314 |
DROP TABLE IF EXISTS `preservation_processing_attributes_items`; |
5315 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5315 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5316 |
/*!40101 SET character_set_client = utf8 */; |
5316 |
/*!40101 SET character_set_client = utf8mb4 */; |
5317 |
CREATE TABLE `preservation_processing_attributes_items` ( |
5317 |
CREATE TABLE `preservation_processing_attributes_items` ( |
5318 |
`processing_attribute_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5318 |
`processing_attribute_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5319 |
`processing_attribute_id` int(11) NOT NULL COMMENT 'link with preservation_processing_attributes', |
5319 |
`processing_attribute_id` int(11) NOT NULL COMMENT 'link with preservation_processing_attributes', |
Lines 5333-5339
CREATE TABLE `preservation_processing_attributes_items` (
Link Here
|
5333 |
|
5333 |
|
5334 |
DROP TABLE IF EXISTS `preservation_processings`; |
5334 |
DROP TABLE IF EXISTS `preservation_processings`; |
5335 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5335 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5336 |
/*!40101 SET character_set_client = utf8 */; |
5336 |
/*!40101 SET character_set_client = utf8mb4 */; |
5337 |
CREATE TABLE `preservation_processings` ( |
5337 |
CREATE TABLE `preservation_processings` ( |
5338 |
`processing_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5338 |
`processing_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5339 |
`name` varchar(80) NOT NULL COMMENT 'name of the processing', |
5339 |
`name` varchar(80) NOT NULL COMMENT 'name of the processing', |
Lines 5348-5354
CREATE TABLE `preservation_processings` (
Link Here
|
5348 |
|
5348 |
|
5349 |
DROP TABLE IF EXISTS `preservation_trains`; |
5349 |
DROP TABLE IF EXISTS `preservation_trains`; |
5350 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5350 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5351 |
/*!40101 SET character_set_client = utf8 */; |
5351 |
/*!40101 SET character_set_client = utf8mb4 */; |
5352 |
CREATE TABLE `preservation_trains` ( |
5352 |
CREATE TABLE `preservation_trains` ( |
5353 |
`train_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5353 |
`train_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5354 |
`name` varchar(80) NOT NULL COMMENT 'name of the train', |
5354 |
`name` varchar(80) NOT NULL COMMENT 'name of the train', |
Lines 5371-5377
CREATE TABLE `preservation_trains` (
Link Here
|
5371 |
|
5371 |
|
5372 |
DROP TABLE IF EXISTS `preservation_trains_items`; |
5372 |
DROP TABLE IF EXISTS `preservation_trains_items`; |
5373 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5373 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5374 |
/*!40101 SET character_set_client = utf8 */; |
5374 |
/*!40101 SET character_set_client = utf8mb4 */; |
5375 |
CREATE TABLE `preservation_trains_items` ( |
5375 |
CREATE TABLE `preservation_trains_items` ( |
5376 |
`train_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5376 |
`train_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5377 |
`train_id` int(11) NOT NULL COMMENT 'link with preservation_train', |
5377 |
`train_id` int(11) NOT NULL COMMENT 'link with preservation_train', |
Lines 5395-5401
CREATE TABLE `preservation_trains_items` (
Link Here
|
5395 |
|
5395 |
|
5396 |
DROP TABLE IF EXISTS `printers_profile`; |
5396 |
DROP TABLE IF EXISTS `printers_profile`; |
5397 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5397 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5398 |
/*!40101 SET character_set_client = utf8 */; |
5398 |
/*!40101 SET character_set_client = utf8mb4 */; |
5399 |
CREATE TABLE `printers_profile` ( |
5399 |
CREATE TABLE `printers_profile` ( |
5400 |
`profile_id` int(4) NOT NULL AUTO_INCREMENT, |
5400 |
`profile_id` int(4) NOT NULL AUTO_INCREMENT, |
5401 |
`printer_name` varchar(40) NOT NULL DEFAULT 'Default Printer', |
5401 |
`printer_name` varchar(40) NOT NULL DEFAULT 'Default Printer', |
Lines 5418-5424
CREATE TABLE `printers_profile` (
Link Here
|
5418 |
|
5418 |
|
5419 |
DROP TABLE IF EXISTS `problem_reports`; |
5419 |
DROP TABLE IF EXISTS `problem_reports`; |
5420 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5420 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5421 |
/*!40101 SET character_set_client = utf8 */; |
5421 |
/*!40101 SET character_set_client = utf8mb4 */; |
5422 |
CREATE TABLE `problem_reports` ( |
5422 |
CREATE TABLE `problem_reports` ( |
5423 |
`reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5423 |
`reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5424 |
`title` varchar(40) NOT NULL DEFAULT '' COMMENT 'report subject line', |
5424 |
`title` varchar(40) NOT NULL DEFAULT '' COMMENT 'report subject line', |
Lines 5444-5450
CREATE TABLE `problem_reports` (
Link Here
|
5444 |
|
5444 |
|
5445 |
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; |
5445 |
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; |
5446 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5446 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5447 |
/*!40101 SET character_set_client = utf8 */; |
5447 |
/*!40101 SET character_set_client = utf8mb4 */; |
5448 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5448 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5449 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5449 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5450 |
`transaction_id` int(11) NOT NULL, |
5450 |
`transaction_id` int(11) NOT NULL, |
Lines 5464-5470
CREATE TABLE `pseudonymized_borrower_attributes` (
Link Here
|
5464 |
|
5464 |
|
5465 |
DROP TABLE IF EXISTS `pseudonymized_transactions`; |
5465 |
DROP TABLE IF EXISTS `pseudonymized_transactions`; |
5466 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5466 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5467 |
/*!40101 SET character_set_client = utf8 */; |
5467 |
/*!40101 SET character_set_client = utf8mb4 */; |
5468 |
CREATE TABLE `pseudonymized_transactions` ( |
5468 |
CREATE TABLE `pseudonymized_transactions` ( |
5469 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5469 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5470 |
`hashed_borrowernumber` varchar(60) NOT NULL, |
5470 |
`hashed_borrowernumber` varchar(60) NOT NULL, |
Lines 5506-5512
CREATE TABLE `pseudonymized_transactions` (
Link Here
|
5506 |
|
5506 |
|
5507 |
DROP TABLE IF EXISTS `quotes`; |
5507 |
DROP TABLE IF EXISTS `quotes`; |
5508 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5508 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5509 |
/*!40101 SET character_set_client = utf8 */; |
5509 |
/*!40101 SET character_set_client = utf8mb4 */; |
5510 |
CREATE TABLE `quotes` ( |
5510 |
CREATE TABLE `quotes` ( |
5511 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the quote', |
5511 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the quote', |
5512 |
`source` mediumtext DEFAULT NULL COMMENT 'source/credit for the quote', |
5512 |
`source` mediumtext DEFAULT NULL COMMENT 'source/credit for the quote', |
Lines 5522-5528
CREATE TABLE `quotes` (
Link Here
|
5522 |
|
5522 |
|
5523 |
DROP TABLE IF EXISTS `ratings`; |
5523 |
DROP TABLE IF EXISTS `ratings`; |
5524 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5524 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5525 |
/*!40101 SET character_set_client = utf8 */; |
5525 |
/*!40101 SET character_set_client = utf8mb4 */; |
5526 |
CREATE TABLE `ratings` ( |
5526 |
CREATE TABLE `ratings` ( |
5527 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron who left this rating (borrowers.borrowernumber)', |
5527 |
`borrowernumber` int(11) NOT NULL COMMENT 'the borrowernumber of the patron who left this rating (borrowers.borrowernumber)', |
5528 |
`biblionumber` int(11) NOT NULL COMMENT 'the biblio this rating is for (biblio.biblionumber)', |
5528 |
`biblionumber` int(11) NOT NULL COMMENT 'the biblio this rating is for (biblio.biblionumber)', |
Lines 5541-5547
CREATE TABLE `ratings` (
Link Here
|
5541 |
|
5541 |
|
5542 |
DROP TABLE IF EXISTS `recalls`; |
5542 |
DROP TABLE IF EXISTS `recalls`; |
5543 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5543 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5544 |
/*!40101 SET character_set_client = utf8 */; |
5544 |
/*!40101 SET character_set_client = utf8mb4 */; |
5545 |
CREATE TABLE `recalls` ( |
5545 |
CREATE TABLE `recalls` ( |
5546 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
5546 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
5547 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
5547 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
Lines 5576-5582
CREATE TABLE `recalls` (
Link Here
|
5576 |
|
5576 |
|
5577 |
DROP TABLE IF EXISTS `record_sources`; |
5577 |
DROP TABLE IF EXISTS `record_sources`; |
5578 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5578 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5579 |
/*!40101 SET character_set_client = utf8 */; |
5579 |
/*!40101 SET character_set_client = utf8mb4 */; |
5580 |
CREATE TABLE `record_sources` ( |
5580 |
CREATE TABLE `record_sources` ( |
5581 |
`record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table', |
5581 |
`record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table', |
5582 |
`name` text NOT NULL COMMENT 'User defined name for the record source', |
5582 |
`name` text NOT NULL COMMENT 'User defined name for the record source', |
Lines 5591-5597
CREATE TABLE `record_sources` (
Link Here
|
5591 |
|
5591 |
|
5592 |
DROP TABLE IF EXISTS `repeatable_holidays`; |
5592 |
DROP TABLE IF EXISTS `repeatable_holidays`; |
5593 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5593 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5594 |
/*!40101 SET character_set_client = utf8 */; |
5594 |
/*!40101 SET character_set_client = utf8mb4 */; |
5595 |
CREATE TABLE `repeatable_holidays` ( |
5595 |
CREATE TABLE `repeatable_holidays` ( |
5596 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5596 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5597 |
`branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for', |
5597 |
`branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for', |
Lines 5612-5618
CREATE TABLE `repeatable_holidays` (
Link Here
|
5612 |
|
5612 |
|
5613 |
DROP TABLE IF EXISTS `reports_dictionary`; |
5613 |
DROP TABLE IF EXISTS `reports_dictionary`; |
5614 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5614 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5615 |
/*!40101 SET character_set_client = utf8 */; |
5615 |
/*!40101 SET character_set_client = utf8mb4 */; |
5616 |
CREATE TABLE `reports_dictionary` ( |
5616 |
CREATE TABLE `reports_dictionary` ( |
5617 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5617 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
5618 |
`name` varchar(255) DEFAULT NULL COMMENT 'name for this definition', |
5618 |
`name` varchar(255) DEFAULT NULL COMMENT 'name for this definition', |
Lines 5632-5638
CREATE TABLE `reports_dictionary` (
Link Here
|
5632 |
|
5632 |
|
5633 |
DROP TABLE IF EXISTS `reserves`; |
5633 |
DROP TABLE IF EXISTS `reserves`; |
5634 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5634 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5635 |
/*!40101 SET character_set_client = utf8 */; |
5635 |
/*!40101 SET character_set_client = utf8mb4 */; |
5636 |
CREATE TABLE `reserves` ( |
5636 |
CREATE TABLE `reserves` ( |
5637 |
`reserve_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5637 |
`reserve_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
5638 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
5638 |
`borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for', |
Lines 5685-5691
CREATE TABLE `reserves` (
Link Here
|
5685 |
|
5685 |
|
5686 |
DROP TABLE IF EXISTS `restriction_types`; |
5686 |
DROP TABLE IF EXISTS `restriction_types`; |
5687 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5687 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5688 |
/*!40101 SET character_set_client = utf8 */; |
5688 |
/*!40101 SET character_set_client = utf8mb4 */; |
5689 |
CREATE TABLE `restriction_types` ( |
5689 |
CREATE TABLE `restriction_types` ( |
5690 |
`code` varchar(50) NOT NULL, |
5690 |
`code` varchar(50) NOT NULL, |
5691 |
`display_text` text NOT NULL, |
5691 |
`display_text` text NOT NULL, |
Lines 5703-5709
CREATE TABLE `restriction_types` (
Link Here
|
5703 |
|
5703 |
|
5704 |
DROP TABLE IF EXISTS `return_claims`; |
5704 |
DROP TABLE IF EXISTS `return_claims`; |
5705 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5705 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5706 |
/*!40101 SET character_set_client = utf8 */; |
5706 |
/*!40101 SET character_set_client = utf8mb4 */; |
5707 |
CREATE TABLE `return_claims` ( |
5707 |
CREATE TABLE `return_claims` ( |
5708 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the return claim', |
5708 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the return claim', |
5709 |
`itemnumber` int(11) NOT NULL COMMENT 'ID of the item', |
5709 |
`itemnumber` int(11) NOT NULL COMMENT 'ID of the item', |
Lines 5738-5744
CREATE TABLE `return_claims` (
Link Here
|
5738 |
|
5738 |
|
5739 |
DROP TABLE IF EXISTS `reviews`; |
5739 |
DROP TABLE IF EXISTS `reviews`; |
5740 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5740 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5741 |
/*!40101 SET character_set_client = utf8 */; |
5741 |
/*!40101 SET character_set_client = utf8mb4 */; |
5742 |
CREATE TABLE `reviews` ( |
5742 |
CREATE TABLE `reviews` ( |
5743 |
`reviewid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for this comment', |
5743 |
`reviewid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for this comment', |
5744 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron left this comment', |
5744 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table defining which patron left this comment', |
Lines 5760-5766
CREATE TABLE `reviews` (
Link Here
|
5760 |
|
5760 |
|
5761 |
DROP TABLE IF EXISTS `saved_reports`; |
5761 |
DROP TABLE IF EXISTS `saved_reports`; |
5762 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5762 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5763 |
/*!40101 SET character_set_client = utf8 */; |
5763 |
/*!40101 SET character_set_client = utf8mb4 */; |
5764 |
CREATE TABLE `saved_reports` ( |
5764 |
CREATE TABLE `saved_reports` ( |
5765 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5765 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5766 |
`report_id` int(11) DEFAULT NULL, |
5766 |
`report_id` int(11) DEFAULT NULL, |
Lines 5776-5782
CREATE TABLE `saved_reports` (
Link Here
|
5776 |
|
5776 |
|
5777 |
DROP TABLE IF EXISTS `saved_sql`; |
5777 |
DROP TABLE IF EXISTS `saved_sql`; |
5778 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5778 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5779 |
/*!40101 SET character_set_client = utf8 */; |
5779 |
/*!40101 SET character_set_client = utf8mb4 */; |
5780 |
CREATE TABLE `saved_sql` ( |
5780 |
CREATE TABLE `saved_sql` ( |
5781 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id and primary key assigned by Koha', |
5781 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id and primary key assigned by Koha', |
5782 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'the staff member who created this report (borrowers.borrowernumber)', |
5782 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'the staff member who created this report (borrowers.borrowernumber)', |
Lines 5805-5811
CREATE TABLE `saved_sql` (
Link Here
|
5805 |
|
5805 |
|
5806 |
DROP TABLE IF EXISTS `search_field`; |
5806 |
DROP TABLE IF EXISTS `search_field`; |
5807 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5807 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5808 |
/*!40101 SET character_set_client = utf8 */; |
5808 |
/*!40101 SET character_set_client = utf8mb4 */; |
5809 |
CREATE TABLE `search_field` ( |
5809 |
CREATE TABLE `search_field` ( |
5810 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5810 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5811 |
`name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine', |
5811 |
`name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine', |
Lines 5828-5834
CREATE TABLE `search_field` (
Link Here
|
5828 |
|
5828 |
|
5829 |
DROP TABLE IF EXISTS `search_filters`; |
5829 |
DROP TABLE IF EXISTS `search_filters`; |
5830 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5830 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5831 |
/*!40101 SET character_set_client = utf8 */; |
5831 |
/*!40101 SET character_set_client = utf8mb4 */; |
5832 |
CREATE TABLE `search_filters` ( |
5832 |
CREATE TABLE `search_filters` ( |
5833 |
`search_filter_id` int(11) NOT NULL AUTO_INCREMENT, |
5833 |
`search_filter_id` int(11) NOT NULL AUTO_INCREMENT, |
5834 |
`name` varchar(255) NOT NULL COMMENT 'filter name', |
5834 |
`name` varchar(255) NOT NULL COMMENT 'filter name', |
Lines 5846-5852
CREATE TABLE `search_filters` (
Link Here
|
5846 |
|
5846 |
|
5847 |
DROP TABLE IF EXISTS `search_history`; |
5847 |
DROP TABLE IF EXISTS `search_history`; |
5848 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5848 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5849 |
/*!40101 SET character_set_client = utf8 */; |
5849 |
/*!40101 SET character_set_client = utf8mb4 */; |
5850 |
CREATE TABLE `search_history` ( |
5850 |
CREATE TABLE `search_history` ( |
5851 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'search history id', |
5851 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'search history id', |
5852 |
`userid` int(11) NOT NULL COMMENT 'the patron who performed the search (borrowers.borrowernumber)', |
5852 |
`userid` int(11) NOT NULL COMMENT 'the patron who performed the search (borrowers.borrowernumber)', |
Lines 5868-5874
CREATE TABLE `search_history` (
Link Here
|
5868 |
|
5868 |
|
5869 |
DROP TABLE IF EXISTS `search_marc_map`; |
5869 |
DROP TABLE IF EXISTS `search_marc_map`; |
5870 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5870 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5871 |
/*!40101 SET character_set_client = utf8 */; |
5871 |
/*!40101 SET character_set_client = utf8mb4 */; |
5872 |
CREATE TABLE `search_marc_map` ( |
5872 |
CREATE TABLE `search_marc_map` ( |
5873 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5873 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5874 |
`index_name` enum('biblios','authorities') NOT NULL COMMENT 'what storage index this map is for', |
5874 |
`index_name` enum('biblios','authorities') NOT NULL COMMENT 'what storage index this map is for', |
Lines 5886-5892
CREATE TABLE `search_marc_map` (
Link Here
|
5886 |
|
5886 |
|
5887 |
DROP TABLE IF EXISTS `search_marc_to_field`; |
5887 |
DROP TABLE IF EXISTS `search_marc_to_field`; |
5888 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5888 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5889 |
/*!40101 SET character_set_client = utf8 */; |
5889 |
/*!40101 SET character_set_client = utf8mb4 */; |
5890 |
CREATE TABLE `search_marc_to_field` ( |
5890 |
CREATE TABLE `search_marc_to_field` ( |
5891 |
`search` tinyint(1) NOT NULL DEFAULT 1, |
5891 |
`search` tinyint(1) NOT NULL DEFAULT 1, |
5892 |
`filter` varchar(100) NOT NULL DEFAULT '' COMMENT 'specify a filter to be applied to field', |
5892 |
`filter` varchar(100) NOT NULL DEFAULT '' COMMENT 'specify a filter to be applied to field', |
Lines 5908-5914
CREATE TABLE `search_marc_to_field` (
Link Here
|
5908 |
|
5908 |
|
5909 |
DROP TABLE IF EXISTS `serial`; |
5909 |
DROP TABLE IF EXISTS `serial`; |
5910 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5910 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5911 |
/*!40101 SET character_set_client = utf8 */; |
5911 |
/*!40101 SET character_set_client = utf8mb4 */; |
5912 |
CREATE TABLE `serial` ( |
5912 |
CREATE TABLE `serial` ( |
5913 |
`serialid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the issue', |
5913 |
`serialid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the issue', |
5914 |
`biblionumber` int(11) NOT NULL COMMENT 'foreign key for the biblio.biblionumber that this issue is attached to', |
5914 |
`biblionumber` int(11) NOT NULL COMMENT 'foreign key for the biblio.biblionumber that this issue is attached to', |
Lines 5939-5945
CREATE TABLE `serial` (
Link Here
|
5939 |
|
5939 |
|
5940 |
DROP TABLE IF EXISTS `serialitems`; |
5940 |
DROP TABLE IF EXISTS `serialitems`; |
5941 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5941 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5942 |
/*!40101 SET character_set_client = utf8 */; |
5942 |
/*!40101 SET character_set_client = utf8mb4 */; |
5943 |
CREATE TABLE `serialitems` ( |
5943 |
CREATE TABLE `serialitems` ( |
5944 |
`itemnumber` int(11) NOT NULL, |
5944 |
`itemnumber` int(11) NOT NULL, |
5945 |
`serialid` int(11) NOT NULL, |
5945 |
`serialid` int(11) NOT NULL, |
Lines 5956-5962
CREATE TABLE `serialitems` (
Link Here
|
5956 |
|
5956 |
|
5957 |
DROP TABLE IF EXISTS `sessions`; |
5957 |
DROP TABLE IF EXISTS `sessions`; |
5958 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5958 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5959 |
/*!40101 SET character_set_client = utf8 */; |
5959 |
/*!40101 SET character_set_client = utf8mb4 */; |
5960 |
CREATE TABLE `sessions` ( |
5960 |
CREATE TABLE `sessions` ( |
5961 |
`id` varchar(32) NOT NULL, |
5961 |
`id` varchar(32) NOT NULL, |
5962 |
`a_session` longblob NOT NULL, |
5962 |
`a_session` longblob NOT NULL, |
Lines 5970-5976
CREATE TABLE `sessions` (
Link Here
|
5970 |
|
5970 |
|
5971 |
DROP TABLE IF EXISTS `sms_providers`; |
5971 |
DROP TABLE IF EXISTS `sms_providers`; |
5972 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5972 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5973 |
/*!40101 SET character_set_client = utf8 */; |
5973 |
/*!40101 SET character_set_client = utf8mb4 */; |
5974 |
CREATE TABLE `sms_providers` ( |
5974 |
CREATE TABLE `sms_providers` ( |
5975 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5975 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5976 |
`name` varchar(255) NOT NULL, |
5976 |
`name` varchar(255) NOT NULL, |
Lines 5986-5992
CREATE TABLE `sms_providers` (
Link Here
|
5986 |
|
5986 |
|
5987 |
DROP TABLE IF EXISTS `smtp_servers`; |
5987 |
DROP TABLE IF EXISTS `smtp_servers`; |
5988 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5988 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5989 |
/*!40101 SET character_set_client = utf8 */; |
5989 |
/*!40101 SET character_set_client = utf8mb4 */; |
5990 |
CREATE TABLE `smtp_servers` ( |
5990 |
CREATE TABLE `smtp_servers` ( |
5991 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5991 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
5992 |
`name` varchar(80) NOT NULL, |
5992 |
`name` varchar(80) NOT NULL, |
Lines 6009-6015
CREATE TABLE `smtp_servers` (
Link Here
|
6009 |
|
6009 |
|
6010 |
DROP TABLE IF EXISTS `social_data`; |
6010 |
DROP TABLE IF EXISTS `social_data`; |
6011 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6011 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6012 |
/*!40101 SET character_set_client = utf8 */; |
6012 |
/*!40101 SET character_set_client = utf8mb4 */; |
6013 |
CREATE TABLE `social_data` ( |
6013 |
CREATE TABLE `social_data` ( |
6014 |
`isbn` varchar(30) NOT NULL DEFAULT '', |
6014 |
`isbn` varchar(30) NOT NULL DEFAULT '', |
6015 |
`num_critics` int(11) DEFAULT NULL, |
6015 |
`num_critics` int(11) DEFAULT NULL, |
Lines 6028-6034
CREATE TABLE `social_data` (
Link Here
|
6028 |
|
6028 |
|
6029 |
DROP TABLE IF EXISTS `special_holidays`; |
6029 |
DROP TABLE IF EXISTS `special_holidays`; |
6030 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6030 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6031 |
/*!40101 SET character_set_client = utf8 */; |
6031 |
/*!40101 SET character_set_client = utf8mb4 */; |
6032 |
CREATE TABLE `special_holidays` ( |
6032 |
CREATE TABLE `special_holidays` ( |
6033 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6033 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6034 |
`branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for', |
6034 |
`branchcode` varchar(10) NOT NULL COMMENT 'foreign key from the branches table, defines which branch this closing is for', |
Lines 6050-6056
CREATE TABLE `special_holidays` (
Link Here
|
6050 |
|
6050 |
|
6051 |
DROP TABLE IF EXISTS `statistics`; |
6051 |
DROP TABLE IF EXISTS `statistics`; |
6052 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6052 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6053 |
/*!40101 SET character_set_client = utf8 */; |
6053 |
/*!40101 SET character_set_client = utf8mb4 */; |
6054 |
CREATE TABLE `statistics` ( |
6054 |
CREATE TABLE `statistics` ( |
6055 |
`datetime` datetime DEFAULT NULL COMMENT 'date and time of the transaction', |
6055 |
`datetime` datetime DEFAULT NULL COMMENT 'date and time of the transaction', |
6056 |
`branch` varchar(10) DEFAULT NULL COMMENT 'foreign key, branch where the transaction occurred', |
6056 |
`branch` varchar(10) DEFAULT NULL COMMENT 'foreign key, branch where the transaction occurred', |
Lines 6080-6086
CREATE TABLE `statistics` (
Link Here
|
6080 |
|
6080 |
|
6081 |
DROP TABLE IF EXISTS `stockrotationitems`; |
6081 |
DROP TABLE IF EXISTS `stockrotationitems`; |
6082 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6082 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6083 |
/*!40101 SET character_set_client = utf8 */; |
6083 |
/*!40101 SET character_set_client = utf8mb4 */; |
6084 |
CREATE TABLE `stockrotationitems` ( |
6084 |
CREATE TABLE `stockrotationitems` ( |
6085 |
`itemnumber_id` int(11) NOT NULL COMMENT 'Itemnumber to link to a stage & rota', |
6085 |
`itemnumber_id` int(11) NOT NULL COMMENT 'Itemnumber to link to a stage & rota', |
6086 |
`stage_id` int(11) NOT NULL COMMENT 'stage ID to link the item to', |
6086 |
`stage_id` int(11) NOT NULL COMMENT 'stage ID to link the item to', |
Lines 6099-6105
CREATE TABLE `stockrotationitems` (
Link Here
|
6099 |
|
6099 |
|
6100 |
DROP TABLE IF EXISTS `stockrotationrotas`; |
6100 |
DROP TABLE IF EXISTS `stockrotationrotas`; |
6101 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6101 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6102 |
/*!40101 SET character_set_client = utf8 */; |
6102 |
/*!40101 SET character_set_client = utf8mb4 */; |
6103 |
CREATE TABLE `stockrotationrotas` ( |
6103 |
CREATE TABLE `stockrotationrotas` ( |
6104 |
`rota_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Stockrotation rota ID', |
6104 |
`rota_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Stockrotation rota ID', |
6105 |
`title` varchar(100) NOT NULL COMMENT 'Title for this rota', |
6105 |
`title` varchar(100) NOT NULL COMMENT 'Title for this rota', |
Lines 6117-6123
CREATE TABLE `stockrotationrotas` (
Link Here
|
6117 |
|
6117 |
|
6118 |
DROP TABLE IF EXISTS `stockrotationstages`; |
6118 |
DROP TABLE IF EXISTS `stockrotationstages`; |
6119 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6119 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6120 |
/*!40101 SET character_set_client = utf8 */; |
6120 |
/*!40101 SET character_set_client = utf8mb4 */; |
6121 |
CREATE TABLE `stockrotationstages` ( |
6121 |
CREATE TABLE `stockrotationstages` ( |
6122 |
`stage_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique stage ID', |
6122 |
`stage_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique stage ID', |
6123 |
`position` int(11) NOT NULL COMMENT 'The position of this stage within its rota', |
6123 |
`position` int(11) NOT NULL COMMENT 'The position of this stage within its rota', |
Lines 6138-6144
CREATE TABLE `stockrotationstages` (
Link Here
|
6138 |
|
6138 |
|
6139 |
DROP TABLE IF EXISTS `subscription`; |
6139 |
DROP TABLE IF EXISTS `subscription`; |
6140 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6140 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6141 |
/*!40101 SET character_set_client = utf8 */; |
6141 |
/*!40101 SET character_set_client = utf8mb4 */; |
6142 |
CREATE TABLE `subscription` ( |
6142 |
CREATE TABLE `subscription` ( |
6143 |
`biblionumber` int(11) NOT NULL COMMENT 'foreign key for biblio.biblionumber that this subscription is attached to', |
6143 |
`biblionumber` int(11) NOT NULL COMMENT 'foreign key for biblio.biblionumber that this subscription is attached to', |
6144 |
`subscriptionid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for this subscription', |
6144 |
`subscriptionid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for this subscription', |
Lines 6203-6209
CREATE TABLE `subscription` (
Link Here
|
6203 |
|
6203 |
|
6204 |
DROP TABLE IF EXISTS `subscription_frequencies`; |
6204 |
DROP TABLE IF EXISTS `subscription_frequencies`; |
6205 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6205 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6206 |
/*!40101 SET character_set_client = utf8 */; |
6206 |
/*!40101 SET character_set_client = utf8mb4 */; |
6207 |
CREATE TABLE `subscription_frequencies` ( |
6207 |
CREATE TABLE `subscription_frequencies` ( |
6208 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6208 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6209 |
`description` mediumtext NOT NULL, |
6209 |
`description` mediumtext NOT NULL, |
Lines 6221-6227
CREATE TABLE `subscription_frequencies` (
Link Here
|
6221 |
|
6221 |
|
6222 |
DROP TABLE IF EXISTS `subscription_numberpatterns`; |
6222 |
DROP TABLE IF EXISTS `subscription_numberpatterns`; |
6223 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6223 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6224 |
/*!40101 SET character_set_client = utf8 */; |
6224 |
/*!40101 SET character_set_client = utf8mb4 */; |
6225 |
CREATE TABLE `subscription_numberpatterns` ( |
6225 |
CREATE TABLE `subscription_numberpatterns` ( |
6226 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6226 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6227 |
`label` varchar(255) NOT NULL, |
6227 |
`label` varchar(255) NOT NULL, |
Lines 6256-6262
CREATE TABLE `subscription_numberpatterns` (
Link Here
|
6256 |
|
6256 |
|
6257 |
DROP TABLE IF EXISTS `subscriptionhistory`; |
6257 |
DROP TABLE IF EXISTS `subscriptionhistory`; |
6258 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6258 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6259 |
/*!40101 SET character_set_client = utf8 */; |
6259 |
/*!40101 SET character_set_client = utf8mb4 */; |
6260 |
CREATE TABLE `subscriptionhistory` ( |
6260 |
CREATE TABLE `subscriptionhistory` ( |
6261 |
`biblionumber` int(11) NOT NULL, |
6261 |
`biblionumber` int(11) NOT NULL, |
6262 |
`subscriptionid` int(11) NOT NULL, |
6262 |
`subscriptionid` int(11) NOT NULL, |
Lines 6279-6285
CREATE TABLE `subscriptionhistory` (
Link Here
|
6279 |
|
6279 |
|
6280 |
DROP TABLE IF EXISTS `subscriptionroutinglist`; |
6280 |
DROP TABLE IF EXISTS `subscriptionroutinglist`; |
6281 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6281 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6282 |
/*!40101 SET character_set_client = utf8 */; |
6282 |
/*!40101 SET character_set_client = utf8mb4 */; |
6283 |
CREATE TABLE `subscriptionroutinglist` ( |
6283 |
CREATE TABLE `subscriptionroutinglist` ( |
6284 |
`routingid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6284 |
`routingid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6285 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines with patron is on the routing list', |
6285 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines with patron is on the routing list', |
Lines 6299-6305
CREATE TABLE `subscriptionroutinglist` (
Link Here
|
6299 |
|
6299 |
|
6300 |
DROP TABLE IF EXISTS `suggestions`; |
6300 |
DROP TABLE IF EXISTS `suggestions`; |
6301 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6301 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6302 |
/*!40101 SET character_set_client = utf8 */; |
6302 |
/*!40101 SET character_set_client = utf8mb4 */; |
6303 |
CREATE TABLE `suggestions` ( |
6303 |
CREATE TABLE `suggestions` ( |
6304 |
`suggestionid` int(8) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned automatically by Koha', |
6304 |
`suggestionid` int(8) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned automatically by Koha', |
6305 |
`suggestedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the person making the suggestion, foreign key linking to the borrowers table', |
6305 |
`suggestedby` int(11) DEFAULT NULL COMMENT 'borrowernumber for the person making the suggestion, foreign key linking to the borrowers table', |
Lines 6363-6369
CREATE TABLE `suggestions` (
Link Here
|
6363 |
|
6363 |
|
6364 |
DROP TABLE IF EXISTS `systempreferences`; |
6364 |
DROP TABLE IF EXISTS `systempreferences`; |
6365 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6365 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6366 |
/*!40101 SET character_set_client = utf8 */; |
6366 |
/*!40101 SET character_set_client = utf8mb4 */; |
6367 |
CREATE TABLE `systempreferences` ( |
6367 |
CREATE TABLE `systempreferences` ( |
6368 |
`variable` varchar(50) NOT NULL DEFAULT '' COMMENT 'system preference name', |
6368 |
`variable` varchar(50) NOT NULL DEFAULT '' COMMENT 'system preference name', |
6369 |
`value` mediumtext DEFAULT NULL COMMENT 'system preference values', |
6369 |
`value` mediumtext DEFAULT NULL COMMENT 'system preference values', |
Lines 6380-6386
CREATE TABLE `systempreferences` (
Link Here
|
6380 |
|
6380 |
|
6381 |
DROP TABLE IF EXISTS `tables_settings`; |
6381 |
DROP TABLE IF EXISTS `tables_settings`; |
6382 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6382 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6383 |
/*!40101 SET character_set_client = utf8 */; |
6383 |
/*!40101 SET character_set_client = utf8mb4 */; |
6384 |
CREATE TABLE `tables_settings` ( |
6384 |
CREATE TABLE `tables_settings` ( |
6385 |
`module` varchar(255) NOT NULL, |
6385 |
`module` varchar(255) NOT NULL, |
6386 |
`page` varchar(255) NOT NULL, |
6386 |
`page` varchar(255) NOT NULL, |
Lines 6399-6405
CREATE TABLE `tables_settings` (
Link Here
|
6399 |
|
6399 |
|
6400 |
DROP TABLE IF EXISTS `tags`; |
6400 |
DROP TABLE IF EXISTS `tags`; |
6401 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6401 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6402 |
/*!40101 SET character_set_client = utf8 */; |
6402 |
/*!40101 SET character_set_client = utf8mb4 */; |
6403 |
CREATE TABLE `tags` ( |
6403 |
CREATE TABLE `tags` ( |
6404 |
`entry` varchar(255) NOT NULL DEFAULT '', |
6404 |
`entry` varchar(255) NOT NULL DEFAULT '', |
6405 |
`weight` bigint(20) NOT NULL DEFAULT 0, |
6405 |
`weight` bigint(20) NOT NULL DEFAULT 0, |
Lines 6413-6419
CREATE TABLE `tags` (
Link Here
|
6413 |
|
6413 |
|
6414 |
DROP TABLE IF EXISTS `tags_all`; |
6414 |
DROP TABLE IF EXISTS `tags_all`; |
6415 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6415 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6416 |
/*!40101 SET character_set_client = utf8 */; |
6416 |
/*!40101 SET character_set_client = utf8mb4 */; |
6417 |
CREATE TABLE `tags_all` ( |
6417 |
CREATE TABLE `tags_all` ( |
6418 |
`tag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id and primary key', |
6418 |
`tag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id and primary key', |
6419 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'the patron who added the tag (borrowers.borrowernumber)', |
6419 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'the patron who added the tag (borrowers.borrowernumber)', |
Lines 6435-6441
CREATE TABLE `tags_all` (
Link Here
|
6435 |
|
6435 |
|
6436 |
DROP TABLE IF EXISTS `tags_approval`; |
6436 |
DROP TABLE IF EXISTS `tags_approval`; |
6437 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6437 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6438 |
/*!40101 SET character_set_client = utf8 */; |
6438 |
/*!40101 SET character_set_client = utf8mb4 */; |
6439 |
CREATE TABLE `tags_approval` ( |
6439 |
CREATE TABLE `tags_approval` ( |
6440 |
`term` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'the tag', |
6440 |
`term` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'the tag', |
6441 |
`approved` int(1) NOT NULL DEFAULT 0 COMMENT 'whether the tag is approved or not (1=yes, 0=pending, -1=rejected)', |
6441 |
`approved` int(1) NOT NULL DEFAULT 0 COMMENT 'whether the tag is approved or not (1=yes, 0=pending, -1=rejected)', |
Lines 6454-6460
CREATE TABLE `tags_approval` (
Link Here
|
6454 |
|
6454 |
|
6455 |
DROP TABLE IF EXISTS `tags_index`; |
6455 |
DROP TABLE IF EXISTS `tags_index`; |
6456 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6456 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6457 |
/*!40101 SET character_set_client = utf8 */; |
6457 |
/*!40101 SET character_set_client = utf8mb4 */; |
6458 |
CREATE TABLE `tags_index` ( |
6458 |
CREATE TABLE `tags_index` ( |
6459 |
`term` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'the tag', |
6459 |
`term` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'the tag', |
6460 |
`biblionumber` int(11) NOT NULL COMMENT 'the bib record this tag was used on (biblio.biblionumber)', |
6460 |
`biblionumber` int(11) NOT NULL COMMENT 'the bib record this tag was used on (biblio.biblionumber)', |
Lines 6472-6478
CREATE TABLE `tags_index` (
Link Here
|
6472 |
|
6472 |
|
6473 |
DROP TABLE IF EXISTS `ticket_updates`; |
6473 |
DROP TABLE IF EXISTS `ticket_updates`; |
6474 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6474 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6475 |
/*!40101 SET character_set_client = utf8 */; |
6475 |
/*!40101 SET character_set_client = utf8mb4 */; |
6476 |
CREATE TABLE `ticket_updates` ( |
6476 |
CREATE TABLE `ticket_updates` ( |
6477 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6477 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6478 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
6478 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
Lines 6498-6504
CREATE TABLE `ticket_updates` (
Link Here
|
6498 |
|
6498 |
|
6499 |
DROP TABLE IF EXISTS `tickets`; |
6499 |
DROP TABLE IF EXISTS `tickets`; |
6500 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6500 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6501 |
/*!40101 SET character_set_client = utf8 */; |
6501 |
/*!40101 SET character_set_client = utf8mb4 */; |
6502 |
CREATE TABLE `tickets` ( |
6502 |
CREATE TABLE `tickets` ( |
6503 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6503 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6504 |
`source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket', |
6504 |
`source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket', |
Lines 6529-6535
CREATE TABLE `tickets` (
Link Here
|
6529 |
|
6529 |
|
6530 |
DROP TABLE IF EXISTS `tmp_holdsqueue`; |
6530 |
DROP TABLE IF EXISTS `tmp_holdsqueue`; |
6531 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6531 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6532 |
/*!40101 SET character_set_client = utf8 */; |
6532 |
/*!40101 SET character_set_client = utf8mb4 */; |
6533 |
CREATE TABLE `tmp_holdsqueue` ( |
6533 |
CREATE TABLE `tmp_holdsqueue` ( |
6534 |
`biblionumber` int(11) DEFAULT NULL, |
6534 |
`biblionumber` int(11) DEFAULT NULL, |
6535 |
`itemnumber` int(11) NOT NULL, |
6535 |
`itemnumber` int(11) NOT NULL, |
Lines 6563-6569
CREATE TABLE `tmp_holdsqueue` (
Link Here
|
6563 |
|
6563 |
|
6564 |
DROP TABLE IF EXISTS `transport_cost`; |
6564 |
DROP TABLE IF EXISTS `transport_cost`; |
6565 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6565 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6566 |
/*!40101 SET character_set_client = utf8 */; |
6566 |
/*!40101 SET character_set_client = utf8mb4 */; |
6567 |
CREATE TABLE `transport_cost` ( |
6567 |
CREATE TABLE `transport_cost` ( |
6568 |
`frombranch` varchar(10) NOT NULL, |
6568 |
`frombranch` varchar(10) NOT NULL, |
6569 |
`tobranch` varchar(10) NOT NULL, |
6569 |
`tobranch` varchar(10) NOT NULL, |
Lines 6582-6588
CREATE TABLE `transport_cost` (
Link Here
|
6582 |
|
6582 |
|
6583 |
DROP TABLE IF EXISTS `uploaded_files`; |
6583 |
DROP TABLE IF EXISTS `uploaded_files`; |
6584 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6584 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6585 |
/*!40101 SET character_set_client = utf8 */; |
6585 |
/*!40101 SET character_set_client = utf8mb4 */; |
6586 |
CREATE TABLE `uploaded_files` ( |
6586 |
CREATE TABLE `uploaded_files` ( |
6587 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6587 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6588 |
`hashvalue` char(40) NOT NULL, |
6588 |
`hashvalue` char(40) NOT NULL, |
Lines 6604-6610
CREATE TABLE `uploaded_files` (
Link Here
|
6604 |
|
6604 |
|
6605 |
DROP TABLE IF EXISTS `user_permissions`; |
6605 |
DROP TABLE IF EXISTS `user_permissions`; |
6606 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6606 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6607 |
/*!40101 SET character_set_client = utf8 */; |
6607 |
/*!40101 SET character_set_client = utf8mb4 */; |
6608 |
CREATE TABLE `user_permissions` ( |
6608 |
CREATE TABLE `user_permissions` ( |
6609 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
6609 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
6610 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
6610 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
Lines 6623-6629
CREATE TABLE `user_permissions` (
Link Here
|
6623 |
|
6623 |
|
6624 |
DROP TABLE IF EXISTS `userflags`; |
6624 |
DROP TABLE IF EXISTS `userflags`; |
6625 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6625 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6626 |
/*!40101 SET character_set_client = utf8 */; |
6626 |
/*!40101 SET character_set_client = utf8mb4 */; |
6627 |
CREATE TABLE `userflags` ( |
6627 |
CREATE TABLE `userflags` ( |
6628 |
`bit` int(11) NOT NULL DEFAULT 0, |
6628 |
`bit` int(11) NOT NULL DEFAULT 0, |
6629 |
`flag` varchar(30) DEFAULT NULL, |
6629 |
`flag` varchar(30) DEFAULT NULL, |
Lines 6639-6645
CREATE TABLE `userflags` (
Link Here
|
6639 |
|
6639 |
|
6640 |
DROP TABLE IF EXISTS `vendor_edi_accounts`; |
6640 |
DROP TABLE IF EXISTS `vendor_edi_accounts`; |
6641 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6641 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6642 |
/*!40101 SET character_set_client = utf8 */; |
6642 |
/*!40101 SET character_set_client = utf8mb4 */; |
6643 |
CREATE TABLE `vendor_edi_accounts` ( |
6643 |
CREATE TABLE `vendor_edi_accounts` ( |
6644 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6644 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6645 |
`description` mediumtext NOT NULL, |
6645 |
`description` mediumtext NOT NULL, |
Lines 6677-6683
CREATE TABLE `vendor_edi_accounts` (
Link Here
|
6677 |
|
6677 |
|
6678 |
DROP TABLE IF EXISTS `virtualshelfcontents`; |
6678 |
DROP TABLE IF EXISTS `virtualshelfcontents`; |
6679 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6679 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6680 |
/*!40101 SET character_set_client = utf8 */; |
6680 |
/*!40101 SET character_set_client = utf8mb4 */; |
6681 |
CREATE TABLE `virtualshelfcontents` ( |
6681 |
CREATE TABLE `virtualshelfcontents` ( |
6682 |
`shelfnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking to the virtualshelves table, defines the list that this record has been added to', |
6682 |
`shelfnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking to the virtualshelves table, defines the list that this record has been added to', |
6683 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking to the biblio table, defines the bib record that has been added to the list', |
6683 |
`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key linking to the biblio table, defines the bib record that has been added to the list', |
Lines 6698-6704
CREATE TABLE `virtualshelfcontents` (
Link Here
|
6698 |
|
6698 |
|
6699 |
DROP TABLE IF EXISTS `virtualshelfshares`; |
6699 |
DROP TABLE IF EXISTS `virtualshelfshares`; |
6700 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6700 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6701 |
/*!40101 SET character_set_client = utf8 */; |
6701 |
/*!40101 SET character_set_client = utf8mb4 */; |
6702 |
CREATE TABLE `virtualshelfshares` ( |
6702 |
CREATE TABLE `virtualshelfshares` ( |
6703 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
6703 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
6704 |
`shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves', |
6704 |
`shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves', |
Lines 6719-6725
CREATE TABLE `virtualshelfshares` (
Link Here
|
6719 |
|
6719 |
|
6720 |
DROP TABLE IF EXISTS `virtualshelves`; |
6720 |
DROP TABLE IF EXISTS `virtualshelves`; |
6721 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6721 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6722 |
/*!40101 SET character_set_client = utf8 */; |
6722 |
/*!40101 SET character_set_client = utf8mb4 */; |
6723 |
CREATE TABLE `virtualshelves` ( |
6723 |
CREATE TABLE `virtualshelves` ( |
6724 |
`shelfnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6724 |
`shelfnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6725 |
`shelfname` varchar(255) DEFAULT NULL COMMENT 'name of the list', |
6725 |
`shelfname` varchar(255) DEFAULT NULL COMMENT 'name of the list', |
Lines 6744-6750
CREATE TABLE `virtualshelves` (
Link Here
|
6744 |
|
6744 |
|
6745 |
DROP TABLE IF EXISTS `z3950servers`; |
6745 |
DROP TABLE IF EXISTS `z3950servers`; |
6746 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6746 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6747 |
/*!40101 SET character_set_client = utf8 */; |
6747 |
/*!40101 SET character_set_client = utf8mb4 */; |
6748 |
CREATE TABLE `z3950servers` ( |
6748 |
CREATE TABLE `z3950servers` ( |
6749 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6749 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', |
6750 |
`host` varchar(255) NOT NULL COMMENT 'target''s host name', |
6750 |
`host` varchar(255) NOT NULL COMMENT 'target''s host name', |
Lines 6774-6780
CREATE TABLE `z3950servers` (
Link Here
|
6774 |
|
6774 |
|
6775 |
DROP TABLE IF EXISTS `zebraqueue`; |
6775 |
DROP TABLE IF EXISTS `zebraqueue`; |
6776 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6776 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6777 |
/*!40101 SET character_set_client = utf8 */; |
6777 |
/*!40101 SET character_set_client = utf8mb4 */; |
6778 |
CREATE TABLE `zebraqueue` ( |
6778 |
CREATE TABLE `zebraqueue` ( |
6779 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6779 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
6780 |
`biblio_auth_number` bigint(20) unsigned NOT NULL DEFAULT 0, |
6780 |
`biblio_auth_number` bigint(20) unsigned NOT NULL DEFAULT 0, |
Lines 6796-6799
CREATE TABLE `zebraqueue` (
Link Here
|
6796 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
6796 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
6797 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
6797 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
6798 |
|
6798 |
|
6799 |
-- Dump completed on 2024-11-25 12:13:27 |
6799 |
-- Dump completed on 2025-05-05 12:15:00 |
6800 |
- |
|
|