X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=003e18f90dfe8aee725a5ade721dcb1d47727c45;hp=c0a385cb6fa148d1ff935a16eeda77b2930f2e26;hb=4bf784ce2bd777045d4351b3fefbd34c66c838e1;hpb=592d88e7f9bb873aacb9a9dda7457eb0c00566b2

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index c0a385cb6f..003e18f90d 100644
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -140,17 +140,17 @@ PRIMARY KEY (`network_translate_id`)
 ) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'");
 
 		// Array-Element translation tables per type/provider
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_array_translation`');
-		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_array_translation` (
-`network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
+		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_return_types` (
+`network_return_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_array_key` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_array_key`),
-UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_translation`),
+`network_return_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+`network_index_translation` VARCHAR(100) NOT NULL DEFAULT '',
+UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_return_index`),
+UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
 PRIMARY KEY (`network_translate_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Cache for all queried APIs'");
+) TYPE={?_TABLE_TYPE?} COMMENT='Return types'");
 
 		// Data from the webmaster (you!)
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
@@ -1473,7 +1473,7 @@ PRIMARY KEY (`network_reload_id`)
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_array_translation`');
+		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`');