LAS (logical area system) table renamed, table comments added:

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

diff --git a/inc/extensions/ext-register.php b/inc/extensions/ext-register.php
index be486be9146d80cdc1fd45fceb70c930ee371817..dcaa8e3793f78956cc5a5289efeb207393289a05 100644 (file)
--- a/inc/extensions/ext-register.php
+++ b/inc/extensions/ext-register.php
@@ -54,8 +54,8 @@ switch (getExtensionMode()) {
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register' LIMIT 1");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register' LIMIT 1");
                addDropTableSql('must_register');
 
                // Unregister a filter
@@ -81,7 +81,7 @@ switch (getExtensionMode()) {
 `field_name` VARCHAR(255) NOT NULL DEFAULT '',
 `field_required` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data which fields the user must fill out'");
 
                                // Add all entries as required (DO NOT DELETE THEM FROM DATABASE!)
                                addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_must_register` (`field_name`, `field_required`) VALUES ('surname','Y')");