123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- <?php
- use yii\db\Migration;
- class m160313_153426_session_init extends Migration
- {
-
- public function up()
- {
- $dataType = $this->binary();
- $tableOptions = null;
- switch ($this->db->driverName) {
- case 'mysql':
-
- $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
- break;
- case 'sqlsrv':
- case 'mssql':
- case 'dblib':
- $dataType = $this->text();
- break;
- }
- $this->createTable('{{%session}}', [
- 'id' => $this->string()->notNull(),
- 'expire' => $this->integer(),
- 'data' => $dataType,
- 'PRIMARY KEY ([[id]])',
- ], $tableOptions);
- }
-
- public function down()
- {
- $this->dropTable('{{%session}}');
- }
- }
|