Revision #8 has been created by rackycz on Sep 19, 2019, 8:52:11 PM with the memo:
db
« previous (#7) next (#9) »
Changes
Title
unchanged
Yii v2 for beginners
Category
unchanged
Tutorials
Yii version
unchanged
2.0
Tags
unchanged
tutorial,beginner,yii2
Content
changed
[...]
---
... text ...
User management + basic SQL commands
---
To create DB with users, use following command. I recommend char set utf8_unicode_ci as it allowes you to use more international characters.
```MySQL
CREATE DATABASE IF NOT EXISTS `yii-demo-db` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
```
If you must use MyISAM instead of InnoDB, just skip the last row.
```MySQL[...]
```MySQL
INSERT INTO `user` (`id`, `username`, `password`) VALUES (1NULL, 'user01', '0497fe4d674fe37194a6fcb08913e596ef6a307f');
```
Login via database + Session
---
... text ...[...]