/**
* Activates the table.
*
* @param \Illuminate\Database\Schema\Blueprint $table
*/
public function activate(Blueprint $table)
{
$table->increments('id');
$table->string('title');
$table->string('slug');
$table->enum('type', ['PROFILE', 'SHARE'])->default('PROFILE');
}
/**
* 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');
}
public static function _schema_locationTrait(Blueprint $table)
{
$table->string('longitude')->nullable();
$table->string('latitude')->nullable();
$table->string('location_precision')->nullable();
$table->string('location_title')->nullable();
return $table;
}
/**
* Activates the table.
*
* @param \Illuminate\Database\Schema\Blueprint $table
*/
public function activate(Blueprint $table)
{
$table->increments('id');
$table->string('title');
$table->string('handle');
$table->string('url');
$table->integer('set_id');
}
/**
* @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;
}
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();
}
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_imageModel(Blueprint $table)
{
$table->string('image');
$table->string('url');
$table->unsignedInteger('order')->default(0);
$table->string('type')->default('default');
$table->integer('width');
$table->integer('height');
$table->morphs('imageable');
return $table;
}
public static function _schema_UserModel(Blueprint $table)
{
$table->string('email')->nullable()->label('邮箱');
$table->string('mobile')->nullable()->label('手机号码');
$table->string('username')->nullable()->label('姓名');
$table->string('nickname')->nullable()->label('昵称');
$table->enum('gender', ['未填' => '未填', '男' => '男', '女' => '女'])->default('未填')->label('性别');
$table->string('avatar')->nullable()->label('头像');
$table->date('birthday')->nullable()->label('生日');
return $table;
}
protected function create(Blueprint $table)
{
$table->create();
$table->string('id', 40);
$table->integer('user_id')->unsigned()->default(1);
$table->integer('created')->unsigned()->default(0);
$table->integer('last_activity')->unsigned()->default(0);
$table->string('last_ip', 200)->default('0.0.0.0');
$table->text('payload');
$table->primary('id');
$table->index('user_id');
}
/**
* Give me the tools and I will tell you what my schema is...
*
* @param Blueprint $table The blueprint for the database table.
* @return Blueprint The designed database table schema.
*/
public static function describeSchema(Blueprint $table)
{
$table->increments('id');
$table->string('uuid', 36);
$table->integer('playhead')->unsigned();
$table->text('metadata');
$table->text('payload');
$table->string('recorded_on', 32);
$table->text('type');
$table->unique(['uuid', 'playhead']);
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;
}
/**
* @param Blueprint $table
* @return Blueprint
*/
public static function _schema_chinaArea(Blueprint $table)
{
$table->integer('areano');
$table->integer('parentno');
$table->string('name');
$table->string('province')->nullable();
$table->string('city')->nuallable();
$table->string('distinct')->nullable();
$table->enum('flag', ['国家', '省', '市', '区/县']);
$table->integer('sort')->default(99);
$table->integer('zipcode')->default(0);
return $table;
}
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->string('title', 50)->default('');
$table->integer('parent_group_id')->unsigned()->nullable();
}
protected function create(Blueprint $table)
{
$table->create();
$table->string('conf_name', 255)->default('');
$table->text('conf_value')->nullable();
$table->primary('conf_name');
}
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']);
}
public static function _schema_tagModel(\Illuminate\Database\Schema\Blueprint $table)
{
$table->text('name')->nullable();
$table->string('type')->default('default');
$table->morphs('taggable');
return $table;
}
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->string('category_slug', 100)->nullable()->index();
$table->string('title');
$table->string('poster', 200)->default('');
$table->integer('posted')->unsigned()->default(0);
$table->integer('first_post_id')->unsigned()->default(0);
$table->integer('last_post')->unsigned()->default(0);
$table->integer('last_post_id')->unsigned()->default(0);
$table->string('last_poster', 200)->nullable();
$table->integer('num_views')->unsigned()->default(0);
$table->integer('num_replies')->unsigned()->default(0);
$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();
}
/**
* 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();
}
}
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->integer('group_id')->unsigned();
$table->string('name', 50);
$table->boolean('value');
}
/**
* Create the table schema.
*
* @param Blueprint $table
*
* @return mixed
*/
protected function create(Blueprint $table)
{
$table->increments('id');
$table->unsignedInteger('job_id');
$table->string('name');
$table->unique(['job_id', 'name']);
$table->timestamps();
}
/**
* Create the table schema.
*
* @param Blueprint $table
*
* @return mixed
*/
protected function create(Blueprint $table)
{
$table->increments('id');
$table->text('public_id');
$table->text('secret_key');
$table->string('type');
$table->text('data');
$table->timestamps();
}
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();
}
/**
* Add the field type column.
*
* @param Blueprint $table
* @param AssignmentInterface $assignment
*/
public function addColumn(Blueprint $table, AssignmentInterface $assignment)
{
// Skip if the column already exists.
if ($this->schema->hasColumn($table->getTable(), $this->fieldType->getColumnName() . '_id')) {
return;
}
$table->string($this->fieldType->getColumnName() . '_type')->nullable(!$assignment->isRequired());
$table->integer($this->fieldType->getColumnName() . '_id')->nullable(!$assignment->isRequired());
if ($assignment->isUnique() && $assignment->isTranslatable()) {
$table->unique([$this->fieldType->getColumnName() . '_type', $this->fieldType->getColumnName() . '_id']);
}
}
/**
* @param Blueprint $table table
* @return Blueprint
*/
private function setColumns(Blueprint $table)
{
$table->string('parentId', 255)->default('');
$table->string('instanceId', 255)->default('');
$table->string('type', 255)->default('');
// users
$table->string('userType', '16')->default('normal');
$table->string('userId', 255);
$table->string('writer', 255);
$table->string('email')->nullable();
// 비회원 작성일때 email 받기?
$table->string('certifyKey', 255);
// nonmember document's password
// count
$table->integer('readCount')->default(0);
$table->integer('commentCount')->default(0);
$table->integer('assentCount')->default(0);
$table->integer('dissentCount')->default(0);
// display contents config values
$table->integer('approved')->default(Document::APPROVED_APPROVED);
$table->integer('published')->default(Document::PUBLISHED_PUBLISHED);
$table->integer('status')->default(Document::STATUS_PUBLIC);
$table->integer('display')->default(Document::DISPLAY_VISIBLE);
$table->integer('format')->default(Document::FORMAT_HTML);
// search
$table->string('locale', 255)->default('');
$table->string('title', 255);
$table->text('content');
$table->text('pureContent');
$table->timestamp('createdAt');
$table->timestamp('updatedAt');
$table->timestamp('publishedAt')->nullable();
$table->timestamp('deletedAt')->nullable();
$table->string('head', 50);
$table->string('reply', 200);
$table->string('ipaddress', 16);
$table->index('createdAt');
$table->unique(['head', 'reply']);
return $table;
}
public static function _schema_usermodel(\Illuminate\Database\Schema\Blueprint $table)
{
$table->string('username', 100);
$table->string('nickname', 30)->unique();
$table->string('email', 100);
$table->string('mobile', 20);
$table->integer('exp')->default(0);
$table->integer('points')->default(0);
$table->date('birthdate')->nullable();
$table->enum('gender', ['男', '女', '保密'])->default('保密');
$table->string('password', 100);
$table->string('remember_token', 100);
$table->timestamp('last_login');
return $table;
}
/**
* Campo LISTA.
*/
public function options($column)
{
$col = parent::string($column, 5);
$col->nullable(true);
return $col;
}
public function testAddingString()
{
$blueprint = new Blueprint('users');
$blueprint->string('foo');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table "users" add "foo" nvarchar(255) not null', $statements[0]);
$blueprint = new Blueprint('users');
$blueprint->string('foo', 100);
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table "users" add "foo" nvarchar(100) not null', $statements[0]);
$blueprint = new Blueprint('users');
$blueprint->string('foo', 100)->nullable()->default('bar');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table "users" add "foo" nvarchar(100) null default \'bar\'', $statements[0]);
}
/**
* @param Blueprint $table
*
* @return \Illuminate\Support\Fluent
*/
public function setDatabaseFieldType(Blueprint $table)
{
return $table->string($this->getDBKey(), 255);
}
