2016_05_21_224200_set_users_table_auto_increment.php
No OneTemporary
Actions

Size

737 B

Referenced Files

None

Subscribers

None

2016_05_21_224200_set_users_table_auto_increment.php
View Options

	<?php

	use Illuminate\Database\Schema\Blueprint;
	use Illuminate\Database\Migrations\Migration;

	class SetUsersTableAutoIncrement extends Migration {

	/**
	* Run the migrations.
	*
	* @return void
	*/
	public function up()
	{
	// See https://secure.phabricator.com/book/phabflavor/article/things_you_should_do_now/#start-ids-at-a-gigantic
	$sql = "ALTER TABLE users AUTO_INCREMENT = 1000000000";
	DB::unprepared($sql);
	}

	/**
	* Reverse the migrations.
	*
	* @return void
	*/
	public function down()
	{
	$maxId = (int)DB::table('users')->max('id');

	$sql = "ALTER TABLE users AUTO_INCREMENT = " . ++$maxId;
	DB::unprepared($sql);
	}

	}

Mime Type: text/x-php
Expires: Sat, Aug 8, 08:59 (1 d, 17 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3938926
Default Alt Text: 2016_05_21_224200_set_users_table_auto_increment.php (737 B)