今天台南颱風假~
可以將前面幾篇再優化一下
Migration資料庫的變動要跟所有人說時,快速建立資料庫在正式區
可以參考:https://ithelp.ithome.com.tw/articles/10243718
先增加資料庫laravel_demo按存檔
laravel_demo
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;程式碼
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateProducts extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('products');
}
}
加入欄位
填入:
在terminal打入php artisan migrate
顯示
到資料庫 重新整理>看
按 把手 顯示 datatype
購物車網站的架構
建立購物車的資料庫
php artisan make:migration create_carts_and_cart_items
顯示
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCartsAndCartItems extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('carts_and_cart_items', function (Blueprint $table) {
$table->id();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('carts_and_cart_items');
}
}
變成carts跟cart_items兩個表格
大家明天見