Adding of request parameters partialy finished

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

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index 1635a7c6c7ad1b74f76d18aca9c0ccbdad5316db..56ec8c84597bf474d4c3b78bc7412d446aeed530 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -84,13 +84,12 @@ 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_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`)
+`network_param_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_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`),
+PRIMARY KEY (`network_param_id`)
 ) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'");
 
                // Error status codes