Snippet content copied to clipboard.
Are you sure to delete this snippet? No, don't delete
  1. <?php
  2. ​
  3. use yii\db\Migration;
  4. ​
  5. /**
  6. * Handles the creation of table `{{%verification_auth}}`.
  7. */
  8. class m220323_084927_create_verification_auth_table extends Migration
  9. {
  10. /**
  11. * {@inheritdoc}
  12. */
  13. public function safeUp()
  14. {
  15. $tableOptions = null;
  16. if ($this->db->driverName === 'mysql') {
  17. $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
  18. }
  19. ​
  20. $this->createTable('{{%verification_auth}}', [
  21. 'hash' => $this->string(50),
  22. 'addressee' => $this->string(100),
  23. 'user_id' => $this->integer(11)->notNull(),
  24. 'verify_code' => $this->integer(11)->notNull(),
  25. 'created_at' => $this->integer(11)->notNull(),
  26. 'resend_at' => $this->integer(11)->notNull(),
  27. 'ip' => $this->string(128)->notNull(),
  28. 'is_confirmed' => $this->tinyInteger(1)->notNull()->defaultValue(0),
  29. 'attempts' => $this->integer(11)->notNull()->defaultValue(0)
  30. ], $tableOptions);
  31. ​
  32. $this->addPrimaryKey(
  33. 'pk-verification_auth-hash',
  34. 'verification_auth',
  35. 'hash'
  36. );
  37. ​
  38. $this->createIndex(
  39. 'user_id',
  40. 'verification_auth',
  41. 'user_id'
  42. );
  43. }
  44. ​
  45. /**
  46. * {@inheritdoc}
  47. */
  48. public function safeDown()
  49. {
  50. $this->dropTable('{{%verification_auth}}');
  51. }
  52. }

Edit this Snippet