2020_11_02_114020_add_default_user.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. use Illuminate\Support\Facades\DB;
  3. use Illuminate\Support\Facades\Schema;
  4. use Illuminate\Database\Schema\Blueprint;
  5. use Illuminate\Database\Migrations\Migration;
  6. use Yunshop\Merchant\common\models\WeiQingUsers;
  7. class AddDefaultUser extends Migration
  8. {
  9. /**
  10. * Run the migrations.
  11. *
  12. * @return void
  13. */
  14. public function up()
  15. {
  16. /*Schema::table('yz_merchant', function(Blueprint $table)
  17. {
  18. if (!Schema::hasColumn('yz_merchant', 'user_uid')) {
  19. $table->integer('user_uid')->nullable()->default(0)->comment('yz_user.id');
  20. } else {
  21. $merchants = DB::table('yz_merchant')->where('user_uid', 0)->get();
  22. if (!$merchants->isEmpty()) {
  23. foreach ($merchants as $merchant) {
  24. $user = WeiQingUsers::register('merchant_user_'.$merchant['id'], 'merchant_user_'.$merchant['id']);
  25. DB::table('yz_merchant')->where('id', $merchant['id'])->update(['user_uid' => $user['user_uid']]);
  26. }
  27. }
  28. }
  29. });*/
  30. }
  31. /**
  32. * Reverse the migrations.
  33. *
  34. * @return void
  35. */
  36. public function down()
  37. {
  38. }
  39. }