X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-html_mail.php;h=6ffd774e150ff298074399e72cfa6b057cf987b4;hb=82d53dfb7f59fa1e37bd500e3db3d10a9d4a78da;hp=821b0592ebb8237695fe29a7eeb7d30b86782727;hpb=44c5b87eca387e02d33b4c0e728920aeca2a9840;p=mailer.git

diff --git a/inc/extensions/ext-html_mail.php b/inc/extensions/ext-html_mail.php
index 821b0592eb..6ffd774e15 100644
--- a/inc/extensions/ext-html_mail.php
+++ b/inc/extensions/ext-html_mail.php
@@ -51,17 +51,17 @@ switch ($EXT_LOAD_MODE)
 {
 case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
 	// SQL commands to run
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_user_data add html ENUM('Y','N') NOT NULL DEFAULT 'Y'";
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_bonus add html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_pool add html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD html ENUM('Y','N') NOT NULL DEFAULT 'Y'";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus ADD html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_pool ADD html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
 	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'html_mail', 'HTML-Empfang', '3', 'Y', 'Y')";
 	break;
 
 case "remove": // Do stuff when removing extension
 	// SQL commands to run
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_user_data drop html";
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_bonus drop html_msg";
-	$SQLs[] = "alter table "._MYSQL_PREFIX."_pool drop html_msg";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data DROP html";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus DROP html_msg";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_pool DROP html_msg";
 	$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE action='main' AND what='html_mail' LIMIT 1";
 	break;