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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +5 lines)
Lines 3216-3222 CREATE TABLE `language_descriptions` ( Link Here
3216
  `id` int(11) NOT NULL AUTO_INCREMENT,
3216
  `id` int(11) NOT NULL AUTO_INCREMENT,
3217
  PRIMARY KEY (`id`),
3217
  PRIMARY KEY (`id`),
3218
  KEY `lang` (`lang`),
3218
  KEY `lang` (`lang`),
3219
  KEY `subtag_type_lang` (`subtag`,`type`,`lang`)
3219
  UNIQUE KEY `uniq_desc` (`subtag`,`type`,`lang`)
3220
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3220
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3221
/*!40101 SET character_set_client = @saved_cs_client */;
3221
/*!40101 SET character_set_client = @saved_cs_client */;
3222
3222
Lines 3232-3238 CREATE TABLE `language_rfc4646_to_iso639` ( Link Here
3232
  `iso639_2_code` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3232
  `iso639_2_code` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3233
  `id` int(11) NOT NULL AUTO_INCREMENT,
3233
  `id` int(11) NOT NULL AUTO_INCREMENT,
3234
  PRIMARY KEY (`id`),
3234
  PRIMARY KEY (`id`),
3235
  KEY `rfc4646_subtag` (`rfc4646_subtag`)
3235
  KEY `rfc4646_subtag` (`rfc4646_subtag`),
3236
  UNIQUE KEY `uniq_code` (`rfc4646_subtag`, `iso639_2_code`)
3236
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3237
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3237
/*!40101 SET character_set_client = @saved_cs_client */;
3238
/*!40101 SET character_set_client = @saved_cs_client */;
3238
3239
Lines 3278-3284 CREATE TABLE `language_subtag_registry` ( Link Here
3278
  `added` date DEFAULT NULL,
3279
  `added` date DEFAULT NULL,
3279
  `id` int(11) NOT NULL AUTO_INCREMENT,
3280
  `id` int(11) NOT NULL AUTO_INCREMENT,
3280
  PRIMARY KEY (`id`),
3281
  PRIMARY KEY (`id`),
3281
  KEY `subtag` (`subtag`)
3282
  KEY `subtag` (`subtag`),
3283
  UNIQUE KEY `uniq_lang` (`subtag`, `type`)
3282
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3284
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3283
/*!40101 SET character_set_client = @saved_cs_client */;
3285
/*!40101 SET character_set_client = @saved_cs_client */;
3284
3286
3285
- 

Return to bug 29605