Yii2 Cheat Sheet

1. Console commands

Migrations

php yii migrate/create create_NAME_table --fields="user_id:integer:unsigned:foreignKey(users):notNull,serial_id:integer:notNull,notification:tinyInteger(1):unsigned:notNull"
php yii migrate/create add_NAME_column_to_NAME_table --fields="description:text(1000):after('title')"

Fields:

• integer
• tinyInteger
• string
• text
• timestamp

Mods:

• unsigned
• foreignKey(tableName)
• null
• notNull
• after('column_name')
• defaultValue('0')
• defaultExpression('CURRENT_TIMESTAMP')
• defaultExpression('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP')