php artisan make:migration create_admin_user_table
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateAdminUserTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('admin_user', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->increments('id');
$table->string('username',32)->comment('用户名');
$table->string('password',255)->comment('密码');
$table->string('email',32)->default('')->comment('邮箱');
$table->integer('phone')->default(0)->comment('手机');
$table->string('desc',100)->default('')->comment('描述');
$table->timestamps();
});
DB::statement("ALTER TABLE `admin_user` comment'平台:用户表'"); // 表注释
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('admin_user');
}
}
#生成表
php artisan migrate
#回滚表
php artisan migrate:rollback --step
laravel php artisan db:seed 提示 class UserTableSeeder does not exist
composer dump-autoload
https://blog.csdn.net/duanshuiliu2017/article/details/79655413
造数据
https://www.jianshu.com/p/4ad6c9239aa8
参考文献:
https://blog.csdn.net/sad1949man/article/details/78267977
https://laravel-china.org/docs/laravel/5.5/migrations/1329