case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
// Main table which hold
addDropTableSql('network_data');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_data` (
+ addCreateTableSql('network_data', "(
`network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_short_name` VARCHAR(50) NOT NULL DEFAULT '',
`network_title` VARCHAR(255) NOT NULL DEFAULT '',
// Types the network provider is supporting (e.g. Forced-Banner and so on)
// @TODO network_type_handle is an internal name and needs documentation
addDropTableSql('network_types');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` (
+ addCreateTableSql('network_types', "(
`network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_handle` VARCHAR(255) NOT NULL DEFAULT '',
// HTTP parameters (names) for URLs
addDropTableSql('network_request_params');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` (
+ addCreateTableSql('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,
// Error status codes
addDropTableSql('network_error_codes');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_codes` (
+ addCreateTableSql('network_error_codes', "(
`network_type_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
// Code types (internal table)
addDropTableSql('network_error_types');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_types` (
+ addCreateTableSql('network_error_types', "(
`network_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_code` VARCHAR(100) NOT NULL DEFAULT 'INVALID_CODE',
UNIQUE (`network_code`),
// Valid translation keys (we hate hard-coded arrays, you see?)
addDropTableSql('network_translations');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
+ addCreateTableSql('network_translations', "(
`network_translation_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_translation_name` VARCHAR(100) NOT NULL DEFAULT '',
UNIQUE (`network_translation_name`),
// Array-Element translation tables per type/provider
addDropTableSql('network_api_translation');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_api_translation` (
+ addCreateTableSql('network_api_translation', "(
`network_api_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,
// Data from the webmaster (you!)
addDropTableSql('network_config');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_config` (
+ addCreateTableSql('network_config', "(
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_api_password` VARCHAR(255) NOT NULL DEFAULT '',
// Configuration data for e.g. reload-time
addDropTableSql('network_types_config');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types_config` (
+ addCreateTableSql('network_types_config', "(
`network_data_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,
// `network_cache_refresh` in seconds or if set to zero, full day
// divided by query amount.
addDropTableSql('network_cache');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_cache` (
+ addCreateTableSql('network_cache', "(
`network_cache_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,
// Reload locks for several types
addDropTableSql('network_reloads');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_reloads` (
+ addCreateTableSql('network_reloads', "(
`network_reload_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,