m150915_125129_addDetails.php
1.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?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}}');
}
}