public static function _schema_multiStatusTrait(\Illuminate\Database\Schema\Blueprint $table) { $status = static::$AllowedStatus; $default = $status[0]; $table->enum('status', $status)->default($default); if (isset(static::$StatusDateTime)) { foreach (static::$StatusDateTime as $column) { if (!in_array($column, ['created_at', 'updated_at', 'deleted_at'])) { $table->dateTime($column)->nullable(); } } } $table->index(['status']); return $table; }
public static function _schema_activityTrait(\Illuminate\Database\Schema\Blueprint $table) { $table->dateTime('activity_start')->nullable(); $table->dateTime('activity_end')->nullable(); $table->dateTime('signup_start')->nullable(); $table->dateTime('signup_end')->nullable(); $table->text('activity_title')->nullable(); $table->longText('activity_content')->nullable(); $table->morphs('owner'); return $table; }
/** * @param Blueprint $table * @return Blueprint */ public static function _schema_ResetPasswordTokens(Blueprint $table) { $table->string('key')->index(); $table->string('token'); $table->integer('user_id')->index(); $table->dateTime('expires_at'); return $table; }
/** * @param Blueprint $table * @return Blueprint */ public static function _schema_LoginableTrait(Blueprint $table) { $table->string('password')->nullable(); $table->rememberToken('remember_token'); $table->dateTime('last_login')->nullable(); $table->string('last_ip')->nullable(); $table->integer('fails')->default(0); $table->enum('is_banned', [0, 1])->default(0); $table->text('ban_reason')->nullable(); $table->enum('locked_screen', [0, 1])->default(0); return $table; }
/** * Campo DATA e HORA. */ public function dateTime($column) { $col = parent::dateTime(strtolower($column)); $col->nullable(true); return $col; }
public function testAddingDateTime() { $blueprint = new Blueprint('users'); $blueprint->dateTime('foo'); $statements = $blueprint->toSql($this->getGrammar()); $this->assertEquals(1, count($statements)); $this->assertEquals('alter table "users" add "foo" datetime not null', $statements[0]); }
/** * @param Blueprint $table * * @return \Illuminate\Support\Fluent */ public function setDatabaseFieldType(Blueprint $table) { return $table->dateTime($this->getDBKey())->default($this->getDefaultValue()); }
public function testAddingDateTime() { $blueprint = new Blueprint('users'); $blueprint->dateTime('foo'); $statements = $blueprint->toSql($this->getConnection(), $this->getGrammar()); $this->assertEquals(1, count($statements)); $this->assertEquals('alter table users add ( foo date not null )', $statements[0]); }