break;
case '0.2.0': // SQL queries for v0.2
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `birthday_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+ addConfigAddSql('birthday_points', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
addDropTableSql('user_birthday');
addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_birthday` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
break;
case '0.3.6': // SQL queries for v0.3.6
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD birthday_mode ENUM('DIRECT','REF') NOT NULL DEFAULT 'DIRECT'");
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD birthday_active ENUM('Y','N') NOT NULL DEFAULT 'N'");
+ addConfigAddSql('birthday_mode', "ENUM('DIRECT','REF') NOT NULL DEFAULT 'DIRECT'");
+ addConfigAddSql('birthday_active', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Vergütungsmodus des Geburtstagsbonus einstellbar.");