- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain`(
- id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- gain decimal(10,3) NOT NULL DEFAULT '0.000',
- PRIMARY KEY (id)
+ addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`");
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain` (
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`gain` decimal(10,3) NOT NULL DEFAULT '0.000',
+PRIMARY KEY (`id`)