View | Details | Raw Unified | Return to bug 39833
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1-8 Link Here
1
-- MariaDB dump 10.19  Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64)
1
-- MariaDB dump 10.19  Distrib 10.11.11-MariaDB, for debian-linux-gnu (x86_64)
2
--
2
--
3
-- Host: db    Database: koha_kohadev
3
-- Host: db    Database: koha_kohadev
4
-- ------------------------------------------------------
4
-- ------------------------------------------------------
(-)Server version (-279 / +278 lines)
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
- 

Return to bug 39833