public static function _schema_roles(\Illuminate\Database\Schema\Blueprint $table)
{
$table->integer('parent_id');
$table->string('name')->unique();
$table->longText('permissions');
$table->string('title');
$table->text('desc')->nullable();
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;
}
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 testAddingLongText()
{
$blueprint = new Blueprint('users');
$blueprint->longText('foo');
$statements = $blueprint->toSql($this->getConnection(), $this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table users add ( foo clob not null )', $statements[0]);
}
