From: Roland Häder Date: Fri, 15 Jan 2010 23:05:33 +0000 (+0000) Subject: Table/columns renamed X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=a3a045c54a2a396fe8b98b86908dc95dabd25136 Table/columns renamed --- 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`');