|
Lines 193-199
CREATE TABLE `action_logs` (
Link Here
|
| 193 |
KEY `object_idx` (`object`), |
193 |
KEY `object_idx` (`object`), |
| 194 |
KEY `info_idx` (`info`(255)), |
194 |
KEY `info_idx` (`info`(255)), |
| 195 |
KEY `interface` (`interface`) |
195 |
KEY `interface` (`interface`) |
| 196 |
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
196 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 197 |
/*!40101 SET character_set_client = @saved_cs_client */; |
197 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 198 |
|
198 |
|
| 199 |
-- |
199 |
-- |
|
Lines 325-331
CREATE TABLE `aqbasket` (
Link Here
|
| 325 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
325 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
| 326 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
326 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
| 327 |
CONSTRAINT `aqbasket_ibfk_4` FOREIGN KEY (`branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
327 |
CONSTRAINT `aqbasket_ibfk_4` FOREIGN KEY (`branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
| 328 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
328 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 329 |
/*!40101 SET character_set_client = @saved_cs_client */; |
329 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 330 |
|
330 |
|
| 331 |
-- |
331 |
-- |
|
Lines 402-408
CREATE TABLE `aqbooksellers` (
Link Here
|
| 402 |
KEY `name` (`name`(255)), |
402 |
KEY `name` (`name`(255)), |
| 403 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
403 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 404 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
404 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
| 405 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
405 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 406 |
/*!40101 SET character_set_client = @saved_cs_client */; |
406 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 407 |
|
407 |
|
| 408 |
-- |
408 |
-- |
|
Lines 440-446
CREATE TABLE `aqbudgetperiods` (
Link Here
|
| 440 |
`sort1_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'statistical category for this budget', |
440 |
`sort1_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'statistical category for this budget', |
| 441 |
`sort2_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'second statistical category for this budget', |
441 |
`sort2_authcat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'second statistical category for this budget', |
| 442 |
PRIMARY KEY (`budget_period_id`) |
442 |
PRIMARY KEY (`budget_period_id`) |
| 443 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
443 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 444 |
/*!40101 SET character_set_client = @saved_cs_client */; |
444 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 445 |
|
445 |
|
| 446 |
-- |
446 |
-- |
|
Lines 473-479
CREATE TABLE `aqbudgets` (
Link Here
|
| 473 |
KEY `budget_period_id` (`budget_period_id`), |
473 |
KEY `budget_period_id` (`budget_period_id`), |
| 474 |
KEY `budget_owner_id` (`budget_owner_id`), |
474 |
KEY `budget_owner_id` (`budget_owner_id`), |
| 475 |
CONSTRAINT `aqbudgetperiods_ibfk_1` FOREIGN KEY (`budget_period_id`) REFERENCES `aqbudgetperiods` (`budget_period_id`) ON DELETE CASCADE ON UPDATE CASCADE |
475 |
CONSTRAINT `aqbudgetperiods_ibfk_1` FOREIGN KEY (`budget_period_id`) REFERENCES `aqbudgetperiods` (`budget_period_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 476 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
476 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 477 |
/*!40101 SET character_set_client = @saved_cs_client */; |
477 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 478 |
|
478 |
|
| 479 |
-- |
479 |
-- |
|
Lines 794-800
CREATE TABLE `audio_alerts` (
Link Here
|
| 794 |
`sound` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, |
794 |
`sound` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, |
| 795 |
PRIMARY KEY (`id`), |
795 |
PRIMARY KEY (`id`), |
| 796 |
KEY `precedence` (`precedence`) |
796 |
KEY `precedence` (`precedence`) |
| 797 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
797 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 798 |
/*!40101 SET character_set_client = @saved_cs_client */; |
798 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 799 |
|
799 |
|
| 800 |
-- |
800 |
-- |
|
Lines 816-822
CREATE TABLE `auth_header` (
Link Here
|
| 816 |
`marcxml` longtext COLLATE utf8mb4_unicode_ci NOT NULL, |
816 |
`marcxml` longtext COLLATE utf8mb4_unicode_ci NOT NULL, |
| 817 |
PRIMARY KEY (`authid`), |
817 |
PRIMARY KEY (`authid`), |
| 818 |
KEY `origincode` (`origincode`) |
818 |
KEY `origincode` (`origincode`) |
| 819 |
) ENGINE=InnoDB AUTO_INCREMENT=1708 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
819 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 820 |
/*!40101 SET character_set_client = @saved_cs_client */; |
820 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 821 |
|
821 |
|
| 822 |
-- |
822 |
-- |
|
Lines 920-926
CREATE TABLE `authorised_values` (
Link Here
|
| 920 |
KEY `lib` (`lib`(191)), |
920 |
KEY `lib` (`lib`(191)), |
| 921 |
KEY `auth_value_idx` (`authorised_value`), |
921 |
KEY `auth_value_idx` (`authorised_value`), |
| 922 |
CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
922 |
CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 923 |
) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
923 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 924 |
/*!40101 SET character_set_client = @saved_cs_client */; |
924 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 925 |
|
925 |
|
| 926 |
-- |
926 |
-- |
|
Lines 988-994
CREATE TABLE `biblio` (
Link Here
|
| 988 |
`abstract` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
988 |
`abstract` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
| 989 |
PRIMARY KEY (`biblionumber`), |
989 |
PRIMARY KEY (`biblionumber`), |
| 990 |
KEY `blbnoidx` (`biblionumber`) |
990 |
KEY `blbnoidx` (`biblionumber`) |
| 991 |
) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
991 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 992 |
/*!40101 SET character_set_client = @saved_cs_client */; |
992 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 993 |
|
993 |
|
| 994 |
-- |
994 |
-- |
|
Lines 1023-1029
CREATE TABLE `biblio_metadata` (
Link Here
|
| 1023 |
UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`), |
1023 |
UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`), |
| 1024 |
KEY `timestamp` (`timestamp`), |
1024 |
KEY `timestamp` (`timestamp`), |
| 1025 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1025 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1026 |
) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1026 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1027 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1027 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1028 |
|
1028 |
|
| 1029 |
-- |
1029 |
-- |
|
Lines 1076-1082
CREATE TABLE `biblioitems` (
Link Here
|
| 1076 |
KEY `publishercode` (`publishercode`(191)), |
1076 |
KEY `publishercode` (`publishercode`(191)), |
| 1077 |
KEY `timestamp` (`timestamp`), |
1077 |
KEY `timestamp` (`timestamp`), |
| 1078 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1078 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1079 |
) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1079 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1080 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1080 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1081 |
|
1081 |
|
| 1082 |
-- |
1082 |
-- |
|
Lines 1442-1448
CREATE TABLE `borrowers` (
Link Here
|
| 1442 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
1442 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
| 1443 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
1443 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
| 1444 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
1444 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
| 1445 |
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1445 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1446 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1446 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1447 |
|
1447 |
|
| 1448 |
-- |
1448 |
-- |
|
Lines 1673-1679
CREATE TABLE `circulation_rules` (
Link Here
|
| 1673 |
CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1673 |
CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1674 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1674 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1675 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
1675 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1676 |
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1676 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1677 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1677 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1678 |
|
1678 |
|
| 1679 |
-- |
1679 |
-- |
|
Lines 2098-2104
CREATE TABLE `courses` (
Link Here
|
| 2098 |
`enabled` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'determines whether the course is active', |
2098 |
`enabled` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes' COMMENT 'determines whether the course is active', |
| 2099 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
2099 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
| 2100 |
PRIMARY KEY (`course_id`) |
2100 |
PRIMARY KEY (`course_id`) |
| 2101 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2101 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2102 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2102 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2103 |
|
2103 |
|
| 2104 |
-- |
2104 |
-- |
|
Lines 2190-2196
CREATE TABLE `creator_layouts` (
Link Here
|
| 2190 |
`layout_xml` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, |
2190 |
`layout_xml` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, |
| 2191 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
2191 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
| 2192 |
PRIMARY KEY (`layout_id`) |
2192 |
PRIMARY KEY (`layout_id`) |
| 2193 |
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2193 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2194 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2194 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2195 |
|
2195 |
|
| 2196 |
-- |
2196 |
-- |
|
Lines 2221-2227
CREATE TABLE `creator_templates` (
Link Here
|
| 2221 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
2221 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
| 2222 |
PRIMARY KEY (`template_id`), |
2222 |
PRIMARY KEY (`template_id`), |
| 2223 |
KEY `template_profile_fk_constraint` (`profile_id`) |
2223 |
KEY `template_profile_fk_constraint` (`profile_id`) |
| 2224 |
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2224 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2225 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2225 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2226 |
|
2226 |
|
| 2227 |
-- |
2227 |
-- |
|
Lines 2604-2610
CREATE TABLE `export_format` (
Link Here
|
| 2604 |
PRIMARY KEY (`export_format_id`), |
2604 |
PRIMARY KEY (`export_format_id`), |
| 2605 |
KEY `used_for_idx` (`used_for`(191)), |
2605 |
KEY `used_for_idx` (`used_for`(191)), |
| 2606 |
KEY `staff_only_idx` (`staff_only`) |
2606 |
KEY `staff_only_idx` (`staff_only`) |
| 2607 |
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export'; |
2607 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export'; |
| 2608 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2608 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2609 |
|
2609 |
|
| 2610 |
-- |
2610 |
-- |
|
Lines 3062-3068
CREATE TABLE `items` (
Link Here
|
| 3062 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
3062 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
| 3063 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
3063 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
| 3064 |
CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
3064 |
CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3065 |
) ENGINE=InnoDB AUTO_INCREMENT=973 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3065 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3066 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3066 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3067 |
|
3067 |
|
| 3068 |
-- |
3068 |
-- |
|
Lines 3184-3190
CREATE TABLE `language_descriptions` (
Link Here
|
| 3184 |
PRIMARY KEY (`id`), |
3184 |
PRIMARY KEY (`id`), |
| 3185 |
KEY `lang` (`lang`), |
3185 |
KEY `lang` (`lang`), |
| 3186 |
KEY `subtag_type_lang` (`subtag`,`type`,`lang`) |
3186 |
KEY `subtag_type_lang` (`subtag`,`type`,`lang`) |
| 3187 |
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3187 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3188 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3188 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3189 |
|
3189 |
|
| 3190 |
-- |
3190 |
-- |
|
Lines 3200-3206
CREATE TABLE `language_rfc4646_to_iso639` (
Link Here
|
| 3200 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3200 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 3201 |
PRIMARY KEY (`id`), |
3201 |
PRIMARY KEY (`id`), |
| 3202 |
KEY `rfc4646_subtag` (`rfc4646_subtag`) |
3202 |
KEY `rfc4646_subtag` (`rfc4646_subtag`) |
| 3203 |
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3203 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3204 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3204 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3205 |
|
3205 |
|
| 3206 |
-- |
3206 |
-- |
|
Lines 3246-3252
CREATE TABLE `language_subtag_registry` (
Link Here
|
| 3246 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3246 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 3247 |
PRIMARY KEY (`id`), |
3247 |
PRIMARY KEY (`id`), |
| 3248 |
KEY `subtag` (`subtag`) |
3248 |
KEY `subtag` (`subtag`) |
| 3249 |
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3249 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3250 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3250 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3251 |
|
3251 |
|
| 3252 |
-- |
3252 |
-- |
|
Lines 3376-3382
CREATE TABLE `marc_matchers` (
Link Here
|
| 3376 |
PRIMARY KEY (`matcher_id`), |
3376 |
PRIMARY KEY (`matcher_id`), |
| 3377 |
KEY `code` (`code`), |
3377 |
KEY `code` (`code`), |
| 3378 |
KEY `record_type` (`record_type`) |
3378 |
KEY `record_type` (`record_type`) |
| 3379 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3379 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3380 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3380 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3381 |
|
3381 |
|
| 3382 |
-- |
3382 |
-- |
|
Lines 3410-3416
CREATE TABLE `marc_modification_template_actions` (
Link Here
|
| 3410 |
PRIMARY KEY (`mmta_id`), |
3410 |
PRIMARY KEY (`mmta_id`), |
| 3411 |
KEY `mmta_ibfk_1` (`template_id`), |
3411 |
KEY `mmta_ibfk_1` (`template_id`), |
| 3412 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3412 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3413 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3413 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3414 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3414 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3415 |
|
3415 |
|
| 3416 |
-- |
3416 |
-- |
|
Lines 3424-3430
CREATE TABLE `marc_modification_templates` (
Link Here
|
| 3424 |
`template_id` int(11) NOT NULL AUTO_INCREMENT, |
3424 |
`template_id` int(11) NOT NULL AUTO_INCREMENT, |
| 3425 |
`name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, |
3425 |
`name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, |
| 3426 |
PRIMARY KEY (`template_id`) |
3426 |
PRIMARY KEY (`template_id`) |
| 3427 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3427 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3428 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3428 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3429 |
|
3429 |
|
| 3430 |
-- |
3430 |
-- |
|
Lines 3558-3564
CREATE TABLE `matchpoint_components` (
Link Here
|
| 3558 |
PRIMARY KEY (`matchpoint_component_id`), |
3558 |
PRIMARY KEY (`matchpoint_component_id`), |
| 3559 |
KEY `by_sequence` (`matchpoint_id`,`sequence`), |
3559 |
KEY `by_sequence` (`matchpoint_id`,`sequence`), |
| 3560 |
CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3560 |
CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3561 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3561 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3562 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3562 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3563 |
|
3563 |
|
| 3564 |
-- |
3564 |
-- |
|
Lines 3576-3582
CREATE TABLE `matchpoints` (
Link Here
|
| 3576 |
PRIMARY KEY (`matchpoint_id`), |
3576 |
PRIMARY KEY (`matchpoint_id`), |
| 3577 |
KEY `matchpoints_ifbk_1` (`matcher_id`), |
3577 |
KEY `matchpoints_ifbk_1` (`matcher_id`), |
| 3578 |
CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3578 |
CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3579 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3579 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3580 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3580 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3581 |
|
3581 |
|
| 3582 |
-- |
3582 |
-- |
|
Lines 3592-3598
CREATE TABLE `message_attributes` (
Link Here
|
| 3592 |
`takes_days` tinyint(1) NOT NULL DEFAULT 0, |
3592 |
`takes_days` tinyint(1) NOT NULL DEFAULT 0, |
| 3593 |
PRIMARY KEY (`message_attribute_id`), |
3593 |
PRIMARY KEY (`message_attribute_id`), |
| 3594 |
UNIQUE KEY `message_name` (`message_name`) |
3594 |
UNIQUE KEY `message_name` (`message_name`) |
| 3595 |
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3595 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3596 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3596 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3597 |
|
3597 |
|
| 3598 |
-- |
3598 |
-- |
|
Lines 3910-3916
CREATE TABLE `opac_news` (
Link Here
|
| 3910 |
KEY `opac_news_branchcode_ibfk` (`branchcode`), |
3910 |
KEY `opac_news_branchcode_ibfk` (`branchcode`), |
| 3911 |
CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3911 |
CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 3912 |
CONSTRAINT `opac_news_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
3912 |
CONSTRAINT `opac_news_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3913 |
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3913 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3914 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3914 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3915 |
|
3915 |
|
| 3916 |
-- |
3916 |
-- |
|
Lines 4115-4121
CREATE TABLE `printers_profile` (
Link Here
|
| 4115 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
4115 |
`creator` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Labels', |
| 4116 |
PRIMARY KEY (`profile_id`), |
4116 |
PRIMARY KEY (`profile_id`), |
| 4117 |
UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`) |
4117 |
UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`) |
| 4118 |
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4118 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4119 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4119 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4120 |
|
4120 |
|
| 4121 |
-- |
4121 |
-- |
|
Lines 4219-4225
CREATE TABLE `quotes` (
Link Here
|
| 4219 |
`text` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'text of the quote', |
4219 |
`text` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'text of the quote', |
| 4220 |
`timestamp` datetime DEFAULT NULL COMMENT 'date and time that the quote last appeared in the opac', |
4220 |
`timestamp` datetime DEFAULT NULL COMMENT 'date and time that the quote last appeared in the opac', |
| 4221 |
PRIMARY KEY (`id`) |
4221 |
PRIMARY KEY (`id`) |
| 4222 |
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4222 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4223 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4223 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4224 |
|
4224 |
|
| 4225 |
-- |
4225 |
-- |
|
Lines 4259-4265
CREATE TABLE `repeatable_holidays` (
Link Here
|
| 4259 |
PRIMARY KEY (`id`), |
4259 |
PRIMARY KEY (`id`), |
| 4260 |
KEY `repeatable_holidays_ibfk_1` (`branchcode`), |
4260 |
KEY `repeatable_holidays_ibfk_1` (`branchcode`), |
| 4261 |
CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
4261 |
CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4262 |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4262 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4263 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4263 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4264 |
|
4264 |
|
| 4265 |
-- |
4265 |
-- |
|
Lines 4452-4458
CREATE TABLE `search_field` (
Link Here
|
| 4452 |
`mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable', |
4452 |
`mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable', |
| 4453 |
PRIMARY KEY (`id`), |
4453 |
PRIMARY KEY (`id`), |
| 4454 |
UNIQUE KEY `name` (`name`(191)) |
4454 |
UNIQUE KEY `name` (`name`(191)) |
| 4455 |
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4455 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4456 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4456 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4457 |
|
4457 |
|
| 4458 |
-- |
4458 |
-- |
|
Lines 4492-4498
CREATE TABLE `search_marc_map` (
Link Here
|
| 4492 |
PRIMARY KEY (`id`), |
4492 |
PRIMARY KEY (`id`), |
| 4493 |
UNIQUE KEY `index_name` (`index_name`,`marc_field`(191),`marc_type`), |
4493 |
UNIQUE KEY `index_name` (`index_name`,`marc_field`(191),`marc_type`), |
| 4494 |
KEY `index_name_2` (`index_name`) |
4494 |
KEY `index_name_2` (`index_name`) |
| 4495 |
) ENGINE=InnoDB AUTO_INCREMENT=611 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4495 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4496 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4496 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4497 |
|
4497 |
|
| 4498 |
-- |
4498 |
-- |
|
Lines 4818-4824
CREATE TABLE `subscription_frequencies` (
Link Here
|
| 4818 |
`unitsperissue` int(11) NOT NULL DEFAULT 1, |
4818 |
`unitsperissue` int(11) NOT NULL DEFAULT 1, |
| 4819 |
`issuesperunit` int(11) NOT NULL DEFAULT 1, |
4819 |
`issuesperunit` int(11) NOT NULL DEFAULT 1, |
| 4820 |
PRIMARY KEY (`id`) |
4820 |
PRIMARY KEY (`id`) |
| 4821 |
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4821 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4822 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4822 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4823 |
|
4823 |
|
| 4824 |
-- |
4824 |
-- |
|
Lines 4853-4859
CREATE TABLE `subscription_numberpatterns` (
Link Here
|
| 4853 |
`setto3` int(11) DEFAULT NULL, |
4853 |
`setto3` int(11) DEFAULT NULL, |
| 4854 |
`numbering3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4854 |
`numbering3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 4855 |
PRIMARY KEY (`id`) |
4855 |
PRIMARY KEY (`id`) |
| 4856 |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4856 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4857 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4857 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4858 |
|
4858 |
|
| 4859 |
-- |
4859 |
-- |
|
Lines 5300-5306
CREATE TABLE `z3950servers` (
Link Here
|
| 5300 |
`add_xslt` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'zero or more paths to XSLT files to be processed on the search results', |
5300 |
`add_xslt` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'zero or more paths to XSLT files to be processed on the search results', |
| 5301 |
`attributes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'additional attributes passed to PQF queries', |
5301 |
`attributes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'additional attributes passed to PQF queries', |
| 5302 |
PRIMARY KEY (`id`) |
5302 |
PRIMARY KEY (`id`) |
| 5303 |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5303 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5304 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5304 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5305 |
|
5305 |
|
| 5306 |
-- |
5306 |
-- |
|
Lines 5331-5334
CREATE TABLE `zebraqueue` (
Link Here
|
| 5331 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
5331 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
| 5332 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
5332 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
| 5333 |
|
5333 |
|
| 5334 |
-- Dump completed on 2020-12-04 14:35:26 |
5334 |
-- Dump completed on 2021-01-12 11:28:48 |
| 5335 |
- |
|
|