MyISAM/InnoDB support added

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

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index b665416b7a7b697da552ae7a84880874f7e7c997..fa7969499b578338f71b297f96fde09bfbdd62d5 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -38,10 +38,10 @@ if (!defined('__SECURITY')) {
 }
 
 // Version number
-EXT_SET_VERSION("0.6.1");
+EXT_SET_VERSION("0.6.2");
 
 // Version history array (add more with , "0.1" and so on)
-EXT_SET_VER_HISTORY(array("0.0", "0.0.1", "0.0.2", "0.0.3", "0.0.4", "0.0.5", "0.0.6", "0.0.7", "0.0.8", "0.0.9", "0.1.0", "0.1.1", "0.1.2", "0.1.3", "0.1.4", "0.1.5", "0.1.6", "0.1.7", "0.1.8", "0.1.9", "0.2.0", "0.2.1", "0.2.2", "0.2.3", "0.2.4", "0.2.5", "0.2.6", "0.2.7", "0.2.8", "0.2.9", "0.3.0", "0.3.1", "0.3.2", "0.3.3", "0.3.4", "0.3.5", "0.3.6", "0.3.7", "0.3.8", "0.3.9", "0.4.0", "0.4.1", "0.4.2", "0.4.3", "0.4.4", "0.4.5", "0.4.6", "0.4.7", "0.4.8", "0.4.9", "0.5.0", "0.5.1", "0.5.2", "0.5.3", "0.5.4", "0.5.5", "0.5.6", "0.5.7", "0.5.8", "0.5.9", "0.6.0", "0.6.1"));
+EXT_SET_VER_HISTORY(array("0.0", "0.0.1", "0.0.2", "0.0.3", "0.0.4", "0.0.5", "0.0.6", "0.0.7", "0.0.8", "0.0.9", "0.1.0", "0.1.1", "0.1.2", "0.1.3", "0.1.4", "0.1.5", "0.1.6", "0.1.7", "0.1.8", "0.1.9", "0.2.0", "0.2.1", "0.2.2", "0.2.3", "0.2.4", "0.2.5", "0.2.6", "0.2.7", "0.2.8", "0.2.9", "0.3.0", "0.3.1", "0.3.2", "0.3.3", "0.3.4", "0.3.5", "0.3.6", "0.3.7", "0.3.8", "0.3.9", "0.4.0", "0.4.1", "0.4.2", "0.4.3", "0.4.4", "0.4.5", "0.4.6", "0.4.7", "0.4.8", "0.4.9", "0.5.0", "0.5.1", "0.5.2", "0.5.3", "0.5.4", "0.5.5", "0.5.6", "0.5.7", "0.5.8", "0.5.9", "0.6.0", "0.6.1", "0.6.2"));
 
 switch ($EXT_LOAD_MODE)
 {
@@ -416,7 +416,7 @@ INDEX (la_id),
 INDEX (la_action),
 INDEX (la_what),
 PRIMARY KEY(id)
-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");
                // All "logical areas" together
                ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las`_data");
                ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_admin_menu_las`_data (
@@ -429,7 +429,7 @@ UNIQUE KEY (la_id),
 INDEX (la_posx),
 INDEX (la_posy),
 PRIMARY KEY(id)
-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");
                // Which menu do you like?
                ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD admin_menu ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'");
 
@@ -453,7 +453,7 @@ type ENUM('la','action','what') NOT NULL DEFAULT 'what',
 clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 INDEX (aid),
 PRIMARY KEY (id)
-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");
 
                // Update notes (these will be set as task text!)
                EXT_SET_UPDATE_NOTES("Admin-abhängig werden nun Klicks im Admin-Menü gezählt, die zur automatischen Anpassung des Menüs in den logischen Bereichen diennen. Dieses "intelligente Unbauen" können Sie auch ganz abschalten.");
@@ -662,7 +662,7 @@ PRIMARY KEY (id)
 PRIMARY KEY(`id`),
 INDEX (`userid`),
 INDEX (`stats_type`)
-) TYPE=MyISAM COMMENT='Member statistics data'");
+) TYPE={!_TABLE_TYPE!} COMMENT='Member statistics data'");
 
                // Update notes (these will be set as task text!)
                EXT_SET_UPDATE_NOTES("Mitglieder könnnen nun z.B. in den Mail-Details zu jeder Mail sehen, wann sie diese bestätigt haben. Die neue Statistik-Tabelle ist aber universell einsetzbar.");
@@ -690,7 +690,7 @@ INDEX (`stats_type`)
 `filter_function` VARCHAR(255) NOT NULL DEFAULT '',
 `filter_active` ENUM('N','Y') NOT NULL DEFAULT 'Y',
 PRIMARY KEY (`filter_id`)
-) TYPE=MyISAM COMMENT='Filter system'");
+) TYPE={!_TABLE_TYPE!} COMMENT='Filter system'");
                ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','list_filter','Filter-Management', 'Zeigt alle im System registrierten Filter an und lässt diese de- bzw. wieder aktivieren.', 17)");
 
                // Update notes (these will be set as task text!)
@@ -714,6 +714,14 @@ PRIMARY KEY (`filter_id`)
                // Update notes (these will be set as task text!)
                EXT_SET_UPDATE_NOTES("Falsche Schreibweise korregiert.");
                break;
+
+       case "0.6.2": // SQL queries for v0.6.2
+               // Depends on refback extension
+               EXT_SET_UPDATE_DEPENDS("user");
+
+               // Update notes (these will be set as task text!)
+               EXT_SET_UPDATE_NOTES("Abh&auml;ngigkeit von <u>ext-user</u> gesetzt.");
+               break;
        }
        break;
 
@@ -733,12 +741,12 @@ default: // Do stuff when extension is loaded
                        LOAD_INC_ONCE("inc/gen_sql_patches.php");
 
                        // @TODO Rewrite this to a filter!
-                       if ((GET_EXT_VERSION("cache") >= "0.1.2") && (isset($GLOBALS['cache_instance'])) && (is_object($GLOBALS['cache_instance']))) {
+                       if ((GET_EXT_VERSION("cache") >= "0.1.2") && (isCacheInstanceValid())) {
                                // Remove extensions and mod_reg cache file
                                LOAD_INC_ONCE("inc/libs/cache_functions.php");
                                require(sprintf("%sinc/extensions/ext-cache.php", constant('PATH')));
                                if ($GLOBALS['cache_instance']->loadCacheFile("extensions", true)) $GLOBALS['cache_instance']->destroyCacheFile();
-                               if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg"))          $GLOBALS['cache_instance']->destroyCacheFile();
+                               if ($GLOBALS['cache_instance']->loadCacheFile("modreg"))           $GLOBALS['cache_instance']->destroyCacheFile();
                        } // END - if
                } // END - if
 
@@ -765,7 +773,7 @@ default: // Do stuff when extension is loaded
                define('MT_WORD3', getConfig('mt_word3'));
                define('_MAX'    , getConfig('rand_no'));
        } else {
-               // Set some lame ( ;-) ) default settings
+               // Set some lame ( ;-) ) default settings
                setConfigEntry('def_refid'        , 0);
                setConfigEntry('enable_title_deco', "N");
                setConfigEntry('title_mod_show'   , "Y");