1. Mula-mula gunakan artisan untuk mencipta templat jadual data boleh dipindahkan Selepas menjalankan arahan ini, ia akan berada dalam pangkalan data/. direktori migrasi. Hasilkan fail
php artisan make:migration create_fees_count_table --create=fees_count
2. Fail yang dijana mengandungi dua kaedah, atas dan bawah mengandungi perihalan menambah jadual, menambah lajur, menambah indeks, dan lain-lain, dan ke bawah adalah agak mudah. iaitu Padam jadual, sudah tentu terdapat beberapa logik lain di dalamnya
3. Buat nota tentang jenis lajur jadual data yang disokong di atas dan jangan terjemahkannya buat masa ini
| Command | Description |
|---|---|
| $table->bigIncrements('id'); | Incrementing ID (primary key) using a "UNSIGNED BIG INTEGER" equivalent. |
| $table->bigInteger('votes'); | BIGINT equivalent for the database. |
| $table->binary('data'); | BLOB equivalent for the database. |
| $table->boolean('confirmed'); | BOOLEAN equivalent for the database. |
| $table->char('name', 4); | CHAR equivalent with a length. |
| $table->date('created_at'); | DATE equivalent for the database. |
| $table->dateTime('created_at'); | DATETIME equivalent for the database. |
| $table->decimal('amount', 5, 2); | DECIMAL equivalent with a precision and scale. |
| $table->double('column', 15, 8); | DOUBLE equivalent with precision, 15 digits in total and 8 after the decimal point. |
| $table->enum('choices', ['foo', 'bar']); | ENUM equivalent for the database. |
| $table->float('amount'); | FLOAT equivalent for the database. |
| $table->increments('id'); | Incrementing ID (primary key) using a "UNSIGNED INTEGER" equivalent. |
| $table->integer('votes'); | INTEGER equivalent for the database. |
| $table->json('options'); | JSON equivalent for the database. |
| $table->jsonb('options'); | JSONB equivalent for the database. |
| $table->longText('description'); | LONGTEXT equivalent for the database. |
| $table->mediumInteger('numbers'); | MEDIUMINT equivalent for the database. |
| $table->mediumText('description'); | MEDIUMTEXT equivalent for the database. |
| $table->morphs('taggable'); | Adds INTEGER taggable_id and STRING taggable_type. |
| $table->nullableTimestamps(); | Same as timestamps(), except allows NULLs. |
| $table->rememberToken(); | Adds remember_token as VARCHAR(100) NULL. |
| $table->smallInteger('votes'); | SMALLINT equivalent for the database. |
| $table->softDeletes(); | Adds deleted_at column for soft deletes. |
| $table->string('email'); | VARCHAR equivalent column. |
| $table->string('name', 100); | VARCHAR equivalent with a length. |
| $table->text('description'); | TEXT equivalent for the database. |
| $table->time('sunrise'); | TIME equivalent for the database. |
| $table->tinyInteger('numbers'); | TINYINT equivalent for the database. |
| $table->timestamp('added_on'); | TIMESTAMP equivalent for the database. |
| $table->timestamps(); | Adds created_at and updated_at columns. |
| $table->uuid('id'); | UUID equivalent for the database. |
4. Pembuatan jadual selesai Selepas itu, laksanakannya secara langsung Memandangkan saya tidak menggunakan php artisan migrate sebelum mencipta banyak jadual, menjalankan arahan ini secara langsung menghasilkan gesaan bahawa beberapa jadual telah wujud ke direktori tmp di bawah pangkalan data dan tambah --path ' database/tmp', dan operasi berjaya sekali lagi
php artisan migrate
5. Perhatikan dalam pangkalan data dan dapatkan jadual telah dibuat!
