2022_10_18_092853_create_broadcasts_table.php 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. <?php
  2. use Illuminate\Database\Schema\Blueprint;
  3. use Illuminate\Database\Migrations\Migration;
  4. /**
  5. * Class CreateBroadcastsTable.
  6. */
  7. class CreateBroadcastsTable extends Migration
  8. {
  9. /**
  10. * Run the migrations.
  11. *
  12. * @return void
  13. */
  14. public function up()
  15. {
  16. Schema::create('broadcasts', function(Blueprint $table) {
  17. $table->increments('id');
  18. $table->string('from')->default('')->comment('from');
  19. $table->string('to')->default('')->comment('to');
  20. $table->string('nonce')->default('')->comment('nonce');
  21. $table->string('value')->default('')->comment('value');
  22. $table->string('data')->default('')->comment('data');
  23. $table->string('chain_id')->default('')->comment('chain_id');
  24. $table->string('gas_price')->default('')->comment('gas_price');
  25. $table->string('gas_limit')->default('')->comment('gas_limit');
  26. $table->string('sign')->default('')->comment('sign');
  27. $table->string('hash')->default('')->comment('hash');
  28. $table->string('from_key')->default('')->comment('from_key');
  29. $table->string('error')->default('')->comment('error');
  30. $table->string('contract_address')->default('')->comment('contract_address');
  31. $table->string('to_address')->default('')->comment('to_address');
  32. $table->text('success')->comment('success');
  33. $table->double('money',12,6)->default('0')->comment('余额');
  34. $table->integer('type')->default('0')->comment('type');
  35. $table->integer('status')->default('0')->comment('status');
  36. $table->integer('order_id')->default('0')->comment('order_id');
  37. $table->integer('coin_id')->default('0')->comment('coin_id');
  38. $table->integer('depend')->default('0')->comment('depend');
  39. $table->integer('m_id')->default('0')->comment('m_id');
  40. $table->timestamps();
  41. });
  42. }
  43. /**
  44. * Reverse the migrations.
  45. *
  46. * @return void
  47. */
  48. public function down()
  49. {
  50. Schema::drop('broadcasts');
  51. }
  52. }