) 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_handle` VARCHAR(255) NOT NULL DEFAULT '',
`network_type_request_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!'");