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);