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 1635a7c6c7ad1b74f76d18aca9c0ccbdad5316db..215dc7d44d2f7169a188623b3ff2ded4f8aa1f61 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -84,13 +84,14 @@ 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 AUTO_INCREMENT,
+`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`request_param_max_reload_time` VARCHAR(10) NOT NULL DEFAULT 'reload',
-`request_param_min_waiting_time` VARCHAR(10) NOT NULL DEFAULT 'ma',
-`request_param_min_remain_clicks` VARCHAR(10) NOT NULL DEFAULT 'uebrig',
-`request_param_min_payment` VARCHAR(10) NOT NULL DEFAULT 'verguetung',
-`request_param_allow_erotic` VARCHAR(10) NOT NULL DEFAULT 'erotik',
-PRIMARY KEY (`network_type_id`)
+`request_param_key` VARCHAR(10) NOT NULL DEFAULT 'invalid',
+`request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid',
+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'");
 
                // Error status codes