|
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 |
- |
|
|