class Migrations_Migration408 extends Shopware\Components\Migrations\AbstractMigration
{ public function up($modus) { $this->
createNewTable();
$this->
prepareOldData();
$this->
migrateData();
$this->
cleanUp();
} /**
* @return string
*/
protected function createNewTable() { $this->
addSql('DROP TABLE IF EXISTS s_article_configurator_price_variations'
);
$sql = <<<EOT
CREATE TABLE `s_article_configurator_price_variations` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`configurator_set_id` int(10) unsigned NOT NULL,
`variation` decimal(10,3) NOT NULL,
`options` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`is_gross` int(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `configurator_set_id` (`configurator_set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;