X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=215dc7d44d2f7169a188623b3ff2ded4f8aa1f61;hp=2eabe994ea3ee2b44c5092d216ad4e395b6ce88b;hb=57227d33e870ec5cd271209c4a978a52b45c2dd6;hpb=adb34cea9c14bcac14030f8eb1e6ae2c3231c962

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index 2eabe994ea..215dc7d44d 100644
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -68,31 +68,31 @@ PRIMARY KEY (`network_id`)
 ) TYPE={?_TABLE_TYPE?} COMMENT='Network data'");
 
 		// Types the network provider is supporting (e.g. Forced-Banner and so on)
-		// @TODO network_type_name is an internal name and needs documentation
+		// @TODO network_type_handle is an internal name and needs documentation
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` (
 `network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_type_name` VARCHAR(255) NOT NULL DEFAULT '',
-`network_type_title` VARCHAR(255) NOT NULL DEFAULT '',
-`network_type_request_url` VARCHAR(255) NOT NULL DEFAULT '',
+`network_type_handle` VARCHAR(255) NOT NULL DEFAULT '',
+`network_type_api_url` VARCHAR(255) NOT NULL DEFAULT '',
 `network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
 `network_type_banner_url` VARCHAR(255) NOT NULL DEFAULT '',
-UNIQUE `provider_type` (`network_id`,`network_type_name`),
+UNIQUE `provider_type` (`network_id`,`network_type_handle`),
 PRIMARY KEY (`network_type_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks. ONLY FILL OUT WITH PROPER idEA!'");
+) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks'");
 
 		// 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`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request ONLY FILL OUT WITH PROPER idEA!'");
+`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
 		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');