コード例 #1
1
 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;
 }
コード例 #2
0
 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;
 }
コード例 #3
0
 /**
  * @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;
 }
コード例 #4
0
 /**
  * @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;
 }
コード例 #5
0
ファイル: Table.php プロジェクト: bugotech/database
 /**
  * Campo DATA e HORA.
  */
 public function dateTime($column)
 {
     $col = parent::dateTime(strtolower($column));
     $col->nullable(true);
     return $col;
 }
コード例 #6
0
 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]);
 }
コード例 #7
0
 /**
  * @param Blueprint $table
  *
  * @return \Illuminate\Support\Fluent
  */
 public function setDatabaseFieldType(Blueprint $table)
 {
     return $table->dateTime($this->getDBKey())->default($this->getDefaultValue());
 }
コード例 #8
0
 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]);
 }