X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-holiday.php;h=dedf0828dd5db95d1207ea21fc67bd6bf2603f4d;hp=bf6ec1bb40a75e54d4e8c8932e333edf22735b58;hb=3f7f0051c91c54cb691303b9d49fb9cd1a7a4e8c;hpb=8f37a3b2708cfc4b4ef266f4be813a84511daa8f diff --git a/inc/extensions/ext-holiday.php b/inc/extensions/ext-holiday.php index bf6ec1bb40..dedf0828dd 100644 --- a/inc/extensions/ext-holiday.php +++ b/inc/extensions/ext-holiday.php @@ -50,21 +50,21 @@ switch (getExtensionMode()) { case 'register': // Do stuff when installation is running // Create database addDropTableSql('user_holidays'); - addCreateTableSql('user_holidays', "( + addCreateTableSql('user_holidays', " `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `holiday_start` VARCHAR(10) NOT NULL DEFAULT 0, `holiday_end` VARCHAR(10) NOT NULL DEFAULT 0, `comments` LONGTEXT NOT NULL, -INDEX (`userid`), -PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User holiday data'"); +PRIMARY KEY (`id`), +INDEX (`userid`)", + 'User holiday data'); // Add default values to config addConfigAddSql('holiday_max', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 30'); // Add member menu - addMemberMenuSql('main', 'holiday', 'Urlaubsschaltung', 'Y', 'Y', 4); + addMemberMenuSql('main', 'holiday', 'Urlaubsschaltung', 4); // Add admin menus addAdminMenuSql('holiday', NULL, 'Urlaubsmanagement', 'Hier können Sie Urlaubsschaltungen Ihrer Mitglieder auflisten oder auch wieder aufheben.', 4);