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

(-)a/debian/scripts/koha-dump (-1 / +1 lines)
Lines 79-85 dump_instance() Link Here
79
        schemadump="$backupdir/$name-schema-$date.sql"
79
        schemadump="$backupdir/$name-schema-$date.sql"
80
        [ "$quiet" = "no" ] && echo "* schema to $schemadump"
80
        [ "$quiet" = "no" ] && echo "* schema to $schemadump"
81
        mysqldump $dbflag -d --host="$mysqlhost" \
81
        mysqldump $dbflag -d --host="$mysqlhost" \
82
            --user="$mysqluser" --password="$mysqlpass" "$mysqldb" > "$schemadump"
82
            --user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump"
83
        chown "root:$name-koha" "$schemadump"
83
        chown "root:$name-koha" "$schemadump"
84
        chmod g+r "$schemadump"
84
        chmod g+r "$schemadump"
85
    else
85
    else
(-)a/installer/data/mysql/kohastructure.sql (-38 / +37 lines)
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
- 

Return to bug 26947