fooRequestElementBar() functions renamed, adding of request parameters added:

[mailer.git] / inc / extensions / ext-network.php

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index 56ec8c84597bf474d4c3b78bc7412d446aeed530..215dc7d44d2f7169a188623b3ff2ded4f8aa1f61 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -84,11 +84,13 @@ PRIMARY KEY (`network_type_id`)
                // HTTP parameters (names) for URLs
                addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` (
-`network_param_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_param_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,
 `request_param_key` VARCHAR(10) NOT NULL DEFAULT 'invalid',
 `request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid',
-UNIQUE `provider_key` (`network_id`, `request_param_key`),
+UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
+UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`),
 PRIMARY KEY (`network_param_id`)
 ) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'");