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

(-)a/installer/data/mysql/kohastructure.sql (-230 / +229 lines)
Lines 8-14 Link Here
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
10
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
11
/*!40101 SET NAMES utf8 */;
11
/*!40101 SET NAMES utf8mb4 */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
Lines 32-38 CREATE TABLE `auth_header` ( Link Here
32
  `marcxml` longtext NOT NULL,
32
  `marcxml` longtext NOT NULL,
33
  PRIMARY KEY  (`authid`),
33
  PRIMARY KEY  (`authid`),
34
  KEY `origincode` (`origincode`)
34
  KEY `origincode` (`origincode`)
35
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
36
36
37
--
37
--
38
-- Table structure for table `auth_types`
38
-- Table structure for table `auth_types`
Lines 45-51 CREATE TABLE `auth_types` ( Link Here
45
  `auth_tag_to_report` varchar(3) NOT NULL default '',
45
  `auth_tag_to_report` varchar(3) NOT NULL default '',
46
  `summary` mediumtext NOT NULL,
46
  `summary` mediumtext NOT NULL,
47
  PRIMARY KEY  (`authtypecode`)
47
  PRIMARY KEY  (`authtypecode`)
48
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
48
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
49
49
50
--
50
--
51
-- Table structure for table `auth_subfield_structure`
51
-- Table structure for table `auth_subfield_structure`
Lines 73-79 CREATE TABLE `auth_subfield_structure` ( Link Here
73
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
73
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
74
  KEY `tab` (`authtypecode`,`tab`),
74
  KEY `tab` (`authtypecode`,`tab`),
75
  CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
75
  CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
76
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
76
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
77
77
78
--
78
--
79
-- Table structure for table `auth_tag_structure`
79
-- Table structure for table `auth_tag_structure`
Lines 90-96 CREATE TABLE `auth_tag_structure` ( Link Here
90
  `authorised_value` varchar(10) default NULL,
90
  `authorised_value` varchar(10) default NULL,
91
  PRIMARY KEY  (`authtypecode`,`tagfield`),
91
  PRIMARY KEY  (`authtypecode`,`tagfield`),
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
94
94
95
95
96
--
96
--
Lines 99-107 CREATE TABLE `auth_tag_structure` ( Link Here
99
99
100
DROP TABLE IF EXISTS `authorised_value_categories`;
100
DROP TABLE IF EXISTS `authorised_value_categories`;
101
CREATE TABLE `authorised_value_categories` (
101
CREATE TABLE `authorised_value_categories` (
102
  `category_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
102
  `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
103
  PRIMARY KEY (`category_name`)
103
  PRIMARY KEY (`category_name`)
104
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
104
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
105
105
106
--
106
--
107
-- Table structure for table `authorised_values`
107
-- Table structure for table `authorised_values`
Lines 117-126 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
117
  `imageurl` varchar(200) default NULL, -- authorized value URL
117
  `imageurl` varchar(200) default NULL, -- authorized value URL
118
  PRIMARY KEY  (`id`),
118
  PRIMARY KEY  (`id`),
119
  KEY `name` (`category`),
119
  KEY `name` (`category`),
120
  KEY `lib` (`lib`),
120
  KEY `lib` (`lib` (191)),
121
  KEY `auth_value_idx` (`authorised_value`),
121
  KEY `auth_value_idx` (`authorised_value`),
122
  CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE
122
  CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE
123
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
124
124
125
--
125
--
126
-- Table structure for table `biblio`
126
-- Table structure for table `biblio`
Lines 142-148 CREATE TABLE `biblio` ( -- table that stores bibliographic information Link Here
142
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
142
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
143
  PRIMARY KEY  (`biblionumber`),
143
  PRIMARY KEY  (`biblionumber`),
144
  KEY `blbnoidx` (`biblionumber`)
144
  KEY `blbnoidx` (`biblionumber`)
145
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
145
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
146
146
147
--
147
--
148
-- Table structure for table `biblio_framework`
148
-- Table structure for table `biblio_framework`
Lines 153-159 CREATE TABLE `biblio_framework` ( -- information about MARC frameworks Link Here
153
  `frameworkcode` varchar(4) NOT NULL default '', -- the unique code assigned to the framework
153
  `frameworkcode` varchar(4) NOT NULL default '', -- the unique code assigned to the framework
154
  `frameworktext` varchar(255) NOT NULL default '', -- the description/name given to the framework
154
  `frameworktext` varchar(255) NOT NULL default '', -- the description/name given to the framework
155
  PRIMARY KEY  (`frameworkcode`)
155
  PRIMARY KEY  (`frameworkcode`)
156
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
156
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
157
157
158
--
158
--
159
-- Table structure for table `biblioitems`
159
-- Table structure for table `biblioitems`
Lines 200-209 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
200
  KEY `isbn` (`isbn`(255)),
200
  KEY `isbn` (`isbn`(255)),
201
  KEY `issn` (`issn`(255)),
201
  KEY `issn` (`issn`(255)),
202
  KEY `ean` (`ean`(255)),
202
  KEY `ean` (`ean`(255)),
203
  KEY `publishercode` (`publishercode`),
203
  KEY `publishercode` (`publishercode` (191)),
204
  KEY `timestamp` (`timestamp`),
204
  KEY `timestamp` (`timestamp`),
205
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
205
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
206
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
206
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
207
207
208
--
208
--
209
-- Table structure for table `borrower_attribute_types`
209
-- Table structure for table `borrower_attribute_types`
Lines 224-230 CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field Link Here
224
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
224
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
225
  PRIMARY KEY  (`code`),
225
  PRIMARY KEY  (`code`),
226
  KEY `auth_val_cat_idx` (`authorised_value_category`)
226
  KEY `auth_val_cat_idx` (`authorised_value_category`)
227
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
227
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
228
228
229
--
229
--
230
-- Table structure for table `borrower_password_recovery`
230
-- Table structure for table `borrower_password_recovery`
Lines 237-243 CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a Link Here
237
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- a time limit on the password recovery attempt
237
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- a time limit on the password recovery attempt
238
  PRIMARY KEY (`borrowernumber`),
238
  PRIMARY KEY (`borrowernumber`),
239
  KEY borrowernumber (borrowernumber)
239
  KEY borrowernumber (borrowernumber)
240
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
240
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
241
241
242
--
242
--
243
-- Table structure for table `branches`
243
-- Table structure for table `branches`
Lines 268-274 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
268
  `geolocation` VARCHAR(255) default NULL, -- geolocation of your library
268
  `geolocation` VARCHAR(255) default NULL, -- geolocation of your library
269
  `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
269
  `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
270
  PRIMARY KEY (`branchcode`)
270
  PRIMARY KEY (`branchcode`)
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
272
272
273
--
273
--
274
-- Table structure for table `browser`
274
-- Table structure for table `browser`
Lines 280-286 CREATE TABLE `browser` ( Link Here
280
  `description` varchar(255) NOT NULL,
280
  `description` varchar(255) NOT NULL,
281
  `number` bigint(20) NOT NULL,
281
  `number` bigint(20) NOT NULL,
282
  `endnode` tinyint(4) NOT NULL
282
  `endnode` tinyint(4) NOT NULL
283
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
283
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
284
284
285
--
285
--
286
-- Table structure for table `categories`
286
-- Table structure for table `categories`
Lines 307-313 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here
307
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.
307
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.
308
  PRIMARY KEY  (`categorycode`),
308
  PRIMARY KEY  (`categorycode`),
309
  UNIQUE KEY `categorycode` (`categorycode`)
309
  UNIQUE KEY `categorycode` (`categorycode`)
310
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
310
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
311
311
312
--
312
--
313
-- Table: collections
313
-- Table: collections
Lines 319-325 CREATE TABLE collections ( Link Here
319
  colDesc text NOT NULL,
319
  colDesc text NOT NULL,
320
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
320
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
321
  PRIMARY KEY (colId)
321
  PRIMARY KEY (colId)
322
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
322
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
323
323
324
--
324
--
325
-- Constraints for table `collections`
325
-- Constraints for table `collections`
Lines 337-343 CREATE TABLE collections_tracking ( Link Here
337
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
337
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
338
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
338
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
339
  PRIMARY KEY (collections_tracking_id)
339
  PRIMARY KEY (collections_tracking_id)
340
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
340
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
341
341
342
--
342
--
343
-- Table structure for table `branch_borrower_circ_rules`
343
-- Table structure for table `branch_borrower_circ_rules`
Lines 354-360 CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rule Link Here
354
    ON DELETE CASCADE ON UPDATE CASCADE,
354
    ON DELETE CASCADE ON UPDATE CASCADE,
355
  CONSTRAINT `branch_borrower_circ_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
355
  CONSTRAINT `branch_borrower_circ_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
356
    ON DELETE CASCADE ON UPDATE CASCADE
356
    ON DELETE CASCADE ON UPDATE CASCADE
357
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
357
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
358
358
359
--
359
--
360
-- Table structure for table `default_borrower_circ_rules`
360
-- Table structure for table `default_borrower_circ_rules`
Lines 368-374 CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found und Link Here
368
  PRIMARY KEY (`categorycode`),
368
  PRIMARY KEY (`categorycode`),
369
  CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
369
  CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
370
    ON DELETE CASCADE ON UPDATE CASCADE
370
    ON DELETE CASCADE ON UPDATE CASCADE
371
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
371
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
372
372
373
--
373
--
374
-- Table structure for table `default_branch_circ_rules`
374
-- Table structure for table `default_branch_circ_rules`
Lines 385-391 CREATE TABLE `default_branch_circ_rules` ( Link Here
385
  PRIMARY KEY (`branchcode`),
385
  PRIMARY KEY (`branchcode`),
386
  CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
386
  CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
387
    ON DELETE CASCADE ON UPDATE CASCADE
387
    ON DELETE CASCADE ON UPDATE CASCADE
388
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
388
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
389
389
390
--
390
--
391
-- Table structure for table `default_circ_rules`
391
-- Table structure for table `default_circ_rules`
Lines 400-406 CREATE TABLE `default_circ_rules` ( Link Here
400
    hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
400
    hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
401
    `returnbranch` varchar(15) default NULL,
401
    `returnbranch` varchar(15) default NULL,
402
    PRIMARY KEY (`singleton`)
402
    PRIMARY KEY (`singleton`)
403
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
403
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
404
404
405
--
405
--
406
-- Table structure for table `cities`
406
-- Table structure for table `cities`
Lines 414-420 CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo Link Here
414
  `city_country` VARCHAR( 100 ) NULL DEFAULT NULL, -- name of the country
414
  `city_country` VARCHAR( 100 ) NULL DEFAULT NULL, -- name of the country
415
  `city_zipcode` varchar(20) default NULL, -- zip or postal code
415
  `city_zipcode` varchar(20) default NULL, -- zip or postal code
416
  PRIMARY KEY  (`cityid`)
416
  PRIMARY KEY  (`cityid`)
417
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
417
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
418
418
419
--
419
--
420
-- Table structure for table `class_sort_rules`
420
-- Table structure for table `class_sort_rules`
Lines 427-433 CREATE TABLE `class_sort_rules` ( Link Here
427
  `sort_routine` varchar(30) NOT NULL default '',
427
  `sort_routine` varchar(30) NOT NULL default '',
428
  PRIMARY KEY (`class_sort_rule`),
428
  PRIMARY KEY (`class_sort_rule`),
429
  UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
429
  UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
430
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
430
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
431
431
432
--
432
--
433
-- Table structure for table `class_sources`
433
-- Table structure for table `class_sources`
Lines 443-449 CREATE TABLE `class_sources` ( Link Here
443
  UNIQUE KEY `cn_source_idx` (`cn_source`),
443
  UNIQUE KEY `cn_source_idx` (`cn_source`),
444
  KEY `used_idx` (`used`),
444
  KEY `used_idx` (`used`),
445
  CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
445
  CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
446
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
446
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
447
447
448
--
448
--
449
-- Table structure for table `currency`
449
-- Table structure for table `currency`
Lines 459-465 CREATE TABLE `currency` ( Link Here
459
  `active` tinyint(1) default NULL,
459
  `active` tinyint(1) default NULL,
460
  `archived` tinyint(1) DEFAULT 0,
460
  `archived` tinyint(1) DEFAULT 0,
461
  PRIMARY KEY  (`currency`)
461
  PRIMARY KEY  (`currency`)
462
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
462
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
463
463
464
--
464
--
465
-- Table structure for table `deletedbiblio`
465
-- Table structure for table `deletedbiblio`
Lines 481-487 CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records Link Here
481
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
481
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
482
  PRIMARY KEY  (`biblionumber`),
482
  PRIMARY KEY  (`biblionumber`),
483
  KEY `blbnoidx` (`biblionumber`)
483
  KEY `blbnoidx` (`biblionumber`)
484
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
484
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
485
485
486
--
486
--
487
-- Table structure for table `deletedbiblioitems`
487
-- Table structure for table `deletedbiblioitems`
Lines 527-535 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
527
  KEY `itemtype_idx` (`itemtype`),
527
  KEY `itemtype_idx` (`itemtype`),
528
  KEY `isbn` (`isbn`(255)),
528
  KEY `isbn` (`isbn`(255)),
529
  KEY `ean` (`ean`(255)),
529
  KEY `ean` (`ean`(255)),
530
  KEY `publishercode` (`publishercode`),
530
  KEY `publishercode` (`publishercode` (191)),
531
  KEY `timestamp` (`timestamp`)
531
  KEY `timestamp` (`timestamp`)
532
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
532
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
533
533
534
--
534
--
535
-- Table structure for table `deletedborrowers`
535
-- Table structure for table `deletedborrowers`
Lines 614-620 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
614
  KEY borrowernumber (borrowernumber),
614
  KEY borrowernumber (borrowernumber),
615
  KEY `cardnumber` (`cardnumber`),
615
  KEY `cardnumber` (`cardnumber`),
616
  KEY `sms_provider_id` (`sms_provider_id`)
616
  KEY `sms_provider_id` (`sms_provider_id`)
617
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
617
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
618
618
619
--
619
--
620
-- Table structure for table `deleteditems`
620
-- Table structure for table `deleteditems`
Lines 675-681 CREATE TABLE `deleteditems` ( Link Here
675
  KEY `delholdingbranch` (`holdingbranch`),
675
  KEY `delholdingbranch` (`holdingbranch`),
676
  KEY `itype_idx` (`itype`),
676
  KEY `itype_idx` (`itype`),
677
  KEY `timestamp` (`timestamp`)
677
  KEY `timestamp` (`timestamp`)
678
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
678
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
679
679
680
--
680
--
681
-- Table structure for table `export_format`
681
-- Table structure for table `export_format`
Lines 694-700 CREATE TABLE `export_format` ( Link Here
694
  `type` varchar(255) DEFAULT 'marc',
694
  `type` varchar(255) DEFAULT 'marc',
695
  `used_for` varchar(255) DEFAULT 'export_records',
695
  `used_for` varchar(255) DEFAULT 'export_records',
696
  PRIMARY KEY  (`export_format_id`)
696
  PRIMARY KEY  (`export_format_id`)
697
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export';
697
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
698
698
699
--
699
--
700
-- Table structure for table `import_batches`
700
-- Table structure for table `import_batches`
Lines 719-725 CREATE TABLE `import_batches` ( -- information about batches of marc records tha Link Here
719
  `comments` mediumtext, -- any comments added when the file was uploaded
719
  `comments` mediumtext, -- any comments added when the file was uploaded
720
  PRIMARY KEY (`import_batch_id`),
720
  PRIMARY KEY (`import_batch_id`),
721
  KEY `branchcode` (`branchcode`)
721
  KEY `branchcode` (`branchcode`)
722
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
722
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
723
723
724
--
724
--
725
-- Table structure for table `import_records`
725
-- Table structure for table `import_records`
Lines 748-754 CREATE TABLE `import_records` ( Link Here
748
  KEY `branchcode` (`branchcode`),
748
  KEY `branchcode` (`branchcode`),
749
  KEY `batch_sequence` (`import_batch_id`, `record_sequence`),
749
  KEY `batch_sequence` (`import_batch_id`, `record_sequence`),
750
  KEY `batch_id_record_type` (`import_batch_id`,`record_type`)
750
  KEY `batch_id_record_type` (`import_batch_id`,`record_type`)
751
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
751
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
752
752
753
--
753
--
754
-- Table structure for `import_record_matches`
754
-- Table structure for `import_record_matches`
Lines 761-767 CREATE TABLE `import_record_matches` ( -- matches found when importing a batch o Link Here
761
  CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
761
  CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
762
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
762
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
763
  KEY `record_score` (`import_record_id`, `score`)
763
  KEY `record_score` (`import_record_id`, `score`)
764
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
764
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
765
765
766
--
766
--
767
-- Table structure for table `import_auths`
767
-- Table structure for table `import_auths`
Lines 777-783 CREATE TABLE `import_auths` ( Link Here
777
  CONSTRAINT `import_auths_ibfk_1` FOREIGN KEY (`import_record_id`)
777
  CONSTRAINT `import_auths_ibfk_1` FOREIGN KEY (`import_record_id`)
778
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
778
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
779
  KEY `matched_authid` (`matched_authid`)
779
  KEY `matched_authid` (`matched_authid`)
780
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
780
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
781
781
782
--
782
--
783
-- Table structure for table `import_biblios`
783
-- Table structure for table `import_biblios`
Lines 799-805 CREATE TABLE `import_biblios` ( Link Here
799
  KEY `matched_biblionumber` (`matched_biblionumber`),
799
  KEY `matched_biblionumber` (`matched_biblionumber`),
800
  KEY `title` (`title`),
800
  KEY `title` (`title`),
801
  KEY `isbn` (`isbn`)
801
  KEY `isbn` (`isbn`)
802
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
802
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
803
803
804
--
804
--
805
-- Table structure for table `import_items`
805
-- Table structure for table `import_items`
Lines 819-825 CREATE TABLE `import_items` ( Link Here
819
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
819
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
820
  KEY `itemnumber` (`itemnumber`),
820
  KEY `itemnumber` (`itemnumber`),
821
  KEY `branchcode` (`branchcode`)
821
  KEY `branchcode` (`branchcode`)
822
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
822
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
823
823
824
--
824
--
825
-- Table structure for table `issuingrules`
825
-- Table structure for table `issuingrules`
Lines 863-869 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
863
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
863
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
864
  KEY `categorycode` (`categorycode`),
864
  KEY `categorycode` (`categorycode`),
865
  KEY `itemtype` (`itemtype`)
865
  KEY `itemtype` (`itemtype`)
866
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
866
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
867
867
868
--
868
--
869
-- Table structure for table `refund_lost_item_fee_rules`
869
-- Table structure for table `refund_lost_item_fee_rules`
Lines 874-880 CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale Link Here
874
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
874
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
875
  `refund` tinyint(1) NOT NULL default 0, -- control wether to refund lost item fees on return
875
  `refund` tinyint(1) NOT NULL default 0, -- control wether to refund lost item fees on return
876
  PRIMARY KEY  (`branchcode`)
876
  PRIMARY KEY  (`branchcode`)
877
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
877
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
878
878
879
--
879
--
880
-- Table structure for table `items`
880
-- Table structure for table `items`
Lines 933-939 CREATE TABLE `items` ( -- holdings/item information Link Here
933
  KEY `itembibnoidx` (`biblionumber`),
933
  KEY `itembibnoidx` (`biblionumber`),
934
  KEY `homebranch` (`homebranch`),
934
  KEY `homebranch` (`homebranch`),
935
  KEY `holdingbranch` (`holdingbranch`),
935
  KEY `holdingbranch` (`holdingbranch`),
936
  KEY `itemcallnumber` (`itemcallnumber`),
936
  KEY `itemcallnumber` (`itemcallnumber` (191)),
937
  KEY `items_location` (`location`),
937
  KEY `items_location` (`location`),
938
  KEY `items_ccode` (`ccode`),
938
  KEY `items_ccode` (`ccode`),
939
  KEY `itype_idx` (`itype`),
939
  KEY `itype_idx` (`itype`),
Lines 942-948 CREATE TABLE `items` ( -- holdings/item information Link Here
942
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
942
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
943
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
943
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
944
  CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
944
  CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
945
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
945
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
946
946
947
--
947
--
948
-- Table structure for table `itemtypes`
948
-- Table structure for table `itemtypes`
Lines 965-971 CREATE TABLE `itemtypes` ( -- defines the item types Link Here
965
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
965
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
966
  PRIMARY KEY  (`itemtype`),
966
  PRIMARY KEY  (`itemtype`),
967
  UNIQUE KEY `itemtype` (`itemtype`)
967
  UNIQUE KEY `itemtype` (`itemtype`)
968
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
968
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
969
969
970
--
970
--
971
-- Table structure for table `default_branch_item_rules`
971
-- Table structure for table `default_branch_item_rules`
Lines 980-986 CREATE TABLE `default_branch_item_rules` ( Link Here
980
  PRIMARY KEY  (`itemtype`),
980
  PRIMARY KEY  (`itemtype`),
981
  CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
981
  CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
982
    ON DELETE CASCADE ON UPDATE CASCADE
982
    ON DELETE CASCADE ON UPDATE CASCADE
983
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
983
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
984
984
985
--
985
--
986
-- Table structure for table `branchtransfers`
986
-- Table structure for table `branchtransfers`
Lines 1002-1008 CREATE TABLE `branchtransfers` ( -- information for items that are in transit be Link Here
1002
  CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1002
  CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1003
  CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1003
  CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1004
  CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1004
  CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1005
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1005
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1006
1006
1007
--
1007
--
1008
-- Table structure for table `branch_item_rules`
1008
-- Table structure for table `branch_item_rules`
Lines 1021-1027 CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and Link Here
1021
    ON DELETE CASCADE ON UPDATE CASCADE,
1021
    ON DELETE CASCADE ON UPDATE CASCADE,
1022
  CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
1022
  CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
1023
    ON DELETE CASCADE ON UPDATE CASCADE
1023
    ON DELETE CASCADE ON UPDATE CASCADE
1024
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1024
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1025
1025
1026
--
1026
--
1027
-- Table structure for table `creator_images`
1027
-- Table structure for table `creator_images`
Lines 1036-1042 CREATE TABLE `creator_images` ( Link Here
1036
  `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1036
  `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1037
  PRIMARY KEY (`image_id`),
1037
  PRIMARY KEY (`image_id`),
1038
  UNIQUE KEY `image_name_index` (`image_name`)
1038
  UNIQUE KEY `image_name_index` (`image_name`)
1039
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1039
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1040
1040
1041
--
1041
--
1042
-- Table structure for table `creator_layouts`
1042
-- Table structure for table `creator_layouts`
Lines 1053-1068 CREATE TABLE `creator_layouts` ( Link Here
1053
  `layout_name` char(25) NOT NULL DEFAULT 'DEFAULT',
1053
  `layout_name` char(25) NOT NULL DEFAULT 'DEFAULT',
1054
  `guidebox` int(1) DEFAULT '0',
1054
  `guidebox` int(1) DEFAULT '0',
1055
  `oblique_title` int(1) DEFAULT '1',
1055
  `oblique_title` int(1) DEFAULT '1',
1056
  `font` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TR',
1056
  `font` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TR',
1057
  `font_size` int(4) NOT NULL DEFAULT '10',
1057
  `font_size` int(4) NOT NULL DEFAULT '10',
1058
  `units` char(20) NOT NULL DEFAULT 'POINT',
1058
  `units` char(20) NOT NULL DEFAULT 'POINT',
1059
  `callnum_split` int(1) DEFAULT '0',
1059
  `callnum_split` int(1) DEFAULT '0',
1060
  `text_justify` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'L',
1060
  `text_justify` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'L',
1061
  `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
1061
  `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
1062
  `layout_xml` text NOT NULL,
1062
  `layout_xml` text NOT NULL,
1063
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1063
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1064
  PRIMARY KEY (`layout_id`)
1064
  PRIMARY KEY (`layout_id`)
1065
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1065
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1066
1066
1067
--
1067
--
1068
-- Table structure for table `creator_templates`
1068
-- Table structure for table `creator_templates`
Lines 1092-1098 CREATE TABLE `creator_templates` ( Link Here
1092
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1092
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1093
  PRIMARY KEY (`template_id`),
1093
  PRIMARY KEY (`template_id`),
1094
  KEY `template_profile_fk_constraint` (`profile_id`)
1094
  KEY `template_profile_fk_constraint` (`profile_id`)
1095
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1095
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1096
1096
1097
--
1097
--
1098
-- Table structure for table `marc_subfield_structure`
1098
-- Table structure for table `marc_subfield_structure`
Lines 1123-1129 CREATE TABLE `marc_subfield_structure` ( Link Here
1123
  KEY `tab` (`frameworkcode`,`tab`),
1123
  KEY `tab` (`frameworkcode`,`tab`),
1124
  KEY `kohafield` (`frameworkcode`,`kohafield`),
1124
  KEY `kohafield` (`frameworkcode`,`kohafield`),
1125
  CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
1125
  CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
1126
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1126
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1127
1127
1128
--
1128
--
1129
-- Table structure for table `marc_tag_structure`
1129
-- Table structure for table `marc_tag_structure`
Lines 1139-1145 CREATE TABLE `marc_tag_structure` ( Link Here
1139
  `authorised_value` varchar(10) default NULL,
1139
  `authorised_value` varchar(10) default NULL,
1140
  `frameworkcode` varchar(4) NOT NULL default '',
1140
  `frameworkcode` varchar(4) NOT NULL default '',
1141
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1141
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1142
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1142
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1143
1143
1144
--
1144
--
1145
-- Table structure for table `marc_matchers`
1145
-- Table structure for table `marc_matchers`
Lines 1155-1161 CREATE TABLE `marc_matchers` ( Link Here
1155
  PRIMARY KEY (`matcher_id`),
1155
  PRIMARY KEY (`matcher_id`),
1156
  KEY `code` (`code`),
1156
  KEY `code` (`code`),
1157
  KEY `record_type` (`record_type`)
1157
  KEY `record_type` (`record_type`)
1158
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1158
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1159
1159
1160
--
1160
--
1161
-- Table structure for table `matchpoints`
1161
-- Table structure for table `matchpoints`
Lines 1169-1175 CREATE TABLE `matchpoints` ( Link Here
1169
  PRIMARY KEY (`matchpoint_id`),
1169
  PRIMARY KEY (`matchpoint_id`),
1170
  CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1170
  CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1171
  REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
1171
  REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
1172
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1172
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1173
1173
1174
1174
1175
--
1175
--
Lines 1188-1194 CREATE TABLE `matchpoint_components` ( Link Here
1188
  KEY `by_sequence` (`matchpoint_id`, `sequence`),
1188
  KEY `by_sequence` (`matchpoint_id`, `sequence`),
1189
  CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
1189
  CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
1190
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1190
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1191
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1191
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1192
1192
1193
--
1193
--
1194
-- Table structure for table `matcher_component_norms`
1194
-- Table structure for table `matcher_component_norms`
Lines 1201-1207 CREATE TABLE `matchpoint_component_norms` ( Link Here
1201
  KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
1201
  KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
1202
  CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
1202
  CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
1203
  REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
1203
  REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
1204
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1204
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1205
1205
1206
--
1206
--
1207
-- Table structure for table `matcher_matchpoints`
1207
-- Table structure for table `matcher_matchpoints`
Lines 1214-1220 CREATE TABLE `matcher_matchpoints` ( Link Here
1214
  REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1214
  REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1215
  CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
1215
  CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
1216
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1216
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1217
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1217
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1218
1218
1219
--
1219
--
1220
-- Table structure for table `matchchecks`
1220
-- Table structure for table `matchchecks`
Lines 1232-1238 CREATE TABLE `matchchecks` ( Link Here
1232
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1232
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1233
  CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
1233
  CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
1234
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1234
  REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1235
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1235
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1236
1236
1237
--
1237
--
1238
-- Table structure for table `need_merge_authorities`
1238
-- Table structure for table `need_merge_authorities`
Lines 1248-1254 CREATE TABLE `need_merge_authorities` ( -- keeping track of authority records st Link Here
1248
  `done` tinyint DEFAULT 0  -- indication whether merge has been executed (0=not done, 1=done, 2=in progress)
1248
  `done` tinyint DEFAULT 0  -- indication whether merge has been executed (0=not done, 1=done, 2=in progress)
1249
-- Note: authid and authid_new should NOT be FOREIGN keys !
1249
-- Note: authid and authid_new should NOT be FOREIGN keys !
1250
-- authid may have been deleted; authid_new may be zero
1250
-- authid may have been deleted; authid_new may be zero
1251
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1251
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1252
1252
1253
--
1253
--
1254
-- Table structure for table `oai_sets`
1254
-- Table structure for table `oai_sets`
Lines 1260-1266 CREATE TABLE `oai_sets` ( Link Here
1260
  `spec` varchar(80) NOT NULL UNIQUE,
1260
  `spec` varchar(80) NOT NULL UNIQUE,
1261
  `name` varchar(80) NOT NULL,
1261
  `name` varchar(80) NOT NULL,
1262
  PRIMARY KEY (`id`)
1262
  PRIMARY KEY (`id`)
1263
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1263
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1264
1264
1265
--
1265
--
1266
-- Table structure for table `oai_sets_descriptions`
1266
-- Table structure for table `oai_sets_descriptions`
Lines 1271-1277 CREATE TABLE `oai_sets_descriptions` ( Link Here
1271
  `set_id` int(11) NOT NULL,
1271
  `set_id` int(11) NOT NULL,
1272
  `description` varchar(255) NOT NULL,
1272
  `description` varchar(255) NOT NULL,
1273
  CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1273
  CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1274
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1274
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1275
1275
1276
--
1276
--
1277
-- Table structure for table `oai_sets_mappings`
1277
-- Table structure for table `oai_sets_mappings`
Lines 1285-1291 CREATE TABLE `oai_sets_mappings` ( Link Here
1285
  `operator` varchar(8) NOT NULL default 'equal',
1285
  `operator` varchar(8) NOT NULL default 'equal',
1286
  `marcvalue` varchar(80) NOT NULL,
1286
  `marcvalue` varchar(80) NOT NULL,
1287
  CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1287
  CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1288
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1288
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1289
1289
1290
--
1290
--
1291
-- Table structure for table `oai_sets_biblios`
1291
-- Table structure for table `oai_sets_biblios`
Lines 1297-1303 CREATE TABLE `oai_sets_biblios` ( Link Here
1297
  `set_id` int(11) NOT NULL,
1297
  `set_id` int(11) NOT NULL,
1298
  PRIMARY KEY (`biblionumber`, `set_id`),
1298
  PRIMARY KEY (`biblionumber`, `set_id`),
1299
  CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1299
  CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1300
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1300
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1301
1301
1302
--
1302
--
1303
-- Table structure for table `overduerules`
1303
-- Table structure for table `overduerules`
Lines 1319-1325 CREATE TABLE `overduerules` ( -- overdue notice status and triggers Link Here
1319
  `debarred3` int(1) default 0, -- is the patron restricted when the third notice is sent (1 for yes, 0 for no)
1319
  `debarred3` int(1) default 0, -- is the patron restricted when the third notice is sent (1 for yes, 0 for no)
1320
  PRIMARY KEY  (`overduerules_id`),
1320
  PRIMARY KEY  (`overduerules_id`),
1321
  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
1321
  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
1322
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1322
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1323
1323
1324
-- Table structure for table `pending_offline_operations`
1324
-- Table structure for table `pending_offline_operations`
1325
--
1325
--
Lines 1337-1343 CREATE TABLE pending_offline_operations ( Link Here
1337
  cardnumber varchar(32) DEFAULT NULL,
1337
  cardnumber varchar(32) DEFAULT NULL,
1338
  amount decimal(28,6) DEFAULT NULL,
1338
  amount decimal(28,6) DEFAULT NULL,
1339
  PRIMARY KEY (operationid)
1339
  PRIMARY KEY (operationid)
1340
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1340
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1341
1341
1342
1342
1343
--
1343
--
Lines 1350-1356 CREATE TABLE `printers` ( Link Here
1350
  `printqueue` varchar(20) default NULL,
1350
  `printqueue` varchar(20) default NULL,
1351
  `printtype` varchar(20) default NULL,
1351
  `printtype` varchar(20) default NULL,
1352
  PRIMARY KEY  (`printername`)
1352
  PRIMARY KEY  (`printername`)
1353
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1353
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1354
1354
1355
--
1355
--
1356
-- Table structure for table `printers_profile`
1356
-- Table structure for table `printers_profile`
Lines 1370-1376 CREATE TABLE `printers_profile` ( Link Here
1370
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1370
  `creator` char(15) NOT NULL DEFAULT 'Labels',
1371
  PRIMARY KEY  (`profile_id`),
1371
  PRIMARY KEY  (`profile_id`),
1372
  UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
1372
  UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
1373
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1373
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1374
1374
1375
--
1375
--
1376
-- Table structure for table `repeatable_holidays`
1376
-- Table structure for table `repeatable_holidays`
Lines 1386-1392 CREATE TABLE `repeatable_holidays` ( -- information for the days the library is Link Here
1386
  `title` varchar(50) NOT NULL default '', -- title of this closing
1386
  `title` varchar(50) NOT NULL default '', -- title of this closing
1387
  `description` text NOT NULL, -- description for this closing
1387
  `description` text NOT NULL, -- description for this closing
1388
  PRIMARY KEY  (`id`)
1388
  PRIMARY KEY  (`id`)
1389
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1389
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1390
1390
1391
--
1391
--
1392
-- Table structure for table `reports_dictionary`
1392
-- Table structure for table `reports_dictionary`
Lines 1403-1409 CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for Link Here
1403
   report_area varchar(6) DEFAULT NULL, -- Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)
1403
   report_area varchar(6) DEFAULT NULL, -- Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)
1404
   PRIMARY KEY  (id),
1404
   PRIMARY KEY  (id),
1405
   KEY dictionary_area_idx (report_area)
1405
   KEY dictionary_area_idx (report_area)
1406
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1406
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1407
1407
1408
--
1408
--
1409
-- Table structure for table `saved_sql`
1409
-- Table structure for table `saved_sql`
Lines 1428-1434 CREATE TABLE saved_sql ( -- saved sql reports Link Here
1428
   PRIMARY KEY  (`id`),
1428
   PRIMARY KEY  (`id`),
1429
   KEY sql_area_group_idx (report_group, report_subgroup),
1429
   KEY sql_area_group_idx (report_group, report_subgroup),
1430
   KEY boridx (`borrowernumber`)
1430
   KEY boridx (`borrowernumber`)
1431
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1431
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1432
1432
1433
1433
1434
--
1434
--
Lines 1442-1448 CREATE TABLE saved_reports ( Link Here
1442
   `report` longtext,
1442
   `report` longtext,
1443
   `date_run` datetime default NULL,
1443
   `date_run` datetime default NULL,
1444
   PRIMARY KEY  (`id`)
1444
   PRIMARY KEY  (`id`)
1445
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1445
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1446
1446
1447
--
1447
--
1448
-- Table structure for table 'search_field'
1448
-- Table structure for table 'search_field'
Lines 1455-1462 CREATE TABLE `search_field` ( Link Here
1455
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1455
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1456
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1456
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1457
  PRIMARY KEY (`id`),
1457
  PRIMARY KEY (`id`),
1458
  UNIQUE KEY (`name`)
1458
  UNIQUE KEY (`name` (191) )
1459
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1459
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1460
1460
1461
--
1461
--
1462
-- Table structure for table `search_history`
1462
-- Table structure for table `search_history`
Lines 1475-1481 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1475
  KEY `userid` (`userid`),
1475
  KEY `userid` (`userid`),
1476
  KEY `sessionid` (`sessionid`),
1476
  KEY `sessionid` (`sessionid`),
1477
  PRIMARY KEY  (`id`)
1477
  PRIMARY KEY  (`id`)
1478
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results';
1478
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';
1479
1479
1480
--
1480
--
1481
-- Table structure for table 'search_marc_map'
1481
-- Table structure for table 'search_marc_map'
Lines 1488-1496 CREATE TABLE `search_marc_map` ( Link Here
1488
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1488
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1489
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1489
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1490
  PRIMARY KEY(`id`),
1490
  PRIMARY KEY(`id`),
1491
  UNIQUE key(index_name, marc_field, marc_type),
1491
  UNIQUE key(index_name, marc_field(191), marc_type),
1492
  INDEX (`index_name`)
1492
  INDEX (`index_name`)
1493
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1494
1494
1495
--
1495
--
1496
-- Table structure for table 'search_marc_to_field'
1496
-- Table structure for table 'search_marc_to_field'
Lines 1506-1512 CREATE TABLE `search_marc_to_field` ( Link Here
1506
  PRIMARY KEY(search_marc_map_id, search_field_id),
1506
  PRIMARY KEY(search_marc_map_id, search_field_id),
1507
  FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE,
1507
  FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE,
1508
  FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE
1508
  FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE
1509
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1509
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1510
1510
1511
--
1511
--
1512
-- Table structure for table `serial`
1512
-- Table structure for table `serial`
Lines 1530-1536 CREATE TABLE `serial` ( -- issues related to subscriptions Link Here
1530
  claims_count int(11) default 0, -- number of claims made related to this issue
1530
  claims_count int(11) default 0, -- number of claims made related to this issue
1531
  `routingnotes` text, -- notes from the routing list
1531
  `routingnotes` text, -- notes from the routing list
1532
  PRIMARY KEY  (`serialid`)
1532
  PRIMARY KEY  (`serialid`)
1533
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1533
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1534
1534
1535
--
1535
--
1536
-- Table structure for table `sessions`
1536
-- Table structure for table `sessions`
Lines 1541-1547 CREATE TABLE sessions ( Link Here
1541
  `id` varchar(32) NOT NULL,
1541
  `id` varchar(32) NOT NULL,
1542
  `a_session` mediumtext NOT NULL,
1542
  `a_session` mediumtext NOT NULL,
1543
  PRIMARY KEY (`id`)
1543
  PRIMARY KEY (`id`)
1544
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1544
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1545
1545
1546
--
1546
--
1547
-- Table structure for table `sms_providers`
1547
-- Table structure for table `sms_providers`
Lines 1553-1560 CREATE TABLE `sms_providers` ( Link Here
1553
  `name` varchar(255) NOT NULL,
1553
  `name` varchar(255) NOT NULL,
1554
  `domain` varchar(255) NOT NULL,
1554
  `domain` varchar(255) NOT NULL,
1555
  PRIMARY KEY (`id`),
1555
  PRIMARY KEY (`id`),
1556
  UNIQUE KEY `name` (`name`)
1556
  UNIQUE KEY `name` (`name` (191))
1557
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1557
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1558
1558
1559
--
1559
--
1560
-- Table structure for table `borrowers`
1560
-- Table structure for table `borrowers`
Lines 1642-1655 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1642
  KEY `branchcode` (`branchcode`),
1642
  KEY `branchcode` (`branchcode`),
1643
  UNIQUE KEY `userid` (`userid`),
1643
  UNIQUE KEY `userid` (`userid`),
1644
  KEY `guarantorid` (`guarantorid`),
1644
  KEY `guarantorid` (`guarantorid`),
1645
  KEY `surname_idx` (`surname`(255)),
1645
  KEY `surname_idx` (`surname` (191)),
1646
  KEY `firstname_idx` (`firstname`(255)),
1646
  KEY `firstname_idx` (`firstname` (191)),
1647
  KEY `othernames_idx` (`othernames`(255)),
1647
  KEY `othernames_idx` (`othernames` (191)),
1648
  KEY `sms_provider_id` (`sms_provider_id`),
1648
  KEY `sms_provider_id` (`sms_provider_id`),
1649
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
1649
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
1650
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1650
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1651
  CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON UPDATE CASCADE ON DELETE SET NULL
1651
  CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON UPDATE CASCADE ON DELETE SET NULL
1652
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1652
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1653
1653
1654
--
1654
--
1655
-- Table structure for table `borrower_attributes`
1655
-- Table structure for table `borrower_attributes`
Lines 1662-1673 CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as Link Here
1662
  `code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
1662
  `code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
1663
  `attribute` varchar(255) default NULL, -- custom patron field value
1663
  `attribute` varchar(255) default NULL, -- custom patron field value
1664
  KEY `borrowernumber` (`borrowernumber`),
1664
  KEY `borrowernumber` (`borrowernumber`),
1665
  KEY `code_attribute` (`code`, `attribute`),
1665
  KEY `code_attribute` (`code`, `attribute` (191)),
1666
  CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1666
  CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1667
    ON DELETE CASCADE ON UPDATE CASCADE,
1667
    ON DELETE CASCADE ON UPDATE CASCADE,
1668
  CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`)
1668
  CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`)
1669
    ON DELETE CASCADE ON UPDATE CASCADE
1669
    ON DELETE CASCADE ON UPDATE CASCADE
1670
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1670
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1671
1671
1672
--
1672
--
1673
-- Table structure for table `borrower_debarments`
1673
-- Table structure for table `borrower_debarments`
Lines 1687-1693 CREATE TABLE borrower_debarments ( -- tracks restrictions on the patron's record Link Here
1687
  KEY borrowernumber (borrowernumber),
1687
  KEY borrowernumber (borrowernumber),
1688
  CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1688
  CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1689
    ON DELETE CASCADE ON UPDATE CASCADE
1689
    ON DELETE CASCADE ON UPDATE CASCADE
1690
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1690
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1691
1691
1692
--
1692
--
1693
-- Table structure for table borrower_sync
1693
-- Table structure for table borrower_sync
Lines 1705-1711 CREATE TABLE borrower_sync ( Link Here
1705
  PRIMARY KEY (borrowersyncid),
1705
  PRIMARY KEY (borrowersyncid),
1706
  KEY borrowernumber (borrowernumber),
1706
  KEY borrowernumber (borrowernumber),
1707
  CONSTRAINT borrower_sync_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
1707
  CONSTRAINT borrower_sync_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
1708
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1708
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1709
1709
1710
--
1710
--
1711
-- Table structure for table `issues`
1711
-- Table structure for table `issues`
Lines 1722-1728 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1722
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1722
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1723
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1723
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1724
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1724
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1725
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1725
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1726
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1726
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1727
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1727
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1728
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1728
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
Lines 1736-1742 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1736
  KEY `bordate` (`borrowernumber`,`timestamp`),
1736
  KEY `bordate` (`borrowernumber`,`timestamp`),
1737
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,
1737
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,
1738
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE
1738
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE
1739
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1739
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1740
1740
1741
--
1741
--
1742
-- Table structure for table `old_issues`
1742
-- Table structure for table `old_issues`
Lines 1753-1759 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1753
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1753
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1754
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1754
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1755
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1755
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1756
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1756
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1757
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1757
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1758
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1758
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1759
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1759
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
Lines 1768-1774 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1768
    ON DELETE SET NULL ON UPDATE SET NULL,
1768
    ON DELETE SET NULL ON UPDATE SET NULL,
1769
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1769
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1770
    ON DELETE SET NULL ON UPDATE SET NULL
1770
    ON DELETE SET NULL ON UPDATE SET NULL
1771
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1771
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1772
1772
1773
--
1773
--
1774
-- Table structure for table `items_last_borrower`
1774
-- Table structure for table `items_last_borrower`
Lines 1784-1790 CREATE TABLE IF NOT EXISTS `items_last_borrower` ( Link Here
1784
  KEY `borrowernumber` (`borrowernumber`),
1784
  KEY `borrowernumber` (`borrowernumber`),
1785
  CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1785
  CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1786
  CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1786
  CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1787
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1787
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1788
1788
1789
--
1789
--
1790
-- Table structure for table `creator_batches`
1790
-- Table structure for table `creator_batches`
Lines 1808-1814 CREATE TABLE `creator_batches` ( Link Here
1808
  CONSTRAINT `creator_batches_ibfk_1` FOREIGN KEY (`borrower_number`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1808
  CONSTRAINT `creator_batches_ibfk_1` FOREIGN KEY (`borrower_number`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1809
  CONSTRAINT `creator_batches_ibfk_2` FOREIGN KEY (`branch_code`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE,
1809
  CONSTRAINT `creator_batches_ibfk_2` FOREIGN KEY (`branch_code`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE,
1810
  CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE
1810
  CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE
1811
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1811
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1812
1812
1813
--
1813
--
1814
-- Table structure for table `opac_news`
1814
-- Table structure for table `opac_news`
Lines 1829-1835 CREATE TABLE `opac_news` ( -- data from the news tool Link Here
1829
  CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1829
  CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1830
  CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
1830
  CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
1831
    ON DELETE CASCADE ON UPDATE CASCADE
1831
    ON DELETE CASCADE ON UPDATE CASCADE
1832
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1832
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1833
1833
1834
--
1834
--
1835
-- Table structure for table `patronimage`
1835
-- Table structure for table `patronimage`
Lines 1842-1848 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1842
  `imagefile` mediumblob NOT NULL, -- the image
1842
  `imagefile` mediumblob NOT NULL, -- the image
1843
  PRIMARY KEY  (`borrowernumber`),
1843
  PRIMARY KEY  (`borrowernumber`),
1844
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1844
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1845
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1845
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1846
1846
1847
--
1847
--
1848
-- Table structure for table `reserves`
1848
-- Table structure for table `reserves`
Lines 1881-1887 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1881
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1881
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1882
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1882
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1883
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
1883
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
1884
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1884
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1885
1885
1886
--
1886
--
1887
-- Table structure for table `old_reserves`
1887
-- Table structure for table `old_reserves`
Lines 1922-1928 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1922
    ON DELETE SET NULL ON UPDATE SET NULL,
1922
    ON DELETE SET NULL ON UPDATE SET NULL,
1923
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1923
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1924
    ON DELETE SET NULL ON UPDATE SET NULL
1924
    ON DELETE SET NULL ON UPDATE SET NULL
1925
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1925
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1926
1926
1927
--
1927
--
1928
-- Table structure for table `reviews`
1928
-- Table structure for table `reviews`
Lines 1939-1945 CREATE TABLE `reviews` ( -- patron opac comments Link Here
1939
  PRIMARY KEY  (`reviewid`),
1939
  PRIMARY KEY  (`reviewid`),
1940
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1940
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1941
  CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1941
  CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1942
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1942
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1943
1943
1944
--
1944
--
1945
-- Table structure for table `special_holidays`
1945
-- Table structure for table `special_holidays`
Lines 1956-1962 CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings Link Here
1956
  `title` varchar(50) NOT NULL default '', -- title for this closing
1956
  `title` varchar(50) NOT NULL default '', -- title for this closing
1957
  `description` text NOT NULL, -- description of this closing
1957
  `description` text NOT NULL, -- description of this closing
1958
  PRIMARY KEY  (`id`)
1958
  PRIMARY KEY  (`id`)
1959
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1959
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1960
1960
1961
--
1961
--
1962
-- Table structure for table `statistics`
1962
-- Table structure for table `statistics`
Lines 1987-1993 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1987
  KEY `borrowernumber_idx` (`borrowernumber`),
1987
  KEY `borrowernumber_idx` (`borrowernumber`),
1988
  KEY `associatedborrower_idx` (`associatedborrower`),
1988
  KEY `associatedborrower_idx` (`associatedborrower`),
1989
  KEY `ccode_idx` (`ccode`)
1989
  KEY `ccode_idx` (`ccode`)
1990
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1990
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1991
1991
1992
--
1992
--
1993
-- Table structure for table subscription_frequencies
1993
-- Table structure for table subscription_frequencies
Lines 2002-2008 CREATE TABLE subscription_frequencies ( Link Here
2002
    unitsperissue INTEGER NOT NULL DEFAULT '1',
2002
    unitsperissue INTEGER NOT NULL DEFAULT '1',
2003
    issuesperunit INTEGER NOT NULL DEFAULT '1',
2003
    issuesperunit INTEGER NOT NULL DEFAULT '1',
2004
    PRIMARY KEY (id)
2004
    PRIMARY KEY (id)
2005
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2005
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2006
2006
2007
--
2007
--
2008
-- Table structure for table subscription_numberpatterns
2008
-- Table structure for table subscription_numberpatterns
Lines 2034-2040 CREATE TABLE subscription_numberpatterns ( Link Here
2034
    setto3 INTEGER DEFAULT NULL,
2034
    setto3 INTEGER DEFAULT NULL,
2035
    numbering3 VARCHAR(255) DEFAULT NULL,
2035
    numbering3 VARCHAR(255) DEFAULT NULL,
2036
    PRIMARY KEY (id)
2036
    PRIMARY KEY (id)
2037
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2037
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2038
2038
2039
--
2039
--
2040
-- Table structure for table `subscription`
2040
-- Table structure for table `subscription`
Lines 2087-2093 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
2087
  PRIMARY KEY  (`subscriptionid`),
2087
  PRIMARY KEY  (`subscriptionid`),
2088
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2088
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2089
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2089
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2090
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2090
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2091
2091
2092
--
2092
--
2093
-- Table structure for table `subscriptionhistory`
2093
-- Table structure for table `subscriptionhistory`
Lines 2105-2111 CREATE TABLE `subscriptionhistory` ( Link Here
2105
  `librariannote` varchar(150) NOT NULL default '',
2105
  `librariannote` varchar(150) NOT NULL default '',
2106
  PRIMARY KEY  (`subscriptionid`),
2106
  PRIMARY KEY  (`subscriptionid`),
2107
  KEY `biblionumber` (`biblionumber`)
2107
  KEY `biblionumber` (`biblionumber`)
2108
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2108
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2109
2109
2110
--
2110
--
2111
-- Table structure for table `subscriptionroutinglist`
2111
-- Table structure for table `subscriptionroutinglist`
Lines 2123-2129 CREATE TABLE `subscriptionroutinglist` ( -- information related to the routing l Link Here
2123
    ON DELETE CASCADE ON UPDATE CASCADE,
2123
    ON DELETE CASCADE ON UPDATE CASCADE,
2124
  CONSTRAINT `subscriptionroutinglist_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`)
2124
  CONSTRAINT `subscriptionroutinglist_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`)
2125
    ON DELETE CASCADE ON UPDATE CASCADE
2125
    ON DELETE CASCADE ON UPDATE CASCADE
2126
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2126
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2127
2127
2128
--
2128
--
2129
-- Table structure for table `systempreferences`
2129
-- Table structure for table `systempreferences`
Lines 2137-2143 CREATE TABLE `systempreferences` ( -- global system preferences Link Here
2137
  `explanation` text, -- descriptive text for the system preference
2137
  `explanation` text, -- descriptive text for the system preference
2138
  `type` varchar(20) default NULL, -- type of question this preference asks (multiple choice, plain text, yes or no, etc)
2138
  `type` varchar(20) default NULL, -- type of question this preference asks (multiple choice, plain text, yes or no, etc)
2139
  PRIMARY KEY  (`variable`)
2139
  PRIMARY KEY  (`variable`)
2140
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2140
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2141
2141
2142
--
2142
--
2143
-- Table structure for table `tags`
2143
-- Table structure for table `tags`
Lines 2147-2154 DROP TABLE IF EXISTS `tags`; Link Here
2147
CREATE TABLE `tags` (
2147
CREATE TABLE `tags` (
2148
  `entry` varchar(255) NOT NULL default '',
2148
  `entry` varchar(255) NOT NULL default '',
2149
  `weight` bigint(20) NOT NULL default 0,
2149
  `weight` bigint(20) NOT NULL default 0,
2150
  PRIMARY KEY  (`entry`)
2150
  PRIMARY KEY  (`entry` (191))
2151
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2151
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2152
2152
2153
--
2153
--
2154
-- Table structure for table `tags_all`
2154
-- Table structure for table `tags_all`
Lines 2169-2175 CREATE TABLE `tags_all` ( -- all of the tags Link Here
2169
        REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2169
        REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2170
  CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
2170
  CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
2171
        REFERENCES `biblio`     (`biblionumber`)  ON DELETE CASCADE ON UPDATE CASCADE
2171
        REFERENCES `biblio`     (`biblionumber`)  ON DELETE CASCADE ON UPDATE CASCADE
2172
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2172
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2173
2173
2174
--
2174
--
2175
-- Table structure for table `tags_approval`
2175
-- Table structure for table `tags_approval`
Lines 2177-2183 CREATE TABLE `tags_all` ( -- all of the tags Link Here
2177
2177
2178
DROP TABLE IF EXISTS `tags_approval`;
2178
DROP TABLE IF EXISTS `tags_approval`;
2179
CREATE TABLE `tags_approval` ( -- approved tags
2179
CREATE TABLE `tags_approval` ( -- approved tags
2180
  `term`   varchar(255) NOT NULL, -- the tag
2180
  `term`   varchar(191) NOT NULL, -- the tag
2181
  `approved`     int(1) NOT NULL default '0', -- whether the tag is approved or not (1=yes, 0=pending, -1=rejected)
2181
  `approved`     int(1) NOT NULL default '0', -- whether the tag is approved or not (1=yes, 0=pending, -1=rejected)
2182
  `date_approved` datetime       default NULL, -- the date this tag was approved
2182
  `date_approved` datetime       default NULL, -- the date this tag was approved
2183
  `approved_by` int(11)          default NULL, -- the librarian who approved the tag (borrowers.borrowernumber)
2183
  `approved_by` int(11)          default NULL, -- the librarian who approved the tag (borrowers.borrowernumber)
Lines 2186-2192 CREATE TABLE `tags_approval` ( -- approved tags Link Here
2186
  KEY `tags_approval_borrowers_fk_1` (`approved_by`),
2186
  KEY `tags_approval_borrowers_fk_1` (`approved_by`),
2187
  CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`)
2187
  CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`)
2188
        REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
2188
        REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
2189
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2189
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2190
2190
2191
--
2191
--
2192
-- Table structure for table `tags_index`
2192
-- Table structure for table `tags_index`
Lines 2194-2200 CREATE TABLE `tags_approval` ( -- approved tags Link Here
2194
2194
2195
DROP TABLE IF EXISTS `tags_index`;
2195
DROP TABLE IF EXISTS `tags_index`;
2196
CREATE TABLE `tags_index` ( -- a weighted list of all tags and where they are used
2196
CREATE TABLE `tags_index` ( -- a weighted list of all tags and where they are used
2197
  `term`    varchar(255) NOT NULL, -- the tag
2197
  `term`    varchar(191) NOT NULL, -- the tag
2198
  `biblionumber` int(11) NOT NULL, -- the bib record this tag was used on (biblio.biblionumber)
2198
  `biblionumber` int(11) NOT NULL, -- the bib record this tag was used on (biblio.biblionumber)
2199
  `weight`        int(9) NOT NULL default '1', -- the number of times this term was used on this bib record
2199
  `weight`        int(9) NOT NULL default '1', -- the number of times this term was used on this bib record
2200
  PRIMARY KEY  (`term`,`biblionumber`),
2200
  PRIMARY KEY  (`term`,`biblionumber`),
Lines 2203-2209 CREATE TABLE `tags_index` ( -- a weighted list of all tags and where they are us Link Here
2203
        REFERENCES `tags_approval` (`term`)  ON DELETE CASCADE ON UPDATE CASCADE,
2203
        REFERENCES `tags_approval` (`term`)  ON DELETE CASCADE ON UPDATE CASCADE,
2204
  CONSTRAINT `tags_index_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
2204
  CONSTRAINT `tags_index_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
2205
        REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
2205
        REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
2206
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2206
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2207
2207
2208
--
2208
--
2209
-- Table structure for table `userflags`
2209
-- Table structure for table `userflags`
Lines 2216-2222 CREATE TABLE `userflags` ( Link Here
2216
  `flagdesc` varchar(255) default NULL,
2216
  `flagdesc` varchar(255) default NULL,
2217
  `defaulton` int(11) default NULL,
2217
  `defaulton` int(11) default NULL,
2218
  PRIMARY KEY  (`bit`)
2218
  PRIMARY KEY  (`bit`)
2219
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2219
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2220
2220
2221
--
2221
--
2222
-- Table structure for table `virtualshelves`
2222
-- Table structure for table `virtualshelves`
Lines 2235-2241 CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) Link Here
2235
  `allow_change_from_others` tinyint(1) default 0, -- can others change contents?
2235
  `allow_change_from_others` tinyint(1) default 0, -- can others change contents?
2236
  PRIMARY KEY  (`shelfnumber`),
2236
  PRIMARY KEY  (`shelfnumber`),
2237
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2237
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2238
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2238
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2239
2239
2240
--
2240
--
2241
-- Table structure for table `virtualshelfcontents`
2241
-- Table structure for table `virtualshelfcontents`
Lines 2253-2259 CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list Link Here
2253
  CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2253
  CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2254
  CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2254
  CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2255
  CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2255
  CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2256
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2256
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2257
2257
2258
--
2258
--
2259
-- Table structure for table `virtualshelfshares`
2259
-- Table structure for table `virtualshelfshares`
Lines 2268-2274 CREATE TABLE `virtualshelfshares` ( -- shared private lists Link Here
2268
  `sharedate` datetime,  -- date of invitation or acceptance of invitation
2268
  `sharedate` datetime,  -- date of invitation or acceptance of invitation
2269
  CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2269
  CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2270
  CONSTRAINT `virtualshelfshares_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2270
  CONSTRAINT `virtualshelfshares_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2271
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2272
2272
2273
--
2273
--
2274
-- Table structure for table `z3950servers`
2274
-- Table structure for table `z3950servers`
Lines 2294-2300 CREATE TABLE `z3950servers` ( -- connection information for the Z39.50 targets u Link Here
2294
  `sru_fields` mediumtext default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes
2294
  `sru_fields` mediumtext default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes
2295
  `add_xslt` mediumtext default NULL, -- zero or more paths to XSLT files to be processed on the search results
2295
  `add_xslt` mediumtext default NULL, -- zero or more paths to XSLT files to be processed on the search results
2296
  PRIMARY KEY  (`id`)
2296
  PRIMARY KEY  (`id`)
2297
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2297
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2298
2298
2299
--
2299
--
2300
-- Table structure for table `zebraqueue`
2300
-- Table structure for table `zebraqueue`
Lines 2310-2316 CREATE TABLE `zebraqueue` ( Link Here
2310
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
2310
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
2311
  PRIMARY KEY  (`id`),
2311
  PRIMARY KEY  (`id`),
2312
  KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
2312
  KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
2313
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2313
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2314
2314
2315
--
2315
--
2316
-- Table structure for table `services_throttle`
2316
-- Table structure for table `services_throttle`
Lines 2321-2327 CREATE TABLE `services_throttle` ( Link Here
2321
  `service_type` varchar(10) NOT NULL default '',
2321
  `service_type` varchar(10) NOT NULL default '',
2322
  `service_count` varchar(45) default NULL,
2322
  `service_count` varchar(45) default NULL,
2323
  PRIMARY KEY  (`service_type`)
2323
  PRIMARY KEY  (`service_type`)
2324
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2324
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2325
2325
2326
--
2326
--
2327
-- Table structure for table `language_subtag_registry`
2327
-- Table structure for table `language_subtag_registry`
Lines 2338-2344 CREATE TABLE language_subtag_registry ( Link Here
2338
        id int(11) NOT NULL auto_increment,
2338
        id int(11) NOT NULL auto_increment,
2339
        PRIMARY KEY  (`id`),
2339
        PRIMARY KEY  (`id`),
2340
        KEY `subtag` (`subtag`)
2340
        KEY `subtag` (`subtag`)
2341
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2341
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2342
2342
2343
--
2343
--
2344
-- Table structure for table `language_rfc4646_to_iso639`
2344
-- Table structure for table `language_rfc4646_to_iso639`
Lines 2354-2360 CREATE TABLE language_rfc4646_to_iso639 ( Link Here
2354
        id int(11) NOT NULL auto_increment,
2354
        id int(11) NOT NULL auto_increment,
2355
        PRIMARY KEY  (`id`),
2355
        PRIMARY KEY  (`id`),
2356
        KEY `rfc4646_subtag` (`rfc4646_subtag`)
2356
        KEY `rfc4646_subtag` (`rfc4646_subtag`)
2357
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2357
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2358
2358
2359
--
2359
--
2360
-- Table structure for table `language_descriptions`
2360
-- Table structure for table `language_descriptions`
Lines 2370-2376 CREATE TABLE language_descriptions ( Link Here
2370
        PRIMARY KEY  (`id`),
2370
        PRIMARY KEY  (`id`),
2371
        KEY `lang` (`lang`),
2371
        KEY `lang` (`lang`),
2372
        KEY `subtag_type_lang` (`subtag`, `type`, `lang`)
2372
        KEY `subtag_type_lang` (`subtag`, `type`, `lang`)
2373
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2373
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2374
2374
2375
--
2375
--
2376
-- Table structure for table `language_script_bidi`
2376
-- Table structure for table `language_script_bidi`
Lines 2382-2388 CREATE TABLE language_script_bidi ( Link Here
2382
        rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
2382
        rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
2383
        bidi varchar(3), -- rtl ltr
2383
        bidi varchar(3), -- rtl ltr
2384
        KEY `rfc4646_subtag` (`rfc4646_subtag`)
2384
        KEY `rfc4646_subtag` (`rfc4646_subtag`)
2385
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2385
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2386
2386
2387
--
2387
--
2388
-- Table structure for table `language_script_mapping`
2388
-- Table structure for table `language_script_mapping`
Lines 2395-2401 CREATE TABLE language_script_mapping ( Link Here
2395
        language_subtag varchar(25),
2395
        language_subtag varchar(25),
2396
        script_subtag varchar(25),
2396
        script_subtag varchar(25),
2397
        KEY `language_subtag` (`language_subtag`)
2397
        KEY `language_subtag` (`language_subtag`)
2398
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2398
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2399
2399
2400
--
2400
--
2401
-- Table structure for table `permissions`
2401
-- Table structure for table `permissions`
Lines 2409-2415 CREATE TABLE `permissions` ( Link Here
2409
  PRIMARY KEY  (`module_bit`, `code`),
2409
  PRIMARY KEY  (`module_bit`, `code`),
2410
  CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`)
2410
  CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`)
2411
    ON DELETE CASCADE ON UPDATE CASCADE
2411
    ON DELETE CASCADE ON UPDATE CASCADE
2412
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2412
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2413
2413
2414
--
2414
--
2415
-- Table structure for table `serialitems`
2415
-- Table structure for table `serialitems`
Lines 2423-2429 CREATE TABLE `serialitems` ( Link Here
2423
	KEY `serialitems_sfk_1` (`serialid`),
2423
	KEY `serialitems_sfk_1` (`serialid`),
2424
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2424
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2425
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2425
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2426
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2426
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2427
2427
2428
--
2428
--
2429
-- Table structure for table `user_permissions`
2429
-- Table structure for table `user_permissions`
Lines 2438-2444 CREATE TABLE `user_permissions` ( Link Here
2438
    ON DELETE CASCADE ON UPDATE CASCADE,
2438
    ON DELETE CASCADE ON UPDATE CASCADE,
2439
  CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`)
2439
  CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`)
2440
    ON DELETE CASCADE ON UPDATE CASCADE
2440
    ON DELETE CASCADE ON UPDATE CASCADE
2441
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2441
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2442
2442
2443
--
2443
--
2444
-- Table structure for table `tmp_holdsqueue`
2444
-- Table structure for table `tmp_holdsqueue`
Lines 2461-2467 CREATE TABLE `tmp_holdsqueue` ( Link Here
2461
  `pickbranch` varchar(10) default NULL,
2461
  `pickbranch` varchar(10) default NULL,
2462
  `notes` text,
2462
  `notes` text,
2463
  `item_level_request` tinyint(4) NOT NULL default 0
2463
  `item_level_request` tinyint(4) NOT NULL default 0
2464
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2464
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2465
2465
2466
--
2466
--
2467
-- Table structure for table `message_transport_types`
2467
-- Table structure for table `message_transport_types`
Lines 2471-2477 DROP TABLE IF EXISTS `message_transport_types`; Link Here
2471
CREATE TABLE `message_transport_types` (
2471
CREATE TABLE `message_transport_types` (
2472
  `message_transport_type` varchar(20) NOT NULL,
2472
  `message_transport_type` varchar(20) NOT NULL,
2473
  PRIMARY KEY  (`message_transport_type`)
2473
  PRIMARY KEY  (`message_transport_type`)
2474
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2474
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2475
2475
2476
--
2476
--
2477
-- Table structure for table `message_queue`
2477
-- Table structure for table `message_queue`
Lines 2496-2502 CREATE TABLE `message_queue` ( Link Here
2496
  KEY `message_transport_type` (`message_transport_type`),
2496
  KEY `message_transport_type` (`message_transport_type`),
2497
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2497
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2498
  CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE RESTRICT ON UPDATE CASCADE
2498
  CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE RESTRICT ON UPDATE CASCADE
2499
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2499
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2500
2500
2501
--
2501
--
2502
-- Table structure for table `letter`
2502
-- Table structure for table `letter`
Lines 2516-2522 CREATE TABLE `letter` ( -- table for all notice templates in Koha Link Here
2516
  PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`, `lang`),
2516
  PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`, `lang`),
2517
  CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)
2517
  CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)
2518
  REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2518
  REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2519
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2519
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2520
2520
2521
--
2521
--
2522
-- Table structure for table `overduerules_transport_types`
2522
-- Table structure for table `overduerules_transport_types`
Lines 2531-2537 CREATE TABLE overduerules_transport_types( Link Here
2531
    PRIMARY KEY (id),
2531
    PRIMARY KEY (id),
2532
    CONSTRAINT overduerules_fk FOREIGN KEY (overduerules_id) REFERENCES overduerules (overduerules_id) ON DELETE CASCADE ON UPDATE CASCADE,
2532
    CONSTRAINT overduerules_fk FOREIGN KEY (overduerules_id) REFERENCES overduerules (overduerules_id) ON DELETE CASCADE ON UPDATE CASCADE,
2533
    CONSTRAINT mtt_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types (message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE
2533
    CONSTRAINT mtt_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types (message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE
2534
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2534
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2535
2535
2536
--
2536
--
2537
-- Table structure for table `message_attributes`
2537
-- Table structure for table `message_attributes`
Lines 2544-2550 CREATE TABLE `message_attributes` ( Link Here
2544
  `takes_days` tinyint(1) NOT NULL default '0',
2544
  `takes_days` tinyint(1) NOT NULL default '0',
2545
  PRIMARY KEY  (`message_attribute_id`),
2545
  PRIMARY KEY  (`message_attribute_id`),
2546
  UNIQUE KEY `message_name` (`message_name`)
2546
  UNIQUE KEY `message_name` (`message_name`)
2547
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2547
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2548
2548
2549
--
2549
--
2550
-- Table structure for table `message_transports`
2550
-- Table structure for table `message_transports`
Lines 2563-2569 CREATE TABLE `message_transports` ( Link Here
2563
  KEY `letter_module` (`letter_module`,`letter_code`),
2563
  KEY `letter_module` (`letter_module`,`letter_code`),
2564
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2564
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2565
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2565
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2566
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2566
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2567
2567
2568
--
2568
--
2569
-- Table structure for table `borrower_files`
2569
-- Table structure for table `borrower_files`
Lines 2581-2587 CREATE TABLE IF NOT EXISTS `borrower_files` ( -- files attached to the patron/bo Link Here
2581
  PRIMARY KEY (`file_id`),
2581
  PRIMARY KEY (`file_id`),
2582
  KEY `borrowernumber` (`borrowernumber`),
2582
  KEY `borrowernumber` (`borrowernumber`),
2583
  CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
2583
  CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
2584
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2584
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2585
2585
2586
--
2586
--
2587
-- Table structure for table `borrower_message_preferences`
2587
-- Table structure for table `borrower_message_preferences`
Lines 2602-2608 CREATE TABLE `borrower_message_preferences` ( Link Here
2602
  CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2602
  CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2603
  CONSTRAINT `borrower_message_preferences_ibfk_2` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2603
  CONSTRAINT `borrower_message_preferences_ibfk_2` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2604
  CONSTRAINT `borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
2604
  CONSTRAINT `borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
2605
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2605
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2606
2606
2607
--
2607
--
2608
-- Table structure for table `borrower_message_transport_preferences`
2608
-- Table structure for table `borrower_message_transport_preferences`
Lines 2616-2622 CREATE TABLE `borrower_message_transport_preferences` ( Link Here
2616
  KEY `message_transport_type` (`message_transport_type`),
2616
  KEY `message_transport_type` (`message_transport_type`),
2617
  CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_preferences` (`borrower_message_preference_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2617
  CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_preferences` (`borrower_message_preference_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2618
  CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2618
  CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2619
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2619
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2620
2620
2621
--
2621
--
2622
-- Table structure for the table branch_transfer_limits
2622
-- Table structure for the table branch_transfer_limits
Lines 2630-2636 CREATE TABLE branch_transfer_limits ( Link Here
2630
    itemtype varchar(10) NULL,
2630
    itemtype varchar(10) NULL,
2631
    ccode varchar(10) NULL,
2631
    ccode varchar(10) NULL,
2632
    PRIMARY KEY  (limitId)
2632
    PRIMARY KEY  (limitId)
2633
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2633
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2634
2634
2635
--
2635
--
2636
-- Table structure for table `item_circulation_alert_preferences`
2636
-- Table structure for table `item_circulation_alert_preferences`
Lines 2645-2651 CREATE TABLE `item_circulation_alert_preferences` ( Link Here
2645
  `notification` varchar(16) NOT NULL,
2645
  `notification` varchar(16) NOT NULL,
2646
  PRIMARY KEY  (`id`),
2646
  PRIMARY KEY  (`id`),
2647
  KEY `branchcode` (`branchcode`,`categorycode`,`item_type`, `notification`)
2647
  KEY `branchcode` (`branchcode`,`categorycode`,`item_type`, `notification`)
2648
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2648
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2649
2649
2650
--
2650
--
2651
-- Table structure for table `messages`
2651
-- Table structure for table `messages`
Lines 2661-2667 CREATE TABLE `messages` ( -- circulation messages left via the patron's check ou Link Here
2661
  `manager_id` int(11) default NULL, -- creator of message
2661
  `manager_id` int(11) default NULL, -- creator of message
2662
  PRIMARY KEY (`message_id`),
2662
  PRIMARY KEY (`message_id`),
2663
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL
2663
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL
2664
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2664
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2665
2665
2666
--
2666
--
2667
-- Table structure for table `accountlines`
2667
-- Table structure for table `accountlines`
Lines 2690-2696 CREATE TABLE `accountlines` ( Link Here
2690
  KEY `itemnumber` (`itemnumber`),
2690
  KEY `itemnumber` (`itemnumber`),
2691
  CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2691
  CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2692
  CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2692
  CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2693
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2693
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2694
2694
2695
--
2695
--
2696
-- Table structure for table `account_offset_types`
2696
-- Table structure for table `account_offset_types`
Lines 2700-2706 DROP TABLE IF EXISTS `account_offset_types`; Link Here
2700
CREATE TABLE `account_offset_types` (
2700
CREATE TABLE `account_offset_types` (
2701
  `type` varchar(16) NOT NULL, -- The type of offset this is
2701
  `type` varchar(16) NOT NULL, -- The type of offset this is
2702
  PRIMARY KEY (`type`)
2702
  PRIMARY KEY (`type`)
2703
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2703
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2704
2704
2705
--
2705
--
2706
-- Table structure for table `account_offsets`
2706
-- Table structure for table `account_offsets`
Lines 2718-2724 CREATE TABLE `account_offsets` ( Link Here
2718
  CONSTRAINT `account_offsets_ibfk_p` FOREIGN KEY (`credit_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2718
  CONSTRAINT `account_offsets_ibfk_p` FOREIGN KEY (`credit_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2719
  CONSTRAINT `account_offsets_ibfk_f` FOREIGN KEY (`debit_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2719
  CONSTRAINT `account_offsets_ibfk_f` FOREIGN KEY (`debit_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2720
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
2720
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
2721
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2721
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2722
2722
2723
--
2723
--
2724
-- Table structure for table `action_logs`
2724
-- Table structure for table `action_logs`
Lines 2742-2748 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here
2742
  KEY `object_idx` (`object`),
2742
  KEY `object_idx` (`object`),
2743
  KEY `info_idx` (`info`(255)),
2743
  KEY `info_idx` (`info`(255)),
2744
  KEY `interface` (`interface`)
2744
  KEY `interface` (`interface`)
2745
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2745
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2746
2746
2747
--
2747
--
2748
-- Table structure for table `alert`
2748
-- Table structure for table `alert`
Lines 2757-2763 CREATE TABLE `alert` ( Link Here
2757
  PRIMARY KEY  (`alertid`),
2757
  PRIMARY KEY  (`alertid`),
2758
  KEY `borrowernumber` (`borrowernumber`),
2758
  KEY `borrowernumber` (`borrowernumber`),
2759
  KEY `type` (`type`,`externalid`)
2759
  KEY `type` (`type`,`externalid`)
2760
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2760
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2761
2761
2762
--
2762
--
2763
-- Table structure for table `aqbooksellers`
2763
-- Table structure for table `aqbooksellers`
Lines 2797-2803 CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis Link Here
2797
  KEY `name` (`name`(255)),
2797
  KEY `name` (`name`(255)),
2798
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2798
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2799
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2799
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2800
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2800
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2801
2801
2802
--
2802
--
2803
-- Table structure for table `aqbasketgroups`
2803
-- Table structure for table `aqbasketgroups`
Lines 2816-2822 CREATE TABLE `aqbasketgroups` ( Link Here
2816
  PRIMARY KEY  (`id`),
2816
  PRIMARY KEY  (`id`),
2817
  KEY `booksellerid` (`booksellerid`),
2817
  KEY `booksellerid` (`booksellerid`),
2818
  CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
2818
  CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
2819
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2819
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2820
2820
2821
--
2821
--
2822
-- Table structure for table `aqbudgets`
2822
-- Table structure for table `aqbudgets`
Lines 2845-2851 CREATE TABLE `aqbudgets` ( -- information related to Funds Link Here
2845
  KEY `budget_branchcode` (`budget_branchcode`),
2845
  KEY `budget_branchcode` (`budget_branchcode`),
2846
  KEY `budget_period_id` (`budget_period_id`),
2846
  KEY `budget_period_id` (`budget_period_id`),
2847
  KEY `budget_owner_id` (`budget_owner_id`)
2847
  KEY `budget_owner_id` (`budget_owner_id`)
2848
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2848
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2849
2849
2850
--
2850
--
2851
-- Table structure for table aqbudgetborrowers
2851
-- Table structure for table aqbudgetborrowers
Lines 2862-2868 CREATE TABLE aqbudgetborrowers ( Link Here
2862
  CONSTRAINT aqbudgetborrowers_ibfk_2 FOREIGN KEY (borrowernumber)
2862
  CONSTRAINT aqbudgetborrowers_ibfk_2 FOREIGN KEY (borrowernumber)
2863
    REFERENCES borrowers (borrowernumber)
2863
    REFERENCES borrowers (borrowernumber)
2864
    ON DELETE CASCADE ON UPDATE CASCADE
2864
    ON DELETE CASCADE ON UPDATE CASCADE
2865
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2865
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2866
2866
2867
--
2867
--
2868
-- Table structure for table `aqbudgetperiods`
2868
-- Table structure for table `aqbudgetperiods`
Lines 2881-2887 CREATE TABLE `aqbudgetperiods` ( -- information related to Budgets Link Here
2881
  `sort1_authcat` varchar(10) default NULL, -- statistical category for this budget
2881
  `sort1_authcat` varchar(10) default NULL, -- statistical category for this budget
2882
  `sort2_authcat` varchar(10) default NULL, -- second statistical category for this budget
2882
  `sort2_authcat` varchar(10) default NULL, -- second statistical category for this budget
2883
  PRIMARY KEY  (`budget_period_id`)
2883
  PRIMARY KEY  (`budget_period_id`)
2884
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2884
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2885
2885
2886
--
2886
--
2887
-- Table structure for table `aqbudgets_planning`
2887
-- Table structure for table `aqbudgets_planning`
Lines 2899-2905 CREATE TABLE `aqbudgets_planning` ( Link Here
2899
  PRIMARY KEY  (`plan_id`),
2899
  PRIMARY KEY  (`plan_id`),
2900
  KEY `budget_period_id` (`budget_period_id`),
2900
  KEY `budget_period_id` (`budget_period_id`),
2901
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2901
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2902
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2902
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2903
2903
2904
--
2904
--
2905
-- Table structure for table 'aqcontacts'
2905
-- Table structure for table 'aqcontacts'
Lines 2924-2930 CREATE TABLE aqcontacts ( Link Here
2924
  PRIMARY KEY  (id),
2924
  PRIMARY KEY  (id),
2925
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
2925
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
2926
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
2926
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
2927
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
2927
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
2928
2928
2929
--
2929
--
2930
-- Table structure for table 'aqcontract'
2930
-- Table structure for table 'aqcontract'
Lines 2941-2947 CREATE TABLE `aqcontract` ( Link Here
2941
  PRIMARY KEY  (`contractnumber`),
2941
  PRIMARY KEY  (`contractnumber`),
2942
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2942
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2943
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2943
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2944
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
2944
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
2945
2945
2946
--
2946
--
2947
-- Table structure for table `aqbasket`
2947
-- Table structure for table `aqbasket`
Lines 2974-2980 CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions Link Here
2974
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2974
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2975
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
2975
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
2976
  CONSTRAINT aqbasket_ibfk_4 FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE SET NULL
2976
  CONSTRAINT aqbasket_ibfk_4 FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE SET NULL
2977
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2977
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2978
2978
2979
--
2979
--
2980
-- Table structure for table aqbasketusers
2980
-- Table structure for table aqbasketusers
Lines 2987-2993 CREATE TABLE aqbasketusers ( Link Here
2987
  PRIMARY KEY (basketno,borrowernumber),
2987
  PRIMARY KEY (basketno,borrowernumber),
2988
  CONSTRAINT aqbasketusers_ibfk_1 FOREIGN KEY (basketno) REFERENCES aqbasket (basketno) ON UPDATE CASCADE ON DELETE CASCADE,
2988
  CONSTRAINT aqbasketusers_ibfk_1 FOREIGN KEY (basketno) REFERENCES aqbasket (basketno) ON UPDATE CASCADE ON DELETE CASCADE,
2989
  CONSTRAINT aqbasketusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON UPDATE CASCADE ON DELETE CASCADE
2989
  CONSTRAINT aqbasketusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON UPDATE CASCADE ON DELETE CASCADE
2990
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2990
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2991
2991
2992
--
2992
--
2993
-- Table structure for table `suggestions`
2993
-- Table structure for table `suggestions`
Lines 3033-3039 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
3033
  KEY `biblionumber` (`biblionumber`),
3033
  KEY `biblionumber` (`biblionumber`),
3034
  KEY `branchcode` (`branchcode`),
3034
  KEY `branchcode` (`branchcode`),
3035
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
3035
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
3036
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3036
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3037
3037
3038
--
3038
--
3039
-- Table structure for table vendor_edi_accounts
3039
-- Table structure for table vendor_edi_accounts
Lines 3065-3071 CREATE TABLE IF NOT EXISTS vendor_edi_accounts ( Link Here
3065
  KEY shipmentbudget (shipment_budget),
3065
  KEY shipmentbudget (shipment_budget),
3066
  CONSTRAINT vfk_vendor_id FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ),
3066
  CONSTRAINT vfk_vendor_id FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ),
3067
  CONSTRAINT vfk_shipment_budget FOREIGN KEY ( shipment_budget ) REFERENCES aqbudgets ( budget_id )
3067
  CONSTRAINT vfk_shipment_budget FOREIGN KEY ( shipment_budget ) REFERENCES aqbudgets ( budget_id )
3068
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3068
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3069
3069
3070
--
3070
--
3071
-- Table structure for table edifact_messages
3071
-- Table structure for table edifact_messages
Lines 3090-3096 CREATE TABLE IF NOT EXISTS edifact_messages ( Link Here
3090
  CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
3090
  CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
3091
  CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
3091
  CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
3092
  CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE
3092
  CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE
3093
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3093
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3094
3094
3095
--
3095
--
3096
-- Table structure for table aqinvoices
3096
-- Table structure for table aqinvoices
Lines 3111-3117 CREATE TABLE aqinvoices ( Link Here
3111
  CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,
3111
  CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,
3112
  CONSTRAINT edifact_msg_fk FOREIGN KEY ( message_id ) REFERENCES edifact_messages ( id ) ON DELETE SET NULL,
3112
  CONSTRAINT edifact_msg_fk FOREIGN KEY ( message_id ) REFERENCES edifact_messages ( id ) ON DELETE SET NULL,
3113
  CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
3113
  CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
3114
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3114
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3115
3115
3116
--
3116
--
3117
-- Table structure for table `aqorders`
3117
-- Table structure for table `aqorders`
Lines 3167-3173 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3167
  line_item_id varchar(35) default NULL, -- Supplier's article id for Edifact orderline
3167
  line_item_id varchar(35) default NULL, -- Supplier's article id for Edifact orderline
3168
  suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref
3168
  suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref
3169
  suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI'
3169
  suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI'
3170
  `suppliers_report` text COLLATE utf8_unicode_ci, -- reports received from suppliers
3170
  `suppliers_report` text COLLATE utf8mb4_unicode_ci, -- reports received from suppliers
3171
  PRIMARY KEY  (`ordernumber`),
3171
  PRIMARY KEY  (`ordernumber`),
3172
  KEY `basketno` (`basketno`),
3172
  KEY `basketno` (`basketno`),
3173
  KEY `biblionumber` (`biblionumber`),
3173
  KEY `biblionumber` (`biblionumber`),
Lines 3180-3186 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3180
  CONSTRAINT aqorders_ibfk_3 FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE SET NULL ON UPDATE CASCADE,
3180
  CONSTRAINT aqorders_ibfk_3 FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE SET NULL ON UPDATE CASCADE,
3181
  CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE,
3181
  CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE,
3182
  CONSTRAINT `aqorders_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`currency`) ON DELETE SET NULL ON UPDATE SET NULL
3182
  CONSTRAINT `aqorders_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`currency`) ON DELETE SET NULL ON UPDATE SET NULL
3183
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3183
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3184
3184
3185
--
3185
--
3186
-- Table structure for table `aqorder_users`
3186
-- Table structure for table `aqorder_users`
Lines 3193-3199 CREATE TABLE aqorder_users ( -- Mapping orders to patrons for notification sendi Link Here
3193
    PRIMARY KEY (ordernumber, borrowernumber),
3193
    PRIMARY KEY (ordernumber, borrowernumber),
3194
    CONSTRAINT aqorder_users_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3194
    CONSTRAINT aqorder_users_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3195
    CONSTRAINT aqorder_users_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3195
    CONSTRAINT aqorder_users_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3196
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3196
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3197
3197
3198
--
3198
--
3199
-- Table structure for table `aqorders_items`
3199
-- Table structure for table `aqorders_items`
Lines 3207-3213 CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti Link Here
3207
  PRIMARY KEY  (`itemnumber`),
3207
  PRIMARY KEY  (`itemnumber`),
3208
  KEY `ordernumber` (`ordernumber`),
3208
  KEY `ordernumber` (`ordernumber`),
3209
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE
3209
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE
3210
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3210
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3211
3211
3212
--
3212
--
3213
-- Table structure for table aqorders_transfers
3213
-- Table structure for table aqorders_transfers
Lines 3222-3228 CREATE TABLE aqorders_transfers ( Link Here
3222
  UNIQUE KEY ordernumber_to (ordernumber_to),
3222
  UNIQUE KEY ordernumber_to (ordernumber_to),
3223
  CONSTRAINT aqorders_transfers_ordernumber_from FOREIGN KEY (ordernumber_from) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE,
3223
  CONSTRAINT aqorders_transfers_ordernumber_from FOREIGN KEY (ordernumber_from) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE,
3224
  CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE
3224
  CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE
3225
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3225
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3226
3226
3227
--
3227
--
3228
-- Table structure for table `fieldmapping`
3228
-- Table structure for table `fieldmapping`
Lines 3236-3242 CREATE TABLE `fieldmapping` ( -- koha to keyword mapping Link Here
3236
  `fieldcode` char(3) NOT NULL, -- marc field number to map to this keyword
3236
  `fieldcode` char(3) NOT NULL, -- marc field number to map to this keyword
3237
  `subfieldcode` char(1) NOT NULL, -- marc subfield associated with the fieldcode to map to this keyword
3237
  `subfieldcode` char(1) NOT NULL, -- marc subfield associated with the fieldcode to map to this keyword
3238
  PRIMARY KEY  (`id`)
3238
  PRIMARY KEY  (`id`)
3239
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3239
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3240
3240
3241
--
3241
--
3242
-- Table structure for table `transport_cost`
3242
-- Table structure for table `transport_cost`
Lines 3252-3258 CREATE TABLE transport_cost ( Link Here
3252
      PRIMARY KEY (frombranch, tobranch),
3252
      PRIMARY KEY (frombranch, tobranch),
3253
      CONSTRAINT transport_cost_ibfk_1 FOREIGN KEY (frombranch) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE,
3253
      CONSTRAINT transport_cost_ibfk_1 FOREIGN KEY (frombranch) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE,
3254
      CONSTRAINT transport_cost_ibfk_2 FOREIGN KEY (tobranch) REFERENCES branches (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3254
      CONSTRAINT transport_cost_ibfk_2 FOREIGN KEY (tobranch) REFERENCES branches (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3255
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3255
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3256
3256
3257
--
3257
--
3258
-- Table structure for table `biblioimages`
3258
-- Table structure for table `biblioimages`
Lines 3268-3274 CREATE TABLE `biblioimages` ( -- local cover images Link Here
3268
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
3268
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
3269
 PRIMARY KEY (`imagenumber`),
3269
 PRIMARY KEY (`imagenumber`),
3270
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3270
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3271
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3272
3272
3273
--
3273
--
3274
-- Table structure for table `social_data`
3274
-- Table structure for table `social_data`
Lines 3284-3290 CREATE TABLE IF NOT EXISTS `social_data` ( Link Here
3284
  `score_avg` DECIMAL(5,2),
3284
  `score_avg` DECIMAL(5,2),
3285
  `num_scores` INT,
3285
  `num_scores` INT,
3286
  PRIMARY KEY  (`isbn`)
3286
  PRIMARY KEY  (`isbn`)
3287
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3287
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3288
3288
3289
--
3289
--
3290
-- 'Ratings' table. This tracks the star ratings set by borrowers.
3290
-- 'Ratings' table. This tracks the star ratings set by borrowers.
Lines 3299-3305 CREATE TABLE ratings ( -- information related to the star ratings in the OPAC Link Here
3299
    PRIMARY KEY  (borrowernumber,biblionumber),
3299
    PRIMARY KEY  (borrowernumber,biblionumber),
3300
    CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3300
    CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3301
    CONSTRAINT ratings_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3301
    CONSTRAINT ratings_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3302
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3302
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3303
3303
3304
--
3304
--
3305
-- Table structure for table `quotes`
3305
-- Table structure for table `quotes`
Lines 3312-3318 CREATE TABLE `quotes` ( -- data for the quote of the day feature Link Here
3312
  `text` mediumtext NOT NULL, -- text of the quote
3312
  `text` mediumtext NOT NULL, -- text of the quote
3313
  `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac
3313
  `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac
3314
  PRIMARY KEY (`id`)
3314
  PRIMARY KEY (`id`)
3315
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3315
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3316
3316
3317
--
3317
--
3318
-- Table structure for table categories_branches
3318
-- Table structure for table categories_branches
Lines 3324-3330 CREATE TABLE categories_branches( -- association table between categories and br Link Here
3324
    branchcode VARCHAR(10),
3324
    branchcode VARCHAR(10),
3325
    FOREIGN KEY (categorycode) REFERENCES categories(categorycode) ON DELETE CASCADE,
3325
    FOREIGN KEY (categorycode) REFERENCES categories(categorycode) ON DELETE CASCADE,
3326
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3326
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3327
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3327
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3328
3328
3329
--
3329
--
3330
-- Table structure for table authorised_values_branches
3330
-- Table structure for table authorised_values_branches
Lines 3336-3342 CREATE TABLE authorised_values_branches( -- association table between authorised Link Here
3336
    branchcode VARCHAR(10) NOT NULL,
3336
    branchcode VARCHAR(10) NOT NULL,
3337
    FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
3337
    FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
3338
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3338
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3339
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3339
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3340
3340
3341
3341
3342
--
3342
--
Lines 3349-3355 CREATE TABLE borrower_attribute_types_branches( -- association table between bor Link Here
3349
    b_branchcode VARCHAR(10),
3349
    b_branchcode VARCHAR(10),
3350
    FOREIGN KEY (bat_code) REFERENCES borrower_attribute_types(code) ON DELETE CASCADE,
3350
    FOREIGN KEY (bat_code) REFERENCES borrower_attribute_types(code) ON DELETE CASCADE,
3351
    FOREIGN KEY (b_branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3351
    FOREIGN KEY (b_branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3352
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3352
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3353
3353
3354
--
3354
--
3355
-- Table structure for table `borrower_modifications`
3355
-- Table structure for table `borrower_modifications`
Lines 3425-3434 CREATE TABLE IF NOT EXISTS `borrower_modifications` ( Link Here
3425
  `smsalertnumber` varchar(50) DEFAULT NULL,
3425
  `smsalertnumber` varchar(50) DEFAULT NULL,
3426
  `privacy` int(11) DEFAULT NULL,
3426
  `privacy` int(11) DEFAULT NULL,
3427
  `extended_attributes` text DEFAULT NULL,
3427
  `extended_attributes` text DEFAULT NULL,
3428
  PRIMARY KEY (`verification_token`,`borrowernumber`),
3428
  PRIMARY KEY (`verification_token` (191),`borrowernumber`),
3429
  KEY `verification_token` (`verification_token`),
3429
  KEY `verification_token` (`verification_token` (191)),
3430
  KEY `borrowernumber` (`borrowernumber`)
3430
  KEY `borrowernumber` (`borrowernumber`)
3431
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3431
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3432
3432
3433
--
3433
--
3434
-- Table structure for table uploaded_files
3434
-- Table structure for table uploaded_files
Lines 3447-3453 CREATE TABLE uploaded_files ( Link Here
3447
    public tinyint,
3447
    public tinyint,
3448
    permanent tinyint,
3448
    permanent tinyint,
3449
    PRIMARY KEY (id)
3449
    PRIMARY KEY (id)
3450
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3450
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3451
3451
3452
--
3452
--
3453
-- Table structure for table linktracker
3453
-- Table structure for table linktracker
Lines 3467-3473 CREATE TABLE linktracker ( Link Here
3467
   KEY itemidx (itemnumber),
3467
   KEY itemidx (itemnumber),
3468
   KEY borridx (borrowernumber),
3468
   KEY borridx (borrowernumber),
3469
   KEY dateidx (timeclicked)
3469
   KEY dateidx (timeclicked)
3470
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3470
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3471
3471
3472
--
3472
--
3473
-- Table structure for table 'plugin_data'
3473
-- Table structure for table 'plugin_data'
Lines 3477-3484 CREATE TABLE IF NOT EXISTS plugin_data ( Link Here
3477
  plugin_class varchar(255) NOT NULL,
3477
  plugin_class varchar(255) NOT NULL,
3478
  plugin_key varchar(255) NOT NULL,
3478
  plugin_key varchar(255) NOT NULL,
3479
  plugin_value text,
3479
  plugin_value text,
3480
  PRIMARY KEY (plugin_class,plugin_key)
3480
  PRIMARY KEY ( `plugin_class` (191), `plugin_key` (191) )
3481
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3481
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3482
3482
3483
--
3483
--
3484
-- Table structure for table `patron_lists`
3484
-- Table structure for table `patron_lists`
Lines 3487-3497 CREATE TABLE IF NOT EXISTS plugin_data ( Link Here
3487
DROP TABLE IF EXISTS patron_lists;
3487
DROP TABLE IF EXISTS patron_lists;
3488
CREATE TABLE patron_lists (
3488
CREATE TABLE patron_lists (
3489
  patron_list_id int(11) NOT NULL AUTO_INCREMENT, -- unique identifier
3489
  patron_list_id int(11) NOT NULL AUTO_INCREMENT, -- unique identifier
3490
  name varchar(255) CHARACTER SET utf8 NOT NULL,  -- the list's name
3490
  name varchar(255) CHARACTER SET utf8mb4 NOT NULL,  -- the list's name
3491
  owner int(11) NOT NULL,                         -- borrowernumber of the list creator
3491
  owner int(11) NOT NULL,                         -- borrowernumber of the list creator
3492
  PRIMARY KEY (patron_list_id),
3492
  PRIMARY KEY (patron_list_id),
3493
  KEY owner (owner)
3493
  KEY owner (owner)
3494
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3494
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3495
3495
3496
--
3496
--
3497
-- Constraints for table `patron_lists`
3497
-- Constraints for table `patron_lists`
Lines 3511-3517 CREATE TABLE patron_list_patrons ( Link Here
3511
  PRIMARY KEY (patron_list_patron_id),
3511
  PRIMARY KEY (patron_list_patron_id),
3512
  KEY patron_list_id (patron_list_id),
3512
  KEY patron_list_id (patron_list_id),
3513
  KEY borrowernumber (borrowernumber)
3513
  KEY borrowernumber (borrowernumber)
3514
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3514
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3515
3515
3516
--
3516
--
3517
-- Constraints for table `patron_list_patrons`
3517
-- Constraints for table `patron_list_patrons`
Lines 3528-3534 CREATE TABLE IF NOT EXISTS marc_modification_templates ( Link Here
3528
    template_id int(11) NOT NULL AUTO_INCREMENT,
3528
    template_id int(11) NOT NULL AUTO_INCREMENT,
3529
    name text NOT NULL,
3529
    name text NOT NULL,
3530
    PRIMARY KEY (template_id)
3530
    PRIMARY KEY (template_id)
3531
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3531
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3532
3532
3533
--
3533
--
3534
-- Table structure for table 'marc_modification_template_actions'
3534
-- Table structure for table 'marc_modification_template_actions'
Lines 3557-3563 CREATE TABLE IF NOT EXISTS marc_modification_template_actions ( Link Here
3557
  description text,
3557
  description text,
3558
  PRIMARY KEY (mmta_id),
3558
  PRIMARY KEY (mmta_id),
3559
  CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
3559
  CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
3560
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3560
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3561
3561
3562
--
3562
--
3563
-- Table structure for table `misc_files`
3563
-- Table structure for table `misc_files`
Lines 3575-3581 CREATE TABLE IF NOT EXISTS `misc_files` ( -- miscellaneous files attached to rec Link Here
3575
  PRIMARY KEY (`file_id`),
3575
  PRIMARY KEY (`file_id`),
3576
  KEY `table_tag` (`table_tag`),
3576
  KEY `table_tag` (`table_tag`),
3577
  KEY `record_id` (`record_id`)
3577
  KEY `record_id` (`record_id`)
3578
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3578
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3579
3579
3580
--
3580
--
3581
-- Table structure for table `columns_settings`
3581
-- Table structure for table `columns_settings`
Lines 3588-3595 CREATE TABLE IF NOT EXISTS columns_settings ( Link Here
3588
    columnname varchar(255) NOT NULL,
3588
    columnname varchar(255) NOT NULL,
3589
    cannot_be_toggled int(1) NOT NULL DEFAULT 0,
3589
    cannot_be_toggled int(1) NOT NULL DEFAULT 0,
3590
    is_hidden int(1) NOT NULL DEFAULT 0,
3590
    is_hidden int(1) NOT NULL DEFAULT 0,
3591
    PRIMARY KEY(module, page, tablename, columnname)
3591
    PRIMARY KEY(module (191), page (191), tablename (191), columnname (191))
3592
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3592
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3593
3593
3594
--
3594
--
3595
-- Table structure for table 'items_search_fields'
3595
-- Table structure for table 'items_search_fields'
Lines 3602-3612 CREATE TABLE items_search_fields ( Link Here
3602
  tagfield CHAR(3) NOT NULL,
3602
  tagfield CHAR(3) NOT NULL,
3603
  tagsubfield CHAR(1) NULL DEFAULT NULL,
3603
  tagsubfield CHAR(1) NULL DEFAULT NULL,
3604
  authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
3604
  authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
3605
  PRIMARY KEY(name),
3605
  PRIMARY KEY(name (191)),
3606
  CONSTRAINT items_search_fields_authorised_values_category
3606
  CONSTRAINT items_search_fields_authorised_values_category
3607
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_value_categories (category_name)
3607
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_value_categories (category_name)
3608
    ON DELETE SET NULL ON UPDATE CASCADE
3608
    ON DELETE SET NULL ON UPDATE CASCADE
3609
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3609
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3610
3610
3611
--
3611
--
3612
-- Table structure for table 'discharges'
3612
-- Table structure for table 'discharges'
Lines 3621-3627 CREATE TABLE discharges ( Link Here
3621
  PRIMARY KEY (discharge_id),
3621
  PRIMARY KEY (discharge_id),
3622
  KEY borrower_discharges_ibfk1 (borrower),
3622
  KEY borrower_discharges_ibfk1 (borrower),
3623
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3623
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3624
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3624
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3625
3625
3626
--
3626
--
3627
-- Table structure for table additional_fields
3627
-- Table structure for table additional_fields
Lines 3637-3644 CREATE TABLE `additional_fields` ( Link Here
3637
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3637
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3638
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3638
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3639
  PRIMARY KEY (`id`),
3639
  PRIMARY KEY (`id`),
3640
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
3640
  UNIQUE KEY `fields_uniq` (`tablename` (191),`name` (191))
3641
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3641
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3642
3642
3643
--
3643
--
3644
-- Table structure for table additional_field_values
3644
-- Table structure for table additional_field_values
Lines 3654-3660 CREATE TABLE `additional_field_values` ( Link Here
3654
  PRIMARY KEY (`id`),
3654
  PRIMARY KEY (`id`),
3655
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
3655
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
3656
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3656
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3657
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3657
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3658
3658
3659
--
3659
--
3660
-- Table structure for table 'localization'
3660
-- Table structure for table 'localization'
Lines 3663-3675 CREATE TABLE `additional_field_values` ( Link Here
3663
DROP TABLE IF EXISTS localization;
3663
DROP TABLE IF EXISTS localization;
3664
CREATE TABLE `localization` (
3664
CREATE TABLE `localization` (
3665
      localization_id int(11) NOT NULL AUTO_INCREMENT,
3665
      localization_id int(11) NOT NULL AUTO_INCREMENT,
3666
      entity varchar(16) COLLATE utf8_unicode_ci NOT NULL,
3666
      entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
3667
      code varchar(64) COLLATE utf8_unicode_ci NOT NULL,
3667
      code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
3668
      lang varchar(25) COLLATE utf8_unicode_ci NOT NULL, -- could be a foreign key
3668
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3669
      translation text COLLATE utf8_unicode_ci,
3669
      translation text COLLATE utf8mb4_unicode_ci,
3670
      PRIMARY KEY (localization_id),
3670
      PRIMARY KEY (localization_id),
3671
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3671
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3672
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3672
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3673
3673
3674
--
3674
--
3675
-- Table structure for table 'audio_alerts'
3675
-- Table structure for table 'audio_alerts'
Lines 3683-3689 CREATE TABLE audio_alerts ( Link Here
3683
  sound varchar(255) NOT NULL,
3683
  sound varchar(255) NOT NULL,
3684
  PRIMARY KEY (id),
3684
  PRIMARY KEY (id),
3685
  KEY precedence (precedence)
3685
  KEY precedence (precedence)
3686
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3686
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3687
3687
3688
--
3688
--
3689
-- Table structure for table 'edifact_ean'
3689
-- Table structure for table 'edifact_ean'
Lines 3697-3703 CREATE TABLE IF NOT EXISTS edifact_ean ( Link Here
3697
  ean VARCHAR(15) NOT NULL,
3697
  ean VARCHAR(15) NOT NULL,
3698
  id_code_qualifier VARCHAR(3) NOT NULL DEFAULT '14',
3698
  id_code_qualifier VARCHAR(3) NOT NULL DEFAULT '14',
3699
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3699
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3700
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3700
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3701
3701
3702
--
3702
--
3703
-- Table structure for table `courses`
3703
-- Table structure for table `courses`
Lines 3720-3726 CREATE TABLE `courses` ( Link Here
3720
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', -- determines whether the course is active
3720
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', -- determines whether the course is active
3721
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3721
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3722
   PRIMARY KEY (`course_id`)
3722
   PRIMARY KEY (`course_id`)
3723
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3723
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3724
3724
3725
--
3725
--
3726
-- Table structure for table `course_instructors`
3726
-- Table structure for table `course_instructors`
Lines 3736-3742 CREATE TABLE `course_instructors` ( Link Here
3736
  `borrowernumber` int(11) NOT NULL, -- foreign key to link to borrowers.borrowernumber for instructor information
3736
  `borrowernumber` int(11) NOT NULL, -- foreign key to link to borrowers.borrowernumber for instructor information
3737
  PRIMARY KEY (`course_id`,`borrowernumber`),
3737
  PRIMARY KEY (`course_id`,`borrowernumber`),
3738
  KEY `borrowernumber` (`borrowernumber`)
3738
  KEY `borrowernumber` (`borrowernumber`)
3739
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3739
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3740
3740
3741
--
3741
--
3742
-- Constraints for table `course_instructors`
3742
-- Constraints for table `course_instructors`
Lines 3766-3772 CREATE TABLE `course_items` ( Link Here
3766
   PRIMARY KEY (`ci_id`),
3766
   PRIMARY KEY (`ci_id`),
3767
   UNIQUE KEY `itemnumber` (`itemnumber`),
3767
   UNIQUE KEY `itemnumber` (`itemnumber`),
3768
   KEY `holdingbranch` (`holdingbranch`)
3768
   KEY `holdingbranch` (`holdingbranch`)
3769
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3769
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3770
3770
3771
--
3771
--
3772
-- Constraints for table `course_items`
3772
-- Constraints for table `course_items`
Lines 3793-3799 CREATE TABLE `course_reserves` ( Link Here
3793
   PRIMARY KEY (`cr_id`),
3793
   PRIMARY KEY (`cr_id`),
3794
   UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`),
3794
   UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`),
3795
   KEY `course_id` (`course_id`)
3795
   KEY `course_id` (`course_id`)
3796
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3796
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3797
3797
3798
--
3798
--
3799
-- Constraints for table `course_reserves`
3799
-- Constraints for table `course_reserves`
Lines 3823-3829 CREATE TABLE `hold_fill_targets` ( Link Here
3823
    REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
3823
    REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
3824
  CONSTRAINT `hold_fill_targets_ibfk_4` FOREIGN KEY (`source_branchcode`)
3824
  CONSTRAINT `hold_fill_targets_ibfk_4` FOREIGN KEY (`source_branchcode`)
3825
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3825
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3826
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3826
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3827
3827
3828
--
3828
--
3829
-- Table structure for table `housebound_profile`
3829
-- Table structure for table `housebound_profile`
Lines 3844-3850 CREATE TABLE `housebound_profile` ( Link Here
3844
    FOREIGN KEY (`borrowernumber`)
3844
    FOREIGN KEY (`borrowernumber`)
3845
    REFERENCES `borrowers` (`borrowernumber`)
3845
    REFERENCES `borrowers` (`borrowernumber`)
3846
    ON UPDATE CASCADE ON DELETE CASCADE
3846
    ON UPDATE CASCADE ON DELETE CASCADE
3847
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3847
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3848
3848
3849
--
3849
--
3850
-- Table structure for table `housebound_visit`
3850
-- Table structure for table `housebound_visit`
Lines 3871-3877 CREATE TABLE `housebound_visit` ( Link Here
3871
    FOREIGN KEY (`deliverer_brwnumber`)
3871
    FOREIGN KEY (`deliverer_brwnumber`)
3872
    REFERENCES `borrowers` (`borrowernumber`)
3872
    REFERENCES `borrowers` (`borrowernumber`)
3873
    ON UPDATE CASCADE ON DELETE CASCADE
3873
    ON UPDATE CASCADE ON DELETE CASCADE
3874
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3874
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3875
3875
3876
--
3876
--
3877
-- Table structure for table `housebound_role`
3877
-- Table structure for table `housebound_role`
Lines 3887-3893 CREATE TABLE IF NOT EXISTS `housebound_role` ( Link Here
3887
    FOREIGN KEY (`borrowernumber_id`)
3887
    FOREIGN KEY (`borrowernumber_id`)
3888
    REFERENCES `borrowers` (`borrowernumber`)
3888
    REFERENCES `borrowers` (`borrowernumber`)
3889
    ON UPDATE CASCADE ON DELETE CASCADE
3889
    ON UPDATE CASCADE ON DELETE CASCADE
3890
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3890
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3891
3891
3892
--
3892
--
3893
-- Table structure for table 'article_requests'
3893
-- Table structure for table 'article_requests'
Lines 3899-3905 CREATE TABLE `article_requests` ( Link Here
3899
  `borrowernumber` int(11) NOT NULL,
3899
  `borrowernumber` int(11) NOT NULL,
3900
  `biblionumber` int(11) NOT NULL,
3900
  `biblionumber` int(11) NOT NULL,
3901
  `itemnumber` int(11) DEFAULT NULL,
3901
  `itemnumber` int(11) DEFAULT NULL,
3902
  `branchcode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3902
  `branchcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3903
  `title` text,
3903
  `title` text,
3904
  `author` text,
3904
  `author` text,
3905
  `volume` text,
3905
  `volume` text,
Lines 3921-3927 CREATE TABLE `article_requests` ( Link Here
3921
  CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
3921
  CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
3922
  CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3922
  CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3923
  CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
3923
  CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
3924
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3924
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3925
3925
3926
--
3926
--
3927
-- Table structure for table `biblio_metadata`
3927
-- Table structure for table `biblio_metadata`
Lines 3939-3945 CREATE TABLE biblio_metadata ( Link Here
3939
    UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3939
    UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3940
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
3940
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
3941
    KEY `timestamp` (`timestamp`)
3941
    KEY `timestamp` (`timestamp`)
3942
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3942
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3943
3943
3944
--
3944
--
3945
-- Table structure for table `deletedbiblio_metadata`
3945
-- Table structure for table `deletedbiblio_metadata`
Lines 3957-3963 CREATE TABLE deletedbiblio_metadata ( Link Here
3957
    UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3957
    UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3958
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
3958
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
3959
    KEY `timestamp` (`timestamp`)
3959
    KEY `timestamp` (`timestamp`)
3960
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3960
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3961
3961
3962
--
3962
--
3963
-- Table structure for table 'club_templates'
3963
-- Table structure for table 'club_templates'
Lines 3976-3982 CREATE TABLE IF NOT EXISTS club_templates ( Link Here
3976
  PRIMARY KEY (id),
3976
  PRIMARY KEY (id),
3977
  KEY ct_branchcode (branchcode),
3977
  KEY ct_branchcode (branchcode),
3978
  CONSTRAINT `club_templates_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3978
  CONSTRAINT `club_templates_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3979
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3979
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3980
3980
3981
--
3981
--
3982
-- Table structure for table 'clubs'
3982
-- Table structure for table 'clubs'
Lines 3997-4003 CREATE TABLE IF NOT EXISTS clubs ( Link Here
3997
  KEY branchcode (branchcode),
3997
  KEY branchcode (branchcode),
3998
  CONSTRAINT clubs_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE,
3998
  CONSTRAINT clubs_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE,
3999
  CONSTRAINT clubs_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
3999
  CONSTRAINT clubs_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
4000
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4000
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4001
4001
4002
--
4002
--
4003
-- Table structure for table 'club_enrollments'
4003
-- Table structure for table 'club_enrollments'
Lines 4019-4025 CREATE TABLE IF NOT EXISTS club_enrollments ( Link Here
4019
  CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE,
4019
  CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE,
4020
  CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
4020
  CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
4021
  CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE
4021
  CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE
4022
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4022
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4023
4023
4024
--
4024
--
4025
-- Table structure for table 'club_template_enrollment_fields'
4025
-- Table structure for table 'club_template_enrollment_fields'
Lines 4034-4040 CREATE TABLE IF NOT EXISTS club_template_enrollment_fields ( Link Here
4034
  PRIMARY KEY (id),
4034
  PRIMARY KEY (id),
4035
  KEY club_template_id (club_template_id),
4035
  KEY club_template_id (club_template_id),
4036
  CONSTRAINT club_template_enrollment_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE
4036
  CONSTRAINT club_template_enrollment_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE
4037
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4037
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4038
4038
4039
--
4039
--
4040
-- Table structure for table 'club_enrollment_fields'
4040
-- Table structure for table 'club_enrollment_fields'
Lines 4050-4056 CREATE TABLE IF NOT EXISTS club_enrollment_fields ( Link Here
4050
  KEY club_template_enrollment_field_id (club_template_enrollment_field_id),
4050
  KEY club_template_enrollment_field_id (club_template_enrollment_field_id),
4051
  CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE ON UPDATE CASCADE,
4051
  CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE ON UPDATE CASCADE,
4052
  CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY (club_template_enrollment_field_id) REFERENCES club_template_enrollment_fields (id) ON DELETE CASCADE ON UPDATE CASCADE
4052
  CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY (club_template_enrollment_field_id) REFERENCES club_template_enrollment_fields (id) ON DELETE CASCADE ON UPDATE CASCADE
4053
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4053
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4054
4054
4055
--
4055
--
4056
-- Table structure for table 'club_template_fields'
4056
-- Table structure for table 'club_template_fields'
Lines 4065-4071 CREATE TABLE IF NOT EXISTS club_template_fields ( Link Here
4065
  PRIMARY KEY (id),
4065
  PRIMARY KEY (id),
4066
  KEY club_template_id (club_template_id),
4066
  KEY club_template_id (club_template_id),
4067
  CONSTRAINT club_template_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE
4067
  CONSTRAINT club_template_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE
4068
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4068
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4069
4069
4070
--
4070
--
4071
-- Table structure for table 'club_fields'
4071
-- Table structure for table 'club_fields'
Lines 4081-4087 CREATE TABLE IF NOT EXISTS club_fields ( Link Here
4081
  KEY club_id (club_id),
4081
  KEY club_id (club_id),
4082
  CONSTRAINT club_fields_ibfk_3 FOREIGN KEY (club_template_field_id) REFERENCES club_template_fields (id) ON DELETE CASCADE ON UPDATE CASCADE,
4082
  CONSTRAINT club_fields_ibfk_3 FOREIGN KEY (club_template_field_id) REFERENCES club_template_fields (id) ON DELETE CASCADE ON UPDATE CASCADE,
4083
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4083
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4084
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4084
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4085
4085
4086
--
4086
--
4087
-- Table structure for table `illrequests`
4087
-- Table structure for table `illrequests`
Lines 4114-4120 CREATE TABLE illrequests ( Link Here
4114
      FOREIGN KEY (`branchcode`)
4114
      FOREIGN KEY (`branchcode`)
4115
      REFERENCES `branches` (`branchcode`)
4115
      REFERENCES `branches` (`branchcode`)
4116
      ON UPDATE CASCADE ON DELETE CASCADE
4116
      ON UPDATE CASCADE ON DELETE CASCADE
4117
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4117
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4118
4118
4119
--
4119
--
4120
-- Table structure for table `illrequestattributes`
4120
-- Table structure for table `illrequestattributes`
Lines 4125-4136 CREATE TABLE illrequestattributes ( Link Here
4125
    illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number
4125
    illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number
4126
    type varchar(200) NOT NULL,                 -- API ILL property name
4126
    type varchar(200) NOT NULL,                 -- API ILL property name
4127
    value text NOT NULL,                        -- API ILL property value
4127
    value text NOT NULL,                        -- API ILL property value
4128
    PRIMARY KEY  (`illrequest_id`,`type`),
4128
    PRIMARY KEY  (`illrequest_id`, `type` (191)),
4129
    CONSTRAINT `illrequestattributes_ifk`
4129
    CONSTRAINT `illrequestattributes_ifk`
4130
      FOREIGN KEY (illrequest_id)
4130
      FOREIGN KEY (illrequest_id)
4131
      REFERENCES `illrequests` (`illrequest_id`)
4131
      REFERENCES `illrequests` (`illrequest_id`)
4132
      ON UPDATE CASCADE ON DELETE CASCADE
4132
      ON UPDATE CASCADE ON DELETE CASCADE
4133
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4133
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4134
4134
4135
--
4135
--
4136
-- Table structure for table 'library_groups'
4136
-- Table structure for table 'library_groups'
4137
- 

Return to bug 18336