X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-imprint.php;h=dc936919dc9f67af2c78105a33437c5bbc3e82a6;hb=f28e0b7c670860b68420a2b78c0aa2cc3838a1c6;hp=4098d18751f09bef88cbee7d1a3d5759e4a7dd84;hpb=9f30db83eedcaf1d265d973e4bffcd3fa7df9bde;p=mailer.git diff --git a/inc/extensions/ext-imprint.php b/inc/extensions/ext-imprint.php index 4098d18751..dc936919dc 100644 --- a/inc/extensions/ext-imprint.php +++ b/inc/extensions/ext-imprint.php @@ -17,7 +17,7 @@ * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -66,13 +66,13 @@ switch (getExtensionMode()) { // Create imprint data table addDropTableSql('imprint_data'); - addCreateTableSql('imprint_data', "( + addCreateTableSql('imprint_data', " `imprint_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `imprint_key` VARCHAR(255) NOT NULL DEFAULT '', `imprint_value` VARCHAR(255) NOT NULL DEFAULT '', -UNIQUE (`imprint_key`), -PRIMARY KEY (`imprint_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Imprint data'"); +PRIMARY KEY (`imprint_id`), +UNIQUE (`imprint_key`)", + 'Imprint data'); // Init imprint data addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_imprint_data` (`imprint_key`) VALUES ('company'),('surname'),('family'),('street_nr1'),('street_nr2'),('zip'),('city'),('state'),('country'),('phone'),('fax'),('email'),('footer')"); @@ -92,12 +92,12 @@ PRIMARY KEY (`imprint_id`) case 'activate': // Do stuff when admin activates this extension // SQL commands to run - addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `locked`='N', `visible`='Y' WHERE `what`='imprint' LIMIT 1"); + addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `locked`='N',`visible`='Y' WHERE `what`='imprint' LIMIT 1"); break; case 'deactivate': // Do stuff when admin deactivates this extension // SQL commands to run - addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `locked`='Y', `visible`='N' WHERE `what`='imprint' LIMIT 1"); + addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `locked`='Y',`visible`='N' WHERE `what`='imprint' LIMIT 1"); break; case 'update': // Update an extension