public function dbInstall() { $db = Yii::$app->db; $tableOptions = null; if ($db->driverName === 'mysql') { $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=MyISAM'; } $db->createCommand()->createTable(Menus::tableName(), ['menu_id' => 'pk', 'parent_id' => Schema::TYPE_INTEGER . ' NOT NULL DEFAULT 0', 'label' => Schema::TYPE_STRING . '(120) NOT NULL', 'url' => Schema::TYPE_STRING . '(255) DEFAULT NULL', 'type' => Schema::TYPE_STRING . '(15) NOT NULL', 'is_mobile' => 'tinyint(1) NOT NULL DEFAULT 1', 'order_num' => Schema::TYPE_INTEGER . ' DEFAULT NULL', 'status' => 'tinyint(1) NOT NULL DEFAULT 1', 'created_at' => Schema::TYPE_INTEGER . ' unsigned NOT NULL', 'updated_at' => Schema::TYPE_INTEGER . ' unsigned NOT NULL'], $tableOptions)->execute(); }