/** * Run the migrations. * * @return void */ public function up() { Schema::create('drinks', function (Blueprint $table) { $table->increments('id'); // auto increment $table->string('name',75)->unique(); // 75 = length of the field, unique $table->text('comments')->nullable(); // nullable = accept null values $table->integer('rating'); // integer $table->date('brew_date'); // date $table->timestamps(); // automatically create two time stamp }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('drinks'); } }
class MakeGenderNullInEmployees extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('employees', function (Blueprint $table) { $table->string('gender', 5)->nullable()->change(); }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('employees', function (Blueprint $table) { $table->string('gender', 5)->change(); }); } }
class Depts extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('depts', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->timestamps(); }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('depts'); } }
class AddDeptIdInEmployees extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('employees', function (Blueprint $table) { $table->unsignedInteger ('dept_id')->nullable()->after('gender'); $table->foreign('dept_id')->references('id')->on('depts')->onDelete('cascade'); }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('employees', function (Blueprint $table) { $table->dropColumn('dept_id'); }); } }
執行php artisan migrate
輸入php artisan make:seeder DrinksTableSeeder
打開database\seeds\DrinksTableSeeder.php修改為
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
class DrinksTableSeeder extends Seeder {
/** * Run the database seeds. * * @return void */ public function run() { DB::table('drinks')->insert([ 'name' => 'Vodka', 'comments' => 'Blood of creativity', 'rating' => 9, 'brew_date' => '1973-09-03', ]); } }
執行php artisan db:seed --class=DrinksTableSeeder
資料表drinks會增加一個資料
1 2
id name comments rating brew_date created_at updated_at 1 Vodka Blood of creativity 9 1973-09-03 NULL NULL
以下欄位所有資料表都要有 S/N FIELD DATA TYPE DESCRIPTION 1 created_at Timestamp Timestamp when record was created 2 updated_at Timestamp Timestamp when record was last updated 3 created_at_ip Varchar(45) IP address used to create the record 4 updated_at_ip Varchar(45) IP address used to last update record
// Posts Table S/N FIELD DATA TYPE DESCRIPTION 1 id INT Primary key (AUTOINCREMENT) 2 url Varchar(255) Page URL 3 title Varchar(140) Page title 4 description Varchar(170) Description that shows in search engine results 5 content Text The content of the page or blog post 6 blog Tinyint(1) Determines if a post is a page is blog
// Products Table S/N FIELD DATA TYPE DESCRIPTION 1 id INT Primary key (AUTOINCREMENT) 2 name Varchar(255) Product name 3 title Varchar(140) Product title 4 description Varchar(500) Product description 5 price int Product price 6 category_id int Product category id 7 brand_id int Product brand id
// Categories Table S/N FIELD DATA TYPE DESCRIPTION 1 id int Primary key (AUTOINCREMENT) 2 name Varchar(255) Category name
// Brands Table S/N FIELD DATA TYPE DESCRIPTION 1 id int Primary key (AUTOINCREMENT) 2 name Varchar(255) Brand name
class ProductsTableSeeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { DB::table('products')->insert(['name' => 'Mini skirt black edition', 'title' => 'Mini skirt black edition','description' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna','price' => 35,'category_id' => 1,'brand_id' => 1,]); DB::table('products')->insert(['name' => 'T-shirt blue edition', 'title' => 'T-shirt blue edition','description' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna','price' => 64,'category_id' => 2,'brand_id' => 3,]); DB::table('products')->insert(['name' => 'Sleeveless Colorblock Scuba', 'title' => 'Sleeveless Colorblock Scuba','description' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna','price' => 13,'category_id' => 3,'brand_id' => 2,]); } }
2.CategoriesTableSeeder.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
class CategoriesTableSeeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { DB::table('categories')->insert(['name' => 'MENS']); DB::table('categories')->insert(['name' => 'WOMENS']); DB::table('categories')->insert(['name' => 'KIDS']); DB::table('categories')->insert(['name' => 'FASHION']); DB::table('categories')->insert(['name' => 'CLOTHING']); } }
3.BrandsTableSeeder.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14
class BrandsTableSeeder extends Seeder {
/** * Run the database seeds. * * @return void */ public function run() { DB::table('brands')->insert(['name' => 'ACNE']); DB::table('brands')->insert(['name' => 'RONHILL']); DB::table('brands')->insert(['name' => 'ALBIRO']); DB::table('brands')->insert(['name' => 'ODDMOLLY']); } }
