PHP Schema::table Examples

PHP Schema::table - 30 examples found. These are the top rated real world PHP examples of Schema::table extracted from open source projects. You can rate examples to help us improve the quality of examples.

table() public static method

Modify a table on the schema.
public static table ( string $table, Closure $callback ) : Illuminate\Database\Schema\Blueprint
$table string
$callback Closure
return Illuminate\Database\Schema\Blueprint
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('pages_closure', function (Blueprint $table) {
         $table->dropForeign('FK_pages_closure_pages');
         $table->dropForeign('FK_pages_closure_pages_2');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('bookings', function ($table) {
         $table->dropColumn('book_from');
         $table->dropColumn('book_to');
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('activity_logs', function (Blueprint $table) {
         $table->increments('id');
         $table->integer(Config::get('activity-log-saas::key'));
         $table->integer('user_id');
         $table->integer('content_id');
         $table->string('content_type', 72);
         $table->string('action', 32);
         $table->string('description');
         $table->text('details');
         $table->boolean('developer');
         $table->string('ip_address', 64);
         $table->string('user_agent');
         $table->timestamps();
     });
     Schema::table('activity_logs', function ($table) {
         // We'll need to ensure that MySQL uses the InnoDB engine to
         // support the indexes, other engines aren't affected.
         $table->engine = 'InnoDB';
         // Useful for filters
         $table->index('user_id');
         $table->index('content_id');
         $table->index('content_type');
         $table->index('action');
     });
 }
 public function down()
 {
     Schema::table('posts', function (Blueprint $table) {
         $table->dropForeign('posts_user_id_foreign');
     });
     Schema::drop('posts');
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('aluminis', function (Blueprint $table) {
         $table->dropForeign('aluminis_department_id_foreign');
         $table->dropColumn('department_id');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('auditoriums', function (Blueprint $table) {
         $table->renameColumn('address', 'direction');
         $table->renameColumn('special_cost', 'especial_cost');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('reg_vocabulary_has_version', function (Blueprint $table) {
         $table->dropForeign('reg_vocabulary_has_version_ibfk_1');
         $table->dropForeign('reg_vocabulary_has_version_ibfk_2');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::drop('professions');
     Schema::table('profiles', function (Blueprint $table) {
         $table->dropColumn('profession_id');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     //
     Schema::table('users', function (Blueprint $table) {
         $table->dropColumn('is_admin');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('users', function (Blueprint $table) {
         //
         $table->drop();
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table("sprites", function ($table) {
         $table->dropIndex("search");
     });
     Schema::drop("sprites");
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('users', function ($table) {
         //-- Custom Column Name
         Schema::drop('users');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('planes_cobertura', function (Blueprint $table) {
         $table->dropColumn('updated_at');
         $table->dropColumn('created_at');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table($this->authenticationProvidersTable, function (Blueprint $table) {
         $table->dropForeign('oauth_identities_user_id_foreign');
     });
     Schema::drop($this->authenticationProvidersTable);
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('interview', function (Blueprint $t) {
         $t->dropForeign('location_id');
         $t->dropColumn('location_id');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('users', function (Blueprint $table) {
         //
         $table->dropColumn('soft_deleted');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('project_tasks', function (Blueprint $table) {
         $table->date('start_date')->unsigned()->change();
         $table->date('due_date')->unsigned()->change();
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('bids', function (Blueprint $table) {
         $table->dropForeign('bids_contract_type_id_foreign');
     });
     Schema::drop('contract_type');
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('users', function (Blueprint $table) {
         $table->dropColumn('oauth_flg');
         $table->dropColumn('oauth_id');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('admins', function ($table) {
         $table->dropColumn('email');
         $table->dropColumn('password');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('rss', function (Blueprint $table) {
         $table->dropForeign('fk_rss_1');
         $table->dropForeign('rss_ibfk_1');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('users', function (Blueprint $table) {
         $table->dropColumn('phone');
         $table->dropColumn('facebook');
     });
 }
 public function down()
 {
     Schema::table('partido_goles', function (Blueprint $table) {
         $table->foreign('gol_autor')->references('pju_id')->on('partido_jugadores')->onDelete('restrict');
         $table->foreign('gol_asistencia')->references('pju_id')->on('partido_jugadores')->onDelete('restrict');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('stack_actions', function (Blueprint $table) {
         $table->dropForeign('stack_actions_tier_id_foreign');
         $table->dropColumn('tier_id');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('tags', function ($t) {
         $t->dropColumn('forum');
         $t->dropColumn('articles');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('musics', function (Blueprint $table) {
         $table->dropColumn('section_duration');
         $table->dropColumn('track');
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     //
     Schema::table('landing', function (Blueprint $table) {
         $table->integer('class_number')->default(1);
     });
 }
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::table('menus', function (Blueprint $table) {
         $table->foreign('page_id')->references('id')->on('pages')->onDelete('cascade');
         $table->unique(['page_id', 'id']);
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('tests', function (Blueprint $table) {
         //
         $table->dropColumn('time');
     });
 }
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('tasks', function (Blueprint $table) {
         $table->dropColumn('list_id');
         $table->dropForeign('tasks_list_id_foreign');
     });
 }