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]); }