CreateDropTable.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace App\Console\Commands\User;
  3. use App\Modules\Book\Models\NovelUserPorperty;
  4. use Illuminate\Console\Command;
  5. class CreateDropTable extends Command
  6. {
  7. /**
  8. * The name and signature of the console command.
  9. *
  10. * @var string
  11. */
  12. protected $signature = 'create_drop_table';
  13. /**
  14. * The console command description.
  15. *
  16. * @var string
  17. */
  18. protected $description = '每天删除新建表';
  19. /**
  20. * Create a new command instance.
  21. *
  22. * @return void
  23. */
  24. public function __construct()
  25. {
  26. parent::__construct();
  27. }
  28. /**
  29. * Execute the console command.
  30. *
  31. * @return mixed
  32. */
  33. public function handle()
  34. {
  35. NovelUserPorperty::dropTable();
  36. for ($i = 0; $i < 3; $i++) {
  37. if ($i) {
  38. $date = date('Ymd', strtotime('+' . $i . ' days'));
  39. } else {
  40. $date = date('Ymd');
  41. }
  42. NovelUserPorperty::model($date)->createTableIfNotExists();
  43. }
  44. }
  45. }