<?php

use yii\db\Schema;
use yii\db\Migration;

class m150915_125129_addDetails extends Migration
{
    public function up()
    {
        $this->execute('CREATE TABLE `details` (
        `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
       `IMPORT_ID` int(6) unsigned NOT NULL,
       `BRAND` varchar(100) NOT NULL,
       `ARTICLE` varchar(100) NOT NULL,
       `FULL_ARTICLE` varchar(150) NOT NULL,
       `PRICE` float(15,2) unsigned NOT NULL,
       `DESCR` varchar(200) NOT NULL,
       `BOX` int(6) unsigned NOT NULL,
       `ADD_BOX` int(6) unsigned NOT NULL DEFAULT 0,
       `GROUP` varchar(200) NOT NULL DEFAULT \'\',
       `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       PRIMARY KEY (`ARTICLE`,`BRAND`,`IMPORT_ID`),
       UNIQUE KEY `ID_delete` (`ID`),
       KEY `timestamp` (`timestamp`),
       KEY `ARTICLE` (`ARTICLE`,`BRAND`,`BOX`),
       KEY `BRAND` (`BRAND`,`ARTICLE`),
       KEY `ARTICLE_2` (`ARTICLE`,`BRAND`,`ADD_BOX`),
       KEY `IMPORT_ID` (`IMPORT_ID`,`ARTICLE`),
       KEY `IMPORT_ID_2` (`IMPORT_ID`,`timestamp`)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8');

    }

    public function down()
    {
        $this->dropTable('{{%details}}');

    }

}