case '0.0.4': // SQL queries for v0.0.4
// SQL commands to run
addDropTableSql('mediadata');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_mediadata` (
+ addCreateTableSql('mediadata', "(
`media_key` VARCHAR(255) NOT NULL DEFAULT '',
`media_value` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`media_key`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Media data key->value'");
// Add auto-check file
addIncludeToPool('extension', 'inc/gen_mediadata.php');
break;
case '0.0.7': // SQL queries for v0.0.7
- addConfigAddSql('mt_start', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
- addConfigAddSql('mt_stage', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 500");
+ addConfigAddSql('mt_start', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0');
+ addConfigAddSql('mt_stage', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 500');
addAdminMenuSql('setup', 'config_mediadata', 'Mediendaten', 'Stellen Sie allgemeine Einstellungen zu den Mediendaten ein.', 10);
// Update notes (these will be set as task text!)