PHP Blueprint::timestamps方法代码示例

 /**
  * 
  * @return $this
  */
 public function timestamps($timestamps = true)
 {
     $this->timestamps = $timestamps;
     if ($timestamps && !Schema::hasTable($this->table)) {
         $this->blueprint->timestamps();
     }
     return $this;
 }

 /**
  * Create the table schema.
  *
  * @param Blueprint $table
  *
  * @return mixed
  */
 protected function create(Blueprint $table)
 {
     $table->increments('id');
     $table->unsignedInteger('job_id');
     $table->string('name');
     $table->unique(['job_id', 'name']);
     $table->timestamps();
 }

 protected function create(Blueprint $table)
 {
     $table->create();
     $table->string('slug', 100)->primary();
     $table->string('name');
     $table->integer('position')->default(0);
     $table->boolean('conversations_enabled')->default(true);
     $table->timestamps();
 }

 /**
  * Create the table schema.
  *
  * @param Blueprint $table
  *
  * @return mixed
  */
 protected function create(Blueprint $table)
 {
     $table->increments('id');
     $table->text('public_id');
     $table->text('secret_key');
     $table->string('type');
     $table->text('data');
     $table->timestamps();
 }

 protected function buildDynamicTable(Blueprint $table)
 {
     $reference_column = $this->getDynamicType() . '_id';
     $reference_table = $this->getDynamicType() . 's';
     $reference_index = 'FK_' . $this->getDynamicTableName() . '_' . $reference_column . '_' . $reference_table;
     $table->increments('id');
     $table->integer($reference_column)->unsigned()->nullable();
     $table->foreign($reference_column, $reference_index)->references('id')->on($reference_table)->onUpdate('CASCADE')->onDelete('SET NULL');
     $table->timestamps();
 }

 protected function buildDynamicTable(Blueprint $table)
 {
     $block_index = 'FK_' . $this->getDynamicTableName() . '_block_id_blocks';
     $page_index = 'FK_' . $this->getDynamicTableName() . '_page_id_pages';
     $table->increments('id');
     $table->integer('block_id')->unsigned()->nullable();
     $table->integer('page_id')->unsigned()->nullable();
     $table->integer('is_shared')->unsigned()->nullable();
     $table->foreign('block_id', $block_index)->references('id')->on('blocks')->onUpdate('CASCADE')->onDelete('SET NULL');
     $table->foreign('page_id', $page_index)->references('id')->on('pages')->onUpdate('CASCADE')->onDelete('SET NULL');
     $table->timestamps();
 }

 /**
  * Create the table schema.
  *
  * @param Blueprint $table
  *
  * @return mixed
  */
 protected function create(Blueprint $table)
 {
     $table->increments('id');
     $table->string('task');
     $table->text('data')->nullable();
     $table->string('state')->default(JobState::IDLE);
     $table->text('message')->nullable();
     $table->boolean('schedulable')->default(false);
     $table->integer('attempts')->default(0);
     $table->integer('retries')->default(0);
     $table->timestamp('started_at')->nullable();
     $table->timestamp('completed_at')->nullable();
     $table->timestamp('expires_at')->nullable();
     $table->timestamp('run_at')->nullable();
     $table->timestamps();
 }

 protected function create(Blueprint $table)
 {
     $table->create();
     $table->increments('id');
     $table->string('category_slug', 100)->nullable()->index();
     $table->string('title');
     $table->string('poster', 200)->default('');
     $table->integer('posted')->unsigned()->default(0);
     $table->integer('first_post_id')->unsigned()->default(0);
     $table->integer('last_post')->unsigned()->default(0);
     $table->integer('last_post_id')->unsigned()->default(0);
     $table->string('last_poster', 200)->nullable();
     $table->integer('num_views')->unsigned()->default(0);
     $table->integer('num_replies')->unsigned()->default(0);
     $table->timestamps();
 }

 private function ifNoUsersTable(Blueprint $table)
 {
     $table->increments('id');
     $table->string('first_name');
     $table->string('last_name');
     $table->string('email')->unique();
     $table->string('avatar');
     $table->string('provider');
     $table->string('provider_id')->unique();
     $table->longText('provider_token');
     $table->string('password', 60)->nullable();
     $table->boolean('verified')->default(false);
     $table->string('gender')->nullable();
     $table->string('link');
     $table->rememberToken();
     $table->timestamps();
 }

 public function testAddingTimeStamps()
 {
     $blueprint = new Blueprint('users');
     $blueprint->timestamps();
     $statements = $blueprint->toSql($this->getGrammar());
     $this->assertEquals(1, count($statements));
     $this->assertEquals('alter table "users" add "created_at" datetime not null, add "updated_at" datetime not null', $statements[0]);
 }

 public function testAddingTimeStamps()
 {
     $blueprint = new Blueprint('users');
     $blueprint->timestamps();
     $statements = $blueprint->toSql($this->getConnection(), $this->getGrammar());
     $this->assertEquals(1, count($statements));
     $this->assertEquals('alter table users add ( created_at timestamp default 0 not null, updated_at timestamp default 0 not null )', $statements[0]);
 }

 /**
  * @return array
  */
 public function buildBlueprints()
 {
     $blueprint = new Blueprint($this->table);
     if (!Schema::hasTable($this->table)) {
         $blueprint->increments('id');
         if ($this->timestamps) {
             $blueprint->timestamps();
         }
     }
     $blueprints[] = $blueprint;
     // Only add column that doesn't exist in the database yet
     foreach ($this->columns as $name => $column) {
         if (!Schema::hasColumn($this->table, $name)) {
             $blueprint->{$column->getType()}($name);
         }
     }
     foreach ($this->relations as $relation) {
         if ($relation->hasPivotTable()) {
             $table = $relation->getBlueprint()->getTable();
             if (!Schema::hasTable($table)) {
                 $blueprints[] = $relation->getBlueprint();
             }
         } else {
             if (!Schema::hasColumn($this->table, $relation->getColumn())) {
                 $blueprint->integer($relation->getColumn());
             }
         }
     }
     return $blueprints;
 }

 /**
  * Creates the table.
  *
  * @param \Illuminate\Database\Schema\Blueprint $table
  */
 public function activate(Blueprint $table)
 {
     $table->increments('id');
     $table->string('address', 100);
     $table->timestamps();
 }