<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class CreateEdmTask extends Migration { public function up() { Schema::create('edm_task', function (Blueprint $gCb7f) { $gCb7f->increments('id'); $gCb7f->timestamps(); $gCb7f->string('title', 200)->nullable()->comment(''); $gCb7f->string('filterTags', 200)->nullable()->comment(''); $gCb7f->tinyInteger('status')->nullable()->comment(''); $gCb7f->string('templateIds', 200)->nullable()->comment(''); $gCb7f->integer('successCount')->nullable()->comment(''); $gCb7f->integer('failCount')->nullable()->comment(''); $gCb7f->tinyInteger('limitEnable')->nullable()->comment(''); $gCb7f->integer('limitHourly')->nullable()->comment(''); $gCb7f->tinyInteger('itemProcessed')->nullable()->comment(''); }); Schema::create('edm_task_item', function (Blueprint $gCb7f) { $gCb7f->increments('id'); $gCb7f->timestamps(); $gCb7f->string('alias', 10)->nullable()->comment(''); $gCb7f->integer('taskId')->nullable()->comment(''); $gCb7f->string('email', 200)->nullable()->comment(''); $gCb7f->dateTime('startTime')->nullable()->comment(''); $gCb7f->dateTime('endTime')->nullable()->comment(''); $gCb7f->dateTime('queueTime')->nullable()->comment(''); $gCb7f->tinyInteger('status')->nullable()->comment(''); $gCb7f->string('statusRemark', 200)->nullable()->comment(''); $gCb7f->string('subject', 200)->nullable()->comment(''); $gCb7f->text('content')->nullable()->comment(''); $gCb7f->tinyInteger('visitStatus')->nullable()->comment(''); $gCb7f->tinyInteger('subscribeStatus')->nullable()->comment(''); $gCb7f->unique(array('taskId', 'email')); $gCb7f->index(array('queueTime')); }); } public function down() { } }