m130524_201442_init.php 1.04 KB
Newer Older
1 2
<?php

Suralc committed
3 4
use yii\db\Schema;

5 6
class m130524_201442_init extends \yii\db\Migration
{
7 8 9 10 11 12
    public function up()
    {
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
        }
13

14
        $this->createTable('{{%user}}', [
15 16 17 18 19 20 21
            'id' => Schema::TYPE_PK,
            'username' => Schema::TYPE_STRING . ' NOT NULL',
            'auth_key' => Schema::TYPE_STRING . '(32) NOT NULL',
            'password_hash' => Schema::TYPE_STRING . ' NOT NULL',
            'password_reset_token' => Schema::TYPE_STRING,
            'email' => Schema::TYPE_STRING . ' NOT NULL',
            'role' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',
22

23 24 25 26 27
            'status' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',
            'created_at' => Schema::TYPE_INTEGER . ' NOT NULL',
            'updated_at' => Schema::TYPE_INTEGER . ' NOT NULL',
        ], $tableOptions);
    }
28

29 30
    public function down()
    {
31
        $this->dropTable('{{%user}}');
32
    }
33
}