\u4e3a\u4e86laravel \u6570\u636e\u5e93\u8fc1\u79fb migration\u4f7f\u7528<\/p>\n\n\n\n
\u6309\u7167\u67d0\u4e2amodel\u6784\u5efa mirgration<\/p>\n\n\n\n
php artisan make:migration create_flights_table --create=flights\n<\/code><\/pre>\n\n\n\n\u6309\u7167\u73b0\u6709\u7684\u6570\u636e\u5e93 dump\u4e00\u4e0b<\/p>\n\n\n\n
php artisan schema:dump\n\n\/\/ Dump the current database schema and prune all existing migrations...\nphp artisan schema:dump --prune<\/code><\/pre>\n\n\n\nmigration\u6587\u4ef6\u4f8b\u5b50<\/p>\n\n\n\n
<?php\n\nuse Illuminate\\Database\\Migrations\\Migration;\nuse Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nclass CreateFlightsTable extends Migration\n{\n \/**\n * Run the migrations.\n *\n * @return void\n *\/\n public function up()\n {\n Schema::create('flights', function (Blueprint $table) {\n $table->id();\n $table->string('name');\n $table->string('airline');\n $table->timestamps();\n });\n }\n\n \/**\n * Reverse the migrations.\n *\n * @return void\n *\/\n public function down()\n {\n Schema::drop('flights');\n }\n}<\/code><\/pre>\n\n\n\n\u6267\u884cmigration<\/p>\n\n\n\n
php artisan migrate<\/code><\/pre>\n\n\n\nscheme\u8be6\u89e3<\/p>\n\n\n\n
\u5efa\u8868<\/p>\n\n\n\n
use Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nSchema::create('users', function (Blueprint $table) {\n $table->id();\n $table->string('name');\n $table->string('email');\n $table->timestamps();\n});<\/code><\/pre>\n\n\n\n\u68c0\u67e5<\/p>\n\n\n\n
if (Schema::hasTable('users')) {\n \/\/ The \"users\" table exists...\n}\n\nif (Schema::hasColumn('users', 'email')) {\n \/\/ The \"users\" table exists and has an \"email\" column...\n}<\/code><\/pre>\n\n\n\n\u6307\u5b9a\u8fde\u63a5<\/p>\n\n\n\n
Schema::connection('sqlite')->create('users', function (Blueprint $table) {\n $table->id();\n});<\/code><\/pre>\n\n\n\n\u6307\u5b9a\u8868\u50a8\u5b58\u5f15\u64ce<\/p>\n\n\n\n
Schema::create('users', function (Blueprint $table) {\n $table->engine = 'InnoDB';\n\n \/\/ ...\n});<\/code><\/pre>\n\n\n\n\u6307\u5b9a\u5b57\u7b26\u96c6<\/p>\n\n\n\n
Schema::create('users', function (Blueprint $table) {\n $table->charset = 'utf8mb4';\n $table->collation = 'utf8mb4_unicode_ci';\n\n \/\/ ...\n});<\/code><\/pre>\n\n\n\n\u66f4\u6539\u5b57\u6bb5\uff08\u548c\u521b\u5efa\u5b57\u6bb5\u4e00\u6837\uff09<\/p>\n\n\n\n
use Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nSchema::table('users', function (Blueprint $table) {\n $table->integer('votes');\n});<\/code><\/pre>\n\n\n\n\u8868\u6539\u540d<\/p>\n\n\n\n
Schema::rename($from, $to);<\/code><\/pre>\n\n\n\n\u5220\u9664\u8868<\/p>\n\n\n\n
Schema::drop('users');\n\nSchema::dropIfExists('users');<\/code><\/pre>\n\n\n\n\u6240\u6709\u7684\u5b57\u6bb5\u7c7b\u578b<\/p>\n\n\n\n
bigIncrements<\/a> bigInteger<\/a> binary<\/a> boolean<\/a> char<\/a> dateTimeTz<\/a> dateTime<\/a> date<\/a> decimal<\/a> double<\/a> enum<\/a>float<\/a> foreignId<\/a> geometryCollection<\/a> geometry<\/a> id<\/a> increments<\/a> integer<\/a> ipAddress<\/a> json<\/a> jsonb<\/a> lineString<\/a> longText<\/a> macAddress<\/a> mediumIncrements<\/a> mediumInteger<\/a> mediumText<\/a> morphs<\/a> multiLineString<\/a> multiPoint<\/a> multiPolygon<\/a> nullableMorphs<\/a> nullableTimestamps<\/a> nullableUuidMorphs<\/a> point<\/a> polygon<\/a> rememberToken<\/a> set<\/a> smallIncrements<\/a> smallInteger<\/a> softDeletesTz<\/a> softDeletes<\/a> string<\/a>text<\/a> timeTz<\/a> time<\/a> timestampTz<\/a> timestamp<\/a> timestampsTz<\/a> timestamps<\/a>tinyIncrements<\/a> tinyInteger<\/a> unsignedBigInteger<\/a> unsignedDecimal<\/a> unsignedInteger<\/a> unsignedMediumInteger<\/a> unsignedSmallInteger<\/a> unsignedTinyInteger<\/a> uuidMorphs<\/a> uuid<\/a> year<\/a><\/p>\n\n\n\n\u66f4\u6539\u5b57\u6bb5<\/p>\n\n\n\n
Schema::table('users', function (Blueprint $table) {\n $table->string('name', 50)->change();\n});<\/code><\/pre>\n\n\n\n\u5b57\u6bb5\u6539\u540d<\/p>\n\n\n\n
Schema::table('users', function (Blueprint $table) {\n $table->renameColumn('from', 'to');\n});<\/code><\/pre>\n\n\n\n\u820d\u5f03\u5b57\u6bb5<\/p>\n\n\n\n
Schema::table('users', function (Blueprint $table) {\n $table->dropColumn('votes');\n});\n\nSchema::table('users', function (Blueprint $table) {\r\n $table->dropColumn(['votes', 'avatar', 'location']);\r\n});<\/code><\/pre>\n\n\n\nCommand<\/th> Description<\/th><\/tr><\/thead> $table->dropMorphs('morphable');<\/code><\/td>Drop the morphable_id<\/code> and morphable_type<\/code> columns.<\/td><\/tr>$table->dropRememberToken();<\/code><\/td>Drop the remember_token<\/code> column.<\/td><\/tr>$table->dropSoftDeletes();<\/code><\/td>Drop the deleted_at<\/code> column.<\/td><\/tr>$table->dropSoftDeletesTz();<\/code><\/td>Alias of dropSoftDeletes()<\/code> method.<\/td><\/tr>$table->dropTimestamps();<\/code><\/td>Drop the created_at<\/code> and updated_at<\/code> columns.<\/td><\/tr>$table->dropTimestampsTz();<\/code><\/td>Alias of dropTimestamps()<\/code> method.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\u7d22\u5f15\u7ea6\u675f<\/p>\n\n\n\n
use Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nSchema::table('users', function (Blueprint $table) {\n $table->string('email')->unique();\n});\n\n$table->unique('email');\r\n\n$table->index(['account_id', 'created_at']);\r\n\n$table->unique('email', 'unique_email');\r\n<\/code><\/pre>\n\n\n\nCommand<\/th> Description<\/th><\/tr><\/thead> $table->primary('id');<\/code><\/td>Adds a primary key.<\/td><\/tr> $table->primary(['id', 'parent_id']);<\/code><\/td>Adds composite keys.<\/td><\/tr> $table->unique('email');<\/code><\/td>Adds a unique index.<\/td><\/tr> $table->index('state');<\/code><\/td>Adds an index.<\/td><\/tr> $table->spatialIndex('location');<\/code><\/td>Adds a spatial index (except SQLite).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\u66f4\u6539\u7d22\u5f15<\/p>\n\n\n\n
$table->renameIndex('from', 'to')<\/code><\/pre>\n\n\n\n\u5220\u9664\u7d22\u5f15\uff08\u7ea6\u675f\uff09<\/p>\n\n\n\nCommand<\/th> Description<\/th><\/tr><\/thead> $table->dropPrimary('users_id_primary');<\/code><\/td>Drop a primary key from the “users” table.<\/td><\/tr> $table->dropUnique('users_email_unique');<\/code><\/td>Drop a unique index from the “users” table.<\/td><\/tr> $table->dropIndex('geo_state_index');<\/code><\/td>Drop a basic index from the “geo” table.<\/td><\/tr> $table->dropSpatialIndex('geo_location_spatialindex');<\/code><\/td>Drop a spatial index from the “geo” table (except SQLite).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\u5916\u952e\u7ea6\u675f<\/p>\n\n\n\n
use Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nSchema::table('posts', function (Blueprint $table) {\n $table->unsignedBigInteger('user_id');\n\n $table->foreign('user_id')->references('id')->on('users');\n});\n\n\/\/\u81ea\u52a8\u63a8\u6d4b\nSchema::table('posts', function (Blueprint $table) {\r\n $table->foreignId('user_id')->constrained();\r\n});\n\nSchema::table('posts', function (Blueprint $table) {\r\n $table->foreignId('user_id')->constrained('users');\r\n});<\/code><\/pre>\n\n\n\n\u5916\u952e\u7ea7\u8054<\/p>\n\n\n\n
$table->foreignId('user_id')\n ->constrained()\n ->onUpdate('cascade')\n ->onDelete('cascade');<\/code><\/pre>\n\n\n\n\u5220\u9664\u5916\u952e<\/p>\n\n\n\n
$table->dropForeign(['user_id']);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u4e3a\u4e86laravel \u6570\u636e\u5e93\u8fc1\u79fb migration\u4f7f\u7528 \u6309\u7167\u67d0\u4e2amodel\u6784\u5efa mirgration \u6309\u7167\u73b0\u6709\u7684\u6570\u636e\u5e93 dump\u4e00\u4e0b migration\u6587\u4ef6\u4f8b\u5b50 \u6267\u884cmigration scheme\u8be6\u89e3 \u5efa\u8868 \u68c0\u67e5 \u6307\u5b9a\u8fde\u63a5 \u6307\u5b9a\u8868\u50a8\u5b58\u5f15\u64ce \u6307\u5b9a\u5b57\u7b26\u96c6 \u66f4\u6539\u5b57\u6bb5\uff08\u548c\u521b\u5efa\u5b57\u6bb5\u4e00\u6837\uff09 \u8868\u6539\u540d \u5220\u9664\u8868 \u6240\u6709\u7684\u5b57\u6bb5\u7c7b\u578b bigIncrements bigInteger binary boolean char dateTimeTz dateTime date decimal double enumfloat foreignId geometryCollection geometry id increments integer ipAddress json jsonb lineString longText macAddress mediumIncrements mediumInteger mediumText morphs multiLineString multiPoint multiPolygon nullableMorphs nullableTimestamps nullableUuidMorphs point polygon rememberToken […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[31,10,34],"_links":{"self":[{"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/posts\/270"}],"collection":[{"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robinluo.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=270"}],"version-history":[{"count":10,"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":280,"href":"https:\/\/robinluo.top\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions\/280"}],"wp:attachment":[{"href":"https:\/\/robinluo.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robinluo.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robinluo.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}