case '0.0.8': // SQL queries for v0.0.8
// Theme table
addDropTableSql('themes');
- addCreateTableSql('themes', "(
+ addCreateTableSql('themes', "
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`theme_path` VARCHAR(255) NOT NULL DEFAULT '',
`theme_name` VARCHAR(255) NOT NULL DEFAULT '',
`theme_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
`theme_ver` VARCHAR(255) NOT NULL DEFAULT '0.0.0',
PRIMARY KEY (`id`),
-UNIQUE KEY (`theme_path`),
-INDEX (`theme_active`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Themes'");
+UNIQUE (`theme_path`),
+INDEX (`theme_active`)", 'Themes');
// Admin menu
addAdminMenuSql('theme', NULL, 'Themes', 'Verwalten Sie hier alle Designs (Themes) Ihres {OPEN_CONFIG}mt_word2{CLOSE_CONFIG}.', 8);
addAdminMenuSql('theme', 'theme_edit', 'Modifizieren', 'Ändern Sie Titel, Freigaben usw. an den Themes. Sie können bis auf das Standard-Theme "default" auch Themes aus der Datenbank entfernen. Vorher sollten Sie es jedoch vom Server löschen, damit es niht erneut importiert werden kann.', 2);
// Guest menu
- addGuestMenuSql('themes', NULL, 'Design-Auswahl', 'Y', 'N', 4);
+ addGuestMenuSql('themes', NULL, 'Design-Auswahl', 4);
// Memember menu
- addMemberMenuSql('themes', NULL, 'Design-Auswahl', 'N', 'Y', 3);
- addMemberMenuSql('main', 'themes', 'Designs', 'N', 'Y', 6);
+ addMemberMenuSql('themes', NULL, 'Design-Auswahl', 3);
+ addMemberMenuSql('main', 'themes', 'Designs', 6);
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`=8 WHERE `action`='themes' LIMIT 1");
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='account', `sort`=1, `title`='Designs' WHERE `what`='themes' LIMIT 1");