Laravel Migrations的migrate与rollback

今天药忘吃喽~ 2022-04-05 08:19 158阅读 0赞

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_blog.csdn.net_duanshuiliu2017_article_details_79655413]

造数据

[https://www.jianshu.com/p/4ad6c9239aa8][https_www.jianshu.com_p_4ad6c9239aa8]

参考文献：

[https://blog.csdn.net/sad1949man/article/details/78267977][https_blog.csdn.net_sad1949man_article_details_78267977]

[https://laravel-china.org/docs/laravel/5.5/migrations/1329][https_laravel-china.org_docs_laravel_5.5_migrations_1329]

[https_blog.csdn.net_duanshuiliu2017_article_details_79655413]: https://blog.csdn.net/duanshuiliu2017/article/details/79655413
[https_www.jianshu.com_p_4ad6c9239aa8]: https://www.jianshu.com/p/4ad6c9239aa8
[https_blog.csdn.net_sad1949man_article_details_78267977]: https://blog.csdn.net/sad1949man/article/details/78267977
[https_laravel-china.org_docs_laravel_5.5_migrations_1329]: https://laravel-china.org/docs/laravel/5.5/migrations/1329