laravel 使用artisan命令新增数据库字段

cmd 命令行 到项目目录，不是public那个目录

D:\Program Files\wamp\www\Book>php artisan migrate:make add_machine_typ
e_to_books
Created Migration: 2013_09_05_104157_add_machine_type_to_books
Generating optimized class loader

migrations目录下面就会生成一个文件，在里面修改即可

文档可见：http://v3.golaravel.com/docs/database/schema.html

<?php

use Illuminate\Database\Migrations\Migration;

class AddMachineTypeToBooks extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::table('books',function($table){
			$table->integer('machine_type');
			$table->string('lan_ip',100);
			$table->string('remote_ip',100);
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::table('books',function($table){
			$table->drop_column('machine_type');
			$table->drop_column('lan_ip');
			$table->drop_column('remote_ip');
		});
	}

}

分别执行如下，就可以了

php artisan migrate:refresh

php artisan db:seed