From a3a045c54a2a396fe8b98b86908dc95dabd25136 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Fri, 15 Jan 2010 23:05:33 +0000 Subject: [PATCH 1/1] Table/columns renamed --- inc/extensions/ext-network.php | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) 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`'); -- 2.39.5