protected function create(Blueprint $table)
{
$table->create();
$table->integer('group_id')->unsigned();
$table->integer('forum_id')->unsigned();
$table->boolean('read_forum')->default(true);
$table->boolean('post_replies')->default(true);
$table->boolean('post_topics')->default(true);
$table->primary(array('group_id', 'forum_id'));
}
/**
* Add confirmation columns.
*
* @param \Illuminate\Database\Schema\Blueprint $table
*/
private function addConfirmationColumns(Blueprint $table)
{
if (UserConfirmator::isEnabled()) {
$table->boolean('is_confirmed')->default(0);
$table->string('confirmation_code', UserConfirmator::getLength())->nullable();
$table->timestamp('confirmed_at')->nullable();
}
}
/**
* Activates the table.
*
* @param \Illuminate\Database\Schema\Blueprint $table
*/
public function activate(Blueprint $table)
{
$table->increments('id');
$table->string('title');
$table->string('slug');
$table->string('url');
$table->boolean('default_set');
}
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->integer('group_id')->unsigned();
$table->string('name', 50);
$table->boolean('value');
}
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->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('poster', 200)->default('');
$table->integer('poster_id')->unsigned()->default(1);
$table->string('poster_ip', 39)->nullable();
$table->text('message')->nullable();
$table->boolean('hide_smilies')->default(false);
$table->integer('posted')->unsigned()->default(0);
$table->integer('edited')->unsigned()->nullable();
$table->string('edited_by', 200)->nullable();
$table->integer('conversation_id')->unsigned();
$table->index('conversation_id');
$table->index(['poster_id', 'conversation_id']);
}
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->integer('group_id')->unsigned()->default(3);
$table->string('username', 200)->default('');
$table->string('password', 60)->default('');
$table->string('email', 80)->default('');
$table->string('title', 50)->nullable();
$table->string('realname', 40)->nullable();
$table->string('url', 100)->nullable();
$table->string('location', 30)->nullable();
$table->text('signature')->nullable();
$table->integer('disp_topics')->unsigned()->nullable();
$table->integer('disp_posts')->unsigned()->nullable();
$table->integer('email_setting')->unsigned()->default(1);
$table->boolean('notify_with_post')->default(false);
$table->boolean('auto_notify')->default(false);
$table->boolean('show_smilies')->default(true);
$table->boolean('show_img')->default(true);
$table->boolean('show_img_sig')->default(true);
$table->boolean('show_avatars')->default(true);
$table->boolean('show_sig')->default(true);
$table->float('timezone')->default(0);
$table->boolean('dst')->default(false);
$table->integer('time_format')->unsigned()->default(0);
$table->integer('date_format')->unsigned()->default(0);
$table->string('language', 25)->default('');
$table->string('style', 25)->default('');
$table->integer('num_posts')->unsigned()->default(0);
$table->integer('last_post')->unsigned()->nullable();
$table->integer('last_search')->unsigned()->nullable();
$table->integer('last_email_sent')->unsigned()->nullable();
$table->integer('last_report_sent')->unsigned()->nullable();
$table->integer('registered')->unsigned()->default(0);
$table->string('registration_ip', 35)->default('0.0.0.0');
$table->integer('last_visit')->unsigned()->default(0);
$table->string('admin_note', 30)->nullable();
$table->string('activate_string', 80)->nullable();
$table->string('activate_key', 8)->nullable();
$table->string('remember_token')->nullable();
$table->unique('username');
$table->index('registered');
}
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 testAddingBoolean()
{
$blueprint = new Blueprint('users');
$blueprint->boolean('foo');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table "users" add "foo" tinyint not null', $statements[0]);
}
public function testAddingBoolean()
{
$blueprint = new Blueprint('users');
$blueprint->boolean('foo');
$statements = $blueprint->toSql($this->getConnection(), $this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table users add ( foo char(1) not null )', $statements[0]);
}
/**
* @param Blueprint $table
*
* @return \Illuminate\Support\Fluent
*/
public function setDatabaseFieldType(Blueprint $table)
{
return $table->boolean($this->getDBKey());
}
