34k+
News
Guide
API
Wiki
Forum
Community
Places
Members
Hall of Fame
Badges
More
Learn
Books
Resources
Develop
Download Yii
Extensions
Report an Issue
Report a Security Issue
Contribute to Yii
Donate
About
Release Cycle
License
Team
Official Logos and Design
Login
Yii v2 snippet guide
Comparing
#30
with
#31
Revision #31 was created by
rackycz
on Sep 20, 2019, 10:15:27 AM.
db
« Previous (#30)
Next (#32) »
Content
[...]
CREATE TABLE IF NOT EXISTS `user` (
`id` INT NOT NULL AUTO_INCREMENT,
`username` VARCHAR(45) NOT NULL,
`password` VARCHAR(60) NOT NULL,
`authKey` VARCHAR(60),
PRIMARY KEY (`id`)) ENGINE = InnoDB; INSERT INTO `user` (`id`, `username`, `password`
, `authKey`
) VALUES (NULL, 'user01', '0497fe4d674fe37194a6fcb08913e596ef6a307f'
, 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. The GII URL will probably be
[...]