|
Lines 3754-3782
CREATE TABLE `keyboard_shortcuts` (
Link Here
|
| 3754 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3754 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3755 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3755 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3756 |
|
3756 |
|
|
|
3757 |
-- |
| 3758 |
-- Table structure for table `l10n_source` |
| 3759 |
-- |
| 3757 |
|
3760 |
|
| 3758 |
DROP TABLE IF EXISTS l10n_source; |
3761 |
DROP TABLE IF EXISTS l10n_source; |
| 3759 |
CREATE TABLE l10n_source ( |
3762 |
CREATE TABLE l10n_source ( |
| 3760 |
l10n_source_id INT(11) NOT NULL AUTO_INCREMENT, |
3763 |
`l10n_source_id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3761 |
`group` VARCHAR(100) NULL DEFAULT NULL, |
3764 |
`group` VARCHAR(100) NULL DEFAULT NULL, |
| 3762 |
`key` VARCHAR(100) NOT NULL, |
3765 |
`key` VARCHAR(100) NOT NULL, |
| 3763 |
`text` TEXT NOT NULL, |
3766 |
`text` TEXT NOT NULL, |
| 3764 |
PRIMARY KEY (l10n_source_id), |
3767 |
PRIMARY KEY (l10n_source_id), |
| 3765 |
UNIQUE KEY group_key (`group`, `key`), |
3768 |
UNIQUE KEY group_key (`group`, `key`) |
| 3766 |
KEY group_text (`group`, `text`(60)) |
|
|
| 3767 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; |
3769 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; |
|
|
3770 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3771 |
|
| 3772 |
-- |
| 3773 |
-- Table structure for table `l10n_target` |
| 3774 |
-- |
| 3768 |
|
3775 |
|
| 3769 |
DROP TABLE IF EXISTS l10n_target; |
3776 |
DROP TABLE IF EXISTS l10n_target; |
| 3770 |
CREATE TABLE l10n_target ( |
3777 |
CREATE TABLE l10n_target ( |
| 3771 |
l10n_target_id INT(11) NOT NULL AUTO_INCREMENT, |
3778 |
`l10n_target_id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3772 |
l10n_source_id INT(11) NOT NULL, |
3779 |
`l10n_source_id` INT(11) NOT NULL, |
| 3773 |
language VARCHAR(10) NOT NULL, |
3780 |
`language` VARCHAR(10) NOT NULL, |
| 3774 |
translation TEXT NOT NULL, |
3781 |
`translation` TEXT NOT NULL, |
|
|
3782 |
`fuzzy` tinyint(1) NOT NULL DEFAULT 0, |
| 3775 |
PRIMARY KEY (l10n_target_id), |
3783 |
PRIMARY KEY (l10n_target_id), |
| 3776 |
UNIQUE KEY l10n_source_language (l10n_source_id, language), |
3784 |
UNIQUE KEY l10n_source_language (l10n_source_id, language), |
| 3777 |
FOREIGN KEY l10n_source (l10n_source_id) REFERENCES l10n_source (l10n_source_id) |
3785 |
CONSTRAINT `l10n_target_fk` FOREIGN KEY (`l10n_source_id`) REFERENCES `l10n_source` (`l10n_source_id`) |
| 3778 |
ON DELETE CASCADE ON UPDATE CASCADE |
3786 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 3779 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; |
3787 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; |
|
|
3788 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3780 |
|
3789 |
|
| 3781 |
-- |
3790 |
-- |
| 3782 |
-- Table structure for table `language_descriptions` |
3791 |
-- Table structure for table `language_descriptions` |
|
Lines 5106-5112
CREATE TABLE `saved_sql` (
Link Here
|
| 5106 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5115 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5107 |
|
5116 |
|
| 5108 |
-- |
5117 |
-- |
| 5109 |
-- Table structure for table `search_field` |
5118 |
|
| 5110 |
-- |
5119 |
-- |
| 5111 |
|
5120 |
|
| 5112 |
DROP TABLE IF EXISTS `search_field`; |
5121 |
DROP TABLE IF EXISTS `search_field`; |