/**
* 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');
});
}