创建表
项目根目录 cmd
php artisan make:migration create_articles_talbe --create=articles
create_articles_talbe 在database/migrations下生成的文件名
articles 数据库的表名
编辑内容如下
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateArticlesTalbe extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('articles', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->string('content');
$table->string('tel')->change();
$table->timestamp("publish");
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('articles');
}
}
命令行
php artisan migrate
即可在数据库中生成database/migrations目录下对应的表、
修改表结构
项目上线后 需修改表结构
重新生成一个文件 如:
E:\Laravel\blog>php artisan make:migration alert_articles_talbe --table=articles
内容如下
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AlertArticlesTalbe extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('articles', function (Blueprint $table) {
//
$table->string("intro");
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('articles', function (Blueprint $table) {
//
$table->dropColumn("intro");
});
}
}
删除表
次的操作,上步migrate 创建表这次及删除
php artisan migrate:rollback
php artisan migrate:reset
填充测试数据
database/seeds
php artisan db:seed --class=UserTableSeeder
php artisan db:seed