m210809_132319_balance_fields.php 925 B

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. use yii\db\Migration;
  3. /**
  4. * Class m210809_132319_balance_fields
  5. */
  6. class m210809_132319_balance_fields extends Migration
  7. {
  8. /**
  9. * {@inheritdoc}
  10. */
  11. public function safeUp()
  12. {
  13. $this->addColumn('{{%user}}', 'balance', $this->integer(11)->notNull()->after('address'));
  14. $this->addColumn('{{%user}}', 'plan_title', $this->string(255)->null()->after('balance'));
  15. $this->addColumn('{{%user}}', 'plan_price', $this->integer(11)->notNull()->after('plan_title'));
  16. $this->addColumn('{{%user}}', 'payment_online', $this->smallInteger(3)->null()->after('plan_price'));
  17. }
  18. /**
  19. * {@inheritdoc}
  20. */
  21. public function safeDown()
  22. {
  23. $this->dropColumn('{{%user}}', 'balance');
  24. $this->dropColumn('{{%user}}', 'plan_title');
  25. $this->dropColumn('{{%user}}', 'plan_price');
  26. $this->dropColumn('{{%user}}', 'payment_online');
  27. }
  28. }