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

(-)a/installer/data/mysql/atomicupdate/bug-26573.pl (-2 / +2 lines)
Lines 10-17 return { Link Here
10
        $dbh->do(
10
        $dbh->do(
11
            q{
11
            q{
12
            CREATE TABLE IF NOT EXISTS `borrower_attribute_types_categories` (
12
            CREATE TABLE IF NOT EXISTS `borrower_attribute_types_categories` (
13
                `borrower_attribute_type_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
13
                `borrower_attribute_type_code` varchar(64) NOT NULL,
14
                `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
14
                `categorycode` varchar(10) NOT NULL,
15
                KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`),
15
                KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`),
16
                KEY `categorycode` (`categorycode`),
16
                KEY `categorycode` (`categorycode`),
17
                CONSTRAINT `borrower_attribute_types_categories_borrower_attribute_type_code` FOREIGN KEY (`borrower_attribute_type_code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
17
                CONSTRAINT `borrower_attribute_types_categories_borrower_attribute_type_code` FOREIGN KEY (`borrower_attribute_type_code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 1290-1297 DROP TABLE IF EXISTS `borrower_attribute_types_categories`; Link Here
1290
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1290
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1291
/*!40101 SET character_set_client = utf8 */;
1291
/*!40101 SET character_set_client = utf8 */;
1292
CREATE TABLE `borrower_attribute_types_categories` (
1292
CREATE TABLE `borrower_attribute_types_categories` (
1293
  `borrower_attribute_type_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
1293
  `borrower_attribute_type_code` varchar(64) NOT NULL,
1294
  `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
1294
  `categorycode` varchar(10) NOT NULL,
1295
  KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`),
1295
  KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`),
1296
  KEY `categorycode` (`categorycode`),
1296
  KEY `categorycode` (`categorycode`),
1297
  CONSTRAINT `borrower_attribute_types_categories_borrower_attribute_type_code` FOREIGN KEY (`borrower_attribute_type_code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
1297
  CONSTRAINT `borrower_attribute_types_categories_borrower_attribute_type_code` FOREIGN KEY (`borrower_attribute_type_code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
1298
- 

Return to bug 26573