Are you going to develop your web application in yii2 framwork, then this article will help you. The user table schema is not provided with yii2 starter kit by yii2 framework package. Below is proper user table schema.

How to create user table schema for yii2

1) Create database fro your yii2 application.
2) Open phpmyadmin in your browser like: http://localhost/phpmyadmin.
3) Select your database and click on SQL Tabs.
4) Copy below mysql query and paste into SQL editor.


Insert below data in user table.

Now you can login in your application by using below username and password :
Username: admin
Password: 123qwe