本文整理汇总了PHP中Illuminate\Database\Schema\Blueprint::create方法的典型用法代码示例。如果您正苦于以下问题:PHP Blueprint::create方法的具体用法?PHP Blueprint::create怎么用?PHP Blueprint::create使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Illuminate\Database\Schema\Blueprint
的用法示例。
在下文中一共展示了Blueprint::create方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: create
protected function create(Blueprint $table)
{
$table->create();
$table->integer('user_id')->unsigned();
$table->integer('topic_id')->unsigned();
$table->primary(array('user_id', 'topic_id'));
}
示例2: create
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->string('title', 50)->default('');
$table->integer('parent_group_id')->unsigned()->nullable();
}
示例3: create
protected function create(Blueprint $table)
{
$table->create();
$table->string('conf_name', 255)->default('');
$table->text('conf_value')->nullable();
$table->primary('conf_name');
}
示例4: create
protected function create(Blueprint $table)
{
$table->create();
$table->increments('id');
$table->integer('group_id')->unsigned();
$table->string('name', 50);
$table->boolean('value');
}
示例5: create
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();
}
示例6: table
/**
*
* @param sting $table
* @return $this
*/
public function table($table)
{
$this->table = $table;
$this->blueprint = new Blueprint($table);
if (!Schema::hasTable($table)) {
$this->blueprint->create();
$this->blueprint->increments('id');
}
return $this;
}
示例7: create
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'));
}
示例8: testBasicCreateTableWithPrefix
public function testBasicCreateTableWithPrefix()
{
$blueprint = new Blueprint('users');
$blueprint->create();
$blueprint->increments('id');
$blueprint->string('email');
$grammar = $this->getGrammar();
$grammar->setTablePrefix('prefix_');
$statements = $blueprint->toSql($grammar);
$this->assertEquals(1, count($statements));
$this->assertEquals('create table `prefix_users` (`id` int not null auto_increment primary key, `email` varchar(255) not null)', $statements[0]);
}
示例9: create
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');
}
示例10: testBasicCreateTable
public function testBasicCreateTable()
{
$blueprint = new Blueprint('users');
$blueprint->create();
$blueprint->increments('id');
$blueprint->string('email');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('create table "users" ("id" int identity primary key not null, "email" nvarchar(255) not null)', $statements[0]);
$blueprint = new Blueprint('users');
$blueprint->increments('id');
$blueprint->string('email');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('alter table "users" add "id" int identity primary key not null, add "email" nvarchar(255) not null', $statements[0]);
}
示例11: create
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']);
}
示例12: create
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();
}
示例13: create
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');
}
示例14: testBasicSelectNotUsingQuotes
public function testBasicSelectNotUsingQuotes()
{
$blueprint = new Blueprint('users');
$blueprint->create();
$blueprint->increments('id');
$blueprint->string('email');
$conn = $this->getConnection();
$statements = $blueprint->toSql($conn, $this->getGrammar(false));
$this->assertEquals(1, count($statements));
$this->assertEquals('create table users ( id number(10,0) not null, email varchar2(255) not null, constraint users_id_primary primary key ( id ) )', $statements[0]);
}
示例15: testAddingForeignKey
public function testAddingForeignKey()
{
$blueprint = new Blueprint('users');
$blueprint->create();
$blueprint->string('foo')->primary();
$blueprint->string('order_id');
$blueprint->foreign('order_id')->references('id')->on('orders');
$statements = $blueprint->toSql($this->getGrammar());
$this->assertEquals(1, count($statements));
$this->assertEquals('create table "users" ("foo" varchar not null, "order_id" varchar not null, foreign key("order_id") references "orders"("id"), primary key ("foo"))', $statements[0]);
}