INSERT INTO `user` (`id`, `username`, `password`, `email`, `authKey`) VALUES (NULL, 'user01', '0497fe4d674fe37194a6fcb08913e596ef6a307f', 'user01@gmail.com', NULL);
```

If you must use MyISAM instead of InnoDB, just change the word InnoDB into MYISAM.

Then use GII to generate model, views and controller + CRUD. The GII URL will probably be - [http://localhost/basic/web/index.php?r=gii](http://localhost/basic/web/index.php?r=gii). - When creating the model, check this checkbox: **Enable I18N** ... we will need i18n later - Note that there already is a model named User in the demo app. You will not need it if you want to use login-via-DB so feel free to check "Othe overwrite"-checkbox in GII. The newly created User model will now be usable only for table operations, not for login. But we will enhance it, keep readingsee te snippet below. - The new model will only have 3 methods: tableName(), rules(), attributeLabels() - In order to use the DB for login, we need to implement IdentityInterface which requires [5 new methods](https://www.yiiframework.com/doc/api/2.0/yii-web-identityinterface). But as I do not need all those methods, in some of them I have commented out their body in the example below.  
- Plus we add 2 methods because of the default LoginForm


The final model should look like this:

```php
<?php