M240827081435CreateValetOrderDefaultUserTable.php 905 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace addons\ValetOrder\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Handles the creation of table `{{%valet_order_default_user}}`.
  6. */
  7. class M240827081435CreateValetOrderDefaultUserTable extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = <<<SQL
  15. CREATE TABLE `qimall_addons_valet_order_default_user` (
  16. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  17. `mall_id` int(10) unsigned NOT NULL DEFAULT '0',
  18. `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  19. `created_at` int(10) unsigned NOT NULL DEFAULT '0',
  20. `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
  21. PRIMARY KEY (`id`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代客下单默认用于下单预览使用的用户';
  23. SQL;
  24. $this->execute($sql);
  25. }
  26. /**
  27. * {@inheritdoc}
  28. */
  29. public function safeDown()
  30. {
  31. return false;
  32. }
  33. }