X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-surfbar.php;h=6ee4cd5b7ac18d2102824e35ce9a1bc0d45fef6f;hp=131726809ca69491a8dd36fdb11f9b73823ce308;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d diff --git a/inc/extensions/ext-surfbar.php b/inc/extensions/ext-surfbar.php index 131726809c..6ee4cd5b7a 100644 --- a/inc/extensions/ext-surfbar.php +++ b/inc/extensions/ext-surfbar.php @@ -53,7 +53,7 @@ switch (getExtensionMode()) { case 'register': // Do stuff when installation is running (modules.php?module=admin is called) // SQL commands to run (surfbar URLs) addDropTableSql('surfbar_urls'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_urls` ( + addCreateTableSql('surfbar_urls', "( `url_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `url_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `url` VARCHAR(255) NOT NULL DEFAULT '', @@ -74,7 +74,7 @@ INDEX `status_userid` (`url_status`,`url_userid`) // Reload locks addDropTableSql('surfbar_locks'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_locks` ( + addCreateTableSql('surfbar_locks', "( `locks_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `locks_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `locks_url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -86,7 +86,7 @@ INDEX (`locks_url_id`) // Surfbar salts addDropTableSql('surfbar_salts'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_salts` ( + addCreateTableSql('surfbar_salts', "( `salts_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `salts_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `salts_url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -98,7 +98,7 @@ INDEX (`salts_url_id`) // Statistics addDropTableSql('surfbar_stats'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_stats` ( + addCreateTableSql('surfbar_stats', "( `stats_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `stats_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `stats_url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -111,7 +111,7 @@ INDEX (`stats_url_id`) // Member actions pending on status addDropTableSql('surfbar_actions'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_actions` ( + addCreateTableSql('surfbar_actions', "( `actions_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `actions_status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NULL DEFAULT NULL, `actions_action` ENUM('EDIT','DELETE','PAUSE','UNPAUSE','FRAMETEST','RETREAT','RESUBMIT','BOOKNOW') NULL DEFAULT NULL,