/** * * @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(); }