qpapi/database/migrations/2019_05_08_160636_create_messages_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateMessagesTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('messages', function(Blueprint $table)
		{
			$table->increments('id');
			$table->string('title', 191)->comment('消息标题');
			$table->text('content', 65535)->nullable()->comment('消息内容');
			$table->integer('read')->default(1)->comment('1-未读，2-已读');
			$table->char('send_uuid', 36)->default(1)->comment('消息发送者UUID，1表示系统发送');
			$table->char('accept_uuid', 36)->comment('消息接收者UUID');
			$table->integer('flag')->comment('消息对应关系：12-系统推送给后台，13-系统推送给前台,22-后台推送给后台，23-后台推送给前台，32-前台推送给后台，33-前台推送给前台，');
			$table->timestamps();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('messages');
	}

}