2020_04_09_111540_change_tutorial_table.php 1021 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. use Illuminate\Support\Facades\Schema;
  3. use Illuminate\Database\Schema\Blueprint;
  4. use Illuminate\Database\Migrations\Migration;
  5. class ChangeTutorialTable extends Migration
  6. {
  7. /**
  8. * Run the migrations.
  9. *
  10. * @return void
  11. */
  12. public function up()
  13. {
  14. Schema::table('tutorials', function (Blueprint $table) {
  15. $table->dropColumn('content');
  16. });
  17. Schema::table('users', function (Blueprint $table) {
  18. $table->string('email')->nullable()->change();
  19. });
  20. }
  21. /**
  22. * Reverse the migrations.
  23. *
  24. * @return void
  25. */
  26. public function down()
  27. {
  28. Schema::table('tutorials', function (Blueprint $table) {
  29. $table->longText('content')->after('name')->nullable()->comment('富文本内容');
  30. });
  31. Schema::table('users', function (Blueprint $table) {
  32. // $table->unique('email','users_email_unique');
  33. // $table->string('email')->unique()->change();
  34. });
  35. }
  36. }