Table/columns renamed
authorRoland Häder <roland@mxchange.org>
Fri, 15 Jan 2010 23:05:33 +0000 (23:05 +0000)
committerRoland Häder <roland@mxchange.org>
Fri, 15 Jan 2010 23:05:33 +0000 (23:05 +0000)
inc/extensions/ext-network.php

index c0a385c..003e18f 100644 (file)
@@ -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`');