SQL fixed

diff --git a/inc/cache/.revision b/inc/cache/.revision
index 2458b5058e02220ac7bec7cea45d54d4de7869e7..471f8160de2bdd8a94873c730b90075aed260e6b 100644 (file)
--- a/inc/cache/.revision
+++ b/inc/cache/.revision
@@ -1,4 +1,4 @@
 856
 856

-1236367472
-0.2.1-FINAL-STELZI
-stelzi
\ No newline at end of file
+1236385939
+0.2.1-FINAL
+quix0r
\ No newline at end of file

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index ef7cd0867b8ccf377932bf8d60f52bb72d8482d5..ed63c11763034a2a156defead8e3683df863bda2 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -58,7 +58,7 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
 case "remove": // Do stuff when removing extension
        // Drop tables
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las`");
 case "remove": // Do stuff when removing extension
        // Drop tables
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las`");

-       ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las`_data");
+       ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las_data`");

        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_stats`");
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_user_stats_data`");
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_user_book`");
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_stats`");
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_user_stats_data`");
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_user_book`");


@@ -423,8 +423,8 @@ INDEX (la_what),
 PRIMARY KEY(id)
 ) TYPE={!_TABLE_TYPE!}");
                // All "logical areas" together
 PRIMARY KEY(id)
 ) 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 (
+               ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_admin_menu_las_data`");
+               ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_admin_menu_las_data` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 la_id VARCHAR(255) NOT NULL DEFAULT '',
 la_title VARCHAR(255) NOT NULL DEFAULT '',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 la_id VARCHAR(255) NOT NULL DEFAULT '',
 la_title VARCHAR(255) NOT NULL DEFAULT '',