/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::create('assinaturasComerciantes', function (Blueprint $table) {
$table->increments('id')->unsigned();
$table->integer('idComerciante')->unsigned();
$table->integer('idAssinatura')->unsigned();
$table->timestamps();
});
Schema::table('assinaturasComerciantes', function ($table) {
$table->foreign('idComerciante')->references('id')->on('comerciantes');
$table->foreign('idAssinatura')->references('id')->on('assinaturas');
});
//voltar os dados para a tabela antiga
$assi = Assinatura::all()->toArray();
foreach ($assi as $single) {
$assinaCom = AssinaturaComerciante::create(['idAssinatura' => $single['id'], 'idComerciante' => $single['idComerciante']]);
$assinaCom->save();
}
Schema::table('assinaturas', function (Blueprint $table) {
$table->dropColumn('idComerciante');
});
}
