LAS (logical area system) table renamed, table comments 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 51d6045a02b7c9ff5b3ae9833d88031b4e0dabdb..1549db5e50e4b9098d07613efa1c357a91f02531 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -59,7 +59,7 @@ switch (getExtensionMode()) {
                // Drop tables
                addDropTableSql('admin_menu_las');
                addDropTableSql('admin_menu_las_data');
-               addDropTableSql('admin_menu_stats');
+               addDropTableSql('admin_las_stats');
                addDropTableSql('filters');
                addDropTableSql('dns_cache');
 
@@ -367,7 +367,7 @@ switch (getExtensionMode()) {
                                break;
 
                        case '0.3.2': // SQL queries for v0.3.2
-                               // Connection table between the menu system and the "logical area" system
+                               // Connection table between the menu system and the "logical area system"
                                addDropTableSql('admin_menu_las');
                                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -378,7 +378,7 @@ INDEX (`la_id`),
 INDEX (`la_action`),
 INDEX (`la_what`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'");
                                // All "logical areas" together
                                addDropTableSql('admin_menu_las_data');
                                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las_data` (
@@ -391,7 +391,7 @@ UNIQUE KEY (`la_id`),
 INDEX (`la_posx`),
 INDEX (`la_posy`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS position and title data'");
                                // Which menu do you like?
                                addConfigAddSql('admin_menu', "ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'");
 
@@ -407,15 +407,15 @@ PRIMARY KEY (`id`)
                                addConfigAddSql('admin_menu_sorter', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
 
                                // The statistics table
-                               addDropTableSql('admin_menu_stats');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_stats` (
+                               addDropTableSql('admin_las_stats');
+                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_las_stats` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `type` ENUM('la','action','what') NOT NULL DEFAULT 'what',
 `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 INDEX (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS click data'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("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.");